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.
Query:
SELECT INSTR('VIP Indicator-0,','%VIP INDICATOR%',1,1)
output:
0
This query has been tested in both V5 and V7 version.
Regards,
CP
