cockroachdb / cockroachdb/cockroach

roachtest: tlp failed [flake due to lack of `ORDER BY` with `LIMIT` clause]

Open
#159,137 4 comments 0 reactions 1 assignee Claimed by @ZhouXing19 View on GitHub
B-runtime-assertions-enabled branch-release-24.1 C-test-failure O-roachtest O-robot O-rsg P-3 T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**Note:** This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar failure without this message. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.tlp [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/20838398?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/20838398?buildTab=artifacts#/tlp) on release-24.1 @ [7a6e9260380add4fcc6f5a2105bea157330bd8ba](https://github.com/cockroachdb/cockroach/commits/7a6e9260380add4fcc6f5a2105bea157330bd8ba):

```
(tlp.go:175).runOneTLP: expected unpartitioned and partitioned results to be equal
  []string(
-  {
-  ",{},',NULL,2033-02-13 01:25:09.000804 +0000 UTC,2003-04-23 12:14:52.00011 +0000 UTC,'IFZAMXu':32B,105A,389C 'RDzoYuUI':99B,230C,"...,
-  "Q\x18b10\x04/\x18,NULL,uX,NULL,2025-03-15 15:02:04.000271 +0000 UTC,1995-01-29 03:41:30.000776 +0000 UTC,'wKVkmMeTTI':8B,777A 'zTjuVLbl',"...,
-  },
+  nil,
  )
sql: SELECT *, st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL, NOT (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL), (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL) IS NULL, true, false, false FROM defaultdb.public.table_3 AS tab_10843
(SELECT *,
st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL, NOT (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL), (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL) IS NULL,
st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL, NOT (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL), (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL) IS NULL
FROM defaultdb.public.table_3 AS tab_10843
WHERE st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL)
UNION ALL (SELECT *,
st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL, NOT (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL), (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL) IS NULL,
NOT (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL), st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL, (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL) IS NULL
FROM defaultdb.public.table_3 AS tab_10843
WHERE NOT (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL))
UNION ALL (SELECT *,
st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL, NOT (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL), (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL) IS NULL,
(st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL) IS NULL, (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL) IS NOT NULL, (NOT (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL)) IS NOT NULL
FROM defaultdb.public.table_3 AS tab_10843
WHERE (st_coveredby('010500004002000000010200004004000000ABA1C7821F8DF1C18090A65FDE83D9C14A4C2DBD851EF7C1304328BCFDE8DD4124E21EF205A3F6C1404DE940223BD4C1AC844D326ACFFE410CBD3DC1066E01426C3C3A1EE19AFD41C06EAFF57208CC41F89C9D73F1CEF541008E9111BE6282410102000040020000001CDFE5634385F5C19CCF8C33940DF7C1BED1DD36E473F7C11B2FD336D539F2C1C7E7F4CB34BF00C2A0376384AC19C6C1':::GEOMETRY::GEOMETRY, (WITH with_246 (col_725) AS (SELECT * FROM (VALUES (1312044930:::INT8), (313561384:::INT8), ((-1857971668):::INT8)) AS tab_10844 (col_725)) SELECT (WITH with_247 (col_726) AS (SELECT * FROM (VALUES ('\x64b235c959':::BYTES), ('\x20':::BYTES), ('\xed2ae5':::BYTES), (('\xd20f76e30f0920':::BYTES::BYTES || '\x66a6':::BYTES::BYTES)::BYTES), (('\x54d5c80ae95dfedb':::BYTES::BYTES || '\x202f6e':::BYTES::BYTES)::BYTES), ('\x7ac189683b8a':::BYTES)) AS tab_10846 (col_726)) SELECT tab_10845.col2_0 AS col_727 LIMIT 1:::INT8) AS col_728 FROM defaultdb.public."tab\vle_2"@[0] AS tab_10845 LIMIT 1:::INT8)::GEOMETRY)::BOOL) IS NULL)
with args: []
test artifacts and logs in: /artifacts/tlp/run_1
```

Parameters:
- arch=amd64
- cloud=gce
- coverageBuild=false
- cpu=4
- encrypted=false
- runtimeAssertionsBuild=true
- ssd=0
Help

See: [roachtest README](https://github.com/cockroachdb/cockroach/blob/master/pkg/cmd/roachtest/README.md)

See: [How To Investigate \(internal\)](https://cockroachlabs.atlassian.net/l/c/SSSBr8c7)

See: [Grafana](https://go.crdb.dev/roachtest-grafana/teamcity-20838398/tlp/1765358280430/1765359960868)

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*tlp.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Jira issue: CRDB-57702

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.