# test case derived from NIST script dml112 TEST:0633 TRIM function!

# simplified test case
SELECT TRIM(NULL FROM 'KATE') AS "my_column";

--disable_abort_on_error
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

# The nearly original test case
   CREATE TABLE t1 (
    NAAM CHAR (14),
    SPONSOR CHAR (14),
    PADCHAR CHAR (1));

INSERT INTO t1 VALUES('KATE','000000000KEITH','0');
INSERT INTO t1 VALUES('    KEITH','KATE',NULL);
INSERT INTO t1 VALUES('eale',NULL,'0');
INSERT INTO t1 VALUES('eale','Code','0');

SELECT COUNT(*) FROM t1
     WHERE TRIM(PADCHAR FROM SPONSOR) IS NULL;
# NIST comment: -- PASS:0633 If count = 2?

# only for information
SELECT PADCHAR, SPONSOR, TRIM(PADCHAR FROM SPONSOR) FROM t1;