You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/10/08 06:41:26 UTC
[jira] [Assigned] (TRAFODION-708) LP Bug: 1384281 - ROUND function
very inefficient with BIG NUM
[ https://issues.apache.org/jira/browse/TRAFODION-708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah reassigned TRAFODION-708:
----------------------------------------
Assignee: Anoop Sharma
> 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
> Assignee: Anoop Sharma
> 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)