diff options
| author | bell@sanja.is.com.ua <> | 2003-08-12 15:04:49 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2003-08-12 15:04:49 +0300 |
| commit | b6a8d68ae43ee84be6fcc34a8aed1c0275d04eba (patch) | |
| tree | 9b6eb05bbb347e1704e9fe0036f80dc793830074 /mysql-test/r/derived.result | |
| parent | c767f0b2a0d0accd837a350074df8d8b561f09f0 (diff) | |
| download | mariadb-git-b6a8d68ae43ee84be6fcc34a8aed1c0275d04eba.tar.gz | |
fixed problem with reference on derived table fields (BUG#1031)
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index f3b09164dda..f9e52174469 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -192,3 +192,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <derived2> ALL NULL NULL NULL NULL 6 Using where 2 DERIVED mp ALL NULL NULL NULL NULL 9 Using temporary; Using filesort 2 DERIVED m2 index NULL PRIMARY 3 NULL 9 Using index +drop table t1,t2; +SELECT a.x FROM (SELECT 1 AS x) AS a HAVING a.x = 1; +x +1 |