Opened 16 years ago

Last modified 16 years ago

#229 new defect

MySQL provider should use the native MySQL ` instead of "

Reported by: bscott Owned by: danstoica
Priority: minor Milestone: 3.4.0
Component: MySQL Provider Version: 3.2.0
Severity: 3 Keywords:
Cc: 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

Change History (3)

comment:1 by bscott, 16 years ago

Component: FDO APIMySQL Provider
Priority: majorminor

comment:2 by gregboone, 16 years ago

Owner: changed from gregboone to danstoica

comment:3 by gregboone, 16 years ago

Note: See TracTickets for help on using tickets.