calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Julian Hyde <jh...@apache.org>
Subject Re: Root Schema
Date Wed, 26 Apr 2017 17:11:53 GMT
It would probably work. (Maybe you'd have to tweak the implementation
of getExpression.)

Databases traditionally don't have tables at level 0 (i.e. the root
directory). They usually have tables in level 1 (they belong to a
user, as in Oracle) or level 2 (they belong to a database and then a
schema, as in SQL Server). If you put tables at level 0 or level 7 you
run the risk of confusing the tools.

If you get it working please contribute a test case.

Julian


On Wed, Apr 26, 2017 at 8:04 AM, Jess Balint <jbalint@gmail.com> wrote:
> What is the function of the root schema? Why can't I use a JdbcSchema as
> the root?
>
> Thx.
> Jess

Mime
View raw message