[libgda/LIBGDA_5.2] Correction for bug #761560



commit 686ce22ea3f7a9df336024a321324a66f7a4fe96
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]