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.

Sign up for GitHub

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

Jump to bottom

roachtest: sqlsmith/setup=seed/setting=no-mutations failed #70670

Closed
cockroach-teamcity opened this issue Sep 24, 2021 · 7 comments
Closed

roachtest: sqlsmith/setup=seed/setting=no-mutations failed #70670

cockroach-teamcity opened this issue Sep 24, 2021 · 7 comments
Assignees
@mgartner
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-queries SQL Queries Team

Comments

@cockroach-teamcity
Copy link
Member

roachtest.sqlsmith/setup=seed/setting=no-mutations failed with artifacts on master @ 85b1e92455eb2795043d71e5766b1b56dab308f2:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:223,sqlsmith.go:256,test_runner.go:777: error: pq: internal error: no volatility for cast tuple[]::tuple{geometry, timestamptz, decimal}[]
		stmt:
		WITH
			with_44761 (col_269848)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									ARRAY[('010300004001000000050000004954AADBD55BF3C130ABE8EFB099C741E3F95A180565FAC140F660134A03CB416A18B0963870EDC12054A489EAF5C541A48B728F64DBF441CCD16417E6A1F64159C2F762384601C25895142D41C7D2C1E89E6726F62ED341E1CB545F175C00C24954AADBD55BF3C130ABE8EFB099C741E3F95A180565FAC1':::GEOMETRY, '2015-03-21 11:17:09.000748+00:00':::TIMESTAMPTZ, 231367901405755.3436:::DECIMAL),('01070000000400000001030000000100000009000000F7DB6E7FF5B500C2FE13371F8AE7E9C1446BD347795AF441BB9065C130A2FCC1C0124896EACCED4103C18C16475DF4C18CC87AFF5C57F241CAA96893E8E5F5C1B03036C0A8D1C141FEF030C5267DE6C1C861E819B03CDEC150CE585B8C53CF41A4B4502D3C0BF3C1FC06F994356AEC4140D9F22732D6F6C1888AC71D2A96E941F7DB6E7FF5B500C2FE13371F8AE7E9C101050000000800000001020000000300000084B8DE27D945DAC1FE2F9C81BB3B00C240E622986490CFC13C6B7365E65AFCC1F4D8BB4059B600427C2E7296528EFAC1010200000002000000003EF953E01DC7C1E0955FED91F6E84170555C156A78E541CE7703EC85C8F641010200000002000000EC97FAE9D4B9F841CC723B94D26DFB411C08CE602FBBF44184BCEA4828210142010200000007000000EC40E1170137FD4189367881DF4CFFC10C3CB195AF04FC41C8BE70490048D7C1A6877C784FF1F64120BF6FA9806AC5C1302E826FAF99014250510361DB66DA414EA5EE667266F241E0D5B23570E5BEC19BC2A9508F61F0C16CECE7482828EF41089D5FDD5C7DD041005BB0FAF779CAC101020000000600000074F943F08ED4EAC140212EBF4817E4C1A05C431A467EE4C16BE29434658B01C220582170560CB9C1C3A8D75B6AF1F2C12CC523AD450F02427AD077CF3505F6C1C0DB59CE7B1FEE41AEF2CA14A6F6F2418AB98D199104FA41725FDDC63F8F0142010200000002000000903DE691A181F841B0D53528000CDAC10084462390628D41107BF2293D65E941010200000003000000403675027118B541445AE53DA7D3EE4120F2AE27E94BBC411879922AB982FF413E94CD394057EAC1C095E339F3A3F64101020000000300000029E3AAB21423FDC1E0102E7BC685D1C10FCFEE0AD05401C2D87F57EF8DFDF0C1BF87C996CAA1F9C1666F7D7EF5EBF2C1010200000004000000E83B0E3CBE77E041DA51CFDC98F0F1C17A60B53D9110F441D847E8B3F0C6EDC1E04953EE4469C7413CA6200F1698EF41D03937B6469DC0C1603535D10574F341010200000003000000E4136048813EF7C19AAA36F531C4E4C1402A5323473CED4120CE91B7BC61D94180E5957A035BE7413845DFCC81E3F441':::GEOMETRY, '1972-10-15 12:47:15.000668+00:00':::TIMESTAMPTZ, 0.8811646107877481123:::DECIMAL),('01060000C00300000001030000C001000000070000006C251179279EF941F02405A22201FFC162ACE3F19206F34100FA08FF1CFD73411EADA166C30CF84126177781B9E5EBC13A7EEA6DC44E0242BBFA146DE87301C2D6347A1EE85CF5419094491B8C69F1417E0E0CFBE570F5C1F482FEFB6363D8C1A45B5BABEC51DDC15A8CEB649F8DF641D8BA8ED8D9CDE741B6E728506292E4C13539EAA660FC01C204534F6FC1D500427AEA22F47CFCF8C1C87EEB42DCB3F54172949D490A96F7C1E09B310BD629DB412A08ABD1DF2FFDC1A606E7F7D710F8C16C251179279EF941F02405A22201FFC162ACE3F19206F34100FA08FF1CFD734101030000C00100000009000000BCB0CFDBACCEFCC11A2FAE689FBFE0C140E5A450DB2BAE41789DF8999077E4413AF5A756C192FFC1CC419A63116000C229F4B31B31BAF3C1C0B7EB15CE72B4C110422D3A9065C5C160F172E9AF56E1C1B65DDF9DE2020242E24C1C34462A0142E0B8315C5B6CBF41F0CBA50BA645C841AA05D8EA7731FA41EF4DDDD5194001C23817656AEFC5FA4164D086B038E3E44164E8640E4BACFE41600F45875367C2C14075F282C43AAD412C4DA0FCA7A3FD41AE12CA4B6EE9F5C15C92FD39E262FFC122ED6A9040F2EBC1286CA9E74344DD41B00A9D9411E3E24166D5E3549728F8413696C23F05F1F7C1F0067489FBEAE04146BDA3E3B46AEEC104F8BCEC70C0FC41BCB0CFDBACCEFCC11A2FAE689FBFE0C140E5A450DB2BAE41789DF8999077E44101030000C00100000007000000AE7C01F3EE76EBC174BC2AABD970E1C1CA6CDE309FB4F1C1DC0BBD05C696ED413CD4B54B8A1E02C263098563AA27F5C1104AB615E3CFFE41729AA260CF9EF0417AE0E29C12BCE7C1006340ECBBE5E1C1749A10F3853BF24158168C21C236FE4198D0603B0999F0C1259F791ACBE5F0C18281CEAE2BF6FFC19ED8E5ADC118F1C10A3B10C4CCE9ECC128B686C29676EFC12329527B785402C28871F20BFD88D7C1563E40578A580042D453A7932FFAFD418C9138038D39F141D07E92B0528AFEC1AE7C01F3EE76EBC174BC2AABD970E1C1CA6CDE309FB4F1C1DC0BBD05C696ED41':::GEOMETRY, '1993-12-31 14:21:20.00033+00:00':::TIMESTAMPTZ, (-5.368604119806860133E+24):::DECIMAL),('01010000C0DC48261B7C5FFD41F0DDA8652D74C84156A65BA0B953E9C130B19C5AF5380042':::GEOMETRY, '2016-03-17 22:21:11.000246+00:00':::TIMESTAMPTZ, 0.8404902139621365780:::DECIMAL)]
								),
								(
									ARRAY[('0102000080060000004E5FF75A71EAE1C11E2550FF0DF9FBC1B40BDD458AE2FAC1E014CC263DB6CFC1BFF25F55095E01C210015645E66CEA41686C26CD8F07DBC172BEEC1011D0E3C110C8C536B508FD4184392EF6CE3FFC410823F1EEE715DEC1A0D631BB9321B0C1384D66A90735E6C180A6CEB6DA13D0C138D223DC7B23D1416AE4DA2224BEEAC11CBB71352942F241F0BC46BBBD9BC9C1':::GEOMETRY, '2018-08-25 23:33:02.000052+00:00':::TIMESTAMPTZ, (-8.356116765236123663):::DECIMAL)]
								),
								(
									ARRAY[('0101000000D65298A21F37EAC1608B17E13889FBC1':::GEOMETRY, '1995-12-16 01:24:27.0008+00:00':::TIMESTAMPTZ, (-0.00180749507187495304):::DECIMAL),('010400000007000000010100000036CAE7D28AE2F7C1B9FD601CC633F9C1010100000095F739062D2C02C2C2145891A6FD00420101000000F21373E6D021FBC1C6BAD73F1C3DE6C101010000008D778A30AF7600C26C9F5FBF424B02C20101000000FCDAD656ACABFC4108B46E666B28FB41010100000028180C5690E9EF41ABDFDAB50F33F0C101010000009C2576B92089E74178CF7CA6D9DCD0C1':::GEOMETRY, NULL, 8.489880604956886265E+27:::DECIMAL)]
								)
						)
							AS tab_109726 (col_269848)
					UNION ALL
						SELECT
							*
						FROM
							(
								VALUES
									(ARRAY[]:::RECORD[]),
									(
										ARRAY[('0103000000010000000C0000004841F0A51A1E01C2C0A2D8A8C390CAC1109BACF7C171D3C108F0E15F0C51EFC17088A5717EC6C1C11EE037A0954EE0C140F9A6151B30D141B0A096E5649AE7C11A9EB741846FF24187C1CAE449F6FDC15A28F05FF6B7F941A6D4831F40D2F2C1884AF793FF08DB41209F17E2BA15CF410C817ADBFCA7FD41BC3022F286AA004232D9219E448DF24130CBC2F9D468F6415B2707FFDBF1FBC1B0346A6DA4EBFD41FC46FFEE4E6301C2C081D029A48AFF414841F0A51A1E01C2C0A2D8A8C390CAC1':::GEOMETRY, '2026-03-12 00:28:47.000968+00:00':::TIMESTAMPTZ, NULL),('010200008005000000607CCC93FDACE041AE5F6BE57951FBC1C0FC993FACA9C9C1A40C10E92392E741D07A8DED70F4D3C1FE26D5EBAB8BF3C16C7AE588923CF0C1C2D507332B27F5416CBE712C2B64D5C15CB980008159F1C19A0DFDD16F89F841D1D145EFDF6D01C2E8D30222E71000C204A441E61376F641ED45AE2D43D7FEC1':::GEOMETRY, '1996-02-15 09:43:20.00089+00:00':::TIMESTAMPTZ, 0.00385034817342638305:::DECIMAL),('01060000C00500000001030000C00100000008000000187F12096CDDD1C1B0BD33FA56FAF8C130953B88EA5FD1C100FA4AB7296602421C722D7FF032E3414834D89F1469EFC1565AC2C4C029E4C1F875F73E3BA2EC41886085E16D12D341766FF6559FA3FBC162902F58D02DFA41902E56210A61E241C62498F7A97EF7419891F7C0481FF7C198D2116F0FB5FE412C6460BCBFC2F441F698A1E89670F9416A3BB8E71F51E5C1501DCC4F8A3F0142DCF25DCD7FC20042CCE500106C4BFE4160AF8496CB1ECFC1E2DB3E8CAF91F041C0143A430712B5C1401224F410CBD0C140AA1BC2F1B7F841CAA807473727F04172DBBD5F552BF441187F12096CDDD1C1B0BD33FA56FAF8C130953B88EA5FD1C100FA4AB72966024201030000C00100000009000000F28C4F6702CFFAC1084D7AED3EFFD1C16CFA9D84A702ED4112C5CCF86264F441F0A5D5F20229EBC1802C76DAD6E59DC1974B5A2108DCF6C10CDD8DA11EF7EB41FEE68C816BB2F7C1B2BF5382D16001C2D099C6114E0ECE414066E7D01BC4FC4180875991F981FC41788BF1C702D7F6C19012042C8656CA41E43B8EBA61A9EDC1DEA6C2E6973A0042ACCF7CC7A716E541DB9CA194F775FBC1C83868AEA394D54134BD2026C0C3EC417A4B8DB0905300424C1A4CBA469E0242ACBE9D210340F9C1A85037F6B34AE041D2518C98025C01421CA09F4AC6F4FE413E76D1E5F78DF9418039564DBB6CD1C110FEE841FCA30042D471455ADD5CEA41A078C98D3A92CFC1F28C4F6702CFFAC1084D7AED3EFFD1C16CFA9D84A702ED4112C5CCF86264F44101030000C0010000000B0000009E87F4A7E0BA00C2A856194C31BAD8C1D2389702EC6AF141A0AD05CD16AEB3415802F164392DEAC137529BFEE5E3FCC1F8C5A5C84EE2DD41BCA4E3437059EDC14004B569B4FAD8418CBCB64CBD9CE6C1FCE1EF993B2EEF41520EEEB61E02E5C1926340D9A9BAF141BE6DE3F56681F8C196B7AF10F9DF0042D01CC1A717C4FB416CB5828FDFEB0042B298C7C88DE5FAC166A112344B1AF2C13837EBDEAAC80042767810575E7902421846474C69AAE341422EAF4B773E02C229AD014E0179F6C1BEAB57C4D467F041D8BA65C27626E241B0E09018A134DF41AA48B5F0583102429C62DD969456F54184E0B31961F7FF41367EFAA93E19014218BF6E173412FB4150B633A1103CF7C1A4415EECD2CC0042E0190DF5F6DCF9418058A4496644B9417AA78EB2140602C228550EB0EAC2F5410088A2FCFA136FC138FE9E7FFB7CF0419E87F4A7E0BA00C2A856194C31BAD8C1D2389702EC6AF141A0AD05CD16AEB34101030000C0010000000A0000000C981FD11F25F7C150BE7359247BC841885A93C680DFD3C10052B9C55FF077C120458AD103DAC3C17C623AE2710DE64198459B63E7A8FD41FEBE221FF446F24180AB1967F634C7C1061355998906EBC1A83E5722269DE9C194C20A2E51AFE9C1B0B83284CDD9E141603DDEEFF9B8DF412846838829A2FD416E9C42C7FC43F2C11892A71148FCF541264E58BBB980F441B0FA9BC4A9C5D9C168BE905F4701D1413C8E2955FEBA0142107C70D4094BFE411089CCD006A5CEC1C87B6472CD75F241604A63004900C7C192685AB2E497F64140900B47D2E5FF414C8658FFCFDEFF414A5641972C8FEDC1E008190C5F34FD41AC349C0459160042880E9C81F96BF441390772653E55FFC1D43C512660F4EE415E83831D9E41FAC14084798E4B20CCC10C981FD11F25F7C150BE7359247BC841885A93C680DFD3C10052B9C55FF077C101030000C00100000007000000D3AC4305A29F01C214F8D50C916EF6C11ED7B8884BDBF041A0DC676FE8E7DFC148D9C755FE5DEEC1360DC6EFE231E5C19C0B2A485D4CF7412C5573D61E32E341E097BAADBCDACA4102EC8A478A5FF7C1008BCF68FD83AC41A0422149ACB3C3C1FAA3BCD8C4A0F741D03124423265FC4198D91A969654D34136A38882FBF8F6C134F06084F7CCECC11C631778156AFA41AE03253C0AB2EBC1A02E8DA71D70BB41A40713FBF23BFEC120300E7728D5E441521EF536803FFEC198AEA0E79889DC41D3AC4305A29F01C214F8D50C916EF6C11ED7B8884BDBF041A0DC676FE8E7DFC1':::GEOMETRY, '1970-09-07 14:14:21.000971+00:00':::TIMESTAMPTZ, (-6430.997043476527788):::DECIMAL)]
									),
									(
										ARRAY[('0101000000000000000000F87F000000000000F87F':::GEOMETRY, '1992-10-05 08:50:46.000269+00:00':::TIMESTAMPTZ, NULL),('0107000080050000000106000080020000000103000080010000000B000000A694B5AB051E01C29032F87E6477F1C183CF2BAB3159F0C1CF81DB6168F401C2BC4EA7E54FBBFBC1C037C34666DAA8C1BA7E23121D1CF8C169B6E8BBDE0BF9C1BCE5A9536EE1DCC164877E6515CEE2C13214264FE13F00C280EAF1D5C0DCAF41549E6BF7CA48E7415E998E512E4EE4C1977E377BE3EEF1C1B28B1CEF2AAA014280430BA7E784E141E41A69AE62C2FD41E625116B35FCF241B03C7BED50AEF941D8EF08C6DFCBF1C1149DADA3CAB8E1C188D9BD67EE84FC41903CE64E8C32C0C1820E21EEB27FF1C19CEB27FA47B4F64130B118919371C6C1A04B683CDFAAFEC188C846ECBD06DE41D8F02F44CB65D0C1A694B5AB051E01C29032F87E6477F1C183CF2BAB3159F0C10103000080010000000D00000079ED099C1BCEF1C1FE61E83B7356FFC19071AB8C0334F441823C68567D85F441C7D88CB34BD8F4C1A1EC3FDA579DF0C1CACE688B47ABFA4193069F5B2C20F1C1E09CE94E7F9CB3415CFCF540109A004234EBE8460F92FAC1505ECABFEC18C2C142BBEC5C4BFB0142DCFE4AFA3D0FDAC16C36B9C2DE590242BC78428B5116FE41DCAFC462BF6DF7411AFB2BBA168300C23A94BEC346E8F2416AC66577A2DDF441389A36993A31DD412823DD81BBE6F341141DD16530E2FB410C00AE6E0739E6C108AFF81525E6E341A4C112732E22F8411292332719C2F241889A14E7D18EDC41E4056410320DF9418A8B0BBA2528E5C1508544AF3F9AE2C142B0D5ED4DA4F641F62AACADBB8DF6414E93A40EC77BF4C138BE2998D7BAFE41BACA34FD3086FA4179ED099C1BCEF1C1FE61E83B7356FFC19071AB8C0334F441010500008002000000010200008005000000383975FB166FF4418FF763C84A8002C2D0C86823E4FACD41888324B589AAEB41AA4CFFDA1BA5F3C1AE52AF11F90D024270CF7681E924E0419A5076AB1E4BE4C1FC4D835A1840F4411419662217220242AB43C47C8410FAC1B848A67D82A5D341382613DD8449E74140505D13AA45B5C1601BD34F837CEA41010200008005000000A2FEED71D993ECC1C88C82DCDA0800C2B62C314DF8B6E9C1B81211B7473BDFC11404626FA1B1F6C1068F1C2C387AF7C14C33984648D5D5C18877F1D9820AFAC190B09D292774D8C170335AADF88ED641B82037D66719EBC17039E9667A40D241BC5AE84E71F3F141AC655A7AA258F34114ADBD89D29FE1410102000080040000007C7CF94411CAE6411C5368EF75D9F7C1E82DB6115E8BEC418C04A7381D8DE941C882AAD9066AE8C19A176B14E030F6415E85C81654E7F341F2CC61704184FDC15863C6730961DF41E8C818E8ED62F9410096CE73AD6CD5C12E87CFBD22C2014201030000800100000007000000A82C9BF1C12ADD41000A9B8CA3FCAA41948E9E62DE6EFA41E80A065F16E5D6413AAE2415CBF3F9C13AA18B2D868AF7C18C29AF57BA0FF7413E237A3AE010FDC114E982D83CEC00421E9C6D0B1C290042609897395700FF4104C85BF0A93000C2C6B1B2C7C3EFE6C15EA02D9582A200428A2038309E08F4C1C0AF3E98CD1FBDC1C88D4DE535E4DA4170DF0F0FF055E841A82C9BF1C12ADD41000A9B8CA3FCAA41948E9E62DE6EFA410101000080ADF086C73BBEF4C11CB01A9774BCE9410CFDDFEB56FEFDC1':::GEOMETRY, '1987-05-13 13:54:30.000683+00:00':::TIMESTAMPTZ, (-3.293382128534475149):::DECIMAL)]
									),
									(
										ARRAY[('010300008000000000':::GEOMETRY, '2012-12-26 20:11:54.000298+00:00':::TIMESTAMPTZ, 5.994060485241242472E+26:::DECIMAL),('01020000000300000064A0214D2905DEC16CF9DF6268ACF1C194849C863EA8F24145BEABE53E35F7C100AE0E2D4EBCA7C1D4741399D719F141':::GEOMETRY, '2010-04-30 01:48:30.000941+00:00':::TIMESTAMPTZ, (-554858.4502416875212):::DECIMAL),('0106000000010000000103000000010000000B000000188F36D078EEDFC128BD9100B625F6C198133A327264D541D7457990215FF1C19017B0815E2DEE41FEE45F15B8E100C2BACFE163FFE60042A5DE10197281F5C1C0B3106ACDB7FF414AF7D907B80AEAC130B7C777D51AE34130012C5E1980DE41582C97381144D841D483C85B0DA1F841408DD50012E9ACC1B0F3BDEA3B5F0142737440955545FCC19C7155E18C2AFA41A8C06EE0D459FBC19071B283A50BF841188F36D078EEDFC128BD9100B625F6C1':::GEOMETRY, '2019-06-20 07:50:42.000158+00:00':::TIMESTAMPTZ, 82681169.28889311929:::DECIMAL),('01060000C00900000001030000C00100000007000000E536F0C76B13F1C1F48315221818E2C155B845EAD08F00C2788F40952AC9EC414CD066A1B8A2E9C14BDE90D60FF3F0C138562E04E2B1004203D9AF1E17BDF9C178B7F962D7ADD8C1886FFDE8FF8CEBC175EA376179F501C2387737213A4EF4418016BD43B687EE4142C0FE9467F7F841E279E5EECF4EF341BA7F4460D8B9F94160966726278CD5C1B0332AFFE8A4FD416E997EA6D4D5F34198CE39B25155F4C11AE0666F906001C2A006DF19F143FA41EC7BA6282A28E9C1DE6D1E45D3920242E536F0C76B13F1C1F48315221818E2C155B845EAD08F00C2788F40952AC9EC4101030000C001000000070000008657968E36FFE7C11C1DE1A5F9EFD5C1F4956EE5E47CF641E36C6A985E4B01C200F702FF015AF9C19709AC8A55DCFFC1A0ADF6A1DCD8E141A8102060D9CFEF41DA99C4364DA8E7C1D5EAAFB717A2F5C148AF5BC31EFAFF41309A60951554CF4168DF0B6B44CCEB41000C6D58475CA2C1C067B74B220CA5C1ECBA60E0F7A2E8413A41995DDE0B0042F6DB806F52EAF641AC3008B87E4CFC412092C85DC0CCDDC11A18CE953838014264698C179B16FC416CD706AEE3B0F5C1745003CA8D07FE418657968E36FFE7C11C1DE1A5F9EFD5C1F4956EE5E47CF641E36C6A985E4B01C201030000C00100000007000000220AC17E6512EBC1887806D71651DAC16B6B096AA927F8C110602007B495C5C1855715EE5853F6C150AAD0FE3B71E7C14E16565F93380142609F3407539BC7415408E08934F5FF418631E8BCF032F0C1E80EC01BCCB7D3C1B4469CE48A71FC41ACB701B4D2B7FA41306646D5B48CD941CC65DC48A04EF6C1BA6C25DFF11BF241D80B8A4BA532E641243CF2C46C04E441D8740B472FEEF4C10088B68A844BB4C1C557A91EEE2001C2E4881823258CF2413082235A9E54D4C13EB00144834FFA41220AC17E6512EBC1887806D71651DAC16B6B096AA927F8C110602007B495C5C101030000C0010000000C000000F04ECAA51F82C3C18A1E3A8CE7D2F7C1964A9B7CBF99F4C1288D72B3E520FC4148177C66248BDB4110E2E0803F1BF7C1E02E4605FF64BEC1B0E5005DDF67D441944BA58CDEC1F54158420A1201ACE0C1944ADAF33C58E5C1BC45ABD2C015FE4194455F58EE78ED41C0D9985512E2C541A52F706EE648F0C150756BC326810142A44E10B92D1EF94120382C296F92B841FCE324C403970142C0BD84767BFEF341C62E22D5C9F10142E8DBFA676330FC418097AB010B3100C254B57FA4FB3BF141904C2AD08239EC412CF903DCF46DF341C0B5AEB198DDCEC130726B57E868CBC120319FECE3CFBFC154B14025AA31FB4110932CFDFFB7D141B86F9292E5C4EEC1FC559FCFA675E1C1C8DE73092787E94188B9D8D0F378FD41186169F2D797E9419C0FEE9D9B04F8C148297A06ED15F24110A011F15203D34120276A7022CF0042724312580570FEC15471CBF7DA84EA41FE49B80B5D44E3C1387E17335567E6C1F04ECAA51F82C3C18A1E3A8CE7D2F7C1964A9B7CBF99F4C1288D72B3E520FC4101030000C00100000009000000166B0022BE0BFEC1FFE09ABF2FCCF8C1227E47BDB366E4C14C70575ADF24004250497BE25750F2C11ABAA79DDE30F9C1DCDD24D554D5FB41AEA9D44F0267E6C160C58A9DF8E3D6C1422355B9433200C260633B8A2B45D2C1A83D7A346891D5C1BA3E59076DC6F8413BD962DDF42DF7C1000C1399814CE541BC54963FC4CAE441ACA25D7F47D2FA41188788B3CD05DF41E09A8289C628D941FC8BD4E39A0EE9419E1CA261E285F14120291AD88C80CC41B420EDF42660EC414832909164C9DDC1ECE8EDFA4F44ED41FAC6609F4FBAF941D856590ECA73DDC1B281859E4B1500426AEA7084C8C9F9C150A0E72C7C66C44190C9BB64BD36EE4118AF18403CE1D941166B0022BE0BFEC1FFE09ABF2FCCF8C1227E47BDB366E4C14C70575ADF24004201030000C0010000000B0000000F0BABC6ADA4F4C1501AC68B3E4EDFC1F084E0AB0061CA41001EC67F74597D4170A660BFC399FAC1C00A7F06EB7BF6C1C0CBBC31B2BDAA41EC4BB20D8C3C02C2A84C019EAA82E8C1C3C63F1E223B00C26E6B074D3018F1C1687A16BA8D10D941D0669256F297D3419C8340CCCE6700C2061BBF716D4702425A43C98F57D5F2C1F09D2332EE1FEC4142DFAAC4F91CF4C1F022D31822CAF9C1F0F76AC36672F341CC59CD13EE490242123E301C0F0AF9C130380699F39AD641987247506320DDC110B169EFD407024220DE2CA92B06D14188F5E0F3232401424E7366CE5A5002C2AE225C9B02FA014200FDD8DA653DF441ACD78D92A5FDF341405461EE57EAA8C1E46D8468AB22DDC150098C18E4EBFF41A0926D5EEEEC0042D8F835AF7E2EFC419ED654DC84B6E8C19C1E7D29092CFF41C8C174D4EFE1FDC1E05B7C8C9FACC2410F0BABC6ADA4F4C1501AC68B3E4EDFC1F084E0AB0061CA41001EC67F74597D4101030000C00100000009000000CCBD923CA711ECC1C00B981D73D4CD41507BBB7ABEDFD341800813799CE0C3C17B7C1ACDE3B2FEC15E1FF7D5C7A7E4C188C489CE5367D44190859F3161CBF6C10C7C48C30EDCF041DCB2A389950CE6C1483F65105069F54134ACE993720DE6417CD1D70931CDF04118B8412BA21EDBC1661385D8765600420032AD99259E76C13885DCC7FCDDD841800153F7F515CA414007FD5BFDF8C041E82088B7FEB2DAC15222707D3F1EF841641F710DBB840042AC437B6DADA4FE41C0A8E5661C3AD141802956428F7EAF4190D7FF625947EE4162FF2D2BF974EBC1086540A11551E2C1A02E8D2244BFBAC1AC7863DA744CE841402F5F869B04AB41BA0471604D85ECC1CCBD923CA711ECC1C00B981D73D4CD41507BBB7ABEDFD341800813799CE0C3C101030000C001000000090000004CF1C6387AF201C2405D89F05E6FC44129326B962307FCC110F780C8A92CC8C13660DCB037E9FEC1D0F907A8CAD301C23C3CD8C9E48001422817DA9CFE7EDAC1360D88380786014267192CEF3C1DF3C1EC83B3BB7101E9C148B97F5F7966EAC1160D0E925A90F04100D47BB0E22084C160CE4AF05CD8DA414AF3D54BB4DDF241E2C7015EC45FF6417608A08E864FF7412C2B36C7D186FA41D1E21449C9DCF6C176D79B1CF77DF74130A0FBA4E941004222A130CD1DB2F54100B8F7F6E137F34114D18618E497DAC11CD070C2AF49F84176A0E067DB47F7C178C8FDD45004EF41A8CBD1B7A4E3F1C14898010D98D0F741647469D7EE1CF341A22CAE982E4201424CF1C6387AF201C2405D89F05E6FC44129326B962307FCC110F780C8A92CC8C101030000C0010000000B0000001468203A9DD6FAC1607D13EE50F8CBC13A619ADD428E00C2D61B139BF575F8C1C2A802E4F777F2C15010F1D25F4EE2C12359D33E93FB00C2465A7DDD9383E5C11C0E13E15B26FAC16E9D4F25AFFBF1C17A9197C9F48CF0414E9067A58017024218B77F94C45200C2A9910554B628FCC12410DB023971E8418092E4A80BE1B54112086FEE96670142D2CEC0EB8098F4C1008B8D50A7B59BC1DAB15CE0D75EE8C1ACEE48D91952FC41E0F85596B977BCC188FFEE2F3CF8D441A60E88E41898F84114B417B23E66FB41A2C22DAA45ACF14100B12539E8EEA741743ED71F96ACEBC1D236C2FC4656F841F0C97E0DF975FB4120412B3A614DB341110CAC18B48D00C2824E693D3C8FF9C1FC8D685BFA8B0142F490E53A302CE64154DE7449E1E2F241203610BB2816F6C1040365FAE6F5F541E0D2B87678ABE3C100AEC7E3707A75C11468203A9DD6FAC1607D13EE50F8CBC13A619ADD428E00C2D61B139BF575F8C1':::GEOMETRY, '2008-06-02 14:13:36.000538+00:00':::TIMESTAMPTZ, (-5.839524405007824537E+19):::DECIMAL),(NULL, '2017-12-30 21:45:02.000197+00:00':::TIMESTAMPTZ, (-5.47070739213498630E+28):::DECIMAL)]
									),
									(
										ARRAY[('0101000000000000000000F03F000000000000F03F':::GEOMETRY, '1999-05-27 14:21:20.000721+00:00':::TIMESTAMPTZ, NULL)]
									)
							)
								AS tab_109727 (col_269849)
				)
		SELECT
			138203661:::INT8 AS col_269850;
Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!
@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. 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 Sep 24, 2021
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Sep 24, 2021
@yuzefovich yuzefovich removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Sep 24, 2021
@cockroach-teamcity
Copy link
Member Author

roachtest.sqlsmith/setup=seed/setting=no-mutations failed with artifacts on master @ 9ba8499e80a3234da094e061827f1c23d9d33341:

										WITH
											with_46324 (col_274196)
												AS (
													SELECT
														*
													FROM
														(VALUES (NULL), (1799940652:::OID), (NULL), (3455094118:::OID))
															AS tab_112535 (col_274196)
												)
										SELECT
											cte_ref_13481.col_274196 AS col_274197
										FROM
											with_46324 AS cte_ref_13481
										LIMIT
											1:::INT8
									),
									CASE
									WHEN NULL
									THEN ARRAY[('2009-12-29 00:54:38.000626':::TIMESTAMP,),('1972-09-25 02:59:34.000456':::TIMESTAMP,),('2007-08-22 01:38:04.000565':::TIMESTAMP,),(NULL,)]
									ELSE ARRAY[]:::RECORD[]
									END
								),
								(
									1937126343:::OID,
									ARRAY[('2003-09-26 17:56:04.000771':::TIMESTAMP,),('2013-10-22 10:28:47.000194':::TIMESTAMP,),('1995-01-27 10:58:36.000703':::TIMESTAMP,)]
								)
						)
							AS tab_112536 (col_274198, col_274199)
				),
			with_46326 (col_274200)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								('a8fc16a1-8bd7-4a64-b425-db7b4e6344d3':::UUID), ('586ff040-78bc-4ddc-b0c8-43415d543938':::UUID)
						)
							AS tab_112537 (col_274200)
				)
		SELECT
			cte_ref_13482.col_274195 AS col_274201
		FROM
			with_46323 AS cte_ref_13482
		WHERE
			(true AND false)
		ORDER BY
			cte_ref_13482.col_274195 DESC, cte_ref_13482.col_274195 ASC, cte_ref_13482.col_274195 DESC
		LIMIT
			94:::INT8;
Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

@rafiss
Copy link
Collaborator

rafiss commented Sep 26, 2021

Caused by 4037bd8

See #70663 (comment)

@rafiss rafiss removed their assignment Sep 26, 2021
@cockroach-teamcity
Copy link
Member Author

roachtest.sqlsmith/setup=seed/setting=no-mutations failed with artifacts on master @ ecaa4920192549af1418923648769ede3de1c9c8:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:223,sqlsmith.go:256,test_runner.go:777: error: pq: internal error: no volatility for cast tuple[]::tuple{bytes, date, int}[]
		stmt:
		WITH
			with_18286 (col_110402)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									ARRAY[('\x737837ebf0':::BYTES, '1996-07-02':::DATE, 1917242869:::INT8),('\x4ff22a':::BYTES, '1986-05-21':::DATE, NULL),('\xdf438173abf57737':::BYTES, '1995-11-21':::DATE, (-1):::INT8),(NULL, '1994-12-16':::DATE, 1205016709:::INT8),(NULL, '1970-01-01':::DATE, NULL)]
								)
						)
							AS tab_44845 (col_110402)
					EXCEPT SELECT * FROM (VALUES (NULL), (ARRAY[]:::RECORD[])) AS tab_44846 (col_110403)
				)
		SELECT
			'1971-09-24 00:24:39.000172':::TIMESTAMP AS col_110404,
			tab_44847._int4 AS col_110405,
			date_trunc(NULL::STRING, ('18:19:34.586143':::TIME::TIME + '-24 years -8 mons -341 days -10:49:59.11274':::INTERVAL::INTERVAL)::TIME::TIME)::INTERVAL
				AS col_110406
		FROM
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_44847
		WHERE
			NULL
		ORDER BY
			tab_44847._int8, tab_44847._int2 ASC, tab_44847.tableoid DESC
		LIMIT
			17:::INT8;
Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.sqlsmith/setup=seed/setting=no-mutations failed with artifacts on master @ 37d9f72a28a8e009bc6ba3c4d3c5780af554b92d:

								(NULL, ARRAY[(-224494908):::INT8,132518960:::INT8]),
								(
									ARRAY[(3432312502:::OID, '1971-09-13':::DATE, '\x':::BYTES),(3284454944:::OID, '1993-06-16':::DATE, '\x5f8aeec45f':::BYTES)],
									ARRAY[1650585162:::INT8,(-661548411):::INT8,551286048:::INT8,825057785:::INT8,336916053:::INT8,(-163717201):::INT8]
								),
								(
									ARRAY[(292159081:::OID, NULL, '\xd9aef614':::BYTES),(220564144:::OID, NULL, NULL),(1836605173:::OID, '1989-10-13':::DATE, '\xb0':::BYTES),(404439839:::OID, '4714-11-24 BC':::DATE, '\x58':::BYTES),(2043559008:::OID, 'infinity':::DATE, '\x3a65daad53':::BYTES)],
									NULL
								)
						)
							AS tab_17698 (col_43504, col_43505)
					INTERSECT
						SELECT
							*
						FROM
							(
								VALUES
									(ARRAY[]:::RECORD[], ARRAY[(-1399182225):::INT8,1945557196:::INT8,1830987992:::INT8]),
									(
										ARRAY[(38178251:::OID, '1995-12-28':::DATE, '\x0c2ba2a8':::BYTES),(0:::OID, '1982-11-07':::DATE, '\x02d99d68':::BYTES)],
										ARRAY[1237448305:::INT8,2147483647:::INT8]
									),
									(
										ARRAY[(0:::OID, '1978-11-27':::DATE, '\xdce762f326f901d6':::BYTES),(2123612345:::OID, '1970-01-01':::DATE, NULL)],
										CASE
										WHEN true THEN ARRAY[]:::INT4[]
										ELSE ARRAY[(-516817440):::INT8,1860122853:::INT8,1163399277:::INT8]
										END
									),
									(
										ARRAY[(3587633761:::OID, '-infinity':::DATE, '\xe39d5d1340e58e':::BYTES)],
										ARRAY[(-2112819186):::INT8]
									),
									(
										ARRAY[(367034774:::OID, '1989-12-19':::DATE, '\xf48390975ede7e35':::BYTES),(357971394:::OID, '1983-05-22':::DATE, '\xf5d9983168b1':::BYTES),(2564895825:::OID, '1993-05-11':::DATE, '\x93a67505e3aeae94c3':::BYTES)],
										ARRAY[(-487625373):::INT8,819255205:::INT8,735288386:::INT8]
									)
							)
								AS tab_17699 (col_43506, col_43507)
				)
		SELECT
			tab_17700.tableoid AS col_43508
		FROM
			with_7232 AS cte_ref_2113,
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_17700,
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_17701
		WHERE
			true
		LIMIT
			75:::INT8;
Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

