Skip to content

sqlsmith: optimizer stack overflow with virtual PK columns #75147

@mgartner

Description

@mgartner

Sqlsmith found a query that causes a stack overflow. I've only been able to reproduce with VIRTUAL columns in the PK, which has only been allowed since #73928, so this bug is not present in any releases.

CREATE TABLE t (
  a INT,
  b INT,
  c INT,
  v1 INT AS (c) VIRTUAL,
  v2 INT AS (c) VIRTUAL,
  PRIMARY KEY (b, v1, v2),
  INDEX (a)
);


SELECT 'foo'
FROM t AS t1
JOIN t AS t2 ON
  t1.v2 = t2.v2
  AND t1.v1 = t2.v1
  AND t1.b = t2.b
JOIN t AS t3 ON t1.a = t3.a;
CREATE TABLE
runtime: goroutine stack exceeds 1000000000-byte limit
runtime: sp=0xc025bd0380 stack=[0xc025bd0000, 0xc045bd0000]
fatal error: stack overflow

runtime stack:
runtime.throw({0x868939d, 0xc2ea780})
	/usr/local/opt/go/libexec/src/runtime/panic.go:1198 +0x71
runtime.newstack()
	/usr/local/opt/go/libexec/src/runtime/stack.go:1088 +0x5ac
runtime.morestack()
	/usr/local/opt/go/libexec/src/runtime/asm_amd64.s:461 +0x8b

goroutine 5983 [running]:
runtime.getitab(0x812bee0, 0x8578e40, 0x0)
	/usr/local/opt/go/libexec/src/runtime/iface.go:33 +0x2da fp=0xc025bd0390 sp=0xc025bd0388 pc=0x400d93a
runtime.convI2I(0x0, {0x9aae690, 0xc0044bdd60})
	/usr/local/opt/go/libexec/src/runtime/iface.go:445 +0x4a fp=0xc025bd03c0 sp=0xc025bd0390 pc=0x400e7aa
github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*LookupJoinExpr).Child(0x0, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/memo/expr.og.go:3135 +0x49 fp=0xc025bd0400 sp=0xc025bd03c0 pc=0x5adcd69
github.com/cockroachdb/cockroach/pkg/sql/opt/ordering.lookupOrIndexJoinBuildChildReqOrdering({0x9aaec30, 0xc002bbc840}, 0x0, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/ordering/lookup_join.go:58 +0x6d fp=0xc025bd0538 sp=0xc025bd0400 pc=0x69a126d
github.com/cockroachdb/cockroach/pkg/sql/opt/ordering.BuildChildRequired({0x9aaec30, 0xc002bbc840}, 0xc0044bdd60, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/ordering/ordering.go:40 +0xa2 fp=0xc025bd05d8 sp=0xc025bd0538 pc=0x69a2582
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.BuildChildPhysicalProps(0xc004b334a0, {0x9aaec30, 0xc002bbc840}, 0xc751200, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/physical_props.go:87 +0x407 fp=0xc025bd0700 sp=0xc025bd05d8 pc=0x69e1207
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:508 +0xcd fp=0xc025bd0770 sp=0xc025bd0700 pc=0x69df16d
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd0808 sp=0xc025bd0770 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd0880 sp=0xc025bd0808 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd08f0 sp=0xc025bd0880 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd0988 sp=0xc025bd08f0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd0a00 sp=0xc025bd0988 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd0a70 sp=0xc025bd0a00 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd0b08 sp=0xc025bd0a70 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd0b80 sp=0xc025bd0b08 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd0bf0 sp=0xc025bd0b80 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd0c88 sp=0xc025bd0bf0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd0d00 sp=0xc025bd0c88 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd0d70 sp=0xc025bd0d00 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd0e08 sp=0xc025bd0d70 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd0e80 sp=0xc025bd0e08 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd0ef0 sp=0xc025bd0e80 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd0f88 sp=0xc025bd0ef0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd1000 sp=0xc025bd0f88 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd1070 sp=0xc025bd1000 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd1108 sp=0xc025bd1070 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd1180 sp=0xc025bd1108 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd11f0 sp=0xc025bd1180 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd1288 sp=0xc025bd11f0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd1300 sp=0xc025bd1288 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd1370 sp=0xc025bd1300 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd1408 sp=0xc025bd1370 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd1480 sp=0xc025bd1408 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd14f0 sp=0xc025bd1480 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd1588 sp=0xc025bd14f0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd1600 sp=0xc025bd1588 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd1670 sp=0xc025bd1600 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd1708 sp=0xc025bd1670 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd1780 sp=0xc025bd1708 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd17f0 sp=0xc025bd1780 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd1888 sp=0xc025bd17f0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd1900 sp=0xc025bd1888 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd1970 sp=0xc025bd1900 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd1a08 sp=0xc025bd1970 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd1a80 sp=0xc025bd1a08 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd1af0 sp=0xc025bd1a80 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd1b88 sp=0xc025bd1af0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd1c00 sp=0xc025bd1b88 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd1c70 sp=0xc025bd1c00 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd1d08 sp=0xc025bd1c70 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd1d80 sp=0xc025bd1d08 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd1df0 sp=0xc025bd1d80 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd1e88 sp=0xc025bd1df0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd1f00 sp=0xc025bd1e88 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd1f70 sp=0xc025bd1f00 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd2008 sp=0xc025bd1f70 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd2080 sp=0xc025bd2008 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd20f0 sp=0xc025bd2080 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd2188 sp=0xc025bd20f0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd2200 sp=0xc025bd2188 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd2270 sp=0xc025bd2200 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd2308 sp=0xc025bd2270 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd2380 sp=0xc025bd2308 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd23f0 sp=0xc025bd2380 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd2488 sp=0xc025bd23f0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd2500 sp=0xc025bd2488 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd2570 sp=0xc025bd2500 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd2608 sp=0xc025bd2570 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd2680 sp=0xc025bd2608 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd26f0 sp=0xc025bd2680 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd2788 sp=0xc025bd26f0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd2800 sp=0xc025bd2788 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd2870 sp=0xc025bd2800 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd2908 sp=0xc025bd2870 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd2980 sp=0xc025bd2908 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd29f0 sp=0xc025bd2980 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd2a88 sp=0xc025bd29f0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd2b00 sp=0xc025bd2a88 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd2b70 sp=0xc025bd2b00 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd2c08 sp=0xc025bd2b70 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd2c80 sp=0xc025bd2c08 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd2cf0 sp=0xc025bd2c80 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd2d88 sp=0xc025bd2cf0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd2e00 sp=0xc025bd2d88 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd2e70 sp=0xc025bd2e00 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd2f08 sp=0xc025bd2e70 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd2f80 sp=0xc025bd2f08 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd2ff0 sp=0xc025bd2f80 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd3088 sp=0xc025bd2ff0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd3100 sp=0xc025bd3088 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd3170 sp=0xc025bd3100 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd3208 sp=0xc025bd3170 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd3280 sp=0xc025bd3208 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd32f0 sp=0xc025bd3280 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd3388 sp=0xc025bd32f0 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0044bdd60}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd3400 sp=0xc025bd3388 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394cb0, {0x9aaec30, 0xc002bbc840}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd3470 sp=0xc025bd3400 pc=0x69df1a5
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup(0xc004b334a0, {0x9aae690, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:456 +0x325 fp=0xc025bd3508 sp=0xc025bd3470 pc=0x69df025
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr(0xc004b334a0, {0x9a1cd38, 0xc0026b21e0}, 0xc751200)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:256 +0x11e fp=0xc025bd3580 sp=0xc025bd3508 pc=0x69dec3e
github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember(0xc004b334a0, 0xc005394af0, {0x9aaf1d0, 0xc005549810}, 0x0)
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/xform/optimizer.go:511 +0x105 fp=0xc025bd35f0 sp=0xc025bd3580 pc=0x69df1a5
...additional frames elided...
created by github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync
	/Users/marcus/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:594 +0x273

Metadata

Metadata

Assignees

Labels

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-sql-queriesSQL Queries Team

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions