Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.1.4
-
Fix Version/s: 1.2.0-ALPHA3
-
Component/s: Connection
-
Labels:None
-
Environment:sqlite
Description
The problem is concerned about sqlite driver. Currently in every occurence of "NOW()" in where clause PDO substitutes result of PHP time() function. Here is a cause:
$this->dbh->sqliteCreateFunction('now', 'time', 0);
Unfortunatelly, sqlite expects a datetime value rather then integer timestamp.
In result, every occurence of 'now()' in where clause is treated as '0'.
I have prepared a testcase and patch.
