[ http://issues.apache.org/jira/browse/DERBY-1877?page=all ]
Mamta A. Satoor updated DERBY-1877:
-----------------------------------
Summary: Wrong results using the RTRIM function in Derby 10.0 and Derby
10.1 ... (was: Potential wrong results using the RTRIM function in Derby 10.0
and Derby 10.1 ...)
Description:
When RTRIM is added to the following query, it gives incorrect results for
column XVAL on Derby 10.0 and Derby 10.1. The same RTRIM query gives correct
results when run on Derby 10.2 (I will attach the reproducible script
RTRIMreproducibleScript.txt to this Jira entry which can be used to demonstrate
the problem on Derby 10.0 and Derby 10.1)
Kathey Marsden had started a thread titled "Did DERBY-883 fix this wrong
results bug?" at
http://www.nabble.com/Did-DERBY-883-fix-this-wrong-results-bug--tf2255734.html#a6273521
to track what has changed between Derby 10.1 and Derby 10.2 which has fixed
the problem. There were some responses to that thread but no resolution has
been reached as to what is causing this query to work fine under Derby 10.2
-- Query w/o RTRIM gives correct results
select '' HOUR_INTERVAL,
sum(double(1) / case
when SAMPLE_RATE = 0 then
1
else
SAMPLE_RATE
end) / 3600 THROUGHPUT_PER_SEC,
((char(r.y_t))) || '^' || '^' ||
((char(r.h_t))) XVAL,
'' NA,
'' SORTCOLUMN,
count(*) SAMPLE_COUNT
from (select year(s.END_TIME) y_t,
hour(s.END_TIME) h_t,
day(s.END_TIME) d_t,
month(s.END_TIME) mn_t,
minute(s.END_TIME) mi_t,
s.SAMPLE_RATE
from SAMPLE s) r
GROUP BY r.y_t, r.h_t
ORDER BY r.y_t, r.h_t;
-- INCORRECT results with the following RTRIM query in Derby 10.1 and Derby
10.0 --
select '' HOUR_INTERVAL,
sum(double(1) / case
when SAMPLE_RATE = 0 then
1
else
SAMPLE_RATE
end) / 3600 THROUGHPUT_PER_SEC,
rtrim((char(r.y_t))) || '^' || '^' ||
rtrim((char(r.h_t))) XVAL,
'' NA,
'' SORTCOLUMN,
count(*) SAMPLE_COUNT
from (select year(s.END_TIME) y_t,
hour(s.END_TIME) h_t,
day(s.END_TIME) d_t,
month(s.END_TIME) mn_t,
minute(s.END_TIME) mi_t,
s.SAMPLE_RATE
from SAMPLE s) r
GROUP BY r.y_t, r.h_t
ORDER BY r.y_t, r.h_t;
was:
When RTRIM is added to the following query, it gives incorrect results on Derby
10.0 and Derby 10.1. The same RTRIM query gives correct results when run on
Derby 10.2 (I will attach the reproducible script RTRIMreproducibleScript.txt
to this Jira entry which can be used to demonstrate the problem on Derby 10.0
and Derby 10.1)
Kathey Marsden had started a thread titled "Did DERBY-883 fix this wrong
results bug?" at
http://www.nabble.com/Did-DERBY-883-fix-this-wrong-results-bug--tf2255734.html#a6273521
to track what has changed between Derby 10.1 and Derby 10.2 which has fixed
the problem. There were some responses to that thread but no resolution has
been reached as to what is causing this query to work fine under Derby 10.2
-- Query w/o RTRIM gives correct results
select '' HOUR_INTERVAL,
sum(double(1) / case
when SAMPLE_RATE = 0 then
1
else
SAMPLE_RATE
end) / 3600 THROUGHPUT_PER_SEC,
((char(r.y_t))) || '^' || '^' ||
((char(r.h_t))) XVAL,
'' NA,
'' SORTCOLUMN,
count(*) SAMPLE_COUNT
from (select year(s.END_TIME) y_t,
hour(s.END_TIME) h_t,
day(s.END_TIME) d_t,
month(s.END_TIME) mn_t,
minute(s.END_TIME) mi_t,
s.SAMPLE_RATE
from SAMPLE s) r
GROUP BY r.y_t, r.h_t
ORDER BY r.y_t, r.h_t;
-- INCORRECT results with the following RTRIM query in Derby 10.1 and Derby
10.0 --
select '' HOUR_INTERVAL,
sum(double(1) / case
when SAMPLE_RATE = 0 then
1
else
SAMPLE_RATE
end) / 3600 THROUGHPUT_PER_SEC,
rtrim((char(r.y_t))) || '^' || '^' ||
rtrim((char(r.h_t))) XVAL,
'' NA,
'' SORTCOLUMN,
count(*) SAMPLE_COUNT
from (select year(s.END_TIME) y_t,
hour(s.END_TIME) h_t,
day(s.END_TIME) d_t,
month(s.END_TIME) mn_t,
minute(s.END_TIME) mi_t,
s.SAMPLE_RATE
from SAMPLE s) r
GROUP BY r.y_t, r.h_t
ORDER BY r.y_t, r.h_t;
> Wrong results using the RTRIM function in Derby 10.0 and Derby 10.1 ...
> -----------------------------------------------------------------------
>
> Key: DERBY-1877
> URL: http://issues.apache.org/jira/browse/DERBY-1877
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.1.3.1, 10.0.2.1
> Reporter: Mamta A. Satoor
> Attachments: RTRIMreproducibleScript.txt
>
>
> When RTRIM is added to the following query, it gives incorrect results for
> column XVAL on Derby 10.0 and Derby 10.1. The same RTRIM query gives correct
> results when run on Derby 10.2 (I will attach the reproducible script
> RTRIMreproducibleScript.txt to this Jira entry which can be used to
> demonstrate the problem on Derby 10.0 and Derby 10.1)
> Kathey Marsden had started a thread titled "Did DERBY-883 fix this wrong
> results bug?" at
> http://www.nabble.com/Did-DERBY-883-fix-this-wrong-results-bug--tf2255734.html#a6273521
> to track what has changed between Derby 10.1 and Derby 10.2 which has fixed
> the problem. There were some responses to that thread but no resolution has
> been reached as to what is causing this query to work fine under Derby 10.2
> -- Query w/o RTRIM gives correct results
> select '' HOUR_INTERVAL,
> sum(double(1) / case
> when SAMPLE_RATE = 0 then
> 1
> else
> SAMPLE_RATE
> end) / 3600 THROUGHPUT_PER_SEC,
> ((char(r.y_t))) || '^' || '^' ||
> ((char(r.h_t))) XVAL,
> '' NA,
> '' SORTCOLUMN,
> count(*) SAMPLE_COUNT
> from (select year(s.END_TIME) y_t,
> hour(s.END_TIME) h_t,
> day(s.END_TIME) d_t,
> month(s.END_TIME) mn_t,
> minute(s.END_TIME) mi_t,
> s.SAMPLE_RATE
> from SAMPLE s) r
> GROUP BY r.y_t, r.h_t
> ORDER BY r.y_t, r.h_t;
> -- INCORRECT results with the following RTRIM query in Derby 10.1 and Derby
> 10.0 --
> select '' HOUR_INTERVAL,
> sum(double(1) / case
> when SAMPLE_RATE = 0 then
> 1
> else
> SAMPLE_RATE
> end) / 3600 THROUGHPUT_PER_SEC,
> rtrim((char(r.y_t))) || '^' || '^' ||
> rtrim((char(r.h_t))) XVAL,
> '' NA,
> '' SORTCOLUMN,
> count(*) SAMPLE_COUNT
> from (select year(s.END_TIME) y_t,
> hour(s.END_TIME) h_t,
> day(s.END_TIME) d_t,
> month(s.END_TIME) mn_t,
> minute(s.END_TIME) mi_t,
> s.SAMPLE_RATE
> from SAMPLE s) r
> GROUP BY r.y_t, r.h_t
> ORDER BY r.y_t, r.h_t;
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
