From mboxrd@z Thu Jan  1 00:00:00 1970
From: Gary Oberbrunner <garyo@oberbrunner.com>
Subject: sql can't export an empty table, gives error
Date: Tue, 23 Dec 2014 17:34:09 -0500
Message-ID: <CAFChFyh_Yd2XPSS9izyo95g23cKgGpTpHp4KrXXqgA2wpbbJoQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary=001a11c33fcc084a89050ae9c62c
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:57352)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <garyo@oberbrunner.com>) id 1Y3Y1z-0003aj-VE
	for emacs-orgmode@gnu.org; Tue, 23 Dec 2014 17:34:27 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <garyo@oberbrunner.com>) id 1Y3Y1r-00046q-PY
	for emacs-orgmode@gnu.org; Tue, 23 Dec 2014 17:34:19 -0500
Received: from mail-lb0-f177.google.com ([209.85.217.177]:55312)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <garyo@oberbrunner.com>) id 1Y3Y1r-00046d-IE
	for emacs-orgmode@gnu.org; Tue, 23 Dec 2014 17:34:11 -0500
Received: by mail-lb0-f177.google.com with SMTP id b6so6037583lbj.36
	for <emacs-orgmode@gnu.org>; Tue, 23 Dec 2014 14:34:09 -0800 (PST)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Orgmode Mailing List <emacs-orgmode@gnu.org>

--001a11c33fcc084a89050ae9c62c
Content-Type: text/plain; charset=UTF-8

If you try to export this document:

#+BEGIN_SRC sql :exports both
 select 1 limit 0;
#+END_SRC

It fails to export with an error in *Messages*:
 user-error: Empty table - created default table
It also stops processing the document at that point.
(That SQL code produces no output but is not a SQL error.)

I'd prefer if it would just leave that empty (missing) table out, and keep
going.  Is there any way to do that?

-- 
Gary

--001a11c33fcc084a89050ae9c62c
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">If you try to export this document:<div><br></div><div><di=
v>#+BEGIN_SRC sql :exports both</div><div>=C2=A0select 1 limit 0;</div><div=
>#+END_SRC</div><div><br></div><div>It fails to export with an error in *Me=
ssages*:</div><div>=C2=A0user-error: Empty table - created default table<br=
></div><div>It also stops processing the document at that point.</div><div>=
(That SQL code produces no output but is not a SQL error.)</div><div><br></=
div><div>I&#39;d prefer if it would just leave that empty (missing) table o=
ut, and keep going.=C2=A0 Is there any way to do that?</div><div><br></div>=
-- <br><div class=3D"gmail_signature">Gary</div>
</div></div>

--001a11c33fcc084a89050ae9c62c--