dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Weird behavior for datetime literal syntax.

Open nicktobey opened this issue 8 months ago • 0 comments

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                |
+---------------------+

nicktobey avatar Dec 20 '23 19:12 nicktobey