-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: TestExecBuild/local/hash_sharded_index/test_hash_index_unique_constraint_sec_key fails under stress #75960
Copy link
Copy link
Closed
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-sql-queriesSQL Queries TeamSQL Queries Teamskipped-test
Description
As of 61e2304:
=== RUN TestExecBuild/local/hash_sharded_index/test_hash_index_unique_constraint_sec_key
logic.go:2493:
/private/var/tmp/_bazel_ssd/a51ea94df2f483aee3088dde6a3dde4e/sandbox/darwin-sandbox/8339/execroot/cockroach/bazel-out/darwin-fastbuild/bin/pkg/sql/opt/exec/execbuilder/execbuilder_test_/execbuilder_test.runfiles/cockroach/pkg/sql/opt/exec/execb
uilder/testdata/hash_sharded_index:469: EXPLAIN (VERBOSE) UPDATE t_hash_indexed SET b = 8765 WHERE a = 4321;
expected:
distribution: local
vectorized: true
·
• update
│ columns: ()
│ estimated row count: 0 (missing stats)
│ table: t_hash_indexed
│ set: b, crdb_internal_b_shard_8
│ auto commit
│
└── • render
│ columns: (a, b, crdb_internal_b_shard_8, b_new, crdb_internal_b_shard_8_cast, check1)
│ estimated row count: 1 (missing stats)
│ render check1: true
│ render crdb_internal_b_shard_8_cast: 3
│ render b_new: 8765
│ render crdb_internal_b_shard_8: mod(fnv32(crdb_internal.datums_to_bytes(b)), 8)
│ render a: a
│ render b: b
│
└── • scan
columns: (a, b)
estimated row count: 1 (missing stats)
table: t_hash_indexed@t_hash_indexed_pkey
spans: /4321/0
locking strength: for update
but found (query options: "") :
distribution: local
vectorized: true
·
• update
│ columns: ()
│ estimated row count: 0 (missing stats)
│ table: t_hash_indexed
│ set: b, crdb_internal_b_shard_8
│ auto commit
│
└── • render
│ columns: (a, b, crdb_internal_b_shard_8, b_new, crdb_internal_b_shard_8_cast, check1)
│ estimated row count: 1 (missing stats)
│ render check1: true
│ render crdb_internal_b_shard_8_cast: 3
│ render b_new: 8765
│ render crdb_internal_b_shard_8: mod(fnv32(crdb_internal.datums_to_bytes(b)), 8)
│ render a: a
│ render b: b
│
└── • scan
columns: (a, b)
estimated row count: 1 (missing stats)
table: t_hash_indexed@t_hash_indexed_pkey
spans: /4321/1/1
locking strength: for update
Diff:
--- Expected
+++ Actual
@@ -24,3 +24,3 @@
table: t_hash_indexed@t_hash_indexed_pkey
- spans: /4321/0
+ spans: /4321/1/1
locking strength: for update
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-sql-queriesSQL Queries TeamSQL Queries Teamskipped-test
Type
Projects
Status
Done