From 22f0e4d9aa119a95f924495f820e4e7fd7233361 Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 20 Oct 2004 12:56:49 +0200 Subject: the test moved from range.test to innodb.test - it should not be run when innodb is disabled --- mysql-test/r/range.result | 35 ----------------------------------- 1 file changed, 35 deletions(-) (limited to 'mysql-test/r/range.result') diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index 4c6caf2d23b..f0f5cef30a0 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -537,38 +537,3 @@ select count(*) from t2 where x = 18446744073709551601; count(*) 0 drop table t1; -create table t1 (x bigint unsigned not null primary key) engine=innodb; -insert into t1(x) values (0xfffffffffffffff0),(0xfffffffffffffff1); -select * from t1; -x -18446744073709551600 -18446744073709551601 -select count(*) from t1 where x>0; -count(*) -2 -select count(*) from t1 where x=0; -count(*) -0 -select count(*) from t1 where x<0; -count(*) -0 -select count(*) from t1 where x < -16; -count(*) -0 -select count(*) from t1 where x = -16; -count(*) -0 -explain select count(*) from t1 where x > -16; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index PRIMARY PRIMARY 8 NULL 2 Using where; Using index -select count(*) from t1 where x > -16; -count(*) -2 -select * from t1 where x > -16; -x -18446744073709551600 -18446744073709551601 -select count(*) from t1 where x = 18446744073709551601; -count(*) -1 -drop table t1; -- cgit v1.2.1