Skip to content

[Bug] BE crash or lose mysql connection when query columns with array type in hms table #25103

@kobe6th

Description

@kobe6th

Search before asking

  • I had searched in the issues and found no similar issues.

Version

1.2.7

What's Wrong?

like issue #20089

  1. BE will crash when meet a query with a hms table which have some array<complex_type> type columns
  2. mysql connection will lose when meet a query with a hms table which have some array<primitive_type> type columns
CREATE TABLE my_array_table (
  id INT,
  my_array ARRAY<STRING>
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE;

MySQL [array_test]> select * from my_array_table;
ERROR 2027 (HY000): Malformed packet
MySQL [array_test]> 
MySQL [array_test]> 
MySQL [array_test]> show create table my_array_table;
ERROR 2013 (HY000): Lost connection to MySQL server during query

What You Expected?

This bug is fixed in master, but not release in 1.2.x.
Realese fix in 1.2.x or just forbid query columns with array type in hms table

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions