Date: Mon, 8 Jul 2024 10:51:45 +0000 From: Roger Marsh <r.m@rmswch.plus.com> To: freebsd-questions@freebsd.org Subject: Re: sqlite3.OperationalError seen after freebsd-update from 14.0 to 14.1 and ports upgrade Message-ID: <20240708105145.46fff70b@opendev.home> In-Reply-To: <20240706175612.0dd7ad18@opendev.home> References: <20240706175612.0dd7ad18@opendev.home>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20240708105145.46fff70b>