https://www.growthbook.io/ logo
#contributing
Title
# contributing
l

late-dentist-52023

04/18/2023, 7:16 PM
We are seeing this error when attempting to apply dimensions to an analysis
Copy code
function concat(character varying, "unknown", character varying) does not exist
this is in redshift The issue appears to be this clause:
Copy code
REGEXP_REPLACE(
        MIN(
          CONCAT(
            cast(e.timestamp as varchar),
            '____',
            coalesce(cast(e.dimension as varchar), '__NULL_DIMENSION')
          )
        ),
        '.*____',
        ''
      ) as dimension,
I believe the
'____'
also needs to be wrapped in a cast() function Self-hosting: Build: f58a91e (2023-03-31)
f

future-teacher-7046

04/18/2023, 7:18 PM
🙌 1
l

late-dentist-52023

04/18/2023, 7:19 PM
excellent, didn’t see that in my quick scan. I will update our build.
f

future-teacher-7046

04/18/2023, 7:20 PM
We had been testing queries on Postgres, assuming Redshift would behave similarly. We've since added Redshift to our testing infrastructure, so hopefully we can catch these types of errors before they go live in the future.
l

late-dentist-52023

04/18/2023, 7:21 PM
yup, makes sense, much of the time postgres is sufficient.
9 Views