GNU bug report logs - #66983
29.1; sql-sqlite prompt-cont-regexp incompatible since sqlite 3.41.0

Please note: This is a static page, with minimal formatting, updated once a day.
Click here to see this page with the latest information and nicer formatting.

Package: emacs; Reported by: Gustav Broberg <gustav.broberg@HIDDEN>; dated Tue, 7 Nov 2023 11:44:02 UTC; Maintainer for emacs is bug-gnu-emacs@HIDDEN.

Message received at 66983 <at> debbugs.gnu.org:


Received: (at 66983) by debbugs.gnu.org; 25 Nov 2023 09:26:43 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Sat Nov 25 04:26:42 2023
Received: from localhost ([127.0.0.1]:37808 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1r6ovy-00010m-Ll
	for submit <at> debbugs.gnu.org; Sat, 25 Nov 2023 04:26:42 -0500
Received: from eggs.gnu.org ([2001:470:142:3::10]:40964)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <eliz@HIDDEN>) id 1r6ovw-00010T-9x
 for 66983 <at> debbugs.gnu.org; Sat, 25 Nov 2023 04:26:40 -0500
Received: from fencepost.gnu.org ([2001:470:142:3::e])
 by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
 (Exim 4.90_1) (envelope-from <eliz@HIDDEN>)
 id 1r6ovl-0007PS-I9; Sat, 25 Nov 2023 04:26:29 -0500
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org;
 s=fencepost-gnu-org; h=References:Subject:In-Reply-To:To:From:Date:
 mime-version; bh=UVyJFF7nJNPd7ClGfMV8uExRQVH1dQDi3CKE5dtZBCU=; b=owbXPotgSgMl
 L3EFwiwmVAwn4qDww3t79GqF56JHBISPja7Rw5EVvLqQI/DAn9Sy4jJ0O/rcSsXwor9KNtYv47sgl
 4tZOKYXKHs+qRM30oAPlGLki80sy4edRFdSCZy/3yBIUw2W7Xz4RawWekUgKy2loVbFJNpmxWXSVx
 KYicZyeWhVixSZVZmB8r4wCoqvkCmMxojhG2wzH6biNXPbOig8grkDmsYSBytBOnMbWWmADeq9CdJ
 HRAXXAVKE7GbNchWVtf1kvVy6PimHwFkLJwY9AgPd46qxi8UydV2znOQOeZtJYg5R9ZIkUH+cO6DK
 fdThujAt7ZKpkVSfFiutgA==;
Date: Sat, 25 Nov 2023 11:26:27 +0200
Message-Id: <838r6mdvzw.fsf@HIDDEN>
From: Eli Zaretskii <eliz@HIDDEN>
To: michael@HIDDEN
In-Reply-To: <83o7g1yfr7.fsf@HIDDEN> (message from Eli Zaretskii on Fri, 10
 Nov 2023 14:06:20 +0200)
Subject: Re: bug#66983: [PATCH] sql.el: Let sqlite's prompt-cont-regexp accept
 new dynamic prompt
References: <CAE4h+g1hsf6iysQnezt2H2fUAGKSYU1VO9pE+tSzoZZkS6ft_g@HIDDEN>
 <CAE4h+g0xnUb00yGM82RsOij8N0T=m9ZDYHYtH3x8mrRFuEGhSg@HIDDEN>
 <83o7g1yfr7.fsf@HIDDEN>
X-Spam-Score: -2.3 (--)
X-Debbugs-Envelope-To: 66983
Cc: 66983 <at> debbugs.gnu.org, gustav.broberg@HIDDEN
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -3.3 (---)

Ping!  Michael, can you please look into this?

> Cc: 66983 <at> debbugs.gnu.org
> Date: Fri, 10 Nov 2023 14:06:20 +0200
> From: Eli Zaretskii <eliz@HIDDEN>
> 
> > From: Gustav Broberg <gustav.broberg@HIDDEN>
> > Date: Fri, 10 Nov 2023 10:41:03 +0100
> > 
> > Patch for changing sql.el sqlite's prompt-cont-regexp to be compatible with SQLite 3.41.0.
> 
> Thanks.
> 
> Michael, any comments or suggestions?
> 
> 
> 
> 




Information forwarded to bug-gnu-emacs@HIDDEN:
bug#66983; Package emacs. Full text available.

Message received at 66983 <at> debbugs.gnu.org:


Received: (at 66983) by debbugs.gnu.org; 10 Nov 2023 12:07:24 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Fri Nov 10 07:07:24 2023
Received: from localhost ([127.0.0.1]:49647 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1r1QIF-0007XD-R3
	for submit <at> debbugs.gnu.org; Fri, 10 Nov 2023 07:07:24 -0500
Received: from eggs.gnu.org ([2001:470:142:3::10]:44150)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <eliz@HIDDEN>) id 1r1QIC-0007Wy-CK
 for 66983 <at> debbugs.gnu.org; Fri, 10 Nov 2023 07:07:22 -0500
Received: from fencepost.gnu.org ([2001:470:142:3::e])
 by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
 (Exim 4.90_1) (envelope-from <eliz@HIDDEN>)
 id 1r1QHT-00077X-1z; Fri, 10 Nov 2023 07:06:35 -0500
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org;
 s=fencepost-gnu-org; h=References:Subject:In-Reply-To:To:From:Date:
 mime-version; bh=fQ8pj0MdCnWw1wlE23fN7tRyeW5cT5EJGLLyAUEcYKg=; b=d/h0MPYPAPwg
 q4eGIvkTpbuDVpENvIKlYn0SrUvpDO+CtlBNG5R5WkGl+bZoLoUdTFW8p01SUtVsuJQNC4zOIT8Gf
 FXe0rRC4Wo18rec2oIcY2MbxC2Z4f+q6umgNcZHNBgLvkD1HwQXGrz/GHbdguJ/UPSuO/xGYe3yX/
 gPFKMXrYpLGfmrX6SqnaMZDjfQ49p9stDMJ23LyT7Y6FbGrAcd+DXxCPC1F+9lDRJhRgm0VyWY1dS
 n36s3E1TWuyhEuSE1C/dhD/8kU/bBDs2efOV0Rp+S9MG8MFzzn4AAWVaEQaf651HHn7F081Sqx79+
 dOTnwFBmF8SRYWM1rugO8Q==;
Date: Fri, 10 Nov 2023 14:06:20 +0200
Message-Id: <83o7g1yfr7.fsf@HIDDEN>
From: Eli Zaretskii <eliz@HIDDEN>
To: Gustav Broberg <gustav.broberg@HIDDEN>,
 Michael R. Mauger <michael@HIDDEN>
In-Reply-To: <CAE4h+g0xnUb00yGM82RsOij8N0T=m9ZDYHYtH3x8mrRFuEGhSg@HIDDEN>
 (message from Gustav Broberg on Fri, 10 Nov 2023 10:41:03 +0100)
Subject: Re: bug#66983: [PATCH] sql.el: Let sqlite's prompt-cont-regexp accept
 new dynamic prompt
References: <CAE4h+g1hsf6iysQnezt2H2fUAGKSYU1VO9pE+tSzoZZkS6ft_g@HIDDEN>
 <CAE4h+g0xnUb00yGM82RsOij8N0T=m9ZDYHYtH3x8mrRFuEGhSg@HIDDEN>
X-Spam-Score: -2.3 (--)
X-Debbugs-Envelope-To: 66983
Cc: 66983 <at> debbugs.gnu.org
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -3.3 (---)

> From: Gustav Broberg <gustav.broberg@HIDDEN>
> Date: Fri, 10 Nov 2023 10:41:03 +0100
> 
> Patch for changing sql.el sqlite's prompt-cont-regexp to be compatible with SQLite 3.41.0.

Thanks.

Michael, any comments or suggestions?




Information forwarded to bug-gnu-emacs@HIDDEN:
bug#66983; Package emacs. Full text available.

Message received at 66983 <at> debbugs.gnu.org:


Received: (at 66983) by debbugs.gnu.org; 10 Nov 2023 10:20:34 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Fri Nov 10 05:20:34 2023
Received: from localhost ([127.0.0.1]:49594 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1r1Oco-0004Mh-WD
	for submit <at> debbugs.gnu.org; Fri, 10 Nov 2023 05:20:34 -0500
Received: from mail-pj1-x1030.google.com ([2607:f8b0:4864:20::1030]:54399)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <gustav.broberg@HIDDEN>) id 1r1O1p-0003Cp-3G
 for 66983 <at> debbugs.gnu.org; Fri, 10 Nov 2023 04:42:19 -0500
Received: by mail-pj1-x1030.google.com with SMTP id
 98e67ed59e1d1-28003daaaa6so1609561a91.0
 for <66983 <at> debbugs.gnu.org>; Fri, 10 Nov 2023 01:41:37 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=gmail.com; s=20230601; t=1699609290; x=1700214090; darn=debbugs.gnu.org;
 h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
 :date:message-id:reply-to;
 bh=fh3pbiCX2KxlRJ/6AKgJUDCSsVoy7upfpPTzzyHYS9o=;
 b=Qp2GxdcfYvcSC+e5tDzujF8YAess+GJNfr994pRETTd042omkXu2cThlr2p/3sPgFQ
 a8asdryAF/aL2yi/rwjtEsNX4QMyW2bt8EpkSUynBHcrIFvdiHAOFVx+yhZOOYfzgyl9
 FkjL3JY1/QWZPdv6r3mkxCMtAd63ygCwHuG/4ChIPdKrNfYppK+btZv80D+mOV5qZJdc
 DDUdBmJKb1unZyfz9godUq97OHFgXLd0m3aInvutfZAiLvV1HO9zDCrB6bWGQ1R6F2iX
 da+bAK26r1HAwMwcgk50VzYKoxams3ghI3XLMvQrbmxYz69z5AIm9wB0sSQQ4ITDZgle
 iLsA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20230601; t=1699609290; x=1700214090;
 h=to:subject:message-id:date:from:mime-version:x-gm-message-state
 :from:to:cc:subject:date:message-id:reply-to;
 bh=fh3pbiCX2KxlRJ/6AKgJUDCSsVoy7upfpPTzzyHYS9o=;
 b=NYxHPvZqLc+uk4+yn3OdK1DxGK7H1jk5eo3OwKFqD8vveZbuP4L6Z811mEyNo+czTh
 K5rHhI21PefoxP5U46IC7+sgCtqLi0Fom6zrRH9QW4vRlb+yOLaQ/zV3/fpLmrUNuzXk
 zoURZhcFZ/aAchqvSOrSG85V5rCBf4mpIKON50fH5jzF8cnV5EinECDTotlzzJlKJ4wX
 QeTEcxGqH3srck2C0mZELot9Xd6Gbjc7oCLtFIdvi0639WiuFn6U0IOOQomLYEGpP8NV
 2zH68NAyBR4IDgCm+R0bImUYCVfMHVdUVuIA9PWYqyn46JwunsizjtynLDPmu8OMHvvI
 pzKw==
X-Gm-Message-State: AOJu0YzX4M2mmqinwv5UOckOJIKjhEfgl+ICABNWztH+r3wCZNWU0hzu
 ukVFLf4tdR0w4Fnj+tHZaFSfmXsAAFdbe5/mwDXdvwaFtAjP/Q==
X-Google-Smtp-Source: AGHT+IFoOqM/oZpX4xg6WV/WVNkSGk9R9VEolgSZXE+04v7aiOiOcDhFKit0DHYKBWxUAgbuAf/DKzIXAi/FH8ji7QA=
X-Received: by 2002:a17:90b:4c12:b0:280:3f33:64d8 with SMTP id
 na18-20020a17090b4c1200b002803f3364d8mr4693904pjb.21.1699609290187; Fri, 10
 Nov 2023 01:41:30 -0800 (PST)
MIME-Version: 1.0
From: Gustav Broberg <gustav.broberg@HIDDEN>
Date: Fri, 10 Nov 2023 10:41:03 +0100
Message-ID: <CAE4h+g0xnUb00yGM82RsOij8N0T=m9ZDYHYtH3x8mrRFuEGhSg@HIDDEN>
Subject: [PATCH] sql.el: Let sqlite's prompt-cont-regexp accept new dynamic
 prompt
To: 66983 <at> debbugs.gnu.org
Content-Type: multipart/mixed; boundary="000000000000ffbd570609c91f7f"
X-Spam-Score: 0.0 (/)
X-Debbugs-Envelope-To: 66983
X-Mailman-Approved-At: Fri, 10 Nov 2023 05:20:29 -0500
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -1.0 (-)

--000000000000ffbd570609c91f7f
Content-Type: multipart/alternative; boundary="000000000000ffbd550609c91f7d"

--000000000000ffbd550609c91f7d
Content-Type: text/plain; charset="UTF-8"

Patch for changing sql.el sqlite's prompt-cont-regexp to be compatible with
SQLite 3.41.0.

--000000000000ffbd550609c91f7d
Content-Type: text/html; charset="UTF-8"

<div dir="ltr">Patch for changing sql.el sqlite&#39;s prompt-cont-regexp to be compatible with SQLite 3.41.0.</div>

--000000000000ffbd550609c91f7d--

--000000000000ffbd570609c91f7f
Content-Type: application/octet-stream; 
	name="0001-sql.el-Let-sqlite-s-prompt-cont-regexp-accept-new-dy.patch"
Content-Disposition: attachment; 
	filename="0001-sql.el-Let-sqlite-s-prompt-cont-regexp-accept-new-dy.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_losfawmr0>
X-Attachment-Id: f_losfawmr0

RnJvbSBlMjQyZDYyMWVhNjVjNTE2M2VlNmRjOWVkNTAyNWE0MDMwODMxOWUxIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBHdXN0YXYgQnJvYmVyZyA8Z3VzdGF2LmJyb2JlcmdAZ21haWwu
Y29tPgpEYXRlOiBGcmksIDEwIE5vdiAyMDIzIDEwOjE2OjI5ICswMTAwClN1YmplY3Q6IFtQQVRD
SF0gc3FsLmVsOiBMZXQgc3FsaXRlJ3MgcHJvbXB0LWNvbnQtcmVnZXhwIGFjY2VwdCBuZXcgZHlu
YW1pYwogcHJvbXB0CgpTaW5jZSBTUUxpdGUgdmVyc2lvbiAzLjQxLjAgdGhlIGNvbnRpbnVhdGlv
biBwcm9tcHQgaXMgZHluYW1pYyBhbmQKc2hvd3Mgb3BlbiBwYXJlbnRoZXNlcywgcXVvdGVzLCBj
b21tZW50cywgZXRjLiBVcGRhdGUgc3FsLmVsIHNxbGl0ZQpwcm9tcHQtY29udC1yZWdleHAgdG8g
bWF0Y2ggbm90IG9ubHkgdGhlIHN0YXRpYyBwcm9tcHQgKCIgICAuLi4+ICIpCmJ1dCB0aGUgbmV3
IGR5bmFtaWMgb25lcy4gVGhlIHBvc3NpYmxlIGNvbnRpbnVhdGlvbiBwcm9tcHRzIGFyZToKCiAg
ICAgLi4uPgogIGAgIC4uLj4KICAnICAuLi4+CiAgIiAgLi4uPgogIC8qIC4uLj4KICAoeE4uLi4+
ICh3aGVyZSBOIGlzIDEgdG8gOSkKICAoLi4uLi4+CiAgKXghLi4uPgotLS0KIGxpc3AvcHJvZ21v
ZGVzL3NxbC5lbCB8IDIgKy0KIDEgZmlsZSBjaGFuZ2VkLCAxIGluc2VydGlvbigrKSwgMSBkZWxl
dGlvbigtKQoKZGlmZiAtLWdpdCBhL2xpc3AvcHJvZ21vZGVzL3NxbC5lbCBiL2xpc3AvcHJvZ21v
ZGVzL3NxbC5lbAppbmRleCAwMDRhZTUwZWY1MC4uYTk5ZTk0YWNmNzkgMTAwNjQ0Ci0tLSBhL2xp
c3AvcHJvZ21vZGVzL3NxbC5lbAorKysgYi9saXNwL3Byb2dtb2Rlcy9zcWwuZWwKQEAgLTUwNyw3
ICs1MDcsNyBAQCBmaWxlLiAgU2luY2UgdGhhdCBpcyBhIHBsYWludGV4dCBmaWxlLCB0aGlzIGNv
dWxkIGJlIGRhbmdlcm91cy4iCiAgICAgIDpjb21wbGV0aW9uLW9iamVjdCBzcWwtc3FsaXRlLWNv
bXBsZXRpb24tb2JqZWN0CiAgICAgIDpwcm9tcHQtcmVnZXhwICJec3FsaXRlPiAiCiAgICAgIDpw
cm9tcHQtbGVuZ3RoIDgKLSAgICAgOnByb21wdC1jb250LXJlZ2V4cCAiXiAgIFxcLlxcLlxcLj4g
IikKKyAgICAgOnByb21wdC1jb250LXJlZ2V4cCAiXltgJ1wiLygpIF1beCouIF1bMS05IS4gXVxc
LlxcLlxcLj4gIikKIAogICAgIChzeWJhc2UKICAgICAgOm5hbWUgIlN5YmFzZSIKLS0gCjIuNDIu
MQoK
--000000000000ffbd570609c91f7f--




Information forwarded to bug-gnu-emacs@HIDDEN:
bug#66983; Package emacs. Full text available.

Message received at submit <at> debbugs.gnu.org:


Received: (at submit) by debbugs.gnu.org; 7 Nov 2023 11:43:49 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Tue Nov 07 06:43:49 2023
Received: from localhost ([127.0.0.1]:41382 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1r0KUb-0007B9-2w
	for submit <at> debbugs.gnu.org; Tue, 07 Nov 2023 06:43:49 -0500
Received: from lists.gnu.org ([2001:470:142::17]:58040)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <gustav.broberg@HIDDEN>) id 1r0JDA-0004t8-Oi
 for submit <at> debbugs.gnu.org; Tue, 07 Nov 2023 05:21:33 -0500
Received: from eggs.gnu.org ([2001:470:142:3::10])
 by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
 (Exim 4.90_1) (envelope-from <gustav.broberg@HIDDEN>)
 id 1r0JCS-000406-Ox
 for bug-gnu-emacs@HIDDEN; Tue, 07 Nov 2023 05:20:49 -0500
Received: from mail-yb1-xb2a.google.com ([2607:f8b0:4864:20::b2a])
 by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128)
 (Exim 4.90_1) (envelope-from <gustav.broberg@HIDDEN>)
 id 1r0JCQ-0004rw-V2
 for bug-gnu-emacs@HIDDEN; Tue, 07 Nov 2023 05:20:48 -0500
