mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
32 lines
790 B
Plaintext
32 lines
790 B
Plaintext
# -------------------------------------------------------------- #
|
|
# Test case migrated from regression test suite: bug3565.sql
|
|
#
|
|
# Author: Daniel Lee, daniel.lee@mariadb.com
|
|
# -------------------------------------------------------------- #
|
|
#
|
|
--source ../include/have_columnstore.inc
|
|
#
|
|
USE tpch1;
|
|
#
|
|
--disable_warnings
|
|
drop table if exists bug3565;
|
|
--enable_warnings
|
|
|
|
#-- Create a table with a tinyint.
|
|
create table bug3565(c1 tinyint)engine=columnstore;
|
|
|
|
#-- Populate with > 256K rows.
|
|
insert into bug3565 (select 0 from orders limit 270000);
|
|
alter table bug3565 add column c2 bigint;
|
|
alter table bug3565 add column c3 int;
|
|
|
|
select count(c1) from bug3565;
|
|
select count(c2) from bug3565;
|
|
select count(c3) from bug3565;
|
|
|
|
--disable_warnings
|
|
drop table if exists bug3565;
|
|
--enable_warnings
|
|
#
|
|
|