Skip to content

sql: internal error: indexed var must be bound to a container before evaluation #38286

@madelynnblue

Description

@madelynnblue
CREATE TABLE table1 (
	col0  TIMESTAMPTZ,
	col1  BIT(22),
	col2  NAME,
	col3  INT8 NULL,
	col4  "char" NOT NULL,
	col5  CHAR NOT NULL,
	col6  CHAR NOT NULL,
	col7  INET NOT NULL,
	col8  INT2 NULL,
	col9  REGNAMESPACE NOT NULL,
	col10 REGTYPE NULL,
	col11 OID NOT NULL,
	col12 REGTYPE NULL,
	col13 BIT(42) NOT NULL,
	col14 INT8 NULL,
	col15 FLOAT8 NULL,
	FAMILY fam0 (col9, col4, col0, col1, col6),
	FAMILY fam1 (col10, col2, col5, col14, col15, col7, col11, col13, col12, col3, col8),
	PRIMARY KEY (col6 ASC),
	INDEX (col7 DESC, col2, col5 DESC, col1, col12 ASC, col0 DESC, col15 ASC)
);

    WITH with_124059 (col_1570955) AS (
									SELECT *
									  FROM (
											VALUES (NULL),
											       (2609206515:::OID),
											       (4037323730:::OID),
											       (1711655002:::OID),
											       (3423528832:::OID)
									       ) AS tab_536190 (col_1570955)
                                   )
  SELECT tab_536191.col11 AS col_1570956,
         ARRAY[
			2917945630780613107:::INT8,
			6992170413345928079:::INT8,
			5859734096475146714:::INT8,
			(-6072750870110614877):::INT8
         ] AS col_1570957,
         tab_536191.col11 AS col_1570958,
         stddev(tab_536191.col8::INT8)::DECIMAL AS col_1570959,
         min(tab_536191.col5::STRING) OVER (
			PARTITION BY tab_536191.col13, tab_536191.col4
			    ORDER BY tab_536191.col1, tab_536191.col13 DESC, tab_536191.col11, tab_536191.col5
			        ROWS BETWEEN tab_536191.col8 FOLLOWING AND 9223372036854775807:::INT8 FOLLOWING
         )::STRING AS col_1570960,
         (-0.45292767816968504):::FLOAT8 AS col_1570961,
         current_timestamp():::DATE::DATE AS col_1570962
    FROM defaultdb.public.table1 AS tab_536191
GROUP BY tab_536191.col4, tab_536191.col8, tab_536191.col11, tab_536191.col1, tab_536191.col13, tab_536191.col5
ORDER BY tab_536191.col13 DESC, tab_536191.col8 DESC, tab_536191.col11
   LIMIT 9:::INT8;
github.com/cockroachdb/cockroach/pkg/sql/sem/tree/indexed_vars.go:77: Eval()
github.com/cockroachdb/cockroach/pkg/sql/distsqlpb/processors.go:92: initFromAST()
github.com/cockroachdb/cockroach/pkg/sql/distsqlpb/processors.go:195: InitFromAST()
github.com/cockroachdb/cockroach/pkg/sql/distsql_plan_window.go:141: createWindowFnSpec()
github.com/cockroachdb/cockroach/pkg/sql/distsql_physical_planner.go:3113: createPlanForWindow()
github.com/cockroachdb/cockroach/pkg/sql/distsql_physical_planner.go:2401: createPlanForNode()
github.com/cockroachdb/cockroach/pkg/sql/distsql_physical_planner.go:2332: createPlanForNode()
github.com/cockroachdb/cockroach/pkg/sql/distsql_physical_planner.go:2350: createPlanForNode()
github.com/cockroachdb/cockroach/pkg/sql/distsql_physical_planner.go:2312: createPlanForNode()
github.com/cockroachdb/cockroach/pkg/sql/distsql_physical_planner.go:2312: createPlanForNode()
github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:834: PlanAndRun()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:896: execWithDistSQLEngine()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:732: dispatchToExecutionEngine()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:419: execStmtInOpenState()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:101: execStmt()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1206: execCmd()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1142: run()
github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:444: ServeConn()
github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:582: func1()
runtime/asm_amd64.s:1337: goexit()

Metadata

Metadata

Assignees

Labels

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-sqlsmith

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions