I’d be interesting in getting some more opinions on support NaN and Infinity. For background some databases allow special floating point values, such as NaN and +Infinity/-Infinity to be stored. This isn’t part of the SQL standard, but some databases support it. PostgreSQL, Oracle and Vertica all appear to support it, while MySQL does not.
We are running metabase on heroku connected to our postgresql database.
Metabase is unusable for us like this, or are there any workarounds?
I`ve seen that there is a GitHub commit in place (https://github.com/metabase/metabase/pull/7914) for this issue already, but it doesn’t seem to be merged yet. Can we expect this issue to be resolved soon?
[shortened trace …]
2019-04-18T14:16:50.873502+00:00 app[web.1]: 04-18 14:16:50 WARN metabase.query-processor :: Abfrage fehlgeschlagen {:status :failed,
2019-04-18T14:16:50.873516+00:00 app[web.1]: :class java.util.concurrent.ExecutionException,
2019-04-18T14:16:50.873519+00:00 app[web.1]: :error "org.postgresql.util.PSQLException: Bad value for type BigDecimal : NaN",
2019-04-18T14:16:50.873522+00:00 app[web.1]: :stacktrace
2019-04-18T14:16:50.873523+00:00 app[web.1]: ("java.util.concurrent.FutureTask.report(FutureTask.java:122)"
2019-04-18T14:16:50.873524+00:00 app[web.1]: "java.util.concurrent.FutureTask.get(FutureTask.java:192)"
2019-04-18T14:16:50.873526+00:00 app[web.1]: "clojure.core$deref_future.invokeStatic(core.clj:2300)"
2019-04-18T14:16:50.873527+00:00 app[web.1]: "clojure.core$future_call$reify__8439.deref(core.clj:6974)"
2019-04-18T14:16:50.873528+00:00 app[web.1]: "clojure.core$deref.invokeStatic(core.clj:2320)"
2019-04-18T14:16:50.873530+00:00 app[web.1]: "clojure.core$deref.invoke(core.clj:2306)"
2019-04-18T14:16:50.873532+00:00 app[web.1]: "--> driver.sql_jdbc.execute$cancelable_run_query$fn__61274.invoke(execute.clj:178)"