mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-18 21:44:02 +03:00
35 lines
1018 B
Plaintext
35 lines
1018 B
Plaintext
# -------------------------------------------------------------- #
|
|
# Test case migrated from regression test suite: bug3312.sql
|
|
#
|
|
# Author: Daniel Lee, daniel.lee@mariadb.com
|
|
# -------------------------------------------------------------- #
|
|
#
|
|
--source ../include/have_columnstore.inc
|
|
#
|
|
USE tpch1;
|
|
#
|
|
--disable_warnings
|
|
drop table if exists user_prop_by_game;
|
|
drop table if exists visit;
|
|
--enable_warnings
|
|
|
|
create table user_prop_by_game(cl_id int, last_visit_date date)engine=columnstore;
|
|
create table visit(cl_id int, visit_date date)engine=columnstore;
|
|
|
|
insert into user_prop_by_game values (1, now()), (2, now());
|
|
insert into visit values (1, '2010-10-01'), (2, '2010-11-01'), (2,
|
|
'2010-10-01');
|
|
|
|
UPDATE user_prop_by_game UPBG, (SELECT cl_id, max(visit_date) AS max_date FROM
|
|
visit GROUP BY cl_id) sub SET UPBG.last_visit_date = sub.max_date WHERE
|
|
UPBG.cl_id = sub.cl_id;
|
|
|
|
select * from user_prop_by_game;
|
|
|
|
--disable_warnings
|
|
drop table if exists user_prop_by_game;
|
|
drop table if exists visit;
|
|
--enable_warnings
|
|
#
|
|
|