[
https://issues.apache.org/jira/browse/TRAFODION-2634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16037543#comment-16037543
]
David Wayne Birdsall commented on TRAFODION-2634:
-------------------------------------------------
ANSI SQL defines FLOOR and CEIL as returning integers. Most DBMSs use an
integer data type as the return type for FLOOR and CEIL. Trafodion returns a
floating point data type.
This can be problematic, as some functions (e.g. LEFT) require an integer
argument. Yes, a user could use CAST in Trafodion to make the result of FLOOR
and CEIL into an integer argument, but the point is that one doesn't have to do
this elsewhere.
> FLOOR and CEIL return a float data type instead of the argument's data type
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-2634
> URL: https://issues.apache.org/jira/browse/TRAFODION-2634
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp, sql-exe
> Affects Versions: 2.2-incubating
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
