Skip to content

opt: hang / infinite recursion (?) in ConstructInnerJoin #28818

Closed
#28848
Closed
opt: hang / infinite recursion (?) in ConstructInnerJoin#28818
#28848
Assignees
andy-kimball
Labels
A-sql-optimizerSQL logical planning and optimizations.C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
Milestone
2.1
@jordanlewis

Description

@jordanlewis
jordanlewis
opened on Aug 19, 2018
SELECT ref_0.details AS c0, ref_2.usesuper AS c1, subq_0.c4 AS c2, ref_2.usesuper AS c3, subq_0.c3 AS c4, ref_2.usecreatedb AS c5, (SELECT pg_catalog.min(tgargs) FROM pg_catalog.pg_trigger) AS c6, ref_0.signature AS c7, subq_1.c0 AS c8, ref_0.category AS c9, ref_2.usename AS c10, ref_0.category AS c11, CASE WHEN ((((SELECT pg_catalog.max(duration) FROM crdb_internal.session_trace) < CAST(NULL AS INTERVAL)) AND ((CAST(NULL AS TIMESTAMP) IS NOT DISTINCT FROM ref_2.valuntil) AND (true))) AND (pg_catalog.array_cat(CAST((SELECT pg_catalog.array_agg(duration) FROM crdb_internal.session_trace) AS INTERVAL[]), CAST(CAST(NULL AS INTERVAL[]) AS INTERVAL[])) != CAST(NULLIF(CAST(NULL AS INTERVAL[]), (SELECT pg_catalog.array_agg(duration) FROM crdb_internal.session_trace)) AS INTERVAL[]))) AND ((SELECT pg_catalog.sqrdiff(zone_id) FROM crdb_internal.zones) = pg_catalog.random()) THEN ref_0.category ELSE ref_0.category END AS c12, ref_0.category AS c13, (SELECT platform FROM crdb_internal.kv_node_status LIMIT 1 OFFSET 1) AS c14, CAST(NULLIF(ref_0.details, pg_catalog.quote_ident(CAST(subq_0.c2 AS TEXT))) AS TEXT) AS c15, subq_1.c1 AS c16, ref_2.usesysid AS c17, subq_0.c2 AS c18 FROM crdb_internal.builtin_functions AS ref_0 INNER JOIN (SELECT ref_1.client_address AS c0, ref_1.oldest_query_start AS c1, ref_1.session_id AS c2, ref_1.session_start AS c3, ref_1.active_queries AS c4, ref_1.node_id AS c5 FROM crdb_internal.node_sessions AS ref_1 WHERE (SELECT pg_catalog.sum(duration) FROM crdb_internal.session_trace) = (SELECT duration FROM crdb_internal.session_trace LIMIT 1 OFFSET 5) LIMIT 105) AS subq_0 ON (((true) OR ((CAST(NULL AS TIME) IS NOT DISTINCT FROM CAST(NULL AS TIME)) OR (ref_0.function IS NULL))) AND (CAST(NULL AS INET[]) != CAST(NULL AS INET[]))) INNER JOIN pg_catalog.pg_user AS ref_2 RIGHT JOIN (SELECT ref_3.client_address AS c0, ref_3.alloc_bytes AS c1 FROM crdb_internal.cluster_sessions AS ref_3 WHERE ref_3.client_address IS NOT NULL LIMIT 97) AS subq_1 ON (ref_2.passwd = subq_1.c0) ON ((SELECT client_addr FROM pg_catalog.pg_stat_activity LIMIT 1 OFFSET 14) <= (SELECT pg_catalog.min(client_addr) FROM pg_catalog.pg_stat_activity)) WHERE EXISTS (SELECT ref_2.usesysid AS c0 FROM pg_catalog.pg_user AS ref_4 LEFT JOIN crdb_internal.kv_node_status AS ref_5 ON ((SELECT high_water_timestamp FROM crdb_internal.jobs LIMIT 1 OFFSET 16) IS NOT DISTINCT FROM (SELECT pg_catalog.sum(mod_time_logical) FROM crdb_internal.tables)) INNER JOIN pg_catalog.pg_extension AS ref_6 ON (ref_4.usebypassrls = ref_6.extrelocatable) RIGHT JOIN pg_catalog.pg_foreign_server AS ref_7 INNER JOIN information_schema.enabled_roles AS ref_8 ON ((SELECT enumsortorder FROM pg_catalog.pg_enum LIMIT 1 OFFSET 2) >= CAST(NULL AS INT8)) INNER JOIN pg_catalog.pg_attrdef AS ref_9 INNER JOIN pg_catalog.pg_views AS ref_10 ON (ref_10.viewowner !~* ref_0.details) ON ((ref_2.valuntil <= CAST(NULL AS TIMESTAMP WITH TIME ZONE)) OR ((SELECT client_addr FROM pg_catalog.pg_stat_activity LIMIT 1 OFFSET 5) < (SELECT pg_catalog.min(client_addr) FROM pg_catalog.pg_stat_activity))) INNER JOIN crdb_internal.tables AS ref_11 ON (ref_11.sc_lease_expiration_time <= (SELECT pg_catalog.min(backend_start) FROM pg_catalog.pg_stat_activity)) INNER JOIN information_schema.column_privileges AS ref_12 ON (ref_10.definition = ref_12.grantor) INNER JOIN information_schema.referential_constraints AS ref_13 ON (subq_1.c0 IS NULL) ON ((ref_11.database_name = ref_5.platform) AND ((SELECT client_addr FROM pg_catalog.pg_stat_activity LIMIT 1 OFFSET 2) < (SELECT pg_catalog.max(client_addr) FROM pg_catalog.pg_stat_activity))) WHERE CAST(NULLIF(CASE WHEN EXISTS (SELECT ref_11.sc_lease_node_id AS c0, (SELECT privilege_type FROM information_schema.table_privileges LIMIT 1 OFFSET 1) AS c1, ref_12.column_name AS c2, ref_8.role_name AS c3, ref_0.details AS c4, (SELECT pg_catalog.min(ev_type) FROM pg_catalog.pg_rewrite) AS c5, ref_0.signature AS c6, subq_0.c3 AS c7, ref_9.adnum AS c8, ref_2.passwd AS c9, 16 AS c10, ref_8.role_name AS c11, ref_0.category AS c12, ref_2.userepl AS c13, 62 AS c14, 5 AS c15, subq_1.c0 AS c16, subq_1.c1 AS c17, ref_10.definition AS c18, ref_14.objoid AS c19, ref_7.srvversion AS c20 FROM pg_catalog.pg_shseclabel AS ref_14 WHERE CAST(NULL AS ()) = CAST(NULL AS ())) THEN CAST(NULL AS TIME[]) ELSE CAST(NULL AS TIME[]) END, CAST(NULLIF(CAST(NULL AS TIME[]), CAST(COALESCE(CAST(NULL AS TIME[]), CAST(NULL AS TIME[])) AS TIME[])) AS TIME[])) AS TIME[]) IS NOT DISTINCT FROM CASE WHEN (CAST(NULL AS DATE) IS DISTINCT FROM ref_4.valuntil) AND (((ref_2.usecreatedb <= ref_2.usecreatedb) AND (((ref_12.privilege_type IS NOT NULL) OR (CAST(NULL AS TIME) IS DISTINCT FROM CAST(NULL AS TIME))) OR ((CAST(NULL AS INTERVAL[]) IS NOT DISTINCT FROM CAST(NULL AS INTERVAL[])) OR ((CAST(NULL AS DATE) IS NOT DISTINCT FROM CAST(NULL AS DATE)) AND (ref_10.definition IS NOT NULL))))) OR ((SELECT rows_avg FROM crdb_internal.node_statement_statistics LIMIT 1 OFFSET 65) < ref_5.node_id)) THEN CAST(NULL AS TIME[]) ELSE CAST(NULL AS TIME[]) END LIMIT 116)

