Package: src:gvmd Version: 9.0.1-1~exp1 Dear Maintainer,
currently the following patch is applied to the file tools/gvm-migrate-to-postgres.in (see [1]): - HAVE_CACHE=`sqlite "SELECT EXISTS (SELECT FROM sqlite_master WHERE type='table' AND name='permissions_get_tasks');"` + HAVE_CACHE=`sqlite "SELECT * EXISTS (SELECT FROM sqlite_master WHERE type='table' AND name='permissions_get_tasks');"` which should be the following instead (SELECT * FROM instead of SELECT * EXISTS) as shown in the linked github patch/commit (see [2]): - HAVE_CACHE=`sqlite "SELECT EXISTS (SELECT FROM sqlite_master WHERE type='table' AND name='permissions_get_tasks');"` + HAVE_CACHE=`sqlite "SELECT EXISTS (SELECT * FROM sqlite_master WHERE type='table' AND name='permissions_get_tasks');"` Regards, [1] https://salsa.debian.org/pkg-security-team/gvmd/-/blob/b1cf764952205dc9da6ccc0e58d05931f28204ac/debian/patches/Fix-gvm-migrate-to-postgres.patch#L22-23 [2] https://github.com/greenbone/gvmd/commit/d994d8742558bfe0e82948a8a5cf92911d6d5884
