From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.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 0AvaIeVQ32RMFgEASxT56A (envelope-from ) for ; Fri, 18 Aug 2023 13:07:17 +0200 Received: from aspmx1.migadu.com ([2001:41d0:403:478a::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id SK2nIeVQ32SCxAAAauVa8A (envelope-from ) for ; Fri, 18 Aug 2023 13:07:17 +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 2F11E66BD2 for ; Fri, 18 Aug 2023 13:07:17 +0200 (CEST) Authentication-Results: aspmx1.migadu.com; dkim=none; 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=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=gmail.com (policy=none) ARC-Seal: i=1; s=key1; d=yhetil.org; t=1692356837; a=rsa-sha256; cv=none; b=FWzOBPFneM9oL+HhKwrvUagFK+ORixPmNE7GjgD+H8mKClO9rAvUaA7PZG7UmJm5w5sQzJ 5BFrDVVWS8rcPtfyC84BnstjF+WUomPcZk9EZxeQx31Gef5Cpfa25M57jkn41yvYPXwR7q aO06ryS5E3oAsE+p1WOwyXGMCkGFvuCgQ7dyyHCvqKeeMa026kSnU6+UEToCPBo5oDc6IE bNgOdjL4jr9/UQs8PwZUTRSEFrDGQNL7c1utisxjpmeTvF2z4O6dIAAhS1K5Wt3hnAY5I7 IPnIBDGGqQJVMkeDEQs1QhYp4as0S/YIGIC9+jx5Y6rwca/1zkjMBt1JEcyqRw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; 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=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=gmail.com (policy=none) ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1692356837; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post; bh=33okZbBGNPbkwQwmdLBAzjR4lLefihuCUol4Y77+9xs=; b=qNCO8iAUigaSPzxTye7XR7ixRktUnhvzb40+CKzA1U8n9HxNWdqyAq1+H9cnx8lmxK9EeF wic2Pf4bdyo381siaviAU+CP/iAAlSjPJ8Pr5W/AJ1iYIYbhBQgtlVBzsvpZmUbF4hyRyo JkFnFDWMpcJlVpO+V2awUm2XnYXvQfYvrsR/nIGy56ghdZh1pe4Cv7vofKh0xiy111GGon putXAppNOa0xz+IzpXve0++r7HAj6djwUEel08seIV7vowypDoJwb+9IijKL6zFOfDswzL LPQuHd0DhEymEFm9C7T83wUV6p8hSyjNy8wx3wDKwUiZ2bbA7sBsGG2TE1IWRw== Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1qWxJd-0007C6-5R; Fri, 18 Aug 2023 07:06:53 -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 1qWxJC-00076y-4M for emacs-orgmode@gnu.org; Fri, 18 Aug 2023 07:06:26 -0400 Received: from ciao.gmane.io ([116.202.254.214]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1qWxJA-00055A-27 for emacs-orgmode@gnu.org; Fri, 18 Aug 2023 07:06:25 -0400 Received: from list by ciao.gmane.io with local (Exim 4.92) (envelope-from ) id 1qWxJ7-0002XG-0U for emacs-orgmode@gnu.org; Fri, 18 Aug 2023 13:06:21 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: emacs-orgmode@gnu.org From: Max Nikulin Subject: Re: [BUG] ob-sqlite: can not override header argument Date: Fri, 18 Aug 2023 18:06:15 +0700 Message-ID: References: <87jzttpmux.fsf@localhost> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.14.0 Content-Language: en-US, ru-RU In-Reply-To: <87jzttpmux.fsf@localhost> Received-SPF: pass client-ip=116.202.254.214; envelope-from=geo-emacs-orgmode@m.gmane-mx.org; helo=ciao.gmane.io X-Spam_score_int: -5 X-Spam_score: -0.6 X-Spam_bar: / X-Spam_report: (-0.6 / 5.0 requ) BAYES_00=-1.9, DKIM_ADSP_CUSTOM_MED=0.001, FORGED_GMAIL_RCVD=1, FORGED_MUA_MOZILLA=2.309, FREEMAIL_FORGED_FROMDOMAIN=0.25, FREEMAIL_FROM=0.001, HEADER_FROM_DIFFERENT_DOMAINS=0.25, NICE_REPLY_A=-3.454, NML_ADSP_CUSTOM_MED=0.9, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no 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: -5.01 X-Migadu-Queue-Id: 2F11E66BD2 X-Migadu-Spam-Score: -5.01 X-TUID: 4oC8a9ETM09H 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. > Note that (member :csv others) yielding "" is also intentional because > it is already added by that time in %others. > > It is also documented to be the default: > > 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. I am not an active sqlite user and I am almost unfamiliar with its options, so I am unsure what is the best way to integrate sqlite into org-babel.