bug-apl
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Bug-apl] Sqlite provider truncates integers in results


From: Kacper Gutowski
Subject: [Bug-apl] Sqlite provider truncates integers in results
Date: Sun, 12 Feb 2017 12:13:22 +0100

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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]