From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nick Dokos Subject: Re: Fwd: bug with org-babel/sqlite? Date: Wed, 14 Sep 2016 17:16:47 -0400 Message-ID: <87zinaxjuo.fsf@gmail.com> References: Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:47992) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bkHYa-0001DN-16 for emacs-orgmode@gnu.org; Wed, 14 Sep 2016 17:17:25 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bkHYU-0006qv-7e for emacs-orgmode@gnu.org; Wed, 14 Sep 2016 17:17:22 -0400 Received: from [195.159.176.226] (port=50410 helo=blaine.gmane.org) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bkHYU-0006qO-0y for emacs-orgmode@gnu.org; Wed, 14 Sep 2016 17:17:18 -0400 Received: from list by blaine.gmane.org with local (Exim 4.84_2) (envelope-from ) id 1bkHYK-00022p-C9 for emacs-orgmode@gnu.org; Wed, 14 Sep 2016 23:17:08 +0200 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org Kaushal Modi writes: > Hi Dushyant, > > The folks following the org mailing list might be able to help you out on this. So I am forwarding this > email there. > > I haven't tried recreating this as I do not use sqlite. > > But when you say that in the case where you use the default :results sqlite doesn't work, what doesn't > work? Do you get an error? > > ---------- Forwarded message --------- > From: Dushyant Juneja > Date: Wed, Sep 14, 2016 at 10:08 AM > Subject: bug with org-babel/sqlite? > To: help-gnu-emacs@gnu.org > > Hi, > > Looks like I stumbled upon a bug with org-babel and sqlite. I have the > following in my org file. PFA the bug description (bug.org). The essence is > that sqlite queries work with :results verbatim, but not otherwise. Any > ideas on how to get past this? > > This is with emacs 24.5.2, RHEL6. > > Dushyant > -- > > Kaushal Modi > > Changing the CSV file slightly gets rid of the problem: ,---- | #+BEGIN_SRC csv :tangle sample1.csv | Year,Make,Model,Description,Price | 1997,Ford,E350,"ac, abs, moon",3000.00 | 1999,Chevy,"Venture ""Extended Edition""","",4900.00 | 1999,Chevy,"Venture ""Extended Edition, Very Large""",,5000.00 | 1996,Jeep,Grand Cherokee,"MUST SELL! air, moon roof, loaded",4799.00 | #+END_SRC `---- ^ The CSV file had a newline ^here. If you eliminate the newline, things work as they should. Whether that's a bug in ob-sqlite or sqlite itself, I have no idea. -- Nick