From nobody Mon Jul 08 10:51:45 2024 X-Original-To: freebsd-questions@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4WHgsy6Jk5z5Pttl for ; Mon, 08 Jul 2024 10:51:50 +0000 (UTC) (envelope-from r.m@rmswch.plus.com) Received: from avasout-ptp-001.plus.net (avasout-ptp-001.plus.net [84.93.230.227]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "avasout.plus.net", Issuer "GeoTrust TLS RSA CA G1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4WHgsx5fH7z4RJ9 for ; Mon, 8 Jul 2024 10:51:49 +0000 (UTC) (envelope-from r.m@rmswch.plus.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=plus.com header.s=042019 header.b=BvOsyNAw; dmarc=none; spf=none (mx1.freebsd.org: domain of r.m@rmswch.plus.com has no SPF policy when checking 84.93.230.227) smtp.mailfrom=r.m@rmswch.plus.com Received: from opendev.home ([80.229.151.92]) by smtp with SMTP id QlyDs6skS4PsgQlyEsiw4E; Mon, 08 Jul 2024 11:51:47 +0100 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=plus.com; s=042019; t=1720435907; bh=jiLOEOJkjtZJPc9T1MPePWColl3y3bDgJceTtEPVTFE=; h=Date:From:To:Subject:In-Reply-To:References; b=BvOsyNAwp8vD2H5Z+iyFtzQuUKkeuHBHHtY0lbJEfwFqSosThkme7ttJ29/vbjzvc puDL6oFFNXcQKFLJ6v6q6heexTAyoqqWCEBBqY7vrusF3HmJ/SQuyO06NfqzfvhoQP AiZqR8zwVje7q4oojXCczRbJrTAZjXGx1hvtH6+cxGWZHFyA2tDBOTSwgby8vuZoq0 7zDuBcLl+bnlaLBYY39DLqp4A56ApMoAgz+kPGUjW5w6bo4hTY7lBvlzJH8GVt4RnV aCdjULH0/7aF/L8qj3P+zlzVEHAvf4ZvkHGtfBq95xzIs0e7XwsvpLBGbH+xSU0F4T lQwhHi0S8yxZg== X-Clacks-Overhead: "GNU Terry Pratchett" X-CM-Score: 0.00 X-CNFS-Analysis: v=2.4 cv=eeSefKEH c=1 sm=1 tr=0 ts=668bc4c3 a=6xlXYeu7y0jVCiZ/8t1ozg==:117 a=6xlXYeu7y0jVCiZ/8t1ozg==:17 a=kj9zAlcOel0A:10 a=EBOSESyhAAAA:8 a=6wKqmGm672WkMZPtbsEA:9 a=CjuIK1q_8ugA:10 a=yJM6EZoI5SlJf8ks9Ge_:22 Date: Mon, 8 Jul 2024 10:51:45 +0000 From: Roger Marsh 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> X-Mailer: Claws Mail 4.2.0 (GTK 3.24.41; x86_64-unknown-openbsd7.5) List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-questions@freebsd.org Sender: owner-freebsd-questions@FreeBSD.org MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-CMAE-Envelope: MS4xfJBbKNhasUU5euefXG3DumUgt30Oo1xXEgZ1rpVnxUtG2y4ZL4RCH91Z7WMGrn40LIjwgVNSApIXjhDg+/Ie4H2EciVfLKcLJNqTVNsSMS1i9T0mQto4 v1DP4LL4qh3Svu3RrC1JTdg36li251XUT0e3QdF+G7WoJmQlpShUaQnLxXG8bayyRbjCzIiH5ZvYEeZob0rfpKkICroUKjkuC+s= X-Spamd-Bar: --- X-Spamd-Result: default: False [-3.39 / 15.00]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.99)[-0.986]; R_DKIM_ALLOW(-0.20)[plus.com:s=042019]; MIME_GOOD(-0.10)[text/plain]; ONCE_RECEIVED(0.10)[]; RWL_MAILSPIKE_GOOD(-0.10)[84.93.230.227:from]; RCVD_IN_DNSWL_LOW(-0.10)[84.93.230.227:from]; MIME_TRACE(0.00)[0:+]; ARC_NA(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; RCVD_COUNT_ONE(0.00)[1]; ASN(0.00)[asn:6871, ipnet:84.92.0.0/15, country:GB]; R_SPF_NA(0.00)[no SPF record]; MLMMJ_DEST(0.00)[freebsd-questions@freebsd.org]; FROM_EQ_ENVFROM(0.00)[]; FROM_HAS_DN(0.00)[]; DMARC_NA(0.00)[plus.com]; TO_DN_NONE(0.00)[]; RCVD_TLS_LAST(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; DKIM_TRACE(0.00)[plus.com:+] X-Rspamd-Queue-Id: 4WHgsx5fH7z4RJ9 On Sat, 6 Jul 2024 17:56:12 +0000 Roger Marsh 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