[Dbix-class] MSSQL/Page/Prefetch problem

[Alan Humphrey]

> 
> This has been fixed in trunk. Please try and report any problems.
> http://dev.catalyst.perl.org/repos/bast/DBIx-Class/0.08/trunk/
> 


Getting the same results, see below.  Also, getting a failure to install DateTime::Format::Pg:

[MSG] Extracted 'DateTime::Format::Pg' to '/home/alanh/.cpanplus/5.10.0/build/DateTime-Format-Pg-0.16003'
[ERROR] Could not read /home/alanh/.cpanplus/5.10.0/build/DateTime-Format-Pg-0.16003/META.yml: ''

Key 'prereqs' needs to be of type 'HASH' at /usr/pkg/lib/perl5/5.10.0/CPANPLUS/Module.pm line 812
[ERROR] Unable to satisfy 'configure_requires' for 'DateTime::Format::Pg' -- aborting install

[ERROR] Unable to create a new distribution object for 'DateTime::Format::Pg' -- cannot continue


META.yml is there, just empty.

Program output:

~/birdweb/trunk/BirdWeb-Admin > export DBIC_TRACE=1
~/birdweb/trunk/BirdWeb-Admin > perl test.pl                               
  SELECT * FROM
  (
    SELECT TOP 25 * FROM
    (
        SELECT TOP 50  me.id, me.survey_site_id, me.start_time, me.end_time, me.zero_ref_point, me.survey_date, me.weather, me.precipitation, me.sea_state, me.tide_movement, me.visibility_distance, me.poor_visibility_reason, me.poor_visibility_reason_other, me.equipment, me.binocular_magnification, me.scope_magnification, me.walker_count, me.dog_count, me.power_boat_count, me.unpowered_boat_count, me.other_activities_name, me.other_activities_count, me.comments, me.is_complete, me.raptor1_bird_id, me.raptor1_count, me.raptor1_affect, me.raptor2_bird_id, me.raptor2_count, me.raptor2_affect, me.raptor3_bird_id, me.raptor3_count, me.raptor3_affect, site.site_code, site.site_name, site.position, site.elevation, site.comments FROM surveys me  JOIN survey_sites site ON site.site_code = me.survey_site_id  ORDER BY survey_site_id ASC, survey_date ASC
    ) AS foo
    ORDER BY survey_site_id DESC, survey_date DESC
  ) AS bar
   ORDER BY survey_site_id, survey_date

: 
DBI Exception: DBD::Sybase::st execute failed: Server message number=8156 severity=16 state=1 line=1 server=SQLA4 text=The column 'comments' was specified multiple times for 'foo'. [for Statement "  SELECT * FROM
  (
    SELECT TOP 25 * FROM
    (
        SELECT TOP 50  me.id, me.survey_site_id, me.start_time, me.end_time, me.zero_ref_point, me.survey_date, me.weather, me.precipitation, me.sea_state, me.tide_movement, me.visibility_distance, me.poor_visibility_reason, me.poor_visibility_reason_other, me.equipment, me.binocular_magnification, me.scope_magnification, me.walker_count, me.dog_count, me.power_boat_count, me.unpowered_boat_count, me.other_activities_name, me.other_activities_count, me.comments, me.is_complete, me.raptor1_bird_id, me.raptor1_count, me.raptor1_affect, me.raptor2_bird_id, me.raptor2_count, me.raptor2_affect, me.raptor3_bird_id, me.raptor3_count, me.raptor3_affect, site.site_code, site.site_name, site.position, site.elevation, site.comments FROM surveys me  JOIN survey_sites site ON site.site_code = me.survey_site_id  ORDER BY survey_site_id ASC, survey_date ASC
    ) AS foo
    ORDER BY survey_site_id DESC, survey_date DESC
  ) AS bar
   ORDER BY survey_site_id, survey_date

"] at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Schema.pm line 1010
        DBIx::Class::Schema::throw_exception('BirdWeb::BirdWebSchema=HASH(0x8666570)', 'DBI Exception: DBD::Sybase::st execute failed: Server message...') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage.pm line 122
        DBIx::Class::Storage::throw_exception('DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server=HASH(...', 'DBI Exception: DBD::Sybase::st execute failed: Server message...') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI.pm line 722
        DBIx::Class::Storage::DBI::__ANON__('DBD::Sybase::st execute failed: Server message number=8156 se...', 'DBI::st=HASH(0x87f4ea0)', undef) called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI.pm line 978
        DBIx::Class::Storage::DBI::_dbh_execute('DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server=HASH(...', 'DBI::db=HASH(0x87cee70)', 'select', undef, 'ARRAY(0x87c6b70)', 'HASH(0x87f4d60)', 'ARRAY(0x8666630)', undef, 'HASH(0x88c7870)', ...) called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI.pm line 400
        DBIx::Class::Storage::DBI::dbh_do('DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server=HASH(...', 'CODE(0x8783d40)', 'select', undef, 'ARRAY(0x87c6b70)', 'HASH(0x87f4d60)', 'ARRAY(0x8666630)', undef, 'HASH(0x88c7870)', ...) called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI/ODBC/Microsoft_SQL_Server.pm line 21
        DBIx::Class::Storage::DBI::ODBC::Microsoft_SQL_Server::_execute('DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server=HASH(...', 'select', undef, 'ARRAY(0x87c6b70)', 'HASH(0x87f4d60)', 'ARRAY(0x8666630)', undef, 'HASH(0x88c7870)', 25, ...) called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI.pm line 1195
        DBIx::Class::Storage::DBI::_select('DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server=HASH(...', 'ARRAY(0x87c6b70)', 'ARRAY(0x8666630)', undef, 'HASH(0x87c6e30)') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI/Cursor.pm line 104
        DBIx::Class::Storage::DBI::Cursor::_dbh_next('DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server=HASH(...', 'DBI::db=HASH(0x87cee70)', 'DBIx::Class::Storage::DBI::Cursor=HASH(0x87c6f00)') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI.pm line 415
        eval {...} called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI.pm line 408
        DBIx::Class::Storage::DBI::dbh_do('DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server=HASH(...', 'CODE(0x86aaba0)', 'DBIx::Class::Storage::DBI::Cursor=HASH(0x87c6f00)') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI/Cursor.pm line 123
        DBIx::Class::Storage::DBI::Cursor::next('DBIx::Class::Storage::DBI::Cursor=HASH(0x87c6f00)') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/ResultSet.pm line 944
        DBIx::Class::ResultSet::next('DBIx::Class::ResultSet=HASH(0x87c6c50)') called at test.pl line 30