[Monetdb-developers] TPC-H Query-14
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@alviss queries]$ mclient -lsql < 14.sql MAPI = monetdb@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@alviss queries]$
Why do I get an Exception when I got a result?
Regards, Romulo
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@alviss queries]$ mclient -lsql < 14.sql MAPI = monetdb@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@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
On 15-07-2010 19:27:55 +0200, Stefan Manegold wrote:
Why do I get an Exception when I got a result?
Indeed, that violates the protocol.
"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)
participants (3)
-
Fabian Groffen
-
Romulo Goncalves
-
Stefan Manegold