diff options
| author | monty@narttu.mysql.fi <> | 2003-10-07 15:42:26 +0300 |
|---|---|---|
| committer | monty@narttu.mysql.fi <> | 2003-10-07 15:42:26 +0300 |
| commit | 6056cfadfcb07cda12f6dc01ec9c1ab07067ac69 (patch) | |
| tree | d89c080ef636608e316f1166b1628cd1d902deec /mysql-test/r/join_outer.result | |
| parent | 0091fa2e3266da6a17b0615a4696c25a4d36d664 (diff) | |
| parent | 446d40e880c0e6ab6ac56b0082d4883ef5c7d467 (diff) | |
| download | mariadb-git-6056cfadfcb07cda12f6dc01ec9c1ab07067ac69.tar.gz | |
Merge with 4.0.16
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index b060fdfb85c..e852d266664 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -614,7 +614,7 @@ INSERT INTO t2 VALUES (1,1); explain SELECT * from t1 left join t2 on t1.id=t2.id where t2.id IS NULL; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 2 -1 SIMPLE t2 index id id 8 NULL 1 Using where; Using index; Not exists +1 SIMPLE t2 ref id id 4 t1.id 1 Using where; Using index; Not exists SELECT * from t1 left join t2 on t1.id=t2.id where t2.id IS NULL; id name id idx 2 no NULL NULL |