@rafiss rafiss mentioned this issue Sep 28, 2021
Closed
@rafiss
Copy link
Collaborator

rafiss commented Sep 28, 2021

Filed #70831 to track the bug separately from this test.

@cockroach-teamcity
Copy link
Member Author

roachtest.sqlsmith/setup=seed/setting=no-mutations failed with artifacts on master @ 5f53feb1ce7070453e9ce52d99013934718cc9d7:

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=seed/setting=no-mutations/run_1
	sqlsmith.go:223,sqlsmith.go:256,test_runner.go:777: error: pq: internal error: no volatility for cast tuple[]::tuple{oid, timetz}[]
		stmt:
		SELECT
			CASE
			WHEN false
			THEN ARRAY[(0:::OID, '15:35:56.531681+09:59:00':::TIMETZ),(1675207521:::OID, '00:00:00+15:59:00':::TIMETZ),(0:::OID, '00:02:51.186077-00:56:00':::TIMETZ)]
			ELSE ARRAY[]:::RECORD[]
			END
				AS col_87476;
Reproduce

See: roachtest README

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

@yuzefovich
Copy link
Member

All issues here are dups of #70831.

@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
Assignees

@mgartner mgartner

Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-queries SQL Queries Team
Projects
SQL Queries
Archived in project
Milestone
No milestone
Development

No branches or pull requests
4 participants
@mgartner @rafiss @yuzefovich @cockroach-teamcity