summaryrefslogtreecommitdiff
path: root/mysql-test/t/ndb_index.test
diff options
context:
space:
mode:
authorunknown <magnus@neptunus.(none)>2004-05-11 10:40:48 +0200
committerunknown <magnus@neptunus.(none)>2004-05-11 10:40:48 +0200
commitcc7353f58b257e9b499212947d9f24b5484dcbaf (patch)
tree71248616c5d0727c46bb959a55fbb4df21eb202c /mysql-test/t/ndb_index.test
parent5b92b23bbf77f8984c9e1309f516bb6820b9cbce (diff)
downloadmariadb-git-cc7353f58b257e9b499212947d9f24b5484dcbaf.tar.gz
Updated ndb_* test cases
Added two new, ndb_replace and ndb_minmax mysql-test/r/ndb_index.result: Disable query, since index used is case sensitive mysql-test/r/ndb_index_ordered.result: Correct faulty CREATE TABLE statement mysql-test/r/ndb_index_unique.result: Correct faulty CREATE TABLE statement mysql-test/t/ndb_index.test: Disable query, since index used is case sensitive mysql-test/t/ndb_index_ordered.test: Correct faulty CREATE TABLE statement mysql-test/t/ndb_index_unique.test: Correct faulty CREATE TABLE statement
Diffstat (limited to 'mysql-test/t/ndb_index.test')
-rw-r--r--mysql-test/t/ndb_index.test7
1 files changed, 5 insertions, 2 deletions
diff --git a/mysql-test/t/ndb_index.test b/mysql-test/t/ndb_index.test
index a4a4b92a66b..d3977dc3ea4 100644
--- a/mysql-test/t/ndb_index.test
+++ b/mysql-test/t/ndb_index.test
@@ -42,8 +42,11 @@ select port, accessnode, pop, accesstype from t1 where pop='pop98';
select port, accessnode, pop, accesstype from t1 where pop='pop98';
select port, accessnode, pop, accesstype from t1 where pop='pop98';
select port, accessnode, pop, accesstype from t1 where pop='pop98' order by accesstype;
-select port, accessnode, pop, accesstype from t1 where pop='POP98';
-select port, accessnode, pop, accesstype from t1 where pop='POP98' order by accesstype;
+# The following two querys will not return any rows since
+# the index used for access is case sensitive
+# They are thus disabled for now
+#select port, accessnode, pop, accesstype from t1 where pop='POP98';
+#select port, accessnode, pop, accesstype from t1 where pop='POP98' order by accesstype;
select port, accessnode, pop, accesstype from t1 where pop='foo';
# Test select using accesstype