Thread: Current CVS parallel test lock
Running latest cvs on freebsd gives me errors in test strings and test
errors, and completely hangs at this point:
parallel group (14 tests): limit prepare sequence copy2 truncate
rowtypes polymorphism temp domain conversion rangefuncs without_oid
alter_table
Chris
parallel group (13 tests): text name varchar char oid boolean int2 int8 float4 int4 float8 bit numeric
boolean ... ok
char ... ok
name ... ok
varchar ... ok
text ... ok
int2 ... ok
int4 ... ok
int8 ... ok
oid ... ok
float4 ... ok
float8 ... ok
bit ... ok
numeric ... ok
test strings ... FAILED
test numerology ... ok
parallel group (20 tests): comments time lseg reltime path timetz abstime circle tinterval box point type_sanity
polygoninterval inet timestamp timestamptz date oidjoins opr_sanity
point ... ok
lseg ... ok
box ... ok
path ... ok
polygon ... ok
circle ... ok
date ... ok
time ... ok
timetz ... ok
timestamp ... ok
timestamptz ... ok
interval ... ok
abstime ... ok
reltime ... ok
tinterval ... ok
inet ... ok
comments ... ok
oidjoins ... ok
type_sanity ... ok
opr_sanity ... ok
test geometry ... ok
test horology ... ok
test insert ... ok
test create_function_1 ... FAILED
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
test copy ... ok
parallel group (7 tests): create_operator create_aggregate vacuum triggers constraints inherit create_misc
constraints ... FAILED
triggers ... ok
create_misc ... ok
create_aggregate ... ok
create_operator ... ok
inherit ... ok
vacuum ... ok
parallel group (2 tests): create_view create_index
create_index ... ok
create_view ... ok
test sanity_check ... ok
test errors ... FAILED
test select ... ok
parallel group (18 tests): select_distinct_on select_into update random namespace select_having select_distinct case
select_implicitbtree_index aggregates union subselect portals join arrays transactions hash_index
select_into ... ok
select_distinct ... ok
select_distinct_on ... ok
select_implicit ... ok
select_having ... ok
subselect ... ok
union ... ok
case ... ok
join ... ok
aggregates ... ok
transactions ... ok
random ... ok
portals ... ok
arrays ... ok
btree_index ... ok
hash_index ... ok
update ... ok
namespace ... ok
test privileges ... ok
test misc ... ok
parallel group (5 tests): select_views portals_p2 cluster foreign_key rules
select_views ... ok
portals_p2 ... ok
rules ... ok
foreign_key ... ok
cluster ... ok
parallel group (14 tests): limit prepare sequence copy2 truncate rowtypes polymorphism temp domain conversion
rangefuncswithout_oid alter_table*** ./expected/strings.out Sun Mar 14 12:25:17 2004
--- ./results/strings.out Wed Mar 9 14:48:33 2005
***************
*** 19,26 ****
' - third line'
AS "Illegal comment within continuation";
ERROR: syntax error at or near "' - third line'" at character 75
- LINE 3: ' - third line'
- ^
--
-- test conversions between various string types
-- E021-10 implicit casting among the character data types
--- 19,24 ----
======================================================================
*** ./expected/create_function_1.out Thu Oct 21 11:12:15 2004
--- ./results/create_function_1.out Wed Mar 9 14:48:38 2005
***************
*** 56,63 ****
CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
AS 'not even SQL';
ERROR: syntax error at or near "not" at character 62
- LINE 2: AS 'not even SQL';
- ^
CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
AS 'SELECT 1, 2, 3;';
ERROR: return type mismatch in function declared to return integer
--- 56,61 ----
======================================================================
*** ./expected/constraints.out Thu Oct 21 11:12:15 2004
--- ./results/constraints.out Wed Mar 9 14:48:43 2005
***************
*** 46,60 ****
-- test for extraneous comma
CREATE TABLE error_tbl (i int DEFAULT (100, ));
ERROR: syntax error at or near ")" at character 45
- LINE 1: CREATE TABLE error_tbl (i int DEFAULT (100, ));
- ^
-- this will fail because gram.y uses b_expr not a_expr for defaults,
-- to avoid a shift/reduce conflict that arises from NOT NULL being
-- part of the column definition syntax:
CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));
ERROR: syntax error at or near "IN" at character 43
- LINE 1: CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));
- ^
-- this should work, however:
CREATE TABLE error_tbl (b1 bool DEFAULT (1 IN (1, 2)));
DROP TABLE error_tbl;
--- 46,56 ----
======================================================================
*** ./expected/errors.out Sat Mar 5 13:48:48 2005
--- ./results/errors.out Wed Mar 9 14:48:57 2005
***************
*** 20,35 ****
-- missing relation name
select;
ERROR: syntax error at or near ";" at character 7
- LINE 1: select;
- ^
-- no such relation
select * from nonesuch;
ERROR: relation "nonesuch" does not exist
-- missing target list
select from pg_database;
ERROR: syntax error at or near "from" at character 8
- LINE 1: select from pg_database;
- ^
-- bad name in target list
select nonesuch from pg_database;
ERROR: column "nonesuch" does not exist
--- 20,31 ----
***************
*** 42,49 ****
-- bad select distinct on syntax, distinct attribute missing
select distinct on (foobar) from pg_database;
ERROR: syntax error at or near "from" at character 29
- LINE 1: select distinct on (foobar) from pg_database;
- ^
-- bad select distinct on syntax, distinct attribute not in target list
select distinct on (foobar) * from pg_database;
ERROR: column "foobar" does not exist
--- 38,43 ----
***************
*** 53,60 ****
-- missing relation name (this had better not wildcard!)
delete from;
ERROR: syntax error at or near ";" at character 12
- LINE 1: delete from;
- ^
-- no such relation
delete from nonesuch;
ERROR: relation "nonesuch" does not exist
--- 47,52 ----
***************
*** 64,71 ****
-- missing relation name (this had better not wildcard!)
drop table;
ERROR: syntax error at or near ";" at character 11
- LINE 1: drop table;
- ^
-- no such relation
drop table nonesuch;
ERROR: table "nonesuch" does not exist
--- 56,61 ----
***************
*** 76,83 ****
-- missing relation name
alter table rename;
ERROR: syntax error at or near ";" at character 19
- LINE 1: alter table rename;
- ^
-- no such relation
alter table nonesuch rename to newnonesuch;
ERROR: relation "nonesuch" does not exist
--- 66,71 ----
***************
*** 132,144 ****
-- missing index name
drop index;
ERROR: syntax error at or near ";" at character 11
- LINE 1: drop index;
- ^
-- bad index name
drop index 314159;
ERROR: syntax error at or near "314159" at character 12
- LINE 1: drop index 314159;
- ^
-- no such index
drop index nonesuch;
ERROR: index "nonesuch" does not exist
--- 120,128 ----
***************
*** 148,165 ****
-- missing aggregate name
drop aggregate;
ERROR: syntax error at or near ";" at character 15
- LINE 1: drop aggregate;
- ^
-- missing aggregate type
drop aggregate newcnt1;
ERROR: syntax error at or near ";" at character 23
- LINE 1: drop aggregate newcnt1;
- ^
-- bad aggregate name
drop aggregate 314159 (int);
ERROR: syntax error at or near "314159" at character 16
- LINE 1: drop aggregate 314159 (int);
- ^
-- bad aggregate type
drop aggregate newcnt (nonesuch);
ERROR: type "nonesuch" does not exist
--- 132,143 ----
***************
*** 175,187 ****
-- missing function name
drop function ();
ERROR: syntax error at or near "(" at character 15
- LINE 1: drop function ();
- ^
-- bad function name
drop function 314159();
ERROR: syntax error at or near "314159" at character 15
- LINE 1: drop function 314159();
- ^
-- no such function
drop function nonesuch();
ERROR: function nonesuch() does not exist
--- 153,161 ----
***************
*** 191,203 ****
-- missing type name
drop type;
ERROR: syntax error at or near ";" at character 10
- LINE 1: drop type;
- ^
-- bad type name
drop type 314159;
ERROR: syntax error at or near "314159" at character 11
- LINE 1: drop type 314159;
- ^
-- no such type
drop type nonesuch;
ERROR: type "nonesuch" does not exist
--- 165,173 ----
***************
*** 207,239 ****
-- missing everything
drop operator;
ERROR: syntax error at or near ";" at character 14
- LINE 1: drop operator;
- ^
-- bad operator name
drop operator equals;
ERROR: syntax error at or near ";" at character 21
- LINE 1: drop operator equals;
- ^
-- missing type list
drop operator ===;
ERROR: syntax error at or near ";" at character 18
- LINE 1: drop operator ===;
- ^
-- missing parentheses
drop operator int4, int4;
ERROR: syntax error at or near "," at character 19
- LINE 1: drop operator int4, int4;
- ^
-- missing operator name
drop operator (int4, int4);
ERROR: syntax error at or near "(" at character 15
- LINE 1: drop operator (int4, int4);
- ^
-- missing type list contents
drop operator === ();
ERROR: syntax error at or near ")" at character 20
- LINE 1: drop operator === ();
- ^
-- no such operator
drop operator === (int4);
ERROR: missing argument
--- 177,197 ----
***************
*** 248,255 ****
-- no such type1
drop operator = ( , int4);
ERROR: syntax error at or near "," at character 19
- LINE 1: drop operator = ( , int4);
- ^
-- no such type1
drop operator = (nonesuch, int4);
ERROR: type nonesuch does not exist
--- 206,211 ----
***************
*** 259,295 ****
-- no such type2
drop operator = (int4, );
ERROR: syntax error at or near ")" at character 24
- LINE 1: drop operator = (int4, );
- ^
--
-- DROP RULE
-- missing rule name
drop rule;
ERROR: syntax error at or near ";" at character 10
- LINE 1: drop rule;
- ^
-- bad rule name
drop rule 314159;
ERROR: syntax error at or near "314159" at character 11
- LINE 1: drop rule 314159;
- ^
-- no such rule
drop rule nonesuch on noplace;
ERROR: relation "noplace" does not exist
-- these postquel variants are no longer supported
drop tuple rule nonesuch;
ERROR: syntax error at or near "tuple" at character 6
- LINE 1: drop tuple rule nonesuch;
- ^
drop instance rule nonesuch on noplace;
ERROR: syntax error at or near "instance" at character 6
- LINE 1: drop instance rule nonesuch on noplace;
- ^
drop rewrite rule nonesuch;
ERROR: syntax error at or near "rewrite" at character 6
- LINE 1: drop rewrite rule nonesuch;
- ^
--
-- Check that division-by-zero is properly caught.
--
--- 215,239 ----
***************
*** 320,380 ****
--
xxx;
ERROR: syntax error at or near "xxx" at character 1
- LINE 1: xxx;
- ^
CREATE foo;
ERROR: syntax error at or near "foo" at character 8
- LINE 1: CREATE foo;
- ^
CREATE TABLE ;
ERROR: syntax error at or near ";" at character 14
- LINE 1: CREATE TABLE ;
- ^
CREATE TABLE
\g
ERROR: syntax error at end of input at character 13
- LINE 1: CREATE TABLE
- ^
INSERT INTO foo VALUES(123) foo;
ERROR: syntax error at or near "foo" at character 29
- LINE 1: INSERT INTO foo VALUES(123) foo;
- ^
INSERT INTO 123
VALUES(123);
ERROR: syntax error at or near "123" at character 13
- LINE 1: INSERT INTO 123
- ^
INSERT INTO foo
VALUES(123) 123
;
ERROR: syntax error at or near "123" at character 30
- LINE 2: VALUES(123) 123
- ^
-- with a tab
CREATE TABLE foo
(id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL PRIMARY KEY,
id3 INTEGER NOT NUL,
id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL);
ERROR: syntax error at or near "NUL" at character 94
- LINE 3: id3 INTEGER NOT NUL,
- ^
-- long line to be truncated on the left
CREATE TABLE foo(id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL,
id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL);
ERROR: syntax error at or near "NUL" at character 90
- LINE 1: ...T NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL,
- ^
-- long line to be truncated on the right
CREATE TABLE foo(
id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL, id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL
PRIMARYKEY);
ERROR: syntax error at or near "NUL" at character 35
- LINE 2: id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQ...
- ^
-- long line to be truncated both ways
CREATE TABLE foo(id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT
NULL,id5 TEXT UNIQUE NOT NULL);
ERROR: syntax error at or near "NUL" at character 90
- LINE 1: ...L, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 I...
- ^
-- long line to be truncated on the left, many lines
CREATE
TEMPORARY
--- 264,302 ----
***************
*** 390,397 ****
NULL)
;
ERROR: syntax error at or near "NUL" at character 101
- LINE 4: ...T NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL,
- ^
-- long line to be truncated on the right, many lines
CREATE
TEMPORARY
--- 312,317 ----
***************
*** 400,407 ****
id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL, id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL
PRIMARYKEY)
;
ERROR: syntax error at or near "NUL" at character 47
- LINE 5: id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQ...
- ^
-- long line to be truncated both ways, many lines
CREATE
TEMPORARY
--- 320,325 ----
***************
*** 413,420 ****
idz INT4 UNIQUE NOT NULL,
idv INT4 UNIQUE NOT NULL);
ERROR: syntax error at or near "NUL" at character 157
- LINE 7: ...L, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 I...
- ^
-- more than 10 lines...
CREATE
TEMPORARY
--- 331,336 ----
***************
*** 439,446 ****
NOT
NULL);
ERROR: syntax error at or near "NUL" at character 190
- LINE 16: ...L, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 I...
- ^
-- Check that stack depth detection mechanism works and
-- max_stack_depth is not set too high
create function infinite_recurse() returns int as
--- 355,360 ----
======================================================================
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Running latest cvs on freebsd gives me errors in test strings and test
> errors, and completely hangs at this point:
Time for a clean rebuild? I've not seen any failures, neither has
the build farm ...
regards, tom lane
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
> Running latest cvs on freebsd gives me errors in test strings and test
> errors, and completely hangs at this point:
I got a similar problem and system hangs randomly(esp. in test strings) in
win32-mingw. The problem I found is in pgunlink(). There is a potential
deadloop in
while (unlink(path))
{ ...
}
However, if we wait long enough( I waited for 20 mins or so), the system
finally go on. I guess that's because of the hot-long-discussed "win32's
inability of removing file-in-use" problem(though FILE_SHARE_DELETE flag is
added). Shall we add a time-limit or something to handle this situation?
>
> parallel group (14 tests): limit prepare sequence copy2 truncate
> rowtypes polymorphism temp domain conversion rangefuncs without_oid
> alter_table
>
> Chris
>
> Time for a clean rebuild? I've not seen any failures, neither has
> the build farm ...
cvs up
gmake clean
./configure --prefix=/home/chriskl/local --enable-depend --enable-debug
--enable-cassert --with-perl --with-pam --with-openssl
gmake check
Still hangs. Gets new failure in create function and constraints.
Seems to be differences in how it's indicating syntax errors.
My src/bin/psql is in the 7_4_STABLE branch, but that shouldn't affect
anything.
Chris
parallel group (13 tests): text name varchar char oid boolean int8 int2 float4 int4 float8 bit numeric
boolean ... ok
char ... ok
name ... ok
varchar ... ok
text ... ok
int2 ... ok
int4 ... ok
int8 ... ok
oid ... ok
float4 ... ok
float8 ... ok
bit ... ok
numeric ... ok
test strings ... FAILED
test numerology ... ok
parallel group (20 tests): comments time reltime path timetz circle point lseg box tinterval polygon inet abstime
type_sanityinterval timestamp date oidjoins timestamptz opr_sanity
point ... ok
lseg ... ok
box ... ok
path ... ok
polygon ... ok
circle ... ok
date ... ok
time ... ok
timetz ... ok
timestamp ... ok
timestamptz ... ok
interval ... ok
abstime ... ok
reltime ... ok
tinterval ... ok
inet ... ok
comments ... ok
oidjoins ... ok
type_sanity ... ok
opr_sanity ... ok
test geometry ... ok
test horology ... ok
test insert ... ok
test create_function_1 ... FAILED
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
test copy ... ok
parallel group (7 tests): create_operator create_aggregate constraints vacuum triggers inherit create_misc
constraints ... FAILED
triggers ... ok
create_misc ... ok
create_aggregate ... ok
create_operator ... ok
inherit ... ok
vacuum ... ok
parallel group (2 tests): create_view create_index
create_index ... ok
create_view ... ok
test sanity_check ... ok
test errors ... FAILED
test select ... ok
parallel group (18 tests): select_distinct_on select_into update random namespace select_having select_distinct
btree_indexcase hash_index aggregates union select_implicit portals join arrays transactions subselect
select_into ... ok
select_distinct ... ok
select_distinct_on ... ok
select_implicit ... ok
select_having ... ok
subselect ... ok
union ... ok
case ... ok
join ... ok
aggregates ... ok
transactions ... ok
random ... ok
portals ... ok
arrays ... ok
btree_index ... ok
hash_index ... ok
update ... ok
namespace ... ok
test privileges ... ok
test misc ... ok
parallel group (5 tests): portals_p2 select_views cluster foreign_key rules
select_views ... ok
portals_p2 ... ok
rules ... ok
foreign_key ... ok
cluster ... ok
parallel group (14 tests): limit prepare sequence copy2 truncate polymorphism rowtypes temp rangefuncs conversion
domainwithout_oid alter_table*** ./expected/strings.out Sun Mar 14 12:25:17 2004
--- ./results/strings.out Wed Mar 9 15:19:16 2005
***************
*** 19,26 ****
' - third line'
AS "Illegal comment within continuation";
ERROR: syntax error at or near "' - third line'" at character 75
- LINE 3: ' - third line'
- ^
--
-- test conversions between various string types
-- E021-10 implicit casting among the character data types
--- 19,24 ----
======================================================================
*** ./expected/create_function_1.out Wed Mar 9 15:18:46 2005
--- ./results/create_function_1.out Wed Mar 9 15:19:21 2005
***************
*** 56,63 ****
CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
AS 'not even SQL';
ERROR: syntax error at or near "not" at character 62
- LINE 2: AS 'not even SQL';
- ^
CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
AS 'SELECT 1, 2, 3;';
ERROR: return type mismatch in function declared to return integer
--- 56,61 ----
======================================================================
*** ./expected/constraints.out Wed Mar 9 15:18:46 2005
--- ./results/constraints.out Wed Mar 9 15:19:24 2005
***************
*** 46,60 ****
-- test for extraneous comma
CREATE TABLE error_tbl (i int DEFAULT (100, ));
ERROR: syntax error at or near ")" at character 45
- LINE 1: CREATE TABLE error_tbl (i int DEFAULT (100, ));
- ^
-- this will fail because gram.y uses b_expr not a_expr for defaults,
-- to avoid a shift/reduce conflict that arises from NOT NULL being
-- part of the column definition syntax:
CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));
ERROR: syntax error at or near "IN" at character 43
- LINE 1: CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));
- ^
-- this should work, however:
CREATE TABLE error_tbl (b1 bool DEFAULT (1 IN (1, 2)));
DROP TABLE error_tbl;
--- 46,56 ----
======================================================================
*** ./expected/errors.out Sat Mar 5 13:48:48 2005
--- ./results/errors.out Wed Mar 9 15:19:41 2005
***************
*** 20,35 ****
-- missing relation name
select;
ERROR: syntax error at or near ";" at character 7
- LINE 1: select;
- ^
-- no such relation
select * from nonesuch;
ERROR: relation "nonesuch" does not exist
-- missing target list
select from pg_database;
ERROR: syntax error at or near "from" at character 8
- LINE 1: select from pg_database;
- ^
-- bad name in target list
select nonesuch from pg_database;
ERROR: column "nonesuch" does not exist
--- 20,31 ----
***************
*** 42,49 ****
-- bad select distinct on syntax, distinct attribute missing
select distinct on (foobar) from pg_database;
ERROR: syntax error at or near "from" at character 29
- LINE 1: select distinct on (foobar) from pg_database;
- ^
-- bad select distinct on syntax, distinct attribute not in target list
select distinct on (foobar) * from pg_database;
ERROR: column "foobar" does not exist
--- 38,43 ----
***************
*** 53,60 ****
-- missing relation name (this had better not wildcard!)
delete from;
ERROR: syntax error at or near ";" at character 12
- LINE 1: delete from;
- ^
-- no such relation
delete from nonesuch;
ERROR: relation "nonesuch" does not exist
--- 47,52 ----
***************
*** 64,71 ****
-- missing relation name (this had better not wildcard!)
drop table;
ERROR: syntax error at or near ";" at character 11
- LINE 1: drop table;
- ^
-- no such relation
drop table nonesuch;
ERROR: table "nonesuch" does not exist
--- 56,61 ----
***************
*** 76,83 ****
-- missing relation name
alter table rename;
ERROR: syntax error at or near ";" at character 19
- LINE 1: alter table rename;
- ^
-- no such relation
alter table nonesuch rename to newnonesuch;
ERROR: relation "nonesuch" does not exist
--- 66,71 ----
***************
*** 132,144 ****
-- missing index name
drop index;
ERROR: syntax error at or near ";" at character 11
- LINE 1: drop index;
- ^
-- bad index name
drop index 314159;
ERROR: syntax error at or near "314159" at character 12
- LINE 1: drop index 314159;
- ^
-- no such index
drop index nonesuch;
ERROR: index "nonesuch" does not exist
--- 120,128 ----
***************
*** 148,165 ****
-- missing aggregate name
drop aggregate;
ERROR: syntax error at or near ";" at character 15
- LINE 1: drop aggregate;
- ^
-- missing aggregate type
drop aggregate newcnt1;
ERROR: syntax error at or near ";" at character 23
- LINE 1: drop aggregate newcnt1;
- ^
-- bad aggregate name
drop aggregate 314159 (int);
ERROR: syntax error at or near "314159" at character 16
- LINE 1: drop aggregate 314159 (int);
- ^
-- bad aggregate type
drop aggregate newcnt (nonesuch);
ERROR: type "nonesuch" does not exist
--- 132,143 ----
***************
*** 175,187 ****
-- missing function name
drop function ();
ERROR: syntax error at or near "(" at character 15
- LINE 1: drop function ();
- ^
-- bad function name
drop function 314159();
ERROR: syntax error at or near "314159" at character 15
- LINE 1: drop function 314159();
- ^
-- no such function
drop function nonesuch();
ERROR: function nonesuch() does not exist
--- 153,161 ----
***************
*** 191,203 ****
-- missing type name
drop type;
ERROR: syntax error at or near ";" at character 10
- LINE 1: drop type;
- ^
-- bad type name
drop type 314159;
ERROR: syntax error at or near "314159" at character 11
- LINE 1: drop type 314159;
- ^
-- no such type
drop type nonesuch;
ERROR: type "nonesuch" does not exist
--- 165,173 ----
***************
*** 207,239 ****
-- missing everything
drop operator;
ERROR: syntax error at or near ";" at character 14
- LINE 1: drop operator;
- ^
-- bad operator name
drop operator equals;
ERROR: syntax error at or near ";" at character 21
- LINE 1: drop operator equals;
- ^
-- missing type list
drop operator ===;
ERROR: syntax error at or near ";" at character 18
- LINE 1: drop operator ===;
- ^
-- missing parentheses
drop operator int4, int4;
ERROR: syntax error at or near "," at character 19
- LINE 1: drop operator int4, int4;
- ^
-- missing operator name
drop operator (int4, int4);
ERROR: syntax error at or near "(" at character 15
- LINE 1: drop operator (int4, int4);
- ^
-- missing type list contents
drop operator === ();
ERROR: syntax error at or near ")" at character 20
- LINE 1: drop operator === ();
- ^
-- no such operator
drop operator === (int4);
ERROR: missing argument
--- 177,197 ----
***************
*** 248,255 ****
-- no such type1
drop operator = ( , int4);
ERROR: syntax error at or near "," at character 19
- LINE 1: drop operator = ( , int4);
- ^
-- no such type1
drop operator = (nonesuch, int4);
ERROR: type nonesuch does not exist
--- 206,211 ----
***************
*** 259,295 ****
-- no such type2
drop operator = (int4, );
ERROR: syntax error at or near ")" at character 24
- LINE 1: drop operator = (int4, );
- ^
--
-- DROP RULE
-- missing rule name
drop rule;
ERROR: syntax error at or near ";" at character 10
- LINE 1: drop rule;
- ^
-- bad rule name
drop rule 314159;
ERROR: syntax error at or near "314159" at character 11
- LINE 1: drop rule 314159;
- ^
-- no such rule
drop rule nonesuch on noplace;
ERROR: relation "noplace" does not exist
-- these postquel variants are no longer supported
drop tuple rule nonesuch;
ERROR: syntax error at or near "tuple" at character 6
- LINE 1: drop tuple rule nonesuch;
- ^
drop instance rule nonesuch on noplace;
ERROR: syntax error at or near "instance" at character 6
- LINE 1: drop instance rule nonesuch on noplace;
- ^
drop rewrite rule nonesuch;
ERROR: syntax error at or near "rewrite" at character 6
- LINE 1: drop rewrite rule nonesuch;
- ^
--
-- Check that division-by-zero is properly caught.
--
--- 215,239 ----
***************
*** 320,380 ****
--
xxx;
ERROR: syntax error at or near "xxx" at character 1
- LINE 1: xxx;
- ^
CREATE foo;
ERROR: syntax error at or near "foo" at character 8
- LINE 1: CREATE foo;
- ^
CREATE TABLE ;
ERROR: syntax error at or near ";" at character 14
- LINE 1: CREATE TABLE ;
- ^
CREATE TABLE
\g
ERROR: syntax error at end of input at character 13
- LINE 1: CREATE TABLE
- ^
INSERT INTO foo VALUES(123) foo;
ERROR: syntax error at or near "foo" at character 29
- LINE 1: INSERT INTO foo VALUES(123) foo;
- ^
INSERT INTO 123
VALUES(123);
ERROR: syntax error at or near "123" at character 13
- LINE 1: INSERT INTO 123
- ^
INSERT INTO foo
VALUES(123) 123
;
ERROR: syntax error at or near "123" at character 30
- LINE 2: VALUES(123) 123
- ^
-- with a tab
CREATE TABLE foo
(id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL PRIMARY KEY,
id3 INTEGER NOT NUL,
id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL);
ERROR: syntax error at or near "NUL" at character 94
- LINE 3: id3 INTEGER NOT NUL,
- ^
-- long line to be truncated on the left
CREATE TABLE foo(id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL,
id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL);
ERROR: syntax error at or near "NUL" at character 90
- LINE 1: ...T NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL,
- ^
-- long line to be truncated on the right
CREATE TABLE foo(
id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL, id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL
PRIMARYKEY);
ERROR: syntax error at or near "NUL" at character 35
- LINE 2: id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQ...
- ^
-- long line to be truncated both ways
CREATE TABLE foo(id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT
NULL,id5 TEXT UNIQUE NOT NULL);
ERROR: syntax error at or near "NUL" at character 90
- LINE 1: ...L, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 I...
- ^
-- long line to be truncated on the left, many lines
CREATE
TEMPORARY
--- 264,302 ----
***************
*** 390,397 ****
NULL)
;
ERROR: syntax error at or near "NUL" at character 101
- LINE 4: ...T NULL, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL,
- ^
-- long line to be truncated on the right, many lines
CREATE
TEMPORARY
--- 312,317 ----
***************
*** 400,407 ****
id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQUE NOT NULL, id INT4 UNIQUE NOT NULL, id2 TEXT NOT NULL
PRIMARYKEY)
;
ERROR: syntax error at or near "NUL" at character 47
- LINE 5: id3 INTEGER NOT NUL, id4 INT4 UNIQUE NOT NULL, id5 TEXT UNIQ...
- ^
-- long line to be truncated both ways, many lines
CREATE
TEMPORARY
--- 320,325 ----
***************
*** 413,420 ****
idz INT4 UNIQUE NOT NULL,
idv INT4 UNIQUE NOT NULL);
ERROR: syntax error at or near "NUL" at character 157
- LINE 7: ...L, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 I...
- ^
-- more than 10 lines...
CREATE
TEMPORARY
--- 331,336 ----
***************
*** 439,446 ****
NOT
NULL);
ERROR: syntax error at or near "NUL" at character 190
- LINE 16: ...L, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 I...
- ^
-- Check that stack depth detection mechanism works and
-- max_stack_depth is not set too high
create function infinite_recurse() returns int as
--- 355,360 ----
======================================================================
On Wed, Mar 09, 2005 at 03:24:20PM +0800, Christopher Kings-Lynne wrote: > gmake clean Have you tried "gmake distclean"? I just built the latest HEAD on FreeBSD 4.11-STABLE and all tests passed. Configure options were: ./configure --prefix=/usr/local/pgsql81 \ --with-pgport=5481 \ --with-openssl \ --with-perl\ --with-python \ --with-tcl \ --with-tclconfig=/usr/local/lib/tcl8.4 \ --enable-debug \ --enable-cassert -- Michael Fuhr http://www.fuhr.org/~mfuhr/
> Have you tried "gmake distclean"? > > I just built the latest HEAD on FreeBSD 4.11-STABLE and all tests > passed. Configure options were: Hrm, I just did a gmake install; gmake installcheck - that worked fine. Then I did gmake check again and now that worksfine... It must have been picking up something from my previously installed pgsql. Chris
On Wed, Mar 09, 2005 at 03:43:38PM +0800, Christopher Kings-Lynne wrote: > Hrm, I just did a gmake install; gmake installcheck - that worked fine. > Then I did gmake check again and now that works fine... > > It must have been picking up something from my previously installed pgsql. Do you have a way to revert to the old installation to check whether the checks fail again? It might be useful to track down exactly what happened. It seems wrong that a currently-installed version should have adverse effects on a just-built version's regression tests. -- Michael Fuhr http://www.fuhr.org/~mfuhr/
> Do you have a way to revert to the old installation to check whether > the checks fail again? It might be useful to track down exactly > what happened. It seems wrong that a currently-installed version > should have adverse effects on a just-built version's regression > tests. No :)
Michael Fuhr <mike@fuhr.org> writes:
> Do you have a way to revert to the old installation to check whether
> the checks fail again? It might be useful to track down exactly
> what happened. It seems wrong that a currently-installed version
> should have adverse effects on a just-built version's regression
> tests.
We've seen that happen many times with shared library dependencies
... but libpq hasn't changed in the last few days AFAIR.
regards, tom lane
>>Do you have a way to revert to the old installation to check whether >>the checks fail again? It might be useful to track down exactly >>what happened. It seems wrong that a currently-installed version >>should have adverse effects on a just-built version's regression >>tests. > > > We've seen that happen many times with shared library dependencies > ... but libpq hasn't changed in the last few days AFAIR. I hadn't done a gmake install for months due to being overseas... Chris