Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit701de35

Browse files
author
Thomas G. Lockhart
committed
Forgot to update the regression test output.
1 parent9426047 commit701de35

File tree

1 file changed

+340
-16
lines changed

1 file changed

+340
-16
lines changed

‎src/test/regress/expected/strings.out

Lines changed: 340 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -92,52 +92,376 @@ SELECT CAST(name 'namefield' AS varchar) AS "varchar(name)";
9292
--
9393
-- test SQL92 string functions
9494
--
95-
SELECT TRIM(BOTH FROM ' bunch o blanks ') AS "bunch o blanks";
95+
SELECT TRIM(BOTH FROM ' bunch o blanks ')= 'bunch o blanks'AS "bunch o blanks";
9696
bunch o blanks
9797
----------------
98-
bunch o blanks
98+
t
9999
(1 row)
100100

101-
SELECT TRIM(LEADING FROM ' bunch o blanks ') AS "bunch o blanks ";
101+
SELECT TRIM(LEADING FROM ' bunch o blanks ')= 'bunch o blanks 'AS "bunch o blanks ";
102102
bunch o blanks
103103
------------------
104-
bunch o blanks
104+
t
105105
(1 row)
106106

107-
SELECT TRIM(TRAILING FROM ' bunch o blanks ') AS " bunch o blanks";
107+
SELECT TRIM(TRAILING FROM ' bunch o blanks ')= ' bunch o blanks'AS " bunch o blanks";
108108
bunch o blanks
109109
------------------
110-
bunch o blanks
110+
t
111111
(1 row)
112112

113-
SELECT TRIM(BOTH 'x' FROM 'xxxxxsome Xsxxxxx') AS "some Xs";
113+
SELECT TRIM(BOTH 'x' FROM 'xxxxxsome Xsxxxxx')= 'some Xs'AS "some Xs";
114114
some Xs
115115
---------
116-
some Xs
116+
t
117117
(1 row)
118118

119-
SELECT SUBSTRING('1234567890' FROM 3) AS "34567890";
119+
SELECT SUBSTRING('1234567890' FROM 3)= '34567890'AS "34567890";
120120
34567890
121121
----------
122-
34567890
122+
t
123123
(1 row)
124124

125-
SELECT SUBSTRING('1234567890' FROM 4 FOR 3) AS "456";
125+
SELECT SUBSTRING('1234567890' FROM 4 FOR 3)= '456'AS "456";
126126
456
127127
-----
128-
456
128+
t
129129
(1 row)
130130

131-
SELECT POSITION('4' IN '1234567890') AS "4";
131+
SELECT POSITION('4' IN '1234567890')= '4'AS "4";
132132
4
133133
---
134-
4
134+
t
135135
(1 row)
136136

