[jira] [Updated] (TRAFODION-3150) to_char and extract function's new options bug
[ https://issues.apache.org/jira/browse/TRAFODION-3150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chenyunren updated TRAFODION-3150: -- Description: 1.select extract(quarter from interval '99' month) from dual; return:33 should return 1 2.select extract(week from date '2016-01-03') from dual; return:2 should return 1 3.select to_char(date '2016-01-03','ww') from dual; return:2 should return 1 4.select to_char(time '00:00:01', 'hh12') from dual; return:00 should return 12 was: 1.select extract(quarter from interval '99' month) from dual; return:33 should return 2 2.select extract(week from date '2016-01-03') from dual; return:2 should return 1 3.select to_char(date '2016-01-03','ww') from dual; return:2 should return 1 4.select to_char(time '00:00:01', 'hh12') from dual; return:00 should return 12 > to_char and extract function's new options bug > -- > > Key: TRAFODION-3150 > URL: https://issues.apache.org/jira/browse/TRAFODION-3150 > Project: Apache Trafodion > Issue Type: Bug >Reporter: chenyunren >Priority: Major > > 1.select extract(quarter from interval '99' month) from dual; > return:33 > should return 1 > 2.select extract(week from date '2016-01-03') from dual; > return:2 > should return 1 > 3.select to_char(date '2016-01-03','ww') from dual; > return:2 > should return 1 > 4.select to_char(time '00:00:01', 'hh12') from dual; > return:00 > should return 12 -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3150) to_char and extract function's new options bug
chenyunren created TRAFODION-3150: - Summary: to_char and extract function's new options bug Key: TRAFODION-3150 URL: https://issues.apache.org/jira/browse/TRAFODION-3150 Project: Apache Trafodion Issue Type: Bug Reporter: chenyunren 1.select extract(quarter from interval '99' month) from dual; return:33 should return 2 2.select extract(week from date '2016-01-03') from dual; return:2 should return 1 3.select to_char(date '2016-01-03','ww') from dual; return:2 should return 1 4.select to_char(time '00:00:01', 'hh12') from dual; return:00 should return 12 -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*
[ https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16547320#comment-16547320 ] ASF GitHub Bot commented on TRAFODION-3144: --- Github user liuyu000 commented on a diff in the pull request: https://github.com/apache/trafodion/pull/1645#discussion_r203239377 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc --- @@ -390,25 +390,27 @@ alter-action is: column-definition is: column-name data-type - ([DEFAULT default] - [[constraint constraint-name] column-constraint]) + [[DEFAULT default] + [[constraint constraint-name] column-constraint]] data-type is: char[acter] [(length)[characters]] - [CHARACTER SET char-set-name] - [UPSHIFT] [[not] casespecific] - | char[acter] varying (length) - [character set char-set-name] - [upshift] [[not] casespecific] - | varchar (length) [character set char-set-name] - [upshift] [[not] casespecific] - | varchar2 (length) [character set char-set-name] - [upshift] [[not] casespecific] + [CHARACTER SET char-set-name] + [UPSHIFT] [[NOT] CASESPECIFIC] + | char[acter] varying (length [characters]) + [CHARACTER SET char-set-name] + [UPSHIFT] [[NOT] CASESPECIFIC] + | varchar (length [characters]) + [CHARACTER SET char-set-name] + [UPSHIFT] [[NOT] CASESPECIFIC] + | varchar2 (length [characters]) + [CHARACTER SET char-set-name] + [UPSHIFT] [[NOT] CASESPECIFIC] + | nchar [length [characters]] --- End diff -- Yes, the origin text is right, I've corrected it š > Correct Syntactic Descriptions of Character String Data Types and Add > Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference > Manual* > -- > > Key: TRAFODION-3144 > URL: https://issues.apache.org/jira/browse/TRAFODION-3144 > Project: Apache Trafodion > Issue Type: Documentation >Reporter: Liu Yu >Assignee: Liu Yu >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3142) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *CREATE TABLE Statement* in *Trafodion SQL Reference Manual*
[ https://issues.apache.org/jira/browse/TRAFODION-3142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16547296#comment-16547296 ] ASF GitHub Bot commented on TRAFODION-3142: --- Github user liuyu000 commented on a diff in the pull request: https://github.com/apache/trafodion/pull/1644#discussion_r203234030 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc --- @@ -2963,18 +2963,22 @@ column-definition is: <<< ``` data-type is: -char[acter] [(length [characters])] - [character set char-set-name] - [upshift] [[not]casespecific] +char[acter] [length [characters]] +[character set char-set-name] +[upshift] [[not]casespecific] | char[acter] varying (length [characters]) - [character set char-set-name] - [upshift] [[not]casespecific] - | varchar (length) [character set char-set-name] +[character set char-set-name] +[upshift] [[not]casespecific] + | varchar (length [characters]) +[character set char-set-name] +[upshift] [[not]casespecific] + | varchar2 (length [characters]) + [character set char-set-name] + [upshift] [[not]casespecific] + | nchar [length [characters]] --- End diff -- Here should be `nchar [(length) [characters]]` š > Correct Syntactic Descriptions of Character String Data Types and Add > Examples (NCHAR) for *CREATE TABLE Statement* in *Trafodion SQL Reference > Manual* > --- > > Key: TRAFODION-3142 > URL: https://issues.apache.org/jira/browse/TRAFODION-3142 > Project: Apache Trafodion > Issue Type: Documentation >Reporter: Liu Yu >Assignee: Liu Yu >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3142) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *CREATE TABLE Statement* in *Trafodion SQL Reference Manual*
[ https://issues.apache.org/jira/browse/TRAFODION-3142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16547295#comment-16547295 ] ASF GitHub Bot commented on TRAFODION-3142: --- Github user liuyu000 commented on a diff in the pull request: https://github.com/apache/trafodion/pull/1644#discussion_r203233947 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc --- @@ -2963,18 +2963,22 @@ column-definition is: <<< ``` data-type is: -char[acter] [(length [characters])] - [character set char-set-name] - [upshift] [[not]casespecific] +char[acter] [length [characters]] --- End diff -- Yes, the origin text is right, I've corrected my writing š > Correct Syntactic Descriptions of Character String Data Types and Add > Examples (NCHAR) for *CREATE TABLE Statement* in *Trafodion SQL Reference > Manual* > --- > > Key: TRAFODION-3142 > URL: https://issues.apache.org/jira/browse/TRAFODION-3142 > Project: Apache Trafodion > Issue Type: Documentation >Reporter: Liu Yu >Assignee: Liu Yu >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Work started] (TRAFODION-3147) add sys_guid function
[ https://issues.apache.org/jira/browse/TRAFODION-3147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3147 started by liu ming. --- > add sys_guid function > - > > Key: TRAFODION-3147 > URL: https://issues.apache.org/jira/browse/TRAFODION-3147 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: liu ming >Priority: Major > > add sys_guid as alias of UUID -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (TRAFODION-3148) Creating a persistent sample table on a Hive table fails with some columns
[ https://issues.apache.org/jira/browse/TRAFODION-3148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3148. - Resolution: Fixed Fix Version/s: 2.3 > Creating a persistent sample table on a Hive table fails with some columns > -- > > Key: TRAFODION-3148 > URL: https://issues.apache.org/jira/browse/TRAFODION-3148 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Affects Versions: 2.3 >Reporter: David Wayne Birdsall >Assignee: David Wayne Birdsall >Priority: Major > Fix For: 2.3 > > > The following reproduces the problem. > First, create and populate a Hive table that uses the column name > "__DIVISION_1__". (In Hive, one uses backticks to define delimited column > names rather than double quotes as in standard SQL.): > {{hive> create table dave2( a int, `__DIVISION_1__` int)}} > Ā > stored as textfile > Ā > ; > {{OK}} > {{Time taken: 0.122 seconds}} > {{hive> insert into dave2 values (1,2),(3,4),(5,6),(7,8);}} > Then, in Trafodion sqlci, attempt to create a random sample. This will fail: > {{>>update statistics for table hive.hive.dave2 create sample random 90 > percent;}} > {{*** ERROR[9200] UPDATE STATISTICS for table HIVE.HIVE.DAVE2 encountered an > error (4023) from statement Process_Query.}} > {{*** ERROR[4023] The degree of each row value constructor (1) must equal the > degree of the target table column list (2).}} > {{*** ERROR[8822] The statement was not prepared.}}{{--- SQL operation failed > with errors.}} > {{>>}} > The probable cause of the problem is that "__DIVISION_1__" is assumed in > Trafodion to be a derived column, but this assumption is incorrect for Hive > tables. > Ā -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3148) Creating a persistent sample table on a Hive table fails with some columns
[ https://issues.apache.org/jira/browse/TRAFODION-3148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16547064#comment-16547064 ] ASF GitHub Bot commented on TRAFODION-3148: --- Github user asfgit closed the pull request at: https://github.com/apache/trafodion/pull/1649 > Creating a persistent sample table on a Hive table fails with some columns > -- > > Key: TRAFODION-3148 > URL: https://issues.apache.org/jira/browse/TRAFODION-3148 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Affects Versions: 2.3 >Reporter: David Wayne Birdsall >Assignee: David Wayne Birdsall >Priority: Major > > The following reproduces the problem. > First, create and populate a Hive table that uses the column name > "__DIVISION_1__". (In Hive, one uses backticks to define delimited column > names rather than double quotes as in standard SQL.): > {{hive> create table dave2( a int, `__DIVISION_1__` int)}} > Ā > stored as textfile > Ā > ; > {{OK}} > {{Time taken: 0.122 seconds}} > {{hive> insert into dave2 values (1,2),(3,4),(5,6),(7,8);}} > Then, in Trafodion sqlci, attempt to create a random sample. This will fail: > {{>>update statistics for table hive.hive.dave2 create sample random 90 > percent;}} > {{*** ERROR[9200] UPDATE STATISTICS for table HIVE.HIVE.DAVE2 encountered an > error (4023) from statement Process_Query.}} > {{*** ERROR[4023] The degree of each row value constructor (1) must equal the > degree of the target table column list (2).}} > {{*** ERROR[8822] The statement was not prepared.}}{{--- SQL operation failed > with errors.}} > {{>>}} > The probable cause of the problem is that "__DIVISION_1__" is assumed in > Trafodion to be a derived column, but this assumption is incorrect for Hive > tables. > Ā -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*
[ https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16546866#comment-16546866 ] ASF GitHub Bot commented on TRAFODION-3144: --- Github user DaveBirdsall commented on a diff in the pull request: https://github.com/apache/trafodion/pull/1645#discussion_r203094486 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc --- @@ -390,25 +390,27 @@ alter-action is: column-definition is: column-name data-type - ([DEFAULT default] - [[constraint constraint-name] column-constraint]) + [[DEFAULT default] + [[constraint constraint-name] column-constraint]] data-type is: char[acter] [(length)[characters]] - [CHARACTER SET char-set-name] - [UPSHIFT] [[not] casespecific] - | char[acter] varying (length) - [character set char-set-name] - [upshift] [[not] casespecific] - | varchar (length) [character set char-set-name] - [upshift] [[not] casespecific] - | varchar2 (length) [character set char-set-name] - [upshift] [[not] casespecific] + [CHARACTER SET char-set-name] + [UPSHIFT] [[NOT] CASESPECIFIC] + | char[acter] varying (length [characters]) + [CHARACTER SET char-set-name] + [UPSHIFT] [[NOT] CASESPECIFIC] + | varchar (length [characters]) + [CHARACTER SET char-set-name] + [UPSHIFT] [[NOT] CASESPECIFIC] + | varchar2 (length [characters]) + [CHARACTER SET char-set-name] + [UPSHIFT] [[NOT] CASESPECIFIC] + | nchar [length [characters]] --- End diff -- Thanks; you are correct. So, it should say, "nchar [(length [characters])]". The length is optional, but if it is present, parentheses are required. > Correct Syntactic Descriptions of Character String Data Types and Add > Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference > Manual* > -- > > Key: TRAFODION-3144 > URL: https://issues.apache.org/jira/browse/TRAFODION-3144 > Project: Apache Trafodion > Issue Type: Documentation >Reporter: Liu Yu >Assignee: Liu Yu >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3142) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *CREATE TABLE Statement* in *Trafodion SQL Reference Manual*
[ https://issues.apache.org/jira/browse/TRAFODION-3142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16546865#comment-16546865 ] ASF GitHub Bot commented on TRAFODION-3142: --- Github user DaveBirdsall commented on a diff in the pull request: https://github.com/apache/trafodion/pull/1644#discussion_r203093950 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc --- @@ -2963,18 +2963,22 @@ column-definition is: <<< ``` data-type is: -char[acter] [(length [characters])] - [character set char-set-name] - [upshift] [[not]casespecific] +char[acter] [length [characters]] --- End diff -- FYI: I double-checked the parser code. Length is optional for CHAR and NCHAR. Length is required for VARCHAR and NCHAR VARYING. > Correct Syntactic Descriptions of Character String Data Types and Add > Examples (NCHAR) for *CREATE TABLE Statement* in *Trafodion SQL Reference > Manual* > --- > > Key: TRAFODION-3142 > URL: https://issues.apache.org/jira/browse/TRAFODION-3142 > Project: Apache Trafodion > Issue Type: Documentation >Reporter: Liu Yu >Assignee: Liu Yu >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3142) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *CREATE TABLE Statement* in *Trafodion SQL Reference Manual*
[ https://issues.apache.org/jira/browse/TRAFODION-3142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16546849#comment-16546849 ] ASF GitHub Bot commented on TRAFODION-3142: --- Github user DaveBirdsall commented on a diff in the pull request: https://github.com/apache/trafodion/pull/1644#discussion_r203091243 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc --- @@ -2963,18 +2963,22 @@ column-definition is: <<< ``` data-type is: -char[acter] [(length [characters])] - [character set char-set-name] - [upshift] [[not]casespecific] +char[acter] [length [characters]] --- End diff -- Ah, good catch! I stand corrected. So, the original text, "char[acter] [(length [characters])] was correct? (The parentheses are needed if a length is supplied.) > Correct Syntactic Descriptions of Character String Data Types and Add > Examples (NCHAR) for *CREATE TABLE Statement* in *Trafodion SQL Reference > Manual* > --- > > Key: TRAFODION-3142 > URL: https://issues.apache.org/jira/browse/TRAFODION-3142 > Project: Apache Trafodion > Issue Type: Documentation >Reporter: Liu Yu >Assignee: Liu Yu >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (TRAFODION-3149) errors in jdbct4 file
[ https://issues.apache.org/jira/browse/TRAFODION-3149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16546139#comment-16546139 ] ASF GitHub Bot commented on TRAFODION-3149: --- GitHub user CoderSong2015 opened a pull request: https://github.com/apache/trafodion/pull/1650 [TRAFODION-3149] Delete duplicated property names in T4Messages.propeā¦ Some simple mistakes exist in jdbct4 property file, which causing failure to pass inspection of JTEST. Duplicated property name 'forward_only_cursor_msg' on line 143 Duplicated property name 'forward_only_cursor_sqlstate' on line 144 Duplicated property name 'forward_only_cursor_sqlcode' on line 145 Duplicated property name 'read_only_concur_msg' on line 147 Duplicated property name 'read_only_concur_sqlstate' on line 148 Duplicated property name 'read_only_concur_sqlcode' on line 149 You can merge this pull request into a Git repository by running: $ git pull https://github.com/CoderSong2015/Apache-Trafodion master Alternatively you can review and apply these changes as the patch at: https://github.com/apache/trafodion/pull/1650.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 #1650 commit 379b3b3ba04ff4cda9b7af3a18dec2ac8326bca4 Author: Haolin.song <403438485@...> Date: 2018-07-17T15:25:10Z [TRAFODION-3149] Delete duplicated property names in T4Messages.properties > errors in jdbct4 file > - > > Key: TRAFODION-3149 > URL: https://issues.apache.org/jira/browse/TRAFODION-3149 > Project: Apache Trafodion > Issue Type: Bug >Reporter: haolin.song >Priority: Major > > SomeĀ simple mistakes exist in jdbct4 property file, which causingĀ failure to > pass inspection of JTEST. > Ā -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (TRAFODION-3149) errors in jdbct4 file
haolin.song created TRAFODION-3149: -- Summary: errors in jdbct4 file Key: TRAFODION-3149 URL: https://issues.apache.org/jira/browse/TRAFODION-3149 Project: Apache Trafodion Issue Type: Bug Reporter: haolin.song SomeĀ simple mistakes exist in jdbct4 property file, which causingĀ failure to pass inspection of JTEST. Ā -- This message was sent by Atlassian JIRA (v7.6.3#76005)