Hi, I have a couple of questions on calcite.
1. Assuming that I have a MySQL server which has two user databases: db1 and db2. If I wish to run a query "select * from db1.tab1 inner join db2.tab2 on db1.id = db2.id", do I need to add both databases in the root schema? 2. 3. Secondly, even if I add one database say db1, the tableMap that we create has all the tables across all the databases in MySQL including system schema such as information schema and performance schema. Why? 4. 5. Point (2) has created an issue for MySQL version 8 where a table name is common in mysql & information databases which leads to exception for duplicate key as we expect each table name to unique. I think I am reading something wrong here because Calcite shouldnt expect table names to be unique across catalogs/schemas? Thanks, Yogi
