VERTICA INSTR function returns position value as 0 - Seems Product Bug

Chandra_PrakashChandra_Prakash
in General Discussion

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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...