roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed #74361

cockroach-teamcity · 2021-12-31T07:30:46Z

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on master @ 3471dc50db8406f3faa638940492dbe0cab53435:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:259,sqlsmith.go:298,test_runner.go:780: error: pq: internal error: cannot map variable 36 to an indexed var
		stmt:
		INSERT
		INTO
			defaultdb.public.table1 AS tab_1105
		SELECT
			tab_1106.col1_0 AS col_2278,
			tab_1106.col1_1 AS col_2279,
			tab_1106.col1_12 AS col_2280,
			tab_1106.tableoid AS col_2281,
			'2008-04-21 12:26:03.000475':::TIMESTAMP AS col_2282,
			'.':::STRING AS col_2283,
			tab_1106.col1_4 AS col_2284,
			'1978-01-29 18:55:33.000744+00:00':::TIMESTAMPTZ AS col_2285,
			tab_1106.tableoid AS col_2286,
			((-222807051796800942):::INT8::INT8 + tab_1106.col1_9::DATE)::DATE AS col_2287,
			'\x679a80a3bcbf':::BYTES AS col_2288
		FROM
			defaultdb.public.table1@table1_expr_col1_7_idx AS tab_1106
		WHERE
			false
		ORDER BY
			tab_1106.col1_8
		LIMIT
			15:::INT8;

Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries _{This test on roachdash | Improve this report!}

The text was updated successfully, but these errors were encountered:

cockroach-teamcity · 2022-01-01T07:27:32Z

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on master @ fa9480a8b661b31a3c5e4c3428595b3e7c320700:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:259,sqlsmith.go:298,test_runner.go:780: error: pq: internal error: cannot map variable 33 to an indexed var
		stmt:
		UPDATE
			defaultdb.public.table2 AS tab_13
		SET
			col2_1 = tab_13.col2_13
		WHERE
			NULL
		ORDER BY
			tab_13.col2_9 ASC, tab_13.col2_2 DESC, tab_13.col2_11
		LIMIT
			35:::INT8;

Help

See: roachtest README

See: How To Investigate (internal)

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2022-01-03T07:27:31Z

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on master @ 65c6377f4f486d537ef7dfc59f8f9c78f1a6018a:

		  | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:91
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*Materializer).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/materializer.go:297
		  | github.com/cockroachdb/cockroach/pkg/sql.(*rowSourceToPlanNode).Next
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/row_source_to_plan_node.go:76
		  | github.com/cockroachdb/cockroach/pkg/sql.(*updateNode).BatchedNext
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/update.go:163
		  | github.com/cockroachdb/cockroach/pkg/sql.(*rowCountNode).startExec
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/plan_batch.go:173
		  | github.com/cockroachdb/cockroach/pkg/sql.startExec.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/plan.go:515
		  | github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:112
		  | github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:295
		  | github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visit
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:79
		  | github.com/cockroachdb/cockroach/pkg/sql.walkPlan
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:43
		  | github.com/cockroachdb/cockroach/pkg/sql.startExec
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/plan.go:518
		  | github.com/cockroachdb/cockroach/pkg/sql.(*planNodeToRowSource).Start
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/plan_node_to_row_source.go:146
		  | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*Columnarizer).Init
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexec/columnarizer.go:157
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*panicInjector).Init
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/panic_injector.go:62
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Init
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/stats.go:87
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).init.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:235
		  | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:91
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).init
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:234
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).Run
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/flow_coordinator.go:275
		  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*vectorizedFlow).Run
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/colflow/vectorized_flow.go:259
		  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:553
		  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRun
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:1368
		  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1391
		Wraps: (2) non-nullable column "table3:col3_12" with no value! Index scanned was "table3_pkey" with the index key columns (rowid) and the values (724580555118018561)
		Error types: (1) *withstack.withStack (2) *errutil.leafError
		stmt:
		UPDATE defaultdb.public.table3 AS tab_1670 SET col3_2 = tab_1670.col3_2 WHERE tab_1670.col3_6;

Help

See: roachtest README

See: How To Investigate (internal)

_{This test on roachdash | Improve this report!}

mgartner · 2022-01-04T19:26:23Z

The last occurence may be different than the rest.

cockroach-teamcity · 2022-01-15T07:36:07Z

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on master @ 78419450178335b31f542bd1b14fefdf4ecee0e8:

											with_3949 (col_26469)
												AS (
													SELECT
														*
													FROM
														(
															VALUES
																(5767419845915155729:::INT8),
																(NULL),
																(4578226787040661029:::INT8),
																(
																	((-4144163362792667650):::INT8::INT8 % 1357670576895543639:::INT8::INT8)::INT8
																),
																((-591534213608873655):::INT8)
														)
															AS tab_12241 (col_26469)
												)
										SELECT
											NULL AS col_26470
										FROM
											defaultdb.public.table2@table2_expr_col2_9_idx AS tab_12242
										ORDER BY
											tab_12242.col2_7 DESC
										LIMIT
											1:::INT8
									),
									NULL
								),
								(B'111001011111100110110', NULL),
								(
									B'010011011111001110101',
									'0107000080070000000101000080E0A8464AC677C2413055A6A96068E94140F83F462A96EA410101000080984B1B2DD42EE0C11863756C24E201C26892D6E2B88302C20103000080010000000D0000002002E072E2B4F1C150243CBC9854C7413E9F69260D78F3C1838721105C0102C2C2E4ED84DF4BE6C1948A50B081DBD6C100E5D214D92C884170AE1159D22402C2206B5B6021EDBAC180F08DD19A6499C10AA9D770F525E2C196898B901DB2F5C1DC00A91CC8F4EB419E5736235D8CE6C1E25127B53214F941E47419712DC7FA4120AA168346CEE74108E17E730493DBC1684C266C1BC6E9417057870841CBE541681C2F5FA2F4E841F438E99FB7A8ED41EE944DAD366DF3416EF501AB1C5100C27816DF49C30DEF41F093593C62930142133A6037B9D9FEC1C3B981969A36F4C110D36404333EFE41401304DA1E82B6418ED19E6A7647FEC1D0BFDA7106CEEA418C14B664A2D5E941A69B1F2E27ADFDC17C17205943BAE34152703E5969EEF4C12002E072E2B4F1C150243CBC9854C7413E9F69260D78F3C101040000800900000001010000804238A1543E21F5C10E372FB837B5F4C11AF28A7C1ADCF7C101010000803A4906A4747BFFC1D0F46068B51FC44102C1DB787CD0F74101010000805C980E2E9600E9414A97B766F7BCE2C151BFA147F2A701C20101000080A8EBF4BF32B2F6C11CF43C3DB9D4E2411B322D5EC8FAF1C1010100008068C113D0F47FEDC150BCD35A9005EA4148A6F286C1CFF041010100008008890418289CDCC1440501295FF0FD4138CCE0D52EB2F5410101000080D0EB54AF0EC0F641E0D6F2FC8EF4E84150B090559F07ED4101010000805CF4D4C3EE4DFF41E809981856DAE741D66B55B2C985F8C10101000080E07CF3F026ABD641F203464B52A9F841D4DA3EFE3C58F74101060000800100000001030000800100000008000000DAB2612BF83FF0C16ECF7BBBD7A0EFC1BC0E04BF07DFF5C1DAACE26B900E0242589A459BD52CEFC1C09C69C4476BF541CAC5B8D50DCDF841F0DA6ED6BC5FE14130FFC3D0C02FE14100B3F96952CBE341E4A6F7F0F418EF4114CFC187D90BF7C1F95B6E8BFA2BF2C106A6C1944E6E0142EE77F66F5FC3F3C11F036596723C01C2FEB0FFF05E8301426C2C3C63DF5BFE41F2674D61E6DBEBC150EF8A1D1522F34128243CCB9A73FA41DAB2612BF83FF0C16ECF7BBBD7A0EFC1BC0E04BF07DFF5C10106000080070000000103000080010000000C00000078A2CA8C13FAEEC138B953229775D1C1902F3C2E3EEC014268CE33496DC2D341FC1AA000F9A4E5C1C84056465D3CD5C100BCF7305C22704139462DD37CC9FCC160AC4F3C76AAB541D85B9F0FC42BDD4109AAFFC63EEBF1C1602CD084B4AAEC41EC0060FE95EBFE4180678A771D7701C2F07ABDEE2189CCC166DBB2BF03F90042504E39DFFDA5CA41BC2568E5FCE0D9C1F2D6657FB0D70142ECDECB4F8630F341020BD33CDDC300423CEC8DC9FD59F4415C203F7E808FE34134F7E91899CFF2C1F084BE014316E74114E6496064560242A4286D4115FAF94100C32F58ADBEDD4114C8C75CE116FB419C8F72502255FE415C75A8F10483FBC1B8E96706D1F4ED412D6A0C8DDA0F02C278A2CA8C13FAEEC138B953229775D1C1902F3C2E3EEC01420103000080010000000B000000A3D0993276D701C234C6EC9AE016E7C1CEE9486AE4AFFDC185DBFCBB9E00F2C19D849A59165FF4C164DE21ABCB57EA41CC55111D0AEAE9C10C1678A59B65FCC1330EE7023882FCC1C8D671743B7ADDC1549FDF96D81DE9C18069A8BBEC59C0C1601BA9718A43DC419C87F00EC6C6F1C16402419FD42EF941A2EA4D0F76A30042B06929C894C2CDC1E9433E6A62A3F3C19EAAEC2384B6F94164A8C1CAFDE7F641D03E1232019AD4C1BFEB38E5EC7301C250F71CB8A05D014220387CAF2040C6C1DAB0BB905608E8C10027901B2B22BD41BEDAE2965441E6C1F53D4DAD05C9F2C1C026D4D741B4B841C0B9924ACEBDB1C1A3D0993276D701C234C6EC9AE016E7C1CEE9486AE4AFFDC10103000080010000000D0000005EB20CC09A46F8C1B0E2E400C67BCBC117067C3D7634F9C18B377EA78862F5C130F0E66BB5DBD2C19CA9B316AEE8FB4194CBCB0053DADEC1280035904A2EDBC1A46FF849779A00C288258275789FE441483922A6E18C02C2588C5313ECE8D54154076E81F90C0142B7511AE994A4F4C1287440B2710CE34124B39EA3D72FF741803CF14486B3DBC1B8DAFB5F649CDFC1C24A813BE8F8F741E020B4FF36ECCEC100CB339D99409841D8A9D214DAD9DD4140259D9213EADE41582C00BEC6E3D3C1D48F02A08DB5EDC1A20B3669C34F0142C8F0C02ABEA7D4411C104655EA55EDC17A43F1179A50F941D648DFE61FFDF7417CB2910EB61CD5C178A504E30B57DC4160E2A30EFE19D741E8D9923885F9F7C150F03D1F3E09DE4150F1FD20C831D1415EB20CC09A46F8C1B0E2E400C67BCBC117067C3D7634F9C10103000080010000000C00000062DE8D7C4D8200C2F81C8E41F4E8F0C15022F0B9F8E0C4C12056D9A31565B941960F6E094D62F5C1FC1A84263BF6EDC1A8A169524579E241299E3EC361DEF4C144DF938FD949E04134009787F944FA41475274CC4BF4FCC1C0DD17D32CA7C0416A446C4EF3E6F64128C7F9F24A0FF6C1F0791FDABC66CE410A7482C3D4AEF7414FB7D96BE0EFF3C1AE1B0D933208F441447FBE0CC4AAF1413EDFD5FCD01FF44173E5551EB4CBF8C1E009C35E269DC9C1C8B77EF804200242F83BB962C29FF1C17CA482BF1641E8C132BD7E36894FF1418024EBFFD892E641EDBFFBF8DF5CF5C17E6B285CDC67F241482242119EBDDA415AD623709B05FCC1183B945BE173E34180A510286B5C984162DE8D7C4D8200C2F81C8E41F4E8F0C15022F0B9F8E0C4C1010300008001000000090000001768CF35C2CBF1C1B18F0289B6D000C2DE1D2F07B879F0C10CCD8AE07574014233BE280FE689FBC1746108AADC6F00422C8699551B8CFF41F484EDD6E6E9F7C1AA3FDDC1B007FA41923BFBB9C4630242A061F8ADAB22C5C140C5AC35FD54D041E2B2B2FF4594F6C1D4541E97D8540142006689BE6FC4B441D630B4E11DF1FEC15C456FF46F510242B67C3673E605F54188A68044C97DE1C100446BE561C378C17EAC392E7B7BF84117E1C6DE2332F3C12099F2D54DC8C1C1900407A1C259FA411768CF35C2CBF1C1B18F0289B6D000C2DE1D2F07B879F0C10103000080010000000A0000008A9C380A4CF3EEC12EEDBF6B195FF2C1789821FCC772FB41FD27CBBCDCB9F0C1B5CDB374F9CF01C2F8DC0A60A93EEAC1C03F3497BBA0C5C1E29CAB5411F1F8C1EA2F829568C5F741680B2D8D17BED441B444B5D942D2F4C138BFD2290CC2D8C17857418ABE39FD4198DE3911BCB5F8C16F030A694A8A01C2A47D3795DE51FA41A284BEADA29EF4C10CB0E6EEC9A3FC41C8144B41B78CFB41581EA13F90F5FD4116A428D4434700C22A820067196AF9C1D0B0853BD2E1CF410486B8DBAF16D7C154E50E0F2B4AE2C18272DB4049E5E1C134A579D3570FD8C18A9C380A4CF3EEC12EEDBF6B195FF2C1789821FCC772FB410103000080010000000C0000007FF676CAC67600C201AABCBC2731F0C1D9264158F21CFEC16CA897753354E2C1C21A7BCD863DEDC15BD8404DF92DF7C1D8F9F83CD6CED141E7B7CB25A76BFFC1D45D52EC060AFB4160323348C29AD941E638604A097EF1C1710A95F922FC01C2C8008B0A7FDDDC416701682E2958F1C150597FF97582C84120085B3E56D001428B8CA3ADEE1AF8C11090FAFCB51BF24160569E990A34FE41F8F6B65EA902D4411FFE6A2CA14C00C2AC3DE8E0A15BE041B48D6E689652FC4188419775E7730242281AABE3DC90E3C140213B265103D14170BCD54252D1F341BAAD3BA07DAC00C2B2972357A733F5410063A83E217600C26E6470520429FCC14E3CFC452C04F14120867DE7D6ACB3417FF676CAC67600C201AABCBC2731F0C1D9264158F21CFEC10105000080090000000102000080050000006C21EFD0A1E3E941443FD21A229DF6C1D017CB32E46CE541A293458800740242101BE7D47B64EEC1A42AE6499B8DE4C1EAFBB6F2CFDBF3410C0584D6974B0242D25F6A5020E9FFC10006540C795FB04174F170E10074ED4198EB9E903C41FE41AA05476ACB55F3C1986E408A1FACF541C4880B9BDA5B02C20102000080020000005690CDFF59CFF6416056F28FEC1EDA41503C5AF7BF15C54154F48C00560AF541B8E934F95C9CEC41905C3FA50D37CAC1010200008002000000763313950A65E9C16442F5B7EFACF7C1E0EEE92418B0C241600D3FEA88F2BFC12C3C167C8DD4EEC170D82161F962FE41010200008002000000A41BDB7E7312E7413DF574831274F2C1502BD8B4573FFDC18C9D5B373930F1413068665F8766FA41144458156455F64101020000800700000014E19DF3C546E2C1E29F6A046196E8C11C33F3C756ADF641C0CB14B64212A6C152852C30081EE0C1900DAFF7F209D7C194AF86189857ED41E66E23909A7DFDC16C73F5410A4AF641D4CF043CA2C3EB41A27D3428D2E1F0C15EABDA08A1040042C44D375EA942FE4100D852F017159FC176127DBDDB2502C24446F4D41380F841086CE1D1DEBBEE410627F874DEDDF8C1308FD275A35DC5415A48DC07EBD6F541F04872BC6443F741010200008004000000606F9D60E767EC4168019443C68AD641D401AEA34CF0E6419D9FD154B777F4C15AB127ADF78AF041EE9FD8A9B29BF84174965454E3FD00C2762C8228D42BF741486AA155C9B6F3415B6F9FF8CB4B02C286D083D996B3F74146297115ACA2F841010200008003000000BE4D27DBEB5FFFC190B849D6981401C2FBBAEC72D407FCC1805F7E518546E3412EFD35EA87C8F2411065083DC6F4D24190C556C0B426C8C13C7D2C78C7EDE441BA9E0CE5F6D9F641010200008004000000C06802BACFBAC2C1FA67F801EEA1EEC1003AE7D8DE48D7412045108AE0AFE14194B69EE7BD42ECC16097E85D716CE5410247B81486DAF441E0C319756D9EE7C15897E699EF37D5C154AD5FAFB6190242DC68C031CA8FD6C119D2549CE629FAC10102000080020000002F101568D3A601C2BAF1E202E7E1FDC1D0A1741111B8D041189BBDDCD561E7410042EAC7D703FEC19D84D780255700C2':::GEOMETRY
								)
						)
							AS tab_12243 (col_26471, col_26472)
				)
		SELECT
			3276246008:::OID AS col_26473,
			tab_12244.col1_11 AS col_26474,
			COALESCE(tab_12245.col4_2, tab_12244.col1_11) AS col_26475,
			1262614544:::OID AS col_26476
		FROM
			defaultdb.public.table1 AS tab_12244
			JOIN defaultdb.public.table4 AS tab_12245 ON (tab_12244.col1_8) = (tab_12245.col4_1)
		WHERE
			true
		ORDER BY
			tab_12244.col1_11 DESC, tab_12244.col1_11 ASC
		LIMIT
			21:::INT8;

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

sql: non-nullable column with no value #74727 roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-21.2 release-blocker]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2022-01-17T07:28:59Z

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on master @ 4b41789120e019ab015e6dbb924df763897ebadb:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:259,sqlsmith.go:298,test_runner.go:780: error: pq: internal error: no volatility for cast regproc::regrole
		stmt:
		UPDATE
			defaultdb.public.table5 AS tab_8230
		SET
			col5_6 = COALESCE(tab_8230.col5_0, tab_8230.col5_6)
		WHERE
			tab_8230.col5_5
		ORDER BY
			tab_8230.tableoid ASC
		LIMIT
			3:::INT8;

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

sql: non-nullable column with no value #74727 roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-21.2 release-blocker]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2022-01-18T07:34:49Z

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on master @ 365b4da8bd02c06ee59d2130a56dec74ffc9ce21:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:259,sqlsmith.go:298,test_runner.go:780: error: pq: internal error: no volatility for cast regrole::regprocedure
		stmt:
		WITH
			with_3449 (col_21613)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(3899762743:::OID),
								(2396430797:::OID),
								(
									(
										SELECT
											NULL AS col_21612
										FROM
											defaultdb.public.table1@table1_col1_6_idx AS tab_10127
										WHERE
											NULL
										ORDER BY
											tab_10127.crdb_internal_mvcc_timestamp ASC
										LIMIT
											1:::INT8
									)
								)
						)
							AS tab_10128 (col_21613)
				),
			with_3450 (col_21614) AS (SELECT NULL AS col_21614 FROM with_3449 AS cte_ref_1013, with_3449 AS cte_ref_1014)
		SELECT
			tab_10129.col3_8 AS col_21615,
			tab_10129.col3_14 AS col_21616,
			tab_10129.col3_13 AS col_21617,
			tab_10129.col3_3 AS col_21618,
			tab_10129.col3_10 AS col_21619,
			'R':::STRING AS col_21620,
			e'\x0e>\x16':::STRING:::NAME AS col_21621,
			COALESCE(tab_10129.col3_9, tab_10129.col3_10) AS col_21622,
			e'\rMil':::STRING AS col_21623,
			'1990-02-20':::DATE AS col_21624
		FROM
			defaultdb.public.table3@table3_col3_13_expr_col3_15_expr1_idx AS tab_10129
		WHERE
			true
		LIMIT
			76:::INT8;

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

