ubuntu 18.04 skips first row under some cases
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.
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.
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.