From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id gNMGKF7MvV4iXgAA0tVLHw (envelope-from ) for ; Thu, 14 May 2020 22:55:26 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id IDnnI17MvV4sDwAA1q6Kng (envelope-from ) for ; Thu, 14 May 2020 22:55:26 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 24EF6940415 for ; Thu, 14 May 2020 22:55:26 +0000 (UTC) Received: from localhost ([::1]:50198 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jZMlB-00089k-2v for larch@yhetil.org; Thu, 14 May 2020 18:55:25 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:41984) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jZMkj-00089X-1Z for emacs-orgmode@gnu.org; Thu, 14 May 2020 18:54:57 -0400 Received: from mail-qt1-x835.google.com ([2607:f8b0:4864:20::835]:40596) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1jZMki-0008DF-2P for emacs-orgmode@gnu.org; Thu, 14 May 2020 18:54:56 -0400 Received: by mail-qt1-x835.google.com with SMTP id c24so361925qtw.7 for ; Thu, 14 May 2020 15:54:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:date:message-id:mime-version; bh=bo4HKWDlw1TaMq2B/WlZVK1no1TCcGYTsL/ZUbhemo8=; b=iu9W6F7UDBgLYty0oFqSqimbYzoDrX6Vdz3nMVmGk/0/z0PEBGugrtSlWrMJPb7MUk EPqmwwU9q4pfihSUrvtjJCZllvE7aL/yBko42guCxv8oJOQaadOVJ9xKwcPCwHpfQZZE rjjj2CMdxgixkzzguORahJ5ZeUazETqOiEdpYSLONvMKM1me5NbUrg/fdG/16Xq7XSaR PXy4tmi03HfrncqcD1KcHc/7O98wgEpaVVCIxEh7FuNWXJXKDD4ZZ77SnDX7gUfJqRoR w+YW4oWf7wF05+BkqDtvSD0fozRI/1oCSPJzxSy08MdQDHAony5bFzIvdrt2XUOHwvxn KGTg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:date:message-id:mime-version; bh=bo4HKWDlw1TaMq2B/WlZVK1no1TCcGYTsL/ZUbhemo8=; b=Y2EXahcM8nCDUZ4AUjaEd7UwodKF5gQLGE3hFZ6jqL864qTg8jHMK8Xkf696JFRTyZ E85fjvc1YW8SPnxLnzho++99lavoZH0HMQ5ARVT1R5uo1/uryPmAZti3BfOXtxtUbRSx 2+r1M8aRXyyHWe5NZNq7S7OnhFGQxidOFBI9mluGz4jgYx0/2DKMZ9guY4B9GmQtjmz8 lX8qS8GunVhXMSvjGgCvKyi5o51ZtAjcMhFe2SU18Hu6/S0a4EjaPGke4Q/L5PEtyKE9 6Ygb5symdHUkfDCwxmbFA5MocIFkk8kfxMoFre1U0AEgSK6t53vQd5vvMu4IS6v+1hv9 NPwg== X-Gm-Message-State: AOAM532Te8EJPb7uMkaMacfO67iUQPg4I/9qHXwYGK76UyImFZ1eiO3a IkyPD2XEUvYRmE7+bQF5j9DLRveW X-Google-Smtp-Source: ABdhPJygTPVBt8bI/rWWVe8wj4CwmiZDeC7d79RmabsbeIV1VQMJHU1O9cZ2nda839yRRP0wQpQExQ== X-Received: by 2002:ac8:4e44:: with SMTP id e4mr556466qtw.326.1589496894210; Thu, 14 May 2020 15:54:54 -0700 (PDT) Received: from sacsa.n800.arm.processor.yandex.fm ([190.236.255.69]) by smtp.gmail.com with ESMTPSA id 74sm248407qkm.40.2020.05.14.15.54.51 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 14 May 2020 15:54:53 -0700 (PDT) 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 Message-ID: <86y2pub006.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2607:f8b0:4864:20::835; envelope-from=rrandresf@gmail.com; helo=mail-qt1-x835.google.com X-detected-operating-system: by eggs.gnu.org: No matching host in p0f cache. That's all we know. X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001 autolearn=_AUTOLEARN X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=iu9W6F7U; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: 3.79 X-TUID: pMATbyYnqJOe 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) )