Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\ddyer\AppData\Roaming\MySQL\Workbench\log\wb.log]
the data export/import fails for enum fields which default to null
CREATE TABLE `offlinegame` (
`owner` int(11) NOT NULL DEFAULT '0',
`whoseturn` int(11) NOT NULL DEFAULT '0',
`gameuid` int(11) NOT NULL AUTO_INCREMENT,
`sequence` int(11) DEFAULT '0',
`status` enum('setup','active','complete','canceled','suspended') NOT NULL DEFAULT 'setup',
`marked` enum('delinquent','expired') DEFAULT NULL,
`offlinegamecol` varchar(45) NOT NULL DEFAULT '0',
`variation` varchar(30) NOT NULL,
`playmode` enum('ranked','unranked','tournament') NOT NULL DEFAULT 'ranked',
`invitedplayers` tinytext,
`acceptedplayers` tinytext,
`allowotherplayers` enum('true','false') DEFAULT NULL,
`body` text,
`comments` text,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`firstplayer` enum('random','mefirst','youfirst') NOT NULL DEFAULT 'random',
`speed` enum('day1','day2','day4','day8') NOT NULL DEFAULT 'day2',
`scored` tinyint(4) NOT NULL DEFAULT '0',
`chat` text,
`nag` text,
`NAGTIME` datetime DEFAULT NULL,
PRIMARY KEY (`gameuid`),
KEY `owner` (`owner`),
KEY `gameuid` (`gameuid`),
KEY `whoseturn` (`whoseturn`),
KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=294 DEFAULT CHARSET=latin1;
the field "marked" is exported to csv as "" if the value
is null. Importing the file results in the fields that should
be null imported as 'delinquent'
How to repeat:
use a table with this structure
Suggested fix:
make it work as intended
Description: ----[For better reports, please attach the log file after submitting. You can find it in C:\Users\ddyer\AppData\Roaming\MySQL\Workbench\log\wb.log] the data export/import fails for enum fields which default to null CREATE TABLE `offlinegame` ( `owner` int(11) NOT NULL DEFAULT '0', `whoseturn` int(11) NOT NULL DEFAULT '0', `gameuid` int(11) NOT NULL AUTO_INCREMENT, `sequence` int(11) DEFAULT '0', `status` enum('setup','active','complete','canceled','suspended') NOT NULL DEFAULT 'setup', `marked` enum('delinquent','expired') DEFAULT NULL, `offlinegamecol` varchar(45) NOT NULL DEFAULT '0', `variation` varchar(30) NOT NULL, `playmode` enum('ranked','unranked','tournament') NOT NULL DEFAULT 'ranked', `invitedplayers` tinytext, `acceptedplayers` tinytext, `allowotherplayers` enum('true','false') DEFAULT NULL, `body` text, `comments` text, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `firstplayer` enum('random','mefirst','youfirst') NOT NULL DEFAULT 'random', `speed` enum('day1','day2','day4','day8') NOT NULL DEFAULT 'day2', `scored` tinyint(4) NOT NULL DEFAULT '0', `chat` text, `nag` text, `NAGTIME` datetime DEFAULT NULL, PRIMARY KEY (`gameuid`), KEY `owner` (`owner`), KEY `gameuid` (`gameuid`), KEY `whoseturn` (`whoseturn`), KEY `status` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=294 DEFAULT CHARSET=latin1; the field "marked" is exported to csv as "" if the value is null. Importing the file results in the fields that should be null imported as 'delinquent' How to repeat: use a table with this structure Suggested fix: make it work as intended