-
Abhishek Ranjan authored
Description: ------------ This is a regression from Bug#18311187 and WL#8596 combined. Bug#18311187 introduced sub modes of STRICT mode, but only for use in syntax. They would have no effect on behaviour. To remove these sql modes completely in future, code was changed to not show these modes in SHOW CREATE TRIGGER statement. When WL#8596 added these sql modes back completely, this use case was missed to add back. Same case exists for Stored Procedure and Stored Function. Fix: ----- Fixed code to show all sql modes in SHOW CREATE TRIGGER / PROCEDURE / FUNCTION statements.
Abhishek Ranjan authoredDescription: ------------ This is a regression from Bug#18311187 and WL#8596 combined. Bug#18311187 introduced sub modes of STRICT mode, but only for use in syntax. They would have no effect on behaviour. To remove these sql modes completely in future, code was changed to not show these modes in SHOW CREATE TRIGGER statement. When WL#8596 added these sql modes back completely, this use case was missed to add back. Same case exists for Stored Procedure and Stored Function. Fix: ----- Fixed code to show all sql modes in SHOW CREATE TRIGGER / PROCEDURE / FUNCTION statements.
Loading