OOFILE Validation Suite - Test 17 Simple test to demonstrate comparative searches using a database identical to ooftst07 except without indices Dumping database in key order by LongUnsigned (reverse of Salary) Taylor Ken 4294959795 Denton Andy 4294962295 DENT Trissa 4294957296 Smith John 4294965295 Retrieving Andy Denton by ShortUnsigned == 25,000: Denton Andy 25000 Finding LongUnsigned between 4294962294 and 4294967295 Denton Andy 4294962295 Smith John 4294965295 Dumping database in key order by Last Name Taylor Ken Taylor Denton Andy Denton DENT Trissa DENT Smith John Smith Finding Last Name starting with DE Denton Andy Denton DENT Trissa DENT Finding Last Name == Dent DENT Trissa DENT Finding Last Name < Dent Finding Last Name <= Dent DENT Trissa DENT Finding Last Name > Dent Taylor Ken Taylor Denton Andy Denton Smith John Smith Finding Last Name >= Dent Taylor Ken Taylor Denton Andy Denton DENT Trissa DENT Smith John Smith Finding Last Name between Dent and Denton Denton Andy Denton DENT Trissa DENT Finding Last Name outside Dent to Denton Taylor Ken Taylor Smith John Smith Dumping database in key order by Other names Taylor Ken Ken Denton Andy Andy DENT Trissa Trissa Smith John John Finding Other names starting with J Smith John John Finding Other names == Andy Denton Andy Andy Finding Other names < Andy Finding Other names <= Andy Denton Andy Andy Finding Other names > Andy Taylor Ken Ken DENT Trissa Trissa Smith John John Finding Other names >= Andy Taylor Ken Ken Denton Andy Andy DENT Trissa Trissa Smith John John Finding Other names between Andy and Kell Denton Andy Andy Smith John John Finding Other names outside Andy to Kell Taylor Ken Ken DENT Trissa Trissa Dumping database in key order by SalaryShort Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Smith John 2000 Retrieving Andy Denton by SalaryShort = 5000: Denton Andy 5000 Retrieving John Smith by SalaryShort < 5000: Smith John 2000 Retrieving Smith & Andy Denton by SalaryShort <= 5000: Denton Andy 5000 Smith John 2000 Retrieving Taylor & Trissa Dent by SalaryShort > 5000: Taylor Ken 7500 DENT Trissa 9999 Same search with >=5000 (should also get Andy Denton): Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Finding SalaryShort between 5000 and 7500 Taylor Ken 7500 Denton Andy 5000 Finding SalaryShort outside 5000 to 7500 DENT Trissa 9999 Smith John 2000 Dumping database in key order by SalaryShortNoDup Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Smith John 2000 Retrieving Andy Denton by SalaryShortNoDup = 5000: Denton Andy 5000 Retrieving John Smith by SalaryShortNoDup < 5000: Smith John 2000 Retrieving Smith & Andy Denton by SalaryShortNoDup <= 5000: Denton Andy 5000 Smith John 2000 Retrieving Taylor & Trissa Dent by SalaryShortNoDup > 5000: Taylor Ken 7500 DENT Trissa 9999 Same search with >=5000 (should also get Andy Denton): Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Finding SalaryShortNoDup between 5000 and 7500 Taylor Ken 7500 Denton Andy 5000 Finding SalaryShortNoDup outside 5000 to 7500 DENT Trissa 9999 Smith John 2000 Dumping database in key order by Salary Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Smith John 2000 Retrieving Andy Denton by Salary = 5000: Denton Andy 5000 Retrieving John Smith by Salary < 5000: Smith John 2000 Retrieving Smith & Andy Denton by Salary <= 5000: Denton Andy 5000 Smith John 2000 Retrieving Taylor & Trissa Dent by Salary > 5000: Taylor Ken 7500 DENT Trissa 9999 Same search with >=5000 (should also get Andy Denton): Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Finding Salary between 5000 and 7500 Taylor Ken 7500 Denton Andy 5000 Finding Salary outside 5000 to 7500 DENT Trissa 9999 Smith John 2000 Dumping database in key order by Salary NoDup Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Smith John 2000 Retrieving Andy Denton by Salary NoDup = 5000: Denton Andy 5000 Retrieving John Smith by Salary NoDup < 5000: Smith John 2000 Retrieving Smith & Andy Denton by Salary NoDup <= 5000: Denton Andy 5000 Smith John 2000 Retrieving Taylor & Trissa Dent by Salary NoDup > 5000: Taylor Ken 7500 DENT Trissa 9999 Same search with >=5000 (should also get Andy Denton): Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Finding Salary NoDup between 5000 and 7500 Taylor Ken 7500 Denton Andy 5000 Finding Salary NoDup outside 5000 to 7500 DENT Trissa 9999 Smith John 2000 Dumping database in key order by SalaryReal Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Smith John 2000 Retrieving Andy Denton by SalaryReal = 5000: Denton Andy 5000 Retrieving John Smith by SalaryReal < 5000: Smith John 2000 Retrieving Smith & Andy Denton by SalaryReal <= 5000: Denton Andy 5000 Smith John 2000 Retrieving Taylor & Trissa Dent by SalaryReal > 5000: Taylor Ken 7500 DENT Trissa 9999 Same search with >=5000 (should also get Andy Denton): Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Finding SalaryReal between 5000 and 7500 Taylor Ken 7500 Denton Andy 5000 Finding SalaryReal outside 5000 to 7500 DENT Trissa 9999 Smith John 2000 Dumping database in key order by SalaryRealNoDup Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Smith John 2000 Retrieving Andy Denton by SalaryRealNoDup = 5000: Denton Andy 5000 Retrieving John Smith by SalaryRealNoDup < 5000: Smith John 2000 Retrieving Smith & Andy Denton by SalaryRealNoDup <= 5000: Denton Andy 5000 Smith John 2000 Retrieving Taylor & Trissa Dent by SalaryRealNoDup > 5000: Taylor Ken 7500 DENT Trissa 9999 Same search with >=5000 (should also get Andy Denton): Taylor Ken 7500 Denton Andy 5000 DENT Trissa 9999 Finding SalaryRealNoDup between 5000 and 7500 Taylor Ken 7500 Denton Andy 5000 Finding SalaryRealNoDup outside 5000 to 7500 DENT Trissa 9999 Smith John 2000 Dumping database in key order by LastVisit Taylor Ken 16/11/1995 Denton Andy 23/1/1995 DENT Trissa 22/11/1994 Smith John 23/11/1994 Finding LastVisit == 23/11/94 Smith John 23/11/1994 Finding LastVisit < 23/11/94 DENT Trissa 22/11/1994 Finding LastVisit <= 23/11/94 DENT Trissa 22/11/1994 Smith John 23/11/1994 Finding LastVisit > 23/11/94 Taylor Ken 16/11/1995 Denton Andy 23/1/1995 Finding LastVisit >= 23/11/94 Taylor Ken 16/11/1995 Denton Andy 23/1/1995 Smith John 23/11/1994 Finding LastVisit between 23/11/94 and 23-1-95 Denton Andy 23/1/1995 Smith John 23/11/1994 Finding LastVisit outside 23/11/94 to 23-1-95 Taylor Ken 16/11/1995 DENT Trissa 22/11/1994 Dumping database in key order by LastVisitNoDup Taylor Ken 16/11/1995 Denton Andy 23/1/1995 DENT Trissa 22/11/1994 Smith John 23/11/1994 Finding LastVisitNoDup == 23/11/94 Smith John 23/11/1994 Finding LastVisitNoDup < 23/11/94 DENT Trissa 22/11/1994 Finding LastVisitNoDup <= 23/11/94 DENT Trissa 22/11/1994 Smith John 23/11/1994 Finding LastVisitNoDup > 23/11/94 Taylor Ken 16/11/1995 Denton Andy 23/1/1995 Finding LastVisitNoDup >= 23/11/94 Taylor Ken 16/11/1995 Denton Andy 23/1/1995 Smith John 23/11/1994 Finding LastVisitNoDup between 23/11/94 and 22-1-95 Smith John 23/11/1994 Finding LastVisitNoDup outside 23/11/94 to 22-1-95 Taylor Ken 16/11/1995 Denton Andy 23/1/1995 DENT Trissa 22/11/1994 done