sijocherian / google-bigquery

Automatically exported from code.google.com/p/google-bigquery
0 stars 0 forks source link

rtrim(str1, str2) docs incorrect #275

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. SELECT RTRIM("TestString", "String")

What is the expected output? "Test"
What do you see instead? "Tes"

Works as intended with regexp_replace().

Original issue reported on code.google.com by w42...@motorola.com on 26 Jun 2015 at 2:01

GoogleCodeExporter commented 8 years ago
Sorry, this is a bug in our documentation. The intended purpose for the second 
argument is to give a set of characters to remove from the first string. So 
because 't' is one of the characters in the second string, it is removed from 
the string in the first argument.

We'll get the docs fixed. My apologies!

Original comment by jcon...@google.com on 26 Jun 2015 at 5:44

GoogleCodeExporter commented 8 years ago
The docs have been updated and should now match the description given above.
https://cloud.google.com/bigquery/query-reference#stringfunctions

Original comment by dk...@google.com on 30 Jul 2015 at 12:01

GoogleCodeExporter commented 8 years ago
Thanks, especially for the prompt acknowledgement!

Original comment by w42...@motorola.com on 30 Jul 2015 at 7:09