Bug: issue with babel and sqlite [9.3 (release_9.3 @ /usr/share/emacs/27.0.91/lisp/org/)]

Bug: issue with babel and sqlite [9.3 (release_9.3 @ /usr/share/emacs/27.0.91/lisp/org/)]

[rrandresf]

Remember to cover the basics, that is, what you expected to happen and
what in fact did happen.  You don't know how to make a good report?  See

     https://orgmode.org/manual/Feedback.html#Feedback

Your bug report will be posted to the Org mailing list.
------------------------------------------------------------------------
Hi. I am testing the pretest. And I have try the snippet below on emacs -Q

1. M-x find-file ~/borrame.org
2. cp content below to borrame.org buffer:
--8<---------------cut here---------------start------------->8---
* on a terminal on your HOME evalute (C-c C-c) the blocks below sequentially from top to bottom
#+BEGIN_SRC emacs-lisp
(when (fboundp 'org-babel-do-load-languages)
    (org-babel-do-load-languages
     (quote org-babel-load-languages)
     (quote ((emacs-lisp . t)
             (sqlite . t)
	     )))
    )
(shell-command-to-string "sqlite3 ~/my_timelines.sqlite3 'CREATE TABLE IF NOT EXISTS time_lines (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, title varchar(255));'")
#+END_SRC

** this subtree works as expected
#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
INSERT INTO time_lines values(1, 'simple tiny note' );
#+END_SRC

#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
select * from time_lines;
#+END_SRC

** this subtree create three colums
#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
INSERT INTO time_lines values(2, 'an issue|problem with table rendering' );
#+END_SRC

#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
-- note the three colums on the table
select * from time_lines;
#+END_SRC

** this subtree generates an errro
#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
INSERT INTO time_lines values(3, '{
"id": 0
"value": 1
}');
#+END_SRC

#+BEGIN_SRC sqlite :db ~/my_timelines.sqlite3 :colnames yes
-- this generates an "org-babel-read: End of file during parsing" because of the inserted json
select * from time_lines;
#+END_SRC
--8<---------------cut here---------------end--------------->8---

Best

Emacs  : GNU Emacs 27.0.91 (build 1, armv7l-unknown-linux-gnueabihf, X toolkit, Xaw3d scroll bars)
Package: Org mode version 9.3 (release_9.3 @ /usr/share/emacs/27.0.91/lisp/org/)

current state:
==============
(setq
 org-cycle-hook '(org-cycle-hide-archived-subtrees org-cycle-show-empty-lines
		  org-optimize-window-after-visibility-change)
 org-archive-hook '(org-attach-archive-delete-maybe)
 org-agenda-before-write-hook '(org-agenda-add-entry-text)
 org-link-elisp-confirm-function 'yes-or-no-p
 org-babel-pre-tangle-hook '(save-buffer)
 org-occur-hook '(org-first-headline-recenter)
 org-mode-hook '(#[0 "\300\301\302\303\304$\207"
		   [add-hook change-major-mode-hook org-show-all append local]
		   5]
		 #[0 "\300\301\302\303\304$\207"
		   [add-hook change-major-mode-hook org-babel-show-result-all
		    append local]
		   5]
		 org-babel-result-hide-spec org-babel-hide-all-hashes)
 org-speed-command-hook '(org-speed-command-activate
			  org-babel-speed-command-activate)
 org-metaup-hook '(org-babel-load-in-session-maybe)
 org-bibtex-headline-format-function #[257 "\300\236A\207" [:title] 3 "\n\n(fn ENTRY)"]
 org-confirm-shell-link-function 'yes-or-no-p
 org-clock-out-hook '(org-clock-remove-empty-clock-drawer)
 org-link-shell-confirm-function 'yes-or-no-p
 org-tab-first-hook '(org-babel-hide-result-toggle-maybe
		      org-babel-header-arg-expand)
 org-link-parameters '(("attachment" :follow org-attach-open-link :export
			org-attach-export-link :complete
			org-attach-complete-link)
		       ("id" :follow org-id-open)
		       ("eww" :follow eww :store org-eww-store-link)
		       ("rmail" :follow org-rmail-open :store
			org-rmail-store-link)
		       ("mhe" :follow org-mhe-open :store org-mhe-store-link)
		       ("irc" :follow org-irc-visit :store org-irc-store-link
			:export org-irc-export)
		       ("info" :follow org-info-open :export org-info-export
			:store org-info-store-link)
		       ("gnus" :follow org-gnus-open :store
			org-gnus-store-link)
		       ("docview" :follow org-docview-open :export
			org-docview-export :store org-docview-store-link)
		       ("bibtex" :follow org-bibtex-open :store
			org-bibtex-store-link)
		       ("bbdb" :follow org-bbdb-open :export org-bbdb-export
			:complete org-bbdb-complete-link :store
			org-bbdb-store-link)
		       ("w3m" :store org-w3m-store-link) ("file+sys")
		       ("file+emacs") ("shell" :follow org-link--open-shell)
		       ("news" :follow
			#[257 "\301\300\302Q!\207" ["news" browse-url ":"] 5
			  "\n\n(fn URL)"]
			)
		       ("mailto" :follow
			#[257 "\301\300\302Q!\207" ["mailto" browse-url ":"]
			  5 "\n\n(fn URL)"]
			)
		       ("https" :follow
			#[257 "\301\300\302Q!\207" ["https" browse-url ":"]
			  5 "\n\n(fn URL)"]
			)
		       ("http" :follow
			#[257 "\301\300\302Q!\207" ["http" browse-url ":"] 5
			  "\n\n(fn URL)"]
			)
		       ("ftp" :follow
			#[257 "\301\300\302Q!\207" ["ftp" browse-url ":"] 5
			  "\n\n(fn URL)"]
			)
		       ("help" :follow org-link--open-help)
		       ("file" :complete org-link-complete-file)
		       ("elisp" :follow org-link--open-elisp)
		       ("doi" :follow org-link--open-doi))
 org-src-mode-hook '(org-src-babel-configure-edit-buffer
		     org-src-mode-configure-edit-buffer)
 org-confirm-elisp-link-function 'yes-or-no-p
 org-metadown-hook '(org-babel-pop-to-session-maybe)
 )

Re: Bug: issue with babel and sqlite [9.3 (release_9.3 @ /usr/share/emacs/27.0.91/lisp/org/)]

[Bastien]

Hi,

rrandresf@gmail.com writes:

> Hi. I am testing the pretest. And I have try the snippet below on
> emacs -Q

Thanks for reporting this.

Can you instrument the `org-babel-read' function?

You can do this with C-h f org-babel-read RET and then C-u C-M-x
on the function's definition.

Then run your code and see where `org-babel-read' exactly fail at
parsing.

Thanks,

-- 
 Bastien

Re: Bug: issue with babel and sqlite [9.3 (release_9.3 @ /usr/share/emacs/27.0.91/lisp/org/)]

[Bastien]

Hi,

I fixed this with commit ec80dd6c in the maint branch.

Thanks,

-- 
 Bastien

Re: Bug: issue with babel and sqlite [9.3 (release_9.3 @ /usr/share/emacs/27.0.91/lisp/org/)]

[andrés ramírez]

Hi Bastien. Thanks for fixing this.

>>>>> "Bastien" == Bastien  <bzg@gnu.org> writes:


[...]


    Bastien> Can you instrument the `org-babel-read' function?

I have done. But It has not failed with 27.1.

    Bastien> You can do this with C-h f org-babel-read RET and then C-u C-M-x on the function's
    Bastien> definition.

Best Regards

Re: Bug: issue with babel and sqlite [9.3 (release_9.3 @ /usr/share/emacs/27.0.91/lisp/org/)]

[Bastien]

andrés ramírez <rrandresf@gmail.com> writes:

> Hi Bastien. Thanks for fixing this.

Okay, thanks for confirming!

-- 
 Bastien