Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL), 11.4
-
None
Description
I run a MariaDB server with lower-case-table-names=0.
This script returns an error:
CREATE OR REPLACE DATABASE MYSQL; |
CREATE OR REPLACE TABLE MYSQL.t1 (a INT); |
CREATE TRIGGER MYSQL.tr1 AFTER INSERT ON t1 FOR EACH ROW DELETE FROM t1; |
ERROR 1465 (HY000): Triggers can not be created on system tables
|
This looks wrong, as the database `MYSQL` (with upper case letters) is not system.
Only `mysql` (with lower case letters) is system.
Attachments
Issue Links
- relates to
-
MDEV-31340 Remove MY_COLLATION_HANDLER::strcasecmp()
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Link |
This issue relates to |
Fix Version/s | 11.4.2 [ 29633 ] | |
Fix Version/s | 11.5.1 [ 29634 ] | |
Fix Version/s | 10.5.26 [ 29832 ] | |
Fix Version/s | 10.6.19 [ 29833 ] | |
Fix Version/s | 10.11.9 [ 29834 ] | |
Fix Version/s | 11.1.6 [ 29835 ] | |
Fix Version/s | 11.2.5 [ 29836 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Fix Version/s | 11.4 [ 29301 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Fix Version/s | 11.4.3 [ 29837 ] | |
Fix Version/s | 11.5.2 [ 29838 ] | |
Fix Version/s | 11.4.2 [ 29633 ] | |
Fix Version/s | 11.5.1 [ 29634 ] |