From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:403:478a::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms9.migadu.com with LMTPS id CKTIDSZT32SPMQEASxT56A (envelope-from ) for ; Fri, 18 Aug 2023 13:16:54 +0200 Received: from aspmx1.migadu.com ([2001:41d0:403:478a::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id eFe1DCZT32R0IwEAG6o9tA (envelope-from ) for ; Fri, 18 Aug 2023 13:16:54 +0200 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 8469E673BD for ; Fri, 18 Aug 2023 13:16:53 +0200 (CEST) Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=posteo.net header.s=2017 header.b=Zt0YERPK; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=none) header.from=posteo.net ARC-Seal: i=1; s=key1; d=yhetil.org; t=1692357414; a=rsa-sha256; cv=none; b=IxT5HsqH/ZIChq/o9EZyyJFj3z2dsLS+VVeW/mvqvty1ZqybYQrgLw6bI4rbqY5k3aa46W Qe6Yf1MJKqyRmglX3NcpwTbOe4o6qaU4rR994ArZ8DauRv2WHzSwIvfx5eSpJyj47jKlQ8 O40hj7I0uWqqvWNw9kubusIcPlzqpWS+/GeasI7iSPWas3l6rA9v8bhvRZnoZsNrJJVVVw sQ14T+2xrvlZYcEYFoRPy2A89SjBf35QQR8pDZTBV1/HpetDrKkqBIkXgzgg8b6vYKHDNO 5LCHJi6UJPN4lnjBd/3svwIweWhQxTWINwwodB41pc3F7uscQNhZxsRuAqbhDw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=posteo.net header.s=2017 header.b=Zt0YERPK; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=none) header.from=posteo.net ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1692357414; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=xb0/bscecGJ5iSdLv0lCpzPu4pAom8QymAxveVkHrR0=; b=WIX1TbLJSc69txfVHFFa8s9SBfZOj2LtwWaFQ0S4LIJNEBIuoqMtkno2DvY0zoVXpNLUEk JA4tGsIS4swYlODuFUkDRoDwiNQFm5oOQjzOKTFjPU3RYCfBZnJ+ZPX4FI+bo+SftqyF2H 2Yw5It3GuDyDTsdyEJZKDI0vVnhtEM5aglL42tJZsoQ9yO5FByfM9P4XqFfsOK+b9qFZJQ kUvoi/bwjC44sieqUieKkzmk0h4HCwLg79FkoWGtSYO6xPOJxOzaMQ3QXgX966T/+eg1w3 Am4EajmX6QgYn4tj/F4SIuJPuPaTEsQKdqALzdifXJ25qg1QAujzqgpUWebepg== Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1qWxST-0001b9-KJ; Fri, 18 Aug 2023 07:16:01 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1qWxSH-0001Z5-Lk for emacs-orgmode@gnu.org; Fri, 18 Aug 2023 07:15:51 -0400 Received: from mout01.posteo.de ([185.67.36.65]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1qWxSE-0000Rn-9X for emacs-orgmode@gnu.org; Fri, 18 Aug 2023 07:15:48 -0400 Received: from submission (posteo.de [185.67.36.169]) by mout01.posteo.de (Postfix) with ESMTPS id 74DDD240027 for ; Fri, 18 Aug 2023 13:15:42 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017; t=1692357342; bh=N7xjpkD8JOuq0qTHTHA2f0GEe90EptBj2DjqezQttAA=; h=From:To:Cc:Subject:Date:Message-ID:MIME-Version:From; b=Zt0YERPK+vSh5OmuaZ07DiSXmivjc2HZrLKZ2mBHJtyITZ+pUw/6e0sraVakVRp92 OlRA21250Ptvk8zk6Rm6c5uNxSsBbF2/iZG4a7HLW/zbQLgkzMcAQl6oSVaqLPEO2Z 7tKOxFEJKG1Sd4PCaSU9rGLsmBLU59GiY9HZHML57AkO87+PtkTDR+A6u5Bnp7D2mK 2dMuZrj48FogynfaqmpAwteVO4cKcTerSDEPAIqtR0yKzYERvhNZ/3ifJDRo5PdQZe bhb+k3kzEJQSyipXEZI91fHUvm5rD23ECkpII6ZTck0hOzjCh3ByivHzevRZUOPfhW bTe/Tr+SD87lQ== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4RRznT6YRXz9rxB; Fri, 18 Aug 2023 13:15:41 +0200 (CEST) From: Ihor Radchenko To: Max Nikulin Cc: emacs-orgmode@gnu.org Subject: Re: [BUG] ob-sqlite: can not override header argument In-Reply-To: References: <87jzttpmux.fsf@localhost> Date: Fri, 18 Aug 2023 11:16:11 +0000 Message-ID: <87lee838jo.fsf@localhost> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=185.67.36.65; envelope-from=yantar92@posteo.net; helo=mout01.posteo.de X-Spam_score_int: -43 X-Spam_score: -4.4 X-Spam_bar: ---- X-Spam_report: (-4.4 / 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, RCVD_IN_DNSWL_MED=-2.3, RCVD_IN_MSPIKE_H5=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 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-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US X-Migadu-Scanner: mx0.migadu.com X-Spam-Score: -8.89 X-Migadu-Queue-Id: 8469E673BD X-Migadu-Spam-Score: -8.89 X-TUID: g5Vk6LUpO3q+ Max Nikulin writes: > On 18/08/2023 01:03, Ihor Radchenko wrote: >> The source says >> >> ;; for easy table parsing, default header type should be -csv >> >> So, it is at least intentional. > > With ":results verbatim" it is not convincing. Maybe. But not a bug either. I am also not a user of ob-sqlite, so I am not in position to judge what is better. My current stance is not to touch the working code. If there are any users of ob-sqlite, I invite them to chime in, if they have an opinion. >> csv >> the default SQLite output format for Babel SQLite source code blocks. > > I do not try to dispute that it is default. The issue is that ":csv no" > is not supported. It is at least not intuitive that to disable :csv and > to activate :separator it is necessary to add :list. So the effect of > sqlite3 command line options differs from the effect of ob-sqlite header > arguments. Sure. But it is not exactly a bug as well. I would accept patches that will allow disabling these header arguments, if someone is bothered enough to submit them. Handled. We can continue the discussion though. -- Ihor Radchenko // yantar92, Org mode contributor, Learn more about Org mode at . Support Org development at , or support my work at