DROP DATABASE IF EXISTS mcs267_db;
CREATE DATABASE mcs267_db;
USE mcs267_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 SHA2(NULL, 256) FROM t1 LIMIT 1;
SHA2(NULL, 256)
NULL
SELECT SHA2(-1, 0) FROM t1 LIMIT 1;
SHA2(-1, 0)
1bad6b8cf97131fceab8543e81f7757195fbb1d36b376ee994ad1cf17699c464
SELECT SHA2(-1, 256) FROM t1 LIMIT 1;
SHA2(-1, 256)
1bad6b8cf97131fceab8543e81f7757195fbb1d36b376ee994ad1cf17699c464
SELECT SHA2(-1, 224) FROM t1 LIMIT 1;
SHA2(-1, 224)
46e8e7eef892970f8f372779731916e5349d9c82a65227374303299e
SELECT SHA2(-1, 384) FROM t1 LIMIT 1;
SHA2(-1, 384)
5e97116be95176424c4eeda0a6bf444e9173ff36f9c3704b7b370dad9dafaa20d5ae7e15723de23b0d50ce62efa3d15b
SELECT SHA2(-1, 512) FROM t1 LIMIT 1;
SHA2(-1, 512)
4fcdd8c15addb15f1e994008677c740848168cd8d32e92d44301ea12b37a93fbd9f0a0468d04789e1f387b395509bd3b998e8aad5e02dd2625f0aac661fb1100
SELECT SHA2(0, 0) FROM t1 LIMIT 1;
SHA2(0, 0)
5feceb66ffc86f38d952786c6d696c79c2dbc239dd4e91b46729d73a27fb57e9
SELECT SHA2(0.5, 0) FROM t1 LIMIT 1;
SHA2(0.5, 0)
d2cbad71ff333de67d07ec676e352ab7f38248eb69c942950157220607c55e84
SELECT SHA2(1234, 0) FROM t1 LIMIT 1;
SHA2(1234, 0)
03ac674216f3e15c761ee1a5e255f067953623c8b388b4459e13f978d7c846f4
SELECT SHA2('1234', 0) FROM t1 LIMIT 1;
SHA2('1234', 0)
03ac674216f3e15c761ee1a5e255f067953623c8b388b4459e13f978d7c846f4
SELECT SHA2('@', 0) FROM t1 LIMIT 1;
SHA2('@', 0)
c3641f8544d7c02f3580b07c0f9887f0c6a27ff5ab1d4a3e29caf197cfc299ae
SELECT SHA2('a', 0) FROM t1 LIMIT 1;
SHA2('a', 0)
ca978112ca1bbdcafac231b39a23dc4da786eff8147c4e72b9807785afee48bb
SELECT SHA2('abcdefg', 0) FROM t1 LIMIT 1;
SHA2('abcdefg', 0)
7d1a54127b222502f5b79b5fb0803061152a44f92b37e23c6527baf665d4da9a
SELECT t1_INT, SHA2(t1_INT, 0) FROM t1 ORDER BY 1;
ERROR 42000: The storage engine for the table doesn't support MCS-1001: Function 'sha2' isn't supported.
SELECT t1_DECIMAL, SHA2(t1_DECIMAL, 0) FROM t1 ORDER BY 1;
ERROR 42000: The storage engine for the table doesn't support MCS-1001: Function 'sha2' isn't supported.
SELECT t1_TEXT, SHA2(t1_TEXT, 0) FROM t1 ORDER BY 1;
ERROR 42000: The storage engine for the table doesn't support MCS-1001: Function 'sha2' isn't supported.
SELECT t1_DATE, SHA2(t1_DATE, 0) FROM t1 ORDER BY 1;
ERROR 42000: The storage engine for the table doesn't support MCS-1001: Function 'sha2' isn't supported.
SELECT t1_TIME, SHA2(t1_TIME, 0) FROM t1 ORDER BY 1;
ERROR 42000: The storage engine for the table doesn't support MCS-1001: Function 'sha2' isn't supported.
DROP DATABASE mcs267_db;