We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
描述 创建表时某个字段使用bit类型,默认值设置为NULL,会报错
CREATE TABLE test.test_bit ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `a_bit_field` bit(8) DEFAULT NULL COMMENT 'xxxxxx', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4;
报错: (2, 'CHECKED', 2, 'Audit Completed', "Invalid default value for column 'a_bit_field'.", "CREATE TABLE test_autodb_t2.test_bit (\n id bigint(20) NOT NULL AUTO_INCREMENT,\n a_bit_field bit(8) DEFAULT NULL COMMENT 'xxxxxx',\n PRIMARY KEY (id)\n)", 0, '0_0_00000001', None, '0', None, '0')
id
a_bit_field
The text was updated successfully, but these errors were encountered:
1183347
已修复,可更新到v1.2.4-72版本后重试。
v1.2.4-72
Sorry, something went wrong.
No branches or pull requests
描述
创建表时某个字段使用bit类型,默认值设置为NULL,会报错
报错:
(2, 'CHECKED', 2, 'Audit Completed', "Invalid default value for column 'a_bit_field'.", "CREATE TABLE test_autodb_t2.test_bit (\n
id
bigint(20) NOT NULL AUTO_INCREMENT,\na_bit_field
bit(8) DEFAULT NULL COMMENT 'xxxxxx',\n PRIMARY KEY (id
)\n)", 0, '0_0_00000001', None, '0', None, '0')The text was updated successfully, but these errors were encountered: