constraints_parser.c can't process a field that its name is reserved keyword
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Data Recovery Tool for InnoDB |
New
|
Undecided
|
gengchc2 |
Bug Description
constraints_
CREATE TABLE `credential` (
`id` varchar(64) NOT NULL,
`user_id` varchar(64) NOT NULL,
`project_id` varchar(64) DEFAULT NULL,
`blob` blob NOT NULL,
`type` varchar(255) NOT NULL,
`extra` blob,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
The field 'blob' is reserved keyword.
constraints_
SET FOREIGN_
LOAD DATA INFILE '/opt/3320/
SET
blob = UNHEX(@var_blob),
extra = UNHEX(@var_extra);
ERROR 1064 (42000) at line 2 in file: '/opt/3320/
extra = UNHEX(@var_extra)' at line 3
The correct load data statement is :
SET FOREIGN_
LOAD DATA INFILE '/opt/3320/
SET
`blob` = UNHEX(@var_blob),
`extra` = UNHEX(@var_extra);
By the way,Can I submit the correct code ?
Changed in percona-data-recovery-tool-for-innodb: | |
assignee: | nobody → gengchc2 (578043796-b) |