dolt
dolt copied to clipboard
Weird behavior for datetime literal syntax.
Dolt appears to not parse the date or time literal syntax. It does parse a datetime literal, but the result is... odd.
MySQL:
mysql> select date '2012-12-31';
+-------------------+
| date '2012-12-31' |
+-------------------+
| 2012-12-31 |
+-------------------+
select time '10:11:12';
+-----------------+
| time '10:11:12' |
+-----------------+
| 10:11:12 |
+-----------------+
select timestamp '2012-12-31 11:30:45';
+---------------------------------+
| timestamp '2012-12-31 11:30:45' |
+---------------------------------+
| 2012-12-31 11:30:45 |
+---------------------------------+
Dolt:
select time '10:11:12';
column "time" could not be found in any table in scope
json> select date '2012-12-31';
column "date" could not be found in any table in scope
select timestamp '2012-12-31 11:30:45';
+---------------------+
| 2012-12-31 11:30:45 |
+---------------------+
| 1000 |
+---------------------+