Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
In Oracle, concatenation has the same priority with + (and lower than *).
SELECT -1+1||1 FROM DUAL /* (-1+1)||'1' */; |
01
|
SELECT -1||0+1 FROM DUAL /* (-1||0)+1 */; |
-9
|
SELECT 1*1||-1 FROM DUAL /* (1*1)||-1 */; |
1-1
|
SELECT 1||1*-1 FROM DUAL /* 1||(1*-1) */; |
1-1
|
In MariaDB, the concatenation operator || (with PIPES_AS_CONCAT enables) has higher priority over + and * and bit shift. This gives difference results in Oracle compatibility mode:
SET sql_mode=ORACLE; |
SELECT -1+1||1 FROM DUAL /* (-1+1)||'1' */; |
10
|
SET sql_mode=ORACLE; |
SELECT -1||0+1 FROM DUAL /* (-1||0)+1 */; |
-9
|
SET sql_mode=ORACLE; |
SELECT 1*1||-1 FROM DUAL /* (1*1)||-1 */; |
1
|
SET sql_mode=ORACLE; |
SELECT 1||1*-1 FROM DUAL /* 1||(1*-1) */; |
-11
|
It should be fixed to produce Oracle compatible results when sql_mode=ORACLE is set.
Attachments
Issue Links
- blocks
-
-
- Open
-
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue blocks MDEV-16156 [ MDEV-16156 ] |
| issue.field.resolutiondate | 2018-05-16 13:24:11.0 | 2018-05-16 13:24:11.816 |
| Fix Version/s | 10.3.7 [ 23005 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Link |
This issue relates to |
| Workflow | MariaDB v3 [ 87270 ] | MariaDB v4 [ 154369 ] |