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
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
Hi Martin,
thanks for the immediate response. The mclient option -lmsql (instead of -lsql) did the trick. I am up and running again with my scripts.
Cheers, —Torsten
On Tue, Apr 14, 2020 at 2:52 PM Martin Kersten martin@monetdb.org wrote:
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
participants (2)
-
Martin Kersten
-
Torsten Grust