5
-- fixed-length by value
6
-- internally passed by value if <= 4 bytes in storage
8
SELECT char 'c' = char 'c' AS true;
11
-- Build a table for testing
14
CREATE TABLE CHAR_TBL(f1 char);
16
INSERT INTO CHAR_TBL (f1) VALUES ('a');
18
INSERT INTO CHAR_TBL (f1) VALUES ('A');
20
-- any of the following three input formats are acceptable
21
INSERT INTO CHAR_TBL (f1) VALUES ('1');
23
INSERT INTO CHAR_TBL (f1) VALUES (2);
25
INSERT INTO CHAR_TBL (f1) VALUES ('3');
28
INSERT INTO CHAR_TBL (f1) VALUES ('');
30
-- try char's of greater than 1 length
31
INSERT INTO CHAR_TBL (f1) VALUES ('cd');
32
INSERT INTO CHAR_TBL (f1) VALUES ('c ');
35
SELECT '' AS seven, CHAR_TBL.*;
45
SELECT '' AS five, c.*
64
-- Now test longer arrays of char
67
CREATE TABLE CHAR_TBL(f1 char(4));
69
INSERT INTO CHAR_TBL (f1) VALUES ('a');
70
INSERT INTO CHAR_TBL (f1) VALUES ('ab');
71
INSERT INTO CHAR_TBL (f1) VALUES ('abcd');
72
INSERT INTO CHAR_TBL (f1) VALUES ('abcde');
73
INSERT INTO CHAR_TBL (f1) VALUES ('abcd ');
75
SELECT '' AS four, CHAR_TBL.*;