Re: A strange problem with org-babel and SQLite

[Robert Klein <roklein@roklein.de>]

Hi Cecil,


On Fri, 31 Aug 2018 12:24:33 +0200
Cecil Westerhof <cldwesterhof@gmail.com> wrote:

> 2018-08-31 11:17 GMT+02:00 Robert Klein <roklein@roklein.de>:
> 
> > Hi Cecil,
> >
> > On Fri, 31 Aug 2018 10:47:50 +0200
> > Cecil Westerhof <cldwesterhof@gmail.com> wrote:
> >  
> > > I have a strange problem with org-babel and SQLite.
> > >
> > > I have a database that is created with:
> > >     CREATE TABLE "quotes" (
> > >         quoteID         TEXT           PRIMARY KEY,
> > >         quote           TEXT NOT NULL  UNIQUE,
> > >         lastUsed        TEXT,
> > >         totalUsed       INT  DEFAULT 'unused'
> > >     )
> > >
> > > When using:
> > >     #+BEGIN_SRC sqlite :db ~/Twitter/twitter.sqlite :colnames yes
> > >     SELECT   lastUsed
> > >     ,        totalUsed
> > >     FROM     quotes
> > >     ORDER BY lastused  ASC
> > >     ,        totalUsed DESC
> > >     LIMIT    40
> > >     #+END_SRC
> > >
> > > Everything is fine. But when I use (add the quote field in the
> > > select): #+BEGIN_SRC sqlite :db
> > > ~/Twitter/twitter.sqlite :colnames yes SELECT   quote
> > >     ,        lastUsed
> > >     ,        totalUsed
> > >     FROM     quotes
> > >     ORDER BY lastused  ASC
> > >     ,        totalUsed DESC
> > >     LIMIT    40
> > >     #+END_SRC
> > >
> > > I get:
> > >     executing Sqlite code block...
> > >     Wrote /tmp/babel-27920y_/ob-input-2792BTG
> > >     org-babel-read: End of file during parsing
> > >
> > > What could be the problem?
> > >  
> >
> > does it work outside of org/babel/emacs, that is, when you use the
> > query in a command line sqlite session, does it work?  “quote” is
> > also a function in sqlite, so this might be your issue.
> >  
> 
> Yes, in sqlite3 and sqlitebrowser it works without problems.
> In org-babel even 'SELECT *' goes wrong.
> 

I can't reproduce the issue, it works for me.  What are your org-mode
and Emacs versions?

Can you provide an ECM (Example, complete, minimal) org-mode setup /
Emacs initialization file?

Best regards
Robert