You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-29 08:21:15 +03:00
17 lines
557 B
Plaintext
17 lines
557 B
Plaintext
DROP DATABASE IF EXISTS mcol5890;
|
|
CREATE DATABASE mcol5890;
|
|
USE mcol5890;
|
|
# Test 1: DROP TABLE IF EXISTS on non-existent table
|
|
DROP TABLE IF EXISTS test.does_not_exist;
|
|
Warnings:
|
|
Note 1051 Unknown table 'test.does_not_exist'
|
|
# Test 2: DROP TABLE on non-existent table
|
|
DROP TABLE test.does_not_exist;
|
|
ERROR 42S02: Unknown table 'test.does_not_exist'
|
|
# Test 3: DROP TABLE IF EXISTS on existing table
|
|
CREATE TABLE t1 (id INT) ENGINE=ColumnStore;
|
|
DROP TABLE IF EXISTS t1;
|
|
SELECT * FROM t1;
|
|
ERROR 42S02: Table 'mcol5890.t1' doesn't exist
|
|
DROP DATABASE mcol5890;
|