# Command works when entered in bash terminal as follows:
# agg -q mega "SELECT idps.name idp_name, \
# props.name prop_name, \
# props.type prop_type, \
# props.host prop_host, \
# CHARACTER_LENGTH(props.origin_host) origin_length, \
# props.origin_host, \
# props.fossl_hostnames, \
# props.fossl_enabled \
# FROM mcdnportal_sso_idps idps \
# LEFT OUTER JOIN \
# mcdnportal_sso_properties props \
# ON idps.id = props.idp_id \
# WHERE idps.name SIMILAR '^USAF\ CCE\ Prod\ -\ LDAP$' \
# OR idps.name SIMILAR '^USAF\ CCE\ Test\ -\ LDAP$' \
# OR idps.name SIMILAR '^USAF\ CCE\ Test\ -\ Headless$' \
# OR idps.name SIMILAR '^USAF\ CCE\ Prod\ -\ Headless$' \
# ORDER BY idps.name, props.name"
[dbowling@a214-48-2-21 bin]$ cat -n test.pl
1 #!/usr/bin/env perl
2
3 use strict;
4 use warnings;
5
6 my $query = `agg -q mega "SELECT idps.name idp_name, \
7 props.name prop_name, \
8 props.type prop_type, \
9 props.host prop_host, \
10 CHARACTER_LENGTH(props.origin_host) origin_length, \
11 props.origin_host, \
12 props.fossl_hostnames, \
13 props.fossl_enabled \
14 FROM mcdnportal_sso_idps idps \
15 LEFT OUTER JOIN \
16 mcdnportal_sso_properties props \
17 ON idps.id = props.idp_id \
18 WHERE idps.name SIMILAR '^USAF\ CCE\ Prod\ -\ LDAP$' \
19 OR idps.name SIMILAR '^USAF\ CCE\ Test\ -\ LDAP$' \
20 OR idps.name SIMILAR '^USAF\ CCE\ Test\ -\ Headless$' \
21 OR idps.name SIMILAR '^USAF\ CCE\ Prod\ -\ Headless$' \
22 ORDER BY idps.name, props.name"`;
23
24 print "$query\n";
[dbowling@a214-48-2-21 bin]$ perl test.pl
Use of uninitialized value $' in concatenation (.) or string at test.pl line 6.
Use of uninitialized value $' in concatenation (.) or string at test.pl line 6.
Use of uninitialized value $' in concatenation (.) or string at test.pl line 6.
Use of uninitialized value $' in concatenation (.) or string at test.pl line 6.
error: syntax error on line 14 at '^'