MySQL provider should use the native MySQL ` instead of "

[bscott]

I'm trying to do that type of sql statement : "select Count(1) from POINT where NOT POINT.KEY_1 NULL" Using the MySQL provider

The MySQL provider push that query to MySQL select Count(1) FROM "point" H WHERE NOT H."key_1" IS NULL and it does not work I have used this fonction FdoComputedIdentifier::Create("Count(1)",FdoExpression::Parse("Count(1)"));

This thing throw me an exception: RDBMS: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Count(1) FROM "fdomysqladsk"."point" H WHERE ( NOT ( H."key_1" IS NULL ) ' at line 1

i've tried this syntax inside MySql? and it throws me the same error. But if we replace all " by ` it works wrong : select Count(1) FROM "fdomysqladsk"."point" H WHERE NOT H."key_1" IS NULL good: select Count(1) FROM fdomysqladsk.point H WHERE NOT H.key_1 IS NULL