OOFILE Validation Suite - Test 7
Simple test to demonstrate comparative searches
using a database similar to ooftest2 but with lots of indexed fields
Dumping database in key order by LongUnsigned (reverse of Salary)
Last Name   Other names LongUnsigned    

DENT    Trissa  4294957296  
Taylor  Ken 4294959795  
Denton  Andy    4294962295  
Smith   John    4294965295  


Retrieving Andy Denton by ShortUnsigned == 25,000: 
Last Name   Other names ShortUnsigned   

Denton  Andy    25000   


Finding LongUnsigned between 4294962294 and 4294967295
Last Name   Other names LongUnsigned    

Smith   John    4294965295  
Denton  Andy    4294962295  


Dumping database in key order by Last Name
Last Name   Other names Last Name   

DENT    Trissa  DENT    
Denton  Andy    Denton  
Smith   John    Smith   
Taylor  Ken Taylor  


Finding Last Name starting with DE
Last Name   Other names Last Name   

DENT    Trissa  DENT    
Denton  Andy    Denton  


Finding Last Name == Dent
Last Name   Other names Last Name   

DENT    Trissa  DENT    


Finding Last Name < Dent
Last Name   Other names Last Name   



Finding Last Name <= Dent
Last Name   Other names Last Name   

DENT    Trissa  DENT    


Finding Last Name > Dent
Last Name   Other names Last Name   

Smith   John    Smith   
Denton  Andy    Denton  
Taylor  Ken Taylor  


Finding Last Name >= Dent
Last Name   Other names Last Name   

Smith   John    Smith   
DENT    Trissa  DENT    
Denton  Andy    Denton  
Taylor  Ken Taylor  


Finding Last Name between Dent and Denton
Last Name   Other names Last Name   

DENT    Trissa  DENT    
Denton  Andy    Denton  


Finding Last Name outside Dent to Denton
Last Name   Other names Last Name   

Smith   John    Smith   
Taylor  Ken Taylor  


Dumping database in key order by Other names
Last Name   Other names Other names 

Denton  Andy    Andy    
Smith   John    John    
Taylor  Ken Ken 
DENT    Trissa  Trissa  


Finding Other names starting with J
Last Name   Other names Other names 

Smith   John    John    


Finding Other names == Andy
Last Name   Other names Other names 

Denton  Andy    Andy    


Finding Other names < Andy
Last Name   Other names Other names 



Finding Other names <= Andy
Last Name   Other names Other names 

Denton  Andy    Andy    


Finding Other names > Andy
Last Name   Other names Other names 

Smith   John    John    
DENT    Trissa  Trissa  
Taylor  Ken Ken 


Finding Other names >= Andy
Last Name   Other names Other names 

Smith   John    John    
DENT    Trissa  Trissa  
Denton  Andy    Andy    
Taylor  Ken Ken 


Finding Other names between Andy and Kell
Last Name   Other names Other names 

Smith   John    John    
Denton  Andy    Andy    


Finding Other names outside Andy to Kell
Last Name   Other names Other names 

DENT    Trissa  Trissa  
Taylor  Ken Ken 


Dumping database in key order by SalaryShort
Last Name   Other names SalaryShort 

Smith   John    2000    
Denton  Andy    5000    
Taylor  Ken 7500    
DENT    Trissa  9999    


Retrieving Andy Denton by SalaryShort = 5000: 
Last Name   Other names SalaryShort 

Denton  Andy    5000    


Retrieving John Smith by SalaryShort < 5000: 
Last Name   Other names SalaryShort 

Smith   John    2000    


Retrieving Smith & Andy Denton by SalaryShort <= 5000: 
Last Name   Other names SalaryShort 

Smith   John    2000    
Denton  Andy    5000    


Retrieving Taylor & Trissa Dent by SalaryShort > 5000: 
Last Name   Other names SalaryShort 

DENT    Trissa  9999    
Taylor  Ken 7500    


Same search with >=5000 (should also get Andy Denton): 
Last Name   Other names SalaryShort 

DENT    Trissa  9999    
Denton  Andy    5000    
Taylor  Ken 7500    


Finding SalaryShort between 5000 and 7500 
Last Name   Other names SalaryShort 

Denton  Andy    5000    
Taylor  Ken 7500    


Finding SalaryShort outside 5000 to 7500 
Last Name   Other names SalaryShort 

Smith   John    2000    
DENT    Trissa  9999    


done
Dumping database in key order by SalaryShortNoDup
Last Name   Other names SalaryShortNoDup    

Smith   John    2000    
Denton  Andy    5000    
Taylor  Ken 7500    
DENT    Trissa  9999    


Retrieving Andy Denton by SalaryShortNoDup = 5000: 
Last Name   Other names SalaryShortNoDup    

Denton  Andy    5000    


Retrieving John Smith by SalaryShortNoDup < 5000: 
Last Name   Other names SalaryShortNoDup    

