sql/opt/xform: TestRules failed

[cockroach-teamcity]

sql/opt/xform.TestRules failed on release-24.3 @ 4cbedefd790c75cb0f21f77ed8d917c8528a7d15:

        ================================================================================
        Source expression:
          inner-join (hash)
           ├── columns: a:1!null b:2!null c:3 x:7!null y:8!null z:9
           ├── fd: (1)==(7), (7)==(1), (2)==(8), (8)==(2)
           ├── scan xyz
           │    └── columns: x:7 y:8 z:9
           ├── scan abc
           │    └── columns: a:1 b:2 c:3
           └── filters
                ├── a:1 = x:7 [outer=(1,7), constraints=(/1: (/NULL - ]; /7: (/NULL - ]), fd=(1)==(7), (7)==(1)]
                └── b:2 = y:8 [outer=(2,8), constraints=(/2: (/NULL - ]; /8: (/NULL - ]), fd=(2)==(8), (8)==(2)]
        
        New expression 1 of 1:
          inner-join (merge)
           ├── columns: a:1!null b:2!null c:3 x:7!null y:8!null z:9
           ├── left ordering: +7,+8
           ├── right ordering: +1,+2
           ├── fd: (1)==(7), (7)==(1), (2)==(8), (8)==(2)
           ├── scan xyz@xy
           │    ├── columns: x:7 y:8 z:9
           │    └── ordering: +7,+8
           ├── scan abc@ab
           │    ├── columns: a:1 b:2 c:3
           │    └── ordering: +1,+2
           └── filters (true)
        
        ================================================================================
        GenerateLookupJoins
        ================================================================================
        Source expression:
          inner-join (hash)
           ├── columns: a:1!null b:2!null c:3 x:7!null y:8!null z:9
           ├── fd: (1)==(7), (7)==(1), (2)==(8), (8)==(2)
           ├── scan xyz
           │    └── columns: x:7 y:8 z:9
           ├── scan abc
           │    └── columns: a:1 b:2 c:3
           └── filters
                ├── a:1 = x:7 [outer=(1,7), constraints=(/1: (/NULL - ]; /7: (/NULL - ]), fd=(1)==(7), (7)==(1)]
                └── b:2 = y:8 [outer=(2,8), constraints=(/2: (/NULL - ]; /8: (/NULL - ]), fd=(2)==(8), (8)==(2)]
        
        New expression 1 of 1:
          inner-join (lookup abc@ab)
           ├── columns: a:1!null b:2!null c:3 x:7!null y:8!null z:9
           ├── key columns: [7 8] = [1 2]
           ├── fd: (1)==(7), (7)==(1), (2)==(8), (8)==(2)
           ├── scan xyz
           │    └── columns: x:7 y:8 z:9
           └── filters (true)

Parameters:

• attempt=1
• run=12
• shard=1

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

Jira issue: CRDB-43387