pgpool2.git / summary / log / commit / refs

commit    164d641b7a52ac51228e2be201c2344de1b8fc5f
Author:   Yoshiyuki Asaba <y-asaba at pgfoundry.org>
Date:     Mon Oct 15 10:20:05 2007 +0000

    Add test cases.


 test/parser/expected/create.out |  2 +-
 test/parser/expected/select.out | 24 +++++++++++++++++++++++-
 test/parser/input/select.sql    | 14 ++++++++++++++
 3 files changed, 38 insertions(+), 2 deletions(-)

diff --git a/test/parser/expected/create.out b/test/parser/expected/create.out
index b42da06b7..79dfe0a49 100644
--- a/test/parser/expected/create.out
+++ b/test/parser/expected/create.out
@@ -26,7 +26,7 @@ CREATE TABLE "foo" ("a" "int4" PRIMARY KEY)
 CREATE TABLE "foo" ("a" "int4" CHECK ( ("a">100 ))) 
 CREATE TABLE "foo" ("a" "int4" REFERENCES "b"("c")) 
 CREATE TABLE "foo" ("a" "int4" REFERENCES "b"("c") MATCH FULL) 
-CREATE TABLE "foo" ("a" "int4" REFERENCES "b"("c") MATCH PARTIAL) 
+syntax error: CREATE TABLE foo (a int references b(c) MATCH PARTIAL)
 CREATE TABLE "foo" ("a" "int4" REFERENCES "b"("c")) 
 CREATE TABLE "foo" ("a" "int4" REFERENCES "b"("c") ON UPDATE RESTRICT) 
 CREATE TABLE "foo" ("a" "int4" REFERENCES "b"("c") ON UPDATE CASCADE) 
diff --git a/test/parser/expected/select.out b/test/parser/expected/select.out
index ea5e9e0ee..29b4cae5e 100644
--- a/test/parser/expected/select.out
+++ b/test/parser/expected/select.out
@@ -5,7 +5,7 @@
  SELECT "x" FROM "a"."b"
  SELECT "foo"()
  SELECT "y" FROM "foo"()
- SELECT "*" FROM 
+syntax error: SELECT * FROM (SELECT * FROM foo);
  SELECT "a" AS "t"  FROM "x"
  SELECT "x" FROM "a" AS "b"
  SELECT "a" AS "tttttttttttttttttttttttttttttttttttttttttttttttttttttttt" ,"b" AS "uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu"  FROM "zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz"
@@ -64,3 +64,25 @@ CREATE TABLE "x" AS SELECT "*" FROM "t"
  SELECT "*" FROM "t" WHERE 1 IS OF ("int4")
  SELECT "*" FROM "t" WHERE "a" IN ('a','b',1)
  SELECT "*" FROM "t" WHERE "a" NOT IN ('a','b',1)
+ SELECT "*" FROM "t" WHERE "a" IS DOCUMENT
+ SELECT "*" FROM "t" WHERE  (NOT "a" IS DOCUMENT)
+ SELECT XMLCONCAT ("a","b")
+ SELECT XMLELEMENT (NAME "a")
+ SELECT XMLELEMENT (NAME "a","b","c")
+ SELECT XMLFOREST ("a")
+ SELECT XMLPARSE (DOCUMENT 1)
+ SELECT XMLPARSE (DOCUMENT 1 PRESERVE WHITESPACE)
+ SELECT "day" '1900-1-1'
+ SELECT "interval" '1 year'
+ SELECT "interval" '1 year' YEAR
+ SELECT "interval" '1 year' MONTH
+ SELECT "interval" '1 year' DAY
+ SELECT "interval" '1 year' HOUR
+ SELECT "interval" '1 year' MINUTE
+ SELECT "interval" '1 year' SECOND
+ SELECT "interval" '1 year' YEAR TO MONTH
+ SELECT "interval" '1 year' DAY TO HOUR
+ SELECT "interval" '1 year' DAY TO MINUTE
+ SELECT "interval" '1 year' DAY TO SECOND
+ SELECT "interval" '1 year' HOUR TO MINUTE
+ SELECT "interval" '1 year' HOUR TO SECOND
diff --git a/test/parser/input/select.sql b/test/parser/input/select.sql
index 0d91e63c2..87082d3f8 100644
--- a/test/parser/input/select.sql
+++ b/test/parser/input/select.sql
@@ -72,3 +72,17 @@ SELECT XMLELEMENT(NAME a,b,c);
 SELECT XMLFOREST(a)
 SELECT XMLPARSE(DOCUMENT 1 STRIP WHITESPACE)
 SELECT XMLPARSE(DOCUMENT 1 PRESERVE WHITESPACE)
+SELECT day '1900-1-1'
+SELECT interval '1 year'
+SELECT interval '1 year' YEAR
+SELECT interval '1 year' MONTH
+SELECT interval '1 year' DAY
+SELECT interval '1 year' HOUR
+SELECT interval '1 year' MINUTE
+SELECT interval '1 year' SECOND
+SELECT interval '1 year' YEAR TO MONTH
+SELECT interval '1 year' DAY TO HOUR
+SELECT interval '1 year' DAY TO MINUTE
+SELECT interval '1 year' DAY TO SECOND
+SELECT interval '1 year' HOUR TO MINUTE
+SELECT interval '1 year' HOUR TO SECOND


[parent: 3d9b750c5677]