summaryrefslogtreecommitdiff
path: root/sql/sql_yacc.yy
diff options
context:
space:
mode:
authorigor@rurik.mysql.com <>2005-07-17 09:46:14 -0700
committerigor@rurik.mysql.com <>2005-07-17 09:46:14 -0700
commit54dd7e5ebf68b2a752c39791744ef8245a58594c (patch)
tree1e07c203ef28201cbcf2715f936d037466b46e03 /sql/sql_yacc.yy
parent553f2a59f37e0e12f245134f95ea5d93a342b77e (diff)
downloadmariadb-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.yy2
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" ?