October 2013 - users-list

new "too many digits" bug in SP-4
by Anthony Damico 03 Oct '13

03 Oct '13

this issue is new for SP-4 ..i have been using this syntax for a long time and never encountered this problem until the upgrade :( > dbGetQuery( db , "select ( sum( ( bene_sex_ident_cd = 1 ) ) ) / ( count( * ) ) as pct_male from x11" ) pct_male 1 0 > dbGetQuery( db , "select ( sum( ( bene_sex_ident_cd = 1 ) )*1.000 ) / ( count( * )*1.000 ) as pct_male from x11" ) Error in .local(conn, statement, ...) : Unable to execute statement 'select ( sum( ( bene_sex_ident_cd = 1 ) )*1.000 ) / ( count( * )*1.000 ) as pct_male from x11'. Server says 'too many digits (19 > 18)' [#22003]. > what diagnostics can i run for you to troubleshoot this? thanks!! :)

2 7

Bug with fetching EXPLAIN results in Python DBAPI driver.
by Pete Hollobon 03 Oct '13

03 Oct '13

Hi, I spotted a bug in the Python DBAPI driver when fetching results from an EXPLAIN. >>> import monetdb.sql >>> db = monetdb.sql.connect(database="demo") >>> cursor = db.cursor() >>> cursor.execute("explain select count(*) from sys.tables") 31 >>> cursor.fetchone() Traceback (most recent call last): File "<stdin>", line 1, in <module> File "monetdb/sql/cursors.py", line 203, in fetchone result = self.__rows[self.rownumber - self.__offset] IndexError: list index out of range >>> I've logged a bug with patches for Python 2 and 3 here: http://bugs.monetdb.org/show_bug.cgi?id=3380 thanks, Pete.

1 0

Static binary compilation
by Hassan, Ahmad 01 Oct '13

01 Oct '13

Hi, May be someone has tried compiling monetdb as a static binary please? I tried compiling the binary using -static flag but the resulting binary is still 'Dynamically linked' binary. I think it is due to glibc and dl libraries. If I pass libglibc.a and libdl.a statically then I get errors like: ============= /tmp/mserver5-rkIbiC.o: In function `mdlopen': /data/ahmad/test/MonetDB/gdk/gdk_posix.c:454: warning: Using 'dlopen' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking /usr/lib/x86_64-linux-gnu/libreadline.a(complete.o): In function `rl_username_completion_function': (.text+0x2bc9): warning: Using 'getpwent' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking ... /data/ahmad/test/MonetDB/common/stream/stream.c:1765: warning: Using 'gethostbyname' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking ============= Does anyone know the workaround of creating static binary of monetdb executable please? Cheers, Ahmad

2 1