Issue Details (XML | Word | Printable)

Key: DOC-146
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Paul Vinkenoog
Reporter: prenosil
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.

Syntax of SUBSTRING( ... SIMILAR ...) in FB3, FB4

Created: 26/May/20 04:14 PM   Updated: 26/May/20 04:14 PM
Component/s: None
Affects Version/s: None
Fix Version/s: None

 Description  « Hide
The examples in README.substring_similar.txt are correct, like
substring('abcabc' similar 'a#"bcab#"c' escape '#')

But the syntax description in this document is wrong:
  <regular expression substring> ::= SUBSTRING(<value> FROM <similar pattern> ESCAPE <escape character>)

Also the syntax in FB3 Release Notes is wrong
  SUBSTRING(<string> [NOT] SIMILAR TO <pattern> ESCAPE <char>)
(both NOT and TO)

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.