Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.6.2, 7.2.6
-
Untriaged
-
0
-
Yes
Description
SELECT d1.c21 FROM shellTest d1 JOIN ( SELECT d2.c11 FROM shellTest d2 JOIN ( SELECT d3.c11 FROM shellTest AS d3 WHERE d3.type = "left" AND d3.c11 < 3) AS d10 USE NL ON d2.c11 = d10.c11 WHERE d2.type = "left" AND d2.c11 = 1) AS final USE NL ON d1.c21 = final.c11 WHERE d1.type = "right"
|
2024-06-17T13:14:32.383 Q S panic: runtime error: invalid memory address or nil pointer dereference
|
2024-06-17T13:14:32.383 Q S request text: <ud>SELECT d1.c21 FROM shellTest d1 JOIN ( SELECT d2.c11 FROM shellTest d2 JOIN ( SELECT d3.c11 FROM shellTest AS d3 WHERE d3.type = "left" AND d3.c11 < 3) AS d10 USE NL ON d2.c11 = d10.c11 WHERE d2.type = "left" AND d2.c11 = 1) AS final USE NL ON d1.c21 = final.c11 WHERE d1.type = "right";</ud>
|
2024-06-17T13:14:32.383 Q S query context: <ud></ud>
|
2024-06-17T13:14:32.383 Q S stack: goroutine 399 [running]:
|
github.com/couchbase/query/server.(*Server).serviceRequest.func1()
|
/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/server/server.go:1286 +0x8c
|
panic({0x2ed08c0?, 0x52716c0?})
|
/home/couchbase/.cbdepscache/exploded/x86_64/go-1.22.2/go/src/runtime/panic.go:770 +0x132
|
github.com/couchbase/query/algebra.(*SubqOptimHints).Copy(...)
|
/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/algebra/hints.go:2349
|
github.com/couchbase/query/algebra.(*OptimHints).Copy(0xc000bfdb00)
|
/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/algebra/hints.go:143 +0x1e8
|
github.com/couchbase/query/planner.BuildPrepared({0x3ccbbc0, 0xc0001b0d90}, {0x3d4cc40?, 0xc0000524b0?}, {0x3d4caa0?, 0xc0004e9e60?}, {0x3244102?, 0x2f87aa0?}, 0x72?, 0x1, ...)
|
/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/planner/build_prepared.go:29 +0xec
|
Attachments
Issue Links
- is caused by
-
MB-54041 [BP to 7.2.0 MB-53601] - Hash join should not be allowed under the inner of a nested-loop join
- Closed