Re: [sqlite] PATCH: compound query column naming and resolving (Ticket #2822)

[Robert Wishlaw]

On Dec 8, 2007 11:49 PM, Trey Mack <[EMAIL PROTECTED]> wrote:

> > Can you please tell me what
> > other databases do with this:
> >
> >    CREATE TABLE t1(a,b,c);
> >    INSERT INTO t1 VALUES(1,2,4);
> >    SELECT a+b AS c FROM t1 WHERE c==4;
>
> SQL Server returns a 3.
> ORACLE 9 returns a 3.
>
>
IBM DB2 9.5

INSERT INTO t1 VALUES(1,2,4);
SELECT a+b AS c FROM t1 WHERE c=4;

returns

C
--------------------
                   3
                   3
                   3
                   3
   4 record(s) selected

Robert Wishlaw