create_defs.pl can't process a table that its name is reserved keyword

Bug #1610496 reported by gengchc2
6
This bug affects 1 person
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/data_3320/mysql.sock --db=keystone --table=group
#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 ?

gengchc2 (578043796-b)
Changed in percona-data-recovery-tool-for-innodb:
assignee: nobody → gengchc2 (578043796-b)
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.