Skip to content

Instantly share code, notes, and snippets.

@jordanlewis
Created February 15, 2019 19:34
Show Gist options
  • Save jordanlewis/1037fb0c5d3040b6022954e1ebd9e3db to your computer and use it in GitHub Desktop.
Save jordanlewis/1037fb0c5d3040b6022954e1ebd9e3db to your computer and use it in GitHub Desktop.
Left expr has relational output (1,2)
Left bound cols: (1)
Creating indexed vars for cols [0 1 2 5 3]
panic: invalid var index 2 (columns: 2) [recovered]
panic: panic while executing 1 statements: SELECT * FROM _ WHERE (SELECT min(_) FROM _ WHERE _._ = _._) IN (SELECT _ FROM _ WHERE _._ = _._); caused by invalid var index 2 (columns: 2)
goroutine 145 [running]:
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).closeWrapper(0xc00185a000, 0x6bf4360, 0xc000879d00, 0x6139180, 0xc0017a9f50)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:721 +0x36d
github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn.func1(0xc00185a000, 0x6bf4360, 0xc000879d00)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:427 +0x61
panic(0x6139180, 0xc0017a9f50)
/usr/local/Cellar/go/1.11/libexec/src/runtime/panic.go:513 +0x1b9
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*IndexedVarHelper).checkIndex(0xc000fd2df0, 0x2)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/indexed_vars.go:184 +0x139
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*IndexedVarHelper).IndexedVar(0xc000fd2df0, 0x2, 0xc00165de30)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/indexed_vars.go:197 +0x39
github.com/cockroachdb/cockroach/pkg/sql.(*execFactory).ConstructSimpleProject(0xc000698910, 0x62d0de0, 0xc0011d9340, 0xc000266d20, 0x5, 0x6, 0x0, 0x0, 0x0, 0x0, ...)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/opt_exec_factory.go:210 +0x1f2
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupByInput(0xc00165d9e0, 0x6c22400, 0xc001528830, 0x0, 0x0, 0x0, 0x0, 0x0, 0xa0, 0x6)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational_builder.go:873 +0x48b
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupBy(0xc00165d9e0, 0x6c22400, 0xc001528830, 0x0, 0x0, 0x0, 0x0, 0x0, 0xc00003a000, 0xc00173b260)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational_builder.go:724 +0x98
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational(0xc00165d9e0, 0x6c22400, 0xc001528830, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational_builder.go:171 +0x206
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildSelect(0xc00165d9e0, 0xc0015d3bb0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational_builder.go:397 +0x97
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational(0xc00165d9e0, 0x6c23120, 0xc0015d3bb0, 0x0, 0x0, 0x0, 0x0, 0x0, 0xc00003a000, 0x62f3660)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational_builder.go:165 +0xbef
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupByInput(0xc00165d9e0, 0x6c22400, 0xc001528a70, 0x0, 0x0, 0x0, 0x0, 0x0, 0x6bff9e0, 0xc0010ef830)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational_builder.go:837 +0xec
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupBy(0xc00165d9e0, 0x6c22400, 0xc001528a70, 0x0, 0x0, 0x0, 0x0, 0x0, 0xc001214400, 0x1)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational_builder.go:724 +0x98
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational(0xc00165d9e0, 0x6c22400, 0xc001528a70, 0x0, 0x0, 0x0, 0x0, 0x0, 0xc001214a48, 0x400e4af)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational_builder.go:171 +0x206
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).build(0xc00165d9e0, 0x6bffba0, 0xc001528a70, 0x0, 0xc001214a78, 0x400ed38, 0x60)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/builder.go:63 +0xab
github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).Build(0xc00165d9e0, 0xc00165d9e0, 0xc000f3ed20, 0xc001866000, 0x6bf4400)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/builder.go:51 +0x41
github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan(0xc00185a458, 0x6bf4420, 0xc000f3ed20, 0x652dc0b, 0x19, 0x9b94216352418, 0x252ecc8)
/Users/jordan/repo/src/github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:153 +0x1ad
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan(0xc00185a000, 0x6bf4420, 0xc000f3ed20, 0xc00185a458, 0x6, 0x400e4af)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment