cockroachdb / cockroachdb/cockroach

sql: internal error when reading BIT and VARBIT ARRAY

Open
#122,149 3 comments 0 reactions 0 assignees View on GitHub
C-bug P-3 T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Here the steps to reproduce

```
root@localhost:26257/mark> show create ref_data;
table_name | create_statement
-------------+--------------------------------------------------------------
ref_data | CREATE TABLE public.ref_data (
| my_time STRING NULL,
| my_bit_arr BIT[] NULL,
| my_3bit_arr BIT(3)[] NULL,
| my_varbit_arr VARBIT[] NULL,
| my_12varbit_arr VARBIT(12)[] NULL,
| rowid INT8 NOT VISIBLE NOT NULL DEFAULT unique_rowid(),
| CONSTRAINT ref_data_pkey PRIMARY KEY (rowid ASC)
| )
(1 row)

Time: 82ms total (execution 81ms / network 0ms)

root@localhost:26257/mark> select * from ref_data;
my_time | my_bit_arr | my_3bit_arr | my_varbit_arr | my_12varbit_arr
----------+------------+-------------+---------------+------------------
(0 rows)

Time: 2ms total (execution 2ms / network 0ms)

root@localhost:26257/mark> IMPORT INTO ref_data CSV DATA ('nodelocal://1/ref.csv') with delimiter = e'\t';
job_id | status | fraction_completed | rows | index_entries | bytes
---------------------+-----------+--------------------+------+---------------+--------
959148846818951169 | succeeded | 1 | 10 | 0 | 780
(1 row)

Time: 1.632s total (execution 1.632s / network 0.000s)

root@localhost:26257/mark> select * from ref_data;
ERROR: internal error: unexpected error from the vectorized engine: runtime error: slice bounds out of range [22222002211:15]
SQLSTATE: XX000
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:89: func1()
GOROOT/src/runtime/panic.go:914: gopanic()
...
```

where `ref.csv` is:

```
[$ cat ref.csv
](fabio: ~/cockroach-data/extern $ cat ref.csv)
jqgzXg1uwc ARRAY[1,0,0] ARRAY[110,011,000] ARRAY[1,1,1] ARRAY[101100100000,011111001101,110101100011]
6rmMu7tO8b ARRAY[1,0,0] ARRAY[100,111,100] ARRAY[1,0,1] ARRAY[000101101100,111010010111,100110011110]
wTf9yLMMk3 ARRAY[0,1,0] ARRAY[110,111,000] ARRAY[0,1,1] ARRAY[001010100001,011010110000,110010000001]
wKN6DGsmV2 ARRAY[1,1,1] ARRAY[011,001,100] ARRAY[1,0,0] ARRAY[110011011010,010110111110,010010111010]
eIq7TjVdwE ARRAY[0,0,1] ARRAY[101,110,010] ARRAY[0,1,0] ARRAY[110010001010,110011001000,000110110011]
AYx47CDtEW ARRAY[1,0,1] ARRAY[100,100,110] ARRAY[0,0,1] ARRAY[001000010111,110110001001,010000010111]
XrhhRYbAFT ARRAY[1,1,0] ARRAY[111,100,110] ARRAY[1,1,1] ARRAY[001011000111,111001111110,101111110010]
iuz9Ugx0Ko ARRAY[0,0,1] ARRAY[010,111,000] ARRAY[0,1,1] ARRAY[001011010000,100101111110,100010000010]
uHSfE4ADYp ARRAY[0,0,0] ARRAY[011,101,011] ARRAY[0,0,0] ARRAY[110010111000,001011011111,000100111000]
F1HQPSBu3p ARRAY[0,1,1] ARRAY[110,011,111] ARRAY[0,1,1] ARRAY[100011010110,000100100110,011000110101]
```

[slack](https://cockroachlabs.slack.com/archives/CHVV403F0/p1712775339591639)

Jira issue: CRDB-37730

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.