[fdo-trac] #799: fdo select command does not escape aliases
FDO
trac_fdo at osgeo.org
Wed Nov 30 22:34:21 EST 2011
#799: fdo select command does not escape aliases
---------------------------------+------------------------------------------
Reporter: jng | Owner: danstoica
Type: defect | Status: new
Priority: major | Milestone: 3.7.0
Component: SQLServer Spatial | Version: 3.7.0
Severity: 3 | Keywords:
External_id: |
---------------------------------+------------------------------------------
For SQL Server, when you specify an alias via FdoISelect::SetAlias() the
alias itself is not being escaped (with [ and ] for SQL Server) as part of
the SQL that the fdo select command builds up for execution.
An easy way to test is to pass in a reserved keyword (eg. primary) as the
alias. The select command when executed, will throw an error "Incorrect
syntax near the keyword <your alias name>"
--
Ticket URL: <http://trac.osgeo.org/fdo/ticket/799>
FDO <http://fdo.osgeo.org/>
Feature Data Objects
More information about the fdo-trac
mailing list