# tests for the dss sort query
TITLE + sort
export TZ=EST5EDT
VIEW data
TEST 01 'string field basics'
EXEC -x $data/pwd.dss '{sort}' $data/pwd.dat
OUTPUT - $'adm:*:5:3:Accounting Files Owner:/var/adm:/bin/sh
aha::-2:0::/:/bin/sh
as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh
auditor:*:11:0:Audit Activity Owner:/auditor:/bin/sh
bin:*:2:2:System Tools Owner:/bin:/dev/null
daemon:*:1:1:daemons:/:/dev/null
demos:*:993:997:Demonstration User:/usr/demos:/bin/csh
diag:*:-3:996:Hardware Diagnostics:/usr/diags:/bin/csh
dup::998:998:oops dup uid gid:/home/he:/bin/ksh
ftp:*:112:112:File Transfer:/home/ftp:/dev/null
guest:*:998:998:Guest Account:/usr/people/guest:/bin/csh
he::30002:30002:Hammond Egger:/home/he:/bin/ksh
he::90002:90002:oops dup name:/home/he:/bin/ksh
jethro::00030001:80001:oops dup uid number different text:/home/he:/bin/ksh
lg:*:30001:10003:Len Gernwolf:/home/lg:/bin/ksh
lp:*:9:9:Print Spooler Owner:/var/spool/lp:/bin/sh
noaccess:*:60002:60002:uid no access:/dev/null:/dev/null
nobody:*:60001:60001:original nobody uid:/dev/null:/dev/null
root:*:0:0:Super-User:/:/bin/csh
sys:*:4:0:System Activity Owner:/var/adm:/bin/sh
sysadm:*:0:9:System V Administration:/usr/admin:/bin/sh
uucp:*:3:5:UUCP Owner:/usr/lib/uucp:/bin/csh'
EXEC -x $data/pwd.dss '{sort --uniq}' $data/pwd.dat
EXEC -x $data/pwd.dss '{sort --reverse}' $data/pwd.dat
OUTPUT - $'uucp:*:3:5:UUCP Owner:/usr/lib/uucp:/bin/csh
sysadm:*:0:9:System V Administration:/usr/admin:/bin/sh
sys:*:4:0:System Activity Owner:/var/adm:/bin/sh
root:*:0:0:Super-User:/:/bin/csh
nobody:*:60001:60001:original nobody uid:/dev/null:/dev/null
noaccess:*:60002:60002:uid no access:/dev/null:/dev/null
lp:*:9:9:Print Spooler Owner:/var/spool/lp:/bin/sh
lg:*:30001:10003:Len Gernwolf:/home/lg:/bin/ksh
jethro::00030001:80001:oops dup uid number different text:/home/he:/bin/ksh
he::90002:90002:oops dup name:/home/he:/bin/ksh
he::30002:30002:Hammond Egger:/home/he:/bin/ksh
guest:*:998:998:Guest Account:/usr/people/guest:/bin/csh
ftp:*:112:112:File Transfer:/home/ftp:/dev/null
dup::998:998:oops dup uid gid:/home/he:/bin/ksh
diag:*:-3:996:Hardware Diagnostics:/usr/diags:/bin/csh
demos:*:993:997:Demonstration User:/usr/demos:/bin/csh
daemon:*:1:1:daemons:/:/dev/null
bin:*:2:2:System Tools Owner:/bin:/dev/null
auditor:*:11:0:Audit Activity Owner:/auditor:/bin/sh
as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh
aha::-2:0::/:/bin/sh
adm:*:5:3:Accounting Files Owner:/var/adm:/bin/sh'
EXEC -x $data/pwd.dss '{sort --reverse --uniq}' $data/pwd.dat
TEST 02 'numeric field basics'
EXEC -x $data/pwd.dss '{sort uid}' $data/pwd.dat
OUTPUT - $'diag:*:-3:996:Hardware Diagnostics:/usr/diags:/bin/csh
aha::-2:0::/:/bin/sh
root:*:0:0:Super-User:/:/bin/csh
sysadm:*:0:9:System V Administration:/usr/admin:/bin/sh
daemon:*:1:1:daemons:/:/dev/null
bin:*:2:2:System Tools Owner:/bin:/dev/null
uucp:*:3:5:UUCP Owner:/usr/lib/uucp:/bin/csh
sys:*:4:0:System Activity Owner:/var/adm:/bin/sh
adm:*:5:3:Accounting Files Owner:/var/adm:/bin/sh
lp:*:9:9:Print Spooler Owner:/var/spool/lp:/bin/sh
auditor:*:11:0:Audit Activity Owner:/auditor:/bin/sh
ftp:*:112:112:File Transfer:/home/ftp:/dev/null
demos:*:993:997:Demonstration User:/usr/demos:/bin/csh
guest:*:998:998:Guest Account:/usr/people/guest:/bin/csh
dup::998:998:oops dup uid gid:/home/he:/bin/ksh
as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh
jethro::00030001:80001:oops dup uid number different text:/home/he:/bin/ksh
lg:*:30001:10003:Len Gernwolf:/home/lg:/bin/ksh
he::30002:30002:Hammond Egger:/home/he:/bin/ksh
nobody:*:60001:60001:original nobody uid:/dev/null:/dev/null
noaccess:*:60002:60002:uid no access:/dev/null:/dev/null
he::90002:90002:oops dup name:/home/he:/bin/ksh'
EXEC -x $data/pwd.dss '{sort --uniq uid}' $data/pwd.dat
OUTPUT - $'diag:*:-3:996:Hardware Diagnostics:/usr/diags:/bin/csh
aha::-2:0::/:/bin/sh
root:*:0:0:Super-User:/:/bin/csh
daemon:*:1:1:daemons:/:/dev/null
bin:*:2:2:System Tools Owner:/bin:/dev/null
uucp:*:3:5:UUCP Owner:/usr/lib/uucp:/bin/csh
sys:*:4:0:System Activity Owner:/var/adm:/bin/sh
adm:*:5:3:Accounting Files Owner:/var/adm:/bin/sh
lp:*:9:9:Print Spooler Owner:/var/spool/lp:/bin/sh
auditor:*:11:0:Audit Activity Owner:/auditor:/bin/sh
ftp:*:112:112:File Transfer:/home/ftp:/dev/null
demos:*:993:997:Demonstration User:/usr/demos:/bin/csh
guest:*:998:998:Guest Account:/usr/people/guest:/bin/csh
as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh
he::30002:30002:Hammond Egger:/home/he:/bin/ksh
nobody:*:60001:60001:original nobody uid:/dev/null:/dev/null
noaccess:*:60002:60002:uid no access:/dev/null:/dev/null
he::90002:90002:oops dup name:/home/he:/bin/ksh'
EXEC -x $data/pwd.dss '{sort --reverse uid}' $data/pwd.dat
OUTPUT - $'he::90002:90002:oops dup name:/home/he:/bin/ksh
noaccess:*:60002:60002:uid no access:/dev/null:/dev/null
nobody:*:60001:60001:original nobody uid:/dev/null:/dev/null
he::30002:30002:Hammond Egger:/home/he:/bin/ksh
lg:*:30001:10003:Len Gernwolf:/home/lg:/bin/ksh
jethro::00030001:80001:oops dup uid number different text:/home/he:/bin/ksh
as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh
dup::998:998:oops dup uid gid:/home/he:/bin/ksh
guest:*:998:998:Guest Account:/usr/people/guest:/bin/csh
demos:*:993:997:Demonstration User:/usr/demos:/bin/csh
ftp:*:112:112:File Transfer:/home/ftp:/dev/null
auditor:*:11:0:Audit Activity Owner:/auditor:/bin/sh
lp:*:9:9:Print Spooler Owner:/var/spool/lp:/bin/sh
adm:*:5:3:Accounting Files Owner:/var/adm:/bin/sh
sys:*:4:0:System Activity Owner:/var/adm:/bin/sh
uucp:*:3:5:UUCP Owner:/usr/lib/uucp:/bin/csh
bin:*:2:2:System Tools Owner:/bin:/dev/null
daemon:*:1:1:daemons:/:/dev/null
sysadm:*:0:9:System V Administration:/usr/admin:/bin/sh
root:*:0:0:Super-User:/:/bin/csh
aha::-2:0::/:/bin/sh
diag:*:-3:996:Hardware Diagnostics:/usr/diags:/bin/csh'
EXEC -x $data/pwd.dss '{sort --reverse --uniq uid}' $data/pwd.dat
OUTPUT - $'he::90002:90002:oops dup name:/home/he:/bin/ksh
noaccess:*:60002:60002:uid no access:/dev/null:/dev/null
nobody:*:60001:60001:original nobody uid:/dev/null:/dev/null
he::30002:30002:Hammond Egger:/home/he:/bin/ksh
lg:*:30001:10003:Len Gernwolf:/home/lg:/bin/ksh
dup::998:998:oops dup uid gid:/home/he:/bin/ksh
demos:*:993:997:Demonstration User:/usr/demos:/bin/csh
ftp:*:112:112:File Transfer:/home/ftp:/dev/null
auditor:*:11:0:Audit Activity Owner:/auditor:/bin/sh
lp:*:9:9:Print Spooler Owner:/var/spool/lp:/bin/sh
adm:*:5:3:Accounting Files Owner:/var/adm:/bin/sh
sys:*:4:0:System Activity Owner:/var/adm:/bin/sh
uucp:*:3:5:UUCP Owner:/usr/lib/uucp:/bin/csh
bin:*:2:2:System Tools Owner:/bin:/dev/null
daemon:*:1:1:daemons:/:/dev/null
sysadm:*:0:9:System V Administration:/usr/admin:/bin/sh
aha::-2:0::/:/bin/sh
diag:*:-3:996:Hardware Diagnostics:/usr/diags:/bin/csh'
TEST 03 'multiple fields'
EXEC -x $data/pwd.dss '{sort uid gid}' $data/pwd.dat
OUTPUT - $'diag:*:-3:996:Hardware Diagnostics:/usr/diags:/bin/csh
aha::-2:0::/:/bin/sh
root:*:0:0:Super-User:/:/bin/csh
sysadm:*:0:9:System V Administration:/usr/admin:/bin/sh
daemon:*:1:1:daemons:/:/dev/null
bin:*:2:2:System Tools Owner:/bin:/dev/null
uucp:*:3:5:UUCP Owner:/usr/lib/uucp:/bin/csh
sys:*:4:0:System Activity Owner:/var/adm:/bin/sh
adm:*:5:3:Accounting Files Owner:/var/adm:/bin/sh
lp:*:9:9:Print Spooler Owner:/var/spool/lp:/bin/sh
auditor:*:11:0:Audit Activity Owner:/auditor:/bin/sh
ftp:*:112:112:File Transfer:/home/ftp:/dev/null
demos:*:993:997:Demonstration User:/usr/demos:/bin/csh
guest:*:998:998:Guest Account:/usr/people/guest:/bin/csh
dup::998:998:oops dup uid gid:/home/he:/bin/ksh
lg:*:30001:10003:Len Gernwolf:/home/lg:/bin/ksh
as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh
jethro::00030001:80001:oops dup uid number different text:/home/he:/bin/ksh
he::30002:30002:Hammond Egger:/home/he:/bin/ksh
nobody:*:60001:60001:original nobody uid:/dev/null:/dev/null
noaccess:*:60002:60002:uid no access:/dev/null:/dev/null
he::90002:90002:oops dup name:/home/he:/bin/ksh'
EXEC -x $data/pwd.dss '{sort --uniq uid gid}' $data/pwd.dat
OUTPUT - $'diag:*:-3:996:Hardware Diagnostics:/usr/diags:/bin/csh
aha::-2:0::/:/bin/sh
root:*:0:0:Super-User:/:/bin/csh
sysadm:*:0:9:System V Administration:/usr/admin:/bin/sh
daemon:*:1:1:daemons:/:/dev/null
bin:*:2:2:System Tools Owner:/bin:/dev/null
uucp:*:3:5:UUCP Owner:/usr/lib/uucp:/bin/csh
sys:*:4:0:System Activity Owner:/var/adm:/bin/sh
adm:*:5:3:Accounting Files Owner:/var/adm:/bin/sh
lp:*:9:9:Print Spooler Owner:/var/spool/lp:/bin/sh
auditor:*:11:0:Audit Activity Owner:/auditor:/bin/sh
ftp:*:112:112:File Transfer:/home/ftp:/dev/null
demos:*:993:997:Demonstration User:/usr/demos:/bin/csh
guest:*:998:998:Guest Account:/usr/people/guest:/bin/csh
lg:*:30001:10003:Len Gernwolf:/home/lg:/bin/ksh
as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh
jethro::00030001:80001:oops dup uid number different text:/home/he:/bin/ksh
he::30002:30002:Hammond Egger:/home/he:/bin/ksh
nobody:*:60001:60001:original nobody uid:/dev/null:/dev/null
noaccess:*:60002:60002:uid no access:/dev/null:/dev/null
he::90002:90002:oops dup name:/home/he:/bin/ksh'
EXEC -x $data/pwd.dss '{sort --reverse uid gid}' $data/pwd.dat
OUTPUT - $'he::90002:90002:oops dup name:/home/he:/bin/ksh
noaccess:*:60002:60002:uid no access:/dev/null:/dev/null
nobody:*:60001:60001:original nobody uid:/dev/null:/dev/null
he::30002:30002:Hammond Egger:/home/he:/bin/ksh
jethro::00030001:80001:oops dup uid number different text:/home/he:/bin/ksh
as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh
lg:*:30001:10003:Len Gernwolf:/home/lg:/bin/ksh
dup::998:998:oops dup uid gid:/home/he:/bin/ksh
guest:*:998:998:Guest Account:/usr/people/guest:/bin/csh
demos:*:993:997:Demonstration User:/usr/demos:/bin/csh
ftp:*:112:112:File Transfer:/home/ftp:/dev/null
auditor:*:11:0:Audit Activity Owner:/auditor:/bin/sh
lp:*:9:9:Print Spooler Owner:/var/spool/lp:/bin/sh
adm:*:5:3:Accounting Files Owner:/var/adm:/bin/sh
sys:*:4:0:System Activity Owner:/var/adm:/bin/sh
uucp:*:3:5:UUCP Owner:/usr/lib/uucp:/bin/csh
bin:*:2:2:System Tools Owner:/bin:/dev/null
daemon:*:1:1:daemons:/:/dev/null
sysadm:*:0:9:System V Administration:/usr/admin:/bin/sh
root:*:0:0:Super-User:/:/bin/csh
aha::-2:0::/:/bin/sh
diag:*:-3:996:Hardware Diagnostics:/usr/diags:/bin/csh'
EXEC -x $data/pwd.dss '{sort --reverse --uniq uid gid}' $data/pwd.dat
OUTPUT - $'he::90002:90002:oops dup name:/home/he:/bin/ksh
noaccess:*:60002:60002:uid no access:/dev/null:/dev/null
nobody:*:60001:60001:original nobody uid:/dev/null:/dev/null
he::30002:30002:Hammond Egger:/home/he:/bin/ksh
jethro::00030001:80001:oops dup uid number different text:/home/he:/bin/ksh
as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh
lg:*:30001:10003:Len Gernwolf:/home/lg:/bin/ksh
dup::998:998:oops dup uid gid:/home/he:/bin/ksh
demos:*:993:997:Demonstration User:/usr/demos:/bin/csh
ftp:*:112:112:File Transfer:/home/ftp:/dev/null
auditor:*:11:0:Audit Activity Owner:/auditor:/bin/sh
lp:*:9:9:Print Spooler Owner:/var/spool/lp:/bin/sh
adm:*:5:3:Accounting Files Owner:/var/adm:/bin/sh
sys:*:4:0:System Activity Owner:/var/adm:/bin/sh
uucp:*:3:5:UUCP Owner:/usr/lib/uucp:/bin/csh
bin:*:2:2:System Tools Owner:/bin:/dev/null
daemon:*:1:1:daemons:/:/dev/null
sysadm:*:0:9:System V Administration:/usr/admin:/bin/sh
root:*:0:0:Super-User:/:/bin/csh
aha::-2:0::/:/bin/sh
diag:*:-3:996:Hardware Diagnostics:/usr/diags:/bin/csh'
TEST 03 'sort uniq count threshhold'
EXEC -x $data/pwd.dss '{sort --count uid}' $data/pwd.dat
OUTPUT - $'1 diag:*:-3:996:Hardware Diagnostics:/usr/diags:/bin/csh
1 aha::-2:0::/:/bin/sh
1 sysadm:*:0:9:System V Administration:/usr/admin:/bin/sh
1 daemon:*:1:1:daemons:/:/dev/null
1 bin:*:2:2:System Tools Owner:/bin:/dev/null
1 uucp:*:3:5:UUCP Owner:/usr/lib/uucp:/bin/csh
1 sys:*:4:0:System Activity Owner:/var/adm:/bin/sh
1 adm:*:5:3:Accounting Files Owner:/var/adm:/bin/sh
1 lp:*:9:9:Print Spooler Owner:/var/spool/lp:/bin/sh
1 auditor:*:11:0:Audit Activity Owner:/auditor:/bin/sh
1 ftp:*:112:112:File Transfer:/home/ftp:/dev/null
1 demos:*:993:997:Demonstration User:/usr/demos:/bin/csh
1 dup::998:998:oops dup uid gid:/home/he:/bin/ksh
1 jethro::00030001:80001:oops dup uid number different text:/home/he:/bin/ksh
1 lg:*:30001:10003:Len Gernwolf:/home/lg:/bin/ksh
1 he::30002:30002:Hammond Egger:/home/he:/bin/ksh
1 nobody:*:60001:60001:original nobody uid:/dev/null:/dev/null
1 noaccess:*:60002:60002:uid no access:/dev/null:/dev/null
1 he::90002:90002:oops dup name:/home/he:/bin/ksh
2 root:*:0:0:Super-User:/:/bin/csh
2 guest:*:998:998:Guest Account:/usr/people/guest:/bin/csh
3 as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh'
EXEC -x $data/pwd.dss '{sort --count=1 uid}' $data/pwd.dat
EXEC -x $data/pwd.dss '{sort --count=2 uid}' $data/pwd.dat
OUTPUT - $'2 root:*:0:0:Super-User:/:/bin/csh
2 guest:*:998:998:Guest Account:/usr/people/guest:/bin/csh
3 as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh'
EXEC -x $data/pwd.dss '{sort --count=3 uid}' $data/pwd.dat
OUTPUT - $'3 as:*:30001:30001:Alan Smithee:/home/as:/bin/ksh'
EXEC -x $data/pwd.dss '{sort --count=4 uid}' $data/pwd.dat
OUTPUT -
