dbeaver: Trigger processing broken in 5.2.5; worked in 5.2.4

When trying to save a trigger to MySQL, I get a syntax error message. This same trigger worked fine in 5.2.4. Went to a mysql command line to submit the trigger to see if it was in error - it wasn’t and was processed.

The alleged syntax error was at or around the 6th line:

        SELECT NEW.test_code INTO @testCode;
        SELECT COUNT(*) FROM testing.test WHERE test_code = @testCode INTO @testCount;
        IF @testCount > 0 THEN
            SELECT name, test_term, test_term_type FROM testing.test WHERE promotion_code = @testCode INTO @name, @testTerm, @testTermType;
        ELSE
            SELECT '', '', '' INTO @name, @testTerm, @testTermType;
        END IF;
    ELSE
        SELECT '', '', '', '' INTO @testCode, @name, @testTerm, @testTermType;
    END IF;

About this issue

  • Original URL
  • State: closed
  • Created 6 years ago
  • Comments: 16 (8 by maintainers)

Most upvoted comments

you should be using the “play” button, 2 buttons above the one you pressed.