Overview
Artifact ID: | 23cdb6761c7c0cec7ccc8ffe1ad2b96faa6fe54c122796cfb562c27300cbf2a9 |
---|---|
Ticket: | 3c27b97e319a263a607253b34270f4747ef8fac6
REAL rounding seems to depend on FROM clause |
User & Date: | dan 2019-05-16 19:02:42 |
Changes
- icomment:
Same problem: <verbatim> CREATE TABLE t1(a REAL); INSERT INTO t1 VALUES( 836627109860825358 ); SELECT * FROM t1 WHERE a = CAST(836627109860825358 AS REAL); -- returns 1 row CREATE INDEX i1 ON t1(a); SELECT * FROM t1 WHERE a = CAST(836627109860825358 AS REAL); -- same query now returns 0 rows </verbatim>
- login: "dan"
- mimetype: "text/x-fossil-wiki"
- priority changed to: "Immediate"
- resolution changed to: "Open"
- subsystem changed to: "Unknown"