[fdo-trac] #229: MySQL provider should use the native MySQL ` instead of "

[FDO]

#229: MySQL provider should use the native MySQL ` instead of "
-----------------------+----------------------------------------------------
   Reporter:  bscott   |       Owner:  gregboone
       Type:  defect   |      Status:  new      
   Priority:  major    |   Milestone:  3.3.0    
  Component:  FDO API  |     Version:  3.2.0    
   Severity:  3        |    Keywords:           
External_id:           |  
-----------------------+----------------------------------------------------
 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

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/229>
FDO <http://fdo.osgeo.org/>
Feature Data Objects