- developers-list - monetdb.org

[Monetdb-developers] a problem
by wuxiaobing 09 Jul '12

09 Jul '12

hi I hava a problem with my MonetDB. I want to visit MonetDB from other machines, that the document told us to set mapi_open=yes,but I do not know how to set it on windows. thank you for answer me. 2012-07-06 wuxiaobing

2 1

Re: [Monetdb-developers] MonetDB: holindex - Change L1 cache size into the number of inte...
by Stefan Manegold 25 Jun '12

25 Jun '12

On Mon, Jun 25, 2012 at 02:53:54PM +0200, Eleni Petraki wrote: > Changeset: f52327015707 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f52327015707 > Modified Files: > monetdb5/extras/crackers/crackers_selecthol_ops.mx > Branch: holindex > Log Message: > > Change L1 cache size into the number of integers that fit into L1. > > > diffs (12 lines): > > diff --git a/monetdb5/extras/crackers/crackers_selecthol_ops.mx b/monetdb5/extras/crackers/crackers_selecthol_ops.mx > --- a/monetdb5/extras/crackers/crackers_selecthol_ops.mx > +++ b/monetdb5/extras/crackers/crackers_selecthol_ops.mx > @@ -306,7 +306,7 @@ createView: > bit copy=TRUE; > > int countBatElements; > - int L1=8192; /*KiloBytes*/ > + int L1=2048000; /*Number of integers that can fit into L1 cache (size: 8192KB)*/ Wow --- which CPU has 8 MB L1(!) cache? > /*k and randomoid are used for DD1R*/ > @1 k,temp_h; > _______________________________________________ > Checkin-list mailing list > Checkin-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/checkin-list > > -- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

1 0

[Monetdb-developers] ODBC driver
by Max Kad 25 Jun '12

25 Jun '12

Hi Guys, I've installed MonetDB yesterday on Ubuntu 11.10 and it seems working fine. I've 2 questions though: 1) I'm trying to install MonetDB ODBC driver for UnixODBC following the instructions at (http://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/ODBC ) but for some reason I can't find the Monet ODBC libMonetODBC.so or libMonetODBCs.so driver. ( I found the following files: libmonetdb5.so.11, libmonetdb5.so.11.0.2 but I'm not sure what they are for. ) 2) Are there similar Date functions available on MonetDB as the following MySQL functions: UNIX_TIMESTAMP(), DATE() ) or an epoch function. I couldn't find it on the following link. ( http://www.monetdb.org/Documentation/SQLreference/Temporal ) Thanks in advance, Max

2 1

[Monetdb-developers] ODBC driver
by Max Kad 23 Jun '12

23 Jun '12

Hi Guys, I've installed MonetDB yesterday on Ubuntu 11.10 and it seems working fine. I've 2 questions though: 1) I'm trying to install MonetDB ODBC driver for UnixODBC following the instructions at ( http://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/ODBC ) but for some reason I can't find the Monet ODBC libMonetODBC.so or libMonetODBCs.so driver. ( I found the following files: libmonetdb5.so.11, libmonetdb5.so.11.0.2 but I'm not sure what they are for. ) 2) Are there similar Date functions available on MonetDB as the following MySQL functions: UNIX_TIMESTAMP(), DATE() ) or an epoch function. I couldn't find it on the following link. ( http://www.monetdb.org/Documentation/SQLreference/Temporal ) Thanks in advance, Max

1 0

[Monetdb-developers] Announcement: New Apr2012-SP2 Bugfix release of MonetDB suite
by Sjoerd Mullender 19 Jun '12

19 Jun '12

The MonetDB team at CWI/MonetDB BV is pleased to announce the Apr2012-SP2 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at <http://www.monetdb.org/>. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Apr 2012-SP2 bugfix release Client Package * Resolved a cosmetical error where tab-characters would cause misalignments in tabular result views. For the time being, tabs are now represented as a single space in tabular view. MonetDB Common * Limit number of detected CPU cores to 16 on 32-bits systems to avoid running quickly out of addressable resources followed by a kill from the OS. Bug Fixes * 2594: NULL cannot automatically be casted to every other type * 3085: assertion fails upon execution of a valid SQL query * 3086: Modulo function does not work in select from table * 3087: query causes "Not yet implemented" message * 3089: mserver5 crashed if join condition has two column and incorrect order * 3090: crashed if using single identifier for where condition * 3096: Type of median error

1 0

Re: [Monetdb-developers] MonetDB: default - attempt to more thoroughly remove opt_accessmode
by Sjoerd Mullender 14 Jun '12

14 Jun '12

On 2012-06-14 10:16, Fabian Groffen wrote: > Changeset: af264c7d6966 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=af264c7d6966 > Modified Files: > NT/installer32/MonetDB5-SQL-Installer.vdproj > NT/installer64/MonetDB5-SQL-Installer.vdproj > clients/Tests/exports.stable.out > monetdb5/modules/mal/mal_init.mal > monetdb5/optimizer/opt_support.c > sql/backends/monet5/Tests/optimizers.sql > sql/backends/monet5/Tests/optimizers.stable.err > Branch: default > Log Message: > > attempt to more thoroughly remove opt_accessmode > > > diffs (163 lines): > > diff --git a/NT/installer32/MonetDB5-SQL-Installer.vdproj b/NT/installer32/MonetDB5-SQL-Installer.vdproj > --- a/NT/installer32/MonetDB5-SQL-Installer.vdproj > +++ b/NT/installer32/MonetDB5-SQL-Installer.vdproj > @@ -2477,26 +2477,6 @@ > "IsDependency" = "11:FALSE" > "IsolateTo" = "8:" > } > - "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_4704D4539B804719AEB979F67EE20CDE" > - { > - "SourcePath" = "8:lib\\monetdb5\\opt_accessmode.mal" > - "TargetName" = "8:opt_accessmode.mal" > - "Tag" = "8:" > - "Folder" = "8:_B593DAA0787744D6A44D17884E0C3951" > - "Condition" = "8:" > - "Transitive" = "11:FALSE" > - "Vital" = "11:TRUE" > - "ReadOnly" = "11:FALSE" > - "Hidden" = "11:FALSE" > - "System" = "11:FALSE" > - "Permanent" = "11:FALSE" > - "SharedLegacy" = "11:FALSE" > - "PackageAs" = "3:1" > - "Register" = "3:1" > - "Exclude" = "11:FALSE" > - "IsDependency" = "11:FALSE" > - "IsolateTo" = "8:" > - } > "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_47A76DE07EE648EF9F19C2D1AC42B9EE" > { > "SourcePath" = "8:lib\\monetdb5\\autoload\\80_udf.mal" > diff --git a/NT/installer64/MonetDB5-SQL-Installer.vdproj b/NT/installer64/MonetDB5-SQL-Installer.vdproj > --- a/NT/installer64/MonetDB5-SQL-Installer.vdproj > +++ b/NT/installer64/MonetDB5-SQL-Installer.vdproj > @@ -2937,26 +2937,6 @@ > "IsDependency" = "11:FALSE" > "IsolateTo" = "8:" > } > - "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_7209273FAD0B4F4ABFF16B6C23681DA5" > - { > - "SourcePath" = "8:lib\\monetdb5\\opt_accessmode.mal" > - "TargetName" = "8:opt_accessmode.mal" > - "Tag" = "8:" > - "Folder" = "8:_B593DAA0787744D6A44D17884E0C3951" > - "Condition" = "8:" > - "Transitive" = "11:FALSE" > - "Vital" = "11:TRUE" > - "ReadOnly" = "11:FALSE" > - "Hidden" = "11:FALSE" > - "System" = "11:FALSE" > - "Permanent" = "11:FALSE" > - "SharedLegacy" = "11:FALSE" > - "PackageAs" = "3:1" > - "Register" = "3:1" > - "Exclude" = "11:FALSE" > - "IsDependency" = "11:FALSE" > - "IsolateTo" = "8:" > - } > "{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_727ED1BD7FF74A91A491B34CC26E6848" > { > "SourcePath" = "8:lib\\monetdb5\\udf.mal" If you do this, also remove the "Entry" with MsmKey equal to the value behind the UUID (so 4704D4539B804719AEB979F67EE20CDE and 7209273FAD0B4F4ABFF16B6C23681DA5 in this case respectively). -- Sjoerd Mullender

1 0

[Monetdb-developers] Announcement: New Apr2012-SP1 Bugfix release of MonetDB suite
by Fabian Groffen 25 May '12

25 May '12

The MonetDB team at CWI/MonetDB BV is pleased to announce the Apr2012-SP1 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at http://www.monetdb.org/. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Apr 2012-SP1 bugfix release Build Environment * Windows: we now use OpenSSL 1.0.1b. SQL * Databases that were upgraded from the Aug2011 release have an error in the catalog for SQL procedures. This is now fixed. Merovingian * Fixed a bug where connecting to a stopped multiplex-funnel would result in a 'there are no available connections' error. MonetDB Common * Implemented MT_getrss for Mac OS X systems, this allows the server to know about how much memory is currently in use. Bug Fixes * 2454: SQL: add various statistical functions * 2916: non admin user cannot create temporary tables * 2949: SQL exception during execution of a correct user defined function that just returns a relation table constructed by a simple SQL select query * 2958: Grant does't work with schema syntax * 2960: mclient terminates connection during insertion of a large number of records from a file * 2972: SQL URL functionality contains errors * 2987: Broken type inference when using sql round * 2992: SQL module truncates DECIMALS when passing integers to MAL module * 3000: Inconsistency between read-only and read-write modes after dropping a schema * 3028: Segmentation fault in seqscan_eq_bte_bte_tloc_void_void * 3046: mserver5 terminates with segmentation fault * 3063: datacell functions no longer work after restart of database * 3072: Database upgrade from Dec2011 to Apr2012 broken for storage() * 3073: VERY slow foreign key check (due to missing batcalc.isnil() ?) * 3074: Name resolution in procedures * 3077: No errors on UDF returning table with too many columns * 3079: Converting an Oracle schema DDL for MonetDB fails to create a column named "no".

1 0

[Monetdb-developers] MonetDB on SUSE
by Hualin Wang 22 May '12

22 May '12

Dear All, I have trouble to install the right PCRE lib on my SUSE box. The server has an old PCRE 7.8 installed. I compiled my own PCRE 8.3 version with UTF-8 enabled. Then set up the env variables pcre_LIBS, pcre_CFLAGS, PKG_CONFIG_PATH, but the ./configure sitll complain utf-8 supported no. Which version I should install on the SUSE box? Thanks for any hint/help Best Regards, Hualin

2 2

[Monetdb-developers] New Jun2012 stable branch created
by Sjoerd Mullender 21 May '12

21 May '12

I have created a new stable branch for the next feature release. This branch was created in order to stabilize the code before the feature release. From now on *only* bug fixes may go to this new stable branch. I reserve the right to undo any changes that do not comply with this rule. I also reserve the right to admit changes that are not strictly bug fixes. The name for the branch is Jun2012. So in each of your stable checkout directories you can do hg pull hg update -rJun2012 to update to this new branch. -- Sjoerd Mullender

1 1

Re: [Monetdb-developers] MonetDB: Apr2012 - approve output after null-any type changes
by Fabian Groffen 17 May '12

17 May '12

Niels, On 16-05-2012 22:49:30 +0200, Niels Nes wrote: > Changeset: f450300984b8 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f450300984b8 > @@ -20,12 +20,12 @@ Ready. > > % . # table_name > % single_value # name > -% char # type > +% any # type > % 0 # length > [ NULL ] If the "any" type now boils up to the clients, we need to fix/change the APIs too, to understand this type and in some cases do something sensical with it. JDBC will barf on it currently, IIRC. Would it be possible to use an existing type for NULL when it has no type at the stage where it is sent back to the client (like exportResult)? Fabian

2 1