-
Notifications
You must be signed in to change notification settings - Fork 4.1k
roachtest: pg_regress failed #155302
Copy link
Copy link
Closed
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.v26.1.0-prerelease
Description
roachtest.pg_regress failed with artifacts on master @ 7d15c710e7514e363557c2d7e7d0fe736e1e7e24:
-- matview rewrite when changing access method
CREATE MATERIALIZED VIEW heapmv USING heap AS SELECT 1 AS a;
+ERROR: at or near "using": syntax error
@@ -861,7 +878,7 @@
-- typed tables are rewritten when their type changes. Don't emit table
-- name, because firing order is not stable.
CREATE OR REPLACE FUNCTION test_evtrig_no_rewrite() RETURNS event_trigger
-@@ -541,21 +728,52 @@
+@@ -541,21 +744,56 @@
pg_event_trigger_table_rewrite_reason();
END;
$$;
@@ -890,6 +907,8 @@
+See: https://go.crdb.dev/issue-v/48701/_version_
-- but this doesn't work
create table rewritemetoo3 (a rewritetype);
++NOTICE: waiting for job(s) to complete: 1114423678558339073
++If the statement is canceled, jobs will continue in the background.
alter type rewritetype alter attribute a type varchar cascade;
-ERROR: cannot alter type "rewritetype" because column "rewritemetoo3.a" uses it
+ERROR: at or near "EOF": syntax error: unimplemented: this syntax
@@ -899,6 +918,8 @@
+HINT: You have attempted to use a feature that is not yet implemented.
+See: https://go.crdb.dev/issue-v/48701/_version_
drop table rewriteme;
++NOTICE: waiting for job(s) to complete: 1114423678822350849
++If the statement is canceled, jobs will continue in the background.
drop event trigger no_rewrite_allowed;
+ERROR: at or near "event": syntax error
+DETAIL: source SQL:
@@ -917,7 +938,7 @@
CREATE TABLE event_trigger_test (a integer, b text);
CREATE OR REPLACE FUNCTION start_command()
RETURNS event_trigger AS $$
-@@ -563,37 +781,46 @@
+@@ -563,37 +801,46 @@
RAISE NOTICE '% - ddl_command_start', tg_tag;
END;
$$ LANGUAGE plpgsql;
@@ -973,7 +994,7 @@
-- Check the object addresses of all the event triggers.
SELECT
e.evtname,
-@@ -604,13 +831,22 @@
+@@ -604,13 +851,22 @@
LATERAL pg_identify_object_as_address('pg_event_trigger'::regclass, e.oid, 0) as b,
LATERAL pg_get_object_address(b.type, b.object_names, b.object_args) as a
ORDER BY e.evtname;
If the diff is expected, copy event_trigger.diffs from the test artifacts to pkg/cmd/roachtest/testdata/event_trigger.diffs
test artifacts and logs in: /artifacts/pg_regress/run_1
Parameters:
arch=amd64cloud=gcecoverageBuild=falsecpu=4encrypted=falsemetamorphicLeases=defaultruntimeAssertionsBuild=falsessd=0
This test on roachdash | Improve this report!
Jira issue: CRDB-55348
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.v26.1.0-prerelease
Type
Projects
Status
Done