2024-11-30 22:53:02.323 UTC postmaster[20175] LOG:  starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit
2024-11-30 22:53:02.323 UTC postmaster[20175] LOG:  listening on Unix socket "/tmp/pg_regress-ocjdVh/.s.PGSQL.40043"
2024-11-30 22:53:02.325 UTC startup[20178] LOG:  database system was shut down at 2024-11-30 22:53:02 UTC
2024-11-30 22:53:02.327 UTC postmaster[20175] LOG:  database system is ready to accept connections
2024-11-30 22:53:02.411 UTC client backend[20186] pg_regress/tablefunc ERROR:  number of rows cannot be negative
2024-11-30 22:53:02.411 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT avg(normal_rand)::int, count(*) FROM normal_rand(-1, 250, 0.2);
2024-11-30 22:53:02.422 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid crosstab source data query
2024-11-30 22:53:02.422 UTC client backend[20186] pg_regress/tablefunc DETAIL:  The query must return 3 columns: row_name, category, and value.
2024-11-30 22:53:02.422 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM crosstab('SELECT rowid, val FROM ct where rowclass = ''group1'' and (attribute = ''att2'' or attribute = ''att3'') ORDER BY 1,2;')
	  AS ct(row_name text, category_1 text, category_2 text);
2024-11-30 22:53:02.422 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid crosstab return type
2024-11-30 22:53:02.422 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Return row must have at least two columns.
2024-11-30 22:53:02.422 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM crosstab('SELECT rowid, attribute, val FROM ct where rowclass = ''group1'' and (attribute = ''att2'' or attribute = ''att3'') ORDER BY 1,2;')
	  AS ct(row_name text);
2024-11-30 22:53:02.423 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid crosstab return type
2024-11-30 22:53:02.423 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Source row_name datatype text does not match return row_name datatype integer.
2024-11-30 22:53:02.423 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM crosstab('SELECT rowid, attribute, val FROM ct where rowclass = ''group1'' and (attribute = ''att2'' or attribute = ''att3'') ORDER BY 1,2;')
	  AS ct(row_name int, category_1 text, category_2 text);
2024-11-30 22:53:02.423 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid crosstab return type
2024-11-30 22:53:02.423 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Source value datatype text does not match return value datatype integer in column 3.
2024-11-30 22:53:02.423 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM crosstab('SELECT rowid, attribute, val FROM ct where rowclass = ''group1'' and (attribute = ''att2'' or attribute = ''att3'') ORDER BY 1,2;')
	  AS ct(row_name text, category_1 text, category_2 int);
2024-11-30 22:53:02.434 UTC client backend[20186] pg_regress/tablefunc ERROR:  crosstab categories query must return at least one row
2024-11-30 22:53:02.434 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM crosstab(
	  'SELECT rowid, rowdt, attribute, val FROM cth ORDER BY 1',
	  'SELECT DISTINCT attribute FROM cth WHERE attribute = ''a'' ORDER BY 1')
	AS c(rowid text, rowdt timestamp, temperature int4, test_result text, test_startdate timestamp, volts float8);
2024-11-30 22:53:02.436 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid crosstab categories query
2024-11-30 22:53:02.436 UTC client backend[20186] pg_regress/tablefunc DETAIL:  The query must return one column.
2024-11-30 22:53:02.436 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM crosstab(
	  'SELECT rowid, rowdt, attribute, val FROM cth ORDER BY 1',
	  'SELECT DISTINCT rowdt, attribute FROM cth ORDER BY 2')
	AS c(rowid text, rowdt timestamp, temperature int4, test_result text, test_startdate timestamp, volts float8);
2024-11-30 22:53:02.436 UTC client backend[20186] pg_regress/tablefunc ERROR:  crosstab category value must not be null
2024-11-30 22:53:02.436 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM crosstab(
	  'SELECT rowid, rowdt, attribute, val FROM cth ORDER BY 1',
	  'SELECT NULL::text')
	AS c(rowid text, rowdt timestamp, temperature int4, test_result text, test_startdate timestamp, volts float8);
2024-11-30 22:53:02.438 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid crosstab source data query
2024-11-30 22:53:02.438 UTC client backend[20186] pg_regress/tablefunc DETAIL:  The query must return at least 3 columns: row_name, category, and value.
2024-11-30 22:53:02.438 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM crosstab(
	  'SELECT rowid, attribute FROM cth ORDER BY 1',
	  'SELECT DISTINCT attribute FROM cth ORDER BY 1')
	AS c(rowid text, temperature text, test_result text, test_startdate text, volts text);
2024-11-30 22:53:02.439 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid crosstab return type
2024-11-30 22:53:02.439 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Return row must have 7 columns, not 6.
2024-11-30 22:53:02.439 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM crosstab(
	  'SELECT rowid, rowdt, rowdt, attribute, val FROM cth ORDER BY 1',
	  'SELECT DISTINCT attribute FROM cth ORDER BY 1')
	AS c(rowid text, rowdt timestamp, temperature int4, test_result text, test_startdate timestamp, volts float8);
2024-11-30 22:53:02.439 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid crosstab return type
2024-11-30 22:53:02.439 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Return row must have at least two columns.
2024-11-30 22:53:02.439 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM crosstab(
	  'SELECT rowid, attribute, val FROM cth ORDER BY 1',
	  'SELECT DISTINCT attribute FROM cth ORDER BY 1')
	AS c(rowid text);
2024-11-30 22:53:02.455 UTC client backend[20186] pg_regress/tablefunc ERROR:  infinite recursion detected
2024-11-30 22:53:02.455 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid int, parent_keyid int, level int, branch text);
2024-11-30 22:53:02.457 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid connectby return type
2024-11-30 22:53:02.457 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Source key type integer does not match return key type text.
2024-11-30 22:53:02.457 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid text, parent_keyid int, level int, branch text);
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid connectby return type
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Source key type integer does not match return key type double precision.
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid float8, parent_keyid float8, level int, branch text);
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid connectby return type
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Source parent key type integer does not match return parent key type double precision.
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid int, parent_keyid float8, level int, branch text);
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid connectby return type
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Return row must have 3 columns, not 4.
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0) AS t(keyid int, parent_keyid int, level int, branch text);
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid connectby return type
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Return row must have 4 columns, not 3.
2024-11-30 22:53:02.458 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid int, parent_keyid int, level int);
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid connectby return type
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Source parent key type integer does not match return parent key type text.
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0) AS t(keyid int, parent_keyid text, level int);
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid connectby return type
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Third return column (depth) must be type integer.
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid int, parent_keyid int, level float, branch float);
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid connectby return type
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Fourth return column (branch) must be type text.
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid int, parent_keyid int, level int, branch float);
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid connectby return type
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Fifth return column (serial) must be type integer.
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_text', 'keyid', 'parent_keyid', 'pos', 'row2', 0, '~') AS t(keyid text, parent_keyid text, level int, branch text, pos text);
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid connectby return type
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc DETAIL:  Fourth return column (serial) must be type integer.
2024-11-30 22:53:02.459 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_text', 'keyid', 'parent_keyid', 'pos', 'row2', 0) AS t(keyid text, parent_keyid text, level int, pos text);
2024-11-30 22:53:02.460 UTC client backend[20186] pg_regress/tablefunc ERROR:  invalid connectby source data query
2024-11-30 22:53:02.460 UTC client backend[20186] pg_regress/tablefunc DETAIL:  The query must return at least two columns.
2024-11-30 22:53:02.460 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_int', '1; --', 'parent_keyid', '2', 0) AS t(keyid int, parent_keyid int, level int);
2024-11-30 22:53:02.460 UTC client backend[20186] pg_regress/tablefunc ERROR:  infinite recursion detected
2024-11-30 22:53:02.460 UTC client backend[20186] pg_regress/tablefunc STATEMENT:  SELECT * FROM connectby('connectby_int', '1::int, NULL::int; --', 'parent_keyid', '2', 0) AS t(keyid int, parent_keyid int, level int);
2024-11-30 22:53:02.467 UTC postmaster[20175] LOG:  received fast shutdown request
2024-11-30 22:53:02.467 UTC postmaster[20175] LOG:  aborting any active transactions
TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 20175
0xaa1ce2 <ExceptionalCondition+0x72> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89e3d7 <PostmasterStateMachine+0x3a7> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89c8d9 <ServerLoop+0x419> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89bcb0 <InitProcessGlobals> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres