Error: Unknown table 'SESSION_VARIABLES' in information_schema

[n9yty]

I just came across this project and wanted to have a look. We are running an old MySQL install (5.0.27), for various reasons, but this error is coming up when we try to do Database Information and Object Info, unsure where else it may happen.

[sasha-alias]

Thanks for reporting! MySQL connector doesn't have that much love as Postgres one, but let's take a look how we can fix that. The exception apparently happens when trying to get DB version with this query If you can help me to rewrite it for your version I will make a fix for next release which is planned on July 5.

[n9yty]

I'll admit that I am not quite following the query that you are using, but to just retrieve the specific variables the current connection is using I think a generic query like this should do it:

SHOW VARIABLES LIKE "version%";

But to list just the ones you want, this works:

SHOW VARIABLES WHERE variable_name IN ('version_comment', 'version', 'version_compile_os', 'version_compile_machine');

However, this returns them as rows with the variable name and value as columns.

Does that help?