[fdo-trac] #593: View Data failed for one feature with Calculation

FDO trac_fdo at osgeo.org
Wed Nov 25 20:42:42 EST 2009


#593: View Data failed for one feature with Calculation
-----------------------+----------------------------------------------------
   Reporter:  Aleck    |       Owner:  Aleck
       Type:  defect   |      Status:  new  
   Priority:  major    |   Milestone:  3.5.0
  Component:  FDO API  |     Version:  3.4.0
   Severity:  3        |    Keywords:       
External_id:           |  
-----------------------+----------------------------------------------------
 When an RDBMS provider processes a computed identifier, a space in the
 name of the computed identifier will lead to an invalid SQL statement.
 Hence an exception will be thrown in this case.

 This is because the name of the identifier is not in a pair of quotation
 marks. Therefore, a computer identifier named "new calculation" with
 expression "(1+1)" will generate a SQL statement SELECT (1+1) AS new
 calculation FROM ...

 The space in the identifier name break the statement, and the solution is
 to put it between quotation marks.

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


More information about the fdo-trac mailing list