Skip to content

sql: internal error: expected constant FD to be strict: lax-key() #43651

@yuzefovich

Description

@yuzefovich

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()
...

Metadata

Metadata

Assignees

Labels

C-bugCode 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.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions