Comments (3)
roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on release-23.2 @ d91ca866b265a837f832bc93b59481847d721f18:
+ ``1986-11-05 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1986-11-08 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1987-11-19 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1987-11-29 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1988-02-14 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1988-06-01 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1989-02-25 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1989-10-29 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1990-07-01 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1991-06-10 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1991-10-02 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1992-01-15 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1992-07-18 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1993-04-29 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1993-06-29 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1993-08-16 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1994-06-27 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1994-09-24 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1994-10-12 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1994-11-30 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1995-02-04 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1995-06-03 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1995-06-30 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1995-11-02 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1995-11-22 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1996-01-13 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1996-03-26 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1996-06-24 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
+ ``1996-07-02 00:00:00 +0000 +0000,BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793),{"b": 1.2360945550345361},0``,
... // 69 identical elements
}
sql: SELECT
tab_1745.col2_1 AS col_4522,
'BOX(-0.517478276052744 0.4854866877302188,0.12555500657776975 0.5913677364431793)':::BOX2D AS col_4523,
'{"b": 1.2360945550345361}':::JSONB AS col_4524,
0:::OID AS col_4525
FROM
defaultdb.public.table2@[0] AS tab_1745
ORDER BY
col_4522 DESC,
tab_1745."col2�_0" DESC,
tab_1745.crdb_internal_mvcc_timestamp NULLS FIRST,
tab_1745.col2_1 NULLS LAST,
tab_1745.tableoid,
col_4525 DESC,
col_4523 NULLS FIRST,
col_4524 ASC NULLS FIRST
LIMIT
69:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-tables/run_1
Parameters:
ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Same failure on other branches
- #122758 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-master release-blocker]
- #118273 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot P-3 T-sql-queries branch-release-23.1]
This test on roachdash | Improve this report!
from cockroach.
roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on release-23.2 @ d91ca866b265a837f832bc93b59481847d721f18:
+ "\r\xcc\xd2,NULL,0000-01-01 00:01:40.01 +0900 +0900,W,0",
+ " a,NULL,0000-01-01 08:20:00 +0600 +0600,W,0",
+ " a,NULL,NULL,MLuK,0",
+ ``",NULL,0000-01-01 00:00:10 +0000 UTC,W,0``,
+ "#,NULL,NULL,W,0",
+ "$\xfb\x1aq\xd3\u05ed\xe0,NULL,NULL,W,0",
+ "%\xbb\x05\xbbkun\x91,NULL,NULL,W,0",
+ ",NULL,0000-01-01 00:01:40.01 -0800 -0800,W,0",
+ ",NULL,0000-01-01 08:02:01.105299 +1359 +1359,W,0",
+ ",NULL,0000-01-01 21:25:36.671145 -0421 -0421,W,0",
+ ",NULL,NULL,W,0",
+ ",NULL,NULL,W,0",
+ ",\xfc\xf3,NULL,NULL,W,0",
+ "1\xb5\xab\xe8\x8d,NULL,NULL,W,0",
+ "2\bu\xfbG,NULL,0000-01-01 02:18:38.343872 -0353 -0353,W,0",
+ "3\xddY,NULL,NULL,W,0",
+ ";\xa7\xf6\a\xc8\x13,NULL,0000-01-01 16:01:39.649272 +0819 +0819,W,0",
+ "@,\x80,NULL,NULL,W,0",
... // 65 identical and 105 inserted elements
}
sql: SELECT
tab_147."col1_?0" AS col_362,
NULL AS col_363,
tab_147."co l1_5" AS col_364,
tab_147.col1_8 AS col_365,
0:::OID AS col_366
FROM
defaultdb.public.table1@[0] AS tab_147
ORDER BY
tab_147."col1_?0" DESC,
tab_147.col1_7 DESC NULLS LAST,
tab_147.col1_9 DESC NULLS LAST,
tab_147."co l1_5" DESC,
col_364 NULLS LAST,
col_365 NULLS LAST,
tab_147.col1_4 DESC NULLS FIRST,
col_362 ASC NULLS FIRST,
tab_147.col1_3,
tab_147.crdb_internal_mvcc_timestamp NULLS LAST,
tab_147."col1' _1" ASC NULLS LAST,
col_366 ASC NULLS FIRST,
tab_147.")c\\U0009C6FBol1_2",
tab_147."c(ol,1_10" NULLS FIRST,
tab_147.col1_8 ASC NULLS LAST,
tab_147.col1_6,
col_363 DESC NULLS FIRST,
tab_147.tableoid ASC
LIMIT
65:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-tables/run_1
Parameters:
ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Same failure on other branches
- #122758 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-master release-blocker]
- #118273 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot P-3 T-sql-queries branch-release-23.1]
This test on roachdash | Improve this report!
from cockroach.
This is a bug. Reproduction:
SET vectorize = off;
CREATE TABLE t (a int, b int, INDEX t_b_idx (b ASC) STORING (a));
INSERT INTO t VALUES
(1, 2),
(3, 4),
(5, 6);
SELECT count(*) AS col1
FROM t
GROUP BY a, b
ORDER BY b, a DESC
LIMIT 2;
This produces 3 rows when it should only produce 2:
col1
--------
1
1
1
(3 rows)
Here's the query plan:
info
--------------------------------------------------------------
distribution: local
vectorized: false
• top-k
│ order: +b,-a
│ k: 2
│
└── • group (partial streaming)
│ group by: a, b
│ ordered: +b
│
└── • scan
missing stats
table: t@t_b_idx
spans: FULL SCAN (SOFT LIMIT)
from cockroach.
Related Issues (20)
- roachtest: schemachange/leasing-benchmark failed HOT 2
- kv/kvserver: TestRangefeedCheckpointsRecoverFromLeaseExpiration failed HOT 1
- opt: do not blanket-exempt partial indexes from disallow_full_table_scans
- roachtest: tpcc/mixed-headroom/n5cpu16 failed
- roachtest: add a new large schema benchmark which can be used to explore object limits
- roachtest: extend large schema benchmark into multi-region
- sql: explicit zone configuration for the timeseries range on a new cluster
- sql: TestExplainRedact failed HOT 1
- roachtest: test server endpoints in large schema benchmark
- online restore: limit disk bandwidth used by downloads in mb/s to avoid starving wal syncs HOT 2
- roachprod: support zfs vms for azure and aws HOT 1
- Update scheduled changefeeds to pause if resumed on a different cluster HOT 1
- roachprod: support specifying SSD count on azure and aws
- sql: full scans of virtual tables don't error out with `disallow_full_table_scans`
- catalog/lease: transactions are not producing deadline errors when they should HOT 1
- pkg/sql/logictest/tests/cockroach-go-testserver-23.2/cockroach-go-testserver-23_2_test: TestLogic_upgrade_skip_version failed HOT 1
- pkg/sql/logictest/tests/cockroach-go-testserver-23.2/cockroach-go-testserver-23_2_test: TestLogic_mixed_version_sequence_per_node_cache failed HOT 1
- Sentry: fold_constants_funcs.go:677: function current_schema() not defined (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pkg/sql/opt/norm... HOT 1
- roachtest: backup-restore/mixed-version failed HOT 1
- roachtest: kv/gracefuldraining failed
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cockroach.