-
Notifications
You must be signed in to change notification settings - Fork 4.1k
opt: sqllite logic test optimizer verification errors #78615
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 Team
Description
$ ./dev test ./pkg/sql/logictest -v -f=TestSqlLiteLogic/fakedist-disk/slt_good_0.test --test-args '-bigtest'
/Users/tpr/go/src/github.com/cockroachdb/sqllogictest/test/index/between/1/slt_good_0.test:437: SELECT pk FROM tab1 WHERE (col4 IN (5.85,5.95,6.30,0.0,1.27) AND (col4 IN (9.41,4.56,2.55,0.83,3.95,6.92) AND (col1 = 6.24)) OR col0 IN (SELECT col3 FROM tab1 WHERE (((((col0 IN (8,1) AND col0 IS NULL AND col1 < 9.21) AND col4 > 8.64 AND (col3 >= 9) OR col0 < 5)))))) AND (col1 < 7.95 OR col0 < 0) AND col3 >= 9 AND col0 < 2 OR col4 BETWEEN 1.13 AND 0.71 AND (col3 > 9) AND (col0 < 3)
expected success, but found
(XX000) internal error: output cols mismatch: (64-66,68,69) vs (14,64-66,68,69)
verify.go:89: in VerifyAgainst()
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/sql/opt/props/verify.go:89: VerifyAgainst()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/check_expr.go:54: CheckExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr.og.go:24006: AddLookupJoinToGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/join_funcs.go:758: func1()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/scan_index_iter.go:298: ForEachStartingAfter()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/scan_index_iter.go:209: ForEach()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/join_funcs.go:359: generateLookupJoinsImpl()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/join_funcs.go:256: GenerateLookupJoins()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/explorer.og.go:1865: exploreSemiJoin()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/explorer.og.go:34: exploreGroupMember()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/explorer.go:182: exploreGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:495: optimizeGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:265: optimizeExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:537: optimizeGroupMember()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:482: optimizeGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:265: optimizeExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:537: optimizeGroupMember()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:482: optimizeGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:265: optimizeExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:537: optimizeGroupMember()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:482: optimizeGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:265: optimizeExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:537: optimizeGroupMember()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:482: optimizeGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:265: optimizeExpr()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:537: optimizeGroupMember()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:482: optimizeGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:653: optimizeEnforcer()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:612: enforceProps()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:522: optimizeGroupMember()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:482: optimizeGroup()
github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:235: Optimize()
Epic: CRDB-14914
Jira issue: CRDB-14197
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 Team
Type
Projects
Status
Done