Smith   John    2000    


Retrieving Smith & Andy Denton by SalaryShortNoDup <= 5000: 
Last Name   Other names SalaryShortNoDup    

Smith   John    2000    
Denton  Andy    5000    


Retrieving Taylor & Trissa Dent by SalaryShortNoDup > 5000: 
Last Name   Other names SalaryShortNoDup    

DENT    Trissa  9999    
Taylor  Ken 7500    


Same search with >=5000 (should also get Andy Denton): 
Last Name   Other names SalaryShortNoDup    

DENT    Trissa  9999    
Denton  Andy    5000    
Taylor  Ken 7500    


Finding SalaryShortNoDup between 5000 and 7500 
Last Name   Other names SalaryShortNoDup    

Denton  Andy    5000    
Taylor  Ken 7500    


Finding SalaryShortNoDup outside 5000 to 7500 
Last Name   Other names SalaryShortNoDup    

Smith   John    2000    
DENT    Trissa  9999    


done
Dumping database in key order by Salary
Last Name   Other names Salary  

Smith   John    2000    
Denton  Andy    5000    
Taylor  Ken 7500    
DENT    Trissa  9999    


Retrieving Andy Denton by Salary = 5000: 
Last Name   Other names Salary  

Denton  Andy    5000    


Retrieving John Smith by Salary < 5000: 
Last Name   Other names Salary  

Smith   John    2000    


Retrieving Smith & Andy Denton by Salary <= 5000: 
Last Name   Other names Salary  

Smith   John    2000    
Denton  Andy    5000    


Retrieving Taylor & Trissa Dent by Salary > 5000: 
Last Name   Other names Salary  

DENT    Trissa  9999    
Taylor  Ken 7500    


Same search with >=5000 (should also get Andy Denton): 
Last Name   Other names Salary  

DENT    Trissa  9999    
Denton  Andy    5000    
Taylor  Ken 7500    


Finding Salary between 5000 and 7500 
Last Name   Other names Salary  

Denton  Andy    5000    
Taylor  Ken 7500    


Finding Salary outside 5000 to 7500 
Last Name   Other names Salary  

Smith   John    2000    
DENT    Trissa  9999    


done
Dumping database in key order by Salary NoDup
Last Name   Other names Salary NoDup    

Smith   John    2000    
Denton  Andy    5000    
Taylor  Ken 7500    
DENT    Trissa  9999    


Retrieving Andy Denton by Salary NoDup = 5000: 
Last Name   Other names Salary NoDup    

Denton  Andy    5000    


Retrieving John Smith by Salary NoDup < 5000: 
Last Name   Other names Salary NoDup    

Smith   John    2000    


Retrieving Smith & Andy Denton by Salary NoDup <= 5000: 
Last Name   Other names Salary NoDup    

Smith   John    2000    
Denton  Andy    5000    


Retrieving Taylor & Trissa Dent by Salary NoDup > 5000: 
Last Name   Other names Salary NoDup    

DENT    Trissa  9999    
Taylor  Ken 7500    


Same search with >=5000 (should also get Andy Denton): 
Last Name   Other names Salary NoDup    

DENT    Trissa  9999    
Denton  Andy    5000    
Taylor  Ken 7500    


Finding Salary NoDup between 5000 and 7500 
Last Name   Other names Salary NoDup    

Denton  Andy    5000    
Taylor  Ken 7500    


Finding Salary NoDup outside 5000 to 7500 
Last Name   Other names Salary NoDup    

Smith   John    2000    
DENT    Trissa  9999    


done
Dumping database in key order by SalaryReal
Last Name   Other names SalaryReal  

Smith   John    2000    
Denton  Andy    5000    
Taylor  Ken 7500    
DENT    Trissa  9999    


Retrieving Andy Denton by SalaryReal = 5000: 
Last Name   Other names SalaryReal  

Denton  Andy    5000    


Retrieving John Smith by SalaryReal < 5000: 
Last Name   Other names SalaryReal  

Smith   John    2000    


Retrieving Smith & Andy Denton by SalaryReal <= 5000: 
Last Name   Other names SalaryReal  

Smith   John    2000    
Denton  Andy    5000    


Retrieving Taylor & Trissa Dent by SalaryReal > 5000: 
Last Name   Other names SalaryReal  

DENT    Trissa  9999    
Taylor  Ken 7500    


Same search with >=5000 (should also get Andy Denton): 
Last Name   Other names SalaryReal  

DENT    Trissa  9999    
Denton  Andy    5000    
Taylor  Ken 7500    


Finding SalaryReal between 5000 and 7500 
Last Name   Other names SalaryReal  

Denton  Andy    5000    
Taylor  Ken 7500    


Finding SalaryReal outside 5000 to 7500 
Last Name   Other names SalaryReal  

Smith   John    2000    
DENT    Trissa  9999    


