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

On Sat, 6 Jul 2024 17:56:12 +0000
Roger Marsh <r.m@rmswch.plus.com> wrote:

>     ss = " ".join(
>         (
>             "select field1 , Segment , RecordCount , file1 from",
>             'file1_field1 where field1 == "one" and Segment == 0',
>         )
>     )
>     dbenv.cursor().execute(ss)

I eventually wondered what happens if the quoting is changed from:

             'file1_field1 where field1 == "one" and Segment == 0'

to:

             "file1_field1 where field1 == 'one' and Segment == 0"

and then no exception is seen.

So maybe the problem, if any, is the original code never gave an exception anywhere previously.

Roger