| Subject: | Field Order from sqlt results for dbi and sql server are incorrect |
$c->{ORDINAL_POSITION} is passed to add_fields for a number of databases. The output order
isn't the same as the ORDINAL_POSITION as seen from SQL Server. I don't know if this affects all
other calls to add_fields() that pass order => something.
Current Master as of commit 0eb3b94a54140cedfc37172290f3fc8c1e15ddc9
From SQL-Translator/lib/SQL/Translator/Schema/Table.pm
$field->order( ++$self->{_order}{field} );
changing to:
$field->order( ++$self->{_order}{field} ) unless $field->{'order'};
Fixes my issue, but fail some tests (see attachment).
I'll try to get a debug log of this tomorrow.
| Subject: | sql-translator-order_is_being_stomped_by_add_fields.txt |
Message body is not shown because it is too large.