-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: internal error: expected constant FD to be strict: lax-key() #43651
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.S-3-ux-surpriseIssue leaves users wondering whether CRDB is behaving properly. Likely to hurt reputation/adoption.Issue leaves users wondering whether CRDB is behaving properly. Likely to hurt reputation/adoption.
Description
Extracted from #42096 (comment).
Currently on master running
SELECT
tab_14919.col_25812 AS col_25814
FROM
(VALUES (NULL)) AS tab_14919 (col_25812)
FULL JOIN (VALUES ('23:59:59.999999':::TIME))
AS tab_14920 (col_25813) ON false
WHERE
(NOT NULL);
produces:
ERROR: internal error: expected constant FD to be strict: lax-key()
SQLSTATE: XX000
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/sql/opt/props/func_dep.go:1438: addDependency()
github.com/cockroachdb/cockroach/pkg/sql/opt/props/func_dep.go:1224: ensureKeyClosure()
github.com/cockroachdb/cockroach/pkg/sql/opt/props/func_dep.go:1187: MakeOuter()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/logical_props_builder.go:1944: setFuncDeps()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/logical_props_builder.go:415: buildJoinProps()
github.com/cockroachdb/cockroach/pkg/sql/opt/memo/logical_props_builder.go:356: buildFullJoinProps()
...
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.S-3-ux-surpriseIssue leaves users wondering whether CRDB is behaving properly. Likely to hurt reputation/adoption.Issue leaves users wondering whether CRDB is behaving properly. Likely to hurt reputation/adoption.