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

Bruno Scott bscott at geomapgis.com
Wed Jan 2 03:53:43 EST 2008


Even when we add the columns in a specific order in a fdo query we don't get
back the column in the same order. This make things very tough to handle in
some case.



Bruno Scott wrote:
> 
> 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-tp14524584s18162p14575194.html
Sent from the fdo-users mailing list archive at Nabble.com.



More information about the fdo-users mailing list