SAP Knowledge Base Article - Preview

3741635 - Ceil returns decimal instead of integer after HANA upgrade

Symptom

In a SELECT statement, the CEIL function used after a division returns a decimal value instead of an integer


Read more...

Environment

HANA 2.0 SPS7

Product

SAP HANA, platform edition 2.0

Keywords

ceil, return type change, double vs integer, hana 2.0 sps7, hana 2.0 sps5, cast, cast as integer, decimal trailing zeros, select statement, cds view, table function, sqlscript, type mismatch, rounding, upgrade impact , KBA , HAN-DB-ENG , SAP HANA DB Engines , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.