[aur-dev] [PATCH 1/2] schema: Remove invalid default values for TEXT columns
When running in strict mode, mysql throws an error upon encountering
these definitions since they are not supported.
References:
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Signed-off-by: Florian Pritz
From the mysql 5.7 breaking change page:
Columns in a PRIMARY KEY must be NOT NULL, but if declared explicitly as
NULL produced no error. Now an error occurs. For example, a statement
such as CREATE TABLE t (i INT NULL PRIMARY KEY) is rejected. The same
occurs for similar ALTER TABLE statements. (Bug #13995622, Bug #66987,
Bug #15967545, Bug #16545198)
References:
http://stackoverflow.com/a/22314073
Signed-off-by: Florian Pritz
On Sat, 15 Apr 2017 at 20:31:37, Florian Pritz via aur-dev wrote:
When running in strict mode, mysql throws an error upon encountering these definitions since they are not supported.
References: https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Signed-off-by: Florian Pritz
--- schema/aur-schema.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) [...]
Queued both patches on pu. Thanks!
participants (2)
-
Florian Pritz
-
Lukas Fleischer