Anyone happened to know what this means ```ProgrammingError

Question

Anyone happened to know what this means ```ProgrammingError Unknown exception com fasterxml jackson databind RuntimeJsonMappingException Cannot deserialize instance of `java lang String` out of VALUE NULL token at Source net jpountz lz4 LZ4BlockInputStream line 1 column 4 ``` It seems to me that the column has null values but the devs said that there are no such nulls

Didip Kerabat · Answer

This happened when they try to use `array agg ` function ```array agg coalesce the column ```

Saydul Bashar · Answer

I think I came across something similar a while ago

Saydul Bashar · Answer

Trying 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 · Answer

I haven t been able to find the relevant info yet but something like ` ```REPLACE myString Char 0x00 ``` ` should work

Didip Kerabat · Answer

ho thank you I will give that a try

Saydul Bashar · Answer

You 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 · Answer

< Didip Kerabat> once you test it out please let me know whether it worked or not I am curious to know slightly smiling face