Multiple spaces deleted in clean_query function

[antoinemertz]

Hello VerticaPy team,

Thank you for your work and project.
But I've got one remark that caused me lot of trouble to understand it. When I use search or filter on a vDataFrame if my query has multiple spaces it is replaced by only one space. And that can cause problems.
For exemple if I want to do that df.search("Name like 'Paul John'") with two spaces between Paul & John it will not match the exact name I want but only Paul John with one space between the names.

I am not sure if it is on purpose but sometimes I'm working with characters that can have multiple spaces and I have to use something like df.search("Name like Paul" || " " || " " || "John") to make it works as expected.

Thank you in advance for your feedback,

Antoine

[Koumboss]

Hello Antoine,

You're right, in the query_request system table we indeed see that the extra whitespaces get stripped. Let me investigate further in the code to understand why.

---

SELECT * FROM (SELECT * FROM "v_temp_schema"."verticapy_tmp_df_argecluster_node000533743210x589a72_ee88930c72b411f0b6e96cf6daf331fc" WHERE name_surname like 'Fiona Taylor') VERTICA_SUBTABLE LIMIT 0

Koumaran

[mail4umar]

Hi!

Thank you for reaching. This comment has been addressed in this PR #1354

[antoinemertz]

Hello @mail4umar and @Koumboss. Thanks for the correction. But from the PR #1354 I see that you have corrected the search method but not the filter method and from code here it seems that it still not working as you still apply clean_query. Correct me if I'm wrong.