137-
SELECT POSITION(5 IN '1234567890') AS "5";
137+
SELECT POSITION(5 IN '1234567890')= '5'AS "5";
138138
5
139139
---
140-
5
140+
t
141+
(1 row)
142+
143+
--
144+
-- test LIKE
145+
-- Be sure to form every test as a LIKE/NOT LIKE pair.
146+
--
147+
-- simplest examples
148+
SELECT 'hawkeye' LIKE 'h%' AS "true";
149+
true
150+
------
151+
t
152+
(1 row)
153+
154+
SELECT 'hawkeye' NOT LIKE 'h%' AS "false";
155+
false
156+
-------
157+
f
158+
(1 row)
159+
160+
SELECT 'hawkeye' LIKE 'H%' AS "false";
161+
false
162+
-------
163+
f
164+
(1 row)
165+
166+
SELECT 'hawkeye' NOT LIKE 'H%' AS "true";
167+
true
168+
------
169+
t
170+
(1 row)
171+
172+
SELECT 'hawkeye' LIKE 'indio%' AS "false";
173+
false
174+
-------
175+
f
176+
(1 row)
177+
178+
SELECT 'hawkeye' NOT LIKE 'indio%' AS "true";
179+
true
180+
------
181+
t
182+
(1 row)
183+
184+
SELECT 'hawkeye' LIKE 'h%eye' AS "true";
185+
true
186+
------
187+
t
188+
(1 row)
189+
190+
SELECT 'hawkeye' NOT LIKE 'h%eye' AS "false";
191+
false
192+
-------
193+
f
194+
(1 row)
195+
196+
SELECT 'indio' LIKE '_ndio' AS "true";
197+
true
198+
------
199+
t
200+
(1 row)
201+
202+
SELECT 'indio' NOT LIKE '_ndio' AS "false";
203+
false
204+
-------
205+
f
206+
(1 row)
207+
208+
SELECT 'indio' LIKE 'in__o' AS "true";
209+
true
210+
------
211+
t
212+
(1 row)
213+
214+
SELECT 'indio' NOT LIKE 'in__o' AS "false";
215+
false
216+
-------
217+
f
218+
(1 row)
219+
220+
SELECT 'indio' LIKE 'in_o' AS "false";
221+
false
222+
-------
223+
f
224+
(1 row)
225+
226+
SELECT 'indio' NOT LIKE 'in_o' AS "true";
227+
true
228+
------
229+
t
230+
(1 row)
231+
232+
-- unused escape character
233+
SELECT 'hawkeye' LIKE 'h%' ESCAPE '#' AS "true";
234+
true
235+
------
236+
t
237+
(1 row)
238+
239+
SELECT 'hawkeye' NOT LIKE 'h%' ESCAPE '#' AS "false";
240+
false
241+
-------
242+
f
243+
(1 row)
244+
245+
SELECT 'indio' LIKE 'ind_o' ESCAPE '$' AS "true";
246+
true
247+
------
248+
t
249+
(1 row)
250+
251+
SELECT 'indio' NOT LIKE 'ind_o' ESCAPE '$' AS "false";
252+
false
253+
-------
254+
f
255+
(1 row)
256+
257+
-- escape character
258+
SELECT 'h%' LIKE 'h#%' ESCAPE '#' AS "true";
259+
true
260+
------
261+
t
262+
(1 row)
263+
264+
SELECT 'h%' NOT LIKE 'h#%' ESCAPE '#' AS "false";
265+
false
266+
-------
267+
f
268+
(1 row)
269+
270+
SELECT 'h%wkeye' LIKE 'h#%' ESCAPE '#' AS "false";
271+
false
272+
-------
273+
f
274+
(1 row)
275+
276+
SELECT 'h%wkeye' NOT LIKE 'h#%' ESCAPE '#' AS "true";
277+
true
278+
------
279+
t
280+
(1 row)
281+
282+
SELECT 'h%wkeye' LIKE 'h#%%' ESCAPE '#' AS "true";
283+
true
284+
------
285+
t
286+
(1 row)
287+
288+
SELECT 'h%wkeye' NOT LIKE 'h#%%' ESCAPE '#' AS "false";
289+
false
290+
-------
291+
f
292+
(1 row)
293+
294+
SELECT 'h%awkeye' LIKE 'h#%a%k%e' ESCAPE '#' AS "true";
295+
true
296+
------
297+
t
298+
(1 row)
299+
300+
SELECT 'h%awkeye' NOT LIKE 'h#%a%k%e' ESCAPE '#' AS "false";
301+
false
302+
-------
303+
f
304+
(1 row)
305+
306+
SELECT 'indio' LIKE '_ndio' ESCAPE '$' AS "true";
307+
true
308+
------
309+
t
310+
(1 row)
311+
312+
SELECT 'indio' NOT LIKE '_ndio' ESCAPE '$' AS "false";
313+
false
314+
-------
315+
f
316+
(1 row)
317+
318+
SELECT 'i_dio' LIKE 'i$_d_o' ESCAPE '$' AS "true";
319+
true
320+
------
321+
t
322+
(1 row)
323+
324+
SELECT 'i_dio' NOT LIKE 'i$_d_o' ESCAPE '$' AS "false";
325+
false
326+
-------
327+
f
328+
(1 row)
329+
330+
SELECT 'i_dio' LIKE 'i$_nd_o' ESCAPE '$' AS "false";
331+
false
332+
-------
333+
f
334+
(1 row)
335+
336+
SELECT 'i_dio' NOT LIKE 'i$_nd_o' ESCAPE '$' AS "true";
337+
true
338+
------
339+
t
340+
(1 row)
341+
342+
SELECT 'i_dio' LIKE 'i$_d%o' ESCAPE '$' AS "true";
343+
true
344+
------
345+
t
346+
(1 row)
347+
348+
SELECT 'i_dio' NOT LIKE 'i$_d%o' ESCAPE '$' AS "false";
349+
false
350+
-------
351+
f
352+
(1 row)
353+
354+
-- escape character same as pattern character
355+
SELECT 'maca' LIKE 'm%aca' ESCAPE '%' AS "true";
356+
true
357+
------
358+
t
359+
(1 row)
360+
361+
SELECT 'maca' NOT LIKE 'm%aca' ESCAPE '%' AS "false";
362+
false
363+
-------
364+
f
365+
(1 row)
366+
367+
SELECT 'ma%a' LIKE 'm%a%%a' ESCAPE '%' AS "true";
368+
true
369+
------
370+
t
371+
(1 row)
372+
373+
SELECT 'ma%a' NOT LIKE 'm%a%%a' ESCAPE '%' AS "false";
374+
false
375+
-------
376+
f
377+
(1 row)
378+
379+
SELECT 'bear' LIKE 'b_ear' ESCAPE '_' AS "true";
380+
true
381+
------
382+
t
383+
(1 row)
384+
385+
SELECT 'bear' NOT LIKE 'b_ear' ESCAPE '_' AS "false";
386+
false
387+
-------
388+
f
389+
(1 row)
390+
391+
SELECT 'be_r' LIKE 'b_e__r' ESCAPE '_' AS "true";
392+
true
393+
------
394+
t
395+
(1 row)
396+
397+
SELECT 'be_r' NOT LIKE 'b_e__r' ESCAPE '_' AS "false";
398+
false
399+
-------
400+
f
401+
(1 row)
402+
403+
SELECT 'be_r' LIKE '__e__r' ESCAPE '_' AS "false";
404+
false
405+
-------
406+
f
407+
(1 row)
408+
409+
SELECT 'be_r' NOT LIKE '__e__r' ESCAPE '_' AS "true";
410+
true
411+
------
412+
t
413+
(1 row)
414+
415+
--
416+
-- test ILIKE (case-insensitive LIKE)
417+
-- Be sure to form every test as an ILIKE/NOT ILIKE pair.
418+
--
419+
SELECT 'hawkeye' ILIKE 'h%' AS "true";
420+
true
421+
------
422+
t
423+
(1 row)
424+
425+
SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
426+
false
427+
-------
428+
f
429+
(1 row)
430+
431+
SELECT 'hawkeye' ILIKE 'H%' AS "true";
432+
true
433+
------
434+
t
435+
(1 row)
436+
437+
SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
438+
false
439+
-------
440+
f
441+
(1 row)
442+
443+
SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
444+
true
445+
------
446+
f
447+
(1 row)
448+
449+
SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
450+
false
451+
-------
452+
t
453+
(1 row)
454+
455+
SELECT 'Hawkeye' ILIKE 'h%' AS "true";
456+
true
457+
------
458+
t
459+
(1 row)
460+
461+
SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
462+
false
463+
-------
464+
f
141465
(1 row)
142466

143467
--

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp