sqlite CURRENT_DATE default gets inserted as a string

[tonyeung]

Simple insert with a current_date default value in the pragma makes lithium generate this sql command below:

INSERT INTO "RecordHeaders" ("entryDate", "version","userID", "providerID") 
VALUES ('CURRENT_DATE', '1', '1', 'abc123');

the pragma:

CREATE TABLE "RecordHeaders" (
    "id" INTEGER PRIMARY KEY  NOT NULL ,
    "entryDate" DATETIME NOT NULL  DEFAULT (CURRENT_DATE) ,
    "version" INTEGER NOT NULL  DEFAULT (1) ,
    "providerID" TEXT NOT NULL, 
    "userID" INTEGER NOT NULL 
)

[greut]

Please show us your PHP code or try writing a test that shows this. thanks!

[jails]

This issue seems to be similar to #28. Maybe we can kill two birds with one stone.

[nateabele]

Fixed in #492. See there for new syntax.