diff options
| author | monty@hundin.mysql.fi <> | 2001-06-19 14:30:12 +0300 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2001-06-19 14:30:12 +0300 |
| commit | 72fb81e888b5c5f9c1c7917709568d61cfb6663f (patch) | |
| tree | 884d89c2f53eae988fe08259ab2953720d274ab2 /mysql-test/t/bdb.test | |
| parent | 16d50ca46d41060240dffc761f12144395150ff6 (diff) | |
| download | mariadb-git-72fb81e888b5c5f9c1c7917709568d61cfb6663f.tar.gz | |
Fixed bug in mysqlcheck when using --fast
Fixed problem when converting bigint to double.
Fixed bug in count(distinct null)
Fixed bug with empty BDB tables.
Diffstat (limited to 'mysql-test/t/bdb.test')
| -rw-r--r-- | mysql-test/t/bdb.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/bdb.test b/mysql-test/t/bdb.test index 96296e238fd..c61a6c7197d 100644 --- a/mysql-test/t/bdb.test +++ b/mysql-test/t/bdb.test @@ -705,3 +705,13 @@ commit; select id,id3 from t1; UNLOCK TABLES; DROP TABLE t1; + +# +# Test with empty tables (crashed with lock error) +# + +CREATE TABLE t1 (SYAIN_NO char(5) NOT NULL default '', KINMU_DATE char(6) NOT NULL default '', PRIMARY KEY (SYAIN_NO,KINMU_DATE)) TYPE=BerkeleyDB; +CREATE TABLE t2 ( SYAIN_NO char(5) NOT NULL default '',STR_DATE char(8) NOT NULL default '',PRIMARY KEY (SYAIN_NO,STR_DATE) ) TYPE=BerkeleyDB; +select T1.KINMU_DATE from t1 T1 ,t2 T2 where T1.SYAIN_NO = '12345' and T1.KINMU_DATE = '200106' and T2.SYAIN_NO = T1.SYAIN_NO; +select T1.KINMU_DATE from t1 T1 ,t2 T2 where T1.SYAIN_NO = '12345' and T1.KINMU_DATE = '200106' and T2.SYAIN_NO = T1.SYAIN_NO; +DROP TABLE t1,t2; |