|Subject:||Re: [O] Fwd: bug with org-babel/sqlite?|
|Date:||Thu, 15 Sep 2016 06:14:19 +0000|
Not sure if you have subscribed to the org mode mailing list. If not, you would not have received this reply. So forwarding that to you.---------- Forwarded message ---------
From: Nick Dokos <address@hidden>
Date: Wed, Sep 14, 2016, 5:18 PM
Subject: Re: [O] Fwd: bug with org-babel/sqlite?
To: <address@hidden>Kaushal Modi <address@hidden> 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 <address@hidden>
> Date: Wed, Sep 14, 2016 at 10:08 AM
> Subject: bug with org-babel/sqlite?
> To: address@hidden <address@hidden>
> 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.
> Kaushal Modi
Changing the CSV file slightly gets rid of the problem:
| #+BEGIN_SRC csv :tangle sample1.csv
| 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
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.
|[Prev in Thread]||Current Thread||[Next in Thread]|