diff options
author | igor@rurik.mysql.com <> | 2005-07-17 09:46:14 -0700 |
---|---|---|
committer | igor@rurik.mysql.com <> | 2005-07-17 09:46:14 -0700 |
commit | 54dd7e5ebf68b2a752c39791744ef8245a58594c (patch) | |
tree | 1e07c203ef28201cbcf2715f936d037466b46e03 /sql/sql_yacc.yy | |
parent | 553f2a59f37e0e12f245134f95ea5d93a342b77e (diff) | |
download | mariadb-git-54dd7e5ebf68b2a752c39791744ef8245a58594c.tar.gz |
select.result, select.test:
Added a test case for bug #11745.
sql_select.cc:
Fixed bug # 11745.
Added support of where clause for queries with FROM DUAL.
sql_yacc.yy:
Fixed bug # 11745.
Added optional where clause for queries with FROM DUAL.
Diffstat (limited to 'sql/sql_yacc.yy')
-rw-r--r-- | sql/sql_yacc.yy | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/sql_yacc.yy b/sql/sql_yacc.yy index 2587ce7e1a5..be8ead8e157 100644 --- a/sql/sql_yacc.yy +++ b/sql/sql_yacc.yy @@ -2459,7 +2459,7 @@ select_into: select_from: FROM join_table_list where_clause group_clause having_clause opt_order_clause opt_limit_clause procedure_clause - | FROM DUAL_SYM opt_limit_clause + | FROM DUAL_SYM where_clause opt_limit_clause /* oracle compatibility: oracle always requires FROM clause, and DUAL is system table without fields. Is "SELECT 1 FROM DUAL" any better than "SELECT 1" ? |