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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
|
#!/bin/bash
set -uex
# A unique working directory
wd=$(pwd)
test_wd=$(pwd)/test_odb_sql_variables
mkdir -p ${test_wd}
cd ${test_wd}
# In case we are resuming from a previous failed run, which has left output in the directory
rm *.odb || true
# Test that variables defined in the schema can be used in queries.
# See ODB-127
cat > schema.hh <<EOF
SET \$var1 = 123;
SET \$var2 = 3.24;
EOF
# Create some test data
cat > data.csv <<EOF
col1:INTEGER,col2:REAL,col3:DOUBLE,col4:INTEGER
1,1.23,4.56,7
123,0.0,0.0,321
321,0.0,0.0,123
0,3.25,0.0,0
0,0.0,3.25,0
EOF
odc import data.csv data.odb
# Runs some selects, to see that the data is correct
odc sql 'select * where col1=1' -i data.odb -f odb -o outfile.odb
cat > expect.csv <<EOF
col1:INTEGER,col2:REAL,col3:DOUBLE,col4:INTEGER
1,1.23,4.56,7
EOF
odc import expect.csv expect.odb
odc compare outfile.odb expect.odb
# --
odc sql '#include "schema.hh"; select * where col1=$var1' -i data.odb -f odb -o outfile.odb
cat > expect.csv <<EOF
col1:INTEGER,col2:REAL,col3:DOUBLE,col4:INTEGER
123,0.0,0.0,321
EOF
odc import expect.csv expect.odb
odc compare outfile.odb expect.odb
# --
odc sql '#include "schema.hh"; select * where col2=$var1' -i data.odb -f odb -o outfile.odb
[[ -e outfile.odb && ! -s outfile.odb ]] # Expect zero sized file
# --
odc sql '#include "schema.hh"; select * where col3=$var1' -i data.odb -f odb -o outfile.odb
[[ -e outfile.odb && ! -s outfile.odb ]] # Expect zero sized file
# --
odc sql '#include "schema.hh"; select * where col4=$var1' -i data.odb -f odb -o outfile.odb
cat > expect.csv <<EOF
col1:INTEGER,col2:REAL,col3:DOUBLE,col4:INTEGER
321,0.0,0.0,123
EOF
odc import expect.csv expect.odb
odc compare outfile.odb expect.odb
# --
odc sql '#include "schema.hh"; select * where col1<$var2' -i data.odb -f odb -o outfile.odb
cat > expect.csv <<EOF
col1:INTEGER,col2:REAL,col3:DOUBLE,col4:INTEGER
1,1.23,4.56,7
0,3.25,0.0,0
0,0.0,3.25,0
EOF
odc import expect.csv expect.odb
odc compare outfile.odb expect.odb
# --
odc sql '#include "schema.hh"; select * where col2<$var2' -i data.odb -f odb -o outfile.odb
cat > expect.csv <<EOF
col1:INTEGER,col2:REAL,col3:DOUBLE,col4:INTEGER
1,1.23,4.56,7
123,0.0,0.0,321
321,0.0,0.0,123
0,0.0,3.25,0
EOF
odc import expect.csv expect.odb
odc compare outfile.odb expect.odb
# --
odc sql '#include "schema.hh"; select * where col3<$var2' -i data.odb -f odb -o outfile.odb
cat > expect.csv <<EOF
col1:INTEGER,col2:REAL,col3:DOUBLE,col4:INTEGER
123,0.0,0.0,321
321,0.0,0.0,123
0,3.25,0.0,0
EOF
odc import expect.csv expect.odb
odc compare outfile.odb expect.odb
# --
odc sql '#include "schema.hh"; select * where col4<$var2' -i data.odb -f odb -o outfile.odb
cat > expect.csv <<EOF
col1:INTEGER,col2:REAL,col3:DOUBLE,col4:INTEGER
0,3.25,0.0,0
0,0.0,3.25,0
EOF
odc import expect.csv expect.odb
odc compare outfile.odb expect.odb
# Clean up
cd ${wd}
rm -rf ${test_wd}
|
