[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
- [Bug-apl] Sqlite provider truncates integers in results,
Kacper Gutowski <=
- Re: [Bug-apl] Sqlite provider truncates integers in results, Elias Mårtenson, 2017/02/12
- Re: [Bug-apl] Sqlite provider truncates integers in results, Elias Mårtenson, 2017/02/14
- Re: [Bug-apl] Sqlite provider truncates integers in results, Kacper Gutowski, 2017/02/15
- Re: [Bug-apl] Sqlite provider truncates integers in results, Elias Mårtenson, 2017/02/15
- Re: [Bug-apl] Sqlite provider truncates integers in results, Juergen Sauermann, 2017/02/15
- Re: [Bug-apl] Sqlite provider truncates integers in results, Elias Mårtenson, 2017/02/15
- Re: [Bug-apl] Sqlite provider truncates integers in results, Juergen Sauermann, 2017/02/15