Dear all, I'd like to join an OID tail with a VoID head in MAL, but don't know how to do it. See below for details. Could someone please help? Thanks in advacne! Stefan ======== $ cat /tmp/join.mal -------- include microbenchmark; b0 := microbenchmark.uniform(0:oid, 10,10); b1 := batcalc.oid(b0); t0 := alarm.usec(); io.print(b1); io.print(b0); b2 := algebra.join(b1,b0); t1 := alarm.usec(); tx := t1 - t0; io.print(tx); ======== $ mserver5 --set monet_prompt='' < /tmp/join.mal -------- # MonetDB Server v5.0.1 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # dbname:demo # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize/etc/monetdb5.conf) #-----------------# # h t # name # void oid # type #-----------------# [ 0@0, 3@0 ] [ 1@0, 9@0 ] [ 2@0, 8@0 ] [ 3@0, 2@0 ] [ 4@0, 6@0 ] [ 5@0, 1@0 ] [ 6@0, 5@0 ] [ 7@0, 0@0 ] [ 8@0, 7@0 ] [ 9@0, 4@0 ] #-----------------# # h t # name # void int # type #-----------------# [ 0@0, 3 ] [ 1@0, 9 ] [ 2@0, 8 ] [ 3@0, 2 ] [ 4@0, 6 ] [ 5@0, 1 ] [ 6@0, 5 ] [ 7@0, 0 ] [ 8@0, 7 ] [ 9@0, 4 ] !TypeException:user.main[1]:'algebra.join' undefined in: b2:any := algebra.join(b1:bat[:void,:oid], b0:bat[:void,:int]) [ 5840 ] ======== -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |