Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
1.6.0
-
None
Description
When trying to query a JDBC table via authenticated Rest API, using a fully qualified table name returns table not found. This does not occur in sqlline, and a workaround is to "use pluginname.mysqldatabase" prior to the query. (Then the fully qualified table name will work)
Plugin Name: mysql
Mysql Database: events
Mysql Table: curevents
Via Rest:
select * from mysql.events.curevents limit 10;
Fail with "VALIDATION ERROR "Table 'mysql.events.curevents' not found
Via Rest:
use mysql.events;
select * from mysql.events.curevents limit 10;
- Success.
Via SQL line, authenticating with the same username, you can connect, and run
select * from mysql.events.curevents limit 10;
without issue. (and without the use mysql.events)