Bug #36669 default values are not quoted for TIME columns
Submitted: 12 May 2008 15:25 Modified: 28 May 2008 23:58
Reporter: Behrooz Afghahi Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.21 OS:Windows (Vista (SP1))
Assigned to: Alfredo Kojima CPU Architecture:Any

[12 May 2008 15:25] Behrooz Afghahi 
Description:
default values are not quoted for columns with TIME as datatype in the columns tab.

How to repeat:
create a table and add a column using TIME as datatype and try adding a default value of 00:00:00 ,the value is not quoted.
[12 May 2008 15:52] Valeriy Kravchuk 
Thank you for a bug report. Workbench produces the following script for the table while Forward Engineering:

...
-- -----------------------------------------------------
-- Table `mydb`.`table1`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`table1` (
  `idtable1` INT NOT NULL ,
  `c1` TIME NULL DEFAULT 00:00:00 ,
  `c2` VARCHAR(45) NULL DEFAULT 'abc' ,
  PRIMARY KEY (`idtable1`) )
ENGINE = InnoDB;
[12 May 2008 15:52] MySQL Verification Team 
Thank you for the bug report.
[21 May 2008 21:14] Johannes Taxacher 
time values are correctly quoted now. tested in bzr rev 3111
[28 May 2008 23:58] Paul DuBois 
Noted in 5.0.22 changelog.

For CREATE TABLE statements, TIME column default values were not
quoted properly.