sqlite3.OperationalError seen after freebsd-update from 14.0 to 14.1 and ports upgrade

Hi,

The SQL statement:

select field1 , Segment , RecordCount , file1 from file1_field1 where field1 == "one" and Segment == 0

gets exception:

sqlite3.OperationalError: no such column: one

when executed via the sqlite3 or apsw modules in Python3.9 on FreeBSD 14.1.

The exception is not seen on various Python versions on OpenBSD or Microsoft Windows 10, and was not seen on FreeBSD before the upgrade to 14.1.

The attachment has the following code to cause the exception.

import sqlite3 as engine
FIELD1 = " ".join(
    (
        "create table if not exists file1_field1",
        "( field1 , Segment , RecordCount, file1 )",
    )
)
if __name__ == "__main__":
    dbenv = engine.Connection(":memory:")
    cursor = dbenv.cursor()
    cursor.execute("begin")
    cursor.execute(FIELD1)
    cursor.execute("commit")
    ss = " ".join(
        (
            "select field1 , Segment , RecordCount , file1 from",
            'file1_field1 where field1 == "one" and Segment == 0',
        )
    )
    dbenv.cursor().execute(ss)

Bug?

Roger