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.