|
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2137
|
|
[11.0.12 Beta] - Hesitant formatting |
|
Formatting seems to be a bit "hesitant".
I have the following formatting rule for MariaDB:
|
|
CREATE ... PROCEDURE ...
(
...
,...
)
...
f:BEGIN
<stmtList>
END;
|
It takes the following code:
|
|
DROP PROCEDURE IF EXISTS `usp_get_user_by_id`;
DELIMITER $$$
CREATE PROCEDURE `usp_get_user_by_id`
(
)
f:
BEGIN
END;$$$
DELIMITER ;
|
On its first run, SA code formatting transforms the above code into this:
|
|
DROP PROCEDURE IF EXISTS `usp_get_user_by_id`;
DELIMITER $$$
CREATE PROCEDURE `usp_get_user_by_id`
(
)
f:BEGIN
END;$$$
DELIMITER ;
|
Running it one more time produces the desired format:
|
|
DROP PROCEDURE IF EXISTS `usp_get_user_by_id`;
DELIMITER $$$
CREATE PROCEDURE `usp_get_user_by_id`
(
)
f:BEGIN
END;$$$
DELIMITER ;
|
Any consecutive runs make no further changes to the code. Shouldn't it yield the second result on its first run?
|
|
Fri Jul 19, 2019 9:17 am |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|