You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Add a bit field named 'SEX' to the source table and set the default value to 0;
Run schemasync to create the patch script;
Import the patch script into mysql;
Following script fails:
ALTER TABLE `table1` ADD COLUMN `SEX` bit(1) NULL DEFAULT 'b'0'' AFTER `LEVEL`;
with error:
ERROR 1064 (42000) at line 9: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near '0'' AFTER `LEVEL`' at line 1
This error is caused by the extra single quotation surrounding b'0'. Correct script should be:
ALTER TABLE `table1` ADD COLUMN `SEX` bit(1) NULL DEFAULT b'0' AFTER `LEVEL`;
The text was updated successfully, but these errors were encountered:
Reproduction steps:
Following script fails:
with error:
This error is caused by the extra single quotation surrounding b'0'. Correct script should be:
The text was updated successfully, but these errors were encountered: