[Dbix-class] MSSQL/Page/Prefetch problem

[Alan Humphrey]

> And what did a previous version generate as far as SQL goes (the one
> that
> used to work)?
> 

0.08102 generates:

SELECT 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, survey_date:

Note: The correct number of rows is returned to the application code.

- Alan