mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-21 19:45:56 +03:00
104 lines
3.0 KiB
Plaintext
104 lines
3.0 KiB
Plaintext
# -------------------------------------------------------------- #
|
|
# Test case migrated from regression test suite: bug3853.sql
|
|
#
|
|
# Author: Daniel Lee, daniel.lee@mariadb.com
|
|
# -------------------------------------------------------------- #
|
|
#
|
|
--source ../include/have_columnstore.inc
|
|
#
|
|
USE tpch1;
|
|
#
|
|
--disable_warnings
|
|
drop table if exists dw_entradas_fact;
|
|
drop table if exists dw_entradas_fact_1;
|
|
--enable_warnings
|
|
|
|
create table dw_entradas_fact (fecha date) engine=columnstore;
|
|
create table dw_entradas_fact_1 (fecha date) engine=columnstore;
|
|
|
|
insert into dw_entradas_fact values ('2010-01-01'), ('2010-02-02'), ('2010-02-27'), ('2010-03-01');
|
|
insert into dw_entradas_fact_1 values ('2010-01-01'), ('2010-02-02'), ('2010-02-27'), ('2010-03-01');
|
|
|
|
|
|
SELECT 1 NORMAL, 1 OFERTA
|
|
FROM DW_ENTRADAS_FACT a
|
|
WHERE a.FECHA BETWEEN '2010-02-01' and '2010-02-28'
|
|
union all
|
|
SELECT 1 NORMAL, 1 OFERTA
|
|
FROM DW_ENTRADAS_FACT_1 a
|
|
WHERE a.FECHA BETWEEN '2010-02-01' and '2010-02-28';
|
|
|
|
|
|
SELECT TY.NORMAL NORMAL ,
|
|
TY.OFERTA OFERTA
|
|
FROM (SELECT 1 NORMAL,
|
|
1 OFERTA
|
|
FROM DW_ENTRADAS_FACT a
|
|
WHERE a.FECHA BETWEEN '2010-02-01' and '2010-02-28') TY
|
|
union all
|
|
SELECT TY.NORMAL NORMAL ,
|
|
TY.OFERTA OFERTA
|
|
FROM (SELECT 1 NORMAL,
|
|
1 OFERTA
|
|
FROM DW_ENTRADAS_FACT_1 a
|
|
WHERE a.FECHA BETWEEN '2010-02-01' and '2010-02-28') TY;
|
|
|
|
|
|
SELECT TY.NORMAL NORMAL ,
|
|
TY.OFERTA OFERTA
|
|
FROM ((SELECT 1 NORMAL,
|
|
1 OFERTA
|
|
FROM DW_ENTRADAS_FACT
|
|
WHERE FECHA BETWEEN '2010-02-01' and '2010-02-28')
|
|
union all
|
|
(SELECT 1 NORMAL,
|
|
1 OFERTA
|
|
FROM DW_ENTRADAS_FACT_1
|
|
WHERE FECHA BETWEEN '2010-02-01' and '2010-02-28')) AS TY;
|
|
|
|
|
|
SELECT 1 NORMAL, 1 OFERTA
|
|
FROM DW_ENTRADAS_FACT a
|
|
WHERE a.FECHA BETWEEN '2010-02-01' and '2010-02-28'
|
|
union
|
|
SELECT 1 NORMAL, 1 OFERTA
|
|
FROM DW_ENTRADAS_FACT_1 a
|
|
WHERE a.FECHA BETWEEN '2010-02-01' and '2010-02-28';
|
|
|
|
|
|
SELECT TY.NORMAL NORMAL ,
|
|
TY.OFERTA OFERTA
|
|
FROM (SELECT 1 NORMAL,
|
|
1 OFERTA
|
|
FROM DW_ENTRADAS_FACT a
|
|
WHERE a.FECHA BETWEEN '2010-02-01' and '2010-02-28') TY
|
|
union
|
|
SELECT TY.NORMAL NORMAL ,
|
|
TY.OFERTA OFERTA
|
|
FROM (SELECT 1 NORMAL,
|
|
1 OFERTA
|
|
FROM DW_ENTRADAS_FACT_1 a
|
|
WHERE a.FECHA BETWEEN '2010-02-01' and '2010-02-28') TY;
|
|
|
|
|
|
SELECT TY.NORMAL NORMAL ,
|
|
TY.OFERTA OFERTA
|
|
FROM ((SELECT 1 NORMAL,
|
|
1 OFERTA
|
|
FROM DW_ENTRADAS_FACT
|
|
WHERE FECHA BETWEEN '2010-02-01' and '2010-02-28')
|
|
union
|
|
(SELECT 1 NORMAL,
|
|
1 OFERTA
|
|
FROM DW_ENTRADAS_FACT_1
|
|
WHERE FECHA BETWEEN '2010-02-01' and '2010-02-28')) AS TY;
|
|
|
|
select * from region where 2=2 union select n_regionkey, n_nationkey, n_name from nation where 0=1;
|
|
|
|
--disable_warnings
|
|
drop table if exists dw_entradas_fact;
|
|
drop table if exists dw_entradas_fact_1;
|
|
--enable_warnings
|
|
#
|
|
|