blob: 349da10460f914caf42be09085e955f21c968fa2 (
plain)
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
|
--**************** testing built-in type char16 **************
--
-- all inputs are silently truncated at 16 characters
--
-- fixed-length by reference
SELECT 'char 16 string'::char16 = 'char 16 string'::char16 AS "True";
SELECT 'char 16 string'::char16 = 'char 16 string '::char16 AS "False";
--
--
--
CREATE TABLE CHAR16_TBL(f1 char16);
INSERT INTO CHAR16_TBL(f1) VALUES ('ABCDEFGHIJKLMNOP');
INSERT INTO CHAR16_TBL(f1) VALUES ('abcdefghijklmnop');
INSERT INTO CHAR16_TBL(f1) VALUES ('asdfghjkl;');
INSERT INTO CHAR16_TBL(f1) VALUES ('343f%2a');
INSERT INTO CHAR16_TBL(f1) VALUES ('d34aaasdf');
INSERT INTO CHAR16_TBL(f1) VALUES ('');
INSERT INTO CHAR16_TBL(f1) VALUES ('1234567890ABCDEFGHIJKLMNOPQRSTUV');
SELECT '' AS seven, CHAR16_TBL.*;
SELECT '' AS six, c.f1 FROM CHAR16_TBL c WHERE c.f1 <> 'ABCDEFGHIJKLMNOP';
SELECT '' AS one, c.f1 FROM CHAR16_TBL c WHERE c.f1 = 'ABCDEFGHIJKLMNOP';
SELECT '' AS three, c.f1 FROM CHAR16_TBL c WHERE c.f1 < 'ABCDEFGHIJKLMNOP';
SELECT '' AS four, c.f1 FROM CHAR16_TBL c WHERE c.f1 <= 'ABCDEFGHIJKLMNOP';
SELECT '' AS three, c.f1 FROM CHAR16_TBL c WHERE c.f1 > 'ABCDEFGHIJKLMNOP';
SELECT '' AS four, c.f1 FROM CHAR16_TBL c WHERE c.f1 >= 'ABCDEFGHIJKLMNOP';
SELECT '' AS seven, c.f1 FROM CHAR16_TBL c WHERE c.f1 ~ '.*';
SELECT '' AS zero, c.f1 FROM CHAR16_TBL c WHERE c.f1 !~ '.*';
SELECT '' AS three, c.f1 FROM CHAR16_TBL c WHERE c.f1 ~ '[0-9]';
SELECT '' AS two, c.f1 FROM CHAR16_TBL c WHERE c.f1 ~ '.*asdf.*';
DROP TABLE CHAR16_TBL;
|
