Bug - Single enum value results in bad query

Anonymous
2012-03-28
2013-06-06
  • Anonymous - 2012-03-28

    For whatever reason, the bug tracker isn't saving my bug submission, so I'll post it here.

    Using MySQL and Adminer 3.3.4 -

    When I try to set just a single enum length when creating a table, adminer doesn't provide anything in the ENUM() declaration in the query, as highlighted in the attached file, resulting in an errored query. If I add an extra enumerated value, the create table works fine.

    On the lower half of the attached file, it results in the same error if I try to reduce the enumerated column to just one value, as well.

    Screenshot:

     
  • Jakub Vrána

    Jakub Vrána - 2012-04-15

    You need to put single quotes around the single value. Adminer supports 'a','b','c' in enum value (for copy/pasting from somewhere else) so it is required to use single quotes if there is just one line.

    Adminer needs to support also crazy shit like 'don\'t' which is why it cannot be automatic.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks