Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.19, 10.0(EOL), 10.1(EOL)
-
10.0.22
Description
MariaDB [test]> CREATE TABLE `market_deductions` (
|
-> `event_id` bigint(20) unsigned NOT NULL DEFAULT '0',
|
-> `market_id` bigint(20) unsigned NOT NULL DEFAULT '0',
|
-> PRIMARY KEY (`event_id`,`market_id`)
|
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
|
Query OK, 0 rows affected (0.01 sec)
|
|
|
MariaDB [test]> ALTER TABLE market_deductions ADD PRIMARY KEY IF NOT EXISTS event_id (event_id,market_id);
|
ERROR 1068 (42000): Multiple primary key defined
|
Seems IF NOT EXISTS is not really checked.
Haven't checked if 10.0.22 has fixed this as part of MDEV-8212
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Labels | alter |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Assignee | Alexey Botchkov [ holyfoot ] | |
| Description |
{noformat} MariaDB [test]> CREATE TABLE `market_deductions` ( -> `event_id` bigint(20) unsigned NOT NULL DEFAULT '0', -> `market_id` bigint(20) unsigned NOT NULL DEFAULT '0', -> PRIMARY KEY (`event_id`,`market_id`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; Query OK, 0 rows affected (0.01 sec) MariaDB [test]> ALTER TABLE market_deductions ADD PRIMARY KEY IF NOT EXISTS event_id (event_id,market_id); ERROR 1068 (42000): Multiple primary key defined {noformat} Seems IF NOT EXISTS is not really checked. Haven't checked if 10.0.22 has fixed this as part of |
{noformat} MariaDB [test]> CREATE TABLE `market_deductions` ( -> `event_id` bigint(20) unsigned NOT NULL DEFAULT '0', -> `market_id` bigint(20) unsigned NOT NULL DEFAULT '0', -> PRIMARY KEY (`event_id`,`market_id`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; Query OK, 0 rows affected (0.01 sec) MariaDB [test]> ALTER TABLE market_deductions ADD PRIMARY KEY IF NOT EXISTS event_id (event_id,market_id); ERROR 1068 (42000): Multiple primary key defined {noformat} Seems IF NOT EXISTS is not really checked. Haven't checked if 10.0.22 has fixed this as part of |
| Sprint | 10.0.22 [ 17 ] |
| Rank | Ranked higher |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Fix Version/s | 10.0.22 [ 19700 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Link |
This issue relates to |
| Workflow | MariaDB v3 [ 70132 ] | MariaDB v4 [ 149293 ] |