Bug with formula and UUIDs as primary field
As reported here: https://community.baserow.io/t/formula-results-in-500-server-error-no-errors-in-ui/4513 there is a bug with formulas that uses lookups when the primary field is a UUID field.
Traceback (most recent call last):
backend-1 | File "/baserow/venv/lib/python3.9/site-packages/silk/sql.py", line 89, in execute_sql
backend-1 | return self._execute_sql(*args, **kwargs)
backend-1 | File "/baserow/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1398, in execute_sql
backend-1 | cursor.execute(sql, params)
backend-1 | File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 102, in execute
backend-1 | return super().execute(sql, params)
backend-1 | File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 67, in execute
backend-1 | return self._execute_with_wrappers(
backend-1 | File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
backend-1 | return executor(sql, params, many, context)
backend-1 | File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
backend-1 | return self.cursor.execute(sql, params)
backend-1 | File "/baserow/venv/lib/python3.9/site-packages/django/db/utils.py", line 91, in __exit__
backend-1 | raise dj_exc_value.with_traceback(traceback) from exc_value
backend-1 | File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
backend-1 | return self.cursor.execute(sql, params)
backend-1 | django.db.utils.ProgrammingError: COALESCE types uuid and text cannot be matched
backend-1 | LINE 1: ..._BUILD_OBJECT('value', COALESCE(U2."field_5203", ('')::text