Received: by mail-yb1-xb2a.google.com with SMTP id
 3f1490d57ef6-da2b9211dc0so5326706276.3
 for <bug-gnu-emacs@HIDDEN>; Tue, 07 Nov 2023 02:20:45 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=gmail.com; s=20230601; t=1699352445; x=1699957245; darn=gnu.org;
 h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
 :date:message-id:reply-to;
 bh=tx71ccI/E9rK3oopN9MHF9kaVHPEXWfKZv3NpenUL+g=;
 b=BH3GuETb5g/Bo7vvi809McQ9sXyldx3xtq0VlG/rcmyuD0MbV0DJo7nHWjLJ5y4qVF
 saHY1UNDjm8zr7HkgOhCHFVNG1KcG65TRJiaohA1XHELyXa1HCFnhMGKih9Qk3+xiNLF
 02HKB2GsPWnoeB9CiCnEstu1bEncf3mUk16n2RMiAu/fAOreA/ftcy2BGj13IAGkKaW4
 +whdtCEnuN7LncwjJboMv7u2mOIQ6+3EWn3E8w+zRDYDH1qx3DxLqdOg6MyM7HaKeWRI
 37quHf5Cpy5pkbW3uhuY8otODveWAeNC5yJDbrDbxzojGtACNoC7myTnvJ6F82lwl6iv
 xbpg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20230601; t=1699352445; x=1699957245;
 h=to:subject:message-id:date:from:mime-version:x-gm-message-state
 :from:to:cc:subject:date:message-id:reply-to;
 bh=tx71ccI/E9rK3oopN9MHF9kaVHPEXWfKZv3NpenUL+g=;
 b=l8cT5ei9K0wEdHEfNlyuqxHzQ3wN6wtE0y4Ji573qPJI32Cg9ddVZqueYCX299wXjz
 QZeP23F8hvbmdEz9O2G6xs4Mj8JSf1C2zkd523B7aEGImIHrk5bk9JHRdyz5p6AQ/g0Q
 kZTWqRWh8HmBpnkPENZiKbCMrcli3hAqOc1QuO19o2KBadm0ennG0BfotJcDSp01VH2D
 IwHDWxp4iu7VezVWO59plIkclnkPRbJ8QqjgtqHoE36VoujEHldwWH8QVnxqQ61U+krL
 t59orcN531Cf3LGPgvW5bBDX5C5kE+LZiNOCessFM3vwfFUa4wSBvDb2zF1PlcQfXT5q
 YHFQ==
X-Gm-Message-State: AOJu0YxxFh+JWGdjy9MAsK6HBfoOP2AoJgKmldfKtvdfsrXXYxF6mlew
 Wu+N4KIUTDt80/ETZjlg5HN6wtZYMb6EuXnq3F+5wPbwC897pg==
X-Google-Smtp-Source: AGHT+IGPqyz25VAuaGJKzfqgv3sXL+6tEIE28sz8M5ZuR+EFy86pm7bUgTfJuiExlc9xUrjFS7xMkYHCseQidNbqnRI=
X-Received: by 2002:a5b:5ca:0:b0:da0:5ba2:6275 with SMTP id
 w10-20020a5b05ca000000b00da05ba26275mr28629605ybp.34.1699352444740; Tue, 07
 Nov 2023 02:20:44 -0800 (PST)
MIME-Version: 1.0
From: Gustav Broberg <gustav.broberg@HIDDEN>
Date: Tue, 7 Nov 2023 11:20:18 +0100
Message-ID: <CAE4h+g1hsf6iysQnezt2H2fUAGKSYU1VO9pE+tSzoZZkS6ft_g@HIDDEN>
Subject: 29.1; sql-sqlite prompt-cont-regexp incompatible since sqlite 3.41.0
To: bug-gnu-emacs@HIDDEN
Content-Type: multipart/alternative; boundary="000000000000d12a8206098d5234"
Received-SPF: pass client-ip=2607:f8b0:4864:20::b2a;
 envelope-from=gustav.broberg@HIDDEN; helo=mail-yb1-xb2a.google.com
X-Spam_score_int: -20
X-Spam_score: -2.1
X-Spam_bar: --
X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1,
 DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001,
 HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001,
 SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no
X-Spam_action: no action
X-Spam-Score: 1.0 (+)
X-Debbugs-Envelope-To: submit
X-Mailman-Approved-At: Tue, 07 Nov 2023 06:43:35 -0500
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -0.0 (/)

--000000000000d12a8206098d5234
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

The continuation prompt regexp for sql.el's sqlite product is hard coded as
"   ...> ":
http://git.savannah.gnu.org/cgit/emacs.git/tree/lisp/progmodes/sql.el?id=3D=
a1abb6a85e6605c256595b8d7b885018e5421c28#n497

