my @chain = (
{
columns => [ 'cdid' ],
- '+select' => [ { lower => 'title' }, 'genreid' ],
- '+as' => [ qw/title_lc genreid/ ],
+ '+columns' => [ { title_lc => { lower => 'title' } } ],
+ '+select' => [ 'genreid' ],
+ '+as' => [ 'genreid' ],
} => 'SELECT me.cdid, LOWER( title ), me.genreid FROM cd me',
{
is_same_sql_bind (
$rs->as_query,
- "x( $sql )", # the x-es are here until SQLA is fixed
+ "($sql)",
[],
"Test $testno of SELECT assembly ok",
);