Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-425

ALTER TABLE cannot change default value of column

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 0.6.2
    • 0.6.1
    • mysql-connector
    • None

      SQL statement alter table customers alter xxx set default 13; ends with exception

      io.debezium.text.ParsingException: Expecting DEFAULT at line 1, column 45 but found '13': ter xxx set default  ===>> 13
connect_1    | 	at io.debezium.text.TokenStream.consume(TokenStream.java:680)
connect_1    | 	at io.debezium.connector.mysql.MySqlDdlParser.parseDefaultClause(MySqlDdlParser.java:1597)
connect_1    | 	at io.debezium.connector.mysql.MySqlDdlParser.parseAlterSpecification(MySqlDdlParser.java:1227)
connect_1    | 	at io.debezium.connector.mysql.MySqlDdlParser.parseAlterSpecificationList(MySqlDdlParser.java:1188)
connect_1    | 	at io.debezium.connector.mysql.MySqlDdlParser.parseAlterTable(MySqlDdlParser.java:1151)
connect_1    | 	at io.debezium.connector.mysql.MySqlDdlParser.parseAlter(MySqlDdlParser.java:1133)
connect_1    | 	at io.debezium.connector.mysql.MySqlDdlParser.parseNextStatement(MySqlDdlParser.java:154)
connect_1    | 	at io.debezium.relational.ddl.DdlParser.parse(DdlParser.java:286)
connect_1    | 	at io.debezium.relational.ddl.DdlParser.parse(DdlParser.java:267)
connect_1    | 	at io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:359)
connect_1    | 	at io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:469)
connect_1    | 	at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:323)
connect_1    | 	... 5 more

              jpechane Jiri Pechanec
              jpechane Jiri Pechanec
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: