Skip to main content

strict = Vertica::RETURN_NULL_ON_NULL_INPUT behavior in UDx

  • March 18, 2022
  • 0 replies
  • 1 view

Sergey_Cherepan_1
Forum|alt.badge.img+2

Hi,

When I am specifying

strict = Vertica::RETURN_NULL_ON_NULL_INPUT;

my UDx never gets any nulls. Seems to be Vertica is filtering them out before passing to my UDx.

It is a welcome behavior, but undocumented.

Can you ask developers, can I rely on UDx functionality - when Vertica::RETURN_NULL_ON_NULL_INPUT is set, null argument values are filtered out for me?

Can this behavior be documented?

Thank you!