[jira] [Commented] (TRAFODION-2110) core/TESTRTS is being incorrectly flagged as PASSED

2016-07-19 Thread ASF GitHub Bot (JIRA)

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/595


> core/TESTRTS is being incorrectly flagged as PASSED
> ---
>
> Key: TRAFODION-2110
> URL: https://issues.apache.org/jira/browse/TRAFODION-2110
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: Selvaganesan Govindarajan
>Assignee: Selvaganesan Govindarajan
>
> There was a problem with the filter FILTERRTS. This causes both the expected 
> and the log output return the same error when the filter is applied on it.  
> Then comparing this output flags it as passed incorrectly.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (TRAFODION-1977) Merge 2.0 fixes forward to master branch

2016-07-19 Thread ASF GitHub Bot (JIRA)

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/603


> Merge 2.0 fixes forward to master branch
> 
>
> Key: TRAFODION-1977
> URL: https://issues.apache.org/jira/browse/TRAFODION-1977
> Project: Apache Trafodion
>  Issue Type: Bug
>Affects Versions: 2.1-incubating
>Reporter: Steve Varnau
>Assignee: Steve Varnau
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (TRAFODION-2113) idtmsrv process ($TSID0) cores

2016-07-19 Thread ASF GitHub Bot (JIRA)

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/602


> idtmsrv process ($TSID0) cores
> --
>
> Key: TRAFODION-2113
> URL: https://issues.apache.org/jira/browse/TRAFODION-2113
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: dtm
>Affects Versions: any
>Reporter: Sean Broeder
>Assignee: Sean Broeder
>
> idtmsrv processed cores at the assert below:
>  lv_ferr = BMSG_READDATA_(pp_sre->sre_msgId,  // msgid
>   (char *) &lv_req,   // reqdata
>   (int) sizeof(lv_req));  // bytecount
> assert(lv_ferr == XZFIL_ERR_OK);
> In this case FEEOF is returned.  This happens because the client has timed 
> out in its id request and has subsequently called BMSG_ABANDON_.
> The fix is to remove the assert and instead test for XMSG_ISCANCELED_ when   
> BMSG_READDATA_ returned <> 0.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (TRAFODION-2102) Load data with # as fs in linux failed

2016-07-19 Thread liu ming (JIRA)

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

liu ming updated TRAFODION-2102:

Assignee: zhangliang

> Load data with # as fs in linux failed
> --
>
> Key: TRAFODION-2102
> URL: https://issues.apache.org/jira/browse/TRAFODION-2102
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: db-utility-odb
> Environment: centos6.7 
> HBase 1.0.0-chd5.4.8
>Reporter: zhangliang
>Assignee: zhangliang
>Priority: Trivial
>
> load data with # as sp and " as fs failed
> logs here:
> Usecase : load with # as sp
> Command : ./odb64luo -u trafodion -p traf123 -d traf  -l 
> src=odb_auto_loadfile/load_data_3:pre=@scripts/ddl_person3.sql:tgt=trafodion.odb_test.person3:max=1000:rows=5000:parallel=5:loadcmd=UL:fs=#:sq=\"
> Result : failed
> During : 22s
> Details :
> odb [2016-07-07 16:47:04]: starting ODBC connection(s)... 0 1 2 3 4 5
> [0.0.0]Executing: 'drop table TRAFODION.odb_test.person3;'
> [0.0.0]--- command executed in 16.499s (prep 0.002s, exec 16.497s, fetch 
> 0.000s/0.000s)
> [0.0.1]Executing: 'CREATE TABLE TRAFODION.odb_test."PERSON3" (PID BIGINT 
> SIGNED NOT NULL,FNAME CHAR(20) NOT NULL,LNAME CHAR(20) NOT NULL,COUNTRY 
> VARCHAR(40) NOT NULL,CITY VARCHAR(40) NOT NULL,BDATE DATE NOT NULL,SEX 
> CHAR(1) NOT NULL,EMAIL VARCHAR(40) NOT NULL,SALARY NUMERIC(9,2) NOT NULL,EMPL 
> VARCHAR(40) NOT NULL,NOTES VARCHAR(80),LOADTS TIMESTAMP(0),PRIMARY KEY 
> (PID));'
> [0.0.1]--- command executed in 1.460s (prep 0.002s, exec 1.458s, fetch 
> 0.000s/0.000s)
> Connected to Trafodion
> odb [Oload(7472)] - Error: row 1 col 1 field truncation. Input string: 
> >1#Jian-Guo#Pu#Canada#Xian#1927-10-07#U#ora...@qq.edu#190048#Google##2016-07-07
>  16:37:06< of length 91. This row won't be loaded
> odb [Oload(7466)] - Warning: row 1 col 2 field truncation. Input string: 
> >2#Liang#Wu#US#Xian#1979-01-24#F#ap...@esgyn.cn#593561#Tencent##2016-07-07
>  16:37:06< of length 86. Only the first 20 char(s) will be loaded
> odb [Oload(7466)] - Warning: row 1 col 3 field truncation. Input string: 
> >3#Yun-Peng#Luo#Canada#Guiyang#1943-09-18#M#ora...@163.org#119880#Microsoft#bb#2016-07-07
>  16:37:06< of length 101. Only the first 20 char(s) will be loaded
> odb [Oload(7466)] - Warning: row 1 col 4 field truncation. Input string: 
> >4#Li-Ru#Yu#India#Xian#1982-01-05#F#le...@sina.com#693695#Esgyn#cc#2016-07-07
>  16:37:06< of length 89. Only the first 40 char(s) will be loaded
> odb [Oload(7466)] - Warning: row 1 col 5 field truncation. Input string: 
> >5#Yun-Peng#Zhou#US#Guiyang#1977-02-03#M#ap...@163.org#586833#Google#cc#2016-07-07
>  16:37:06< of length 94. Only the first 40 char(s) will be loaded
> odb [Oload(7472)] - Error: row 1 col 6 field truncation. Input string: 
> >6#Liang#Luo#Canada#Shanghai#1968-05-13#U#p...@esgyn.cn#980259#Apple#cc#2016-07-07
>  16:37:06< of length 94. This row won't be loaded
> odb [Oload(7466)] - Warning: row 1 col 7 field truncation. Input string: 
> >7#Fu-Jin#Zhang#Canada#Shanghai#1964-08-02#M#p...@qq.edu#189402#Esgyn##2016-07-07
>  16:37:06< of length 93. Only the first 1 char(s) will be loaded
> odb [Oload(7466)] - Warning: row 1 col 8 field truncation. Input string: 
> >8#Liang#Zhang#Canada#Guangzhou#1987-01-12#F#p...@sina.cn#1670621#Microsoft##2016-07-07
>  16:37:06< of length 99. Only the first 40 char(s) will be loaded
> odb [Oload(7472)] - Error: row 1 col 9 field truncation. Input string: 
> >9#Shi-Fu#Yu#US#Beijing#2005-04-05#M#ap...@esgyn.cn#1045566#Microsoft##2016-07-07
>  16:37:06< of length 93. This row won't be loaded
> odb [Oload(7466)] - Warning: row 1 col 10 field truncation. Input string: 
> >10#Liang#Wu#Canada#Shanghai#1917-07-18#M#ap...@163.cn#1810598#Esgyn#bb#2016-07-07
>  16:37:06< of length 94. Only the first 40 char(s) will be loaded
> odb [Oload(7466)] - Warning: row 1 col 11 field truncation. Input string: 
> >11#Shi-Fu#Wu#Canada#Guangzhou#1966-05-30#M#ora...@gmail.org#1376463#Google#cc#2016-07-07
>  16:37:06< of length 101. Only the first 80 char(s) will be loaded
> odb [Oload(7472)] - Error: row 1 col 12 field truncation. Input string: 
> >12#Liang#Wu#China#Shanghai#1999-09-05#M#ora...@gmail.org#306457#HP#bb#2016-07-07
>  16:37:06< of length 93. This row won't be loaded
> ...
> [0] odb version 1.1.0 Load statistics:
>  [0] Target table: TRAFODION.ODB_TEST.PERSON3
>  [0] Source: odb_auto_loadfile/load_data_3
>  [0] Pre-loading time: 21.917 s (00:00:21.917)
>  [0] Loading time: 0.052 s(00:00:00.052)
>  [0] Total records read: 833
>  [0] Total records inserted: 0
>  [0] Total number of columns: 12
>  [0] Total bytes read: 1,138,306
>  [0] Average input row size: 1,366.5 B
>  [0] ODBC row size: 341 B (data) + 96 B (len ind)
>  [0] Rowset size: 1,000
>  [0] Rowset buffer size: 4

