sqlite-parquet-vtable icon indicating copy to clipboard operation
sqlite-parquet-vtable copied to clipboard

ubuntu 18.04 skips first row under some cases

Open cldellow opened this issue 7 years ago • 2 comments

When testing on Ubuntu 18.04 with sqlite 3.22, this query fails:

SELECT rowid FROM nulls WHERE (bool_0 IS 1)

We expect rows 1, 3, 5, 7, 9 but only get 3, 5, 7, 9.

cldellow avatar Jul 04 '18 23:07 cldellow

Hm, interestingly, this does not fail when added as a test case.

That made me think it was something specific to the python test harness, but now the same query is passing under that harness.

Similarly, if I cause it to generate another test case that fails in a similar way:

SELECT rowid FROM nulls WHERE (binary_9 IS NOT X'2C2C2C2C2C') LIMIT 1

it does not fail as a test case, and no longer fails under python. Maybe some scenario where I'm not initializing memory and get non deterministic results? Will think a bit.

cldellow avatar Jul 05 '18 00:07 cldellow

While it's overwhelmingly likely that this issue is in my code, it's also unclear whether 18.04 is a supported target for arrow/parquet-cpp yet -- http://mail-archives.apache.org/mod_mbox/arrow-dev/201806.mbox/%[email protected]%3E talks about adding it to their build matrix.

Going to ignore this for a few months.

cldellow avatar Jul 05 '18 00:07 cldellow