But since SQLite version 3.41.0 this prompt is no longer static but dynamic
and contains information about current context (unclosed string,
parentheses, etc.):
https://www.sqlite.org/releaselog/3_41_0.html

For example, sending a multi-line query with an unclosed string like:

  SELECT 1
  AS "two lines
  ";

will give an output like:

  SQLite version 3.44.0 2023-11-01 11:23:50
  Enter ".help" for usage hints.
  sqlite>
  "  ...> =E2=94=8C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=90
  =E2=94=82 two lines =E2=94=82
  =E2=94=9C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=A4
  =E2=94=82 1         =E2=94=82
  =E2=94=94=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=98
  Run Time: real 0.000 user 0.000118 sys 0.000076

because the continuation prompt is '"  ...> '.

Setting a custom sqlite continuation prompt regexp to match the dynamic
prompt
fixes this:

  (sql-set-product-feature 'sqlite :prompt-cont-regexp "^...\\.\\.\\.> ")

I suggest updating the regexp in sql.el to this (or some more specific)
regexp.

Thanks!
--=20
Gustav

--000000000000d12a8206098d5234
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">The continuation prompt regexp for sql.el&#39;s sqlite pro=
duct is hard coded as &quot; =C2=A0 ...&gt; &quot;:<br><a href=3D"http://gi=
t.savannah.gnu.org/cgit/emacs.git/tree/lisp/progmodes/sql.el?id=3Da1abb6a85=
e6605c256595b8d7b885018e5421c28#n497">http://git.savannah.gnu.org/cgit/emac=
s.git/tree/lisp/progmodes/sql.el?id=3Da1abb6a85e6605c256595b8d7b885018e5421=
c28#n497</a><br><br>But since SQLite version 3.41.0 this prompt is no longe=
r static but dynamic<br>and contains information about current context (unc=
losed string, parentheses, etc.):<br><a href=3D"https://www.sqlite.org/rele=
aselog/3_41_0.html">https://www.sqlite.org/releaselog/3_41_0.html</a><br><b=
r>For example, sending a multi-line query with an unclosed string like:<br>=
<br>=C2=A0 SELECT 1<br>=C2=A0 AS &quot;two lines<br>=C2=A0 &quot;;<br><br>w=
ill give an output like:<br><br>=C2=A0 SQLite version 3.44.0 2023-11-01 11:=
23:50<br>=C2=A0 Enter &quot;.help&quot; for usage hints.<br>=C2=A0 sqlite&g=
t; <br>=C2=A0 &quot; =C2=A0...&gt; =E2=94=8C=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=90<br>=C2=A0 =E2=94=82 two lines =E2=94=82<br>=C2=A0 =E2=94=9C=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=A4<br>=C2=A0 =E2=94=82 1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =E2=
=94=82<br>=C2=A0 =E2=94=94=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=98<br>=C2=A0 Run =
Time: real 0.000 user 0.000118 sys 0.000076<br><br>because the continuation=
 prompt is &#39;&quot; =C2=A0...&gt; &#39;.<br><br>Setting a custom sqlite =
continuation prompt regexp to match the dynamic prompt<br>fixes this:<br><b=
r>=C2=A0 (sql-set-product-feature &#39;sqlite :prompt-cont-regexp &quot;^..=
.\\.\\.\\.&gt; &quot;)<br><br>I suggest updating the regexp in sql.el to th=
is (or some more specific)<br>regexp.<br><br>Thanks!<br>-- <br>Gustav<br></=
div>

--000000000000d12a8206098d5234--




Acknowledgement sent to Gustav Broberg <gustav.broberg@HIDDEN>:
New bug report received and forwarded. Copy sent to bug-gnu-emacs@HIDDEN. Full text available.
Report forwarded to bug-gnu-emacs@HIDDEN:
bug#66983; Package emacs. Full text available.
Please note: This is a static page, with minimal formatting, updated once a day.
Click here to see this page with the latest information and nicer formatting.
Last modified: Sat, 25 Nov 2023 09:30:02 UTC

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997 nCipher Corporation Ltd, 1994-97 Ian Jackson.