Hi,
I am running in to an error that seems to be happening everytime I try to use field filters on a column of enum type in a Postgres (12) table.
My test query is as basic as SELECT * FROM documents WHERE {{ type }}
The query returns results when the field is empty; the field filter also is able to read the different values of the column type as they are available for me to select (as shown in screenshot below).
But as soon as I select a value and return the query, the following error is thrown:
ERROR: operator does not exist: document_type = character varying Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 186
Am I doing something wrong or is this an expected behaviour?
Thanks in advance,
Grégoire
{
"browser-info": {
"language": "fr-FR",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.111 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "1.8.0_272-heroku-b10",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_272-heroku",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "25.272-b10",
"os.name": "Linux",
"os.version": "4.4.0-1081-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"postgres",
"redshift"
],
"hosting-env": "heroku",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.4 (Ubuntu 12.4-1.pgdg16.04+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.8"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.37.0.2",
"date": "2020-10-26",
"branch": "release-x.37.x",
"hash": "ba7be09"
},
"settings": {
"report-timezone": null
}
}
}
on the first post