Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

[Clark Christensen]

----- Original Message ----
From: [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Wednesday, November 02, 2005 07:36:58
Subject: Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

Consider the following SQL:

   CREATE TABLE t1(a INTEGER, b REAL);
   INSERT INTO t1 VALUES(5,5);
   SELECT a/2, b/2 FROM t1;

D. Richard Hipp <[EMAIL PROTECTED]>
 ---
 
Connected to:
 Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
 With the Partitioning option
 JServer Release 8.1.6.0.0 - Production
 
 SQL> create table t1 (a integer, b real);
 
 Table created.
 
 SQL> insert into t1 values (5,5);
 
 1 row created.
 
 SQL> select a/2, b/2 from t1;
 
        A/2        B/2
 ---------- ----------
        2.5        2.5
 
 SQL>