SQLite

Ticket Change Details
Login
Overview

Artifact ID: 23cdb6761c7c0cec7ccc8ffe1ad2b96faa6fe54c122796cfb562c27300cbf2a9
Ticket: 3c27b97e319a263a607253b34270f4747ef8fac6
REAL rounding seems to depend on FROM clause
User & Date: dan 2019-05-16 19:02:42
Changes

  1. 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>
    
  2. login: "dan"
  3. mimetype: "text/x-fossil-wiki"
  4. priority changed to: "Immediate"
  5. resolution changed to: "Open"
  6. subsystem changed to: "Unknown"