[MonetDB-users] ODBC connection issues

Sjoerd Mullender sjoerd at acm.org
Wed Oct 19 16:08:32 CEST 2011


I opened a bug for this problem (http://bugs.monetdb.org/2908).
It is a bug in the server that it makes a mess of this query, but I can
work around it in the ODBC driver, so I have checked in a patch so that
the bug isn't triggered anymore by the driver.

On 2011-10-19 15:22, Sjoerd Mullender wrote:
> On 2011-10-19 11:31, Jeremy O'Sullivan wrote:
>> Hello,
>> Regarding the ODBC error, I tried connecting to MonetDB using excel and
>> got the same error as I got from OBI EE, see log below:
>> Regards,
> 
> The problem is with the query which the MonetDB ODBC driver produces for
> the call to SQLTables where the catalog and schema names are both empty
> strings, the table name parameter is "%", and the table type parameter
> is "TABLE".
> 
> Just as a FYI, the query that is produced is this:
> 
> select cast(null as varchar(1)) as table_cat, s."name" as table_schem,
> t."name" as table_name, case when t."type" = 0 and t."system" = false
> and t."temporary" = 0 then cast('TABLE' as varchar(20)) when t."type" =
> 0 and t."system" = true and t."temporary" = 0 then cast('SYSTEM TABLE'
> as varchar(20)) when t."type" = 1 then cast('VIEW' as varchar(20)) when
> t."type" = 0 and t."system" = false and t."temporary" = 1 then
> cast('LOCAL TEMPORARY' as varchar(20)) else cast('INTERNAL TABLE TYPE'
> as varchar(20)) end as table_type, cast('' as varchar(1)) as remarks
> from sys."schemas" s, sys."tables" t where s."id" = t."schema_id" and
> t."name" like '%' and (1 = 0 or (t."type" = 0 and t."system" = false and
> t."temporary" = 0)) order by table_type, table_schem, table_name;
> 
> The server doesn't like this query.  :-(
> 
> 
> 
> 
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2d-oct
> 
> 
> 
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users


-- 
Sjoerd Mullender

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 371 bytes
Desc: OpenPGP digital signature
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20111019/8c649c7a/attachment.sig>


More information about the users-list mailing list