Skip to content

ON UPDATE option in a field definition of TIMESTAMP type with precision is not parsed appropriately #92

@devenbansod

Description

@devenbansod

Parse the query :

CREATE TABLE `aa` (
  `id` int(11) NOT NULL,
  `rTime` timestamp(3) NOT NULL DEFAULT '0000-00-00 00:00:00.000' ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Parser error Output

#1 A comma or a closing bracket was expected. (near '(' at position 138)
#2 Unexpected beginning of statement. (near '3' at position 139) 
#3 Unrecognized statement type. (near 'PRIMARY KEY' at position 145)

Issue

ON UPDATE option in a field definition of TIMESTAMP type with precision is not parsed appropriately

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions