diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-11-28 23:31:48 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-11-28 23:31:48 +0200 |
| commit | 3ec9f7e1c46de3f4bbbf54106d0eaae7d55b1b34 (patch) | |
| tree | 57c79fcea3663b0d0a62c779f4099f4cf73d3e67 /mysql-test/r | |
| parent | 4078d0deffb7720c2732be4bfea5fec107d40779 (diff) | |
| download | mariadb-git-3ec9f7e1c46de3f4bbbf54106d0eaae7d55b1b34.tar.gz | |
test of changing subselects tree
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/subselect.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index ea771938286..523c3af91c4 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -532,6 +532,15 @@ Note 1246 Select 2 was reduced during optimisation SELECT * FROM t WHERE id IN (SELECT 1 UNION SELECT 3); id 1 +SELECT * FROM t WHERE id IN (SELECT 1+(select 1)); +id +2 +EXPLAIN SELECT * FROM t WHERE id IN (SELECT 1+(select 1)); +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY t ref id id 5 const 1 Using where; Using index +3 SUBSELECT No tables used +Warnings: +Note 1246 Select 2 was reduced during optimisation EXPLAIN SELECT * FROM t WHERE id IN (SELECT 1 UNION SELECT 3); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t index NULL id 5 NULL 2 Using where; Using index |