sql-queries: unoptimize-query-oracle failure from 141581

[mgartner]

Failure from #141581:

CREATE TABLE t (
  a INT NOT NULL,
  b INT NOT NULL,
  c STRING NOT NULL AS (a::string) VIRTUAL,
  d STRING NOT NULL AS (b::string) VIRTUAL,
  PRIMARY KEY (a, b),
  INVERTED INDEX (d gin_trgm_ops)
);

SELECT 1 FROM t AS t1 JOIN t AS t2 ON t1.c = t2.d WHERE t1.c LIKE 'aaa';

Jira issue: CRDB-48643

[blathers-crl]

Hi @mgartner, please add branch-* labels to identify which branch(es) this C-bug affects.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}

[mgartner]

        (XX000) internal error: output cols mismatch: (11) vs (10,11)
        verify.go:82: in VerifyAgainst()
        DETAIL: stack trace:
        pkg/sql/opt/props/verify.go:82: VerifyAgainst()
        pkg/sql/opt/memo/check_expr.go:52: CheckExpr()
        bazel-out/k8-fastbuild/bin/pkg/sql/opt/memo/expr.og.go:25377: AddSelectToGroup()
        pkg/sql/opt/xform/index_scan_builder.go:265: Build()
        pkg/sql/opt/xform/select_funcs.go:1001: func1()
        pkg/sql/opt/xform/scan_index_iter.go:317: ForEachStartingAfter()
        pkg/sql/opt/xform/scan_index_iter.go:209: ForEach()
        pkg/sql/opt/xform/select_funcs.go:902: generateInvertedIndexScansImpl()
        pkg/sql/opt/xform/select_funcs.go:847: GenerateInvertedIndexScans()
        bazel-out/k8-fastbuild/bin/pkg/sql/opt/xform/explorer.og.go:400: exploreSelect()
        bazel-out/k8-fastbuild/bin/pkg/sql/opt/xform/explorer.og.go:26: exploreGroupMember()
        pkg/sql/opt/xform/explorer.go:180: exploreGroup()
        pkg/sql/opt/xform/optimizer.go:559: optimizeGroup()
        pkg/sql/opt/xform/optimizer.go:296: optimizeExpr()
        pkg/sql/opt/xform/optimizer.go:604: optimizeGroupMember()
        pkg/sql/opt/xform/optimizer.go:546: optimizeGroup()
        pkg/sql/opt/xform/optimizer.go:296: optimizeExpr()
        pkg/sql/opt/xform/optimizer.go:604: optimizeGroupMember()
        pkg/sql/opt/xform/optimizer.go:546: optimizeGroup()
        pkg/sql/opt/xform/optimizer.go:296: optimizeExpr()
        pkg/sql/opt/xform/optimizer.go:604: optimizeGroupMember()
        pkg/sql/opt/xform/optimizer.go:546: optimizeGroup()
        pkg/sql/opt/xform/optimizer.go:746: optimizeEnforcer()
        pkg/sql/opt/xform/optimizer.go:698: enforceProps()
        pkg/sql/opt/xform/optimizer.go:589: optimizeGroupMember()
        pkg/sql/opt/xform/optimizer.go:546: optimizeGroup()
        pkg/sql/opt/xform/optimizer.go:266: Optimize()
        pkg/sql/plan_opt.go:862: buildExecMemo()
        pkg/sql/plan_opt.go:260: makeOptimizerPlan()
        pkg/sql/conn_executor_exec.go:3303: makeExecPlan()
        pkg/sql/conn_executor_exec.go:2851: dispatchToExecutionEngine()
        pkg/sql/conn_executor_exec.go:2118: execStmtInOpenStateWithPausablePortal()