[jira] [Resolved] (TRAFODION-3237) Incorrect results for INTERVAL addition in an uncommon case
[ https://issues.apache.org/jira/browse/TRAFODION-3237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3237. - Resolution: Fixed Fix Version/s: 2.4 > Incorrect results for INTERVAL addition in an uncommon case > --- > > Key: TRAFODION-3237 > URL: https://issues.apache.org/jira/browse/TRAFODION-3237 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Affects Versions: 2.4 >Reporter: David Wayne Birdsall >Assignee: David Wayne Birdsall >Priority: Major > Fix For: 2.4 > > > The following script illustrates the problem: > {quote}?section ddl > drop table if exists mytableF_base; > create table mytableF_base ( > val int, > "c9" interval day(7) to second default NULL, > "c10" interval day(13) to second(0) default NULL, > "key c10" interval day(13) to second(0) not null default interval > '1:01:11:11' day(13) to second(0), > unique ("key c10") > ); > ?section populateit > insert into mytableF_base values ( > 0, > interval '0 00:00:00' day(7) to second, > interval '0 00:00:00' day(13) to second(0), > interval '0 00:00:00' day(13) to second(0)); > insert into mytableF_base > select 1, > "c9" + interval '1' day, > "c10" + interval '1' day, -- gives incorrect result > "key c10" + interval '1' day -- gives incorrect result > from mytableF_base > where val = 0; > insert into mytableF_base > select 23, > "c9" + interval '1' day, > "c10" + interval '2' day, -- gives correct result > "key c10" + interval '3' day -- gives correct result > from mytableF_base > where val = 0; > select "c10","key c10" from mytableF_base; > {quote} > When run, the last SELECT gives: > {quote}>>select "c10","key c10" from mytableF_base; > c10 key c10 > --- --- > 0 00:00:00 0 00:00:00 > 100 00:00:00 100 00:00:00 > 2 00:00:00 3 00:00:00 > --- 3 row(s) selected. > >>exit; > {quote} > The second line is incorrect; the values are off by a factor of one million. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3237) Incorrect results for INTERVAL addition in an uncommon case
[ https://issues.apache.org/jira/browse/TRAFODION-3237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16719324#comment-16719324 ] ASF GitHub Bot commented on TRAFODION-3237: --- Github user asfgit closed the pull request at: https://github.com/apache/trafodion/pull/1759 > Incorrect results for INTERVAL addition in an uncommon case > --- > > Key: TRAFODION-3237 > URL: https://issues.apache.org/jira/browse/TRAFODION-3237 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Affects Versions: 2.4 >Reporter: David Wayne Birdsall >Assignee: David Wayne Birdsall >Priority: Major > > The following script illustrates the problem: > {quote}?section ddl > drop table if exists mytableF_base; > create table mytableF_base ( > val int, > "c9" interval day(7) to second default NULL, > "c10" interval day(13) to second(0) default NULL, > "key c10" interval day(13) to second(0) not null default interval > '1:01:11:11' day(13) to second(0), > unique ("key c10") > ); > ?section populateit > insert into mytableF_base values ( > 0, > interval '0 00:00:00' day(7) to second, > interval '0 00:00:00' day(13) to second(0), > interval '0 00:00:00' day(13) to second(0)); > insert into mytableF_base > select 1, > "c9" + interval '1' day, > "c10" + interval '1' day, -- gives incorrect result > "key c10" + interval '1' day -- gives incorrect result > from mytableF_base > where val = 0; > insert into mytableF_base > select 23, > "c9" + interval '1' day, > "c10" + interval '2' day, -- gives correct result > "key c10" + interval '3' day -- gives correct result > from mytableF_base > where val = 0; > select "c10","key c10" from mytableF_base; > {quote} > When run, the last SELECT gives: > {quote}>>select "c10","key c10" from mytableF_base; > c10 key c10 > --- --- > 0 00:00:00 0 00:00:00 > 100 00:00:00 100 00:00:00 > 2 00:00:00 3 00:00:00 > --- 3 row(s) selected. > >>exit; > {quote} > The second line is incorrect; the values are off by a factor of one million. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3248) provide more dcscheck option
[ https://issues.apache.org/jira/browse/TRAFODION-3248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16718654#comment-16718654 ] ASF GitHub Bot commented on TRAFODION-3248: --- GitHub user CoderSong2015 opened a pull request: https://github.com/apache/trafodion/pull/1761 [TRAFODION-3248]provide more dcscheck option -m: memory status of dcsmaster -s: status of mxosrvrs -t: thread info of dcs ListenerWorker and ListenerService You can merge this pull request into a Git repository by running: $ git pull https://github.com/CoderSong2015/Apache-Trafodion forDcsStatus2 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/trafodion/pull/1761.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #1761 commit b20451c2bf8f204a0ec28ef337b78a1629130247 Author: haolin.song Date: 2018-12-12T16:37:11Z [TRAFODION-3248]provide more dcscheck option -m: memory status of dcsmaster -s: status of mxosrvrs -t: thread info of dcs ListenerWorker and ListenerService > provide more dcscheck option > > > Key: TRAFODION-3248 > URL: https://issues.apache.org/jira/browse/TRAFODION-3248 > Project: Apache Trafodion > Issue Type: New Feature > Components: connectivity-dcs >Affects Versions: 2.4 >Reporter: haolin.song >Assignee: haolin.song >Priority: Major > > Providing more dcscheck option to get more information about dcs/mxosrvr > status. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3248) provide more dcscheck option
haolin.song created TRAFODION-3248: -- Summary: provide more dcscheck option Key: TRAFODION-3248 URL: https://issues.apache.org/jira/browse/TRAFODION-3248 Project: Apache Trafodion Issue Type: New Feature Components: connectivity-dcs Affects Versions: 2.4 Reporter: haolin.song Assignee: haolin.song Providing more dcscheck option to get more information about dcs/mxosrvr status. -- This message was sent by Atlassian JIRA (v7.6.3#76005)