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 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 > Date: Wed, Sep 14, 2016, 5:18 PM > Subject: Re: [O] Fwd: bug with org-babel/sqlite? > To: > > > 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 > > > -- > > Kaushal Modi >