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
88 lines
3.6 KiB
Plaintext
88 lines
3.6 KiB
Plaintext
# -------------------------------------------------------------- #
|
|
# Test case migrated from regression test suite: MCOL-979.sql
|
|
#
|
|
# Author: Daniel Lee, daniel.lee@mariadb.com
|
|
# -------------------------------------------------------------- #
|
|
#
|
|
--source ../include/have_columnstore.inc
|
|
#
|
|
USE tpch1;
|
|
#
|
|
--disable_warnings
|
|
drop table if exists mcol979;
|
|
--enable_warnings
|
|
|
|
create table mcol979 (a int, b double, c CHAR(1), d CHAR(2), e CHAR(3), f CHAR(4), g CHAR(8),
|
|
h CHAR(16), m VARCHAR(32)) engine=columnstore;
|
|
|
|
insert into mcol979 values (1,1.1,'a','ab','abc','abcd','abcdefgh','abcdefghijklmnop','abcdefghijklmnopqrstuvwxyz123456');
|
|
insert into mcol979 values (2,2.2,'b','bc','bcd','bcde','bcdefghi','bcdefghijklmnopq','bcdefghijklmnopqrstuvwxyz1234567');
|
|
insert into mcol979 values (3,3.3,'c','cd','cde','cdef','cdefghij','cdefghijklmnopqr','cdefghijklmnopqrstuvwxyz12345678');
|
|
insert into mcol979 values (4,4.4,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
|
|
|
|
select lead(c) over (order by a) from mcol979;
|
|
select lead(d) over (order by a) from mcol979;
|
|
select lead(e) over (order by a) from mcol979;
|
|
select lead(f) over (order by a) from mcol979;
|
|
select lead(g) over (order by a) from mcol979;
|
|
select lead(h) over (order by a) from mcol979;
|
|
select lead(m) over (order by a) from mcol979;
|
|
select lead(c) over (order by b) from mcol979;
|
|
select lead(d) over (order by b) from mcol979;
|
|
select lead(e) over (order by b) from mcol979;
|
|
select lead(f) over (order by b) from mcol979;
|
|
select lead(g) over (order by b) from mcol979;
|
|
select lead(h) over (order by b) from mcol979;
|
|
select lead(m) over (order by b) from mcol979;
|
|
|
|
select lag(c) over (order by a) from mcol979;
|
|
select lag(d) over (order by a) from mcol979;
|
|
select lag(e) over (order by a) from mcol979;
|
|
select lag(f) over (order by a) from mcol979;
|
|
select lag(g) over (order by a) from mcol979;
|
|
select lag(h) over (order by a) from mcol979;
|
|
select lag(m) over (order by a) from mcol979;
|
|
select lag(c) over (order by b) from mcol979;
|
|
select lag(d) over (order by b) from mcol979;
|
|
select lag(e) over (order by b) from mcol979;
|
|
select lag(f) over (order by b) from mcol979;
|
|
select lag(g) over (order by b) from mcol979;
|
|
select lag(h) over (order by b) from mcol979;
|
|
select lag(m) over (order by b) from mcol979;
|
|
|
|
select lead(a) over (order by c) from mcol979;
|
|
select lead(a) over (order by d) from mcol979;
|
|
select lead(a) over (order by e) from mcol979;
|
|
select lead(a) over (order by f) from mcol979;
|
|
select lead(a) over (order by g) from mcol979;
|
|
select lead(a) over (order by h) from mcol979;
|
|
select lead(a) over (order by m) from mcol979;
|
|
select lead(b) over (order by c) from mcol979;
|
|
select lead(b) over (order by d) from mcol979;
|
|
select lead(b) over (order by e) from mcol979;
|
|
select lead(b) over (order by f) from mcol979;
|
|
select lead(b) over (order by g) from mcol979;
|
|
select lead(b) over (order by h) from mcol979;
|
|
select lead(b) over (order by m) from mcol979;
|
|
|
|
select lag(a) over (order by c) from mcol979;
|
|
select lag(a) over (order by d) from mcol979;
|
|
select lag(a) over (order by e) from mcol979;
|
|
select lag(a) over (order by f) from mcol979;
|
|
select lag(a) over (order by g) from mcol979;
|
|
select lag(a) over (order by h) from mcol979;
|
|
select lag(a) over (order by m) from mcol979;
|
|
select lag(b) over (order by c) from mcol979;
|
|
select lag(b) over (order by d) from mcol979;
|
|
select lag(b) over (order by e) from mcol979;
|
|
select lag(b) over (order by f) from mcol979;
|
|
select lag(b) over (order by g) from mcol979;
|
|
select lag(b) over (order by h) from mcol979;
|
|
select lag(b) over (order by m) from mcol979;
|
|
|
|
--disable_warnings
|
|
drop table if exists mcol979;
|
|
--enable_warnings
|
|
#
|
|
|