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.

 

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

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file