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)
you should be using the “play” button, 2 buttons above the one you pressed.