diff options
| author | unknown <tim@white.box> | 2001-07-17 17:30:17 -0400 |
|---|---|---|
| committer | unknown <tim@white.box> | 2001-07-17 17:30:17 -0400 |
| commit | c35334543c2d48f2a4527c3b837913133c8fff6d (patch) | |
| tree | 2474609801cb5429e18dceac6189cfa6cd64f862 /mysql-test | |
| parent | 03509e63992a931c55b9ac6cb3e15c09ccd14857 (diff) | |
| download | mariadb-git-c35334543c2d48f2a4527c3b837913133c8fff6d.tar.gz | |
bdb.test new test for a bug report
mysql-test/t/bdb.test:
new test for a bug report
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/t/bdb.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/bdb.test b/mysql-test/t/bdb.test index c61a6c7197d..ed167d8d005 100644 --- a/mysql-test/t/bdb.test +++ b/mysql-test/t/bdb.test @@ -715,3 +715,18 @@ CREATE TABLE t2 ( SYAIN_NO char(5) NOT NULL default '',STR_DATE char(8) NOT NULL 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; + +# +# Test problem with joining table to itself on a multi-part unique key +# + +drop table if exists t; +create table t (a int(11) not null, b int(11) not null, unique (a,b)) type=bdb; + +insert into t values (1,1), (1,2); + +select * from t where a = 1; +select t1.*, t2.* from t t1, t t2 where t1.a = t2.a and t2.a = 1; +select * from t where a = 1; + +drop table t; |