From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id 2DInBT2IkGD/JgEAgWs5BA (envelope-from ) for ; Tue, 04 May 2021 01:33:17 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id 0A7kAD2IkGAANAAAB5/wlQ (envelope-from ) for ; Mon, 03 May 2021 23:33:17 +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 8A37D26EFD for ; Tue, 4 May 2021 01:33:16 +0200 (CEST) Received: from localhost ([::1]:48160 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1ldi3v-0000xj-N0 for larch@yhetil.org; Mon, 03 May 2021 19:33:15 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:40888) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ldi35-0000vW-Js for emacs-orgmode@gnu.org; Mon, 03 May 2021 19:32:23 -0400 Received: from out5-smtp.messagingengine.com ([66.111.4.29]:56323) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ldi33-0000CA-Pn for emacs-orgmode@gnu.org; Mon, 03 May 2021 19:32:23 -0400 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.nyi.internal (Postfix) with ESMTP id 481F45C0150 for ; Mon, 3 May 2021 19:32:19 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Mon, 03 May 2021 19:32:19 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=VOPRsU Xw1UKQalQ/Rz91CDaoWxBJAtR/DfCVIev1bns=; b=MHmYNVqesQFh3q3exQXDXS EdncNONMrDIscdl5dL9lrWmHhxtj7Yfum1zabP1tQifdgoUDYJlNCYT86nFqqJkN 5PLpG70boLmid3Z7HXxUJ+tDUFrEcsE5gbpq8mUUKgTL4d8EIg4OCQ0Xvrppmv9M 7AYNXXdiWOgKumU5ZDkILNfZR23Jae3bEHaYbQbHSy/sSCNbov4yzyEo7Eu+zIaw Dwq9XDSz5yAOiJebQTzCOgP7iEDbsz19f4O9FKJMGBOcmXuEiGel37Rjz1vYA9PR TAm5+aZ5LcYie1FgOPTTt4ErL/kui4MZcuwEdk1S1SQurZI9HxVheP5Fs8AiaaKQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrvdefhedgvdefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefuvfhfhffkffgfgggjtgesrgdtre ertdefjeenucfhrhhomheppfhitghkucfurghvrghgvgcuoehnihgtkhesnhhitghkshgr vhgrghgvrdgtrgeqnecuggftrfgrthhtvghrnhephfdufedtheffieevhfdvtdffteegud egtdeigeeggeeflefftddthffgieeujeeunecukfhppedujeegrdelfedrudeihedrudef necuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepnhhitg hksehnihgtkhhsrghvrghgvgdrtggr X-ME-Proxy: Received: from [192.168.0.67] (bras-base-aylmpq0104w-grc-46-174-93-165-13.dsl.bell.ca [174.93.165.13]) by mail.messagingengine.com (Postfix) with ESMTPA for ; Mon, 3 May 2021 19:32:18 -0400 (EDT) Subject: Re: Bug: sqlite output truncated? To: emacs-orgmode@gnu.org References: X-Woof-Bug: : confirmed From: Nick Savage Message-ID: <69793036-939e-a95d-8ea8-91c0ce0306fb@nicksavage.ca> Date: Mon, 3 May 2021 19:32:18 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------24737F257CC435B314A2A3BD" Content-Language: en-US Received-SPF: none client-ip=66.111.4.29; envelope-from=nick@nicksavage.ca; helo=out5-smtp.messagingengine.com X-Spam_score_int: -25 X-Spam_score: -2.6 X-Spam_bar: -- X-Spam_report: (-2.6 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=0.001, NICE_REPLY_A=-0.001, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H4=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_PASS=-0.001, SPF_NONE=0.001 autolearn=ham autolearn_force=no X-Spam_action: no action 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=1620084796; 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:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=VOPRsUXw1UKQalQ/Rz91CDaoWxBJAtR/DfCVIev1bns=; b=YeK4UvvHwNDs8OmyZM7bpakz036nZBfhHEq9TJpk4WdxBP/0m7AIIXz2fRg0WIJnZTCO68 kK5LCzMwudIbXdusut10gSa8B9lYQjSJxqtYhBCVuFsbprkkmxNjy8vYIFLAqspH/CaG5X /+aq59a29LHOm4HSYAirqSOjwwOhSfw18/lTyidSOsZcNIlftJMcOsUSuty8h4pwZKpdER mD+Sw1G8L8i0sY/1YBP8G/9JIApVw3qeMRtK+bmsavZ8v/yJ530c3qcooIDgQ6AxCJ0BjR jISF1mOH3HI9wY28oAo3X0Na7WaDULI/NnkAd6sUdBVx43VW+i4UW40gXFuviw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1620084796; a=rsa-sha256; cv=none; b=Gk3rXITicScygKm+uiNjfeWtZ7RHaPO6V6kyms/jWgl2PF7vaL0dysfaJU3pmjT7shA+Iq mpUsvm7aOlyzcVSn5S4asn4+rKV3iAwVglohAjNmAjL2VM6AurmP01bqr+W6RHAN8fXrGc 80haUbg2wO+0rRdlw6u6v46U0PjGg5F5rlE3l/W+AZT4ToRZ2dDHS5FdVLtG1hDH0K1Cem spcj8rhYf2W1C7IaGoZbJjZ6jA5PNVsgNxpCedP03fRf1qvo3C8CnaaGOEzjPdPx7Vo+7Z ajeEtQkKxVZD5PbSoDkHYpADxodwAI+SUq0eUsxToyU9UMvyFfN3/GliCEotQQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=messagingengine.com header.s=fm2 header.b=MHmYNVqe; 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: -1.66 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=messagingengine.com header.s=fm2 header.b=MHmYNVqe; dmarc=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: 8A37D26EFD X-Spam-Score: -1.66 X-Migadu-Scanner: scn0.migadu.com X-TUID: Fo3dNp4X2TXq This is a multi-part message in MIME format. --------------24737F257CC435B314A2A3BD Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit I can replicate this, it looks like a bug to me. Looks to me that there's something wrong with the way it is handling single quoted strings, since the output is only what is within the double quoted strings. I will take a stab at fixing this. On 5/3/21 6:22 PM, learn orchids wrote: > 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                 | --------------24737F257CC435B314A2A3BD Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

I can replicate this, it looks like a bug to me.

Looks to me that there's something wrong with the way it is handling single quoted strings, since the output is only what is within the double quoted strings. I will take a stab at fixing this.

On 5/3/21 6:22 PM, learn orchids wrote:
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                 |
--------------24737F257CC435B314A2A3BD--