diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-08-12 15:04:49 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-08-12 15:04:49 +0300 |
| commit | 45b145a96e9a5992b8a5c8a0a1a23d99951058ca (patch) | |
| tree | 9b6eb05bbb347e1704e9fe0036f80dc793830074 /mysql-test/r/derived.result | |
| parent | 253b2a9654f6430d879076771b70bd018dd30732 (diff) | |
| download | mariadb-git-45b145a96e9a5992b8a5c8a0a1a23d99951058ca.tar.gz | |
fixed problem with reference on derived table fields (BUG#1031)
mysql-test/r/derived.result:
test of BUG#1031
mysql-test/t/derived.test:
test of BUG#1031
sql/item_sum.cc:
'alias' parameter added to create_tmp_table
sql/sql_derived.cc:
Derived table should be named (to pass it name to Field and then to Item_field)
sql/sql_select.cc:
'alias' parameter added to create_tmp_table
sql/sql_select.h:
'alias' parameter added to create_tmp_table
sql/sql_union.cc:
'alias' parameter added to create_tmp_table
sql/sql_update.cc:
'alias' parameter added to create_tmp_table
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 |