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