create_defs.pl can't process a table that its name is reserved keyword
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Data Recovery Tool for InnoDB |
New
|
Undecided
|
gengchc2 |
Bug Description
create_defs.pl can't process a table that its name is reserved keyword.such as:
CREATE TABLE `group` (
`id` varchar(64) NOT NULL,
`domain_id` varchar(64) NOT NULL,
`name` varchar(64) NOT NULL,
`description` blob,
`extra` blob,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
The table name 'group' is reserved keyword.
./create_defs.pl -S /opt/3320/
#ifndef table_defs_h
#define table_defs_h
// Table definitions
table_def_t table_definitions[] = {
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group' at line 1 at ./create_defs.pl line 68.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at ./create_defs.pl line 69.
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group' at line 1 at ./create_defs.pl line 74.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at ./create_defs.pl line 75.
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group' at line 1 at ./create_defs.pl line 82.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at ./create_defs.pl line 84.
By the way,Can I submit the correct code ?
Changed in percona-data-recovery-tool-for-innodb: | |
assignee: | nobody → gengchc2 (578043796-b) |