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

MySQL procedure parser handles strings and keywords as same tokens

XMLWordPrintable

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

      In procedure

      CREATE DEFINER=`root`@`localhost` PROCEDURE `drop_old_tables_kenshoointernal`(p_int_to_delete INT )
      BEGIN
              INSERT INTO log_tbl (log_name,log_type,message) VALUES ('drop_old_tables_kenshoointernal','debug','end');       
             
      END
      

      there is a string `end'. When the method is parsed the string is erronesouly parsed as a keyword END. The problem is that method canConsume etc takse only token string value into consideration not token type.

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

              Created:
              Updated:
              Resolved: