mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-18 21:44:02 +03:00
90 lines
2.1 KiB
Plaintext
90 lines
2.1 KiB
Plaintext
DROP DATABASE IF EXISTS mcs14_db1;
|
|
CREATE DATABASE mcs14_db1;
|
|
USE mcs14_db1;
|
|
CREATE TABLE t1 (a INTEGER, b INT,c1 CHAR(10)) ENGINE=Columnstore;
|
|
INSERT INTO t1 (a) VALUES (1),(2);
|
|
TRUNCATE TABLE t1;
|
|
SELECT COUNT(*) FROM t1;
|
|
COUNT(*)
|
|
0
|
|
INSERT INTO t1 VALUES (1, 2, "test");
|
|
SELECT COUNT(*) FROM t1;
|
|
COUNT(*)
|
|
1
|
|
TRUNCATE mcs14_db1.t1;
|
|
DROP TABLE IF EXISTS non_existing_table;
|
|
Warnings:
|
|
Note 1051 Unknown table 'mcs14_db1.non_existing_table'
|
|
TRUNCATE non_existing_table;
|
|
ERROR 42S02: Table 'mcs14_db1.non_existing_table' doesn't exist
|
|
DROP TABLE t1;
|
|
DROP TABLE IF EXISTS t2;
|
|
Warnings:
|
|
Note 1051 Unknown table 'mcs14_db1.t2'
|
|
CREATE TABLE t1 (id INT) ENGINE=INNODB;
|
|
CREATE TABLE t2 (id INT) ENGINE=Columnstore;
|
|
TRUNCATE t1, t2;
|
|
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' t2' at line 1
|
|
TRUNCATE t1;
|
|
TRUNCATE t2;
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
CREATE TABLE t1 (id INT) ENGINE=Columnstore;
|
|
INSERT INTO t1 (id) VALUES (1), (2), (3), (4), (5);
|
|
CREATE VIEW v1 AS SELECT * FROM t1;
|
|
TRUNCATE v1;
|
|
ERROR 42S02: Table 'mcs14_db1.v1' doesn't exist
|
|
SELECT * FROM v1;
|
|
id
|
|
1
|
|
2
|
|
3
|
|
4
|
|
5
|
|
TRUNCATE v1;
|
|
ERROR 42S02: Table 'mcs14_db1.v1' doesn't exist
|
|
SELECT * FROM v1;
|
|
id
|
|
1
|
|
2
|
|
3
|
|
4
|
|
5
|
|
CREATE PROCEDURE p1() SET @a = 5;
|
|
TRUNCATE p1;
|
|
ERROR 42S02: Table 'mcs14_db1.p1' doesn't exist
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 AS SELECT 1 AS f1;
|
|
HANDLER t1 OPEN;
|
|
TRUNCATE t1;
|
|
DROP TABLE t1;
|
|
DROP TABLE IF EXISTS t1;
|
|
Warnings:
|
|
Note 1051 Unknown table 'mcs14_db1.t1'
|
|
CREATE TABLE t1 (id INT) ENGINE=Columnstore;
|
|
INSERT INTO t1 (id) VALUES (1), (2), (3), (4), (5);
|
|
CREATE TABLE t2 LIKE t1;
|
|
INSERT INTO t2 SELECT * FROM t1;
|
|
connect addconroot1, localhost, root,,;
|
|
connect addconroot2, localhost, root,,;
|
|
connection addconroot1;
|
|
TRUNCATE mcs14_db1.t1;
|
|
connection addconroot2;
|
|
TRUNCATE mcs14_db1.t1;
|
|
connection addconroot1;
|
|
TRUNCATE mcs14_db1.t1;
|
|
connection addconroot2;
|
|
USE mcs14_db1;
|
|
TRUNCATE t2;
|
|
connection default;
|
|
USE mcs14_db1;
|
|
SELECT count(*) FROM t1;
|
|
count(*)
|
|
0
|
|
SELECT count(*) FROM t2;
|
|
count(*)
|
|
0
|
|
disconnect addconroot1;
|
|
disconnect addconroot2;
|
|
DROP DATABASE mcs14_db1;
|