Issue with "T" when using str_to_date

[kylebrandt]

When there is a literal T null is returned.

$ mysql --host=127.0.0.1 --port=3306 --user=root mydb --execute="select str_to_date('2025-02-03T3:00:00','%Y-%m-%dT%H:%i:%s') as ts;"
+------+
| ts   |
+------+
| NULL |
+------+

$ mysql --host=127.0.0.1 --port=3306 --user=root mydb --execute="select str_to_date('2025-02-03-3:00:00','%Y-%m-%d-%H:%i:%s') as ts;"
+---------------------+
| ts                  |
+---------------------+
| 2025-02-03 03:00:00 |
+---------------------+

[kylebrandt]

(Also, when I go over the sql.Row the interface{} is a string (with the working one), thought it would be a time.Time?

[jycor]

Hey @kylebrandt , thanks for reporting this issue. I moved it to dolt for more visibility.
I can reproduce the bug and can confirm it does not alilgn with MySQL behavior.
We'll start on a fix for this ASAP!

[jycor]

Hey @kylebrandt , the fix for this has been merged to GMS and is making its way to dolt main.
Expect a dolt release with the fix later this week.