SUBSTRING and SUBSTR documentation error

1

I just stumbled over an error in the documentation of SUBSTRING and SUBSTR

The example says that SUBSTRING('dremio user 1 2 3', 12) returns 1 2 3 when it actually returns 1 2 3

The example for SUBSTRING(<string>, from_idx, to_idx) further down is correct though

It would clarify things if the documentation stated wether the indexes are inclusive or not.

2

@dotjdk I see both return the same value, you have said " The example says that SUBSTRING('dremio user 1 2 3', 12) returns 1 2 3 when it actually returns 1 2 3 … what does this mean?

3

Oh, sorry. I didn’t notice. Looks like the code tag trims spaces. The “actually returns” has a space in front of 1 2 3. The 12th character (the space after user) is included in the return value, but in the example it is not