[Koha-bugs] [Bug 17234] ALTER IGNORE TABLE is invalid in mysql 5.7. This breaks updatedatabase.pl
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Sep 6 10:44:36 CEST 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17234
Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jonathan.druart at bugs.koha-c
| |ommunity.org
--- Comment #7 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Could someone explain me why I don't get the same error:
mysql> set sql_mode="STRICT_TRANS_TABLES";
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER IGNORE TABLE suggestions ADD KEY biblionumber (biblionumber);
ERROR 1061 (42000): Duplicate key name 'biblionumber'
And so I don't understand the IGNORE keyword :)
Server version: 5.6.30-1 (Debian) # And not 5.7
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list