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/t/derived.test | |
| 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/t/derived.test')
| -rw-r--r-- | mysql-test/t/derived.test | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/mysql-test/t/derived.test b/mysql-test/t/derived.test index c998de7ae6e..c3edbabcd53 100644 --- a/mysql-test/t/derived.test +++ b/mysql-test/t/derived.test @@ -88,5 +88,9 @@ SELECT d.pla_id, m2.test FROM t1 m2 INNER JOIN (SELECT mp.pla_id, MIN(m1.matint explain SELECT d.pla_id, m2.mat_id FROM t1 m2 INNER JOIN (SELECT mp.pla_id, MIN(m1.matintnum) AS matintnum FROM t2 mp INNER JOIN t1 m1 ON mp.mat_id=m1.mat_id GROUP BY mp.pla_id) d ON d.matintnum=m2.matintnum; explain SELECT d.pla_id, m2.test FROM t1 m2 INNER JOIN (SELECT mp.pla_id, MIN(m1.matintnum) AS matintnum FROM t2 mp INNER JOIN t1 m1 ON mp.mat_id=m1.mat_id GROUP BY mp.pla_id) d ON d.matintnum=m2.matintnum; +drop table t1,t2; -drop table t1,t2 +# +# derived table reference +# +SELECT a.x FROM (SELECT 1 AS x) AS a HAVING a.x = 1; |