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