sqlite-parquet-vtable/tests/templates/103-double-rowid-and-field-...

select printf('%.2f', double_6) from nulls1 where rowid = 1 and double_6 <> '100'
99.00
Make rowid start from 1, not 0 Unclear whether this is strictly required, but I'm going to start using SQLite as an oracle, and it'll be simpler if our rowids match theirs. 2018-03-18 21:03:46 +00:00			`select printf('%.2f', double_6) from nulls1 where rowid = 1 and double_6 <> '100'`
More tests cases to deal with affinity I'm not sure how these manifest - whether SQLite retypes them based on column affinity before we see them, or whether they're provided as is. 2018-03-11 23:18:44 +00:00			`99.00`