On Mon, Jul 21, 2008 at 10:07:04AM -0400, James Leigh wrote:
On Wed, 2008-07-16 at 18:04 +0200, Niels Nes wrote:
(ps72) throws a "Query did not produce a result set" in MonetDB?
No I don't. Could you try to run the queries with out java, ie simply using mclient -lsql?
Niels
Here you can see that the "exec 0();" command works before a table is created, but is lost once a table is created.
sql>prepare select 0; sql>exec 0(); +--------------+ | single_value | +==============+ | 0 | +--------------+ sql>create table blah(blah integer); sql>exec 0(); sql>prepare select 1; sql>exec 0(); +--------------+ | single_value | +==============+ | 1 | +--------------+
Good catch. The problem is indeed that the query and prepared statement cache is cleaned after an 'schema' statement. A simple reorder of the code should help. A better error message should afcourse be given. A more flexible prepare/execute scheme could be a nice feature request. Niels -- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl