Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql: panic: unsupported comparison: inet to int[] #40591

Closed
Tracked by #40649
maddyblue opened this issue Sep 9, 2019 · 2 comments
Closed
Tracked by #40649

sql: panic: unsupported comparison: inet to int[] #40591

maddyblue opened this issue Sep 9, 2019 · 2 comments
Assignees
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-sqlsmith

Comments

@maddyblue
Copy link
Contributor

CREATE TABLE IF NOT EXISTS tab_orig AS
	SELECT g AS _int8 FROM generate_series(0, 0) AS g;

WITH
	with_224
		AS (
			SELECT
				*
			FROM
				(VALUES ((SELECT ARRAY[0])))
					AS tab_979 (col_2702)
		)
SELECT
	NULL
FROM
	tab_orig AS tab_982
WHERE
	EXISTS(
		WITH
			with_225
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									array_position(
										ARRAY[
											'326f:1afd:71e3:de51:720c:75fb:6871:d482/123',
											'f452:79d7:3e9b:97cf:b316:90bc:3a62:8007/88',
											'6901:1a4:1d9c:3970:4436:10ae:acd3:ce60/71',
											'87bb:2258:e011:2a64:ee7a:eef4:39de:3e16/85',
											'202.110/5',
											'203.110/20'
										]::INET[],
										(SELECT NULL)
									)
								)
						)
							AS tab_986 (col_2706)
				)
		SELECT
			tab_982._int8
		WHERE
			EXISTS(SELECT NULL)
	);
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).closeWrapper(0xc0008df000, 0x4f50cc0, 0xc000a73180, 0x4230a00, 0xc00043ef20)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:730 +0x330
github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn.func1(0xc0008df000, 0x4f50cc0, 0xc000a73180)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:442 +0x61
panic(0x4230a00, 0xc00043ef20)
	/usr/local/go/src/runtime/panic.go:522 +0x1b5
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*DIPAddr).Compare(0xc0003d4be0, 0xc001af6d80, 0x4fd7700, 0xc001848840, 0xc0018499e0)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/datum.go:1556 +0x197
github.com/cockroachdb/cockroach/pkg/sql/sem/builtins.glob..func189.1(0xc001af6d80, 0xc001bb86e0, 0x2, 0x2, 0x2, 0x2, 0x0, 0x0)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/builtins/builtins.go:2626 +0xf6
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FuncExpr).Eval(0xc0016b8800, 0xc001af6d80, 0x4fd7de0, 0xc0002eb6f0, 0x0, 0x0)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/sem/tree/eval.go:3832 +0xb8
github.com/cockroachdb/cockroach/pkg/sql.(*valuesNode).startExec(0xc001b04870, 0x4f50cc0, 0xc001aead80, 0xc001af6d80, 0xc0008df358, 0x0, 0xc0017f19a0)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/values.go:156 +0x366
github.com/cockroachdb/cockroach/pkg/sql.startExec.func2(0x4568ecc, 0x6, 0x4f531c0, 0xc001b04870, 0xc000b71560, 0xc0017f19b0)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/plan.go:362 +0x55
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal.func1(0xc0008d43c0, 0x4568ecc, 0x6, 0x4f531c0, 0xc001b04870)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:141 +0x5d
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal(0xc0008d43c0, 0x4f531c0, 0xc001b04870, 0x4568ecc, 0x6)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:668 +0x286
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visit(0xc0008d43c0, 0x4f531c0, 0xc001b04870, 0x4575771, 0xb)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:108 +0x8d
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal(0xc0008d43c0, 0x4f51e40, 0xc0012e70b0, 0x4575771, 0xb)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:660 +0x4ea5
github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visit(0xc0008d43c0, 0x4f51e40, 0xc0012e70b0, 0x0, 0x60)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:108 +0x8d
github.com/cockroachdb/cockroach/pkg/sql.walkPlan(...)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/walk.go:72
github.com/cockroachdb/cockroach/pkg/sql.startExec(0x4f50cc0, 0xc001aead80, 0xc001af6d80, 0xc0008df358, 0x4f51e40, 0xc0012e70b0, 0x0, 0x7d98ea0)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/plan.go:365 +0x286
github.com/cockroachdb/cockroach/pkg/sql.(*planNodeToRowSource).Start(0xc001572f00, 0x4f50cc0, 0xc001aead80, 0x7d98ea0, 0x3f4e5c0)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/plan_node_to_row_source.go:117 +0xd6
github.com/cockroachdb/cockroach/pkg/sql/distsqlrun.(*ProcessorBase).Run(0xc001572f00, 0x4f50cc0, 0xc001aead80)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/processors.go:792 +0x52
github.com/cockroachdb/cockroach/pkg/sql/distsqlrun.(*Flow).Run(0xc001b098c0, 0x4f50d80, 0xc001906cc0, 0x46f1078, 0x0, 0x0)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/flow.go:584 +0x1ec
github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run(0xc000456000, 0xc001941f80, 0xc0018dee10, 0xc0017f3018, 0xc001b3b8c0, 0xc001af6900, 0x0, 0x0)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:337 +0x381
github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).planAndRunSubquery(0xc000456000, 0x4f50cc0, 0xc001a5a800, 0x1, 0xc0012e7110, 0x3, 0x1, 0x4f51e40, 0xc0012e70b0, 0x0, ...)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:880 +0x7c8
github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunSubqueries(0xc000456000, 0x4f50cc0, 0xc001a5a800, 0xc0008df358, 0xc0017f32d8, 0xc000c09000, 0x9, 0x9, 0xc001b3a840, 0xc0008df101, ...)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:784 +0x1ba
github.com/cockroachdb/cockroach/pkg/sql.(*applyJoinNode).runRightSidePlan(0xc000c09800, 0x4f50cc0, 0xc001a5a800, 0xc001aaa480, 0xc0008df358, 0xc00152b740, 0x0, 0x0)
	/home/mjibson/go/src/github.com/cockroachdb/cockroach/pkg/sql/apply_join.go:310 +0x26b
github.com/cockroachdb/cockroach/pkg/sql.(*applyJoinNode).Next(0xc000c09800, 0x4f50cc0, 0xc001a5a800, 0xc001aaa480, 0xc0008df358, 0x10, 0x203000, 0x203000)
@maddyblue maddyblue added C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-sqlsmith labels Sep 9, 2019
@maddyblue
Copy link
Contributor Author

Real similar error message as #40444 but totally different stack trace, so maybe a new bug?

@maddyblue
Copy link
Contributor Author

This doesn't repro anymore.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-sqlsmith
Projects
None yet
Development

No branches or pull requests

3 participants