diff options
| author | unknown <istruewing@chilla.local> | 2006-08-29 21:08:40 +0200 |
|---|---|---|
| committer | unknown <istruewing@chilla.local> | 2006-08-29 21:08:40 +0200 |
| commit | a32f6b89417bf26f27526544501262368ea753d9 (patch) | |
| tree | 08a6b6e546c6c0e6fe7a976e786c0edc374fec1d /mysql-test/r/myisam.result | |
| parent | 868fee4dde4d73c2cd999f8a2ffc915f040e9e0b (diff) | |
| parent | 7d600f71314504bb85d9329628668962355f52ae (diff) | |
| download | mariadb-git-a32f6b89417bf26f27526544501262368ea753d9.tar.gz | |
Merge chilla.local:/home/mydev/mysql-4.0-bug14400
into chilla.local:/home/mydev/mysql-4.1-bug14400
myisam/mi_rkey.c:
Bug#14400 - Query joins wrong rows from table which is
subject of "concurrent insert"
Manual merge from 4.0.
mysql-test/r/myisam.result:
Bug#14400 - Query joins wrong rows from table which is
subject of "concurrent insert"
Manual merge from 4.0.
mysql-test/t/myisam.test:
Bug#14400 - Query joins wrong rows from table which is
subject of "concurrent insert"
Manual merge from 4.0.
Diffstat (limited to 'mysql-test/r/myisam.result')
| -rw-r--r-- | mysql-test/r/myisam.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 7aaf3c8f85a..47160fd47c7 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -756,3 +756,18 @@ a b xxxxxxxxx bbbbbb xxxxxxxxx bbbbbb DROP TABLE t1; +create table t1 (a int not null, primary key(a)); +create table t2 (a int not null, b int not null, primary key(a,b)); +insert into t1 values (1),(2),(3),(4),(5),(6); +insert into t2 values (1,1),(2,1); +lock tables t1 read local, t2 read local; +select straight_join * from t1,t2 force index (primary) where t1.a=t2.a; +a a b +1 1 1 +2 2 1 +insert into t2 values(2,0); +select straight_join * from t1,t2 force index (primary) where t1.a=t2.a; +a a b +1 1 1 +2 2 1 +drop table t1,t2; |