[Bug 282980] astro/kstars crashes on startup

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=282980

Raúl Zighelboim <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #5 from Raúl Zighelboim <[email protected]> ---
Created attachment 270257
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=270257&action=edit
patch-kstars_catalogsdb_sqlstatements

KStars fails to execute certain SQL queries against SQLite due to incorrect

string quoting.

The code currently uses:

    name like "%" || :name || "%"

SQLite expects single quotes for string literals. The correct form is:

    name like '%' || :name || '%'

This causes query preparation failures at runtime.

Attached patch fixes the issue in catalogsdb/sqlstatements.cpp.

Tested on FreeBSD 15.0 with kstars-3.8.0_1,1. After applying the patch,

queries prepare and execute correctly.

-- 
You are receiving this mail because:
You are the assignee for the bug.