skeema / skeema / 5907318228

93%

main: 92%

push

github

diff/push: support ALTER PROCEDURE and ALTER FUNCTION

For some limited types of adjustments to a routine, MySQL and MariaDB both
support ALTER statements to modify the routine's characteristics in-place.
Previously, Skeema would never emit ALTER PROCEDURE or ALTER FUNCTION
statements in these cases; all modifications to routines were handled with
a DROP and CREATE pair in MySQL, or a single CREATE OR REPLACE in MariaDB.

This commit adds the ability for `skeema diff` and `skeema push` to generate
an ALTER statement whenever the desired modification to a routine can be
handled solely with such a statement. In other words, an ALTER will now be
generated for changes that only affect some combination of a routine's SQL
characteristic, SECURITY characteristic, or comment clause.

Such changes are always considered safe (not requiring --allow-unsafe even in
MySQL) because the change is atomic, and does not cause the routine to briefly
not exist.

86 of 86 new or added lines in 1 file covered. (100.0%)

9260 of 9944 relevant lines covered (93.12%)

1.11 hits per line