[MacPorts] #70846: macports.sqlext should be updated to current extension APIs
MacPorts
noreply at macports.org
Sat Sep 21 12:57:08 UTC 2024
#70846: macports.sqlext should be updated to current extension APIs
------------------------------+--------------------
Reporter: RJVB | Owner: (none)
Type: defect | Status: new
Priority: Normal | Milestone:
Component: ports | Version:
Resolution: | Keywords:
Port: macports.sqlext |
------------------------------+--------------------
Comment (by RJVB):
Correction: the init function does get called, but is doesn't appear to
have the intended effect:
{{{
> sqlite3
SQLite version 3.46.0 2024-05-23 13:25:27
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .load /alt/local/libexec/macports/lib/registry2.0/macports.sqlext
creating collation sequence VERSION to sql_version()
sqlite> .open /opt/local/var/macports/registry/registry-20240920.db
sqlite> VACUUM;
Runtime error: no such collation sequence: VERSION
}}}
With a bit more info printed it finally becomes clear that loading
extensions only applies to already attached database(s)...
{{{
> sqlite3
SQLite version 3.46.0 2024-05-23 13:25:27
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .load /alt/local/libexec/macports/lib/registry2.0/macports.sqlext
creating collation sequence VERSION to sql_version() for database ""
sqlite> .open /opt/local/var/macports/registry/registry-20240920.db
sqlite> .load /alt/local/libexec/macports/lib/registry2.0/macports.sqlext
creating collation sequence VERSION to sql_version() for database
"/opt/local/var/macports/registry/registry-20240920.db"
sqlite> VACUUM;
sqlite> ^D
}}}
I'll attach my modifications as a patch but this ticket can be closed. Or
rather, maybe only after updating the instructions for the sake of other
database n00bs.
--
Ticket URL: <https://trac.macports.org/ticket/70846#comment:1>
MacPorts <https://www.macports.org/>
Ports system for macOS
More information about the macports-tickets
mailing list