| Subject: | DBD::monetdb::db::monetdb_table_info query error |
when I try to use:
$dbh->table_info('', '%', '%');
DBD::monetdb::db issues the following query:
======================
select cast( null as varchar( 128 ) ) as table_cat
, s."name" as table_schem
, t."name" as table_name
, case
when t."istable" = true and t."system" = false and t."temporary" = 0 then
cast('TABLE' as varchar( 254 ) )
when t."istable" = true and t."system" = true and t."temporary" = 0 then
cast('SYSTEM TABLE' as varchar( 254 ) )
when t."istable" = true and t."system" = false and t."temporary" = 1 then
cast('LOCAL TEMPORARY' as varchar( 254 ) )
when t."istable" = false then cast('VIEW'
as varchar( 254 ) )
else cast('INTERNAL TABLE TYPE' as varchar( 254 ) )
end as table_type
, cast( null as varchar( 254 ) ) as remarks
from sys."schemas" s
, sys."tables" t
where t."schema_id" = s."id"
======================
which fails because there's no (more) a column named "istable" in "sys.tables"