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
commit2b1e7075f797184eb7215c40b62d32db79a41b7e (patch)
tree71248616c5d0727c46bb959a55fbb4df21eb202c /mysql-test/t/ndb_index.test
parent032ac6ce2e3b270f3778d07d69ded6e050a48b29 (diff)
downloadmariadb-git-2b1e7075f797184eb7215c40b62d32db79a41b7e.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