mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-21 19:45:56 +03:00
68 lines
2.3 KiB
Plaintext
68 lines
2.3 KiB
Plaintext
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;
|