*** ./expected/strings.out Sun Mar 14 12:25:17 2004 --- ./results/strings.out Wed Mar 9 15:19:16 2005 *************** *** 19,26 **** ' - third line' AS "Illegal comment within continuation"; ERROR: syntax error at or near "' - third line'" at character 75 - LINE 3: ' - third line' - ^ -- -- test conversions between various string types -- E021-10 implicit casting among the character data types --- 19,24 ---- ====================================================================== *** ./expected/create_function_1.out Wed Mar 9 15:18:46 2005 --- ./results/create_function_1.out Wed Mar 9 15:19:21 2005 *************** *** 56,63 **** CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql AS 'not even SQL'; ERROR: syntax error at or near "not" at character 62 - LINE 2: AS 'not even SQL'; - ^ CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql AS 'SELECT 1, 2, 3;'; ERROR: return type mismatch in function declared to return integer --- 56,61 ---- ====================================================================== *** ./expected/constraints.out Wed Mar 9 15:18:46 2005 --- ./results/constraints.out Wed Mar 9 15:19:24 2005 *************** *** 46,60 **** -- test for extraneous comma CREATE TABLE error_tbl (i int DEFAULT (100, )); ERROR: syntax error at or near ")" at character 45 - LINE 1: CREATE TABLE error_tbl (i int DEFAULT (100, )); - ^ -- this will fail because gram.y uses b_expr not a_expr for defaults, -- to avoid a shift/reduce conflict that arises from NOT NULL being -- part of the column definition syntax: CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2)); ERROR: syntax error at or near "IN" at character 43 - LINE 1: CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2)); - ^ -- this should work, however: CREATE TABLE error_tbl (b1 bool DEFAULT (1 IN (1, 2))); DROP TABLE error_tbl; --- 46,56 ---- ====================================================================== *** ./expected/errors.out Sat Mar 5 13:48:48 2005 --- ./results/errors.out Wed Mar 9 15:19:41 2005 *************** *** 20,35 **** -- missing relation name select; ERROR: syntax error at or near ";" at character 7 - LINE 1: select; - ^ -- no such relation select * from nonesuch; ERROR: relation "nonesuch" does not exist -- missing target list select from pg_database; ERROR: syntax error at or near "from" at character 8 - LINE 1: select from pg_database; - ^ -- bad name in target list select nonesuch from pg_database; ERROR: column "nonesuch" does not exist --- 20,31 ---- *************** *** 42,49 **** -- bad select distinct on syntax, distinct attribute missing select distinct on (foobar) from pg_database; ERROR: syntax error at or near "from" at character 29 - LINE 1: select distinct on (foobar) from pg_database; - ^ -- bad select distinct on syntax, distinct attribute not in target list select distinct on (foobar) * from pg_database; ERROR: column "foobar" does not exist --- 38,43 ---- *************** *** 53,60 **** -- missing relation name (this had better not wildcard!) delete from; ERROR: syntax error at or near ";" at character 12 - LINE 1: delete from; - ^ -- no such relation delete from nonesuch; ERROR: relation "nonesuch" does not exist --- 47,52 ---- *************** *** 64,71 **** -- missing relation name (this had better not wildcard!) drop table; ERROR: syntax error at or near ";" at character 11 - LINE 1: drop table; - ^ -- no such relation drop table nonesuch; ERROR: table "nonesuch" does not exist --- 56,61 ---- *************** *** 76,83 **** -- missing relation name alter table rename; ERROR: syntax error at or near ";" at character 19 - LINE 1: alter table rename; - ^ -- no such relation alter table nonesuch rename to newnonesuch; ERROR: relation "nonesuch" does not exist --- 66,71 ---- *************** *** 132,144 **** -- missing index name drop index; ERROR: syntax error at or near ";" at character 11 - LINE 1: drop index; - ^ -- bad index name drop index 314159; ERROR: syntax error at or near "314159" at character 12 - LINE 1: drop index 314159; - ^ -- no such index drop index nonesuch; ERROR: index "nonesuch" does not exist --- 120,128 ---- *************** *** 148,165 **** -- missing aggregate name drop aggregate; ERROR: syntax error at or near ";" at character 15 - LINE 1: drop aggregate; - ^ -- missing aggregate type drop aggregate newcnt1; ERROR: syntax error at or near ";" at character 23 - LINE 1: drop aggregate newcnt1; - ^ -- bad aggregate name drop aggregate 314159 (int); ERROR: syntax error at or near "314159" at character 16 - LINE 1: drop aggregate 314159 (int); - ^ -- bad aggregate type drop aggregate newcnt (nonesuch); ERROR: type "nonesuch" does not exist --- 132,143 ---- *************** *** 175,187 **** -- missing function name drop function (); ERROR: syntax error at or near "(" at character 15 - LINE 1: drop function (); - ^ -- bad function name drop function 314159(); ERROR: syntax error at or near "314159" at character 15 - LINE 1: drop function 314159(); - ^ -- no such function drop function nonesuch(); ERROR: function nonesuch() does not exist --- 153,161 ---- *************** *** 191,203 **** -- missing type name drop type; ERROR: syntax error at or near ";" at character 10 - LINE 1: drop type; - ^ -- bad type name drop type 314159; ERROR: syntax error at or near "314159" at character 11 - LINE 1: drop type 314159; - ^ -- no such type drop type nonesuch; ERROR: type "nonesuch" does not exist --- 165,173 ---- *************** *** 207,239 **** -- missing everything drop operator; ERROR: syntax error at or near ";" at character 14 - LINE 1: drop operator; - ^ -- bad operator name drop operator equals; ERROR: syntax error at or near ";" at character 21 - LINE 1: drop operator equals; - ^ -- missing type list drop operator ===; ERROR: syntax error at or near ";" at character 18 - LINE 1: drop operator ===; - ^ -- missing parentheses drop operator int4, int4; ERROR: syntax error at or near "," at character 19 - LINE 1: drop operator int4, int4; - ^ -- missing operator name drop operator (int4, int4); ERROR: syntax error at or near "(" at character 15 - LINE 1: drop operator (int4, int4); - ^ -- missing type list contents drop operator === (); ERROR: syntax error at or near ")" at character 20 - LINE 1: drop operator === (); - ^ -- no such operator drop operator === (int4); ERROR: missing argument --- 177,197 ---- *************** *** 248,255 **** -- no such type1 drop operator = ( , int4); ERROR: syntax error at or near "," at character 19 - LINE 1: drop operator = ( , int4); - ^ -- no such type1 drop operator = (nonesuch, int4); ERROR: type nonesuch does not exist --- 206,211 ---- *************** *** 259,295 **** -- no such type2 drop operator = (int4, ); ERROR: syntax error at or near ")" at character 24 - LINE 1: drop operator = (int4, ); - ^ -- -- DROP RULE -- missing rule name drop rule; ERROR: syntax error at or near ";" at character 10 - LINE 1: drop rule; - ^ -- bad rule name drop rule 314159; ERROR: syntax error at or near "314159" at character 11 - LINE 1: drop rule 314159; - ^ -- no such rule drop rule nonesuch on noplace; ERROR: relation "noplace" does not exist -- these postquel variants are no longer supported drop tuple rule nonesuch; ERROR: syntax error at or near "tuple" at character 6 - LINE 1: drop tuple rule nonesuch; - ^ drop instance rule nonesuch on noplace; ERROR: syntax error at or near "instance" at character 6 - LINE 1: drop instance rule nonesuch on noplace; - ^ drop rewrite rule nonesuch; ERROR: syntax error at or near "rewrite" at character 6 - LINE 1: drop rewrite rule nonesuch; - ^ -- -- Check that division-by-zero is properly caught. -- --- 215,239 ---- *************** *** 320,380 **** -- xxx; ERROR: syntax error at or near "xxx" at character 1 - LINE 1: xxx; - ^ CREATE foo; ERROR: syntax error at or near "foo" at character 8 - LINE 1: CREATE foo; - ^ CREATE TABLE ; ERROR: syntax error at or near ";" at character 14 - LINE 1: CREATE TABLE ; - ^ CREATE TABLE \g ERROR: syntax error at end of input at character 13 - LINE 1: CREATE TABLE - ^ INSERT INTO foo VALUES(123) foo; ERROR: syntax error at or near "foo" at character 29 - LINE 1: INSERT INTO foo VALUES(123) foo; - ^ INSERT INTO 123 VALUES(123); ERROR: syntax error at or near "123" at character 13 - LINE 1: INSERT INTO 123 - ^ INSERT INTO foo VALUES(123) 123 ; ERROR: syntax error at or near "123" at character 30 - LINE 2: VALUES(123) 123 - ^ -- with a tab CREATE TABLE foo (id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL); ERROR: syntax error at or near "NUL" at character 94 - LINE 3: id3 INTEGER NOT NUL, - ^ -- long line to be truncated on the left CREATE TABLE foo(id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL); ERROR: syntax error at or near "NUL" at character 90 - LINE 1: ...T NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, - ^ -- long line to be truncated on the right CREATE TABLE foo( id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL, id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL PRIMARY KEY); ERROR: syntax error at or near "NUL" at character 35 - LINE 2: id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQ... - ^ -- long line to be truncated both ways CREATE TABLE foo(id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL); ERROR: syntax error at or near "NUL" at character 90 - LINE 1: ...L, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 I... - ^ -- long line to be truncated on the left, many lines CREATE TEMPORARY --- 264,302 ---- *************** *** 390,397 **** NULL) ; ERROR: syntax error at or near "NUL" at character 101 - LINE 4: ...T NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, - ^ -- long line to be truncated on the right, many lines CREATE TEMPORARY --- 312,317 ---- *************** *** 400,407 **** id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL, id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL PRIMARY KEY) ; ERROR: syntax error at or near "NUL" at character 47 - LINE 5: id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQ... - ^ -- long line to be truncated both ways, many lines CREATE TEMPORARY --- 320,325 ---- *************** *** 413,420 **** idz INT4 UNIQUE NOT NULL, idv INT4 UNIQUE NOT NULL); ERROR: syntax error at or near "NUL" at character 157 - LINE 7: ...L, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 I... - ^ -- more than 10 lines... CREATE TEMPORARY --- 331,336 ---- *************** *** 439,446 **** NOT NULL); ERROR: syntax error at or near "NUL" at character 190 - LINE 16: ...L, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 I... - ^ -- Check that stack depth detection mechanism works and -- max_stack_depth is not set too high create function infinite_recurse() returns int as --- 355,360 ---- ======================================================================