1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
use strict;
use warnings;
use Test::More;
use Test::Exception;
use SQL::Abstract::More;
use SQL::Abstract::Test import => ['is_same_sql_bind'];
plan tests => 2;
my $sqla = SQL::Abstract::More->new();
my ($sql,@bind) = $sqla->select(
-from => 't2',
-where => {col => {-in => \[$sqla->select(
-columns => 'some_key',
-from => 't1',
-order_by => 'foo',
)]}},
-group_by => 'bar',
);
is_same_sql_bind (
$sql,
\@bind,
'SELECT * FROM t2 WHERE ( col IN ( SELECT some_key FROM t1 ORDER BY foo ) ) '
. 'GROUP BY bar',
[],
);
($sql,@bind) = $sqla->select(
-from => 't2',
-where => {col => {-in => \[$sqla->select(
-columns => 'some_key',
-from => 't1',
-order_by => 'foo',
)]}},
-group_by => 'bar',
-order_by => 'buz',
);
is_same_sql_bind (
$sql,
\@bind,
'SELECT * FROM t2 WHERE ( col IN ( SELECT some_key FROM t1 ORDER BY foo ) ) '
. 'GROUP BY bar ORDER BY buz',
[],
);
|
