Github user kaspersorensen commented on the issue: https://github.com/apache/metamodel/pull/128 I've been looking a bit more, and it seems that ANSI SQL does not specify anything here. PostgreSQL and MS SQL use the behaviour you describe, whereas Oracle and MySQL return floating points. Furthermore I checked ElasticSearch, which also returns floating points.
---