[Bug 270064] databases/sqlite3: Changed option DQS default, some ports required it.

From: <bugzilla-noreply_at_freebsd.org>
Date: Thu, 09 Mar 2023 13:00:45 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=270064

            Bug ID: 270064
           Summary: databases/sqlite3: Changed option DQS default, some
                    ports required it.
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Some People
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs@FreeBSD.org
          Reporter: pavelivolkov@gmail.com

Created attachment 240695
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=240695&action=edit
patch

Some port (see list after) required old behavior for option SQLITE_DQS:

1. net-p2p/sonarr (https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=270004) -
"already patched"
2. multimedia/emby-server
(https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=269889)
3. multimedia/tautulli
(https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=269889)
4. net/vnstat (https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=269966)
5. www/qutebrowser (https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=269950)

The old behavior is not welcomed by the authors SQLite, see:
1. https://www.sqlite.org/quirks.html#dblquote
2. https://www.sqlite.org/compile.html#dqs
3. https://www.sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdqsddl

It is recommended to make changes to the applications. It's been 4 years
already.

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