This produces an infinite hang, as far as I can tell - perhaps it terminates eventually but I'm not sure.

The partial stack trace looks like this:

goroutine 105 [runnable]:
github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*listStorage).intern(0xc4265c8a68, 0xc42752e000, 0x37bb, 0x3800, 0x90156c8)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/memo/list_storage.go:109 +0xa6
github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*Memo).InternList(0xc4265c8960, 0xc42752e000, 0x37bb, 0x3800, 0x4014949)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/memo/memo.go:333 +0x51
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*ListBuilder).BuildList(0xc42ecc0980, 0xc42872207c)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/list_builder.go:70 +0x51
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*CustomFuncs).ConcatFilters(0xc425383588, 0x9e00007017, 0xc42ecc0d58)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/custom_funcs.go:563 +0x34b
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructSelect(0xc425383578, 0x9e00007018, 0x9e)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:379 +0x3afb
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00007018, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1610 +0x7b8
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600007018, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00007016, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600007016, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00007014, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600007014, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00007012, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600007012, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00007010, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600007010, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b0000700e, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa60000700e, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b0000700c, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa60000700c, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b0000700a, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa60000700a, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00007008, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600007008, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00007006, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600007006, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00007004, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600007004, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00007002, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600007002, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00007000, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600007000, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006ffe, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006ffe, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006ffc, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006ffc, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006ffa, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006ffa, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006ff8, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006ff8, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006ff6, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006ff6, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006ff4, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006ff4, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006ff2, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006ff2, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006ff0, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006ff0, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fee, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fee, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fec, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fec, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fea, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fea, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fe8, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fe8, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fe6, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fe6, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fe4, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fe4, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fe2, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fe2, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fe0, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fe0, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fde, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fde, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fdc, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fdc, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fda, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fda, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fd8, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fd8, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fd6, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fd6, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fd4, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fd4, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fd2, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fd2, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fd0, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fd0, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fce, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fce, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fcc, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fcc, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fca, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fca, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fc8, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fc8, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fc6, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fc6, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fc4, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fc4, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fc2, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fc2, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fc0, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fc0, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fbe, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fbe, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0x4b00006fbc, 0x4f0000009e, 0x7dcaf00)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1609 +0x900
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructInnerJoin(0xc425383578, 0xa600006fbc, 0x4f, 0x1)
        /Users/jordan/go/src/github.com/cockroachdb/cockroach/pkg/sql/opt/norm/factory.og.go:1319 +0x3a9f

Metadata

Metadata

Assignees

Labels

A-sql-optimizerSQL logical planning and optimizations.C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions