[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