Skip to content

sql: TestExecBuild/local/hash_sharded_index/test_hash_index_unique_constraint_sec_key fails under stress #75960

@stevendanna

Description

@stevendanna

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

Metadata

Metadata

Assignees

Labels

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-sql-queriesSQL Queries Teamskipped-test

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions