Hello, <div><br></div><div>I have recently started trying out monetdb and have been very impressed by its speed so far. </div><div><br></div><div>However, I am hitting a failure trying to read in a large negative number (bitmask) into a bigint field; </div>
<div><br></div><div><div>sql&gt;\&lt;test.sql                                                                                                                                                                                                     </div>
<div>operation successful                                                                                                                                                                                             </div><div>
value &#39;-9223372036854775808&#39; from line 1 field 17 not inserted, expecting type bigint                                                                                                                           </div>
<div>failed to import table                                                                                                                                                                                   </div></div><div>
<br></div><div>I&#39;ve attached the sql commands to create the table and a test file to this message.</div><div><br></div><div>As far as I can tell, this should be fine for being represented by a 64 bit integer....</div>
<div><br></div><div>I am running this on an OS X 10.6 64-bit system, this is the Dec-2011 SP2 version of the 64 bit binaries dowloaded from <a href="http://www.monetdb.org">www.monetdb.org</a>.</div><div><br></div><div>Any help is much appreciated.</div>
<div>Thanks in advance, </div><div>-- Nikhil</div><div><br clear="all">---------------------------------<br>Nikhil Padmanabhan<br><a href="mailto:nikhil.padmanabhan@yale.edu">nikhil.padmanabhan@yale.edu</a><br>
</div>