[MCOL-1728] MCS doesn't recognise specificaly formated queries run with SQLyog, HeidiSQL and DBeaver(w/ Connector/J 2.3.0) Created: 2018-09-18  Updated: 2020-10-11  Resolved: 2020-10-11

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.1.6
Fix Version/s: 1.4.1

Type: Bug Priority: Minor
Reporter: Roman Assignee: Unassigned
Resolution: Fixed Votes: 2
Labels: None


 Description   

MCS processes the query like this disabling vtable mode when the query run in SQLyog for Windows. HeidiSQL and DBeaver(w/ Connector/J 2.3.0) proved to be vulnerable also.

INSERT INTO cs1
 
SELECT
 
* FROM cs2;

When
The check here fails because there is '\r\n' sequence inserted right after SELECT instead of '\n' so the current idb_cleanQuery() code doesn't strip it.

 Comments   
Comment by Roman [ 2018-09-18 ]

I will come up with a relevant test later.

Comment by Roman [ 2020-10-11 ]

Fixed after we abandon the server's fork in 1.4.

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