[MonetDB-users] 'create table as select...' from union queries doesn't work
Hi, If I do this: create table t1 (f1 int); create table t2 (f1 int); create table t_union as (select f1 from t1 union all select f1 from t2) with data; Then no table is created and no exception is thrown. Should I open a bug for this? (AugSP2 on Windows) -- View this message in context: http://old.nabble.com/%27create-table-as-select...%27-from-union-queries-doe... Sent from the monetdb-users mailing list archive at Nabble.com.
On Wed, Nov 25, 2009 at 09:41:29AM -0800, Alex Bo. wrote:
Hi,
If I do this:
create table t1 (f1 int); create table t2 (f1 int); create table t_union as (select f1 from t1 union all select f1 from t2) with data;
Then no table is created and no exception is thrown. Should I open a bug for this?
(AugSP2 on Windows)
just tested on linux Nov2009 release and that doesn't have this problem Niels
-- View this message in context: http://old.nabble.com/%27create-table-as-select...%27-from-union-queries-doe... Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room C0.02/M3.46, phone ++31 20 592-4098 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
participants (2)
-
Alex Bo. -
Niels Nes