From: rrandresf@gmail.com
To: emacs-orgmode@gnu.org
Subject: Bug: issue with babel and sqlite [9.3 (release_9.3 @ /usr/share/emacs/27.0.91/lisp/org/)]
Date: Thu, 14 May 2020 22:54:49 +0000 [thread overview]
Message-ID: <86y2pub006.fsf@gmail.com> (raw)
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)
)
next reply other threads:[~2020-05-14 22:55 UTC|newest]
Thread overview: 5+ messages / expand[flat|nested] mbox.gz Atom feed top
2020-05-14 22:54 rrandresf [this message]
2020-09-05 7:33 ` Bug: issue with babel and sqlite [9.3 (release_9.3 @ /usr/share/emacs/27.0.91/lisp/org/)] Bastien
2020-09-06 10:00 ` Bastien
2020-09-07 4:04 ` andrés ramírez
2020-09-07 4:38 ` Bastien
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=86y2pub006.fsf@gmail.com \
--to=rrandresf@gmail.com \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.