sql: non-nullable column with no value #74727 roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-21.2 release-blocker]

_{This test on roachdash | Improve this report!}

mgartner · 2022-01-20T04:45:10Z

Duplicates of #74241 and #74784.

blathers-crl bot added the T-sql-queries SQL Queries Team label Dec 31, 2021

mgartner self-assigned this Jan 4, 2022

cockroach-teamcity mentioned this issue Jan 12, 2022

sql: non-nullable column with no value #74727

Closed

mgartner closed this as completed Jan 20, 2022

mgartner added this to SQL Queries Jul 24, 2023

mgartner moved this to Done in SQL Queries Jul 24, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed #74361

roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed #74361

cockroach-teamcity commented Dec 31, 2021

cockroach-teamcity commented Jan 1, 2022

cockroach-teamcity commented Jan 3, 2022

mgartner commented Jan 4, 2022

cockroach-teamcity commented Jan 15, 2022

cockroach-teamcity commented Jan 17, 2022

cockroach-teamcity commented Jan 18, 2022

mgartner commented Jan 20, 2022

roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed #74361

roachtest: sqlsmith/setup=rand-tables/setting=no-ddl failed #74361

Comments

cockroach-teamcity commented Dec 31, 2021

cockroach-teamcity commented Jan 1, 2022

cockroach-teamcity commented Jan 3, 2022

mgartner commented Jan 4, 2022

cockroach-teamcity commented Jan 15, 2022

cockroach-teamcity commented Jan 17, 2022

cockroach-teamcity commented Jan 18, 2022

mgartner commented Jan 20, 2022