pgpool2.git / summary / log / commit / refs

commit    7b34105de84bab871c8f9a8d7fe7588e33a01444
Author:   Tatsuo Ishii <ishii at sraoss.co.jp>
Date:     Sat Aug 01 03:20:38 2009 +0000

    parser test for PostgreSQL 8.4 or later.
    Patch contributed by Akio Ishida.


 test/parser/input/v84.sql  | 37 +++++++++++++++++++++++++++++++++++++
 test/parser/parse_schedule |  1 +
 2 files changed, 38 insertions(+)

diff --git a/test/parser/input/v84.sql b/test/parser/input/v84.sql
new file mode 100644
index 000000000..36026d4a4
--- /dev/null
+++ b/test/parser/input/v84.sql
@@ -0,0 +1,37 @@
+SELECT INTERVAL(0) '1.23' SECOND;
+SELECT INTERVAL '1 year' HOUR TO SECOND(2)
+SELECT char 'ABC';
+SELECT "char" 'ABC';
+SELECT avg(c1) OVER (PARTITION BY depname RANGE UNBOUNDED PRECEDING) FROM r1;
+SELECT avg(c1) OVER (PARTITION BY depname ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM r1;
+SELECT sum(c1) OVER w1 FROM r1 WINDOW w1 AS (PARTITION BY c2 ORDER BY c3), w2 AS (w1 PARTITION BY c4);
+WITH w1(n) AS (SELECT 1), w2(n) AS (SELECT 2) SELECT sum(n) FROM r1;
+WITH RECURSIVE t(n) AS (VALUES (1) UNION ALL SELECT n+1 FROM t WHERE n  < 100) SELECT sum(n) FROM t;
+ALTER AGGREGATE FOO(int) OWNER TO BAR;
+ALTER CONVERSION FOO OWNER TO BAR;
+ALTER DATABASE FOO OWNER TO BAR;
+ALTER DOMAIN FOO OWNER TO BAR;
+ALTER FUNCTION FOO() OWNER TO BAR;
+ALTER LANGUAGE FOO OWNER TO BAR;
+ALTER OPERATOR + (int, int) OWNER TO BAR;
+ALTER OPERATOR CLASS FOO USING BAZ OWNER TO BAR;
+ALTER OPERATOR FAMILY FOO USING BAZ OWNER TO BAR;
+ALTER TYPE FOO OWNER TO BAR;
+ALTER TABLESPACE FOO OWNER TO BAR;
+ALTER TEXT SEARCH DICTIONARY FOO OWNER TO BAR;
+ALTER TEXT SEARCH CONFIGURATION FOO OWNER TO BAR;
+ALTER FOREIGN DATA WRAPPER FOO OWNER TO BAR;
+ALTER SERVER FOO OWNER TO BAR;
+ALTER SCHEMA FOO OWNER TO BAR;
+LISTEN x
+NOTIFY x
+UNLISTEN x
+UNLISTEN *
+CREATE TRIGGER t1 BEFORE INSERT OR UPDATE OR DELETE OR TRUNCATE ON r1 EXECUTE PROCEDURE p1();
+GRANT ALL ON r1 TO PUBLIC;
+GRANT ALL ON SEQUENCE r1 TO PUBLIC;
+GRANT ALL ON FUNCTION r1() TO PUBLIC;
+GRANT ALL ON DATABASE r1 TO PUBLIC;
+GRANT ALL ON LANGUAGE r1 TO PUBLIC;
+GRANT ALL ON SCHEMA r1 TO PUBLIC;
+GRANT ALL ON TABLESPACE r1 TO PUBLIC;
diff --git a/test/parser/parse_schedule b/test/parser/parse_schedule
index b04971556..b81b22697 100644
--- a/test/parser/parse_schedule
+++ b/test/parser/parse_schedule
@@ -11,3 +11,4 @@ cursor
 prepare
 create
 drop
+v84


[parent: fd382bff97e3]