diff options
| author | unknown <mikael@c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se> | 2006-06-14 08:51:39 -0400 |
|---|---|---|
| committer | unknown <mikael@c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se> | 2006-06-14 08:51:39 -0400 |
| commit | 179c979937bf8fafef7931ce79304fd66a1eaff3 (patch) | |
| tree | c3357efb607b156fe28aa7f574fc751359477fb5 /mysql-test/t/partition.test | |
| parent | 2ecd916de6f0daebb22f79cd6f0ad09f581c2aec (diff) | |
| parent | a4c2d33ed976de778f1ff526b6d524a3ffe844c9 (diff) | |
| download | mariadb-git-179c979937bf8fafef7931ce79304fd66a1eaff3.tar.gz | |
Merge c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/clean-mysql-5.1
into c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/bug19801
mysql-test/r/partition.result:
Auto merged
mysql-test/t/partition.test:
Auto merged
sql/sql_partition.cc:
Auto merged
sql/partition_info.cc:
manual merge
Diffstat (limited to 'mysql-test/t/partition.test')
| -rw-r--r-- | mysql-test/t/partition.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/partition.test b/mysql-test/t/partition.test index a7f2e1c0b3e..f18db2fed10 100644 --- a/mysql-test/t/partition.test +++ b/mysql-test/t/partition.test @@ -919,6 +919,12 @@ create table t1 (f1 smallint) partition by list (f1) (partition p0 values in (null)); insert into t1 values (null); select * from t1 where f1 is null; +select * from t1 where f1 < 1; +select * from t1 where f1 <= NULL; +select * from t1 where f1 < NULL; +select * from t1 where f1 >= NULL; +select * from t1 where f1 > NULL; +select * from t1 where f1 > 1; drop table t1; create table t1 (f1 smallint) |