Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

roachtest: sqlsmith/setup=rand-tables/setting=no-mutations failed #63430

Closed
cockroach-teamcity opened this issue Apr 10, 2021 · 0 comments · Fixed by #63446
Closed

roachtest: sqlsmith/setup=rand-tables/setting=no-mutations failed #63430

cockroach-teamcity opened this issue Apr 10, 2021 · 0 comments · Fixed by #63446
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.

Comments

@cockroach-teamcity
Copy link
Member

(roachtest).sqlsmith/setup=rand-tables/setting=no-mutations failed on release-21.1@5323c44e1c3d3d9ded95a9f20be5ba738cd542ec:

								*
							FROM
								(
									VALUES
										(3618326136:::OID),
										(NULL),
										(1535022620:::OID),
										(CASE WHEN NULL THEN 3809945684:::OID ELSE 1132124906:::OID END),
										(3812966465:::OID)
								)
									AS tab_762 (col_1832)
						),
					with_271 (col_1833)
						AS (SELECT * FROM (VALUES ('P':::STRING), ('8':::STRING), ('T':::STRING)) AS tab_763 (col_1833))
				SELECT
					regr_r2(NULL::INT8, (-0.0017706938632580105):::FLOAT8::INT8)::FLOAT8 AS col_1834
				FROM
					defaultdb.public.table3@[0] AS tab_764
				GROUP BY
					tab_764.col3_11, tab_764.col2_6, tab_764.col3_16
				ORDER BY
					tab_764.col3_16 ASC, tab_764.col3_11 ASC
				LIMIT
					1:::INT8
			)
				AS col_1835,
			jsonb_insert('[false, []]':::JSONB::JSONB, NULL::STRING[], tab_757.col1_6::JSONB, false::BOOL)::JSONB AS col_1836,
			tab_758.col2_3 AS col_1837,
			((-1):::INT8::INT8 * (-6297526606271204945):::INT8::INT8)::INT8 AS col_1838,
			tab_757.col1_4 AS col_1839,
			'\x4a5c':::BYTES AS col_1840,
			0:::OID AS col_1841,
			tab_758.col2_5 AS col_1842,
			tab_758.col2_0 AS col_1843,
			tab_758.col2_2 AS col_1844,
			tab_757.col1_15 AS col_1845,
			tab_758.col2_9 AS col_1846,
			tab_757.col1_0 AS col_1847,
			(-0.9961179198744912):::FLOAT8 AS col_1848,
			B'00100110011111110110101110010001101111000011100' AS col_1849,
			'':::STRING AS col_1850
		FROM
			defaultdb.public.table1@table1_col1_0_col1_16_col1_15_col1_2_idx AS tab_757,
			with_267 AS cte_ref_80,
			defaultdb.public.table2@table2_col2_13_col2_8_col2_4_col2_14_col2_2_col2_9_col2_12_col2_11_col2_10_col2_3_col2_7_col2_1_col2_15_col2_0_col2_6_col2_5_idx
				AS tab_758
		WHERE
			false
		LIMIT
			47:::INT8;

More

Artifacts: /sqlsmith/setup=rand-tables/setting=no-mutations

See this test on roachdash
powered by pkg/cmd/internal/issues

@cockroach-teamcity cockroach-teamcity added branch-release-21.1 C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. labels Apr 10, 2021
@craig craig bot closed this as completed in 3e54362 Apr 11, 2021
@mgartner mgartner moved this to Done in SQL Queries Jul 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Projects
Archived in project
Development

Successfully merging a pull request may close this issue.

1 participant