Thanks. I'll take a look at this today or tomorrow if no one else does it before me. Ma ☺️
On 12 Feb 2017 7:13 PM, "Kacper Gutowski" <mwgam...@gmail.com> wrote: > The sqlite provider seems to silently truncate integer values in results: > > )COPY 5 SQL > DUMPED 2017-02-12 10:13:53 (GMT+1) > db←'sqlite' SQL∆Connect ':memory:' > 'create table a(b)' SQL∆Exec[db] ⍬ > > 'insert into a values(?),(?)' SQL∆Exec[db] 2⋆31 32 > > 'select b from a' SQL∆Select[db] ⍬ > ¯2147483648 > 0 > 'select cast(b as real) from a' SQL∆Select[db] ⍬ > 2147483648 > 4294967296 > > > -k > >
