1
93%
main: 92%

Ran 18 Aug 2023 09:48PM UTC

Files 74

Run time 6min

Badge

Embed ▾

Committed 18 Aug 2023 09:39PM UTC coverage: 93.121% (-0.06%) from 93.18%

Job # 5907318228.1

Build Type

push

github

Committed by

evanelias

Commit Message

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.

Run Details

9260 of 9944 relevant lines covered (93.12%)

1.11 hits per line

skeema / skeema / 5907318228 / 1
93%
main: 92%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 5907318228.1

skeema / skeema / 5907318228 / 1 93% main: 92%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 5907318228.1

skeema / skeema / 5907318228 / 1
93%
main: 92%

README BADGES
x