DROP DATABASE IF EXISTS mcs262_db;
CREATE DATABASE mcs262_db;
USE mcs262_db;
CREATE TABLE t1
(
t1_INT INT,
t1_DECIMAL DECIMAL(12,5),
t1_TEXT TEXT,
t1_DATE DATE,
t1_TIME TIME
)ENGINE=Columnstore;
INSERT INTO t1 VALUES(103, 1234.5699, 'pqrstuvwxyz', '1997-12-12', '22:12:02');
INSERT INTO t1 VALUES(-7299, 111.99, 'abcdefghijklm', '2001-1-1', '23:59:59');
INSERT INTO t1 VALUES(9913, 98765.4321, repeat('q', 5), '09-12-11', '01:08:59');
SELECT SHA(NULL) FROM t1 LIMIT 1;
SHA(NULL)
NULL
SELECT SHA1(-1) FROM t1 LIMIT 1;
SHA1(-1)
7984b0a0e139cabadb5afc7756d473fb34d23819
SELECT SHA1(0) FROM t1 LIMIT 1;
SHA1(0)
b6589fc6ab0dc82cf12099d1c2d40ab994e8410c
SELECT SHA1(0.5) FROM t1 LIMIT 1;
SHA1(0.5)
1b390cd54a0c0d4f27fa7adf23e3c45536e9f37c
SELECT SHA1(1234) FROM t1 LIMIT 1;
SHA1(1234)
7110eda4d09e062aa5e4a390b0a572ac0d2c0220
SELECT SHA1('1234') FROM t1 LIMIT 1;
SHA1('1234')
7110eda4d09e062aa5e4a390b0a572ac0d2c0220
SELECT SHA1('@') FROM t1 LIMIT 1;
SHA1('@')
9a78211436f6d425ec38f5c4e02270801f3524f8
SELECT SHA1('a') FROM t1 LIMIT 1;
SHA1('a')
86f7e437faa5a7fce15d1ddcb9eaeaea377667b8
SELECT SHA1('abcdefg') FROM t1 LIMIT 1;
SHA1('abcdefg')
2fb5e13419fc89246865e7a324f476ec624e8740
SELECT t1_INT, SHA1(t1_INT) FROM t1 ORDER BY 1;
t1_INT	SHA1(t1_INT)
-7299	99bd359db94d943c07e6a8d8ce5909257751f777
103	934385f53d1bd0c1b8493e44d0dfd4c8e88a04bb
9913	bc9c6748bf7e917b9cc84e36ca8d1a30a8077b29
SELECT t1_DECIMAL, SHA1(t1_DECIMAL) FROM t1 ORDER BY 1;
t1_DECIMAL	SHA1(t1_DECIMAL)
111.99000	3d4eef5333ee54768c5c0d4fe6c6fa1f1df882ad
1234.56990	59a2c163d8b59461e1174d802c6eb1b21a680ce1
98765.43210	3d60f3b3e8deb710457a1f3dfb60f6393156c654
SELECT t1_TEXT, SHA1(t1_TEXT) FROM t1 ORDER BY 1;
t1_TEXT	SHA1(t1_TEXT)
abcdefghijklm	4b9892b6527214afc655b8aa52f4d203c15e7c9c
pqrstuvwxyz	9724f7008b044ab3a49a8bc753c645218ba2ff24
qqqqq	c6efae9869218c6d45b92a3090bce129f27c070d
SELECT t1_DATE, SHA1(t1_DATE) FROM t1 ORDER BY 1;
t1_DATE	SHA1(t1_DATE)
1997-12-12	636e8b96e212f8acd7f2f9944c29217c7166d268
2001-01-01	c94cc3ef45c876d2ff63bfb1b3187dcf879aa93e
2009-12-11	e4ece5fec695f4b89579ca650e32748384c689ed
SELECT t1_TIME, SHA1(t1_TIME) FROM t1 ORDER BY 1;
t1_TIME	SHA1(t1_TIME)
01:08:59	a4d16eb727cc806026d3f5cabb016909e96afcb8
22:12:02	33a8c9cff37f9b4344d7eccfc3b9ea1c6e5fb06a
23:59:59	614742247dae58d7ebc92151200c215daa53f779
DROP DATABASE mcs262_db;