babelfish-for-postgresql / babelfish_extensions / 11886904756

75%

push

github

Support empty double-quoted string in SQL object body (#3121)

This fixes the long-standing bug that a reference to a double-quoted empty string, when located in the body of a procedure, function or trigger, raises an error even though QUOTED_IDENTIFIER is OFF. This is due to the PG backend interpreting any double-quoted string as an identifier, whose length cannot be zero. It is fixed by replacing "" by '' at the ANTLR stage.

Signed-off-by: Rob Verschoor <rcv@amazon.com>

5 of 5 new or added lines in 1 file covered. (100.0%)

45637 of 61075 relevant lines covered (74.72%)

162353.82 hits per line