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

Create Trigger DDL - parsing error

XMLWordPrintable

    • False
    • None
    • False

      DDL SQL (For some reason Jira wouldnt let pasting or attachment), attached as screenshot.

      Error:

       {{line 374:21 no viable alternative at input 'CREATE DEFINER=`bcadmin`@`%` TRIGGER `host_id_constraint` BEFORE INSERT ON `host` FOR EACH ROW begin\n declare next_id int;\n declare max_id int;\n declare error_msg varchar(100);\n set max_id = power(2, 9)-1;\n set next_id = null;\n select min(st.value) into next_id\n from SEQUENCE_TABLE('
      line 371:27 mismatched input '1' expecting '-'}}
       

       

      Add a comment

        1. screenshot-1.png
          78 kB
          Kanthi Subramanian

              Unassigned Unassigned
              subkanthi Kanthi Subramanian
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: