cockroachdb / cockroachdb/cockroach

sql: deep scalar AST causes node-crashing stack overflow

Open
#159,599 1 comment 0 reactions 0 assignees View on GitHub
C-bug T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

A query with very deeply nested parentheses can cause a stack overflow.

#### Reproduction

```bash
python3 -c "n=1000000; print('SELECT ' + '+1'*n + ';')" > crash.sql

cockroach demo --empty -f crash.sql
```

Stacktrace

```
runtime: goroutine stack exceeds 1000000000-byte limit
runtime: sp=0x14034dea3b0 stack=[0x14034dea000, 0x14054dea000]
fatal error: stack overflow

runtime stack:
runtime.throw({0x10616adc9?, 0x100b79c84?})
GOROOT/src/runtime/panic.go:1073 +0x38 fp=0x175b7ad50 sp=0x175b7ad20 pc=0x100bd2d78
runtime.newstack()
GOROOT/src/runtime/stack.go:1117 +0x78c fp=0x175b7af00 sp=0x175b7ad50 pc=0x100bafdcc
runtime.morestack()
src/runtime/asm_arm64.s:342 +0x70 fp=0x175b7af00 sp=0x175b7af00 pc=0x100bdb450

goroutine 2772 gp=0x1400f7ea8c0 m=14 mp=0x14000b80808 [running]:
runtime.mallocgc(0xd0?, 0x10802c280?, 0x1?)
GOROOT/src/runtime/malloc.go:983 +0xd0c fp=0x14034dea3b0 sp=0x14034dea3b0 pc=0x100bcc41c
runtime.newobject(0x14034dea418?)
GOROOT/src/runtime/malloc.go:1386 +0x2c fp=0x14034dea3e0 sp=0x14034dea3b0 pc=0x100b5ac9c
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.init.func8()
pkg/sql/sem/tree/overload.go:778 +0x24 fp=0x14034dea410 sp=0x14034dea3e0 pc=0x101cf1504
sync.(*Pool).Get(0x10cd847c0)
GOROOT/src/sync/pool.go:155 +0x288 fp=0x14034dea480 sp=0x14034dea410 pc=0x100beb738
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.getOverloadTypeChecker({0x108358740, 0x140011a0e88}, {0x14034dea6a8, 0x2, 0x0?})
pkg/sql/sem/tree/overload.go:787 +0x34 fp=0x14034dea4f0 sp=0x14034dea480 pc=0x101d44094
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x14011419f40, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:412 +0xb4 fp=0x14034dea6f0 sp=0x14034dea4f0 pc=0x101d7cb54
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97e10, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034deacd0 sp=0x14034dea6f0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a000, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034deaed0 sp=0x14034deacd0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97d40, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034deb4b0 sp=0x14034deaed0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a040, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034deb6b0 sp=0x14034deb4b0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97c70, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034debc90 sp=0x14034deb6b0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a080, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034debe90 sp=0x14034debc90 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97ba0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034dec470 sp=0x14034debe90 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a0c0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034dec670 sp=0x14034dec470 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97ad0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034decc50 sp=0x14034dec670 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a100, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034dece50 sp=0x14034decc50 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97a00, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034ded430 sp=0x14034dece50 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a140, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034ded630 sp=0x14034ded430 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97930, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034dedc10 sp=0x14034ded630 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a180, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034dede10 sp=0x14034dedc10 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97860, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034dee3f0 sp=0x14034dede10 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a1c0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034dee5f0 sp=0x14034dee3f0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97790, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034deebd0 sp=0x14034dee5f0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a200, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034deedd0 sp=0x14034deebd0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f976c0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034def3b0 sp=0x14034deedd0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a240, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034def5b0 sp=0x14034def3b0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f975f0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034defb90 sp=0x14034def5b0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a280, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034defd90 sp=0x14034defb90 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97520, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034df0370 sp=0x14034defd90 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a2c0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034df0570 sp=0x14034df0370 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97450, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034df0b50 sp=0x14034df0570 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a300, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034df0d50 sp=0x14034df0b50 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97380, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034df1330 sp=0x14034df0d50 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a340, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034df1530 sp=0x14034df1330 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f972b0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034df1b10 sp=0x14034df1530 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a380, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034df1d10 sp=0x14034df1b10 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f971e0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034df22f0 sp=0x14034df1d10 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a3c0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034df24f0 sp=0x14034df22f0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97110, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034df2ad0 sp=0x14034df24f0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a400, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034df2cd0 sp=0x14034df2ad0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f97040, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034df32b0 sp=0x14034df2cd0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a440, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034df34b0 sp=0x14034df32b0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f96f70, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034df3a90 sp=0x14034df34b0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a480, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034df3c90 sp=0x14034df3a90 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f96ea0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034df4270 sp=0x14034df3c90 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a4c0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034df4470 sp=0x14034df4270 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f96dd0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034df4a50 sp=0x14034df4470 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a500, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034df4c50 sp=0x14034df4a50 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14026f96d00, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14034df5230 sp=0x14034df4c50 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401141a540, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14034df5430 sp=0x14034df5230 pc=0x101d7cb90
...532530 frames elided...
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x1400359a0d0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14054de1ef0 sp=0x14054de1910 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401249cc40, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14054de20f0 sp=0x14054de1ef0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x1400359a000, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14054de26d0 sp=0x14054de20f0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401249cc80, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14054de28d0 sp=0x14054de26d0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14003581ba0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14054de2eb0 sp=0x14054de28d0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401249ccc0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14054de30b0 sp=0x14054de2eb0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14003581ad0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14054de3690 sp=0x14054de30b0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401249cd00, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14054de3890 sp=0x14054de3690 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14003581860, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14054de3e70 sp=0x14054de3890 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401249cd40, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14054de4070 sp=0x14054de3e70 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14003581790, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14054de4650 sp=0x14054de4070 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401249cd80, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14054de4850 sp=0x14054de4650 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14003581520, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14054de4e30 sp=0x14054de4850 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401249cdc0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14054de5030 sp=0x14054de4e30 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14003581040, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14054de5610 sp=0x14054de5030 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401249ce00, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14054de5810 sp=0x14054de5610 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14003580f70, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14054de5df0 sp=0x14054de5810 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401249ce40, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14054de5ff0 sp=0x14054de5df0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14003580dd0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14054de65d0 sp=0x14054de5ff0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401249ce80, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14054de67d0 sp=0x14054de65d0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs(0x14003580820, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60, 0x1)
pkg/sql/sem/tree/overload.go:1089 +0xab0 fp=0x14054de6db0 sp=0x14054de67d0 pc=0x101d45050
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*BinaryExpr).TypeCheck(0x1401249cec0, {0x10839be68, 0x14002ac80a0}, 0x14002ed2c60, 0x10cddee60)
pkg/sql/sem/tree/type_check.go:414 +0xf0 fp=0x14054de6fb0 sp=0x14054de6db0 pc=0x101d7cb90
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.TypeCheck({0x10839be68?, 0x14002ac80a0?}, {0x10839c060?, 0x1401249cec0?}, 0x1401249cec0?, 0x0?)
pkg/sql/sem/tree/type_check.go:367 +0x98 fp=0x14054de7000 sp=0x14054de6fb0 pc=0x101d7c668
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).resolveType(0x14003c54110, {0x10839c060?, 0x1401249cec0?}, 0x10cddee60)
pkg/sql/opt/optbuilder/scope.go:459 +0xbc fp=0x14054de7040 sp=0x14054de7000 pc=0x10414580c
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).analyzeSelectList(0x14009ac6160, 0x140038b8040, {0x0, 0x0, 0x140594551e8?}, 0x14003c54110, 0x14003c54218)
pkg/sql/opt/optbuilder/project.go:174 +0x36c fp=0x14054de71b0 sp=0x14054de7040 pc=0x10413721c
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).analyzeProjectionList(0x14009ac6160?, 0x140038b8000?, {0x0?, 0x0?, 0x0?}, 0x0?, 0x0?)
pkg/sql/opt/optbuilder/project.go:90 +0x128 fp=0x14054de7290 sp=0x14054de71b0 pc=0x104136b18
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectClause(0x14009ac6160, 0x140038b8000, {0x0, 0x0, 0x0}, {{0x0, 0x0, 0x0}, {0x0, 0x0, ...}, ...}, ...)
pkg/sql/opt/optbuilder/select.go:1233 +0x204 fp=0x14054de73a0 sp=0x14054de7290 pc=0x104154444
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectStmtWithoutParens(0x14009ac6160, {0x1083d3308, 0x140038b8000}, {0x0, 0x0, 0x0}, 0x0, {0x0, 0x0, 0x0?}, ...)
pkg/sql/opt/optbuilder/select.go:1154 +0x278 fp=0x14054de74f0 sp=0x14054de73a0 pc=0x104153ad8
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect.func1(0x0?)
pkg/sql/opt/optbuilder/select.go:1106 +0x7c fp=0x14054de75b0 sp=0x14054de74f0 pc=0x10415383c
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).processWiths(0x14009ac6160, 0x104046340?, 0x14059455708?, 0x14059455680)
pkg/sql/opt/optbuilder/with.go:110 +0x4c fp=0x14054de7620 sp=0x14054de75b0 pc=0x10416d78c
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect(0x10?, 0x10?, {{0x0, 0x0, 0x0}, {0x0, 0x0, 0x0}, 0x0, 0x0}, ...)
pkg/sql/opt/optbuilder/select.go:1105 +0x1dc fp=0x14054de7730 sp=0x14054de7620 pc=0x10415366c
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt(0x14009ac6160, {0x1083c4340, 0x14003fc4000}, {0x0, 0x0, 0x0}, 0x14003c54008)
pkg/sql/opt/optbuilder/builder.go:393 +0x45c fp=0x14054de7880 sp=0x14054de7730 pc=0x1040f04fc
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRootWithScope(0x14009ac6160, {0x1083c4340, 0x14003fc4000}, {0x0, 0x0, 0x0}, 0x14003c54008)
pkg/sql/opt/optbuilder/builder.go:331 +0x170 fp=0x14054de7920 sp=0x14054de7880 pc=0x1040eff40
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot(0x14009ac6160?, {0x1083c4340?, 0x14003fc4000?}, {0x0?, 0x0?, 0x0?})
pkg/sql/opt/optbuilder/builder.go:307 +0x110 fp=0x14054de7970 sp=0x14054de7920 pc=0x1040efd30
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).Build(0x14009ac6160)
pkg/sql/opt/optbuilder/builder.go:286 +0x268 fp=0x14054de7a50 sp=0x14054de7970 pc=0x1040ef9a8
github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildExecMemo(...)
pkg/sql/plan_opt.go:867
github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan(0x14002ed27f8, {0x10839be68?, 0x14002ac8000?})
pkg/sql/plan_opt.go:261 +0x600 fp=0x14054de7b90 sp=0x14054de7a50 pc=0x104408240
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan(0x14002ed2008, {0x10839be68, 0x14002ac8000}, 0x14002ed27f8)
pkg/sql/conn_executor_exec.go:3205 +0x14c fp=0x14054de7e10 sp=0x14054de7b90 pc=0x1042beb2c
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine(0x14002ed2008, {0x10839be68, 0x14002ac8000}, 0x14002ed27f8, {0x10f748d08, 0x14004b84f60})
pkg/sql/conn_executor_exec.go:2785 +0x7e4 fp=0x14054de83a0 sp=0x14054de7e10 pc=0x1042bc044
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState(0x14002ed2008, {0x10839ae90, 0x14004440000}, {{0x1083c4340, 0x14003fc4000}, {0x0, 0x0, 0x0}, {0x1400cc3e000, 0x1e8487}, ...}, ...)
pkg/sql/conn_executor_exec.go:1067 +0x32f0 fp=0x14054de9020 sp=0x14054de83a0 pc=0x1042af5d0
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func2({0x10839ae90?, 0x14004440000?})
pkg/sql/conn_executor_exec.go:175 +0x8c fp=0x14054de90d0 sp=0x14054de9020 pc=0x1042ab66c
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling(0x10839ae90?, {0x10839ae90?, 0x14004440000?}, {0x1083c4340?, 0x14003fc4000?}, 0x0?, 0x500000100010000?)
pkg/sql/conn_executor_exec.go:4415 +0x478 fp=0x14054de9290 sp=0x14054de90d0 pc=0x1042c6848
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt(0x14002ed2008, {0x10839ae90, 0x14004440000}, {{0x1083c4340, 0x14003fc4000}, {0x0, 0x0, 0x0}, {0x1400cc3e000, 0x1e8487}, ...}, ...)
pkg/sql/conn_executor_exec.go:174 +0x6c4 fp=0x14054de9540 sp=0x14054de9290 pc=0x1042aaec4
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1({{{0x1083c4340, 0x14003fc4000}, {0x0, 0x0, 0x0}, {0x1400cc3e000, 0x1e8487}, 0x0, 0x0}, 0x228e70a3, ...}, ...)
pkg/sql/conn_executor.go:2378 +0x360 fp=0x14054de9610 sp=0x14054de9540 pc=0x10429a120
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0x14002ed2008)
pkg/sql/conn_executor.go:2383 +0xbc4 fp=0x14054de9b40 sp=0x14054de9610 pc=0x104297de4
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0x14002ed2008, {0x10839be68, 0x14004fb0be0}, 0x101557820?, 0x14009a185a0?, 0x14001720c40?)
pkg/sql/conn_executor.go:2291 +0x1b4 fp=0x14054de9c30 sp=0x14054de9b40 pc=0x104296e84
github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn(0x1400a4164e0?, {0x10839be68?, 0x14004fb0be0?}, {0x14004c1bb00?}, 0x2?, 0x0?)
pkg/sql/conn_executor.go:1067 +0xa0 fp=0x14054de9ce0 sp=0x14054de9c30 pc=0x104292b80
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommands(0x14004b84808, {0x10839be68, 0x14004fb0be0}, {0x0, 0x4, {0x1, {0x10612b2e2, 0x3}, {0x1400ab408b0, 0xf}, ...}, ...}, ...)
pkg/sql/pgwire/conn.go:253 +0x340 fp=0x14054de9ee0 sp=0x14054de9ce0 pc=0x1057552e0
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveImpl.func4()
pkg/sql/pgwire/server.go:1228 +0xc8 fp=0x14054de9fd0 sp=0x14054de9ee0 pc=0x105769188
runtime.goexit({})
src/runtime/asm_arm64.s:1223 +0x4 fp=0x14054de9fd0 sp=0x14054de9fd0 pc=0x100bdd824
created by github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveImpl in goroutine 2854
pkg/sql/pgwire/server.go:1225 +0x498
```

Jira issue: CRDB-57939

Jira issue: CRDB-57940

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.