| 1 | -- SQL invoked from regtest/aports-html.sh
|
| 2 |
|
| 3 | alter table diff_baseline add column cause text;
|
| 4 | -- Add Github links (AFTER accounting for signals)
|
| 5 | alter table diff_baseline add column cause_HREF text;
|
| 6 | alter table diff_baseline add column suite text;
|
| 7 | alter table diff_baseline add column suite_HREF text;
|
| 8 |
|
| 9 | -- Update diff table with values from causes table
|
| 10 | update diff_baseline
|
| 11 | set
|
| 12 | cause = causes.cause,
|
| 13 | suite = causes.suite,
|
| 14 | suite_HREF = causes.suite_HREF
|
| 15 | from causes
|
| 16 | where causes.pkg = diff_baseline.pkg;
|
| 17 |
|
| 18 | -- Set causes for signals/timeouts
|
| 19 | update diff_baseline
|
| 20 | set cause = 'signal-124'
|
| 21 | where status1 = 124 or status2 = 124;
|
| 22 |
|
| 23 | update diff_baseline
|
| 24 | set cause = 'signal-143'
|
| 25 | where status1 = 143 or status2 = 143;
|
| 26 |
|
| 27 | update diff_baseline
|
| 28 | set cause_HREF = case
|
| 29 | when cause regexp '#[0-9]+' then printf(
|
| 30 | 'https://github.com/oils-for-unix/oils/issues/%s',
|
| 31 | ltrim(cause, '#')
|
| 32 | )
|
| 33 | else ''
|
| 34 | end;
|