Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.3, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
Description
MariaDB [test]> set sql_mode = 'NO_ENGINE_SUBSTITUTION';
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [test]> set character_set_connection=utf32;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [test]> set sql_mode = 'NO_ENGINE_SUBSTITUTION';
|
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NO_ENGINE_SUBSTITUTION'
|
Attachments
Issue Links
- relates to
-
MDEV-7635 update defaults and simplify mysqld config parameters
-
- Closed
-
- links to
Activity
| Affects Version/s | 5.5 [ 15800 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Assignee | Alexander Barkov [ bar ] | |
| Labels | upstream |
bar Based on our discussion, I have committed a fix for this issue.
http://lists.askmonty.org/pipermail/commits/2017-January/010405.html
Can you review it please?
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Assignee | Alexander Barkov [ bar ] | Nirbhay Choubey [ nirbhay_c ] |
| Assignee | Nirbhay Choubey [ nirbhay_c ] | Alexander Barkov [ bar ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Alexander Barkov [ bar ] | Nirbhay Choubey [ nirbhay_c ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | Confirmed [ 10101 ] |
http://lists.askmonty.org/pipermail/commits/2017-January/010414.html is OK to push.
One small thing: Please move the ucs2 test from ctype_ucs2_def.test to ctype_ucs.test.
| Fix Version/s | 5.5.55 [ 22311 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Confirmed [ 10101 ] | Closed [ 6 ] |
| Remote Link | This issue links to "Github commit (Web Link)" [ 27906 ] |
| Fix Version/s | 10.0.29 [ 22312 ] | |
| Fix Version/s | 10.1.21 [ 22113 ] | |
| Fix Version/s | 10.2.4 [ 22116 ] |
| Workflow | MariaDB v3 [ 79023 ] | MariaDB v4 [ 151456 ] |
Same for utf16, utf16le, ucs2.
I expect it has something to do with the fact that they can't be used as a client character set, but I'll leave it to the character set expert bar to provide a proper explanation (or to confirm it's a bug, if it is).