[libgda] Correction for bug #761560
- From: Vivien Malerba <vivien src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [libgda] Correction for bug #761560
- Date: Sat, 6 Feb 2016 17:54:09 +0000 (UTC)
commit d0f0d9a458f01fdf81b2a95ce433257ae6a343ba
Author: Vivien Malerba <malerba gnome-db org>
Date: Sat Feb 6 18:52:37 2016 +0100
Correction for bug #761560
libgda/sql-parser/parser.y | 1 +
tests/parser/testdata.xml | 4 ++++
2 files changed, 5 insertions(+), 0 deletions(-)
---
diff --git a/libgda/sql-parser/parser.y b/libgda/sql-parser/parser.y
index 2987577..8dba637 100644
--- a/libgda/sql-parser/parser.y
+++ b/libgda/sql-parser/parser.y
@@ -992,6 +992,7 @@ paramspec(P) ::= paramspec(E) PNULLOK(N). {if (!E) P = gda_sql_param_spec_new (N
nm(A) ::= JOIN(X). {A = X;}
nm(A) ::= ID(X). {A = X;}
nm(A) ::= TEXTUAL(X). {A = X;}
+nm(A) ::= LIMIT(X). {A = X;}
// Fully qualified name
fullname(A) ::= nm(X). {A = X;}
diff --git a/tests/parser/testdata.xml b/tests/parser/testdata.xml
index 1a3679d..82467c6 100644
--- a/tests/parser/testdata.xml
+++ b/tests/parser/testdata.xml
@@ -1044,4 +1044,8 @@
<sql>SELECT foo.abc FROM (select abc from bar) foo</sql>
<expected>{"statements":[{"statement":{"sql":"SELECT foo.abc FROM (select abc from bar)
foo","stmt_type":"SELECT","contents":{"distinct":"false","fields":[{"expr":{"value":"foo.abc"},"field_name":"abc","table_name":"foo"}],"from":{"targets":[{"expr":{"select":{"contents":{"distinct":"false","fields":[{"expr":{"value":"abc"},"field_name":"abc"}],"from":{"targets":[{"expr":{"value":"bar"},"table_name":"bar"}]}}}},"as":"foo"}]}}}}]}</expected>
</test>
+ <test id="bug761560">
+ <sql>UPDATE coupons SET limit = 1 WHERE coupons.id = 1</sql>
+ <expected>{"statements":[{"statement":{"sql":"UPDATE coupons SET limit = 1 WHERE coupons.id =
1","stmt_type":"UPDATE","contents":{"table":"coupons","fields":["limit"],"expressions":[{"value":"1"}],"condition":{"operation":{"operator":"=","operand0":{"value":"coupons.id"},"operand1":{"value":"1"}}}}}}]}</expected>
+ </test>
</testdata>
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]