diff options
| author | unknown <evgen@moonbone.local> | 2006-01-11 23:39:09 +0300 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2006-01-11 23:39:09 +0300 |
| commit | 4e2e0c6d53ea561005b2b9d600d3ba0e0fe11f05 (patch) | |
| tree | 9e1e00941b043b69e54ae5805514d29fb9e94c34 /mysql-test/r/select.result | |
| parent | 5c12976f539b7ba27c08e1dc06aa85d240094890 (diff) | |
| download | mariadb-git-4e2e0c6d53ea561005b2b9d600d3ba0e0fe11f05.tar.gz | |
Fixed bug #15538: unchecked table absence caused server crash.
Absence of table in left part of LEFT/RIGHT join wasn't checked before
name resolution which resulted in NULL dereferencing and server crash.
Modified rules:
"table_ref LEFT opt_outer JOIN_SYM table_ref" and "table_ref RIGHT opt_outer
JOIN_SYM table_ref"
NULL check is moved before push_new_name_resolution_context()
sql/sql_yacc.yy:
Fixed bug #15538: unchecked table absence caused server crash.
Modified rules:
"table_ref LEFT opt_outer JOIN_SYM table_ref" and "table_ref RIGHT opt_outer
JOIN_SYM table_ref"
NULL check is moved before push_new_name_resolution_context()
mysql-test/r/select.result:
Added test case for bug #15538: unchecked table absence caused server crash.
mysql-test/t/select.test:
Added test case for bug #15538: unchecked table absence caused server crash.
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index e2c4609d902..943ab88223c 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -3345,3 +3345,5 @@ select * from t1 left join t2 on f1=t2.f2 where t1.f2='a'; f1 f2 f2 NULL a NULL drop table t1,t2; +select * from (select * left join t on f1=f2) tt; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on f1=f2) tt' at line 1 |