Create Schema
CREATE DATABASE test; |
USE test; |
|
|
CREATE TABLE `innodbt` ( |
`C_` varchar(100) DEFAULT NULL, |
`A_` varchar(100) DEFAULT NULL, |
`B_` varchar(100) DEFAULT NULL, |
`D_` varchar(100) DEFAULT NULL, |
`E_` varchar(100) DEFAULT NULL |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
|
CREATE TABLE `colstore` ( |
`C_` varchar(100) DEFAULT NULL, |
`A_` varchar(100) DEFAULT NULL, |
`B_` varchar(100) DEFAULT NULL, |
`D_` varchar(100) DEFAULT NULL, |
`E_` varchar(100) DEFAULT NULL |
) ENGINE=Columnstore DEFAULT CHARSET=utf8; |
|
|
DELIMITER $$
|
CREATE PROCEDURE gendemo() |
BEGIN
|
DECLARE i INT DEFAULT 0; |
WHILE i < 50000 DO
|
INSERT INTO `innodbt` (C_,A_,B_,D_,E_) VALUES ( |
ROUND((RAND() * 100000),0), ROUND((RAND() * 100000),0), ROUND((RAND() * 100000),0), ROUND((RAND() * 100000),0),
|
1
|
);
|
SET i = i + 1; |
END WHILE; |
insert into colstore select * from innodbt; |
END$$ |
DELIMITER ;
|
|
|
CALL gendemo();
|
|
|
insert into innodbt( C_, A_, B_, D_, E_) select C_, A_, B_, D_ , E_ |
FROM (select 'text' as C_, A_, B_, D_ , E_ FROM colstore |
)derived;
|
Populate Schema
Run CALL gendemo(); then insert into innodbt snippet from above until SELECT COUNT
FROM `colstore`; returns 2300000.
Run Test
USE test; |
select * from `colstore`order by rand(); |
Expected Output
ERROR 1815 (HY000): Internal error: IDB-2045: At least one PrimProc closed the connection unexpectedly.
|