Some basic datatypes and functions in oracle compatibility mode do not work
(MDEV-19162)
|
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Technical task | Priority: | Major |
| Reporter: | Faisal Saeed (Inactive) | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | Compatibility, Oracle | ||
| Description |
|
The LEFT/RIGHT OUTER JOIN oracle old syntax (+) is not supported in SQL_MODE=ORACLE. Many of the old ORACLE application still use this syntax and it's very difficult to modify the queries. https://www.techonthenet.com/oracle/joins.php Refer to the old syntax for LEFT and RIGHT outer joins in the link above. |
[MDEV-20650]