On Thu, Jul 15, 2010 at 07:03:51PM +0200, Romulo Goncalves wrote: > Hello, > > I am running TPC-H in the default version, updated 1 minute ago. > Compilation in Debug mode and I am running in my Desktop at CWI. > > I loaded TPC-H SF-10 without constraints. > > [gonca...@alviss queries]$ mclient -lsql < 14.sql > MAPI = mone...@localhost:55000 > QUERY = select > ERROR = !SQLException:convert:too many digits (20 > 19) > #select * from optimizer_stats() stats; > % .stats, .stats # table_name > % rewrite, count # name > % clob, int # type > % 7, 1 # length > [ "joinidx", 0 ] > [gonca...@alviss queries]$ > > > Why do I get an Exception when I got a result?
"overflow" in decimal representation of intermediate result --- a known issue with TPCH Q14 with SF >=10 when using decimals in your schema (using floats or doubles, instead, would avoid the overflow, but provides less numerical accuracy) Stefan > Regards, > Romulo > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > _______________________________________________ > Monetdb-developers mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-developers > > -- | Dr. Stefan Manegold | mailto:[email protected] | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 | ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
