Skip to content

when dealing with data like ' select ' a valid form of insert, heavydb fails. #845

@geo-de-tang

Description

@geo-de-tang

Any string that contains select that is surrounded by spaces triggers an error when run on an insert for the TEXT datatype.

This suggests there are deeper errors in the logic of parsing the sql call.

The error occurs also with TEXT[] type.

Steps to reproduce:
run heavysql:

The first two inserts are successful. The last one fails, and different variations of the last one also fail.

heavysql> create table texts (strs text not null);
heavysql> insert into texts values ('select');
heavysql> insert into texts values (' select');
heavysql> insert into texts values (' select ');

Thrift connection error: No more data to read.
Retrying connection
Thrift error: No more data to read.
Thrift connection error: No more data to read.
Retrying connection
Thrift: Sun May 11 09:57:53 2025 TSocket::write_partial() send() <Host: localhost Port: 6274>: Broken pipe
Thrift error: write() send(): Broken pipe
Thrift connection error: write() send(): Broken pipe
Retrying connection

After this error occurs, one has to ctrl-c and restart heavysql totally to connect to db.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions