[BUG] MS SQL Token error: 'Invalid object name 'information_schema.schemata'.' about dataflare HOT 5 CLOSED

@kodaicoder @wqweto
We have just released version 0.6, and this error has been fixed. Can you please try again?

from dataflare.

It does work ok now!

Btw, on browsing tables the arrow in the cells for following foreign key is a nice touch :-))

from dataflare.

@kodaicoder Thanks.

Dataflare gets the schema and table through this SQL, what is certain is that the problem comes from this piece of SQL, maybe a compatibility issue, I'll look into it.

SELECT
    c.schema_name,
    t.table_name
FROM
    information_schema.schemata as c
    LEFT JOIN information_schema.tables as t ON
        t.TABLE_TYPE = 'BASE TABLE' AND
        t.table_schema = c.schema_name
ORDER BY c.schema_name, t.table_name;

from dataflare.

I has trying change the code you mention into all upper case like this

SELECT
    c.SCHEMA_NAME,
    t.TABLE_NAME
FROM
    INFORMATION_SCHEMA.SCHEMATA as c
    LEFT JOIN INFORMATION_SCHEMA.TABLES as t ON
        t.TABLE_TYPE = 'BASE TABLE' AND
        t.TABLE_SCHEMA = c.SCHEMA_NAME
ORDER BY c.SCHEMA_NAME, t.TABLE_NAME;

and it working good
BTW I don't know if it will affected and cause error on any other MSSQL version or other SQL tools

from dataflare.

I have the same problem on a SQL Server host with case-sensitive collation.

INFORMATION_SCHEMA views (and columns) are all UPPER-CASE named by design as described in every RDBMS documentation and not surprisingly writing these queries in lower-case can lead to compatibility problems.

from dataflare.