On 09-07-2009 14:15:23 +0200, Franck Routier wrote:

using squirrelsql to access Monetdb (so, via jdbc), the tool fails to display the result for select count(*) from table;

Instead it will display <Other>. On the metadata tab, it says the result is seen as culumnType = 1111, columnTypeName = wrd

Issuing the same command in montdb command line display the result.

The problem here is that probably on some dark and windy night someone decided to add the "wrd" type to SQL. This type is the equivalent of ssize_t, a platform specific type, usually 32-bits or 64-bits. While it is fine when SQL uses this internally, it shouldn't have exposed this type to the outside for a couple of reasons: - it is not a SQL standard type - clients have no clue what the word-size of the server is - dumping and restoring might fail if a word-size mismatch occurs In short, this feature did more damage than originally intended and we'll be working on a backwards compatible fix for the next Service Pack.