diff options
| author | unknown <gluh@mysql.com/eagle.(none)> | 2007-02-26 16:52:54 +0400 |
|---|---|---|
| committer | unknown <gluh@mysql.com/eagle.(none)> | 2007-02-26 16:52:54 +0400 |
| commit | bab42f674d95186ccc7a3fdb4901fbb0b00a1b96 (patch) | |
| tree | 18a8e98d0082cdf6308374068d3790ba225348bc /mysql-test/r | |
| parent | b10600528dfd92a4d1dcd5d3bff1e0c0f41672a8 (diff) | |
| download | mariadb-git-bab42f674d95186ccc7a3fdb4901fbb0b00a1b96.tar.gz | |
after merge fix
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/insert_select.result | 14 | ||||
| -rw-r--r-- | mysql-test/r/subselect.result | 12 |
2 files changed, 6 insertions, 20 deletions
diff --git a/mysql-test/r/insert_select.result b/mysql-test/r/insert_select.result index 77420890053..18a0ed1a1cb 100644 --- a/mysql-test/r/insert_select.result +++ b/mysql-test/r/insert_select.result @@ -717,20 +717,6 @@ select * from t1; f1 f2 1 2 drop table t1; -create table t1(f1 int primary key auto_increment, f2 int unique); -insert into t1(f2) values(1); -select @@identity; -@@identity -1 -insert ignore t1(f2) values(1); -select @@identity; -@@identity -0 -insert ignore t1(f2) select 1; -select @@identity; -@@identity -0 -drop table t1; CREATE TABLE t1 (f1 INT, f2 INT ); CREATE TABLE t2 (f1 INT PRIMARY KEY, f2 INT); INSERT INTO t1 VALUES (1,1),(2,2),(10,10); diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 7c6657d0960..43abef692e9 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -328,9 +328,9 @@ patient_uq clinic_uq 1 2 2 2 explain extended select * from t6 where exists (select * from t7 where uq = clinic_uq); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t6 ALL NULL NULL NULL NULL 4 Using where -2 DEPENDENT SUBQUERY t7 eq_ref PRIMARY PRIMARY 4 t6.clinic_uq 1 Using where; Using index +id select_type table type possible_keys key key_len ref rows filtered Extra +1 PRIMARY t6 ALL NULL NULL NULL NULL 4 100.00 Using where +2 DEPENDENT SUBQUERY t7 eq_ref PRIMARY PRIMARY 4 t6.clinic_uq 1 100.00 Using where; Using index Warnings: Note 1276 Field or reference 'test.t6.clinic_uq' of SELECT #2 was resolved in SELECT #1 Note 1003 select `test`.`t6`.`patient_uq` AS `patient_uq`,`test`.`t6`.`clinic_uq` AS `clinic_uq` from `test`.`t6` where exists(select 1 AS `Not_used` from `test`.`t7` where (`test`.`t7`.`uq` = `test`.`t6`.`clinic_uq`)) @@ -1739,9 +1739,9 @@ id select_type table type possible_keys key key_len ref rows filtered Extra Warnings: Note 1003 select `test`.`t1`.`id` AS `id`,`test`.`t1`.`text` AS `text` from `test`.`t1` where (not(<in_optimizer>(`test`.`t1`.`id`,<exists>(<primary_index_lookup>(<cache>(`test`.`t1`.`id`) in t1 on PRIMARY where (`test`.`t1`.`id` < 8)))))) explain extended select * from t1 as tt where not exists (select id from t1 where id < 8 and (id = tt.id or id is null) having id is not null); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY tt ALL NULL NULL NULL NULL 12 Using where -2 DEPENDENT SUBQUERY t1 eq_ref PRIMARY PRIMARY 4 tt.id 1 Using where; Using index +id select_type table type possible_keys key key_len ref rows filtered Extra +1 PRIMARY tt ALL NULL NULL NULL NULL 12 100.00 Using where +2 DEPENDENT SUBQUERY t1 eq_ref PRIMARY PRIMARY 4 tt.id 1 100.00 Using where; Using index Warnings: Note 1276 Field or reference 'test.tt.id' of SELECT #2 was resolved in SELECT #1 Note 1003 select `test`.`tt`.`id` AS `id`,`test`.`tt`.`text` AS `text` from `test`.`t1` `tt` where (not(exists(select `test`.`t1`.`id` AS `id` from `test`.`t1` where ((`test`.`t1`.`id` < 8) and (`test`.`t1`.`id` = `test`.`tt`.`id`)) having (`test`.`t1`.`id` is not null)))) |