diff options
| author | monty@hundin.mysql.fi <> | 2001-09-14 17:59:05 +0300 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2001-09-14 17:59:05 +0300 |
| commit | 008472f3737bee96fb77f20726fb4478044ac81d (patch) | |
| tree | 7e952862e45ea1418eb96e1cbd225a646acd0849 /mysql-test/t/bdb.test | |
| parent | c946439d6c8d402a0a1a2a6520760dab16648c21 (diff) | |
| download | mariadb-git-008472f3737bee96fb77f20726fb4478044ac81d.tar.gz | |
Fixed problem with "record not found" in BDB tables.
Diffstat (limited to 'mysql-test/t/bdb.test')
| -rw-r--r-- | mysql-test/t/bdb.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/bdb.test b/mysql-test/t/bdb.test index 465dc9634cc..50698bb8df6 100644 --- a/mysql-test/t/bdb.test +++ b/mysql-test/t/bdb.test @@ -748,3 +748,22 @@ SELECT t1.* FROM t1 WHERE id IN (1); SELECT t1.* FROM t2 left outer join t1 on (t1.id=t2.id); delete from t1 where id3 >= 0 and id3 <= 0; drop table t1,t2; + +# +# Test problems with NULL +# + +CREATE TABLE t1 (i varchar(48) NOT NULL default '', p varchar(255) default NULL,s varchar(48) NOT NULL default '', PRIMARY KEY (i), UNIQUE(p,s)) TYPE=BDB; +INSERT INTO t1 VALUES ('00000000-e6c4ddeaa6-003b8-83458387','programs/xxxxxxxx.wmv','00000000-e6c4ddeb32-003bc-83458387'); +SELECT * FROM t1 WHERE p='programs/xxxxxxxx.wmv'; +drop table t1; + +# +# Test problem which gave error 'Can't find record in 't1'' +# + +CREATE TABLE t1 ( STR_DATE varchar(8) NOT NULL default '',INFO_NOTE varchar(200) default NULL,PRIMARY KEY (STR_DATE) ) TYPE=BerkeleyDB; +select INFO_NOTE from t1 where STR_DATE = '20010610'; +select INFO_NOTE from t1 where STR_DATE < '20010610'; +select INFO_NOTE from t1 where STR_DATE > '20010610'; +drop table t1; |