summaryrefslogtreecommitdiff
path: root/mysql-test/r/range.result
diff options
context:
space:
mode:
authorigor@rurik.mysql.com <>2004-10-20 13:17:06 -0700
committerigor@rurik.mysql.com <>2004-10-20 13:17:06 -0700
commitf0bc019c868ddaf97e734e0059192fbf03ca0271 (patch)
tree76e9b0c642d788fcfffa799cf27f3c2e61bb900a /mysql-test/r/range.result
parentf64d88a9f31ad319b25f710acdfb405325ba3fc6 (diff)
parent7f884c1f346fd536e0d481f814e044023a448ef4 (diff)
downloadmariadb-git-f0bc019c868ddaf97e734e0059192fbf03ca0271.tar.gz
Merge rurik.mysql.com:/home/igor/mysql-5.0
into rurik.mysql.com:/home/igor/dev/mysql-5.0-0
Diffstat (limited to 'mysql-test/r/range.result')
-rw-r--r--mysql-test/r/range.result35
1 files changed, 0 insertions, 35 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result
index 5369932c13e..a9f40f6c302 100644
--- a/mysql-test/r/range.result
+++ b/mysql-test/r/range.result
@@ -547,38 +547,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;