Menu

#566 change to incorrect datatypes on table alter (MySQL 5.7)

Git
closed-invalid
nobody
5
2018-01-30
2017-07-22
amir
No

in left side is first correct table structure

and error on alter table shows in right

good luck

1 Attachments

Discussion

  • Jakub Vrána

    Jakub Vrána - 2018-01-23
    • status: open --> pending-works-for-me
     
  • Jakub Vrána

    Jakub Vrána - 2018-01-23

    Please send instructions to reproduce this.

     
  • Jakub Vrána

    Jakub Vrána - 2018-01-23

    This is similar to #555.

     
  • Erik Frøseth

    Erik Frøseth - 2018-01-30

    I don't understand what the expected outcome is...
    It seems like you are trying to change a VARCHAR(33) to TINYINT(33). For obvious reasons, this won't work if your column contains non-numeric values (as it seemingly does based on the error reported).

     
  • Jakub Vrána

    Jakub Vrána - 2018-01-30
    • status: pending-works-for-me --> closed-invalid
     

Log in to post a comment.

MongoDB Logo MongoDB