|
5 | 5 | \set ECHO none |
6 | 6 | --test query_int |
7 | 7 | select '1'::query_int; |
8 | | -?column? |
9 | | ----------- |
| 8 | +query_int |
| 9 | +----------- |
10 | 10 | 1 |
11 | 11 | (1 row) |
12 | 12 |
|
13 | 13 | select ' 1'::query_int; |
14 | | -?column? |
15 | | ----------- |
| 14 | +query_int |
| 15 | +----------- |
16 | 16 | 1 |
17 | 17 | (1 row) |
18 | 18 |
|
19 | 19 | select '1 '::query_int; |
20 | | -?column? |
21 | | ----------- |
| 20 | +query_int |
| 21 | +----------- |
22 | 22 | 1 |
23 | 23 | (1 row) |
24 | 24 |
|
25 | 25 | select ' 1 '::query_int; |
26 | | -?column? |
27 | | ----------- |
| 26 | +query_int |
| 27 | +----------- |
28 | 28 | 1 |
29 | 29 | (1 row) |
30 | 30 |
|
31 | 31 | select ' ! 1 '::query_int; |
32 | | -?column? |
33 | | ----------- |
| 32 | +query_int |
| 33 | +----------- |
34 | 34 | !1 |
35 | 35 | (1 row) |
36 | 36 |
|
37 | 37 | select '!1'::query_int; |
38 | | -?column? |
39 | | ----------- |
| 38 | +query_int |
| 39 | +----------- |
40 | 40 | !1 |
41 | 41 | (1 row) |
42 | 42 |
|
43 | 43 | select '1|2'::query_int; |
44 | | -?column? |
45 | | ----------- |
| 44 | +query_int |
| 45 | +----------- |
46 | 46 | 1 | 2 |
47 | 47 | (1 row) |
48 | 48 |
|
49 | 49 | select '1|!2'::query_int; |
50 | | -?column? |
51 | | ----------- |
| 50 | +query_int |
| 51 | +----------- |
52 | 52 | 1 | !2 |
53 | 53 | (1 row) |
54 | 54 |
|
55 | 55 | select '!1|2'::query_int; |
56 | | -?column? |
57 | | ----------- |
| 56 | +query_int |
| 57 | +----------- |
58 | 58 | !1 | 2 |
59 | 59 | (1 row) |
60 | 60 |
|
61 | 61 | select '!1|!2'::query_int; |
62 | | -?column? |
63 | | ----------- |
| 62 | +query_int |
| 63 | +----------- |
64 | 64 | !1 | !2 |
65 | 65 | (1 row) |
66 | 66 |
|
67 | 67 | select '!(!1|!2)'::query_int; |
68 | | - ?column? |
| 68 | +query_int |
69 | 69 | -------------- |
70 | 70 | !( !1 | !2 ) |
71 | 71 | (1 row) |
72 | 72 |
|
73 | 73 | select '!(!1|2)'::query_int; |
74 | | -?column? |
| 74 | +query_int |
75 | 75 | ------------- |
76 | 76 | !( !1 | 2 ) |
77 | 77 | (1 row) |
78 | 78 |
|
79 | 79 | select '!(1|!2)'::query_int; |
80 | | -?column? |
| 80 | +query_int |
81 | 81 | ------------- |
82 | 82 | !( 1 | !2 ) |
83 | 83 | (1 row) |
84 | 84 |
|
85 | 85 | select '!(1|2)'::query_int; |
86 | | - ?column? |
| 86 | +query_int |
87 | 87 | ------------ |
88 | 88 | !( 1 | 2 ) |
89 | 89 | (1 row) |
90 | 90 |
|
91 | 91 | select '1&2'::query_int; |
92 | | -?column? |
93 | | ----------- |
| 92 | +query_int |
| 93 | +----------- |
94 | 94 | 1 & 2 |
95 | 95 | (1 row) |
96 | 96 |
|
97 | 97 | select '!1&2'::query_int; |
98 | | -?column? |
99 | | ----------- |
| 98 | +query_int |
| 99 | +----------- |
100 | 100 | !1 & 2 |
101 | 101 | (1 row) |
102 | 102 |
|
103 | 103 | select '1&!2'::query_int; |
104 | | -?column? |
105 | | ----------- |
| 104 | +query_int |
| 105 | +----------- |
106 | 106 | 1 & !2 |
107 | 107 | (1 row) |
108 | 108 |
|
109 | 109 | select '!1&!2'::query_int; |
110 | | -?column? |
111 | | ----------- |
| 110 | +query_int |
| 111 | +----------- |
112 | 112 | !1 & !2 |
113 | 113 | (1 row) |
114 | 114 |
|
115 | 115 | select '(1&2)'::query_int; |
116 | | -?column? |
117 | | ----------- |
| 116 | +query_int |
| 117 | +----------- |
118 | 118 | 1 & 2 |
119 | 119 | (1 row) |
120 | 120 |
|
121 | 121 | select '1&(2)'::query_int; |
122 | | -?column? |
123 | | ----------- |
| 122 | +query_int |
| 123 | +----------- |
124 | 124 | 1 & 2 |
125 | 125 | (1 row) |
126 | 126 |
|
127 | 127 | select '!(1)&2'::query_int; |
128 | | -?column? |
129 | | ----------- |
| 128 | +query_int |
| 129 | +----------- |
130 | 130 | !1 & 2 |
131 | 131 | (1 row) |
132 | 132 |
|
133 | 133 | select '!(1&2)'::query_int; |
134 | | - ?column? |
| 134 | +query_int |
135 | 135 | ------------ |
136 | 136 | !( 1 & 2 ) |
137 | 137 | (1 row) |
138 | 138 |
|
139 | 139 | select '1|2&3'::query_int; |
140 | | -?column? |
| 140 | +query_int |
141 | 141 | ----------- |
142 | 142 | 1 | 2 & 3 |
143 | 143 | (1 row) |
144 | 144 |
|
145 | 145 | select '1|(2&3)'::query_int; |
146 | | -?column? |
| 146 | +query_int |
147 | 147 | ----------- |
148 | 148 | 1 | 2 & 3 |
149 | 149 | (1 row) |
150 | 150 |
|
151 | 151 | select '(1|2)&3'::query_int; |
152 | | -?column? |
| 152 | +query_int |
153 | 153 | --------------- |
154 | 154 | ( 1 | 2 ) & 3 |
155 | 155 | (1 row) |
156 | 156 |
|
157 | 157 | select '1|2&!3'::query_int; |
158 | | - ?column? |
| 158 | +query_int |
159 | 159 | ------------ |
160 | 160 | 1 | 2 & !3 |
161 | 161 | (1 row) |
162 | 162 |
|
163 | 163 | select '1|!2&3'::query_int; |
164 | | - ?column? |
| 164 | +query_int |
165 | 165 | ------------ |
166 | 166 | 1 | !2 & 3 |
167 | 167 | (1 row) |
168 | 168 |
|
169 | 169 | select '!1|2&3'::query_int; |
170 | | - ?column? |
| 170 | +query_int |
171 | 171 | ------------ |
172 | 172 | !1 | 2 & 3 |
173 | 173 | (1 row) |
174 | 174 |
|
175 | 175 | select '!1|(2&3)'::query_int; |
176 | | - ?column? |
| 176 | +query_int |
177 | 177 | ------------ |
178 | 178 | !1 | 2 & 3 |
179 | 179 | (1 row) |
180 | 180 |
|
181 | 181 | select '!(1|2)&3'::query_int; |
182 | | - ?column? |
| 182 | +query_int |
183 | 183 | ---------------- |
184 | 184 | !( 1 | 2 ) & 3 |
185 | 185 | (1 row) |
186 | 186 |
|
187 | 187 | select '(!1|2)&3'::query_int; |
188 | | - ?column? |
| 188 | +query_int |
189 | 189 | ---------------- |
190 | 190 | ( !1 | 2 ) & 3 |
191 | 191 | (1 row) |
192 | 192 |
|
193 | 193 | select '1|(2|(4|(5|6)))'::query_int; |
194 | | -?column? |
| 194 | +query_int |
195 | 195 | ------------------------------- |
196 | 196 | 1 | ( 2 | ( 4 | ( 5 | 6 ) ) ) |
197 | 197 | (1 row) |
198 | 198 |
|
199 | 199 | select '1|2|4|5|6'::query_int; |
200 | | -?column? |
| 200 | +query_int |
201 | 201 | ------------------------------- |
202 | 202 | ( ( ( 1 | 2 ) | 4 ) | 5 ) | 6 |
203 | 203 | (1 row) |
204 | 204 |
|
205 | 205 | select '1&(2&(4&(5&6)))'::query_int; |
206 | | -?column? |
| 206 | +query_int |
207 | 207 | ------------------- |
208 | 208 | 1 & 2 & 4 & 5 & 6 |
209 | 209 | (1 row) |
210 | 210 |
|
211 | 211 | select '1&2&4&5&6'::query_int; |
212 | | -?column? |
| 212 | +query_int |
213 | 213 | ------------------- |
214 | 214 | 1 & 2 & 4 & 5 & 6 |
215 | 215 | (1 row) |
216 | 216 |
|
217 | 217 | select '1&(2&(4&(5|6)))'::query_int; |
218 | | -?column? |
| 218 | +query_int |
219 | 219 | ----------------------- |
220 | 220 | 1 & 2 & 4 & ( 5 | 6 ) |
221 | 221 | (1 row) |
222 | 222 |
|
223 | 223 | select '1&(2&(4&(5|!6)))'::query_int; |
224 | | - ?column? |
| 224 | +query_int |
225 | 225 | ------------------------ |
226 | 226 | 1 & 2 & 4 & ( 5 | !6 ) |
227 | 227 | (1 row) |
|