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)