Fail early on literal-ordered complex prefetch without explicit group_by clause

[dbsrgits/DBIx-Class.git] / t / 746mssql.t

diff --git a/t/746mssql.t b/t/746mssql.t
index 674046a..6584050 100644 (file)
--- a/t/746mssql.t
+++ b/t/746mssql.t
@@ -336,6 +336,7 @@ for my $dialect (
       {
         prefetch => 'books',
         order_by => { -asc => \['name + ?', [ test => 'xxx' ]] }, # test bindvar propagation
+        group_by => [ map { "me.$_" } $schema->source('Owners')->columns ], # the literal order_by requires an explicit group_by
         rows     => 3,  # 8 results total
         unsafe_subselect_ok => 1,
       },