[jira] [Updated] (TRAFODION-2103) Load data with " as sp and " as fs in linux failed

2016-07-19 Thread liu ming (JIRA)

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

liu ming updated TRAFODION-2103:

Assignee: zhangliang

> Load data with " as sp and " as fs in linux failed
> --
>
> Key: TRAFODION-2103
> URL: https://issues.apache.org/jira/browse/TRAFODION-2103
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: db-utility-odb
> Environment: centos6.7
> HBase 1.0.0 - cdh 5.4.8
>Reporter: zhangliang
>Assignee: zhangliang
>Priority: Trivial
>
> load data with " as sp and " as fs failed.
> It is because the sp of first colume and the fs of second one matched, and 
> odb consider it is colume 2 and is a null string, meawhile, the table define 
> that colume 2 cannot be null.
> logs here:
> Usecase : load with " as sp
> Command : ./odb64luo -u trafodion -p traf123 -d traf  -l 
> src=odb_auto_loadfile/load_data_11:pre=@scripts/ddl_person3.sql:tgt=trafodion.odb_test.person3:max=1000:rows=5000:parallel=5:loadcmd=UL:fs=\":sq=\"
> Result : failed
> During : 36s
> Details :
> odb [2016-07-07 16:50:16]: starting ODBC connection(s)... 0 1 2 3 4 5
> [0.0.0]Executing: 'drop table TRAFODION.odb_test.person3;'
> [0.0.0]--- command executed in 16.653s (prep 0.002s, exec 16.651s, fetch 
> 0.000s/0.000s)
> [0.0.1]Executing: 'CREATE TABLE TRAFODION.odb_test."PERSON3" (PID BIGINT 
> SIGNED NOT NULL,FNAME CHAR(20) NOT NULL,LNAME CHAR(20) NOT NULL,COUNTRY 
> VARCHAR(40) NOT NULL,CITY VARCHAR(40) NOT NULL,BDATE DATE NOT NULL,SEX 
> CHAR(1) NOT NULL,EMAIL VARCHAR(40) NOT NULL,SALARY NUMERIC(9,2) NOT NULL,EMPL 
> VARCHAR(40) NOT NULL,NOTES VARCHAR(80),LOADTS TIMESTAMP(0),PRIMARY KEY 
> (PID));'
> [0.0.1]--- command executed in 1.435s (prep 0.002s, exec 1.433s, fetch 
> 0.000s/0.000s)
> Connected to Trafodion
> [1] odb [Oloadbuff(9438)] - Error loading row 1 (State: 23000, Native 0)
> [Trafodion ODBC Driver] GENERAL ERROR. Null Value in a non nullable column. 
> Row: 1 Column: 2
> >>> 1""Liang"""Yu"""Japan"""Beijing
> [1] odb [Oloadbuff(9438)] - Error loading row 1 (State: 23000, Native 0)
> [Trafodion ODBC Driver] GENERAL ERROR. Null Value in a non nullable column. 
> Row: 1 Column: 4
> >>> 1""Liang"""Yu"""Japan"""Beijing
> [1] odb [Oloadbuff(9438)] - Error loading row 1 (State: 23000, Native 0)
> [Trafodion ODBC Driver] GENERAL ERROR. Null Value in a non nullable column. 
> Row: 1 Column: 5
> >>> 1""Liang"""Yu"""Japan"""Beijing
> [1] odb [Oloadbuff(9438)] - Error loading row 1 (State: 23000, Native 0)
> [Trafodion ODBC Driver] GENERAL ERROR. Null Value in a non nullable column. 
> Row: 1 Column: 7
> >>> 1""Liang"""Yu"""Japan"""Beijing
> ...
> [1] 0 records inserted [commit]
> [0] odb version 1.1.0 Load statistics:
>  [0] Target table: TRAFODION.ODB_TEST.PERSON3
>  [0] Source: odb_auto_loadfile/load_data_11
>  [0] Pre-loading time: 21.300 s (00:00:21.300)
>  [0] Loading time: 15.028 s(00:00:15.028)
>  [0] Total records read: 1,000
>  [0] Total records inserted: 0
>  [0] Total number of columns: 12
>  [0] Total bytes read: 262,144
>  [0] Average input row size: 262.1 B
>  [0] ODBC row size: 341 B (data) + 96 B (len ind)
>  [0] Rowset size: 1,000
>  [0] Rowset buffer size: 426.76 KiB
>  [0] Load throughput (real data): 17.035 KiB/s
>  [0] Load throughput (ODBC): 0.000 KiB/s
>  [0] Reader Total/Wait Cycles: 1/0
> odb [2016-07-07 16:50:52]: exiting. Session Elapsed time 36.339 seconds 
> (00:00:36.339)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (TRAFODION-2104) odb crashed when extract single table using xml format in linux

2016-07-19 Thread liu ming (JIRA)

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

liu ming updated TRAFODION-2104:

Assignee: zhangliang

> odb crashed when extract single table using xml format in linux
> ---
>
> Key: TRAFODION-2104
> URL: https://issues.apache.org/jira/browse/TRAFODION-2104
> Project: Apache Trafodion
>  Issue Type: Bug
> Environment: centos6.7
> HBase 1.0.0 - cdh 5.4.8
>Reporter: zhangliang
>Assignee: zhangliang
>Priority: Minor
>
> function pass and extract correct file, but odb crashed at last 
> Usecase : Extract single table using xml format
> Command : ./odb64luo -u trafodion -p traf123 -d traf -e 
> src=trafodion.odb_test_extract.person_e:tgt=output_data/ext_xml_%t.csv:rows=m10:fs=,:trim:sq=\":xml
> Result : failed
> During : 14s
> Details :
> Connected to Trafodion
> [0] odb(13001) [2016-07-07 16:58:37] - [Trafodion ODBC Driver][Trafodion 
> Database] SQL WARNING:*** WARNING[6008] Statistics for column (PID) from 
> table TRAFODION.ODB_TEST_EXTRACT.PERSON_E were not available. As a result, 
> the access path chosen might not be the best possible. [2016-07-07 16:58:17] 
> (State: 01000 Native Err: 6008)
> odb [2016-07-07 16:58:37]: starting ODBC connection(s)... 0
> [0] odb(3206) [2016-07-07 16:58:38] - [Trafodion ODBC Driver][Trafodion 
> Database] SQL WARNING:*** WARNING[6008] Statistics for column (PID) from 
> table TRAFODION.ODB_TEST_EXTRACT.PERSON_E were not available. As a result, 
> the access path chosen might not be the best possible. [2016-07-07 16:58:18] 
> (State: 01000 Native Err: 6008)
> [0] 29,704 records extracted
> [0] 59,408 records extracted
> [0] 89,112 records extracted
> [0] 118,816 records extracted
> [0] 148,520 records extracted
> [0] 178,224 records extracted
> [0] 207,928 records extracted
> [0] 237,632 records extracted
> [0] 267,336 records extracted
> [0] 297,040 records extracted
> [0] 326,744 records extracted
> [0] 356,448 records extracted
> [0] 386,152 records extracted
> [0] 415,856 records extracted
> [0] 445,560 records extracted
> [0] 475,264 records extracted
> [0] 504,968 records extracted
> [0] 534,672 records extracted
> [0] 564,376 records extracted
> [0] 594,080 records extracted
> [0] 623,784 records extracted
> [0] 653,488 records extracted
> [0] 683,192 records extracted
> [0] 712,896 records extracted
> [0] 742,600 records extracted
> [0] 772,304 records extracted
> [0] 802,008 records extracted
> [0] 831,712 records extracted
> [0] 861,416 records extracted
> [0] 891,120 records extracted
> [0] 920,824 records extracted
> [0] 950,528 records extracted
> [0] 980,232 records extracted
> [0] 1,000,000 records extracted
> sh: line 1: 34333 Segmentation fault  ./odb64luo -u trafodion -p traf123 
> -d traf -e 
> src=trafodion.odb_test_extract.person_e:tgt=output_data/ext_xml_%t.csv:rows=m10:fs=,:trim:sq=\":xml



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (TRAFODION-2108) Allow multiple, different OLAP window specifications in a SELECT

2016-07-19 Thread liu ming (JIRA)

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

liu ming updated TRAFODION-2108:

Assignee: Howard Qin

> Allow multiple, different OLAP window specifications in a SELECT
> 
>
> Key: TRAFODION-2108
> URL: https://issues.apache.org/jira/browse/TRAFODION-2108
> Project: Apache Trafodion
>  Issue Type: New Feature
>  Components: sql-cmp
>Affects Versions: 1.3-incubating
> Environment: Any
>Reporter: Hans Zeller
>Assignee: Howard Qin
>
> Trafodion supports OLAP functions with a window specification, like this:
> {noformat}
> select *, sum(b) over(partition by a order by b) x
> from (values (1,1,1), (1,2,2), (2,1,3), (2,2,4)) T(a,b,c);
> {noformat}
> It also allows multiple such functions, as long as they all use the same 
> window specification:
> {noformat}
> select *, sum(b) over(partition by a order by b) x,
>   max(b) over(partition by a order by b) y
> from (values (1,1,1), (1,2,2), (2,1,3), (2,2,4)) T(a,b,c);
> {noformat}
> However, if we use different window specifications in the same SELECT, we get 
> this error:
> {noformat}
> select *, sum(b) over(partition by a order by b) x,
>   max(b) over(partition by b order by a) z
> from (values (1,1,1), (1,2,2), (2,1,3), (2,2,4)) T(a,b,c);
> *** ERROR[4340] All Window Functions within a query must have
> the same window partition clause and window order clause.
> {noformat}
> It would be nice if we could transparently rewrite this into the following, 
> supported syntax:
> {noformat}
> select *, max(b) over(partition by b order by a) z
> from (select *, sum(b) over(partition by a order by b) x
>   from (values (1,1,1), (1,2,2), (2,1,3), (2,2,4)) T(a,b,c));
> {noformat}
> We could also do some optimizations, but that could come later (and would be 
> a separate JIRA).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (TRAFODION-2117) add support of SQL extension 'EXCEPT'

2016-07-19 Thread liu ming (JIRA)
liu ming created TRAFODION-2117:
---

 Summary: add support of SQL extension 'EXCEPT' 
 Key: TRAFODION-2117
 URL: https://issues.apache.org/jira/browse/TRAFODION-2117
 Project: Apache Trafodion
  Issue Type: New Feature
Reporter: liu ming


add syntax and basic functional support for 'EXCEPT', meet the requirement to 
run TPCDS as initial goal.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (TRAFODION-2117) add support of SQL extension 'EXCEPT'

2016-07-19 Thread liu ming (JIRA)

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

liu ming reassigned TRAFODION-2117:
---

Assignee: liu ming

> add support of SQL extension 'EXCEPT' 
> --
>
> Key: TRAFODION-2117
> URL: https://issues.apache.org/jira/browse/TRAFODION-2117
> Project: Apache Trafodion
>  Issue Type: New Feature
>Reporter: liu ming
>Assignee: liu ming
>
> add syntax and basic functional support for 'EXCEPT', meet the requirement to 
> run TPCDS as initial goal.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (TRAFODION-2016) doesn't support vanilla hbase 1.1

2016-07-19 Thread ASF GitHub Bot (JIRA)

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/600


> doesn't support vanilla hbase 1.1
> -
>
> Key: TRAFODION-2016
> URL: https://issues.apache.org/jira/browse/TRAFODION-2016
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: mashengchen
>Assignee: mashengchen
>
> trafodion 2.1 support cdh5.4 & hdp2.3 & vanilla hbase 1.0.
> but when use hbase 1.1 ,it can pass compile, the reason is some APIs and 
> method return type changed.
> Need generate another suit of codes like what hdp2.3 do (hdp2.3 based on 
> hbase 1.1).
> also need to support cdh5.5



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (TRAFODION-1743) Unable to create a volatile table in a stored procedure

2016-07-19 Thread ASF GitHub Bot (JIRA)

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/561


> Unable to create a volatile table in a stored procedure
> ---
>
> Key: TRAFODION-1743
> URL: https://issues.apache.org/jira/browse/TRAFODION-1743
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Reporter: Roberta Marton
>Assignee: mashengchen
>
> Wrote an SPJ that creates a volatile table.  The following error is returned:
> create stmt: create volatile table ABC_2016_01_07_19_32_29_11(version int not 
> null, time_lct char(26) character set ISO88591 not null, user_name char(128) 
> character set ISO88591 not null, grant_depth int not null, seq_num largeint 
> generated by default as identity , grant_details varchar (500) character set 
> ISO88591 not null) ;
> @Thu Jan 07 19:32:31 GMT 2016: ERROR: unable to create the results table *** 
> ERROR[15001] A syntax error occurred at or before:
> CREATE VOLATILE SCHEMA;
>  ^ (22 characters from start of SQL statement)
> The same create statement works fine through sqlci



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (TRAFODION-2116) The ODBC Driver DSN functionality still using "HP" prefix for configuration key name

2016-07-19 Thread RuoYu Zuo (JIRA)
RuoYu Zuo created TRAFODION-2116:


 Summary: The ODBC Driver DSN functionality still using "HP" prefix 
for configuration key name
 Key: TRAFODION-2116
 URL: https://issues.apache.org/jira/browse/TRAFODION-2116
 Project: Apache Trafodion
  Issue Type: Bug
  Components: client-odbc-linux
 Environment: Linux
Reporter: RuoYu Zuo
Assignee: RuoYu Zuo


ODBC DSN configuration still using "HPDatabaseCertificateDir" for user to 
specify the location of saving the server certificate file. HP no longer owns 
the Trafodion's copyright and authority, this is exposed to users, which will 
cause confusion. We must stop using the "HP" prefix.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (TRAFODION-2065) Documentation of TO_CHAR, TO_DATE, TO_NUMBER

2016-07-19 Thread liu ming (JIRA)

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

liu ming updated TRAFODION-2065:

Assignee: Liu Yu  (was: liu ming)

> Documentation of TO_CHAR, TO_DATE, TO_NUMBER
> 
>
> Key: TRAFODION-2065
> URL: https://issues.apache.org/jira/browse/TRAFODION-2065
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: documentation
>Reporter: liu ming
>Assignee: Liu Yu
>
> It is very hard to know how to use Trafodion TO_CHAR, the format is not fully 
> compatible with Oracle, and there are some limitations, without 
> documentation, it is hard to be used.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (TRAFODION-2115) Better UX for README on GitHub main page.

2016-07-19 Thread Eason Zhang (JIRA)
Eason Zhang created TRAFODION-2115:
--

 Summary: Better UX for README on GitHub main page.
 Key: TRAFODION-2115
 URL: https://issues.apache.org/jira/browse/TRAFODION-2115
 Project: Apache Trafodion
  Issue Type: Improvement
  Components: documentation
Reporter: Eason Zhang
Assignee: Eason Zhang
Priority: Minor


Use markdown to support better UX for trafodion README file.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)