mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
21 lines
978 B
Plaintext
21 lines
978 B
Plaintext
#
|
|
# Test case migrated from regression test suite:
|
|
# ./mysql/queries/nightly/alltest/test023/q1.1.2.sql
|
|
#
|
|
# Author: Susil, susil.behera@mariadb.com
|
|
#
|
|
|
|
-- source ../include/have_columnstore.inc
|
|
|
|
USE tpch1;
|
|
|
|
SET sql_mode = ANSI_QUOTES;
|
|
create table "to!@#$%^&*$#,()[].;:+-|/%^<>=!&|@\"(some int,t text) engine=columnstore;
|
|
insert into `to!@#$%^&*$#,()[].;:+-|/%^<>=!&|@\` values (1,'Lorem ipsum dolor sit amet, consectetur adipiscing elit,'),(7,'sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.'),(8,'Ut enim ad minim veniam,'),(9,'quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.'),(10,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore e');
|
|
select * from "to!@#$%^&*$#,()[].;:+-|/%^<>=!&|@\";
|
|
show create table "to!@#$%^&*$#,()[].;:+-|/%^<>=!&|@\";
|
|
drop table "to!@#$%^&*$#,()[].;:+-|/%^<>=!&|@\";
|
|
# Negative. table doesn't exist
|
|
--error 1146
|
|
show create table "to!@#$%^&*$#,()[].;:+-|/%^<>=!&|@\";
|