[mapguide-trac] #1135: Feature Service API throws exception on executing some SQL's

[MapGuide Open Source]

#1135: Feature Service API throws exception on executing some SQL's
---------------------+------------------------------------------------------
 Reporter:  Aleck    |         Owner:  Aleck
     Type:  defect   |        Status:  new  
 Priority:  low      |     Milestone:       
Component:  General  |       Version:  2.0.2
 Severity:  trivial  |    Resolution:       
 Keywords:           |   External_id:       
---------------------+------------------------------------------------------
Comment (by Aleck):

 Well, if an AS clause is provided for the selected field name such as the
 sql statement "select (max(f.id))+1 AS NextID from table f", everything
 goes OK. That is because for these statements,the provider will return the
 user defined field name in AS clause as the property name such as "NextID"
 in the above case. In this circumstance, there will be no dot in the
 property name text, therefore, feature service is able to handle this.

 What I'm addressing in this ticket is that a property name containing a
 dot will raise this issue. that is to say a statement like "select
 (max(f.id))+1 from table f"

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/1135#comment:2>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals