You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:17:53 UTC

[jira] [Created] (TRAFODION-708) LP Bug: 1384281 - ROUND function very inefficient with BIG NUM

Alice Chen created TRAFODION-708:
------------------------------------

             Summary: LP Bug: 1384281 - ROUND function very inefficient with BIG NUM
                 Key: TRAFODION-708
                 URL: https://issues.apache.org/jira/browse/TRAFODION-708
             Project: Apache Trafodion
          Issue Type: Wish
          Components: sql-cmp
            Reporter: Apache Trafodion
            Priority: Minor


When applied to NUMERIC with a large precision, the ROUND function creates 200+ clauses, compared to fewer than 10 if the precision is less than 19. 

Here is a test script for sqlci:

drop table TRAFODION.SCH.TROUND;

CREATE TABLE TRAFODION.SCH.TROUND
  (
    A19                              NUMERIC(19, 1) NO DEFAULT NOT NULL NOT
      DROPPABLE
  , A18                              NUMERIC(18, 1) NO DEFAULT NOT NULL NOT
      DROPPABLE
  , A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , PRIMARY KEY (A ASC)
  )
;
log sp19 clear;
showplan select round(a19) from tround;
log;
log sp18 clear;
showplan select round(a18) from tround;
log;


sh grep -c "Clause #" sp??;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)