VERTICA INSTR function returns position value as 0 - Seems Product Bug
Hi Vertica team,
INSTR function value as 0. seems a product bug and now causing big issue for my code where i am using
REGEXP_SUBSTR function to read the output and unable to read since REGEXP_SUBSTR starts eading from position 1.
SELECT INSTR('VIP Indicator-0,','%VIP INDICATOR%',1,1)
This query has been tested in both V5 and V7 version.