* New upstream release. * Add build-dependency on libtest-pod-perl, for test coverage. * Upgrade to debhelper compatibility level 5. * Update watch file.
# SELECT DISTINCT main.* FROM (Groups main LEFT JOIN Principals Principals_2 ON ( main.id = Principals_2.id)) , GroupMembers GroupMembers_1 WHERE ((GroupMembers_1.MemberId = '70')) AND ((Principals_2.Disabled = '0')) AND ((main.Domain = 'UserDefined')) AND ((main.id = GroupMembers_1.GroupId))
107
# ORDER BY main.Name ASC
108
# It needs
109
# SELECT DISTINCT main.* FROM Groups main LEFT JOIN Principals Principals_2 ON ( main.id = Principals_2.id) , GroupMembers GroupMembers_1 WHERE ((GroupMembers_1.MemberId = '70')) AND ((Principals_2.Disabled = '0')) AND ((main.Domain = 'UserDefined')) AND ((main.id = GroupMembers_1.GroupId)) ORDER BY main.Name ASC
110
111
sub _BuildJoins {
112
my $self = shift;
113
my $sb = shift;
114
my %seen_aliases;
115
116
$seen_aliases{'main'} = 1;
117
118
# We don't want to get tripped up on a dependency on a simple alias.
119
foreach my $alias ( @{ $sb->{'aliases'}} ) {
120
if ( $alias =~ /^(.*?)\s+(.*?)$/ ) {
121
$seen_aliases{$2} = 1;
122
}
123
}
124
125
my $join_clause = $sb->Table . " main ";
126
127
my @keys = ( keys %{ $sb->{'left_joins'} } );
128
my %seen;
129
130
while ( my $join = shift @keys ) {
131
if ( ! $sb->{'left_joins'}{$join}{'depends_on'} || $seen_aliases{ $sb->{'left_joins'}{$join}{'depends_on'} } ) {
132
#$join_clause = "(" . $join_clause;
133
$join_clause .=
134
$sb->{'left_joins'}{$join}{'alias_string'} . " ON (";