},
{
prefetch => 'books',
- order_by => { -asc => \['name + ?', [ test => 'xxx' ]] }, # test bindvar propagation
+ order_by => [ { -asc => \['name + ?', [ test => 'xxx' ]] }, 'me.id' ], # 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,
having => \['1 = ?', [ test => 1 ] ], #test having propagation
prefetch => 'owner',
rows => 2, # 3 results total
- order_by => { -desc => 'me.owner' },
+ order_by => [{ -desc => 'me.owner' }, 'me.id'],
unsafe_subselect_ok => 1,
},
);
});
TODO: {
+ my $freetds_and_dynamic_cursors = 1
+ if $opts_name eq 'use_dynamic_cursors' &&
+ $schema->storage->using_freetds;
+
local $TODO =
'these tests fail on freetds with dynamic cursors for some reason'
- if $opts_name eq 'use_dynamic_cursors'
- && $schema->storage->using_freetds;
+ if $freetds_and_dynamic_cursors;
+ local $ENV{DBIC_NULLABLE_KEY_NOWARN} = 1
+ if $freetds_and_dynamic_cursors;
my $rs = $schema->resultset('Money');
my $row;