cockroachdb / cockroachdb/cockroach
roachtest: tlp failed [flake due to lack of `ORDER BY` with `LIMIT` clause]
- 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
Assessment
This issue has not been assessed yet.