Our test framework always adds single quotes if the result type is string or char. It makes the potential problems.
1. The regression test cannot distinguish between 'NULL' string literal and NULL.
2. It makes a developer confuse because 'NULL' is totally different NULL.
When I look through the relevant code, I think the following code should be maintained.
The problematic code was introduced with the commit ef48f65e. Please consider "how to distinguish NULL and 'NULL' string literal" when you fix this problem.
Dan Hecht mentioned it might be a known issue, so please mark it as a duplicate if you find a original ticket. I also tried to find it using the options(
i.e. project = IMPALA AND description ~ 'NULL' and component = Infrastructure), but I couldn't find.