When the schema name in database is different from 'dbo', or database has more than one schema names - HeidiSQL constructs object names in internal queries like this:
select *** from "DatabaseName".."TableName"
(note double period between databse name and table name)
When I manually run same query with a fix - it works fine:
select *** from "DatabaseName".myschemaname."TableName"
And when database schema name is default (dbo) and the only - Heidi handles it correctly:
select *** from "DatabaseName".dbo."TableName"
Please fix it.