1DROP DATABASE IF EXISTS mcs263_db; 2CREATE DATABASE mcs263_db; 3USE mcs263_db; 4CREATE TABLE t1 5( 6t1_INT INT, 7t1_DECIMAL DECIMAL(12,5), 8t1_TEXT TEXT, 9t1_DATE DATE, 10t1_TIME TIME 11)ENGINE=Columnstore; 12INSERT INTO t1 VALUES(103, 1234.5699, 'pqrstuvwxyz', '1997-12-12', '22:12:02'); 13INSERT INTO t1 VALUES(-7299, 111.99, 'abcdefghijklm', '2001-1-1', '23:59:59'); 14INSERT INTO t1 VALUES(9913, 98765.4321, repeat('q', 5), '09-12-11', '01:08:59'); 15SELECT SIN(-1) FROM t1 LIMIT 1; 16SIN(-1) 17-0.8414709848078965 18SELECT SIN(0) FROM t1 LIMIT 1; 19SIN(0) 200 21SELECT SIN(1) FROM t1 LIMIT 1; 22SIN(1) 230.8414709848078965 24SELECT SIN(3.14) FROM t1 LIMIT 1; 25SIN(3.14) 260.0015926529164868282 27SELECT SIN(3.14/2) FROM t1 LIMIT 1; 28SIN(3.14/2) 290.9999996829318346 30SELECT SIN(3.14/4) FROM t1 LIMIT 1; 31SIN(3.14/4) 320.706825181105366 33SELECT t1_INT, SIN(t1_INT) FROM t1 ORDER BY 1; 34t1_INT SIN(t1_INT) 35-7299 0.8820830128380527 36103 0.6229886314423488 379913 -0.9566221651044184 38SELECT t1_DECIMAL, SIN(t1_DECIMAL) FROM t1 ORDER BY 1; 39t1_DECIMAL SIN(t1_DECIMAL) 40111.99000 -0.8945107200074195 411234.56990 0.07593968211822391 4298765.43210 0.04224386964079158 43DROP DATABASE mcs263_db; 44