Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
Description
The one-line test case is also attached as a file, in case JIRA corrupts the string.
|
Oracle |
SELECT TO_DATE('15 ابريل 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=EGYPTIAN') AS x FROM DUAL; |
|
|
X
|
15-APR-24
|
|
bb-12.3-MDEV-19683-to_date f45636ea81a5a02444833e993e47c262ed52f384 |
MariaDB [test]> SELECT TO_DATE('15 ابريل 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=EGYPTIAN') 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 ابريل 2024' for function to_date | |
+---------+------+---------------------------------------------------------------------+ |
1 row in set (0.000 sec) |
I have no idea what would be the right string for MariaDB. Also, maybe it somehow gets corrupt between the client and the server, although it looks the same to me in the warning.
Attachments
Issue Links
- is caused by
-
MDEV-19683 Add support for Oracle TO_DATE()
-
- In Testing
-
- relates to
-
MDEV-38583 TO_DATE: NLS_DATE_LANGUAGE=URDU does not parse values which work in Oracle
-
- Open
-