panic: runtime error: index out of range [375] with length 0

[aaronmlee]

steps:

1. create a table csvq 'CREATE TABLE IF NOT EXISTS common_record (day, sleep_hrs_x, sleep_hrs_y, sleep_hrs_z);'
2. Try to select into table from an existing CSV csvq 'REPLACE INTO common_record (day, sleep_hrs_x) USING (day) select day, total_sleep_duration from x_sleep'

note, day is a string date field.

results:

panic: runtime error: index out of range [375] with length 0

goroutine 67 [running]: github.com/mithrandie/csvq/lib/query.(View).replace.func2(0x177) github.com/mithrandie/csvq/lib/query/view.go:2231 +0x1a0 github.com/mithrandie/csvq/lib/query.(GoroutineTaskManager).run(0x140001f1880, {0x10338d618, 0x140001f1740}, 0x14000ecac00, 0x0?) github.com/mithrandie/csvq/lib/query/goroutine_manager.go:156 +0xfc created by github.com/mithrandie/csvq/lib/query.(*GoroutineTaskManager).Run github.com/mithrandie/csvq/lib/query/goroutine_manager.go:171 +0xbc panic: runtime error: index out of range [750] with length 0

goroutine 68 [running]: github.com/mithrandie/csvq/lib/query.(View).replace.func2(0x2ee) github.com/mithrandie/csvq/lib/query/view.go:2231 +0x1a0 github.com/mithrandie/csvq/lib/query.(GoroutineTaskManager).run(0x140001f1880, {0x10338d618, 0x140001f1740}, 0x14000ecac00, 0x0?) github.com/mithrandie/csvq/lib/query/goroutine_manager.go:156 +0xfc created by github.com/mithrandie/csvq/lib/query.(*GoroutineTaskManager).Run github.com/mithrandie/csvq/lib/query/goroutine_manager.go:171 +0xbc

found on Monterey 12.4 M1

[ondohotola]

Would be helpful if you included the command to create and fill x_sleep.csv so one can try to reproduce, even though it seems that it has been fixed.

On 30/06/2022 05:17, Aaron Lee wrote:

steps:

1. create a table |csvq 'CREATE TABLE IF NOT EXISTS common_record (day, sleep_hrs_x, sleep_hrs_y, sleep_hrs_z);'|
2. Try to select into table from an existing CSV |csvq 'REPLACE INTO common_record (day, sleep_hrs_x) USING (day) select day, total_sleep_duration from x_sleep'|

note, |day| is a string date field.

results:

panic: runtime error: index out of range [375] with length 0 [...]-- Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist @.** / | Telephone: +264 81 124 6733 (cell) PO Box 8421 Bachbrecht \ / If this email is signed with GPG/PGP 10007, Namibia ;____/ Sect 20 of Act No. 4 of 2019 may apply

[mithrandie]

This bug has been fixed in Release v1.17.6.