done
Dumping database in key order by SalaryRealNoDup
Last Name   Other names SalaryRealNoDup 

Smith   John    2000    
Denton  Andy    5000    
Taylor  Ken 7500    
DENT    Trissa  9999    


Retrieving Andy Denton by SalaryRealNoDup = 5000: 
Last Name   Other names SalaryRealNoDup 

Denton  Andy    5000    


Retrieving John Smith by SalaryRealNoDup < 5000: 
Last Name   Other names SalaryRealNoDup 

Smith   John    2000    


Retrieving Smith & Andy Denton by SalaryRealNoDup <= 5000: 
Last Name   Other names SalaryRealNoDup 

Smith   John    2000    
Denton  Andy    5000    


Retrieving Taylor & Trissa Dent by SalaryRealNoDup > 5000: 
Last Name   Other names SalaryRealNoDup 

DENT    Trissa  9999    
Taylor  Ken 7500    


Same search with >=5000 (should also get Andy Denton): 
Last Name   Other names SalaryRealNoDup 

DENT    Trissa  9999    
Denton  Andy    5000    
Taylor  Ken 7500    


Finding SalaryRealNoDup between 5000 and 7500 
Last Name   Other names SalaryRealNoDup 

Denton  Andy    5000    
Taylor  Ken 7500    


Finding SalaryRealNoDup outside 5000 to 7500 
Last Name   Other names SalaryRealNoDup 

Smith   John    2000    
DENT    Trissa  9999    


done
Dumping database in key order by LastVisit
Last Name   Other names LastVisit   

DENT    Trissa  22/11/1994 0:00:00  
Smith   John    23/11/1994 0:00:00  
Denton  Andy    23/1/1995 0:00:00   
Taylor  Ken 16/11/1995 0:00:00  


Finding LastVisit == 23/11/94
Last Name   Other names LastVisit   

Smith   John    23/11/1994 0:00:00  


Finding LastVisit < 23/11/94
Last Name   Other names LastVisit   

DENT    Trissa  22/11/1994 0:00:00  


Finding LastVisit <= 23/11/94
Last Name   Other names LastVisit   

Smith   John    23/11/1994 0:00:00  
DENT    Trissa  22/11/1994 0:00:00  


Finding LastVisit > 23/11/94
Last Name   Other names LastVisit   

Denton  Andy    23/1/1995 0:00:00   
Taylor  Ken 16/11/1995 0:00:00  


Finding LastVisit >= 23/11/94
Last Name   Other names LastVisit   

Smith   John    23/11/1994 0:00:00  
Denton  Andy    23/1/1995 0:00:00   
Taylor  Ken 16/11/1995 0:00:00  


Finding LastVisit between 23/11/94 and 23-1-95
Last Name   Other names LastVisit   

Smith   John    23/11/1994 0:00:00  
Denton  Andy    23/1/1995 0:00:00   


Finding LastVisit outside 23/11/94 to 23-1-95
Last Name   Other names LastVisit   

DENT    Trissa  22/11/1994 0:00:00  
Taylor  Ken 16/11/1995 0:00:00  


Dumping database in key order by LastVisitNoDup
Last Name   Other names LastVisitNoDup  

DENT    Trissa  22/11/1994 0:00:00  
Smith   John    23/11/1994 0:00:00  
Denton  Andy    23/1/1995 0:00:00   
Taylor  Ken 16/11/1995 0:00:00  


Finding LastVisitNoDup == 23/11/94
Last Name   Other names LastVisitNoDup  

Smith   John    23/11/1994 0:00:00  


Finding LastVisitNoDup < 23/11/94
Last Name   Other names LastVisitNoDup  

DENT    Trissa  22/11/1994 0:00:00  


Finding LastVisitNoDup <= 23/11/94
Last Name   Other names LastVisitNoDup  

Smith   John    23/11/1994 0:00:00  
DENT    Trissa  22/11/1994 0:00:00  


Finding LastVisitNoDup > 23/11/94
Last Name   Other names LastVisitNoDup  

Denton  Andy    23/1/1995 0:00:00   
Taylor  Ken 16/11/1995 0:00:00  


Finding LastVisitNoDup >= 23/11/94
Last Name   Other names LastVisitNoDup  

Smith   John    23/11/1994 0:00:00  
Denton  Andy    23/1/1995 0:00:00   
Taylor  Ken 16/11/1995 0:00:00  


Finding LastVisitNoDup between 23/11/94 and 22-1-95
Last Name   Other names LastVisitNoDup  

Smith   John    23/11/1994 0:00:00  


Finding LastVisitNoDup outside 23/11/94 to 22-1-95
Last Name   Other names LastVisitNoDup  

DENT    Trissa  22/11/1994 0:00:00  
Denton  Andy    23/1/1995 0:00:00   
Taylor  Ken 16/11/1995 0:00:00  


done