Re: [Bug-apl] Sqlite provider truncates integers in results

[Elias Mårtenson]

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" <address@hidden> 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