From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id 6EMeFQIqwF9PEgAA0tVLHw (envelope-from ) for ; Thu, 26 Nov 2020 22:19:46 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id WKzqEAIqwF9IZAAAbx9fmQ (envelope-from ) for ; Thu, 26 Nov 2020 22:19:46 +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 CF151940485 for ; Thu, 26 Nov 2020 22:19:45 +0000 (UTC) Received: from localhost ([::1]:58992 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kiPc7-0007Mz-8a for larch@yhetil.org; Thu, 26 Nov 2020 17:19:43 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:52788) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kiO9r-0004qN-BM for emacs-orgmode@gnu.org; Thu, 26 Nov 2020 15:46:30 -0500 Received: from mail-out-4.itc.rwth-aachen.de ([2a00:8a60:1:e501::5:49]:63537) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kiO9k-00005H-7E for emacs-orgmode@gnu.org; Thu, 26 Nov 2020 15:46:25 -0500 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: =?us-ascii?q?A2BzEQC8EsBf/6EagoZiHQEBPAEFBQECA?= =?us-ascii?q?QkBFYFRgVCBTVhfhD2QeAicVgsBAQEBAQEBAQEIASMKAgQBAYZ0AiU4EwIQAQE?= =?us-ascii?q?GAQEBAQEGBIZSDIYcFTZAAh8HAkkWDQgBAYMiAYMGAQ6vMoEyhVeDOYE8BgkBg?= =?us-ascii?q?QQqAYZohlcPgU0/gREnDIMjgQSBWQSCKoJKgl8EkEyDKIdLgRybWywHgWOBDoE?= =?us-ascii?q?SBAuHdoZpix8FKZJYjzkLhXiYZpVmAgICAgkCFYFtgXozGiRPgmpPFwINji0MC?= =?us-ascii?q?xSIToVEQjI3AgYKAQEDCXyPWAEB?= X-IPAS-Result: =?us-ascii?q?A2BzEQC8EsBf/6EagoZiHQEBPAEFBQECAQkBFYFRgVCBTVh?= =?us-ascii?q?fhD2QeAicVgsBAQEBAQEBAQEIASMKAgQBAYZ0AiU4EwIQAQEGAQEBAQEGBIZSD?= =?us-ascii?q?IYcFTZAAh8HAkkWDQgBAYMiAYMGAQ6vMoEyhVeDOYE8BgkBgQQqAYZohlcPgU0?= =?us-ascii?q?/gREnDIMjgQSBWQSCKoJKgl8EkEyDKIdLgRybWywHgWOBDoESBAuHdoZpix8FK?= =?us-ascii?q?ZJYjzkLhXiYZpVmAgICAgkCFYFtgXozGiRPgmpPFwINji0MCxSIToVEQjI3AgY?= =?us-ascii?q?KAQEDCXyPWAEB?= X-IronPort-AV: E=Sophos;i="5.78,373,1599516000"; d="scan'208";a="91316151" Received: from rwthex-s3-b.rwth-ad.de ([134.130.26.161]) by mail-in-4.itc.rwth-aachen.de with ESMTP; 26 Nov 2020 21:46:10 +0100 Received: from [IPv6:2a02:908:1081:ee60:9eb6:d0ff:fed4:99d3] (2a02:908:1081:ee60:9eb6:d0ff:fed4:99d3) by rwthex-s3-b.rwth-ad.de (2a00:8a60:1:e500::26:161) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.2044.4; Thu, 26 Nov 2020 21:46:09 +0100 To: Subject: Bug: ob-sql fails to work with other source code blocks if result contains quotes [9.4 (9.4-44-g5272d9-elpa @ /home/philipp/.emacs.d/elpa/org-20201123/)] From: Philipp Uhl Message-ID: <97dfc87b-9748-a5e2-cf4d-1aa78451607c@rwth-aachen.de> Date: Thu, 26 Nov 2020 20:46:09 +0000 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.12.0 MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit Content-Language: de-DE X-Originating-IP: [2a02:908:1081:ee60:9eb6:d0ff:fed4:99d3] X-ClientProxiedBy: rwthex-s2-a.rwth-ad.de (2a00:8a60:1:e500::26:154) To rwthex-s3-b.rwth-ad.de (2a00:8a60:1:e500::26:161) Received-SPF: pass client-ip=2a00:8a60:1:e501::5:49; envelope-from=philipp.uhl@rwth-aachen.de; helo=mail-out-4.itc.rwth-aachen.de X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-Mailman-Approved-At: Thu, 26 Nov 2020 17:13:21 -0500 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-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -2.26 X-Scanner: ns3122888.ip-94-23-21.eu Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; 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-TUID: gI8useNN9Pqf 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. ------------------------------------------------------------------------ When SQL output contains " than, JS code blocks don't work. This works: #+NAME: test #+BEGIN_SRC sql select '1' #+END_SRC #+BEGIN_SRC js :var test=test return test #+END_SRC #+RESULTS: | 1 | This does not: #+NAME: test #+BEGIN_SRC sql select '"1"' #+END_SRC #+BEGIN_SRC js :var test=test return test #+END_SRC #+RESULTS: It results in this error: /tmp/babel-vaAbSc/js-script-GZW7OY:2 var test=[[#("\"1\"" 0 3 (face font-lock-string-face))]]; ^ SyntaxError: Invalid or unexpected token at wrapSafe (node:internal/modules/cjs/loader:999:16) at Module._compile (node:internal/modules/cjs/loader:1047:27) at Object.Module._extensions..js (node:internal/modules/cjs/loader:1112:10) at Module.load (node:internal/modules/cjs/loader:948:32) at Function.Module._load (node:internal/modules/cjs/loader:789:14) at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:72:12) at node:internal/main/run_main_module:17:47 The expanded code looks like this: var test=[[#("\"1\"" 0 3 (face font-lock-string-face))]]; return test I should mention, that, in order to make JS output as a result work at all, I have this in my config (but I don't think, it is related to this bug): Fix issue with javascript output due to depricated use of "sys" package #+BEGIN_SRC emacs-lisp (setq org-babel-js-function-wrapper "process.stdout.write(require('util').inspect(function(){\n%s\n}(), { maxArrayLength: null, maxStringLength: null, breakLength: Infinity, compact: true }))") #+END_SRC The bug does not appear when using e.g. python. With best regards, Philipp Uhl Emacs : GNU Emacs 27.1 (build 1, x86_64-pc-linux-gnu, GTK+ Version 3.24.22, cairo version 1.17.3) of 2020-08-28 Package: Org mode version 9.4 (9.4-44-g5272d9-elpa @ /home/philipp/.emacs.d/elpa/org-20201123/)