| Subject: | as_subselect_rs with a paged & prefetched rs wont work (only pg tested) |
i added a failing test into t/72pg.t which make a simple search with a
as_subselect_rs. If i added page => 1 to the inner query, he died with
"column me.title is not clearly" (translated from the german errormessage)
I only checked that with Pg.
| Subject: | dbic_as_subselect_rs_failing_test.patch |
--- t/72pg.t.orig 2010-07-28 09:18:38.000000000 +0200
+++ t/72pg.t 2010-07-28 09:20:09.000000000 +0200
@@ -78,6 +78,27 @@
### begin main tests
+
+# using a paged and prefetched resultset in a as_subselect_rs dont work
+{
+ my $all_fine = 0;
+ eval {
+ my $rs = $schema->resultset('CD')->search(
+ {
+ },
+ {
+ page => 1,
+ prefetch => 'tracks',
+ },
+ );
+ my $all = $rs->as_subselect_rs->all;
+ $all_fine = 1;
+ };
+ ok($all_fine, "paged and prefetched rs dont work with as_subselect_rs");
+ $@ && diag($@);
+}
+
+
# run a BIG bunch of tests for last-insert-id / Auto-PK / sequence
# discovery
run_apk_tests($schema); #< older set of auto-pk tests