[libgda] Remove not needed comment
- From: Vivien Malerba <vivien src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [libgda] Remove not needed comment
- Date: Tue, 9 Feb 2016 20:45:42 +0000 (UTC)
commit 58aac77c4e545c176803752a1e3a43cf01389c79
Author: Arthur Neves <arthurnn gmail com>
Date: Mon Feb 8 15:40:48 2016 -0500
Remove not needed comment
The comment was probably copied from the test above, but it is incorrect for that test
tests/parser/testdata.xml | 3 +--
1 files changed, 1 insertions(+), 2 deletions(-)
---
diff --git a/tests/parser/testdata.xml b/tests/parser/testdata.xml
index 82467c6..1b4de5e 100644
--- a/tests/parser/testdata.xml
+++ b/tests/parser/testdata.xml
@@ -204,7 +204,7 @@
<sql>DECLARE var1 int; var2 varchar (23); begin blah; bloh; end;</sql>
<expected>{"statements":[{"statement":{"sql":"DECLARE var1 int; var2 varchar (23); begin blah; bloh;
end;","stmt_type":"UNKNOWN","contents":[{"value":"DECLARE"},{"value":" "},{"value":"var1"},{"value":"
"},{"value":"int"},{"value":";"},{"value":" "},{"value":"var2"},{"value":" "},{"value":"varchar"},{"value":"
"},{"value":"("},{"value":"23"},{"value":")"},{"value":";"},{"value":" "},{"value":"begin"},{"value":"
"},{"value":"blah"},{"value":";"},{"value":" "},{"value":"bloh"},{"value":";"},{"value":"
"},{"value":"end"}]}}]}</expected>
</test>
-
+
<test id="33.3">
<sql>DECLARE a T1.e%TYPE; b T1.f%TYPE;CURSOR T1Cursor IS SELECT e, f FROM T1 WHERE e < f FOR UPDATE;
BEGIN OPEN T1Cursor; LOOP FETCH T1Cursor INTO a, b; EXIT WHEN T1Cursor%NOTFOUND; DELETE FROM T1 WHERE CURRENT
OF T1Cursor; INSERT INTO T1 VALUES(b, a); END LOOP;CLOSE T1Cursor;END;</sql>
<expected>{"statements":[{"statement":{"sql":"DECLARE a T1.e%TYPE; b T1.f%TYPE;CURSOR T1Cursor IS SELECT
e, f FROM T1 WHERE e < f FOR UPDATE; BEGIN OPEN T1Cursor; LOOP FETCH T1Cursor INTO a, b; EXIT WHEN
T1Cursor%NOTFOUND; DELETE FROM T1 WHERE CURRENT OF T1Cursor; INSERT INTO T1 VALUES(b, a); END LOOP;CLOSE
T1Cursor;END;","stmt_type":"UNKNOWN","contents":[{"value":"DECLARE"},{"value":" "},{"value":"a"},{"value":"
"},{"value":"T1.e%TYPE"},{"value":";"},{"value":" "},{"value":"b"},{"value":"
"},{"value":"T1.f%TYPE"},{"value":";"},{"value":"CURSOR"},{"value":" "},{"value":"T1Cursor"},{"value":"
"},{"value":"IS"},{"value":" "},{"value":"SELECT"},{"value":" "},{"value":"e,"},{"value":"
"},{"value":"f"},{"value":" "},{"value":"FROM"},{"value":" "},{"value":"T1"},{"value":"
"},{"value":"WHERE"},{"value":" "},{"value":"e"},{"value":" "},{"value":"<"},{"value":"
"},{"value":"f"},{"value":" "},{"value":"FOR"},{"value":" "},{"value":"UPDATE"},{"value":";"},{"value":"
"},{"val
ue":"BEGIN"},{"value":" "},{"value":"OPEN"},{"value":" "},{"value":"T1Cursor"},{"value":";"},{"value":"
"},{"value":"LOOP"},{"value":" "},{"value":"FETCH"},{"value":" "},{"value":"T1Cursor"},{"value":"
"},{"value":"INTO"},{"value":" "},{"value":"a,"},{"value":" "},{"value":"b"},{"value":";"},{"value":"
"},{"value":"EXIT"},{"value":" "},{"value":"WHEN"},{"value":"
"},{"value":"T1Cursor%NOTFOUND"},{"value":";"},{"value":" "},{"value":"DELETE"},{"value":"
"},{"value":"FROM"},{"value":" "},{"value":"T1"},{"value":" "},{"value":"WHERE"},{"value":"
"},{"value":"CURRENT"},{"value":" "},{"value":"OF"},{"value":"
"},{"value":"T1Cursor"},{"value":";"},{"value":" "},{"value":"INSERT"},{"value":"
"},{"value":"INTO"},{"value":" "},{"value":"T1"},{"value":"
"},{"value":"VALUES"},{"value":"("},{"value":"b,"},{"value":" "},{"value":"a)"},{"value":";"},{"value":"
"},{"value":"END LOOP"},{"value":";"},{"value":"CLOSE"},{"value":"
"},{"value":"T1Cursor"},{"value":";"},{"value":"END"}]}}]}</exp
ected>
@@ -1039,7 +1039,6 @@
<expected>{"statements":[{"statement":{"sql":"SELECT * FROM
\"table\"","stmt_type":"SELECT","contents":{"distinct":"false","fields":[{"expr":{"value":"*"}}],"from":{"targets":[{"expr":{"value":"\"table\""},"table_name":"\"table\""}]}}}}]}</expected>
</test>
- <!-- Double quoting table name, works for PostgreSQL as well -->
<test id="bug761529">
<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>
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]