Select Pattern with MySQL

, ,
1

Hello,

I am using a JDBC adapter with MySQL.
When I create a new Adapter service with a select template, the SQL request generated is:

SELECT ALL ChannelStatus.ChannelID,ChannelStatus.Status FROM channeltables.ROOT@CLAP101H.CLA.FR.channelstatus t1 WHERE (ChannelStatus.ChannelID = ChannelID)

This request is refused by MySql because it can’t recognise the table name channeltables.ROOT@CLAP101H.CLA.FR.channelstatus. However if I replace it with the simple table name “channelstatus”, it works.

Do you know why ? or to you know How to force the simple table name ?

Thanks