[MCOL-1520] Forked server crashes in Item_ident::print() for a Temptable_field. Created: 2018-06-29  Updated: 2018-09-12  Resolved: 2018-09-12

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.2.0
Fix Version/s: 1.2.0

Type: Bug Priority: Minor
Reporter: Roman Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-1510 GROUP BY handler doesn't support oper... Closed
Sprint: 2018-14, 2018-15, 2018-16, 2018-17

 Description   

The CS crashes trying to print out a zero pointer Item_ident.field_name. Normally server returns hardcoded 'tmp_field' value.
The steps to reproduce:

MariaDB [cs]> show create table cs1;
+-------+--------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                             |
+-------+--------------------------------------------------------------------------------------------------------------------------+
| cs1   | CREATE TABLE `cs1` (
  `i` int(11) DEFAULT NULL,
  `it` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=latin1 |
+-------+--------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
 
MariaDB [cs]> select * from cs1;
+------+------+
| i    | it   |
+------+------+
|    1 |    2 |
|    3 |    4 |
|   25 |   26 |
|   25 |    1 |
+------+------+
4 rows in set (0.06 sec)
 
MariaDB [cs]> select sum(i)+1 from cs1 group by i;
+----------+
| sum(i)+1 |
+----------+
| 4        |
| 2        |
| 51       |
+----------+
3 rows in set (0.02 sec)
 
MariaDB [cs]> set infinidb_vtable_mode=0;
Query OK, 0 rows affected (0.00 sec)
 
MariaDB [cs]> select sum(i)+1 from cs1 group by i;



 Comments   
Comment by Roman [ 2018-06-29 ]

Please review.

Comment by Daniel Lee (Inactive) [ 2018-07-23 ]

Build tested: 1.2.0-1 source

/root/columnstore/mariadb-columnstore-server
commit 4ea82f8f53b0dbec6971d93f19a7e6fa18b7c50c
Merge: 3bfc3ad 15febae
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Wed Jul 18 20:47:56 2018 +0100

Merge pull request #122 from mariadb-corporation/MCOL-1520

MCOL-1520 Fix the server crash in Item_iden::print() for a temptable field.

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 4a3f8b77c2e3fe2ec311150c79551900324e59e8
Merge: 6aedf1d a62a2e3
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Wed Jul 18 09:34:13 2018 +0100

Merge pull request #519 from drrtuy/MCOL-1510

MCOL-1510 GROUP BY handler doesn't support operations on aggregate functions when projecting columns.

mysql crashed, as it did in MCOL-1510
MariaDB [mytest]> create table cs1 (i int, it int) engine=columnstore;
Query OK, 0 rows affected (0.17 sec)

MariaDB [mytest]> insert cs1 values (1,2);
Query OK, 1 row affected (0.15 sec)

MariaDB [mytest]> insert cs1 values (3,4);
Query OK, 1 row affected (0.06 sec)

MariaDB [mytest]> insert cs1 values (25,26);
Query OK, 1 row affected (0.05 sec)

MariaDB [mytest]> insert cs1 values (25,1);
Query OK, 1 row affected (0.05 sec)

MariaDB [mytest]> select sum+1 from cs1 group by i;
----------

sum+1

----------

4
2
51

----------
3 rows in set (0.04 sec)

MariaDB [mytest]> set infinidb_vtable_mode=0;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mytest]> select sum+1 from cs1 group by i;
ERROR 2013 (HY000): Lost connection to MySQL server during query
MariaDB [mytest]> quit
Bye

Comment by Daniel Lee (Inactive) [ 2018-09-12 ]

Build verified: 1.2.0-1 source
/root/columnstore/mariadb-columnstore-server
commit c2052269ef995332eedbef4fbd3ecc4a5e8e8cf0
Merge: b8fded1 d0385eb
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Mon Sep 10 09:07:03 2018 -0500
Merge pull request #131 from mariadb-corporation/build_fix
Revert "MDEV-11036 Add link wsrep_sst_rsync_wan -> wsrep_sst_rsync"
/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 764090ba0cf0bbb99092f5bfd9f8014464a136b1
Merge: 73b45ac 5b682a5
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Mon Sep 3 16:20:47 2018 +0100
Merge pull request #552 from drrtuy/MCOL-1510_4
MCOL-1510: Add CalpontSelectExecutionPlan::serialize() changes.

MariaDB [mytest]> select sum+1 from cs1 group by i;
----------

sum+1

----------

4
2
26

----------
3 rows in set (0.064 sec)

MariaDB [mytest]> set infinidb_vtable_mode=0;
Query OK, 0 rows affected (0.001 sec)

MariaDB [mytest]> select sum+1 from cs1 group by i;
----------

sum+1

----------

2
4
26

----------
3 rows in set (0.012 sec)

Generated at Thu Feb 08 02:29:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.