Opened 13 years ago

Closed 13 years ago

#560 closed defect (fixed)

MySQL: Handle embedded quotes in datastore description

Reported by: brentrobinson Owned by: brentrobinson
Priority: minor Milestone: 3.5.0
Component: FDO API Version: 3.4.0
Severity: 3 Keywords: Create Datastore Single Quote Description
Cc: External ID:

Description

If a datastore is created with an embedded single quote in the description, a SQL error is generated since the quote is mistaken for the string delimiter.

The fix is to escape the single quotes when the description is formatted into the corresponding SQL statement.

Change History (1)

comment:1 by brentrobinson, 13 years ago

Resolution: fixed
Status: newclosed

Revision: 4960 Author: brentrobinson Date: 3:00:07 PM, Friday, September 25, 2009 Message: Ticket#560: Escape single quotes in datastore description.


Modified : /trunk/Providers/GenericRdbms/Src/SchemaMgr/Ph/Owner.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoDatastoreTest.cpp

Note: See TracTickets for help on using tickets.