|
Try the following test script to reproduce the problem.
DROP TABLE if exists t1;
|
DROP TABLE if exists l_t1;
|
|
CREATE TABLE t1 ( c1 int not null, c2 bigint, c3 float,
|
c4 double, c5 char(10), c6 varchar(20), c7 datetime ,
|
c8 tinytext, c9 tinyblob, c10 text, c11 blob,
|
c12 mediumtext, c13 mediumblob, c14 longtext,
|
c15 longblob ) engine=columnstore;
|
|
CREATE TABLE l_t1 ( c1 int not null, c2 bigint, c3 float,
|
c4 double, c5 char(10), c6 varchar(20), c7 datetime ,
|
c8 tinytext, c9 tinyblob, c10 text, c11 blob,
|
c12 mediumtext, c13 mediumblob, c14 longtext,
|
c15 longblob ) engine=columnstore;
|
|
|
insert into t1 values(95000, 88000, 12.45, 99.56, 'charone', 'varcharone', '2018/07/08 10:10:10',
|
'tinytext', '<---tinyblob---->', 'a-text-type', 'a-blob',
|
'medium-text', 'medium-blob', 'long-text', 'long-blob');
|
select * from t1 where c1 > 0;
|
insert into l_t1 values(95000, 88000, 12.45, 99.56, 'charone', 'varcharone', '2018/07/08 10:10:10',
|
'tinytext', '<---tinyblob---->', 'a-text-type', 'a-blob',
|
'medium-text', 'medium-blob', 'long-text', 'long-blob');
|
insert into l_t1 select * from t1;
|
select * from l_t1 where c1 > 0;
|
I have the following result from running the script:
MariaDB [mydb]> desc t1;
|
+-------+-------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+-------------+------+-----+---------+-------+
|
| c1 | int(11) | NO | | NULL | |
|
| c2 | bigint(20) | YES | | NULL | |
|
| c3 | float | YES | | NULL | |
|
| c4 | double | YES | | NULL | |
|
| c5 | char(10) | YES | | NULL | |
|
| c6 | varchar(20) | YES | | NULL | |
|
| c7 | datetime | YES | | NULL | |
|
| c8 | tinytext | YES | | NULL | |
|
| c9 | tinyblob | YES | | NULL | |
|
| c10 | text | YES | | NULL | |
|
| c11 | blob | YES | | NULL | |
|
| c12 | mediumtext | YES | | NULL | |
|
| c13 | mediumblob | YES | | NULL | |
|
| c14 | longtext | YES | | NULL | |
|
| c15 | longblob | YES | | NULL | |
|
+-------+-------------+------+-----+---------+-------+
|
15 rows in set (0.01 sec)
|
|
MariaDB [mydb]> desc l_t1;
|
+-------+-------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+-------------+------+-----+---------+-------+
|
| c1 | int(11) | NO | | NULL | |
|
| c2 | bigint(20) | YES | | NULL | |
|
| c3 | float | YES | | NULL | |
|
| c4 | double | YES | | NULL | |
|
| c5 | char(10) | YES | | NULL | |
|
| c6 | varchar(20) | YES | | NULL | |
|
| c7 | datetime | YES | | NULL | |
|
| c8 | tinytext | YES | | NULL | |
|
| c9 | tinyblob | YES | | NULL | |
|
| c10 | text | YES | | NULL | |
|
| c11 | blob | YES | | NULL | |
|
| c12 | mediumtext | YES | | NULL | |
|
| c13 | mediumblob | YES | | NULL | |
|
| c14 | longtext | YES | | NULL | |
|
| c15 | longblob | YES | | NULL | |
|
+-------+-------------+------+-----+---------+-------+
|
15 rows in set (0.00 sec)
|
|
MariaDB [mydb]> select * from t1;
|
+-------+-------+-------+-------+---------+------------+---------------------+----------+-------------------+-------------+--------+-------------+-------------+-----------+-----------+
|
| c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | c9 | c10 | c11 | c12 | c13 | c14 | c15 |
|
+-------+-------+-------+-------+---------+------------+---------------------+----------+-------------------+-------------+--------+-------------+-------------+-----------+-----------+
|
| 95000 | 88000 | 12.45 | 99.56 | charone | varcharone | 2018-07-08 10:10:10 | tinytext | <---tinyblob----> | a-text-type | a-blob | medium-text | medium-blob | long-text | long-blob |
|
+-------+-------+-------+-------+---------+------------+---------------------+----------+-------------------+-------------+--------+-------------+-------------+-----------+-----------+
|
1 row in set (0.07 sec)
|
|
insert into l_t1 select * from t1;
|
#0 0x00007febea629c0e in ha_calpont_impl_write_batch_row_ (buf=0x7feb5002eea2 "\t", table=0x7feb50027e60, ci=...)
|
at /home/rprakash/mariadb/mariadb-columnstore-server/mariadb-columnstore-engine/dbcon/mysql/ha_calpont_dml.cpp:1638
|
#1 0x00007febea5fc7ac in ha_calpont_impl_write_row (buf=0x7feb5002ee28 "", table=0x7feb50027e60)
|
at /home/rprakash/mariadb/mariadb-columnstore-server/mariadb-columnstore-engine/dbcon/mysql/ha_calpont_impl.cpp:3435
|
#2 0x00007febea5eab1d in ha_calpont::write_row (this=0x7feb5004ae98, buf=0x7feb5002ee28 "")
|
at /home/rprakash/mariadb/mariadb-columnstore-server/mariadb-columnstore-engine/dbcon/mysql/ha_calpont.cpp:499
|
#3 0x00005610445a84de in handler::ha_write_row (this=0x7feb5004ae98, buf=0x7feb5002ee28 "")
|
at /home/rprakash/mariadb/mariadb-columnstore-server/sql/handler.cc:5978
|
#4 0x00005610442f8880 in write_record (thd=0x7feb50000b00, table=0x7feb50027e60, info=0x7feb5004f778)
|
at /home/rprakash/mariadb/mariadb-columnstore-server/sql/sql_insert.cc:1929
|
#5 0x00005610442fd8ff in select_insert::send_data (this=0x7feb5004f738, values=...)
|
at /home/rprakash/mariadb/mariadb-columnstore-server/sql/sql_insert.cc:3757
|
#6 0x0000561044392f0f in end_send (join=0x7feb5004f7e0, join_tab=0x7feb500451e0, end_of_records=false)
|
at /home/rprakash/mariadb/mariadb-columnstore-server/sql/sql_select.cc:20161
|
#7 0x00005610443909e5 in evaluate_join_record (join=0x7feb5004f7e0, join_tab=0x7feb50044e30, error=0)
|
at /home/rprakash/mariadb/mariadb-columnstore-server/sql/sql_select.cc:19213
|
#8 0x00005610443902ef in sub_select (join=0x7feb5004f7e0, join_tab=0x7feb50044e30, end_of_records=false)
|
at /home/rprakash/mariadb/mariadb-columnstore-server/sql/sql_select.cc:18993
|
#9 0x000056104438f88b in do_select (join=0x7feb5004f7e0, procedure=0x0)
|
at /home/rprakash/mariadb/mariadb-columnstore-server/sql/sql_select.cc:18537
|
#10 0x0000561044369e9d in JOIN::exec_inner (this=0x7feb5004f7e0)
|
at /home/rprakash/mariadb/mariadb-columnstore-server/sql/sql_select.cc:3816
|
#11 0x0000561044368bd2 in JOIN::exec (this=0x7feb5004f7e0)
|
at /home/rprakash/mariadb/mariadb-columnstore-server/sql/sql_select.cc:3403
|
#12 0x000056104436a6ae in mysql_select (thd=0x7feb50000b00, tables=0x7feb5004f090, wild_num=1, fields=..., conds=0x0, og_num=0,
|
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489925888, result=0x7feb5004f738, unit=0x7feb50004800,
|
select_lex=0x7feb50004f38) at /home/rprakash/mariadb/mariadb-columnstore-server/sql/sql_select.cc:4051
|
#13 0x000056104435e229 in handle_select (thd=0x7feb50000b00, lex=0x7feb50004738, result=0x7feb5004f738,
|
setup_tables_done_option=1073741824) at /home/rprakash/mariadb/mariadb-columnstore-server/sql/sql_select.cc:376
|
|