1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-05-01 08:44:47 +03:00
mariadb-columnstore-engine/mysql-test/columnstore/basic/r/mcs75_generated_columns.result

7 lines
306 B
Plaintext

DROP DATABASE IF EXISTS mcs75_db;
CREATE DATABASE mcs75_db;
USE mcs75_db;
CREATE TABLE t1(col1 INT, col2 CHAR(10), col3 CHAR(10), col4 VARCHAR(20) GENERATED ALWAYS AS (CONCAT(col2,col3)))ENGINE=Columnstore;
ERROR HY000: Columnstore storage engine does not support generated columns
DROP DATABASE mcs75_db;