From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:8:6d80::]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id oLhdEhWSW2DZuAAAgWs5BA (envelope-from ) for ; Wed, 24 Mar 2021 20:25:09 +0100 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id IIULDhWSW2AwJgAAbx9fmQ (envelope-from ) for ; Wed, 24 Mar 2021 19:25:09 +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 BBCD42004E for ; Wed, 24 Mar 2021 20:25:08 +0100 (CET) Received: from localhost ([::1]:47782 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lP97r-0001vq-Up for larch@yhetil.org; Wed, 24 Mar 2021 15:25:07 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:56242) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lP973-0001vh-Sk for emacs-orgmode@gnu.org; Wed, 24 Mar 2021 15:24:17 -0400 Received: from mail-lj1-x233.google.com ([2a00:1450:4864:20::233]:39830) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1lP970-00073v-VY for emacs-orgmode@gnu.org; Wed, 24 Mar 2021 15:24:17 -0400 Received: by mail-lj1-x233.google.com with SMTP id u4so69548ljo.6 for ; Wed, 24 Mar 2021 12:24:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=HyFIqUKyWFDFSg06XMvlTGwSwA5wG5KjjkA8OR/CWjc=; b=UvDKKe4Z9wyi9acLVNksIJcnWI+HFUFxf8luz1QWx0CwDOfbQnR1A6t9b8NNKAvSUY oZ7dVZJ0az8R9hi+O61U9DkB3gaOq5W8k5YYEqSWnooeilZseqX4e5Oj3aK7vtUZUTSk FDi1J0GM8tBRwVxVYEiN02eIKGmMLidlzx/nMvwKrXXbhURErsk2M4l9G+yacHB6cIjj jMz6Enqozpy4O5cCEzgGRY6ENc8omoyXz30aw7dhockxIphwDtoBECxkd+MZBUNwFJ48 sXlIWRPwfTOQ8Gkw/4JoigV5IkBDkR/wHEW7gcx+eYIguJXZPD1OzJDcuBvQr1U6h/Qm nhsg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=HyFIqUKyWFDFSg06XMvlTGwSwA5wG5KjjkA8OR/CWjc=; b=Qlcqlce19e6vjyiBBWerRpag2pKqY6mnCzBzAOJEyBsmfRQAEdSN5xL+abqe61emcI rEXJJqbPFpyQ7U5mNpnIZoxM+P8vr/0+vasJMz1b4U9ey5vITO2Nx/fYzFnEwlXc0496 0ZvUszMOZe+9z6aIwIfAsy2Xu3pP07nQOuE1wsf99qrY2Rl1BJ6RYmQzeYFo26FSqXX+ DsKPS4MN2hN5nuFPrvfRCkeuhvw2MiVDFPSnuRfZsfdBGa/VK6QkTM20QF3Z7fuYi48J Zvq3vVsaRu0ybiC7voxsXPzxkRet4LvLKPVOspD5twxOyUFfNvgqD/I1iLsfsf6xzZ3W 56ZQ== X-Gm-Message-State: AOAM5327LJLJh4DwYAxLUmVtV1s9+abC9EbwcMMliA6vzGcjcH67dvZ2 1rikf/bKdPg6uI24fNyjM6lvueqgeuLUECaiIAK4l5KlFWqK0Q== X-Google-Smtp-Source: ABdhPJxYYvnlkLLMFj7QpidISP2hvlnrTs2sp0XYa7Ya5rnFMtnHFAR8l3gvrq5mYpxszINCAOrPF2aWSAv9CUUneYs= X-Received: by 2002:a2e:b52a:: with SMTP id z10mr2962488ljm.320.1616613852554; Wed, 24 Mar 2021 12:24:12 -0700 (PDT) MIME-Version: 1.0 From: Niall Dooley Date: Wed, 24 Mar 2021 19:23:36 +0000 Message-ID: Subject: Bug: 9.4.4 - ob-sql inserts page break (^L) in first cell of results table and truncates some column names To: emacs-orgmode@gnu.org Content-Type: multipart/alternative; boundary="0000000000006baaa505be4d3e62" Received-SPF: pass client-ip=2a00:1450:4864:20::233; envelope-from=dooleyn@gmail.com; helo=mail-lj1-x233.google.com 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, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, 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.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 ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1616613908; 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:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=HyFIqUKyWFDFSg06XMvlTGwSwA5wG5KjjkA8OR/CWjc=; b=Kud/WH5iBZRk224kBqFsbx6JzpswFcDwQfCof/x9GxxGg7Nx2yR9Z2bf1EJ/LJ30toJ5HF RAIXK1goG8vpIIq8HtSss0UxgsFM4YDEsw+bn8OfL2xw/hGUoXcbT5tnF7LbNyv+/flGAp kOwBeS7fNpIgk4iWSV0oiqEqRYXBSb1KRNJSDoN/PWyYubzEijnsgnYVuEtoN1bQF8JYPL /aodIpYUZ61zvjLaKcbBRm0jGEEoNhKpEs+nkK2S1Q2T7O7p0CAHZzO7bWN58WxIBThRyB 2qdCE3NfCKRUCp+IKZSYzx+6Ww893AqwL/QHToia++d877EZN3kMji65p1v6FA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1616613908; a=rsa-sha256; cv=none; b=rM3afcAowkvwjw1VmhoWcccfNMMdZgyEIrQ2xOLG/8nU7sH58CiTk21jv7jkfbedb4kzX6 6zSCjHHzpP1BajUYz/HgnZKGOuG+YgWgVvzi3j5ZSVYL8+p3wLEvbqa+1zAEMVYk/CUtsu 5K8BJQGz1tNUTn3QHpoV5p9fnYV899Te2gzMynOXfrdmOoLN4EANZLapC00CSaDdOk03AY oLtSrooZk2lLqCeAzGwUVyuR2sLQmhrgpZM9Sdt+Bj3MkzU4p9XlVn1Y5bVjx4LPhb0m6l 8rIu3PBCgZAOry4rZD3f1ZUf/1u96Fmtnm0opuspvpT7ls9VCsVtOqqnQ/9itw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=UvDKKe4Z; 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-Migadu-Spam-Score: -3.12 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=UvDKKe4Z; 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-Migadu-Queue-Id: BBCD42004E X-Spam-Score: -3.12 X-Migadu-Scanner: scn0.migadu.com X-TUID: Pwvis8y6MPP7 --0000000000006baaa505be4d3e62 Content-Type: text/plain; charset="UTF-8" Using ob-sql for the first time. It works great and I no longer need to deal with the ugly output from the SQL command line. However, I noted that after submitting a query the first cell (first column name) of the results table includes a page break (^L). I use the purcell/page-break-lines package [1] and this resulted in the table layout being distorted. Once I disabled that mode the table was no longer distorted but I could see the ^L in the first cell. I also noted that some column names are truncated. Oddily, it doesn not appear to be based on length as some that are truncated are very short only three characters yet others which are much longer are not. Thanks for your time. [1]: https://github.com/purcell/page-break-lines --0000000000006baaa505be4d3e62 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Using ob-sql for the first time.=C2=A0 It works great and = I no longer need to
deal with the ugly output from the SQL command line.=

However, I noted that after submitting a query the first cell (firs= t
column name) of the results table includes a page break (^L).=C2=A0 I = use the
purcell/page-break-lines package [1] and this resulted in the ta= ble
layout being distorted.=C2=A0 Once I disabled that mode the table wa= s no
longer distorted but I could see the ^L in the first cell.

I= also noted that some column names are truncated. Oddily, it doesn not
a= ppear to be based on length as some that are truncated are very short
only three characters yet others which are much longer are not.

Thanks for your time.

[1]: https://github.com/purcell/page-break= -lines --0000000000006baaa505be4d3e62--