Erro retrieving schema from MySql 5.4 (5.4.2) RTM

Posts   
 
    
Posts: 1
Joined: 28-Jan-2016
# Posted on: 19-Oct-2018 11:04:58   

I get the flowing error on every table when trying to retrieve the schema:

Error: 'Table 'new_table' removed from list due to cast exception in Field population.'

MySql Comunity server 8.0.12 Devart.Data.MySql.MySqlProviderFactory 5.4.2 llblgen 5.4 (5.4.2) RTM

Regards,

Joost Voorhaar

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39747
Joined: 17-Aug-2003
# Posted on: 19-Oct-2018 15:04:10   

Could you give a stack trace please? (if it's available of course). You get this error when pulling metadata for tables or also for other elements?

What I gather from DevArt's website is that their v8.0 connector is required for mysql v8. Nevertheless, what we're doing is: DESCRIBE tablename as the query, and then consume the resultset as a datatable. We have to check whether that gives a different resultset on mysql 8 as it does on previous versions or that the devart connector does/doesn't work with that...

(edit) according to the mysql 8 docs, 'describe' returns the info like show_columns does, which is what the driver expects. Odd... (however again, it might be the values returned by the devart connector are not correct as their connector v5.x might not be compatible with v8 (as they explicitly state mysql 8 support is available through their v8 connector))

Frans Bouma | Lead developer LLBLGen Pro