[fdo-users] FDO MySQL Defect : wrong column order

Bruno Scott bscott at geomapgis.com
Fri Dec 28 06:09:02 EST 2007


I have created a Feature Class using the MySql FDO provider
I have added all properties in this order
  KEY_1
  STRING_1
  INT32_1	
  DOUBLE_1	
  DATE_1
  STR_CODE_1	
  INT_CODE_1

When i query this feature class i get back this order
  DATE_1	
  DOUBLE_1	
  INT32_1
  INT_CODE_1	
  STRING_1	
  STR_CODE_1	
  KEY_1	

It seems that the provider some kind of sort the column 
and it always return the primary key field last

There is also something strange with the column order when we add a geometry
column

FDO MySQL should respect the order of column creation
and return the same order when we isssue a "Select * from MyTable"

Bruno




-- 
View this message in context: http://www.nabble.com/FDO-MySQL-Defect-%3A-wrong-column-order-tp14524584s18162p14524584.html
Sent from the fdo-users mailing list archive at Nabble.com.



More information about the fdo-users mailing list