Hello together,<div><br></div><div>I installed MonetDB with the help of the latest <span style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:13px">monetdb-install.sh and played around with MIL. Now I&#39;m stuck with translating a simple SQL-Query containing a GROUPBY.</span></div>

<div><span style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:13px"><br></span></div><div><font face="Verdana, Arial, Helvetica, sans-serif">After starting the server with </font></div>
<div><font face="Verdana, Arial, Helvetica, sans-serif"># Mserver --dbname test --dbinit &#39;module(mapi); mil_start();&#39;</font></div><div><font face="Verdana, Arial, Helvetica, sans-serif">and the client with</font></div>

<div><span style="font-family:Verdana, Arial, Helvetica, sans-serif"> # ./mclient -lmil -utest -dname=test</span></div><div><font face="Verdana, Arial, Helvetica, sans-serif"><br>
</font></div><div><font face="Verdana, Arial, Helvetica, sans-serif">I tried the following:</font></div><div><font face="Verdana, Arial, Helvetica, sans-serif"><br></font></div>
<div><font face="Verdana, Arial, Helvetica, sans-serif"><div>var a:= bat(oid,int);</div><div>a.insert(1@0, 1995);</div><div>a.insert(2@0, 1992);</div><div>a.insert(3@0, 1993);</div><div>a.insert(4@0, 1994);</div>
<div>a.insert(5@0, 1995);</div><div>a.insert(6@0, 1996);</div><div>CTgroup(a).print();</div><div><br></div><div>the answer is:</div><div><br></div><div><div>ERROR: const operation on a BAT</div><div>ERROR: CMDconstCopy: operation failed.</div>

<div>ERROR: interpret_params: print(param 1): evaluation error.</div><div><br></div><div>Another try after loading the xtables-Module:</div><div><br></div><div><div>mil&gt;module(&quot;xtables&quot;);</div><div><div>mil&gt;CTgroup(a).print();</div>

<div>+-------------------------------------------------------+</div><div>| �                                                      |</div><div>+-------------------------------------------------------+</div><div>1 tuple</div>

<div><br></div><div><br></div><div>I used a few papers and <a href="http://monetdb.cwi.nl/MonetDB/Version4/Documentation/mil/index.html" target="_blank">http://monetdb.cwi.nl/MonetDB/Version4/Documentation/mil/index.html</a> (Chapter 3.7 is what I&#39;m looking for) as tutorial but didn&#39;t find anything helpful.</div>

<div><br></div><div>Where&#39;s my mistake?</div><div><br></div><div>Best Regards,</div><div>Hannes</div></div><div><br></div></div><div><br></div></div></font></div>