January 2006 - developers-list

[Monetdb-developers] SQL/JDBC: autocommit state
by Andrei Martsinchyk 30 Jan '06

30 Jan '06

Hi All, I have almost filed a bug, but noticed [ 1394298 ] SQL: auto commit state is not changed correctly on commit<https://sourceforge.net/tracker/index.php?func=detail&aid=1394298&group_id=…> so I decided to discuss the problem here first. My JDBC-based application stopped working with MonetDB 4.10.0/sql 2.10.0, while it works OK with Postgres backend and it used to work with MonetDB 4.9.3/sql 2.9.3. It output "commit does not allowed in autocommit mode" exceptions. However, I am sure that application handles transaction itself, that is setAutoCommit(false) is called immediately after connection is established and the connections are never return to autocommit mode. I investigated and found out that connection is switched to autocommit mode after commit() is called. I think server should not switch to autocommit mode after java.sql.Connection.commit() or java.sql.Connection.rollback(). Though this is not explicitly defined by JDBC specs, as far as I know all JDBC drivers work in this way, so it is standard de-facto. Therefore I suggest to revert the change. -- Best regards, Andrei Martsinchyk mailto:andrei.martsinchyk@gmail.com

2 1

[Monetdb-developers] ☆らぶともメール☆のご案内 -28
by info＠bananalove.info 26 Jan '06

26 Jan '06

$B:#(B10$BBe!A(B30$BBe$N=w@-$KBg?M5$$J$N$,!V$i$V$H$b%a!<%k!W$G$9!#(B $BK\5$$J=w$N;R$,B?$$$N$G!"??LLL\$J5$;}$A$G;22C$7$F$/$@$5$$!#(B $B:#$J$i!o(B5000$BJ,$N%]%$%s%H$,L5NA$G$9!#(B $B$40FFb@h"-(B http://bananalove.info/lvtm/ $BG[?.ITMW$NJ}$O%3%A%i$^$G(B refusal(a)ok.kz

1 0

[Monetdb-developers] Update and verify your information
by Scotiabank 26 Jan '06

26 Jan '06

1 0

[Monetdb-developers] SQL:2003 OLAP/windowing functions?
by Andrew Piskorski 25 Jan '06

25 Jan '06

Hello, I believe MonetDB/SQL does not currently support the SQL:2003 OLAP (aka, windowing) functions. Do you have any plans to add such support, or thoughts on how to do so? Coul this support be added via MIL, and if so how difficult do you think that would be? E.g., is it something that a dedicated end-user/devloper might plausibly attempt, or would it require deep knowledge of and hacking on the MonetDB core itself? These windowing functions were added as an amendement to the SQL:1999 spec, and SQL:2003 includes that, I think as features T611, "Elementrary OLAP functions" and T612, "Advanced OLAP functions". Apparently Fred Zemke of Oracle was the author of those SQL specs, and IBM also supported it, so the SQL:2003 syntax and behavior is probably identical to what Oracle and DB2 already have. PostgreSQL 8.0 doesn't yet support it, and I don't know if/when they plan to. Oracle calls this their "analytic" SQL functions, and has had it starting in 8i with improvements in 9i. I've used it extensively on Oracle, and although its syntax seems kind of klunky and non-intuitive, the functionality is EXTREMELY useful. Here are a bunch of links about the SQL OLAP/windowing functions: http://www.wintercorp.com/rwintercolumns/SQL_99snewolapfunctions.html http://www.ncb.ernet.in/education/modules/dbms/SQL99/OLAP-99-154r2.pdf http://www.wiscorp.com/sql/SQL2003Features.pdf http://troels.arvin.dk/db/rdbms/#select-limit-offset http://www.postgresql.org/docs/8.0/interactive/features.html http://en.wikipedia.org/wiki/SQL http://www.sigmod.org/sigmod/record/issues/0403/E.JimAndrew-standard.pdf http://www.oracle.com/oramag/oracle/01-jul/o41industry.html And here are a few more examples of using it. "lead" and "lag" are just the beginning, there is more. I find "dense_rank" particularly useful: http://www.mail-archive.com/sqlite-users@sqlite.org/msg08223.html http://www.mail-archive.com/sqlite-users@sqlite.org/msg10855.html -- Andrew Piskorski <atp(a)piskorski.com> http://www.piskorski.com/

2 1

[Monetdb-developers] FYI: only Fedore Core RPMs for upcoming MonetDB 4.10 release
by Stefan Manegold 22 Jan '06

22 Jan '06

Dear all, I just wanted to let you now that the only binary RPMs we will provide with the upcoming MonetDB 4.10 release will be made on Fedora Core 4 systems. On all other machines that we currently use with RPM-bases systems (SuSE, SLES & RHEL), too many tools are missing to build a full-fledged source distribution and/or all RPMs. We might consider having these machines upgraded *after* the initial release. Stefan -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@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-4312 |

2 1

[Monetdb-developers] Feature Freeze!
by Stefan Manegold 21 Jan '06

21 Jan '06

Dear all, to ensure smooth processing in the final stages before we will release MonetDB 4.10 (hopefully on Monday), I now declare a Feature Freeze i.e., as of now, no more checkin sare allowed to *development trunks* of any the MonetDB related repositories on SF (buildtools, MonetDB, sql, pathfinder), unless they are bug fixes! I plan to fork-off the new release branches later tonight or tomorrow. I let you know, once I'm done with that. *Only then*, you may again check-in new features to the *development trunks*; *all* bugfixes must then go to the new release branches. Thanks you very much for your cooperation. Regards, Stefan ps: Your well come to take your share of the following tasks: 1) Take care of all open bugs and fix them: https://sourceforge.net/tracker/index.php?func=browse&group_id=56967&atid=4… 2) Re-check all bug reports that are set to "pending" and add proper test scripts for them: https://sourceforge.net/tracker/index.php?func=browse&group_id=56967&atid=4… If you do so, please let me know! Thanks in advance! -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@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-4312 |

1 1

Fwd: * Re: * [Monetdb-developers] MonetDB on FreeBSD?
by Arnoud Vermeer 20 Jan '06

20 Jan '06

Hi, I've included the full alarm.glue.c in the following url: http://www.freshway.biz/files/MonetDB-alarm.glue.c.txt I hope it helps. Thanks, Arnoud

3 9

Re: * [Monetdb-developers] MonetDB on FreeBSD?
by Stefan Manegold 20 Jan '06

20 Jan '06

> > > configure: WARNING: sys/file.h: present but cannot be compiled > > > configure: WARNING: sys/file.h: check for missing prerequisite > > headers? > > > configure: WARNING: sys/file.h: see the Autoconf documentation > > > configure: WARNING: sys/file.h: section "Present But Cannot Be > > Compiled" > > > > > > configure: WARNING: sys/file.h: proceeding with the preprocessor's > > result > > > configure: WARNING: sys/file.h: in the future, the compiler will take > > > precedence > > > configure: WARNING: ## ------------------------------------------ ## > > > > > configure: WARNING: ## Report this to the AC_PACKAGE_NAME lists. ## > > > configure: WARNING: ## ------------------------------------------ ## > > > > are these the only error messages you get from configure? > > yes, I've seen them before at other compiles to. Does compile most of the > time, inspite of the error. yes. I actually don't think that these are the reason for the errors you get. first was, that MonetDB requires GNU make instead of BSD make. That's solved. > The gmake fails: > standard ./configure (same output as in earlier posted version) > gmake > gmake.txt > gmake console output > gmake_console.txt > > Adding --enable-bits=64 to the ./configure doesn't change the output. > > http://www.freshway.biz/files/MonetDB-gmake.txt > http://www.freshway.biz/files/MonetDB-gmake_console.txt > > Any ideas? not really. I'm a bit scared by all the "overriding commands for target" messages, but the real problems seems to be this: ======= In file included from stream.mx:264: /usr/include/netinet/ip.h:49: error: syntax error before "u_int" /usr/include/netinet/ip.h:148: error: syntax error before "u_char" /usr/include/netinet/ip.h:200: error: syntax error before "u_char" stream.mx: In function ocket_open': stream.mx:1198: error: P_TOS' undeclared (first use in this function) stream.mx:1198: error: (Each undeclared identifier is reported only once stream.mx:1198: error: for each function it appears in.) gmake[4]: *** [libstream_la-stream.lo] Error 1 gmake[3]: *** [all] Error 2 gmake[2]: *** [all-recursive] Error 1 gmake[1]: *** [all-recursive] Error 1 gmake: *** [all] Error 2 ======== I recall that there were some changes/fixes related to FreeBSD, which might not be in the release tarball ("MonetDB-4.8.2.tar.gz"). But we are about to release MonetDB 4.10 on Monday; hence, could you download the latest release candidate "MonetDB-4.9.3.tar.gz" from http://monetdb.cwi.nl/testing/projects/monetdb/Current/.DailyBuilds./Source… and check whether this works (better)? Stefan > Greetings, > > Arnoud Vermeer > FreshWay Innovations -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@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-4312 |

2 1

Re: * [Monetdb-developers] MonetDB on FreeBSD?
by Stefan Manegold 19 Jan '06

19 Jan '06

Arnoud, which version of gcc are you using? `gcc --version` Stefan On Thu, Jan 19, 2006 at 10:57:58PM +0100, Arnoud Vermeer wrote: > Hi Stefan, > > In the new version, I've got a new error. The gmake command lasts longer > though, so I guess the previous problem was fixed in the newer version. > > This is the current error I get at a standard ./configure && gmake > > /bin/sh ../../../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. > -I../../.. -I. -I../../common -I../../gdk -I../../monet -DLIBALARM > -g -O2 -std=c99 -Wall -W -fno-strict-aliasing > -Werror-implicit-function-declaration -Werror -Wno-unused-function > -Wno-unused-label -D_REENTRANT -c -o lib_alarm_la-alarm.glue.lo `test -f ' > alarm.glue.c' || echo './'`alarm.glue.c > gcc -DHAVE_CONFIG_H -I. -I. -I../../.. -I. -I../../common -I../../gdk > -I../../monet -DLIBALARM -g -O2 -std=c99 -Wall -W -fno-strict-aliasing > -Werror-implicit-function-declaration -Werror -Wno-unused-function > -Wno-unused-label -D_REENTRANT -c alarm.glue.c -fPIC -DPIC -o > .libs/lib_alarm_la-alarm.glue.o > alarm.glue.c: In function `CMDctime_unpack559103634': > alarm.glue.c:185: warning: assignment discards qualifiers from pointer > target type > gmake[4]: *** [lib_alarm_la-alarm.glue.lo] Error 1 > gmake[4]: Leaving directory `/usr/home/funzoneq/MonetDB-4.9.3 > /src/modules/plain' > gmake[3]: *** [check] Error 2 > gmake[3]: Leaving directory `/usr/home/funzoneq/MonetDB-4.9.3 > /src/modules/plain' > gmake[2]: *** [check-recursive] Error 1 > gmake[2]: Leaving directory `/usr/home/funzoneq/MonetDB-4.9.3/src/modules' > gmake[1]: *** [check-recursive] Error 1 > gmake[1]: Leaving directory `/usr/home/funzoneq/MonetDB-4.9.3/src' > gmake: *** [check-recursive] Error 1 > > I also get a lot of overrides from rpm.mk, but that doesn't concern me that > much hence FreeBSD doesn't know rpm's. It seems the new error is located in > alarm.glue.c. > Although I have had a small bit of experience with C++ programming (first > year student Information Sciences at Windesheim College, Zwolle, The > Netherlands), I don't have a clue what the error means. > > Do you have any clue? > > Thanks, > > Arnoud Vermeer > > On 1/19/06, Stefan Manegold <Stefan.Manegold(a)cwi.nl> wrote: > > > > > > > configure: WARNING: sys/file.h: present but cannot be compiled > > > > > configure: WARNING: sys/file.h: check for missing prerequisite > > > > headers? > > > > > configure: WARNING: sys/file.h: see the Autoconf documentation > > > > > configure: WARNING: sys/file.h: section "Present But Cannot Be > > > > Compiled" > > > > > > > > > > configure: WARNING: sys/file.h: proceeding with the preprocessor's > > > > result > > > > > configure: WARNING: sys/file.h: in the future, the compiler will > > take > > > > > precedence > > > > > configure: WARNING: ## > > ------------------------------------------ ## > > > > > > > > > configure: WARNING: ## Report this to the AC_PACKAGE_NAME > > lists. ## > > > > > configure: WARNING: ## > > ------------------------------------------ ## > > > > > > > > are these the only error messages you get from configure? > > > > > > yes, I've seen them before at other compiles to. Does compile most of > > the > > > time, inspite of the error. > > > > yes. I actually don't think that these are the reason for the errors you > > get. > > > > first was, that MonetDB requires GNU make instead of BSD make. That's > > solved. > > > > > The gmake fails: > > > standard ./configure (same output as in earlier posted version) > > > gmake > gmake.txt > > > gmake console output > gmake_console.txt > > > > > > Adding --enable-bits=64 to the ./configure doesn't change the output. > > > > > > http://www.freshway.biz/files/MonetDB-gmake.txt > > > http://www.freshway.biz/files/MonetDB-gmake_console.txt > > > > > > Any ideas? > > > > not really. > > > > I'm a bit scared by all the "overriding commands for target" messages, but > > the real problems seems to be this: > > ======= > > In file included from stream.mx:264: > > /usr/include/netinet/ip.h:49: error: syntax error before "u_int" > > /usr/include/netinet/ip.h:148: error: syntax error before "u_char" > > /usr/include/netinet/ip.h:200: error: syntax error before "u_char" > > stream.mx: In function ocket_open': > > stream.mx:1198: error: P_TOS' undeclared (first use in this function) > > stream.mx:1198: error: (Each undeclared identifier is reported only once > > stream.mx:1198: error: for each function it appears in.) > > gmake[4]: *** [libstream_la-stream.lo] Error 1 > > gmake[3]: *** [all] Error 2 > > gmake[2]: *** [all-recursive] Error 1 > > gmake[1]: *** [all-recursive] Error 1 > > gmake: *** [all] Error 2 > > ======== > > > > I recall that there were some changes/fixes related to FreeBSD, which > > might > > not be in the release tarball ("MonetDB-4.8.2.tar.gz"). > > > > But we are about to release MonetDB 4.10 on Monday; > > hence, could you download the latest release candidate " > > MonetDB-4.9.3.tar.gz" > > from > > http://monetdb.cwi.nl/testing/projects/monetdb/Current/.DailyBuilds./Source… > > and check whether this works (better)? > > > > Stefan > > > > > Greetings, > > > > > > Arnoud Vermeer > > > FreshWay Innovations > > > > -- > > | Dr. Stefan Manegold | mailto:Stefan.Manegold@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-4312 | > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@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-4312 |

1 1

[Monetdb-developers] MonetDB on FreeBSD?
by Arnoud Vermeer 19 Jan '06

19 Jan '06

Hello, I'm trying to compile MonetDB on FreeBSD 5.4. The machine is a dell single xeon EMT64 3.0 ghz with 2 gb of memory. The ./configure works just fine. I've included the output in configure.txt It does however put out the following text: configure: WARNING: sys/file.h: present but cannot be compiled configure: WARNING: sys/file.h: check for missing prerequisite headers? configure: WARNING: sys/file.h: see the Autoconf documentation configure: WARNING: sys/file.h: section "Present But Cannot Be Compiled" configure: WARNING: sys/file.h: proceeding with the preprocessor's result configure: WARNING: sys/file.h: in the future, the compiler will take precedence configure: WARNING: ## ------------------------------------------ ## configure: WARNING: ## Report this to the AC_PACKAGE_NAME lists. ## configure: WARNING: ## ------------------------------------------ ## When I try to run make, it returns the following error: "Makefile", line 981: Could not find ./*.mk "Makefile", line 982: Could not find ./*.mk make: fatal errors encountered -- cannot continue It is these two lines in the Makefile: include $(top_srcdir)/*.mk include $(top_builddir)/*.mk when I ls src/* I get no *.mk just: Makefile Makefile.am <http://makefile.am/> Makefile.msc gdk mel monet tools Makefile.ag <http://makefile.ag/> Makefile.in <http://makefile.in/> common mapi modules testing utils Includes: http://www.freshway.biz/files/MonetDB-configure.txt http://www.freshway.biz/files/MonetDB-makefile.txt Can anybody help me further along? Kind regards, Arnoud Vermeer FreshWay Innovations The Netherlands

3 4