Hi Torsten

Good to hear. Indeed, MonetDB makes big strides into the future.
Both in functionality and performance
(it gained 2x improvement on TPC-H since 2017 release)

Functionally, the console option has been removed from the mserver.
Nowadays all is handled thru the mclient.

Something like this will keep you going, otherwise you know where to ask.

mclient -d dbname -lmsql

regards Martin

On 14/04/2020 13:49, Torsten Grust wrote:
> Dear MonetDB friends,
>
> I am about to start the next semester of my DB implementation course here at U Tübingen.  The course peeks at the internals of a variety of DBMSs, PostgreSQL and MonetDB5 in particular.
>
> The discussion in that course relies on being able to use the functions in the MAL 'sql' module directly such that students can understand how SQL queries are compiled into sequences of MAL statements.  MAL scripts that have worked perfectly for this in
> the past now already stop at the initial sql.init() command:
>
>     $ mclient -d scratch -l mal
>     Welcome to mclient, the MonetDB interactive terminal (Nov2019-SP3)
>     [...]
>     mal>sql.init();
>     MAPI  = (monetdb) /tmp/.s.monetdb.50000
>     QUERY = sql.init();
>     ERROR = !TypeException:user.main[1]:'sql.init' undefined in:     sql.init();
>
>
> I am running version 11.35.19 (Nov2019-SP3).  Have the magic incantations that talk to SQL from MAL changed?
>
> I'd appreciate any help here.
>
> Thanks,
>    —Torsten
>
> --
> | Prof. Dr. Torsten Grust
> | Database Systems — Universität Tübingen (Germany)
> | ✉︎ torsten.grust@uni-tuebingen.de <mailto:torsten.grust@uni-tuebingen.de>
> | db.inf.uni-tuebingen.de <http://db.inf.uni-tuebingen.de>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list