transaction_log incorrectly has NOT NULL for column in update test
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Medium
|
Stewart Smith | ||
Dexter |
Fix Released
|
Medium
|
Stewart Smith |
Bug Description
from old (wrong) to new (correct)
--- /home/stewart/
+++ /home/stewart/
@@ -58,7 +58,7 @@
DROP TABLE `test`.`t1`;
COMMIT;
START TRANSACTION;
-CREATE TABLE `test`.`t1` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(1024) NOT NULL COLLATE utf8_general_ci, `alias` VARCHAR(1024) NOT NULL COLLATE utf8_general_ci, PRIMARY KEY `PRIMARY` (`id`) ) ENGINE = InnoDB COLLATE = utf8_general_ci;
+CREATE TABLE `test`.`t1` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(1024) DEFAULT NULL, `alias` varchar(1024) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
COMMIT;
START TRANSACTION;
INSERT INTO `test`.`t1` (`id`,`
fixed in show create table from statement_transform branch