[pkg-bacula-devel] Bug#909460: Trouble with the sqlite3 upgrade path

[Sven Hartge]

On 9/24/18 10:07 AM, Carsten Leonhardt wrote:

> according to piuparts:
> 
>   applying upgrade sql for 7.4.4+dfsg-6 -> 9.0.0.
>   Error: near line 84: near "MODIFY": syntax error
>   Error: near line 85: near "MODIFY": syntax error
>   Error: near line 86: near "MODIFY": syntax error
> 
> https://piuparts.debian.org/stable2sid/fail/bacula-director-sqlite3_9.2.1-1.log
> 
> The version in stretch-backports contains the 9.0.0 update too but
> stretch2bpo works ok.

According to the sqlite3 documentation, "ALTER TABLE table-name MODIFY"
is indeed invalid. But we had this patch for some releases.

https://www.sqlite.org/lang_altertable.html

Maybe this was changed in a recent sqlite release?

S°

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <http://alioth-lists.debian.net/pipermail/pkg-bacula-devel/attachments/20180924/1459fdc2/attachment.sig>