[ 
https://issues.apache.org/jira/browse/BEAM-5829?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16734573#comment-16734573
 ] 

Kenneth Knowles commented on BEAM-5829:
---------------------------------------

Actually, I think the SQL layer does not reject it, but allows Beam to reject. 
It should be caught in SQL.

> SQL should probably not support GROUP BY or set operations on floating point 
> numbers
> ------------------------------------------------------------------------------------
>
>                 Key: BEAM-5829
>                 URL: https://issues.apache.org/jira/browse/BEAM-5829
>             Project: Beam
>          Issue Type: Bug
>          Components: dsl-sql, test-failures
>            Reporter: Kenneth Knowles
>            Assignee: Kenneth Knowles
>            Priority: Major
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> These are known to be super unreliable on most SQL engines, and generally 
> indicate a programming error. Floating points numbers are intended as 
> stand-ins for real numbers, for which equality (hence grouping and set 
> operations) are undecidable. And our build is broken because of it.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to