BTW, the following

with xxx(current_date,date) as (
  select '2000-01-01',current_date
  )
  select *,current_date,date from xxx;

outputs:

current_date  date        current_date  date      
------------  ----------  ------------  ----------
2000-01-01    2016-02-10  2016-02-10    2016-02-10

As you can see the user defined current_date is masked by SQLite3's built-in 
name.  (If this expected, at least a warning about using a reserved name would 
be nice.)
To me, however, the user-defined name should mask the built-in one.

Regards.

Reply via email to