Skip to content

panic when importing into a table with virtual computed columns #66694

@mgartner

Description

@mgartner

Describe the problem

Importing a table with a virtual computed column causes a panic.

To Reproduce

IMPORT TABLE addresses (
    first STRING,
    last STRING,
    street STRING,
    city STRING,
    state STRING,
    zip STRING,
    first_lower STRING AS (lower(first)) VIRTUAL
) CSV DATA ('https://people.sc.fsu.edu/~jburkardt/data/csv/addresses.csv');
panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x0 pc=0x707b3cb]

goroutine 3479 [running]:
github.com/cockroachdb/cockroach/pkg/sql.NewTableDesc(0x952fd20, 0xc001f7eb38, 0x0, 0x964adc0, 0xc000ca41e8, 0xc00152c000, 0xc000874f00, 0x1d00000032, 0xc000000035, 0x0, ...)
        /go/src/github.com/cockroachdb/cockroach/pkg/sql/create_table.go:1807 +0x578b
github.com/cockroachdb/cockroach/pkg/ccl/importccl.MakeSimpleTableDescriptor(0x952fd20, 0xc001f7eb38, 0xc000747ef8, 0xc00152c000, 0xc000874f00, 0x1d00000032, 0xc000000035, 0x0, 0xc0010d5380, 0x0, ...)
        /go/src/github.com/cockroachdb/cockroach/pkg/ccl/importccl/import_table_creation.go:158 +0xa85
github.com/cockroachdb/cockroach/pkg/ccl/importccl.importPlanHook.func1(0x9510260, 0xc002d2edc0, 0x0, 0x0, 0x0, 0xc002a08480, 0x0, 0x0)
        /go/src/github.com/cockroachdb/cockroach/pkg/ccl/importccl/import_stmt.go:853 +0x21e8
github.com/cockroachdb/cockroach/pkg/sql.(*hookFnNode).startExec.func1(0xc000e1f200, 0x9510260, 0xc002d2edc0, 0xc002822000, 0xc000747dd8)
        /go/src/github.com/cockroachdb/cockroach/pkg/sql/planhook.go:145 +0x7d
created by github.com/cockroachdb/cockroach/pkg/sql.(*hookFnNode).startExec
        /go/src/github.com/cockroachdb/cockroach/pkg/sql/planhook.go:144 +0xcc

Environment:

Build Tag:        v21.1.1
Build Time:       2021/05/24 15:00:00
Distribution:     CCL
Platform:         darwin amd64 (x86_64-apple-darwin19)
Go Version:       go1.15.11
C Compiler:       Clang 10.0.0
Build Commit ID:  f6630b3f524f3a5e52b330220037af01369b1ff2
Build Type:       release
(use 'cockroach-v21.1.1 version --build-tag' to display only the build tag)

Metadata

Metadata

Assignees

Labels

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-sql-queriesSQL Queries Team

Type

No type
No fields configured for issues without a type.

Projects

Status
Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions