[jira] [Created] (TRAFODION-3006) unix_timestamp runtime crash

[liu ming (JIRA)]

liu ming created TRAFODION-3006:
---

 Summary: unix_timestamp runtime crash
 Key: TRAFODION-3006
 URL: https://issues.apache.org/jira/browse/TRAFODION-3006
 Project: Apache Trafodion
  Issue Type: Bug
Reporter: liu ming
Assignee: liu ming


in some cases 

select unix_timestamp('2017-11-02 00:00:00') from dual;

will crash



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (TRAFODION-3005) CREATE INDEX on certain long chars fails with Java exceptions

[David Wayne Birdsall (JIRA)]

 [ 
https://issues.apache.org/jira/browse/TRAFODION-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Wayne Birdsall updated TRAFODION-3005:

Description: 
The following session illustrates the issue. Creating an index on a CHAR(32757) 
succeeds. Creating an index on a CHAR(32766) fails with a good error message 
(1141). But creating an index on intermediate sizes fails with a Java 
exception, pointing to some bug with near-boundary conditions.

{{>>drop table if exists mytable;}}{{--- SQL operation complete.}}
{{>>create table mytable (}}
{{+>c1 char(32757),}}
{{+>c2 char(32758),}}
{{+>c3 char(32765),}}
{{+>c4 char(32766));}}{{--- SQL operation complete.}}
{{>>insert into mytable values ('A','A','A','A');}}{{--- 1 row(s) inserted.}}
{{>>create index idx1 on mytable (c1);}}{{--- SQL operation complete.}}
{{>>create index idx2 on mytable (c2);}}{{*** ERROR[8448] Unable to access 
Hbase interface. Call to ExpHbaseInterface::addToHFile returned error 
HBASE_ADD_TO_HFILE_ERROR(-713). Cause: java.lang.NegativeArraySizeException}}
{{org.trafodion.sql.HBulkLoadClient.addToHFile(HBulkLoadClient.java:247).}}

{{*** ERROR[1081] Loading of index TRAFODION.SCH.IDX2 failed unexpectedly.}}

{{--- SQL operation failed with errors.}}
{{>>create index idx3 on mytable (c3);}}

{{*** ERROR[8448] Unable to access Hbase interface. Call to 
ExpHbaseInterface::addToHFile returned error HBASE_ADD_TO_HFILE_ERROR(-713). 
Cause: java.lang.NegativeArraySizeException}}
{{org.trafodion.sql.HBulkLoadClient.addToHFile(HBulkLoadClient.java:247).}}

{{*** ERROR[1081] Loading of index TRAFODION.SCH.IDX3 failed unexpectedly.}}

{{--- SQL operation failed with errors.}}
{{>>create index idx4 on mytable (c4);}}

{{*** ERROR[1141] Key length 32768 exceeds the maximum allowed key length of 
32767.}}

{{--- SQL operation failed with errors.}}
{{>>}}

> CREATE INDEX on certain long chars fails with Java exceptions
> -
>
> Key: TRAFODION-3005
> URL: https://issues.apache.org/jira/browse/TRAFODION-3005
> 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 session illustrates the issue. Creating an index on a 
> CHAR(32757) succeeds. Creating an index on a CHAR(32766) fails with a good 
> error message (1141). But creating an index on intermediate sizes fails with 
> a Java exception, pointing to some bug with near-boundary conditions.
> {{>>drop table if exists mytable;}}{{--- SQL operation complete.}}
> {{>>create table mytable (}}
> {{+>c1 char(32757),}}
> {{+>c2 char(32758),}}
> {{+>c3 char(32765),}}
> {{+>c4 char(32766));}}{{--- SQL operation complete.}}
> {{>>insert into mytable values ('A','A','A','A');}}{{--- 1 row(s) inserted.}}
> {{>>create index idx1 on mytable (c1);}}{{--- SQL operation complete.}}
> {{>>create index idx2 on mytable (c2);}}{{*** ERROR[8448] Unable to access 
> Hbase interface. Call to ExpHbaseInterface::addToHFile returned error 
> HBASE_ADD_TO_HFILE_ERROR(-713). Cause: java.lang.NegativeArraySizeException}}
> {{org.trafodion.sql.HBulkLoadClient.addToHFile(HBulkLoadClient.java:247).}}
> {{*** ERROR[1081] Loading of index TRAFODION.SCH.IDX2 failed unexpectedly.}}
> {{--- SQL operation failed with errors.}}
> {{>>create index idx3 on mytable (c3);}}
> {{*** ERROR[8448] Unable to access Hbase interface. Call to 
> ExpHbaseInterface::addToHFile returned error HBASE_ADD_TO_HFILE_ERROR(-713). 
> Cause: java.lang.NegativeArraySizeException}}
> {{org.trafodion.sql.HBulkLoadClient.addToHFile(HBulkLoadClient.java:247).}}
> {{*** ERROR[1081] Loading of index TRAFODION.SCH.IDX3 failed unexpectedly.}}
> {{--- SQL operation failed with errors.}}
> {{>>create index idx4 on mytable (c4);}}
> {{*** ERROR[1141] Key length 32768 exceeds the maximum allowed key length of 
> 32767.}}
> {{--- SQL operation failed with errors.}}
> {{>>}}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2494) support listagg function

[liu ming (JIRA)]

[ 
https://issues.apache.org/jira/browse/TRAFODION-2494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16406066#comment-16406066
 ] 

liu ming commented on TRAFODION-2494:
-

Yes, Anoop.

I checked this again, it is an Oracle function, very similar with group_concat, 
so I will leave this open, and no need to support it until real requirement.

It is part of Oracle compatibility, but no strong requirement for now. It was 
once required, so I create a Jira to record it.

 

Basic function:
   DEPTNO ENAME
- --
   10 CLARK
   10 KING
   10 MILLER
   20 ADAMS
   20 FORD
   20 JONES

   DEPTNO AGGREGATED_ENAMES
- -
   10 CLARK,KING,MILLER
   20 ADAMS,FORD,JONES

> support listagg function
> 
>
> Key: TRAFODION-2494
> URL: https://issues.apache.org/jira/browse/TRAFODION-2494
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: liu ming
>Assignee: liu ming
>Priority: Major
>
> to simulate Oracle's listagg function.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2985) Update Project Web Site for Apache Trafodion Release 2.2.0

[Jacques Le Roux (JIRA)]

[ 
https://issues.apache.org/jira/browse/TRAFODION-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16405964#comment-16405964
 ] 

Jacques Le Roux commented on TRAFODION-2985:


Don't you close issues when completely done?

> Update Project Web Site for Apache Trafodion Release 2.2.0
> --
>
> Key: TRAFODION-2985
> URL: https://issues.apache.org/jira/browse/TRAFODION-2985
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: liu ming
>Assignee: liu ming
>Priority: Major
> Fix For: 2.2.0
>
>
> h3. Update Project Web Site



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2900) insert or update or upsert 40 length Chinese to char(30) set character utf8 column successfully

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TRAFODION-2900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16405924#comment-16405924
 ] 

ASF GitHub Bot commented on TRAFODION-2900:
---

Github user CoderSong2015 closed the pull request at:

https://github.com/apache/trafodion/pull/1387


> insert or update or upsert 40 length Chinese to char(30) set character utf8 
> column successfully
> ---
>
> Key: TRAFODION-2900
> URL: https://issues.apache.org/jira/browse/TRAFODION-2900
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: client-jdbc-t4
>Affects Versions: 2.3
> Environment: centos
>Reporter: haolin.song
>Priority: Major
>
> call "setBinaryStream(int parameterIndex,InputStream int length) or 
> setBinaryStream(int parameterIndex,InputStream long length) or
> setBytes(int parameterIndex,Bytes[] x) or
> setCharacterStream(int parameterIndex,Reader x,int length) or
> setCharacterStream(int parameterIndex,Reader x,long length) or
> setObject(int parameterIndex,Object x,int length) or
> setObject(int parameterIndex, Object x, int targetSqlType) or
> setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) 
> or
> setString(int parameterIndex,String x)" to insert/update/upsert 40 length 
> Chinese to char(30) column,except fail actual success,



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (TRAFODION-2985) Update Project Web Site for Apache Trafodion Release 2.2.0

[Pierre Smits (JIRA)]

 [ 
https://issues.apache.org/jira/browse/TRAFODION-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits updated TRAFODION-2985:

Fix Version/s: 2.2.0

> Update Project Web Site for Apache Trafodion Release 2.2.0
> --
>
> Key: TRAFODION-2985
> URL: https://issues.apache.org/jira/browse/TRAFODION-2985
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: liu ming
>Assignee: liu ming
>Priority: Major
> Fix For: 2.2.0
>
>
> h3. Update Project Web Site



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3001) Add an Overview of *Datetime Functions* in *Trafodion SQL Reference Manual*

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TRAFODION-3001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16405872#comment-16405872
 ] 

ASF GitHub Bot commented on TRAFODION-3001:
---

GitHub user liuyu000 opened a pull request:

https://github.com/apache/trafodion/pull/1486

[TRAFODION-3001] Add an Overview of *Datetime Functions* in *Trafodion SQL 
Reference Manual*



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/liuyu000/trafodion DatetimeFunctions

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/trafodion/pull/1486.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 #1486


commit 3260a586edfdaaaea6f8c1c0710e8b2ec38bf569
Author: liu.yu 
Date:   2018-03-20T06:26:18Z

$ Add an Overview of *Datetime Functions* in *Trafodion SQL Reference
Manual




> Add an Overview of *Datetime Functions* in *Trafodion SQL Reference Manual*
> ---
>
> Key: TRAFODION-3001
> URL: https://issues.apache.org/jira/browse/TRAFODION-3001
> 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] [Updated] (TRAFODION-3001) Add an Overview of *Datetime Functions* in *Trafodion SQL Reference Manual*

[Liu Yu (JIRA)]

 [ 
https://issues.apache.org/jira/browse/TRAFODION-3001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Liu Yu updated TRAFODION-3001:
--
Summary: Add an Overview of *Datetime Functions* in *Trafodion SQL 
Reference Manual*  (was: Add an overview of *Datetime Functions* in *Trafodion 
SQL Reference Manual*)

> Add an Overview of *Datetime Functions* in *Trafodion SQL Reference Manual*
> ---
>
> Key: TRAFODION-3001
> URL: https://issues.apache.org/jira/browse/TRAFODION-3001
> 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)