diff options
Diffstat (limited to 'src/test')
55 files changed, 680 insertions, 3 deletions
diff --git a/src/test/regress/expected/abstime.out b/src/test/regress/expected/abstime.out index 309fb1d671..a04f091666 100644 --- a/src/test/regress/expected/abstime.out +++ b/src/test/regress/expected/abstime.out @@ -29,12 +29,18 @@ INSERT INTO ABSTIME_TBL (f1) VALUES (abstime 'May 10, 1947 23:59:12'); -- what happens if we specify slightly misformatted abstime? INSERT INTO ABSTIME_TBL (f1) VALUES ('Feb 35, 1946 10:00:00'); ERROR: date/time field value out of range: "Feb 35, 1946 10:00:00" +LINE 1: INSERT INTO ABSTIME_TBL (f1) VALUES ('Feb 35, 1946 10:00:00'... + ^ HINT: Perhaps you need a different "datestyle" setting. INSERT INTO ABSTIME_TBL (f1) VALUES ('Feb 28, 1984 25:08:10'); ERROR: date/time field value out of range: "Feb 28, 1984 25:08:10" +LINE 1: INSERT INTO ABSTIME_TBL (f1) VALUES ('Feb 28, 1984 25:08:10'... + ^ -- badly formatted abstimes: these should result in invalid abstimes INSERT INTO ABSTIME_TBL (f1) VALUES ('bad date format'); ERROR: invalid input syntax for type abstime: "bad date format" +LINE 1: INSERT INTO ABSTIME_TBL (f1) VALUES ('bad date format'); + ^ INSERT INTO ABSTIME_TBL (f1) VALUES ('Jun 10, 1843'); -- test abstime operators SELECT '' AS eight, * FROM ABSTIME_TBL; diff --git a/src/test/regress/expected/aggregates.out b/src/test/regress/expected/aggregates.out index ae65314166..46f6f18ed0 100644 --- a/src/test/regress/expected/aggregates.out +++ b/src/test/regress/expected/aggregates.out @@ -293,6 +293,8 @@ group by ten having exists (select 1 from onek b where sum(distinct a.four + b.four) = b.four); ERROR: aggregates not allowed in WHERE clause +LINE 4: where sum(distinct a.four + b.four) = b.four)... + ^ -- -- test for bitwise integer aggregates -- diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index daf9482c4a..15179540a2 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -112,6 +112,8 @@ SELECT * FROM tmp_new; ALTER TABLE tmp RENAME TO tmp_new2; SELECT * FROM tmp; -- should fail ERROR: relation "tmp" does not exist +LINE 1: SELECT * FROM tmp; + ^ SELECT * FROM tmp_new; tmptable ---------- @@ -780,8 +782,12 @@ LINE 1: update atacc1 set b = 2 where "........pg.dropped.1........"... -- INSERTs insert into atacc1 values (10, 11, 12, 13); ERROR: INSERT has more expressions than target columns +LINE 1: insert into atacc1 values (10, 11, 12, 13); + ^ insert into atacc1 values (default, 11, 12, 13); ERROR: INSERT has more expressions than target columns +LINE 1: insert into atacc1 values (default, 11, 12, 13); + ^ insert into atacc1 values (11, 12, 13); insert into atacc1 (a) values (10); ERROR: column "a" of relation "atacc1" does not exist diff --git a/src/test/regress/expected/arrays.out b/src/test/regress/expected/arrays.out index 5103d6868d..bcf5280b14 100644 --- a/src/test/regress/expected/arrays.out +++ b/src/test/regress/expected/arrays.out @@ -775,16 +775,28 @@ select 'foo' ilike all (array['F%', '%O']); -- t -- none of the following should be accepted select '{{1,{2}},{2,3}}'::text[]; ERROR: malformed array literal: "{{1,{2}},{2,3}}" +LINE 1: select '{{1,{2}},{2,3}}'::text[]; + ^ select '{{},{}}'::text[]; ERROR: malformed array literal: "{{},{}}" +LINE 1: select '{{},{}}'::text[]; + ^ select E'{{1,2},\\{2,3}}'::text[]; ERROR: malformed array literal: "{{1,2},\{2,3}}" +LINE 1: select E'{{1,2},\\{2,3}}'::text[]; + ^ select '{{"1 2" x},{3}}'::text[]; ERROR: malformed array literal: "{{"1 2" x},{3}}" +LINE 1: select '{{"1 2" x},{3}}'::text[]; + ^ select '{}}'::text[]; ERROR: malformed array literal: "{}}" +LINE 1: select '{}}'::text[]; + ^ select '{ }}'::text[]; ERROR: malformed array literal: "{ }}" +LINE 1: select '{ }}'::text[]; + ^ select array[]; ERROR: cannot determine type of empty array LINE 1: select array[]; diff --git a/src/test/regress/expected/boolean.out b/src/test/regress/expected/boolean.out index 511987e8b9..e66f33702b 100644 --- a/src/test/regress/expected/boolean.out +++ b/src/test/regress/expected/boolean.out @@ -137,6 +137,8 @@ INSERT INTO BOOLTBL2 (f1) VALUES (bool 'FALSE'); INSERT INTO BOOLTBL2 (f1) VALUES (bool 'XXX'); ERROR: invalid input syntax for type boolean: "XXX" +LINE 2: VALUES (bool 'XXX'); + ^ -- BOOLTBL2 should be full of false's at this point SELECT '' AS f_4, BOOLTBL2.* FROM BOOLTBL2; f_4 | f1 diff --git a/src/test/regress/expected/box.out b/src/test/regress/expected/box.out index cd2179f092..2a94e33465 100644 --- a/src/test/regress/expected/box.out +++ b/src/test/regress/expected/box.out @@ -25,8 +25,12 @@ INSERT INTO BOX_TBL (f1) VALUES ('(3.0, 3.0,3.0,3.0)'); -- badly formatted box inputs INSERT INTO BOX_TBL (f1) VALUES ('(2.3, 4.5)'); ERROR: invalid input syntax for type box: "(2.3, 4.5)" +LINE 1: INSERT INTO BOX_TBL (f1) VALUES ('(2.3, 4.5)'); + ^ INSERT INTO BOX_TBL (f1) VALUES ('asdfasdf(ad'); ERROR: invalid input syntax for type box: "asdfasdf(ad" +LINE 1: INSERT INTO BOX_TBL (f1) VALUES ('asdfasdf(ad'); + ^ SELECT '' AS four, * FROM BOX_TBL; four | f1 ------+--------------------- diff --git a/src/test/regress/expected/circle.out b/src/test/regress/expected/circle.out index a63e348aca..9ba4a0495d 100644 --- a/src/test/regress/expected/circle.out +++ b/src/test/regress/expected/circle.out @@ -11,10 +11,16 @@ INSERT INTO CIRCLE_TBL VALUES ('<(100,1),115>'); -- bad values INSERT INTO CIRCLE_TBL VALUES ('<(-100,0),-100>'); ERROR: invalid input syntax for type circle: "<(-100,0),-100>" +LINE 1: INSERT INTO CIRCLE_TBL VALUES ('<(-100,0),-100>'); + ^ INSERT INTO CIRCLE_TBL VALUES ('1abc,3,5'); ERROR: invalid input syntax for type circle: "1abc,3,5" +LINE 1: INSERT INTO CIRCLE_TBL VALUES ('1abc,3,5'); + ^ INSERT INTO CIRCLE_TBL VALUES ('(3,(1,2),3)'); ERROR: invalid input syntax for type circle: "(3,(1,2),3)" +LINE 1: INSERT INTO CIRCLE_TBL VALUES ('(3,(1,2),3)'); + ^ SELECT * FROM CIRCLE_TBL; f1 ---------------- diff --git a/src/test/regress/expected/create_type.out b/src/test/regress/expected/create_type.out index 72556a88f8..1d3a22612d 100644 --- a/src/test/regress/expected/create_type.out +++ b/src/test/regress/expected/create_type.out @@ -107,6 +107,8 @@ DROP TABLE default_test; -- (we have borrowed numeric's typmod functions) CREATE TEMP TABLE mytab (foo widget(42,13,7)); -- should fail ERROR: invalid NUMERIC type modifier +LINE 1: CREATE TEMP TABLE mytab (foo widget(42,13,7)); + ^ CREATE TEMP TABLE mytab (foo widget(42,13)); SELECT format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid = 'mytab'::regclass AND attnum > 0; diff --git a/src/test/regress/expected/date.out b/src/test/regress/expected/date.out index 24018de560..a4acf3e9c9 100644 --- a/src/test/regress/expected/date.out +++ b/src/test/regress/expected/date.out @@ -11,6 +11,8 @@ INSERT INTO DATE_TBL VALUES ('1996-03-02'); INSERT INTO DATE_TBL VALUES ('1997-02-28'); INSERT INTO DATE_TBL VALUES ('1997-02-29'); ERROR: date/time field value out of range: "1997-02-29" +LINE 1: INSERT INTO DATE_TBL VALUES ('1997-02-29'); + ^ INSERT INTO DATE_TBL VALUES ('1997-03-01'); INSERT INTO DATE_TBL VALUES ('1997-03-02'); INSERT INTO DATE_TBL VALUES ('2000-04-01'); @@ -87,12 +89,18 @@ SELECT date '1999-01-18'; SELECT date '1/8/1999'; ERROR: date/time field value out of range: "1/8/1999" +LINE 1: SELECT date '1/8/1999'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1/18/1999'; ERROR: date/time field value out of range: "1/18/1999" +LINE 1: SELECT date '1/18/1999'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '18/1/1999'; ERROR: date/time field value out of range: "18/1/1999" +LINE 1: SELECT date '18/1/1999'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '01/02/03'; date @@ -126,6 +134,8 @@ SELECT date 'J2451187'; SELECT date 'January 8, 99 BC'; ERROR: date/time field value out of range: "January 8, 99 BC" +LINE 1: SELECT date 'January 8, 99 BC'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '99-Jan-08'; date @@ -141,6 +151,8 @@ SELECT date '1999-Jan-08'; SELECT date '08-Jan-99'; ERROR: date/time field value out of range: "08-Jan-99" +LINE 1: SELECT date '08-Jan-99'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '08-Jan-1999'; date @@ -150,6 +162,8 @@ SELECT date '08-Jan-1999'; SELECT date 'Jan-08-99'; ERROR: date/time field value out of range: "Jan-08-99" +LINE 1: SELECT date 'Jan-08-99'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date 'Jan-08-1999'; date @@ -159,8 +173,12 @@ SELECT date 'Jan-08-1999'; SELECT date '99-08-Jan'; ERROR: invalid input syntax for type date: "99-08-Jan" +LINE 1: SELECT date '99-08-Jan'; + ^ SELECT date '1999-08-Jan'; ERROR: invalid input syntax for type date: "1999-08-Jan" +LINE 1: SELECT date '1999-08-Jan'; + ^ SELECT date '99 Jan 08'; date ------------ @@ -175,6 +193,8 @@ SELECT date '1999 Jan 08'; SELECT date '08 Jan 99'; ERROR: date/time field value out of range: "08 Jan 99" +LINE 1: SELECT date '08 Jan 99'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '08 Jan 1999'; date @@ -184,6 +204,8 @@ SELECT date '08 Jan 1999'; SELECT date 'Jan 08 99'; ERROR: date/time field value out of range: "Jan 08 99" +LINE 1: SELECT date 'Jan 08 99'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date 'Jan 08 1999'; date @@ -217,15 +239,23 @@ SELECT date '1999-01-08'; SELECT date '08-01-99'; ERROR: date/time field value out of range: "08-01-99" +LINE 1: SELECT date '08-01-99'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '08-01-1999'; ERROR: date/time field value out of range: "08-01-1999" +LINE 1: SELECT date '08-01-1999'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '01-08-99'; ERROR: date/time field value out of range: "01-08-99" +LINE 1: SELECT date '01-08-99'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '01-08-1999'; ERROR: date/time field value out of range: "01-08-1999" +LINE 1: SELECT date '01-08-1999'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '99-08-01'; date @@ -253,15 +283,23 @@ SELECT date '1999 01 08'; SELECT date '08 01 99'; ERROR: date/time field value out of range: "08 01 99" +LINE 1: SELECT date '08 01 99'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '08 01 1999'; ERROR: date/time field value out of range: "08 01 1999" +LINE 1: SELECT date '08 01 1999'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '01 08 99'; ERROR: date/time field value out of range: "01 08 99" +LINE 1: SELECT date '01 08 99'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '01 08 1999'; ERROR: date/time field value out of range: "01 08 1999" +LINE 1: SELECT date '01 08 1999'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '99 08 01'; date @@ -302,6 +340,8 @@ SELECT date '1/8/1999'; SELECT date '1/18/1999'; ERROR: date/time field value out of range: "1/18/1999" +LINE 1: SELECT date '1/18/1999'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '18/1/1999'; date @@ -347,6 +387,8 @@ SELECT date 'January 8, 99 BC'; SELECT date '99-Jan-08'; ERROR: date/time field value out of range: "99-Jan-08" +LINE 1: SELECT date '99-Jan-08'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1999-Jan-08'; date @@ -380,10 +422,16 @@ SELECT date 'Jan-08-1999'; SELECT date '99-08-Jan'; ERROR: invalid input syntax for type date: "99-08-Jan" +LINE 1: SELECT date '99-08-Jan'; + ^ SELECT date '1999-08-Jan'; ERROR: invalid input syntax for type date: "1999-08-Jan" +LINE 1: SELECT date '1999-08-Jan'; + ^ SELECT date '99 Jan 08'; ERROR: date/time field value out of range: "99 Jan 08" +LINE 1: SELECT date '99 Jan 08'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1999 Jan 08'; date @@ -417,6 +465,8 @@ SELECT date 'Jan 08 1999'; SELECT date '99 08 Jan'; ERROR: invalid input syntax for type date: "99 08 Jan" +LINE 1: SELECT date '99 08 Jan'; + ^ SELECT date '1999 08 Jan'; date ------------ @@ -425,6 +475,8 @@ SELECT date '1999 08 Jan'; SELECT date '99-01-08'; ERROR: date/time field value out of range: "99-01-08" +LINE 1: SELECT date '99-01-08'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1999-01-08'; date @@ -458,6 +510,8 @@ SELECT date '01-08-1999'; SELECT date '99-08-01'; ERROR: date/time field value out of range: "99-08-01" +LINE 1: SELECT date '99-08-01'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1999-08-01'; date @@ -467,6 +521,8 @@ SELECT date '1999-08-01'; SELECT date '99 01 08'; ERROR: date/time field value out of range: "99 01 08" +LINE 1: SELECT date '99 01 08'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1999 01 08'; date @@ -500,6 +556,8 @@ SELECT date '01 08 1999'; SELECT date '99 08 01'; ERROR: date/time field value out of range: "99 08 01" +LINE 1: SELECT date '99 08 01'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1999 08 01'; date @@ -540,6 +598,8 @@ SELECT date '1/18/1999'; SELECT date '18/1/1999'; ERROR: date/time field value out of range: "18/1/1999" +LINE 1: SELECT date '18/1/1999'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '01/02/03'; date @@ -579,6 +639,8 @@ SELECT date 'January 8, 99 BC'; SELECT date '99-Jan-08'; ERROR: date/time field value out of range: "99-Jan-08" +LINE 1: SELECT date '99-Jan-08'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1999-Jan-08'; date @@ -612,10 +674,16 @@ SELECT date 'Jan-08-1999'; SELECT date '99-08-Jan'; ERROR: invalid input syntax for type date: "99-08-Jan" +LINE 1: SELECT date '99-08-Jan'; + ^ SELECT date '1999-08-Jan'; ERROR: invalid input syntax for type date: "1999-08-Jan" +LINE 1: SELECT date '1999-08-Jan'; + ^ SELECT date '99 Jan 08'; ERROR: invalid input syntax for type date: "99 Jan 08" +LINE 1: SELECT date '99 Jan 08'; + ^ SELECT date '1999 Jan 08'; date ------------ @@ -648,6 +716,8 @@ SELECT date 'Jan 08 1999'; SELECT date '99 08 Jan'; ERROR: invalid input syntax for type date: "99 08 Jan" +LINE 1: SELECT date '99 08 Jan'; + ^ SELECT date '1999 08 Jan'; date ------------ @@ -656,6 +726,8 @@ SELECT date '1999 08 Jan'; SELECT date '99-01-08'; ERROR: date/time field value out of range: "99-01-08" +LINE 1: SELECT date '99-01-08'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1999-01-08'; date @@ -689,6 +761,8 @@ SELECT date '01-08-1999'; SELECT date '99-08-01'; ERROR: date/time field value out of range: "99-08-01" +LINE 1: SELECT date '99-08-01'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1999-08-01'; date @@ -698,6 +772,8 @@ SELECT date '1999-08-01'; SELECT date '99 01 08'; ERROR: date/time field value out of range: "99 01 08" +LINE 1: SELECT date '99 01 08'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1999 01 08'; date @@ -731,6 +807,8 @@ SELECT date '01 08 1999'; SELECT date '99 08 01'; ERROR: date/time field value out of range: "99 08 01" +LINE 1: SELECT date '99 08 01'; + ^ HINT: Perhaps you need a different "datestyle" setting. SELECT date '1999 08 01'; date diff --git a/src/test/regress/expected/enum.out b/src/test/regress/expected/enum.out index 4fa2d07ada..56240c0e7a 100644 --- a/src/test/regress/expected/enum.out +++ b/src/test/regress/expected/enum.out @@ -22,6 +22,8 @@ SELECT 'red'::rainbow; SELECT 'mauve'::rainbow; ERROR: invalid input value for enum rainbow: "mauve" +LINE 1: SELECT 'mauve'::rainbow; + ^ -- -- Basic table creation, row selection -- diff --git a/src/test/regress/expected/errors.out b/src/test/regress/expected/errors.out index 257722e94a..55822e0b9b 100644 --- a/src/test/regress/expected/errors.out +++ b/src/test/regress/expected/errors.out @@ -25,6 +25,8 @@ LINE 1: select; -- no such relation select * from nonesuch; ERROR: relation "nonesuch" does not exist +LINE 1: select * from nonesuch; + ^ -- missing target list select from pg_database; ERROR: syntax error at or near "from" @@ -66,6 +68,8 @@ LINE 1: delete from; -- no such relation delete from nonesuch; ERROR: relation "nonesuch" does not exist +LINE 1: delete from nonesuch; + ^ -- -- DROP @@ -245,6 +249,8 @@ LINE 1: drop operator === (); -- no such operator drop operator === (int4); ERROR: missing argument +LINE 1: drop operator === (int4); + ^ HINT: Use NONE to denote the missing argument of a unary operator. -- no such operator by that name drop operator === (int4, int4); @@ -252,6 +258,8 @@ ERROR: operator does not exist: integer === integer -- no such type1 drop operator = (nonesuch); ERROR: missing argument +LINE 1: drop operator = (nonesuch); + ^ HINT: Use NONE to denote the missing argument of a unary operator. -- no such type1 drop operator = ( , int4); diff --git a/src/test/regress/expected/float4-exp-three-digits.out b/src/test/regress/expected/float4-exp-three-digits.out index fd8d0b319e..b849910151 100644 --- a/src/test/regress/expected/float4-exp-three-digits.out +++ b/src/test/regress/expected/float4-exp-three-digits.out @@ -10,29 +10,53 @@ INSERT INTO FLOAT4_TBL(f1) VALUES ('1.2345678901234e-20'); -- test for over and under flow INSERT INTO FLOAT4_TBL(f1) VALUES ('10e70'); ERROR: value out of range: overflow +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('10e70'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e70'); ERROR: value out of range: overflow +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e70'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('10e-70'); ERROR: value out of range: underflow +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('10e-70'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e-70'); ERROR: value out of range: underflow +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e-70'); + ^ -- bad input INSERT INTO FLOAT4_TBL(f1) VALUES (''); ERROR: invalid input syntax for type real: "" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES (''); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES (' '); ERROR: invalid input syntax for type real: " " +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES (' '); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('xyz'); ERROR: invalid input syntax for type real: "xyz" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('xyz'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('5.0.0'); ERROR: invalid input syntax for type real: "5.0.0" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('5.0.0'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('5 . 0'); ERROR: invalid input syntax for type real: "5 . 0" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('5 . 0'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('5. 0'); ERROR: invalid input syntax for type real: "5. 0" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('5. 0'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES (' - 3.0'); ERROR: invalid input syntax for type real: " - 3.0" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES (' - 3.0'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('123 5'); ERROR: invalid input syntax for type real: "123 5" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('123 5'); + ^ -- special inputs SELECT 'NaN'::float4; float4 @@ -67,10 +91,16 @@ SELECT ' -INFINiTY '::float4; -- bad special inputs SELECT 'N A N'::float4; ERROR: invalid input syntax for type real: "N A N" +LINE 1: SELECT 'N A N'::float4; + ^ SELECT 'NaN x'::float4; ERROR: invalid input syntax for type real: "NaN x" +LINE 1: SELECT 'NaN x'::float4; + ^ SELECT ' INFINITY x'::float4; ERROR: invalid input syntax for type real: " INFINITY x" +LINE 1: SELECT ' INFINITY x'::float4; + ^ SELECT 'Infinity'::float4 + 100.0; ?column? ---------- diff --git a/src/test/regress/expected/float4.out b/src/test/regress/expected/float4.out index b3bc431a15..2c19e7eb08 100644 --- a/src/test/regress/expected/float4.out +++ b/src/test/regress/expected/float4.out @@ -10,29 +10,53 @@ INSERT INTO FLOAT4_TBL(f1) VALUES ('1.2345678901234e-20'); -- test for over and under flow INSERT INTO FLOAT4_TBL(f1) VALUES ('10e70'); ERROR: value out of range: overflow +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('10e70'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e70'); ERROR: value out of range: overflow +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e70'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('10e-70'); ERROR: value out of range: underflow +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('10e-70'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e-70'); ERROR: value out of range: underflow +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e-70'); + ^ -- bad input INSERT INTO FLOAT4_TBL(f1) VALUES (''); ERROR: invalid input syntax for type real: "" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES (''); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES (' '); ERROR: invalid input syntax for type real: " " +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES (' '); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('xyz'); ERROR: invalid input syntax for type real: "xyz" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('xyz'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('5.0.0'); ERROR: invalid input syntax for type real: "5.0.0" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('5.0.0'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('5 . 0'); ERROR: invalid input syntax for type real: "5 . 0" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('5 . 0'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('5. 0'); ERROR: invalid input syntax for type real: "5. 0" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('5. 0'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES (' - 3.0'); ERROR: invalid input syntax for type real: " - 3.0" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES (' - 3.0'); + ^ INSERT INTO FLOAT4_TBL(f1) VALUES ('123 5'); ERROR: invalid input syntax for type real: "123 5" +LINE 1: INSERT INTO FLOAT4_TBL(f1) VALUES ('123 5'); + ^ -- special inputs SELECT 'NaN'::float4; float4 @@ -67,10 +91,16 @@ SELECT ' -INFINiTY '::float4; -- bad special inputs SELECT 'N A N'::float4; ERROR: invalid input syntax for type real: "N A N" +LINE 1: SELECT 'N A N'::float4; + ^ SELECT 'NaN x'::float4; ERROR: invalid input syntax for type real: "NaN x" +LINE 1: SELECT 'NaN x'::float4; + ^ SELECT ' INFINITY x'::float4; ERROR: invalid input syntax for type real: " INFINITY x" +LINE 1: SELECT ' INFINITY x'::float4; + ^ SELECT 'Infinity'::float4 + 100.0; ?column? ---------- diff --git a/src/test/regress/expected/float8-exp-three-digits-win32.out b/src/test/regress/expected/float8-exp-three-digits-win32.out index 55615c498f..4d133b42dc 100644 --- a/src/test/regress/expected/float8-exp-three-digits-win32.out +++ b/src/test/regress/expected/float8-exp-three-digits-win32.out @@ -10,29 +10,53 @@ INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200'); -- test for underflow and overflow handling SELECT '10e400'::float8; ERROR: "10e400" is out of range for type double precision +LINE 1: SELECT '10e400'::float8; + ^ SELECT '-10e400'::float8; ERROR: "-10e400" is out of range for type double precision +LINE 1: SELECT '-10e400'::float8; + ^ SELECT '10e-400'::float8; ERROR: "10e-400" is out of range for type double precision +LINE 1: SELECT '10e-400'::float8; + ^ SELECT '-10e-400'::float8; ERROR: "-10e-400" is out of range for type double precision +LINE 1: SELECT '-10e-400'::float8; + ^ -- bad input INSERT INTO FLOAT8_TBL(f1) VALUES (''); ERROR: invalid input syntax for type double precision: "" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (''); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES (' '); ERROR: invalid input syntax for type double precision: " " +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (' '); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('xyz'); ERROR: invalid input syntax for type double precision: "xyz" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('xyz'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5.0.0'); ERROR: invalid input syntax for type double precision: "5.0.0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5.0.0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5 . 0'); ERROR: invalid input syntax for type double precision: "5 . 0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5 . 0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5. 0'); ERROR: invalid input syntax for type double precision: "5. 0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5. 0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES (' - 3'); ERROR: invalid input syntax for type double precision: " - 3" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (' - 3'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('123 5'); ERROR: invalid input syntax for type double precision: "123 5" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('123 5'); + ^ -- special inputs SELECT 'NaN'::float8; float8 @@ -67,10 +91,16 @@ SELECT ' -INFINiTY '::float8; -- bad special inputs SELECT 'N A N'::float8; ERROR: invalid input syntax for type double precision: "N A N" +LINE 1: SELECT 'N A N'::float8; + ^ SELECT 'NaN x'::float8; ERROR: invalid input syntax for type double precision: "NaN x" +LINE 1: SELECT 'NaN x'::float8; + ^ SELECT ' INFINITY x'::float8; ERROR: invalid input syntax for type double precision: " INFINITY x" +LINE 1: SELECT ' INFINITY x'::float8; + ^ SELECT 'Infinity'::float8 + 100.0; ?column? ---------- @@ -376,12 +406,20 @@ SELECT '' AS five, * FROM FLOAT8_TBL; -- test for over- and underflow INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400'); ERROR: "10e400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400'); ERROR: "-10e400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400'); ERROR: "10e-400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400'); ERROR: "-10e-400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400'); + ^ -- maintain external table consistency across platforms -- delete all values and reinsert well-behaved ones DELETE FROM FLOAT8_TBL; diff --git a/src/test/regress/expected/float8-small-is-zero.out b/src/test/regress/expected/float8-small-is-zero.out index 50af50556e..6c756a6f8e 100644 --- a/src/test/regress/expected/float8-small-is-zero.out +++ b/src/test/regress/expected/float8-small-is-zero.out @@ -10,8 +10,12 @@ INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200'); -- test for underflow and overflow handling SELECT '10e400'::float8; ERROR: "10e400" is out of range for type double precision +LINE 1: SELECT '10e400'::float8; + ^ SELECT '-10e400'::float8; ERROR: "-10e400" is out of range for type double precision +LINE 1: SELECT '-10e400'::float8; + ^ SELECT '10e-400'::float8; float8 -------- @@ -27,20 +31,36 @@ SELECT '-10e-400'::float8; -- bad input INSERT INTO FLOAT8_TBL(f1) VALUES (''); ERROR: invalid input syntax for type double precision: "" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (''); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES (' '); ERROR: invalid input syntax for type double precision: " " +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (' '); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('xyz'); ERROR: invalid input syntax for type double precision: "xyz" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('xyz'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5.0.0'); ERROR: invalid input syntax for type double precision: "5.0.0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5.0.0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5 . 0'); ERROR: invalid input syntax for type double precision: "5 . 0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5 . 0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5. 0'); ERROR: invalid input syntax for type double precision: "5. 0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5. 0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES (' - 3'); ERROR: invalid input syntax for type double precision: " - 3" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (' - 3'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('123 5'); ERROR: invalid input syntax for type double precision: "123 5" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('123 5'); + ^ -- special inputs SELECT 'NaN'::float8; float8 @@ -75,10 +95,16 @@ SELECT ' -INFINiTY '::float8; -- bad special inputs SELECT 'N A N'::float8; ERROR: invalid input syntax for type double precision: "N A N" +LINE 1: SELECT 'N A N'::float8; + ^ SELECT 'NaN x'::float8; ERROR: invalid input syntax for type double precision: "NaN x" +LINE 1: SELECT 'NaN x'::float8; + ^ SELECT ' INFINITY x'::float8; ERROR: invalid input syntax for type double precision: " INFINITY x" +LINE 1: SELECT ' INFINITY x'::float8; + ^ SELECT 'Infinity'::float8 + 100.0; ?column? ---------- @@ -384,8 +410,12 @@ SELECT '' AS five, * FROM FLOAT8_TBL; -- test for over- and underflow INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400'); ERROR: "10e400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400'); ERROR: "-10e400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400'); INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400'); -- maintain external table consistency across platforms diff --git a/src/test/regress/expected/float8-small-is-zero_1.out b/src/test/regress/expected/float8-small-is-zero_1.out index 83919802ca..8b25f0955c 100644 --- a/src/test/regress/expected/float8-small-is-zero_1.out +++ b/src/test/regress/expected/float8-small-is-zero_1.out @@ -10,8 +10,12 @@ INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200'); -- test for underflow and overflow handling SELECT '10e400'::float8; ERROR: "10e400" is out of range for type double precision +LINE 1: SELECT '10e400'::float8; + ^ SELECT '-10e400'::float8; ERROR: "-10e400" is out of range for type double precision +LINE 1: SELECT '-10e400'::float8; + ^ SELECT '10e-400'::float8; float8 -------- @@ -27,20 +31,36 @@ SELECT '-10e-400'::float8; -- bad input INSERT INTO FLOAT8_TBL(f1) VALUES (''); ERROR: invalid input syntax for type double precision: "" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (''); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES (' '); ERROR: invalid input syntax for type double precision: " " +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (' '); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('xyz'); ERROR: invalid input syntax for type double precision: "xyz" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('xyz'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5.0.0'); ERROR: invalid input syntax for type double precision: "5.0.0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5.0.0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5 . 0'); ERROR: invalid input syntax for type double precision: "5 . 0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5 . 0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5. 0'); ERROR: invalid input syntax for type double precision: "5. 0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5. 0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES (' - 3'); ERROR: invalid input syntax for type double precision: " - 3" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (' - 3'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('123 5'); ERROR: invalid input syntax for type double precision: "123 5" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('123 5'); + ^ -- special inputs SELECT 'NaN'::float8; float8 @@ -75,10 +95,16 @@ SELECT ' -INFINiTY '::float8; -- bad special inputs SELECT 'N A N'::float8; ERROR: invalid input syntax for type double precision: "N A N" +LINE 1: SELECT 'N A N'::float8; + ^ SELECT 'NaN x'::float8; ERROR: invalid input syntax for type double precision: "NaN x" +LINE 1: SELECT 'NaN x'::float8; + ^ SELECT ' INFINITY x'::float8; ERROR: invalid input syntax for type double precision: " INFINITY x" +LINE 1: SELECT ' INFINITY x'::float8; + ^ SELECT 'Infinity'::float8 + 100.0; ?column? ---------- @@ -384,8 +410,12 @@ SELECT '' AS five, * FROM FLOAT8_TBL; -- test for over- and underflow INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400'); ERROR: "10e400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400'); ERROR: "-10e400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400'); INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400'); -- maintain external table consistency across platforms diff --git a/src/test/regress/expected/float8.out b/src/test/regress/expected/float8.out index f81d9b2bac..e9e71bb7aa 100644 --- a/src/test/regress/expected/float8.out +++ b/src/test/regress/expected/float8.out @@ -10,29 +10,53 @@ INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200'); -- test for underflow and overflow handling SELECT '10e400'::float8; ERROR: "10e400" is out of range for type double precision +LINE 1: SELECT '10e400'::float8; + ^ SELECT '-10e400'::float8; ERROR: "-10e400" is out of range for type double precision +LINE 1: SELECT '-10e400'::float8; + ^ SELECT '10e-400'::float8; ERROR: "10e-400" is out of range for type double precision +LINE 1: SELECT '10e-400'::float8; + ^ SELECT '-10e-400'::float8; ERROR: "-10e-400" is out of range for type double precision +LINE 1: SELECT '-10e-400'::float8; + ^ -- bad input INSERT INTO FLOAT8_TBL(f1) VALUES (''); ERROR: invalid input syntax for type double precision: "" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (''); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES (' '); ERROR: invalid input syntax for type double precision: " " +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (' '); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('xyz'); ERROR: invalid input syntax for type double precision: "xyz" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('xyz'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5.0.0'); ERROR: invalid input syntax for type double precision: "5.0.0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5.0.0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5 . 0'); ERROR: invalid input syntax for type double precision: "5 . 0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5 . 0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('5. 0'); ERROR: invalid input syntax for type double precision: "5. 0" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('5. 0'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES (' - 3'); ERROR: invalid input syntax for type double precision: " - 3" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES (' - 3'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('123 5'); ERROR: invalid input syntax for type double precision: "123 5" +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('123 5'); + ^ -- special inputs SELECT 'NaN'::float8; float8 @@ -67,10 +91,16 @@ SELECT ' -INFINiTY '::float8; -- bad special inputs SELECT 'N A N'::float8; ERROR: invalid input syntax for type double precision: "N A N" +LINE 1: SELECT 'N A N'::float8; + ^ SELECT 'NaN x'::float8; ERROR: invalid input syntax for type double precision: "NaN x" +LINE 1: SELECT 'NaN x'::float8; + ^ SELECT ' INFINITY x'::float8; ERROR: invalid input syntax for type double precision: " INFINITY x" +LINE 1: SELECT ' INFINITY x'::float8; + ^ SELECT 'Infinity'::float8 + 100.0; ?column? ---------- @@ -376,12 +406,20 @@ SELECT '' AS five, * FROM FLOAT8_TBL; -- test for over- and underflow INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400'); ERROR: "10e400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400'); ERROR: "-10e400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400'); ERROR: "10e-400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400'); + ^ INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400'); ERROR: "-10e-400" is out of range for type double precision +LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400'); + ^ -- maintain external table consistency across platforms -- delete all values and reinsert well-behaved ones DELETE FROM FLOAT8_TBL; diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out index 9c101ad9a0..926a2cfde6 100644 --- a/src/test/regress/expected/horology.out +++ b/src/test/regress/expected/horology.out @@ -80,6 +80,8 @@ SELECT timestamp with time zone '12/27/2001 04:05:06.789-08'; -- should fail in mdy mode: SELECT timestamp with time zone '27/12/2001 04:05:06.789-08'; ERROR: date/time field value out of range: "27/12/2001 04:05:06.789-08" +LINE 1: SELECT timestamp with time zone '27/12/2001 04:05:06.789-08'... + ^ HINT: Perhaps you need a different "datestyle" setting. set datestyle to dmy; SELECT timestamp with time zone '27/12/2001 04:05:06.789-08'; @@ -841,11 +843,11 @@ SELECT time '03:30' + interval '1 month 04:01' AS "07:31:00"; SELECT CAST(time with time zone '01:02-08' AS interval) AS "+00:01"; ERROR: cannot cast type time with time zone to interval LINE 1: SELECT CAST(time with time zone '01:02-08' AS interval) AS "... - ^ + ^ SELECT CAST(interval '02:03' AS time with time zone) AS "02:03:00-08"; ERROR: cannot cast type interval to time with time zone LINE 1: SELECT CAST(interval '02:03' AS time with time zone) AS "02:... - ^ + ^ SELECT time with time zone '01:30-08' - interval '02:01' AS "23:29:00-08"; 23:29:00-08 ------------- diff --git a/src/test/regress/expected/inet.out b/src/test/regress/expected/inet.out index 9ecb37e29b..abb59d4acf 100644 --- a/src/test/regress/expected/inet.out +++ b/src/test/regress/expected/inet.out @@ -25,15 +25,23 @@ INSERT INTO INET_TBL (c, i) VALUES ('::ffff:1.2.3.4', '::4.3.2.1/24'); -- check that CIDR rejects invalid input: INSERT INTO INET_TBL (c, i) VALUES ('192.168.1.2/30', '192.168.1.226'); ERROR: invalid cidr value: "192.168.1.2/30" +LINE 1: INSERT INTO INET_TBL (c, i) VALUES ('192.168.1.2/30', '192.1... + ^ DETAIL: Value has bits set to right of mask. INSERT INTO INET_TBL (c, i) VALUES ('1234::1234::1234', '::1.2.3.4'); ERROR: invalid input syntax for type cidr: "1234::1234::1234" +LINE 1: INSERT INTO INET_TBL (c, i) VALUES ('1234::1234::1234', '::1... + ^ -- check that CIDR rejects invalid input when converting from text: INSERT INTO INET_TBL (c, i) VALUES (cidr('192.168.1.2/30'), '192.168.1.226'); ERROR: invalid cidr value: "192.168.1.2/30" +LINE 1: INSERT INTO INET_TBL (c, i) VALUES (cidr('192.168.1.2/30'), ... + ^ DETAIL: Value has bits set to right of mask. INSERT INTO INET_TBL (c, i) VALUES (cidr('ffff:ffff:ffff:ffff::/24'), '::192.168.1.226'); ERROR: invalid cidr value: "ffff:ffff:ffff:ffff::/24" +LINE 1: INSERT INTO INET_TBL (c, i) VALUES (cidr('ffff:ffff:ffff:fff... + ^ DETAIL: Value has bits set to right of mask. SELECT '' AS ten, c AS cidr, i AS inet FROM INET_TBL; ten | cidr | inet diff --git a/src/test/regress/expected/insert.out b/src/test/regress/expected/insert.out index b4e6c306b4..d8510ea334 100644 --- a/src/test/regress/expected/insert.out +++ b/src/test/regress/expected/insert.out @@ -22,12 +22,20 @@ select * from inserttest; -- insert into inserttest (col1, col2, col3) values (DEFAULT, DEFAULT); ERROR: INSERT has more target columns than expressions +LINE 1: insert into inserttest (col1, col2, col3) values (DEFAULT, D... + ^ insert into inserttest (col1, col2, col3) values (1, 2); ERROR: INSERT has more target columns than expressions +LINE 1: insert into inserttest (col1, col2, col3) values (1, 2); + ^ insert into inserttest (col1) values (1, 2); ERROR: INSERT has more expressions than target columns +LINE 1: insert into inserttest (col1) values (1, 2); + ^ insert into inserttest (col1) values (DEFAULT, DEFAULT); ERROR: INSERT has more expressions than target columns +LINE 1: insert into inserttest (col1) values (DEFAULT, DEFAULT); + ^ select * from inserttest; col1 | col2 | col3 ------+------+--------- diff --git a/src/test/regress/expected/int2.out b/src/test/regress/expected/int2.out index e34e85bc97..61ac956cb7 100644 --- a/src/test/regress/expected/int2.out +++ b/src/test/regress/expected/int2.out @@ -9,24 +9,40 @@ INSERT INTO INT2_TBL(f1) VALUES (' 1234 '); INSERT INTO INT2_TBL(f1) VALUES (' -1234'); INSERT INTO INT2_TBL(f1) VALUES ('34.5'); ERROR: invalid input syntax for integer: "34.5" +LINE 1: INSERT INTO INT2_TBL(f1) VALUES ('34.5'); + ^ -- largest and smallest values INSERT INTO INT2_TBL(f1) VALUES ('32767'); INSERT INTO INT2_TBL(f1) VALUES ('-32767'); -- bad input values -- should give errors INSERT INTO INT2_TBL(f1) VALUES ('100000'); ERROR: value "100000" is out of range for type smallint +LINE 1: INSERT INTO INT2_TBL(f1) VALUES ('100000'); + ^ INSERT INTO INT2_TBL(f1) VALUES ('asdf'); ERROR: invalid input syntax for integer: "asdf" +LINE 1: INSERT INTO INT2_TBL(f1) VALUES ('asdf'); + ^ INSERT INTO INT2_TBL(f1) VALUES (' '); ERROR: invalid input syntax for integer: " " +LINE 1: INSERT INTO INT2_TBL(f1) VALUES (' '); + ^ INSERT INTO INT2_TBL(f1) VALUES ('- 1234'); ERROR: invalid input syntax for integer: "- 1234" +LINE 1: INSERT INTO INT2_TBL(f1) VALUES ('- 1234'); + ^ INSERT INTO INT2_TBL(f1) VALUES ('4 444'); ERROR: invalid input syntax for integer: "4 444" +LINE 1: INSERT INTO INT2_TBL(f1) VALUES ('4 444'); + ^ INSERT INTO INT2_TBL(f1) VALUES ('123 dt'); ERROR: invalid input syntax for integer: "123 dt" +LINE 1: INSERT INTO INT2_TBL(f1) VALUES ('123 dt'); + ^ INSERT INTO INT2_TBL(f1) VALUES (''); ERROR: invalid input syntax for integer: "" +LINE 1: INSERT INTO INT2_TBL(f1) VALUES (''); + ^ SELECT '' AS five, * FROM INT2_TBL; five | f1 ------+-------- diff --git a/src/test/regress/expected/int4.out b/src/test/regress/expected/int4.out index 3e0eff13a3..a21bbda2c9 100644 --- a/src/test/regress/expected/int4.out +++ b/src/test/regress/expected/int4.out @@ -9,24 +9,40 @@ INSERT INTO INT4_TBL(f1) VALUES ('123456 '); INSERT INTO INT4_TBL(f1) VALUES (' -123456'); INSERT INTO INT4_TBL(f1) VALUES ('34.5'); ERROR: invalid input syntax for integer: "34.5" +LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('34.5'); + ^ -- largest and smallest values INSERT INTO INT4_TBL(f1) VALUES ('2147483647'); INSERT INTO INT4_TBL(f1) VALUES ('-2147483647'); -- bad input values -- should give errors INSERT INTO INT4_TBL(f1) VALUES ('1000000000000'); ERROR: value "1000000000000" is out of range for type integer +LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('1000000000000'); + ^ INSERT INTO INT4_TBL(f1) VALUES ('asdf'); ERROR: invalid input syntax for integer: "asdf" +LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('asdf'); + ^ INSERT INTO INT4_TBL(f1) VALUES (' '); ERROR: invalid input syntax for integer: " " +LINE 1: INSERT INTO INT4_TBL(f1) VALUES (' '); + ^ INSERT INTO INT4_TBL(f1) VALUES (' asdf '); ERROR: invalid input syntax for integer: " asdf " +LINE 1: INSERT INTO INT4_TBL(f1) VALUES (' asdf '); + ^ INSERT INTO INT4_TBL(f1) VALUES ('- 1234'); ERROR: invalid input syntax for integer: "- 1234" +LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('- 1234'); + ^ INSERT INTO INT4_TBL(f1) VALUES ('123 5'); ERROR: invalid input syntax for integer: "123 5" +LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('123 5'); + ^ INSERT INTO INT4_TBL(f1) VALUES (''); ERROR: invalid input syntax for integer: "" +LINE 1: INSERT INTO INT4_TBL(f1) VALUES (''); + ^ SELECT '' AS five, * FROM INT4_TBL; five | f1 ------+------------- diff --git a/src/test/regress/expected/int8-exp-three-digits.out b/src/test/regress/expected/int8-exp-three-digits.out index e3697f8344..12af98f0b5 100644 --- a/src/test/regress/expected/int8-exp-three-digits.out +++ b/src/test/regress/expected/int8-exp-three-digits.out @@ -11,18 +11,32 @@ INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789'); -- bad inputs INSERT INTO INT8_TBL(q1) VALUES (' '); ERROR: invalid input syntax for integer: " " +LINE 1: INSERT INTO INT8_TBL(q1) VALUES (' '); + ^ INSERT INTO INT8_TBL(q1) VALUES ('xxx'); ERROR: invalid input syntax for integer: "xxx" +LINE 1: INSERT INTO INT8_TBL(q1) VALUES ('xxx'); + ^ INSERT INTO INT8_TBL(q1) VALUES ('3908203590239580293850293850329485'); ERROR: value "3908203590239580293850293850329485" is out of range for type bigint +LINE 1: INSERT INTO INT8_TBL(q1) VALUES ('39082035902395802938502938... + ^ INSERT INTO INT8_TBL(q1) VALUES ('-1204982019841029840928340329840934'); ERROR: value "-1204982019841029840928340329840934" is out of range for type bigint +LINE 1: INSERT INTO INT8_TBL(q1) VALUES ('-1204982019841029840928340... + ^ INSERT INTO INT8_TBL(q1) VALUES ('- 123'); ERROR: invalid input syntax for integer: "- 123" +LINE 1: INSERT INTO INT8_TBL(q1) VALUES ('- 123'); + ^ INSERT INTO INT8_TBL(q1) VALUES (' 345 5'); ERROR: invalid input syntax for integer: " 345 5" +LINE 1: INSERT INTO INT8_TBL(q1) VALUES (' 345 5'); + ^ INSERT INTO INT8_TBL(q1) VALUES (''); ERROR: invalid input syntax for integer: "" +LINE 1: INSERT INTO INT8_TBL(q1) VALUES (''); + ^ SELECT * FROM INT8_TBL; q1 | q2 ------------------+------------------- @@ -309,6 +323,8 @@ select '-9223372036854775808'::int8; select '-9223372036854775809'::int8; ERROR: value "-9223372036854775809" is out of range for type bigint +LINE 1: select '-9223372036854775809'::int8; + ^ select '9223372036854775807'::int8; int8 --------------------- @@ -317,3 +333,5 @@ select '9223372036854775807'::int8; select '9223372036854775808'::int8; ERROR: value "9223372036854775808" is out of range for type bigint +LINE 1: select '9223372036854775808'::int8; + ^ diff --git a/src/test/regress/expected/int8.out b/src/test/regress/expected/int8.out index 52cdabab74..f1cc62d680 100644 --- a/src/test/regress/expected/int8.out +++ b/src/test/regress/expected/int8.out @@ -11,18 +11,32 @@ INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789'); -- bad inputs INSERT INTO INT8_TBL(q1) VALUES (' '); ERROR: invalid input syntax for integer: " " +LINE 1: INSERT INTO INT8_TBL(q1) VALUES (' '); + ^ INSERT INTO INT8_TBL(q1) VALUES ('xxx'); ERROR: invalid input syntax for integer: "xxx" +LINE 1: INSERT INTO INT8_TBL(q1) VALUES ('xxx'); + ^ INSERT INTO INT8_TBL(q1) VALUES ('3908203590239580293850293850329485'); ERROR: value "3908203590239580293850293850329485" is out of range for type bigint +LINE 1: INSERT INTO INT8_TBL(q1) VALUES ('39082035902395802938502938... + ^ INSERT INTO INT8_TBL(q1) VALUES ('-1204982019841029840928340329840934'); ERROR: value "-1204982019841029840928340329840934" is out of range for type bigint +LINE 1: INSERT INTO INT8_TBL(q1) VALUES ('-1204982019841029840928340... + ^ INSERT INTO INT8_TBL(q1) VALUES ('- 123'); ERROR: invalid input syntax for integer: "- 123" +LINE 1: INSERT INTO INT8_TBL(q1) VALUES ('- 123'); + ^ INSERT INTO INT8_TBL(q1) VALUES (' 345 5'); ERROR: invalid input syntax for integer: " 345 5" +LINE 1: INSERT INTO INT8_TBL(q1) VALUES (' 345 5'); + ^ INSERT INTO INT8_TBL(q1) VALUES (''); ERROR: invalid input syntax for integer: "" +LINE 1: INSERT INTO INT8_TBL(q1) VALUES (''); + ^ SELECT * FROM INT8_TBL; q1 | q2 ------------------+------------------- @@ -309,6 +323,8 @@ select '-9223372036854775808'::int8; select '-9223372036854775809'::int8; ERROR: value "-9223372036854775809" is out of range for type bigint +LINE 1: select '-9223372036854775809'::int8; + ^ select '9223372036854775807'::int8; int8 --------------------- @@ -317,3 +333,5 @@ select '9223372036854775807'::int8; select '9223372036854775808'::int8; ERROR: value "9223372036854775808" is out of range for type bigint +LINE 1: select '9223372036854775808'::int8; + ^ diff --git a/src/test/regress/expected/interval.out b/src/test/regress/expected/interval.out index 72a031df5f..049850af8e 100644 --- a/src/test/regress/expected/interval.out +++ b/src/test/regress/expected/interval.out @@ -71,8 +71,12 @@ INSERT INTO INTERVAL_TBL (f1) VALUES ('5 months 12 hours'); -- badly formatted interval INSERT INTO INTERVAL_TBL (f1) VALUES ('badly formatted interval'); ERROR: invalid input syntax for type interval: "badly formatted interval" +LINE 1: INSERT INTO INTERVAL_TBL (f1) VALUES ('badly formatted inter... + ^ INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 30 eons ago'); ERROR: invalid input syntax for type interval: "@ 30 eons ago" +LINE 1: INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 30 eons ago'); + ^ -- test interval operators SELECT '' AS ten, * FROM INTERVAL_TBL; ten | f1 @@ -343,9 +347,17 @@ SELECT '3 days 5 milliseconds'::interval; SELECT '1 second 2 seconds'::interval; -- error ERROR: invalid input syntax for type interval: "1 second 2 seconds" +LINE 1: SELECT '1 second 2 seconds'::interval; + ^ SELECT '10 milliseconds 20 milliseconds'::interval; -- error ERROR: invalid input syntax for type interval: "10 milliseconds 20 milliseconds" +LINE 1: SELECT '10 milliseconds 20 milliseconds'::interval; + ^ SELECT '5.5 seconds 3 milliseconds'::interval; -- error ERROR: invalid input syntax for type interval: "5.5 seconds 3 milliseconds" +LINE 1: SELECT '5.5 seconds 3 milliseconds'::interval; + ^ SELECT '1:20:05 5 microseconds'::interval; -- error ERROR: invalid input syntax for type interval: "1:20:05 5 microseconds" +LINE 1: SELECT '1:20:05 5 microseconds'::interval; + ^ diff --git a/src/test/regress/expected/lseg.out b/src/test/regress/expected/lseg.out index 9e0e6cb2df..bba1f3ee80 100644 --- a/src/test/regress/expected/lseg.out +++ b/src/test/regress/expected/lseg.out @@ -12,12 +12,20 @@ INSERT INTO LSEG_TBL VALUES ('(11,22,33,44)'); -- bad values for parser testing INSERT INTO LSEG_TBL VALUES ('(3asdf,2 ,3,4r2)'); ERROR: invalid input syntax for type lseg: "(3asdf,2 ,3,4r2)" +LINE 1: INSERT INTO LSEG_TBL VALUES ('(3asdf,2 ,3,4r2)'); + ^ INSERT INTO LSEG_TBL VALUES ('[1,2,3, 4'); ERROR: invalid input syntax for type lseg: "[1,2,3, 4" +LINE 1: INSERT INTO LSEG_TBL VALUES ('[1,2,3, 4'); + ^ INSERT INTO LSEG_TBL VALUES ('[(,2),(3,4)]'); ERROR: invalid input syntax for type lseg: "[(,2),(3,4)]" +LINE 1: INSERT INTO LSEG_TBL VALUES ('[(,2),(3,4)]'); + ^ INSERT INTO LSEG_TBL VALUES ('[(1,2),(3,4)'); ERROR: invalid input syntax for type lseg: "[(1,2),(3,4)" +LINE 1: INSERT INTO LSEG_TBL VALUES ('[(1,2),(3,4)'); + ^ select * from LSEG_TBL; s ------------------------------- diff --git a/src/test/regress/expected/numeric.out b/src/test/regress/expected/numeric.out index 1c5047455e..c2fe7070b5 100644 --- a/src/test/regress/expected/numeric.out +++ b/src/test/regress/expected/numeric.out @@ -1231,25 +1231,45 @@ INSERT INTO num_input_test(n1) VALUES ('555.50'); INSERT INTO num_input_test(n1) VALUES ('-555.50'); INSERT INTO num_input_test(n1) VALUES ('NaN '); ERROR: invalid input syntax for type numeric: "NaN " +LINE 1: INSERT INTO num_input_test(n1) VALUES ('NaN '); + ^ INSERT INTO num_input_test(n1) VALUES (' nan'); ERROR: invalid input syntax for type numeric: " nan" +LINE 1: INSERT INTO num_input_test(n1) VALUES (' nan'); + ^ -- bad inputs INSERT INTO num_input_test(n1) VALUES (' '); ERROR: invalid input syntax for type numeric: " " +LINE 1: INSERT INTO num_input_test(n1) VALUES (' '); + ^ INSERT INTO num_input_test(n1) VALUES (' 1234 %'); ERROR: invalid input syntax for type numeric: " 1234 %" +LINE 1: INSERT INTO num_input_test(n1) VALUES (' 1234 %'); + ^ INSERT INTO num_input_test(n1) VALUES ('xyz'); ERROR: invalid input syntax for type numeric: "xyz" +LINE 1: INSERT INTO num_input_test(n1) VALUES ('xyz'); + ^ INSERT INTO num_input_test(n1) VALUES ('- 1234'); ERROR: invalid input syntax for type numeric: "- 1234" +LINE 1: INSERT INTO num_input_test(n1) VALUES ('- 1234'); + ^ INSERT INTO num_input_test(n1) VALUES ('5 . 0'); ERROR: invalid input syntax for type numeric: "5 . 0" +LINE 1: INSERT INTO num_input_test(n1) VALUES ('5 . 0'); + ^ INSERT INTO num_input_test(n1) VALUES ('5. 0 '); ERROR: invalid input syntax for type numeric: "5. 0 " +LINE 1: INSERT INTO num_input_test(n1) VALUES ('5. 0 '); + ^ INSERT INTO num_input_test(n1) VALUES (''); ERROR: invalid input syntax for type numeric: "" +LINE 1: INSERT INTO num_input_test(n1) VALUES (''); + ^ INSERT INTO num_input_test(n1) VALUES (' N aN '); ERROR: invalid input syntax for type numeric: " N aN " +LINE 1: INSERT INTO num_input_test(n1) VALUES (' N aN '); + ^ SELECT * FROM num_input_test; n1 --------- diff --git a/src/test/regress/expected/oid.out b/src/test/regress/expected/oid.out index e01db08c20..008b5a246b 100644 --- a/src/test/regress/expected/oid.out +++ b/src/test/regress/expected/oid.out @@ -14,24 +14,44 @@ INSERT INTO OID_TBL(f1) VALUES (' 15 '); -- bad inputs INSERT INTO OID_TBL(f1) VALUES (''); ERROR: invalid input syntax for type oid: "" +LINE 1: INSERT INTO OID_TBL(f1) VALUES (''); + ^ INSERT INTO OID_TBL(f1) VALUES (' '); ERROR: invalid input syntax for type oid: " " +LINE 1: INSERT INTO OID_TBL(f1) VALUES (' '); + ^ INSERT INTO OID_TBL(f1) VALUES ('asdfasd'); ERROR: invalid input syntax for type oid: "asdfasd" +LINE 1: INSERT INTO OID_TBL(f1) VALUES ('asdfasd'); + ^ INSERT INTO OID_TBL(f1) VALUES ('99asdfasd'); ERROR: invalid input syntax for type oid: "99asdfasd" +LINE 1: INSERT INTO OID_TBL(f1) VALUES ('99asdfasd'); + ^ INSERT INTO OID_TBL(f1) VALUES ('5 d'); ERROR: invalid input syntax for type oid: "5 d" +LINE 1: INSERT INTO OID_TBL(f1) VALUES ('5 d'); + ^ INSERT INTO OID_TBL(f1) VALUES (' 5d'); ERROR: invalid input syntax for type oid: " 5d" +LINE 1: INSERT INTO OID_TBL(f1) VALUES (' 5d'); + ^ INSERT INTO OID_TBL(f1) VALUES ('5 5'); ERROR: invalid input syntax for type oid: "5 5" +LINE 1: INSERT INTO OID_TBL(f1) VALUES ('5 5'); + ^ INSERT INTO OID_TBL(f1) VALUES (' - 500'); ERROR: invalid input syntax for type oid: " - 500" +LINE 1: INSERT INTO OID_TBL(f1) VALUES (' - 500'); + ^ INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935'); ERROR: value "32958209582039852935" is out of range for type oid +LINE 1: INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935'); + ^ INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385'); ERROR: value "-23582358720398502385" is out of range for type oid +LINE 1: INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385'); + ^ SELECT '' AS six, * FROM OID_TBL; six | f1 -----+------------ diff --git a/src/test/regress/expected/path.out b/src/test/regress/expected/path.out index f5671c7a13..08d6d61dda 100644 --- a/src/test/regress/expected/path.out +++ b/src/test/regress/expected/path.out @@ -14,8 +14,12 @@ INSERT INTO PATH_TBL VALUES ('(11,12,13,14)'); -- bad values for parser testing INSERT INTO PATH_TBL VALUES ('[(,2),(3,4)]'); ERROR: invalid input syntax for type path: "[(,2),(3,4)]" +LINE 1: INSERT INTO PATH_TBL VALUES ('[(,2),(3,4)]'); + ^ INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)'); ERROR: invalid input syntax for type path: "[(1,2),(3,4)" +LINE 1: INSERT INTO PATH_TBL VALUES ('[(1,2),(3,4)'); + ^ SELECT f1 FROM PATH_TBL; f1 --------------------------- diff --git a/src/test/regress/expected/point.out b/src/test/regress/expected/point.out index a31a4b39b7..9d1bd434e9 100644 --- a/src/test/regress/expected/point.out +++ b/src/test/regress/expected/point.out @@ -10,11 +10,17 @@ INSERT INTO POINT_TBL(f1) VALUES ('(-5.0,-12.0)'); -- bad format points INSERT INTO POINT_TBL(f1) VALUES ('asdfasdf'); ERROR: invalid input syntax for type point: "asdfasdf" +LINE 1: INSERT INTO POINT_TBL(f1) VALUES ('asdfasdf'); + ^ INSERT INTO POINT_TBL(f1) VALUES ('10.0,10.0'); INSERT INTO POINT_TBL(f1) VALUES ('(10.0 10.0)'); ERROR: invalid input syntax for type point: "(10.0 10.0)" +LINE 1: INSERT INTO POINT_TBL(f1) VALUES ('(10.0 10.0)'); + ^ INSERT INTO POINT_TBL(f1) VALUES ('(10.0,10.0'); ERROR: invalid input syntax for type point: "(10.0,10.0" +LINE 1: INSERT INTO POINT_TBL(f1) VALUES ('(10.0,10.0'); + ^ SELECT '' AS six, * FROM POINT_TBL; six | f1 -----+------------ diff --git a/src/test/regress/expected/polygon.out b/src/test/regress/expected/polygon.out index 2edda04b4e..56b72aaa8e 100644 --- a/src/test/regress/expected/polygon.out +++ b/src/test/regress/expected/polygon.out @@ -22,14 +22,24 @@ INSERT INTO POLYGON_TBL(f1) VALUES ('(0.0,1.0),(0.0,1.0)'); -- bad polygon input strings INSERT INTO POLYGON_TBL(f1) VALUES ('0.0'); ERROR: invalid input syntax for type polygon: "0.0" +LINE 1: INSERT INTO POLYGON_TBL(f1) VALUES ('0.0'); + ^ INSERT INTO POLYGON_TBL(f1) VALUES ('(0.0 0.0'); ERROR: invalid input syntax for type polygon: "(0.0 0.0" +LINE 1: INSERT INTO POLYGON_TBL(f1) VALUES ('(0.0 0.0'); + ^ INSERT INTO POLYGON_TBL(f1) VALUES ('(0,1,2)'); ERROR: invalid input syntax for type polygon: "(0,1,2)" +LINE 1: INSERT INTO POLYGON_TBL(f1) VALUES ('(0,1,2)'); + ^ INSERT INTO POLYGON_TBL(f1) VALUES ('(0,1,2,3'); ERROR: invalid input syntax for type polygon: "(0,1,2,3" +LINE 1: INSERT INTO POLYGON_TBL(f1) VALUES ('(0,1,2,3'); + ^ INSERT INTO POLYGON_TBL(f1) VALUES ('asdf'); ERROR: invalid input syntax for type polygon: "asdf" +LINE 1: INSERT INTO POLYGON_TBL(f1) VALUES ('asdf'); + ^ SELECT '' AS four, * FROM POLYGON_TBL; four | f1 ------+--------------------- diff --git a/src/test/regress/expected/prepared_xacts.out b/src/test/regress/expected/prepared_xacts.out index 258706da8e..535dbe4cbf 100644 --- a/src/test/regress/expected/prepared_xacts.out +++ b/src/test/regress/expected/prepared_xacts.out @@ -148,6 +148,8 @@ ERROR: cursor "foo" does not exist -- Table doesn't exist, the creation hasn't been committed yet SELECT * FROM pxtest2; ERROR: relation "pxtest2" does not exist +LINE 1: SELECT * FROM pxtest2; + ^ -- There should be two prepared transactions SELECT gid FROM pg_prepared_xacts; gid @@ -202,6 +204,8 @@ SELECT gid FROM pg_prepared_xacts; COMMIT PREPARED 'regress-two'; SELECT * FROM pxtest3; ERROR: relation "pxtest3" does not exist +LINE 1: SELECT * FROM pxtest3; + ^ -- There should be no prepared transactions SELECT gid FROM pg_prepared_xacts; gid diff --git a/src/test/regress/expected/rangefuncs.out b/src/test/regress/expected/rangefuncs.out index 90111553d9..e8a9013550 100644 --- a/src/test/regress/expected/rangefuncs.out +++ b/src/test/regress/expected/rangefuncs.out @@ -20,6 +20,8 @@ CREATE FUNCTION foot(int) returns setof foo2 as 'SELECT * FROM foo2 WHERE fooid -- supposed to fail with ERROR select * from foo2, foot(foo2.fooid) z where foo2.f2 = z.f2; ERROR: function expression in FROM cannot refer to other relations of same query level +LINE 1: select * from foo2, foot(foo2.fooid) z where foo2.f2 = z.f2; + ^ -- function in subselect select * from foo2 where f2 in (select f2 from foot(foo2.fooid) z where z.fooid = foo2.fooid) ORDER BY 1,2; fooid | f2 diff --git a/src/test/regress/expected/reltime.out b/src/test/regress/expected/reltime.out index 8f4faef124..14fdc6aeec 100644 --- a/src/test/regress/expected/reltime.out +++ b/src/test/regress/expected/reltime.out @@ -11,8 +11,12 @@ INSERT INTO RELTIME_TBL (f1) VALUES ('@ 14 seconds ago'); -- badly formatted reltimes INSERT INTO RELTIME_TBL (f1) VALUES ('badly formatted reltime'); ERROR: invalid input syntax for type reltime: "badly formatted reltime" +LINE 1: INSERT INTO RELTIME_TBL (f1) VALUES ('badly formatted reltim... + ^ INSERT INTO RELTIME_TBL (f1) VALUES ('@ 30 eons ago'); ERROR: invalid input syntax for type reltime: "@ 30 eons ago" +LINE 1: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 30 eons ago'); + ^ -- test reltime operators SELECT '' AS six, * FROM RELTIME_TBL; six | f1 diff --git a/src/test/regress/expected/rowtypes.out b/src/test/regress/expected/rowtypes.out index 6af1aa705f..73ae3ce10e 100644 --- a/src/test/regress/expected/rowtypes.out +++ b/src/test/regress/expected/rowtypes.out @@ -45,9 +45,13 @@ select '(Joe,)'::fullname; -- ok, null 2nd column select '(Joe)'::fullname; -- bad ERROR: malformed record literal: "(Joe)" +LINE 1: select '(Joe)'::fullname; + ^ DETAIL: Too few columns. select '(Joe,,)'::fullname; -- bad ERROR: malformed record literal: "(Joe,,)" +LINE 1: select '(Joe,,)'::fullname; + ^ DETAIL: Too many columns. create temp table quadtable(f1 int, q quad); insert into quadtable values (1, ((3.3,4.4),(5.5,6.6))); diff --git a/src/test/regress/expected/select_distinct_on.out b/src/test/regress/expected/select_distinct_on.out index c4b03e95f7..fc6dda7477 100644 --- a/src/test/regress/expected/select_distinct_on.out +++ b/src/test/regress/expected/select_distinct_on.out @@ -17,6 +17,8 @@ SELECT DISTINCT ON (string4, ten) string4, two, ten FROM tmp ORDER BY string4 using <, two using <, ten using <; ERROR: SELECT DISTINCT ON expressions must match initial ORDER BY expressions +LINE 1: SELECT DISTINCT ON (string4, ten) string4, two, ten + ^ SELECT DISTINCT ON (string4, ten) string4, ten, two FROM tmp ORDER BY string4 using <, ten using >, two using <; diff --git a/src/test/regress/expected/select_having.out b/src/test/regress/expected/select_having.out index dc4dee06b1..3950c0b404 100644 --- a/src/test/regress/expected/select_having.out +++ b/src/test/regress/expected/select_having.out @@ -65,8 +65,12 @@ SELECT min(a), max(a) FROM test_having HAVING min(a) < max(a); -- errors: ungrouped column references SELECT a FROM test_having HAVING min(a) < max(a); ERROR: column "test_having.a" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: SELECT a FROM test_having HAVING min(a) < max(a); + ^ SELECT 1 AS one FROM test_having HAVING a > 1; ERROR: column "test_having.a" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: SELECT 1 AS one FROM test_having HAVING a > 1; + ^ -- the really degenerate case: need not scan table at all SELECT 1 AS one FROM test_having HAVING 1 > 2; one diff --git a/src/test/regress/expected/select_having_1.out b/src/test/regress/expected/select_having_1.out index de721dd803..5c58da154c 100644 --- a/src/test/regress/expected/select_having_1.out +++ b/src/test/regress/expected/select_having_1.out @@ -65,8 +65,12 @@ SELECT min(a), max(a) FROM test_having HAVING min(a) < max(a); -- errors: ungrouped column references SELECT a FROM test_having HAVING min(a) < max(a); ERROR: column "test_having.a" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: SELECT a FROM test_having HAVING min(a) < max(a); + ^ SELECT 1 AS one FROM test_having HAVING a > 1; ERROR: column "test_having.a" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: SELECT 1 AS one FROM test_having HAVING a > 1; + ^ -- the really degenerate case: need not scan table at all SELECT 1 AS one FROM test_having HAVING 1 > 2; one diff --git a/src/test/regress/expected/select_having_2.out b/src/test/regress/expected/select_having_2.out index 542436e5ea..7087fb1c0c 100644 --- a/src/test/regress/expected/select_having_2.out +++ b/src/test/regress/expected/select_having_2.out @@ -65,8 +65,12 @@ SELECT min(a), max(a) FROM test_having HAVING min(a) < max(a); -- errors: ungrouped column references SELECT a FROM test_having HAVING min(a) < max(a); ERROR: column "test_having.a" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: SELECT a FROM test_having HAVING min(a) < max(a); + ^ SELECT 1 AS one FROM test_having HAVING a > 1; ERROR: column "test_having.a" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: SELECT 1 AS one FROM test_having HAVING a > 1; + ^ -- the really degenerate case: need not scan table at all SELECT 1 AS one FROM test_having HAVING 1 > 2; one diff --git a/src/test/regress/expected/select_implicit.out b/src/test/regress/expected/select_implicit.out index 14ee2b6205..b358ee9fcc 100644 --- a/src/test/regress/expected/select_implicit.out +++ b/src/test/regress/expected/select_implicit.out @@ -45,6 +45,8 @@ SELECT count(*) FROM test_missing_target GROUP BY test_missing_target.c ORDER BY -- failure expected SELECT count(*) FROM test_missing_target GROUP BY a ORDER BY b; ERROR: column "test_missing_target.b" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: ...ECT count(*) FROM test_missing_target GROUP BY a ORDER BY b; + ^ -- w/o existing GROUP BY target and w/o existing same ORDER BY target SELECT count(*) FROM test_missing_target GROUP BY b ORDER BY b; count @@ -240,6 +242,8 @@ ORDER BY lower(test_missing_target.c); -- failure expected SELECT count(a) FROM test_missing_target GROUP BY a ORDER BY b; ERROR: column "test_missing_target.b" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: ...ECT count(a) FROM test_missing_target GROUP BY a ORDER BY b; + ^ -- w/o existing GROUP BY target and w/o existing same ORDER BY target SELECT count(b) FROM test_missing_target GROUP BY b/2 ORDER BY b/2; count diff --git a/src/test/regress/expected/select_implicit_1.out b/src/test/regress/expected/select_implicit_1.out index feb33ec576..1527ce4277 100644 --- a/src/test/regress/expected/select_implicit_1.out +++ b/src/test/regress/expected/select_implicit_1.out @@ -45,6 +45,8 @@ SELECT count(*) FROM test_missing_target GROUP BY test_missing_target.c ORDER BY -- failure expected SELECT count(*) FROM test_missing_target GROUP BY a ORDER BY b; ERROR: column "test_missing_target.b" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: ...ECT count(*) FROM test_missing_target GROUP BY a ORDER BY b; + ^ -- w/o existing GROUP BY target and w/o existing same ORDER BY target SELECT count(*) FROM test_missing_target GROUP BY b ORDER BY b; count @@ -240,6 +242,8 @@ ORDER BY lower(test_missing_target.c); -- failure expected SELECT count(a) FROM test_missing_target GROUP BY a ORDER BY b; ERROR: column "test_missing_target.b" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: ...ECT count(a) FROM test_missing_target GROUP BY a ORDER BY b; + ^ -- w/o existing GROUP BY target and w/o existing same ORDER BY target SELECT count(b) FROM test_missing_target GROUP BY b/2 ORDER BY b/2; count diff --git a/src/test/regress/expected/select_implicit_2.out b/src/test/regress/expected/select_implicit_2.out index fac106353f..4217af7ba4 100644 --- a/src/test/regress/expected/select_implicit_2.out +++ b/src/test/regress/expected/select_implicit_2.out @@ -45,6 +45,8 @@ SELECT count(*) FROM test_missing_target GROUP BY test_missing_target.c ORDER BY -- failure expected SELECT count(*) FROM test_missing_target GROUP BY a ORDER BY b; ERROR: column "test_missing_target.b" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: ...ECT count(*) FROM test_missing_target GROUP BY a ORDER BY b; + ^ -- w/o existing GROUP BY target and w/o existing same ORDER BY target SELECT count(*) FROM test_missing_target GROUP BY b ORDER BY b; count @@ -240,6 +242,8 @@ ORDER BY lower(test_missing_target.c); -- failure expected SELECT count(a) FROM test_missing_target GROUP BY a ORDER BY b; ERROR: column "test_missing_target.b" must appear in the GROUP BY clause or be used in an aggregate function +LINE 1: ...ECT count(a) FROM test_missing_target GROUP BY a ORDER BY b; + ^ -- w/o existing GROUP BY target and w/o existing same ORDER BY target SELECT count(b) FROM test_missing_target GROUP BY b/2 ORDER BY b/2; count diff --git a/src/test/regress/expected/temp.out b/src/test/regress/expected/temp.out index da126a3aff..c39a88ad51 100644 --- a/src/test/regress/expected/temp.out +++ b/src/test/regress/expected/temp.out @@ -45,6 +45,8 @@ CREATE TEMP TABLE temptest(col int); \c SELECT * FROM temptest; ERROR: relation "temptest" does not exist +LINE 1: SELECT * FROM temptest; + ^ -- Test ON COMMIT DELETE ROWS CREATE TEMP TABLE temptest(col int) ON COMMIT DELETE ROWS; BEGIN; @@ -94,6 +96,8 @@ SELECT * FROM temptest; COMMIT; SELECT * FROM temptest; ERROR: relation "temptest" does not exist +LINE 1: SELECT * FROM temptest; + ^ BEGIN; CREATE TEMP TABLE temptest(col) ON COMMIT DROP AS SELECT 1; SELECT * FROM temptest; @@ -105,6 +109,8 @@ SELECT * FROM temptest; COMMIT; SELECT * FROM temptest; ERROR: relation "temptest" does not exist +LINE 1: SELECT * FROM temptest; + ^ -- ON COMMIT is only allowed for TEMP CREATE TABLE temptest(col int) ON COMMIT DELETE ROWS; ERROR: ON COMMIT can only be used on temporary tables diff --git a/src/test/regress/expected/time.out b/src/test/regress/expected/time.out index 6e21828cf7..8e0afe69e0 100644 --- a/src/test/regress/expected/time.out +++ b/src/test/regress/expected/time.out @@ -16,6 +16,8 @@ INSERT INTO TIME_TBL VALUES ('2003-07-07 15:36:39 America/New_York'); -- this should fail (the timezone offset is not known) INSERT INTO TIME_TBL VALUES ('15:36:39 America/New_York'); ERROR: invalid input syntax for type time: "15:36:39 America/New_York" +LINE 1: INSERT INTO TIME_TBL VALUES ('15:36:39 America/New_York'); + ^ SELECT f1 AS "Time" FROM TIME_TBL; Time ------------- diff --git a/src/test/regress/expected/timestamp.out b/src/test/regress/expected/timestamp.out index 81b3eb87ca..a0924c7fe3 100644 --- a/src/test/regress/expected/timestamp.out +++ b/src/test/regress/expected/timestamp.out @@ -82,14 +82,22 @@ INSERT INTO TIMESTAMP_TBL VALUES ('epoch'); -- Obsolete special values INSERT INTO TIMESTAMP_TBL VALUES ('invalid'); ERROR: date/time value "invalid" is no longer supported +LINE 1: INSERT INTO TIMESTAMP_TBL VALUES ('invalid'); + ^ INSERT INTO TIMESTAMP_TBL VALUES ('current'); ERROR: date/time value "current" is no longer supported +LINE 1: INSERT INTO TIMESTAMP_TBL VALUES ('current'); + ^ -- Postgres v6.0 standard output format INSERT INTO TIMESTAMP_TBL VALUES ('Mon Feb 10 17:32:01 1997 PST'); INSERT INTO TIMESTAMP_TBL VALUES ('Invalid Abstime'); ERROR: date/time value "Invalid Abstime" is no longer supported +LINE 1: INSERT INTO TIMESTAMP_TBL VALUES ('Invalid Abstime'); + ^ INSERT INTO TIMESTAMP_TBL VALUES ('Undefined Abstime'); ERROR: date/time value "Undefined Abstime" is no longer supported +LINE 1: INSERT INTO TIMESTAMP_TBL VALUES ('Undefined Abstime'); + ^ -- Variations on Postgres v6.1 standard output format INSERT INTO TIMESTAMP_TBL VALUES ('Mon Feb 10 17:32:01.000001 1997 PST'); INSERT INTO TIMESTAMP_TBL VALUES ('Mon Feb 10 17:32:01.999999 1997 PST'); @@ -129,6 +137,8 @@ INSERT INTO TIMESTAMP_TBL VALUES ('19970210 173201 America/New_York'); -- this fails (even though TZ is a no-op, we still look it up) INSERT INTO TIMESTAMP_TBL VALUES ('19970710 173201 America/Does_not_exist'); ERROR: time zone "america/does_not_exist" not recognized +LINE 1: INSERT INTO TIMESTAMP_TBL VALUES ('19970710 173201 America/D... + ^ -- Check date conversion and date arithmetic INSERT INTO TIMESTAMP_TBL VALUES ('1997-06-10 18:32:01 PDT'); INSERT INTO TIMESTAMP_TBL VALUES ('Feb 10 17:32:01 1997'); @@ -156,6 +166,8 @@ INSERT INTO TIMESTAMP_TBL VALUES ('Jan 01 17:32:01 1997'); INSERT INTO TIMESTAMP_TBL VALUES ('Feb 28 17:32:01 1997'); INSERT INTO TIMESTAMP_TBL VALUES ('Feb 29 17:32:01 1997'); ERROR: date/time field value out of range: "Feb 29 17:32:01 1997" +LINE 1: INSERT INTO TIMESTAMP_TBL VALUES ('Feb 29 17:32:01 1997'); + ^ INSERT INTO TIMESTAMP_TBL VALUES ('Mar 01 17:32:01 1997'); INSERT INTO TIMESTAMP_TBL VALUES ('Dec 30 17:32:01 1997'); INSERT INTO TIMESTAMP_TBL VALUES ('Dec 31 17:32:01 1997'); @@ -166,8 +178,12 @@ INSERT INTO TIMESTAMP_TBL VALUES ('Jan 01 17:32:01 2001'); -- Currently unsupported syntax and ranges INSERT INTO TIMESTAMP_TBL VALUES ('Feb 16 17:32:01 -0097'); ERROR: time zone displacement out of range: "Feb 16 17:32:01 -0097" +LINE 1: INSERT INTO TIMESTAMP_TBL VALUES ('Feb 16 17:32:01 -0097'); + ^ INSERT INTO TIMESTAMP_TBL VALUES ('Feb 16 17:32:01 5097 BC'); ERROR: timestamp out of range: "Feb 16 17:32:01 5097 BC" +LINE 1: INSERT INTO TIMESTAMP_TBL VALUES ('Feb 16 17:32:01 5097 BC')... + ^ SELECT '' AS "64", d1 FROM TIMESTAMP_TBL; 64 | d1 ----+----------------------------- diff --git a/src/test/regress/expected/timestamptz.out b/src/test/regress/expected/timestamptz.out index 92fa5cfaae..31012f80b6 100644 --- a/src/test/regress/expected/timestamptz.out +++ b/src/test/regress/expected/timestamptz.out @@ -81,14 +81,22 @@ INSERT INTO TIMESTAMPTZ_TBL VALUES ('epoch'); -- Obsolete special values INSERT INTO TIMESTAMPTZ_TBL VALUES ('invalid'); ERROR: date/time value "invalid" is no longer supported +LINE 1: INSERT INTO TIMESTAMPTZ_TBL VALUES ('invalid'); + ^ INSERT INTO TIMESTAMPTZ_TBL VALUES ('current'); ERROR: date/time value "current" is no longer supported +LINE 1: INSERT INTO TIMESTAMPTZ_TBL VALUES ('current'); + ^ -- Postgres v6.0 standard output format INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mon Feb 10 17:32:01 1997 PST'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('Invalid Abstime'); ERROR: date/time value "Invalid Abstime" is no longer supported +LINE 1: INSERT INTO TIMESTAMPTZ_TBL VALUES ('Invalid Abstime'); + ^ INSERT INTO TIMESTAMPTZ_TBL VALUES ('Undefined Abstime'); ERROR: date/time value "Undefined Abstime" is no longer supported +LINE 1: INSERT INTO TIMESTAMPTZ_TBL VALUES ('Undefined Abstime'); + ^ -- Variations on Postgres v6.1 standard output format INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mon Feb 10 17:32:01.000001 1997 PST'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mon Feb 10 17:32:01.999999 1997 PST'); @@ -141,6 +149,8 @@ SELECT '19970710 173201' AT TIME ZONE 'America/New_York'; INSERT INTO TIMESTAMPTZ_TBL VALUES ('19970710 173201 America/Does_not_exist'); ERROR: time zone "america/does_not_exist" not recognized +LINE 1: INSERT INTO TIMESTAMPTZ_TBL VALUES ('19970710 173201 America... + ^ SELECT '19970710 173201' AT TIME ZONE 'America/Does_not_exist'; ERROR: time zone "America/Does_not_exist" not recognized -- Daylight saving time for timestamps beyond 32-bit time_t range. @@ -195,6 +205,8 @@ INSERT INTO TIMESTAMPTZ_TBL VALUES ('Jan 01 17:32:01 1997'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 28 17:32:01 1997'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 29 17:32:01 1997'); ERROR: date/time field value out of range: "Feb 29 17:32:01 1997" +LINE 1: INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 29 17:32:01 1997'); + ^ INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mar 01 17:32:01 1997'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('Dec 30 17:32:01 1997'); INSERT INTO TIMESTAMPTZ_TBL VALUES ('Dec 31 17:32:01 1997'); @@ -205,8 +217,12 @@ INSERT INTO TIMESTAMPTZ_TBL VALUES ('Jan 01 17:32:01 2001'); -- Currently unsupported syntax and ranges INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 -0097'); ERROR: time zone displacement out of range: "Feb 16 17:32:01 -0097" +LINE 1: INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 -0097')... + ^ INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 5097 BC'); ERROR: timestamp out of range: "Feb 16 17:32:01 5097 BC" +LINE 1: INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 5097 BC... + ^ -- Alternative field order that we've historically supported (sort of) -- with regular and POSIXy timezone specs SELECT 'Wed Jul 11 10:51:14 America/New_York 2001'::timestamptz; diff --git a/src/test/regress/expected/timetz.out b/src/test/regress/expected/timetz.out index 44e8b25b30..43911312f9 100644 --- a/src/test/regress/expected/timetz.out +++ b/src/test/regress/expected/timetz.out @@ -17,6 +17,8 @@ INSERT INTO TIMETZ_TBL VALUES ('2003-07-07 15:36:39 America/New_York'); -- this should fail (the timezone offset is not known) INSERT INTO TIMETZ_TBL VALUES ('15:36:39 America/New_York'); ERROR: invalid input syntax for type time with time zone: "15:36:39 America/New_York" +LINE 1: INSERT INTO TIMETZ_TBL VALUES ('15:36:39 America/New_York'); + ^ SELECT f1 AS "Time TZ" FROM TIMETZ_TBL; Time TZ ---------------- diff --git a/src/test/regress/expected/tinterval.out b/src/test/regress/expected/tinterval.out index 1b4586b87a..89e850cf61 100644 --- a/src/test/regress/expected/tinterval.out +++ b/src/test/regress/expected/tinterval.out @@ -18,9 +18,13 @@ INSERT INTO TINTERVAL_TBL (f1) INSERT INTO TINTERVAL_TBL (f1) VALUES ('["bad time specifications" ""]'); ERROR: invalid input syntax for type abstime: "bad time specifications" +LINE 2: VALUES ('["bad time specifications" ""]'); + ^ INSERT INTO TINTERVAL_TBL (f1) VALUES ('["" "infinity"]'); ERROR: invalid input syntax for type abstime: "" +LINE 2: VALUES ('["" "infinity"]'); + ^ -- test tinterval operators SELECT '' AS five, * FROM TINTERVAL_TBL; five | f1 diff --git a/src/test/regress/expected/transactions.out b/src/test/regress/expected/transactions.out index 7c469f13c0..51bb3668f3 100644 --- a/src/test/regress/expected/transactions.out +++ b/src/test/regress/expected/transactions.out @@ -93,6 +93,8 @@ SELECT * FROM foo; -- should be empty SELECT * FROM bar; -- shouldn't exist ERROR: relation "bar" does not exist +LINE 1: SELECT * FROM bar; + ^ SELECT * FROM barbaz; -- should be empty a --- @@ -109,6 +111,8 @@ BEGIN; SAVEPOINT one; INSERT into bar VALUES (1); ERROR: relation "bar" does not exist +LINE 1: INSERT into bar VALUES (1); + ^ ROLLBACK TO one; RELEASE SAVEPOINT one; SAVEPOINT two; diff --git a/src/test/regress/expected/truncate.out b/src/test/regress/expected/truncate.out index c9134ee233..3055679f7e 100644 --- a/src/test/regress/expected/truncate.out +++ b/src/test/regress/expected/truncate.out @@ -257,3 +257,5 @@ SELECT * FROM truncate_a; DROP TABLE truncate_a; SELECT nextval('truncate_a_id1'); -- fail, seq should have been dropped ERROR: relation "truncate_a_id1" does not exist +LINE 1: SELECT nextval('truncate_a_id1'); + ^ diff --git a/src/test/regress/expected/txid.out b/src/test/regress/expected/txid.out index 59b629358a..930b86a656 100644 --- a/src/test/regress/expected/txid.out +++ b/src/test/regress/expected/txid.out @@ -15,14 +15,24 @@ select '12:18:14,16'::txid_snapshot; -- errors select '31:12:'::txid_snapshot; ERROR: invalid input for txid_snapshot: "31:12:" +LINE 1: select '31:12:'::txid_snapshot; + ^ select '0:1:'::txid_snapshot; ERROR: invalid input for txid_snapshot: "0:1:" +LINE 1: select '0:1:'::txid_snapshot; + ^ select '12:13:0'::txid_snapshot; ERROR: invalid input for txid_snapshot: "12:13:0" +LINE 1: select '12:13:0'::txid_snapshot; + ^ select '12:16:14,13'::txid_snapshot; ERROR: invalid input for txid_snapshot: "12:16:14,13" +LINE 1: select '12:16:14,13'::txid_snapshot; + ^ select '12:16:14,14'::txid_snapshot; ERROR: invalid input for txid_snapshot: "12:16:14,14" +LINE 1: select '12:16:14,14'::txid_snapshot; + ^ create temp table snapshot_test ( nr integer, snap txid_snapshot @@ -224,3 +234,5 @@ SELECT txid_snapshot '1:9223372036854775807:3'; SELECT txid_snapshot '1:9223372036854775808:3'; ERROR: invalid input for txid_snapshot: "1:9223372036854775808:3" +LINE 1: SELECT txid_snapshot '1:9223372036854775808:3'; + ^ diff --git a/src/test/regress/expected/uuid.out b/src/test/regress/expected/uuid.out index 179bf60d98..03bd73bd0c 100644 --- a/src/test/regress/expected/uuid.out +++ b/src/test/regress/expected/uuid.out @@ -14,19 +14,31 @@ CREATE TABLE guid2 -- too long INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111F'); ERROR: invalid input syntax for uuid: "11111111-1111-1111-1111-111111111111F" +LINE 1: INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-111... + ^ -- too short INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-1111-11111111111}'); ERROR: invalid input syntax for uuid: "{11111111-1111-1111-1111-11111111111}" +LINE 1: INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-11... + ^ -- valid data but invalid format INSERT INTO guid1(guid_field) VALUES('111-11111-1111-1111-1111-111111111111'); ERROR: invalid input syntax for uuid: "111-11111-1111-1111-1111-111111111111" +LINE 1: INSERT INTO guid1(guid_field) VALUES('111-11111-1111-1111-11... + ^ INSERT INTO guid1(guid_field) VALUES('{22222222-2222-2222-2222-222222222222 '); ERROR: invalid input syntax for uuid: "{22222222-2222-2222-2222-222222222222 " +LINE 1: INSERT INTO guid1(guid_field) VALUES('{22222222-2222-2222-22... + ^ -- invalid data INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-G111-111111111111'); ERROR: invalid input syntax for uuid: "11111111-1111-1111-G111-111111111111" +LINE 1: INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-G11... + ^ INSERT INTO guid1(guid_field) VALUES('11+11111-1111-1111-1111-111111111111'); ERROR: invalid input syntax for uuid: "11+11111-1111-1111-1111-111111111111" +LINE 1: INSERT INTO guid1(guid_field) VALUES('11+11111-1111-1111-111... + ^ --inserting three input formats INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111'); INSERT INTO guid1(guid_field) VALUES('{22222222-2222-2222-2222-222222222222}'); diff --git a/src/test/regress/expected/xml.out b/src/test/regress/expected/xml.out index f29c61b23c..fe5ccb8adc 100644 --- a/src/test/regress/expected/xml.out +++ b/src/test/regress/expected/xml.out @@ -6,6 +6,8 @@ INSERT INTO xmltest VALUES (1, '<value>one</value>'); INSERT INTO xmltest VALUES (2, '<value>two</value>'); INSERT INTO xmltest VALUES (3, '<wrong'); ERROR: invalid XML content +LINE 1: INSERT INTO xmltest VALUES (3, '<wrong'); + ^ DETAIL: Entity: line 1: parser error : Couldn't find end of Start Tag wrong line 1 <wrong ^ @@ -58,6 +60,8 @@ LINE 1: SELECT xmlconcat(1, 2); ^ SELECT xmlconcat('bad', '<syntax'); ERROR: invalid XML content +LINE 1: SELECT xmlconcat('bad', '<syntax'); + ^ DETAIL: Entity: line 1: parser error : Couldn't find end of Start Tag syntax line 1 <syntax ^ @@ -340,6 +344,8 @@ SELECT xml 'abc' IS NOT DOCUMENT; SELECT '<>' IS NOT DOCUMENT; ERROR: invalid XML content +LINE 1: SELECT '<>' IS NOT DOCUMENT; + ^ DETAIL: Entity: line 1: parser error : StartTag: invalid element name <> ^ @@ -384,6 +390,8 @@ EXECUTE foo ('<bar/>'); EXECUTE foo ('bad'); ERROR: invalid XML document +LINE 1: EXECUTE foo ('bad'); + ^ DETAIL: Entity: line 1: parser error : Start tag expected, '<' not found bad ^ diff --git a/src/test/regress/expected/xml_1.out b/src/test/regress/expected/xml_1.out index ff3bfb77bf..596031dd13 100644 --- a/src/test/regress/expected/xml_1.out +++ b/src/test/regress/expected/xml_1.out @@ -4,14 +4,20 @@ CREATE TABLE xmltest ( ); INSERT INTO xmltest VALUES (1, '<value>one</value>'); ERROR: unsupported XML feature +LINE 1: INSERT INTO xmltest VALUES (1, '<value>one</value>'); + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. INSERT INTO xmltest VALUES (2, '<value>two</value>'); ERROR: unsupported XML feature +LINE 1: INSERT INTO xmltest VALUES (2, '<value>two</value>'); + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. INSERT INTO xmltest VALUES (3, '<wrong'); ERROR: unsupported XML feature +LINE 1: INSERT INTO xmltest VALUES (3, '<wrong'); + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT * FROM xmltest; @@ -47,6 +53,8 @@ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlconcat('hello', 'you'); ERROR: unsupported XML feature +LINE 1: SELECT xmlconcat('hello', 'you'); + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlconcat(1, 2); @@ -55,14 +63,20 @@ LINE 1: SELECT xmlconcat(1, 2); ^ SELECT xmlconcat('bad', '<syntax'); ERROR: unsupported XML feature +LINE 1: SELECT xmlconcat('bad', '<syntax'); + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlconcat('<foo/>', NULL, '<?xml version="1.1" standalone="no"?><bar/>'); ERROR: unsupported XML feature +LINE 1: SELECT xmlconcat('<foo/>', NULL, '<?xml version="1.1" standa... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlconcat('<?xml version="1.1"?><foo/>', NULL, '<?xml version="1.1" standalone="no"?><bar/>'); ERROR: unsupported XML feature +LINE 1: SELECT xmlconcat('<?xml version="1.1"?><foo/>', NULL, '<?xml... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlelement(name element, @@ -180,34 +194,50 @@ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlroot(xml '<foo/>', version no value, standalone no value); ERROR: unsupported XML feature +LINE 1: SELECT xmlroot(xml '<foo/>', version no value, standalone no... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlroot(xml '<foo/>', version '2.0'); ERROR: unsupported XML feature +LINE 1: SELECT xmlroot(xml '<foo/>', version '2.0'); + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlroot(xml '<foo/>', version no value, standalone yes); ERROR: unsupported XML feature +LINE 1: SELECT xmlroot(xml '<foo/>', version no value, standalone ye... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlroot(xml '<?xml version="1.1"?><foo/>', version no value, standalone yes); ERROR: unsupported XML feature +LINE 1: SELECT xmlroot(xml '<?xml version="1.1"?><foo/>', version no... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlroot(xmlroot(xml '<foo/>', version '1.0'), version '1.1', standalone no); ERROR: unsupported XML feature +LINE 1: SELECT xmlroot(xmlroot(xml '<foo/>', version '1.0'), version... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlroot('<?xml version="1.1" standalone="yes"?><foo/>', version no value, standalone no); ERROR: unsupported XML feature +LINE 1: SELECT xmlroot('<?xml version="1.1" standalone="yes"?><foo/>... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlroot('<?xml version="1.1" standalone="yes"?><foo/>', version no value, standalone no value); ERROR: unsupported XML feature +LINE 1: SELECT xmlroot('<?xml version="1.1" standalone="yes"?><foo/>... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlroot('<?xml version="1.1" standalone="yes"?><foo/>', version no value); ERROR: unsupported XML feature +LINE 1: SELECT xmlroot('<?xml version="1.1" standalone="yes"?><foo/>... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlroot ( @@ -235,30 +265,44 @@ SELECT xmlserialize(content data as character varying(20)) FROM xmltest; SELECT xmlserialize(content 'good' as char(10)); ERROR: unsupported XML feature +LINE 1: SELECT xmlserialize(content 'good' as char(10)); + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlserialize(document 'bad' as text); ERROR: unsupported XML feature +LINE 1: SELECT xmlserialize(document 'bad' as text); + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xml '<foo>bar</foo>' IS DOCUMENT; ERROR: unsupported XML feature +LINE 1: SELECT xml '<foo>bar</foo>' IS DOCUMENT; + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xml '<foo>bar</foo><bar>foo</bar>' IS DOCUMENT; ERROR: unsupported XML feature +LINE 1: SELECT xml '<foo>bar</foo><bar>foo</bar>' IS DOCUMENT; + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xml '<abc/>' IS NOT DOCUMENT; ERROR: unsupported XML feature +LINE 1: SELECT xml '<abc/>' IS NOT DOCUMENT; + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xml 'abc' IS NOT DOCUMENT; ERROR: unsupported XML feature +LINE 1: SELECT xml 'abc' IS NOT DOCUMENT; + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT '<>' IS NOT DOCUMENT; ERROR: unsupported XML feature +LINE 1: SELECT '<>' IS NOT DOCUMENT; + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xmlagg(data) FROM xmltest; @@ -288,6 +332,8 @@ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. PREPARE foo (xml) AS SELECT xmlconcat('<foo/>', $1); ERROR: unsupported XML feature +LINE 1: PREPARE foo (xml) AS SELECT xmlconcat('<foo/>', $1); + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SET XML OPTION DOCUMENT; @@ -304,6 +350,8 @@ ERROR: prepared statement "foo" does not exist CREATE VIEW xmlview1 AS SELECT xmlcomment('test'); CREATE VIEW xmlview2 AS SELECT xmlconcat('hello', 'you'); ERROR: unsupported XML feature +LINE 1: CREATE VIEW xmlview2 AS SELECT xmlconcat('hello', 'you'); + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. CREATE VIEW xmlview3 AS SELECT xmlelement(name element, xmlattributes (1 as ":one:", 'deuce' as two), 'content&'); @@ -321,14 +369,20 @@ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. CREATE VIEW xmlview7 AS SELECT xmlroot(xml '<foo/>', version no value, standalone yes); ERROR: unsupported XML feature +LINE 1: CREATE VIEW xmlview7 AS SELECT xmlroot(xml '<foo/>', version... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. CREATE VIEW xmlview8 AS SELECT xmlserialize(content 'good' as char(10)); ERROR: unsupported XML feature +LINE 1: ...EATE VIEW xmlview8 AS SELECT xmlserialize(content 'good' as ... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. CREATE VIEW xmlview9 AS SELECT xmlserialize(content 'good' as text); ERROR: unsupported XML feature +LINE 1: ...EATE VIEW xmlview9 AS SELECT xmlserialize(content 'good' as ... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT table_name, view_definition FROM information_schema.views @@ -352,17 +406,25 @@ SELECT xpath(NULL, NULL) IS NULL FROM xmltest; SELECT xpath('', '<!-- error -->'); ERROR: unsupported XML feature +LINE 1: SELECT xpath('', '<!-- error -->'); + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local:piece id="2" /></local:data>'); ERROR: unsupported XML feature +LINE 1: SELECT xpath('//text()', '<local:data xmlns:local="http://12... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xpath('//loc:piece/@id', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local:piece id="2" /></local:data>', ARRAY[ARRAY['loc', 'http://127.0.0.1']]); ERROR: unsupported XML feature +LINE 1: SELECT xpath('//loc:piece/@id', '<local:data xmlns:local="ht... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. SELECT xpath('//b', '<a>one <b>two</b> three <b>etc</b></a>'); ERROR: unsupported XML feature +LINE 1: SELECT xpath('//b', '<a>one <b>two</b> three <b>etc</b></a>'... + ^ DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. diff --git a/src/test/regress/output/create_function_1.source b/src/test/regress/output/create_function_1.source index 5c3779a225..d3abca0caa 100644 --- a/src/test/regress/output/create_function_1.source +++ b/src/test/regress/output/create_function_1.source @@ -66,7 +66,8 @@ CONTEXT: SQL function "test1" CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL AS 'SELECT $2;'; ERROR: there is no parameter $2 -CONTEXT: SQL function "test1" +LINE 2: AS 'SELECT $2;'; + ^ CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL AS 'a', 'b'; ERROR: only one AS item needed for language "sql" |