1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
|
#------------------------------------------------------------
# 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
|