| Subject: | wrong where phrase |
perl -de 1
DB<1> use SQL::Abstract::Limit
DB<2> $sqla = SQL::Abstract->new( logic => 'and' )
DB<3> $sqlb = SQL::Abstract::Limit->new( logic=>'and' )
DB<4> @where = ( a => {'>', 1}, a => {'<', 10} )
DB<5> x $sqla->select('table_a', [a,b,c], \@where)
0 'SELECT a, b, c FROM table_a WHERE ( ( a > ? ) AND ( a < ? ) )'
1 1
2 10
DB<6> x $sqlb->select('table_a', [a,b,c], \@where)
0 'SELECT a, b, c FROM table_a WHERE ( ( a > ? ) OR ( a < ? ) )'
1 1
2 10
where phase is unmatch.