Announcement: New Jul2017 Feature release of MonetDB suite

Sjoerd Mullender sjoerd at monetdb.org
Tue Jul 18 11:18:58 CEST 2017


On 17/07/17 18:21, Brian Hood wrote:
> Hi Sjoerd,
> 
> I just noticed functions that are deprecated from the mapi client
>  library in your release note.
> 
> * Removed the "array" and "quick" functions from the mapi library. To
>        be precise, the removed functions are: mapi_execute_array,
>        mapi_fetch_field_array, mapi_prepare_array, mapi_query_array,
>        mapi_quick_query, mapi_quick_query_array, and mapi_quick_response.
>      * Added a more elaborate \help command for SQL expressions.
> 
> If possible could provide a list of currently supported functions as i
> have all of these functions in my Crystal Language driver code that i
> will need to remove.

Sorry about that.  I didn't think anybody used those functions, we
certainly don't and never have.  And having them is just that much more
of a maintenance burden.

The list of supported functions is in mapi.h.  You can see the contents
of the file here:

https://www.monetdb.org/hg/MonetDB/file/Jul2017/clients/mapilib/mapi.h

> Regards,
> 
> Brian Hood 
> 
> On Mon, Jul 17, 2017 at 3:37 PM, Sjoerd Mullender <sjoerd at acm.org
> <mailto:sjoerd at acm.org>> wrote:
> 
>     The MonetDB team at CWI/MonetDB BV is pleased to announce the
>     Jul2017 feature 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
>     <http://www.monetdb.org/Downloads/ReleaseNotes>>.
> 
>     As usual, the download location is
>     <http://dev.monetdb.org/downloads/ <http://dev.monetdb.org/downloads/>>.
> 
> 
>     Jul 2017 feature release
> 
>        MonetDB5 Server
>          * The "sub" prefix of many functions, both at the MAL and the C
>            level, has been removed.
>          * Changed the interfaces of the AUTH* functions: pass values, not
>            pointers to values.
>          * Removed calc.setoid().
>          * group.subgroup is now called group.group if it is not refining a
>            group. Both group.group and group.subgroup now also have variants
>            with a candidate list.
>          * The allocation schemes for MAL blocks and Variables has been
>     turned
>            into block-based. This reduces the number of malloc()/free()
>     calls.
> 
>        .
>          * Added a new server-side protocol implementation. The new protocol
>            is backwards compatible with the old protocol. Clients can choose
>            whether they want to use the old or the new protocol during the
>            initial handshake with the server. The new protocol is a binary
>            column-based protocol that is significantly faster than the old
>            protocol when transferring large result sets. In addition,
>     the new
>            protocol supports compression using Snappy or LZ4.
>          * Moved the sphinx extension module to its own repository. See
>            https://dev.monetdb.org/hg/MonetDB-sphinx/
>     <https://dev.monetdb.org/hg/MonetDB-sphinx/>.
>          * Removed GSL module: it's now a separate (extension) package. See
>            https://dev.monetdb.org/hg/MonetDB-gsl/
>     <https://dev.monetdb.org/hg/MonetDB-gsl/>.
>          * The PCRE library is now optional for systems that support POSIX
>            regular expressions.
>          * Added 5 new sys schema tables: function_languages,
>     function_types,
>            key_types, index_types and privilege_codes. They are pre-loaded
>            with static content and contain descriptive names for the various
>            integer type and code values. See also
>            sql/scripts/51_sys_schema_extension.sql
> 
>        Merovingian
>          * Added handling of a dbextra property per database at the daemon
>            level. The user can set the dbextra property for a database using
>            the command: $ monetdb set dbextra=<path> <database> and the
>     daemon
>            will make sure to start the new server using the correct
>     --dbextra
>            parameter.
> 
>        Client Package
>          * The mclient and msqldump programs lost compatibility with old
>            mserver5 versions (pre 2014) which didn't have a "system"
>     column in
>            the sys.schemas table.
>          * The mclient and msqldump programs lost compatibility with ancient
>            mserver5 versions (pre 2011) which didn't have the
>            sys.systemfunctions table.
>          * Removed the "array" and "quick" functions from the mapi
>     library. To
>            be precise, the removed functions are: mapi_execute_array,
>            mapi_fetch_field_array, mapi_prepare_array, mapi_query_array,
>            mapi_quick_query, mapi_quick_query_array, and
>     mapi_quick_response.
>          * Added a more elaborate \help command for SQL expressions.
> 
>        MonetDB Common
>          * Improved error checking in the logger code (dealing with the
>            write-ahead log); changed return types a several functions
>     from int
>            to gdk_return (i.e., they now return GDK_SUCCEED or
>     GDK_FAIL). The
>            logger no longer calls GDKfatal on error. Instead the caller is
>            responsible for dealing with errors.
>          * BATsort may now create an order index as a by product.
>          * Quantile calculations now use the order index if available
>     (and use
>            BATsort otherwise, producing an order index).
>          * Quantiles calculate a position in the sorted column. If this
>            position is not an integer, we now choose the nearest position,
>            favoring the lower if the distance to the two adjacent
>     positions is
>            equal (round down to nearest integer).
>          * Removed function BATprintf. Use BATprint or BATprintcolumns
>            instead.
>          * Removed BATsave from the list of exported functions.
>          * Replaced BBPincref/BBPdecref with BBPfix/BBPunfix for physical
>            reference count and BBPretain/BBPrelease for logical reference
>            count maintenance.
>          * Removed automatic conversion of 32-bit OIDs to 64 bits on 64-bit
>            architectures.
>          * Removed functions OIDbase() and OIDnew().
>          * Removed talign field from BAT descriptor.
>          * BATappend now takes an optional (NULL if not used) candidate list
>            for the to-be-appended BAT.
>          * New function BATkeyed(BAT *b) that determines (possibly using a
>            hash table) whether all values in b are distinct.
> 
>        SQL
>          * Made the operator precedence of % equal to those of * and /. All
>            three are evaluated from left to right.
>          * Removed table sys.connections. It was a remnant of an
>     experimental
>            change that had already been removed in 2012.
>          * Protect against runaway profiler events If you hit a barrier
>     block
>            during profiling, the JSON event log may quickly become unwieldy.
>            Event production is protected using a high water mark, which
>            ensures that never within the single execution of MAL block the
>            instruction causes excessive event records.
> 
>        Bug Fixes
>          * 3465: Request: add support for CREATE VIEW with ORDER BY clause
>          * 3545: monetdb commands don't work with -h -P -p options (locally
>            and remotely)
>          * 3996: select * from sys.connections always returns 0 rows.
>     Expected
>            to see at least one row for the active connection.
>          * 6187: Nested WITH queries not supported
>          * 6225: Order of evaluation of the modulo operator
>          * 6289: Crashes and hangs with remote tables
>          * 6292: Runaway SQL optimizer in too many nested operators
>          * 6310: Name resolution error (sqlsmith)
>          * 6312: Object not found in LIMIT clause (sqlsmith)
>          * 6313: Null type resolution in disjunction fails (sqlsmith)
>          * 6319: Server crash on LATERAL (sqlsmith)
>          * 6322: Crash on disjunction with LIMIT (sqlsmith)
>          * 6323: Deadlock calling sys.bbp()
>          * 6324: Sqlitelogictest crash in a IN query (8th)
>          * 6327: The daemon does not respect the actual name of the mserver5
>            executable
>          * 6330: Sqlitelogictest crash on a complex SELECT query
>          * 6331: sys.statistics column "nils" always contains 0. Expected a
>            positive value for columns that have one or more nils/NULLs
>          * 6332: Sqlitelogictest crash related to an undefined MAL function
>     _______________________________________________
>     developers-list mailing list
>     developers-list at monetdb.org <mailto:developers-list at monetdb.org>
>     https://www.monetdb.org/mailman/listinfo/developers-list
>     <https://www.monetdb.org/mailman/listinfo/developers-list>
> 
> 
> 
> 
> _______________________________________________
> developers-list mailing list
> developers-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/developers-list
> 


-- 
Sjoerd Mullender

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20170718/0dd15345/attachment.sig>


More information about the developers-list mailing list