The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
#------------------------------------------------------------
# Test for skiphiddedn 
#  This option is created by Ilia Sotnikov.
#  Thank you, Ilia.
#--------------------------------------------------------------
# 1. SELECT(with no params)
#--------------------------------------------------------------
NO	NAME	DEPT	SECRET	MAIL	
1	Emp1	1st row	real:1	Emp1@com
H	Mr.Hide	HIDDEN	real:2	Wmm&.
2	Emp2	2nd row	real:3	hoge@mail
#--------------------------------------------------------------
# 2. SELECT(vtbl)
#--------------------------------------------------------------
NAME	DEPT	SECRET	
Emp1	1st row	real:1
Mr.Hide	HIDDEN	real:2
#--------------------------------------------------------------
# 3. SELECT(with condition)
#--------------------------------------------------------------
NAME	
Mr.Hide
#--------------------------------------------------------------
# 4. SELECT(vtbl:with condition)
#--------------------------------------------------------------
NAME	
Emp1
Mr.Hide
#==============================================================
# SKIPHIDDEN
#==============================================================
#--------------------------------------------------------------
# 1. SELECT(with no params, skip hiddedn)
#--------------------------------------------------------------
NO	NAME	DEPT	MAIL	
1	Emp1	1st row	Emp1@com
2	Emp2	2nd row	hoge@mail
#--------------------------------------------------------------
# 2. SELECT(vtbl, skip hidden)
#--------------------------------------------------------------
NAME	DEPT	
Emp1	1st row
Emp2	2nd row
#--------------------------------------------------------------
# 3. SELECT(with condition)
#--------------------------------------------------------------
NAME	
#--------------------------------------------------------------
# 4. SELECT(vtbl:with condition)
#--------------------------------------------------------------
NAME	
Emp1
#==============================================================
# SKIPHIDDEN+IGONORECASE
#==============================================================
#--------------------------------------------------------------
# 1. SELECT(with no params, skip hiddedn)
#--------------------------------------------------------------
NO	NAME	DEPT	MAIL	
1	Emp1	1st row	Emp1@com
2	Emp2	2nd row	hoge@mail
#--------------------------------------------------------------
# 2. SELECT(vtbl, skip hidden)
#--------------------------------------------------------------
NAME	DEPT	
Emp1	1st row
Emp2	2nd row
#--------------------------------------------------------------
# 3. SELECT(with condition)
#--------------------------------------------------------------
NAME	
#--------------------------------------------------------------
# 4. SELECT(vtbl:with condition)
#--------------------------------------------------------------
NAME	
Emp1