Announcement: New Jul2017 Feature release of MonetDB suite

Brian Hood brianh6854 at googlemail.com
Tue Jul 18 19:51:18 CEST 2017


Thankyou i will go through the valid function list.

Cheers,

Brian
On Jul 18, 2017 10:20 AM, "Sjoerd Mullender" <sjoerd at monetdb.org> wrote:

> 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
>
>
> _______________________________________________
> developers-list mailing list
> developers-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/developers-list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20170718/733ad55c/attachment-0001.html>


More information about the developers-list mailing list