From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id UOIsHu+FkGA8IwEAgWs5BA (envelope-from ) for ; Tue, 04 May 2021 01:23:27 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id IE7hGe+FkGDaQwAA1q6Kng (envelope-from ) for ; Mon, 03 May 2021 23:23:27 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id EA97326CC2 for ; Tue, 4 May 2021 01:23:26 +0200 (CEST) Received: from localhost ([::1]:34868 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1ldhuO-0003Xy-KN for larch@yhetil.org; Mon, 03 May 2021 19:23:24 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:54540) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ldgyA-0004km-LQ for emacs-orgmode@gnu.org; Mon, 03 May 2021 18:23:15 -0400 Received: from mail-yb1-xb2c.google.com ([2607:f8b0:4864:20::b2c]:33432) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1ldgy4-0004SE-9g for emacs-orgmode@gnu.org; Mon, 03 May 2021 18:23:14 -0400 Received: by mail-yb1-xb2c.google.com with SMTP id 15so9679299ybc.0 for ; Mon, 03 May 2021 15:23:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:sender:from:date:message-id:subject:to; bh=SrfCjpnrrHmC/vzr/aihoUod2NVYzl6IjK4mlb3SSis=; b=MyfGE+vmvcD2OCg7JJuYdkgS5M51hfHzoMJIz2eT+dY0ZEPUNcy4CNO5Tkj1KetBtF XTPz4cehwfKOTswjvWm6rplvD46NNR12an09R2VBtEwqCRUCxzE0bjyYWK0Kqf/+RpRg TGr2Pld5ltsnaS0obx8g5LDhjGBSWmSYN7zbCCFJrjHhpWalU8tzWcJwl0aVc65vFLKO nF3gurYHZ7K2lvFoPlN0Q7nAEpZjoGxL/6ja7J2xcxpHHkUtmGi+7+iLTWxi7dJ8Lemb gS79DzPmJu1lwwJvEK+aB1+cdLEPhEm9pNPTw0NXLG7yLgXJvk0R7ERmdkcP9d/odP2M texw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:sender:from:date:message-id:subject :to; bh=SrfCjpnrrHmC/vzr/aihoUod2NVYzl6IjK4mlb3SSis=; b=tK38B6kw1VUrR25FhKcARU1ectqA36/feOxgsTfNev6Gb5IbMTXjsdovRg31IiUKPc PRVC293LorNv678osDNZbcqlIihyBXGxXsjTpYxnwsUeTPg+SvMWkYln9YghUY2Pd/KW OXzEw1VeuRuUlPeTz0osgN6VEuze9j/M8yJAPmUpsWbqtxeV5ZSi01w2yMiwLatKfRrO ajs6fgghruwl1elc5b1Bn7hy0ieZvb8HzovKR345qkeASv8rEzpK5kFmGFyX4dWDwgCP P7zMCuqVsgQZ8OyiA7ykNYB81YgCF0R23CUfyWzFbk36w/v5LnIiGt4o3x6c5Km8XPmD xYkA== X-Gm-Message-State: AOAM53280VCE2jeY/9nBln+mLWW4aTo/Kc6kYWiq7ExkuepCpEwHTLd8 qQj4DB36gzU294O8DIZuF+BdRM+rePUy3otVRDvYmA1Zb6U= X-Google-Smtp-Source: ABdhPJz84+s7X0UzxNOdQVhWp8anIteMkkBOGMgWFsQjfBjEKGApTyB4kJIZ42LMe+YyTNd1xeodrCl0cZK13DGddrA= X-Received: by 2002:a25:76d0:: with SMTP id r199mr28776269ybc.266.1620080586724; Mon, 03 May 2021 15:23:06 -0700 (PDT) MIME-Version: 1.0 X-Google-Sender-Delegation: realneel@gmail.com From: learn orchids Date: Mon, 3 May 2021 15:22:56 -0700 X-Google-Sender-Auth: -HPSVb8Fi4S61IgOlHataV7Xu4s Message-ID: Subject: Bug: sqlite output truncated? To: emacs-orgmode@gnu.org Content-Type: multipart/alternative; boundary="000000000000e117d405c174677d" Received-SPF: pass client-ip=2607:f8b0:4864:20::b2c; envelope-from=learnorchids@gmail.com; helo=mail-yb1-xb2c.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 autolearn=ham autolearn_force=no X-Spam_action: no action X-Mailman-Approved-At: Mon, 03 May 2021 19:22:43 -0400 X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1620084207; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=SrfCjpnrrHmC/vzr/aihoUod2NVYzl6IjK4mlb3SSis=; b=mGq2TOjxQeLxjz3jfueMc4lER8slEPRAC01GtT7kH0CGLhPF3l2D0o25pGQBdezadGVxdA aQ5mnm+EGh5dPd9PLU7RdjkHXn6hmH3g8jpS4ALnn9eToja5A+V5QQRPKBq3UnD/Q+5oC6 aAkhvrDzOE8yL4FUg+Y5h0/f57JcvVJCIRXvCKW9IBXRt4B/3lQxLcUTUhvUFLpt1XRGlY UFLhUFvVPILoOCBQ5PXfCRNH6jEdt5uW8PyXb3ovaMfE1Aopn8LXhkr4z4+bM+xza5zdGz i6dCOeqq4nBRZlprUFUG/ocmqBVbG4UjSqRo/NcBzFBT1f7+FaCOfXys/R+nOw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1620084207; a=rsa-sha256; cv=none; b=nyXAqKtQ/FkuMjceJpbPAo5nrMSQruhi4dQMvC1Iz2YA87DWZVv4c0dzig9S0wmb+QSGxn OGlPbZ2MTFd3EZGIAaVrds9noLQnmlEKgr6KJZ522y7MpdK91tpOlNkOgTZ5IA0/8DiA8c M8e0tn2Ku76SH4L20QuZyAY4R5g9ISQUv3h6JsZxcHr9n++sTz4bkqf1vPD9oQ39ftYCI3 J6kZn4Pk4TKAL/3Kmq7LfS60voDWwy9A/eozeUV2N6KqokYFDaCgZ/pt/qJfrHfCUMBsOh s0C5kipG5uEHupI0jIASEExV3OWjZdJkRba98ndTK1e3vWE7w+W+CmSdyM0u9Q== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20161025 header.b=MyfGE+vm; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Spam-Score: -0.36 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20161025 header.b=MyfGE+vm; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: EA97326CC2 X-Spam-Score: -0.36 X-Migadu-Scanner: scn0.migadu.com X-TUID: iPcCX3+PeUcj --000000000000e117d405c174677d Content-Type: text/plain; charset="UTF-8" I am using Org mode version 9.4.5 (9.4.5-73-g4c7696-elpaplus and I have the following code snippet. Values in the 'sql' column of the second row is truncated. Am I missing something? #+begin_src sqlite :db /tmp/rip.db :colnames yes drop table if exists testtable; create table testtable(id int, sql varchar); insert into testtable values (1, "Select id from foo"); insert into testtable values (2, 'Select "id" from foo'); select* from testtable; #+end_src #+RESULTS: testsql | id | sql | |----+--------------------| | 1 | Select id from foo | | 2 | id | --000000000000e117d405c174677d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 
I am using Org mode version 9.4=
.5 (9.4.5-73-g4c7696-elpaplus and I have the following code snippet. Values=
 in the 'sql' column of the second row is truncated. Am I missing s=
omething?

#+begin_src sqlite :db /tmp/rip.db =C2=A0:colnames yes
=
=C2=A0 drop table if exists testtable;
=C2=A0 create table testtable(id =
int, sql varchar);
=C2=A0 insert into testtable values (1, "Select =
id from foo");
=C2=A0 insert into testtable values (2, 'Select =
"id" from foo');
=C2=A0 select* from testtable;
#+end_s=
rc

#+RESULTS: testsql
| id | sql =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0|
|----+--------------------|
| =C2=A01 | Sel=
ect id from foo |
| =C2=A02 | id =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 |
--000000000000e117d405c174677d--