Re: [O] Fwd: bug with org-babel/sqlite?

[Dushyant Juneja]

Thanks, Kaushal for forwarding me the reply. Indeed, I was not on the list. I have requested a subscription now, nevertheless.

Hi Nick,

Yes. That seems to help. However, I suspect the bug is with ob-sqlite rather than sqlite itself. If I do the following directly in sqlite3 terminal, it seems to work just fine:

119 $ sqlite3

SQLite version 3.7.11 2012-03-20 11:35:50

Enter ".help" for instructions

Enter SQL statements terminated with a ";"

sqlite> .mode csv

sqlite> create table foo(Year,Make,Model,Description,Price);

sqlite> .import sample1.csv foo

sqlite> select * from foo;

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

Given that SQL is hence able to treat it properly, it looks like the bug lies with ob-sqlite wrongly interpreting the newline.

Dushyant

On Thu, Sep 15, 2016 at 6:32 AM Kaushal Modi <address@hidden> wrote:

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>
>
> 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

--

Kaushal Modi