Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
-
Not for Release Notes
Description
The one-line test case is also attached as a file, in case JIRA corrupts the string.
|
Oracle |
SELECT TO_DATE('15 4月 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=JAPANESE') AS x FROM DUAL; |
|
|
X
|
15-APR-24
|
|
bb-12.3-MDEV-19683-to_date f45636ea81a5a02444833e993e47c262ed52f384 |
MariaDB [test]> SELECT TO_DATE('15 4月 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=JAPANESE') AS x FROM DUAL; |
+------+ |
| x |
|
+------+ |
| NULL | |
+------+ |
1 row in set, 1 warning (0.001 sec) |
|
|
MariaDB [test]> show warnings;
|
+---------+------+---------------------------------------------------------------+ |
| Level | Code | Message | |
+---------+------+---------------------------------------------------------------+ |
| Warning | 1411 | Incorrect datetime value: '15 4月 2024' for function to_date | |
+---------+------+---------------------------------------------------------------+ |
1 row in set (0.000 sec) |
I can't see a difference between the value in the string and the one in sql/sql_locale.cc, so I guess something else is wrong.
Attachments
Issue Links
- is caused by
-
MDEV-19683 Add support for Oracle TO_DATE()
-
- In Testing
-