/ Ticket Change Details
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference
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. Change icomment to:
    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. Change login to "dan"
  3. Change mimetype to "text/x-fossil-wiki"
  4. Change priority to "Immediate"
  5. Change resolution to "Open"
  6. Change subsystem to "Unknown"