This message was deleted.
# troubleshootings
Slackbot
05/25/2023, 4:15 PMThis message was deleted.
d
Didip Kerabat
05/25/2023, 4:16 PMThis happened when they try to use
array_agg() Copy code
array_agg(coalesce(the_column, ''))s
Saydul Bashar
05/25/2023, 4:50 PMI think I came across something similar a while ago
Saydul Bashar
05/25/2023, 4:52 PMTrying to dig out a bit more info about it. What happened was that there was a null character in my string. Languages like C++ use null characters to terminate strings whereas Java uses string length. So, this has the potential of having vulnerabilities. So, Druid SQL doesn't allow this. The solution was to use a regex to remove the null character
Saydul Bashar
05/25/2023, 4:56 PMI haven't been able to find the relevant info yet but something like `
Copy code
REPLACE(myString, Char(0x00), '')d
Didip Kerabat
05/25/2023, 4:57 PMho thank you! I will give that a try.
s
Saydul Bashar
05/25/2023, 4:58 PMYou are welcome. You need to test out the regex a bit. I am not quite sure whether this is the right one or not.
Saydul Bashar
05/26/2023, 7:55 AM@Didip Kerabat once you test it out please let me know whether it worked or not. I am curious to know 🙂.