[MCOL-684] Prepare statement with parameter substitution asserts in debug build Created: 2017-04-25 Updated: 2017-09-06 Resolved: 2017-09-06 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | 1.1.0 |
| Fix Version/s: | 1.1.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | David Hall (Inactive) | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
After the MariaDB 10.2 merge, a simple PREPARE statement with substitution causes assert: MariaDB [tpch1]> create table t1 (x int, y int) engine=columnstore; MariaDB [tpch1]> insert into t1 values (1, 1), (2, 2), (3, null); MariaDB [tpch1]> prepare stmt1 from "select count MariaDB [tpch1]> set @parm1=1; MariaDB [tpch1]> execute stmt1 using @parm1; In addition, this statement should have a return type of INT, yet the assert is occurring in Item_func_get_user_var::val_real(). This bug also affects InnoDB tables accessed by the Columnstore build. I believe the problem occurred in earlier builds, but there was no assert then. |
| Comments |
| Comment by David Hall (Inactive) [ 2017-08-02 ] |
|
Prepare or execute breaks only if using <param> is included. |
| Comment by Daniel Lee (Inactive) [ 2017-09-06 ] |
|
Build verified: 1.1.0 Github source /root/columnstore/mariadb-columnstore-server Merge pull request #68 from mariadb-corporation/ /root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine Merge pull request #247 from mariadb-corporation/ Add compiler flag checks and hardening flags Verified both with and without the debug flag for cmake. |