On Sat, Apr 14, 2007 at 09:32:24AM -0700, Colin Foss wrote: > This is strange. Using MonetDB4 this script ran > without error, in MonetDB5 I get this error: > > QUERY = copy INTO my_big_table FROM > 'E:/data/migrate/big_table_input-ab.tab' > ERROR = !MALException:batmtime.EQ:Unexpected input > type
sounds like a bug. Which version of M5/sql are you using? The fact that it runs fine on M4 and in 2 runs indicates that it maybe related too one of the m5 optimizers. These can be controlled using the optimizer session variable. See http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Optimizer-Control.html#Optimizer-Control for more information. Niels > > always on the second input file. > > Here is my script: > ------------------------------------- > set SCHEMA myschema; > declare fname varchar(100); > delete from my_big_table; > > -- this one is good > set fname='big_table_input-aa.tab'; > select fname as phase; > COPY into my_big_table from > 'E:/data/migrate/big_table_input-aa.tab' using > delimiters '\t','\n'; > > -- this one will error > set fname='big_table_input-ab.tab'; > select fname as phase; > COPY into my_big_table from > 'E:/data/migrate/big_table_input-ab.tab' using > delimiters '\t','\n'; > > select 'total amount' as phase; > select count(*) from my_big_table; > ------------------------------------- > > Yet, if I run the files one at a time, the will each > load without error. > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > MonetDB-users mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/monetdb-users -- 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: [EMAIL PROTECTED] ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/monetdb-users
