transaction_log incorrectly has NOT NULL for column in update test

Bug #611032 reported by Stewart Smith
6
This bug affects 1 person
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/drizzle/show-create-table-using-table-message/tests/../plugin/transaction_log/tests/r/update.result 2010-07-28 22:53:50.539885198 +0300
+++ /home/stewart/drizzle/show-create-table-using-table-message/tests/../plugin/transaction_log/tests/r/update.reject 2010-07-28 23:00:02.709476321 +0300
@@ -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`,`name`,`alias`) VALUES (1,'jeff lebowski','dude');

fixed in show create table from statement_transform branch

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.