[Monetdb-developers] TPC-H Query-14

Stefan Manegold Stefan.Manegold at cwi.nl
Thu Jul 15 19:27:55 CEST 2010


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.
> 
> [goncalve at alviss queries]$ mclient -lsql < 14.sql
> MAPI  = monetdb at 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	]
> [goncalve at 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
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers
> 
> 

-- 
| Dr. Stefan Manegold | mailto:Stefan.Manegold at cwi.nl |
| 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       |




More information about the developers-list mailing list