[MonetDB-users] select count(*) not understood by squirrelsql
Hi, 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. Any idea ? Franck
Franck Routier wrote:
Hi,
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.
Any idea ?
Fabian, is the wrd type recognized by the JDBC driver? -- Sjoerd Mullender
On 09-07-2009 14:36:33 +0200, Sjoerd Mullender wrote:
Franck Routier wrote:
Hi,
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.
Any idea ?
Fabian, is the wrd type recognized by the JDBC driver?
nope, seems it needs to be added.
Fabian Groffen wrote:
On 09-07-2009 14:36:33 +0200, Sjoerd Mullender wrote:
Fabian, is the wrd type recognized by the JDBC driver?
On a second thought, wrd is not an SQL type, so I guess it shouldn't. It's a tinyint.
The SQL server does however produce columns of type wrd in certain circumstances. -- Sjoerd Mullender
On 09-07-2009 16:05:43 +0200, Sjoerd Mullender wrote:
Fabian Groffen wrote:
On 09-07-2009 14:36:33 +0200, Sjoerd Mullender wrote:
Fabian, is the wrd type recognized by the JDBC driver?
On a second thought, wrd is not an SQL type, so I guess it shouldn't. It's a tinyint.
The SQL server does however produce columns of type wrd in certain circumstances.
Bug is in the server then. Let's take a look.
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.
participants (3)
-
Fabian Groffen -
Franck Routier -
Sjoerd Mullender