[MDEV-9524] Cannot load from mysql.event when sql_mode is set to PAD_CHAR_TO_FULL_LENGTH Created: 2016-02-05 Updated: 2016-06-21 Resolved: 2016-06-21 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Events |
| Affects Version/s: | 10.0.23, 10.1.11 |
| Fix Version/s: | 10.0.26, 10.1.15 |
| Type: | Bug | Priority: | Major |
| Reporter: | Nirbhay Choubey (Inactive) | Assignee: | Alexander Barkov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | SUSE, upstream | ||
| Issue Links: |
|
||||||||
| Sprint: | 10.0.26 | ||||||||
| Description |
|
Cannot load from mysql.event when sql_mode is set to PAD_CHAR_TO_FULL_LENGTH mysql Ver 15.1 Distrib 10.0.22-MariaDB, for Linux (x86_64) using readline 5.1 Steps to reproduce:
While searching I have found https://bugs.mysql.com/bug.php?id=74947 |
| Comments |
| Comment by Nirbhay Choubey (Inactive) [ 2016-05-09 ] | ||||||||||||||
|
elenst Do you know who should be the right developer for this issue? | ||||||||||||||
| Comment by Elena Stepanova [ 2016-05-09 ] | ||||||||||||||
|
bar, could you please look at it? Feel free to reassign if needed. | ||||||||||||||
| Comment by Alexander Barkov [ 2016-06-20 ] | ||||||||||||||
|
A smaller test case demonstrating the same problem:
The first SHOW EVENTS works fine, the second one fails. | ||||||||||||||
| Comment by Alexander Barkov [ 2016-06-21 ] | ||||||||||||||
|
The same problem is also repeatable with the "HELP" command.
If I set sql_mode to PAD_CHAR_TO_FULL_LENGTH, it stops working:
|