#166 Enumerate does not work (as expected) without quotes

3.2.2
closed-rejected
Common (150)
5
2011-06-30
2011-06-30
Anonymous
No

Altering current table or creating new does fail if at least one of the columns is `enum` set to foo.
Even with the value filled, the actual query is generated as follows:

ALTER TABLE `transaction`
CHANGE `method` `method` enum() COLLATE \'utf8_czech_ci\' NULL AFTER `timestamp`,
COMMENT=\'\'
REMOVE PARTITIONING;

Adding newline after the foo or quoting it does produce the expected query:

ALTER TABLE `transaction`
CHANGE `method` `method` enum(\'foo\') COLLATE \'utf8_czech_ci\' NULL AFTER `timestamp`,
COMMENT=\'\'
REMOVE PARTITIONING;

Discussion

  • Jakub Vrána

    Jakub Vrána - 2011-06-30

    You should enclose the value to single quotes if you don't use the multi-line edit. Otherwise it would not be possible to differentiate between 'a,b' and 'a','b'.

     
  • Jakub Vrána

    Jakub Vrána - 2011-06-30
    • status: open --> closed-rejected
     

Log in to post a comment.