[jira] [Work logged] (TRAFODION-3329) Remove unused code in T2 driver

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3329?focusedWorklogId=322364=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322364
 ]

ASF GitHub Bot logged work on TRAFODION-3329:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 23:41
Start Date: 02/Oct/19 23:41
Worklog Time Spent: 10m 
  Work Description: selvaganesang commented on pull request #1859: 
[TRAFODION-3329] Code cleanup in Type 2 driver
URL: https://github.com/apache/trafodion/pull/1859#discussion_r330815443
 
 

 ##
 File path: core/sql/sqlmxevents/logmxevent_traf.h
 ##
 @@ -189,4 +190,7 @@ class SQLMXLoggingArea


 
 };
 
+void logAnMXEventForError( ComCondition & condition, 
SQLMXLoggingArea::ExperienceLevel emsEventEL);
 
 Review comment:
   The implementation was already available at cli/CliExtern.cpp. The 
corresponding include file will be sqlcli.h that contains the interface to be 
used by the clients to Trafodion SQL engine. Hence, I added this declaration in 
logmxevent_traf.h
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322364)
Time Spent: 40m  (was: 0.5h)

> Remove unused code in T2 driver
> ---
>
> Key: TRAFODION-3329
> URL: https://issues.apache.org/jira/browse/TRAFODION-3329
> Project: Apache Trafodion
>  Issue Type: Sub-task
>  Components: client-jdbc-t2
>Reporter: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 40m
>  Remaining Estimate: 0h
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Work logged] (TRAFODION-3329) Remove unused code in T2 driver

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3329?focusedWorklogId=322363=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322363
 ]

ASF GitHub Bot logged work on TRAFODION-3329:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 23:34
Start Date: 02/Oct/19 23:34
Worklog Time Spent: 10m 
  Work Description: DaveBirdsall commented on pull request #1859: 
[TRAFODION-3329] Code cleanup in Type 2 driver
URL: https://github.com/apache/trafodion/pull/1859#discussion_r330813852
 
 

 ##
 File path: core/sql/sqlmxevents/logmxevent_traf.h
 ##
 @@ -189,4 +190,7 @@ class SQLMXLoggingArea


 
 };
 
+void logAnMXEventForError( ComCondition & condition, 
SQLMXLoggingArea::ExperienceLevel emsEventEL);
 
 Review comment:
   Is there a function body somewhere that goes with this? I don't see it in 
this pull request.
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322363)
Time Spent: 0.5h  (was: 20m)

> Remove unused code in T2 driver
> ---
>
> Key: TRAFODION-3329
> URL: https://issues.apache.org/jira/browse/TRAFODION-3329
> Project: Apache Trafodion
>  Issue Type: Sub-task
>  Components: client-jdbc-t2
>Reporter: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 0.5h
>  Remaining Estimate: 0h
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Work logged] (TRAFODION-3329) Remove unused code in T2 driver

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3329?focusedWorklogId=322360=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322360
 ]

ASF GitHub Bot logged work on TRAFODION-3329:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 23:27
Start Date: 02/Oct/19 23:27
Worklog Time Spent: 10m 
  Work Description: Traf-Jenkins commented on issue #1859: [TRAFODION-3329] 
Code cleanup in Type 2 driver
URL: https://github.com/apache/trafodion/pull/1859#issuecomment-537722843
 
 
   Check Test Started: https://jenkins.esgyn.com/job/Check-PR-master/3267/
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322360)
Time Spent: 20m  (was: 10m)

> Remove unused code in T2 driver
> ---
>
> Key: TRAFODION-3329
> URL: https://issues.apache.org/jira/browse/TRAFODION-3329
> Project: Apache Trafodion
>  Issue Type: Sub-task
>  Components: client-jdbc-t2
>Reporter: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 20m
>  Remaining Estimate: 0h
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Work logged] (TRAFODION-3329) Remove unused code in T2 driver

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3329?focusedWorklogId=322359=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322359
 ]

ASF GitHub Bot logged work on TRAFODION-3329:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 23:27
Start Date: 02/Oct/19 23:27
Worklog Time Spent: 10m 
  Work Description: selvaganesang commented on pull request #1859: 
[TRAFODION-3329] Code cleanup in Type 2 driver
URL: https://github.com/apache/trafodion/pull/1859
 
 
   Remove unused static module related code from T2 driver.
   
   Cleanup of T2 code exposed an issue with cleanup of volatile schema
   at the time of drop session and t2 disconnect.
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322359)
Remaining Estimate: 0h
Time Spent: 10m

> Remove unused code in T2 driver
> ---
>
> Key: TRAFODION-3329
> URL: https://issues.apache.org/jira/browse/TRAFODION-3329
> Project: Apache Trafodion
>  Issue Type: Sub-task
>  Components: client-jdbc-t2
>Reporter: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 10m
>  Remaining Estimate: 0h
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (TRAFODION-3328) Code cleanup in Trafodion

2019-10-02 Thread Selvaganesan Govindarajan (Jira)


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

Selvaganesan Govindarajan updated TRAFODION-3328:
-
Description: 
Trafodion code base has many code paths that are unused due to legacy reasons.  
This Jira will be used to track all the tasks associated with this cleanup 
effort

 

  was:
With embedded compiler, there is a need to have many cmpContexts to compile the 
query because the compile code is not re-entrant. 

With many cmpContext, there is a need to ensure the elements of cmpContext are 
managed in an optimal way. This Jira is  created to track  all the improvements 
that can be done in this area. 


> Code cleanup in Trafodion
> -
>
> Key: TRAFODION-3328
> URL: https://issues.apache.org/jira/browse/TRAFODION-3328
> Project: Apache Trafodion
>  Issue Type: Improvement
>  Components: sql-cmp
>Reporter: Selvaganesan Govindarajan
>Assignee: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> Trafodion code base has many code paths that are unused due to legacy 
> reasons.  This Jira will be used to track all the tasks associated with this 
> cleanup effort
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (TRAFODION-3330) Cleanup of NADefaults

2019-10-02 Thread Selvaganesan Govindarajan (Jira)


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

Selvaganesan Govindarajan updated TRAFODION-3330:
-
Description: 
With embedded compiler, there is a need to have many cmpContexts to compile the 
query because the compile code is not re-entrant. 

With many cmpContext, there is a need to ensure the elements of cmpContext are 
managed in an optimal way. This Jira is  created to track  all the improvements 
that can be done in this area. 

> Cleanup of NADefaults
> -
>
> Key: TRAFODION-3330
> URL: https://issues.apache.org/jira/browse/TRAFODION-3330
> Project: Apache Trafodion
>  Issue Type: Sub-task
>  Components: sql-cmp
>Reporter: Selvaganesan Govindarajan
>Assignee: Selvaganesan Govindarajan
>Priority: Major
>
> With embedded compiler, there is a need to have many cmpContexts to compile 
> the query because the compile code is not re-entrant. 
> With many cmpContext, there is a need to ensure the elements of cmpContext 
> are managed in an optimal way. This Jira is  created to track  all the 
> improvements that can be done in this area. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (TRAFODION-3330) Cleanup of NADefaults

2019-10-02 Thread Selvaganesan Govindarajan (Jira)
Selvaganesan Govindarajan created TRAFODION-3330:


 Summary: Cleanup of NADefaults
 Key: TRAFODION-3330
 URL: https://issues.apache.org/jira/browse/TRAFODION-3330
 Project: Apache Trafodion
  Issue Type: Sub-task
  Components: sql-cmp
Reporter: Selvaganesan Govindarajan
Assignee: Selvaganesan Govindarajan






--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (TRAFODION-3329) Remove unused code in T2 driver

2019-10-02 Thread Selvaganesan Govindarajan (Jira)
Selvaganesan Govindarajan created TRAFODION-3329:


 Summary: Remove unused code in T2 driver
 Key: TRAFODION-3329
 URL: https://issues.apache.org/jira/browse/TRAFODION-3329
 Project: Apache Trafodion
  Issue Type: Sub-task
  Components: client-jdbc-t2
Reporter: Selvaganesan Govindarajan






--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (TRAFODION-3328) Code cleanup in Trafodion

2019-10-02 Thread Selvaganesan Govindarajan (Jira)


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

Selvaganesan Govindarajan updated TRAFODION-3328:
-
Summary: Code cleanup in Trafodion  (was: Code cleanup in NADefaults)

> Code cleanup in Trafodion
> -
>
> Key: TRAFODION-3328
> URL: https://issues.apache.org/jira/browse/TRAFODION-3328
> Project: Apache Trafodion
>  Issue Type: Improvement
>  Components: sql-cmp
>Reporter: Selvaganesan Govindarajan
>Assignee: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> With embedded compiler, there is a need to have many cmpContexts to compile 
> the query because the compile code is not re-entrant. 
> With many cmpContext, there is a need to ensure the elements of cmpContext 
> are managed in an optimal way. This Jira is  created to track  all the 
> improvements that can be done in this area. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Work logged] (TRAFODION-3328) Code cleanup in NADefaults

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3328?focusedWorklogId=322262=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322262
 ]

ASF GitHub Bot logged work on TRAFODION-3328:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 21:02
Start Date: 02/Oct/19 21:02
Worklog Time Spent: 10m 
  Work Description: Traf-Jenkins commented on issue #1858: [TRAFODION-3328] 
Code cleanup in NADefaults
URL: https://github.com/apache/trafodion/pull/1858#issuecomment-537679358
 
 
   Test Failed.  https://jenkins.esgyn.com/job/Check-PR-master/3266/
   
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322262)
Time Spent: 1.5h  (was: 1h 20m)

> Code cleanup in NADefaults
> --
>
> Key: TRAFODION-3328
> URL: https://issues.apache.org/jira/browse/TRAFODION-3328
> Project: Apache Trafodion
>  Issue Type: Improvement
>  Components: sql-cmp
>Reporter: Selvaganesan Govindarajan
>Assignee: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> With embedded compiler, there is a need to have many cmpContexts to compile 
> the query because the compile code is not re-entrant. 
> With many cmpContext, there is a need to ensure the elements of cmpContext 
> are managed in an optimal way. This Jira is  created to track  all the 
> improvements that can be done in this area. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Work logged] (TRAFODION-3328) Code cleanup in NADefaults

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3328?focusedWorklogId=322148=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322148
 ]

ASF GitHub Bot logged work on TRAFODION-3328:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 18:50
Start Date: 02/Oct/19 18:50
Worklog Time Spent: 10m 
  Work Description: DaveBirdsall commented on pull request #1858: 
[TRAFODION-3328] Code cleanup in NADefaults
URL: https://github.com/apache/trafodion/pull/1858#discussion_r330712806
 
 

 ##
 File path: core/sql/sqlcomp/nadefaults.cpp
 ##
 @@ -3629,11 +3622,12 @@ void 
NADefaults::initCurrentDefaultsWithDefaultDefaults()
   }
 // End: Temporary workaround for SQL build regressions to pass
 
-  // Cache all the default keywords up front,
   // leaving other non-keyword token to be cached on demand.
 
 Review comment:
   Should this comment line (line 3625 in the new file) be deleted also? It 
doesn't make sense by itself.
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322148)
Time Spent: 1h 20m  (was: 1h 10m)

> Code cleanup in NADefaults
> --
>
> Key: TRAFODION-3328
> URL: https://issues.apache.org/jira/browse/TRAFODION-3328
> Project: Apache Trafodion
>  Issue Type: Improvement
>  Components: sql-cmp
>Reporter: Selvaganesan Govindarajan
>Assignee: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 1h 20m
>  Remaining Estimate: 0h
>
> With embedded compiler, there is a need to have many cmpContexts to compile 
> the query because the compile code is not re-entrant. 
> With many cmpContext, there is a need to ensure the elements of cmpContext 
> are managed in an optimal way. This Jira is  created to track  all the 
> improvements that can be done in this area. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Work logged] (TRAFODION-3328) Code cleanup in NADefaults

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3328?focusedWorklogId=322147=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322147
 ]

ASF GitHub Bot logged work on TRAFODION-3328:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 18:50
Start Date: 02/Oct/19 18:50
Worklog Time Spent: 10m 
  Work Description: DaveBirdsall commented on pull request #1858: 
[TRAFODION-3328] Code cleanup in NADefaults
URL: https://github.com/apache/trafodion/pull/1858#discussion_r330710014
 
 

 ##
 File path: core/sql/generator/GenRelUpdate.cpp
 ##
 @@ -779,6 +779,7 @@ short HbaseDelete::codeGen(Generator * generator)
 
   NABoolean isAlignedFormat = 
getTableDesc()->getNATable()->isAlignedFormat(getIndexDesc());
   NABoolean isHbaseMapFormat = getTableDesc()->getNATable()->isHbaseMapTable();
+  NABoolean isTrafMDTable = getTableDesc()->getNATable()->isSeabaseMDTable();
 
 Review comment:
   Not sure why this change is here. We don't seem to use isTrafMDTable 
anywhere?
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322147)
Time Spent: 1h 10m  (was: 1h)

> Code cleanup in NADefaults
> --
>
> Key: TRAFODION-3328
> URL: https://issues.apache.org/jira/browse/TRAFODION-3328
> Project: Apache Trafodion
>  Issue Type: Improvement
>  Components: sql-cmp
>Reporter: Selvaganesan Govindarajan
>Assignee: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> With embedded compiler, there is a need to have many cmpContexts to compile 
> the query because the compile code is not re-entrant. 
> With many cmpContext, there is a need to ensure the elements of cmpContext 
> are managed in an optimal way. This Jira is  created to track  all the 
> improvements that can be done in this area. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Work logged] (TRAFODION-3328) Code cleanup in NADefaults

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3328?focusedWorklogId=322146=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322146
 ]

ASF GitHub Bot logged work on TRAFODION-3328:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 18:50
Start Date: 02/Oct/19 18:50
Worklog Time Spent: 10m 
  Work Description: DaveBirdsall commented on pull request #1858: 
[TRAFODION-3328] Code cleanup in NADefaults
URL: https://github.com/apache/trafodion/pull/1858#discussion_r330711433
 
 

 ##
 File path: core/sql/generator/GenRelUpdate.cpp
 ##
 @@ -2449,6 +2450,7 @@ short HbaseInsert::codeGen(Generator *generator)
   }
 
   const NATable *naTable = getTableDesc()->getNATable();
+  NABoolean isTrafMDTable = getTableDesc()->getNATable()->isSeabaseMDTable();
 
 Review comment:
   Same observation here
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322146)
Time Spent: 1h 10m  (was: 1h)

> Code cleanup in NADefaults
> --
>
> Key: TRAFODION-3328
> URL: https://issues.apache.org/jira/browse/TRAFODION-3328
> Project: Apache Trafodion
>  Issue Type: Improvement
>  Components: sql-cmp
>Reporter: Selvaganesan Govindarajan
>Assignee: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> With embedded compiler, there is a need to have many cmpContexts to compile 
> the query because the compile code is not re-entrant. 
> With many cmpContext, there is a need to ensure the elements of cmpContext 
> are managed in an optimal way. This Jira is  created to track  all the 
> improvements that can be done in this area. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Work logged] (TRAFODION-3327) LOB support in T2 driver

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3327?focusedWorklogId=322136=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322136
 ]

ASF GitHub Bot logged work on TRAFODION-3327:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 18:42
Start Date: 02/Oct/19 18:42
Worklog Time Spent: 10m 
  Work Description: selvaganesang commented on pull request #1857: 
[TRAFODION-3327] LOB support in T2 driver
URL: https://github.com/apache/trafodion/pull/1857
 
 
   
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322136)
Time Spent: 1h  (was: 50m)

> LOB support in T2 driver
> 
>
> Key: TRAFODION-3327
> URL: https://issues.apache.org/jira/browse/TRAFODION-3327
> Project: Apache Trafodion
>  Issue Type: New Feature
>  Components: client-jdbc-t2
>Reporter: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 1h
>  Remaining Estimate: 0h
>
> LOB support in T2 driver doesn't use the concepts of LOB in Trafodion SQL 
> engine.  The existing code used the legacy code that was inherited from HP 
> that couldn't be used with new CLOB/BLOB concepts in Trafodion SQL engine.  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Work logged] (TRAFODION-3327) LOB support in T2 driver

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3327?focusedWorklogId=322135=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322135
 ]

ASF GitHub Bot logged work on TRAFODION-3327:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 18:41
Start Date: 02/Oct/19 18:41
Worklog Time Spent: 10m 
  Work Description: selvaganesang commented on issue #1857: 
[TRAFODION-3327] LOB support in T2 driver
URL: https://github.com/apache/trafodion/pull/1857#issuecomment-537626395
 
 
   Thanks @DaveBirdsall . Yes. Lob support is still not functional.  I will be 
making another round of changes with more testing. 
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322135)
Time Spent: 50m  (was: 40m)

> LOB support in T2 driver
> 
>
> Key: TRAFODION-3327
> URL: https://issues.apache.org/jira/browse/TRAFODION-3327
> Project: Apache Trafodion
>  Issue Type: New Feature
>  Components: client-jdbc-t2
>Reporter: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 50m
>  Remaining Estimate: 0h
>
> LOB support in T2 driver doesn't use the concepts of LOB in Trafodion SQL 
> engine.  The existing code used the legacy code that was inherited from HP 
> that couldn't be used with new CLOB/BLOB concepts in Trafodion SQL engine.  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Work logged] (TRAFODION-3328) Code cleanup in NADefaults

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3328?focusedWorklogId=322134=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322134
 ]

ASF GitHub Bot logged work on TRAFODION-3328:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 18:40
Start Date: 02/Oct/19 18:40
Worklog Time Spent: 10m 
  Work Description: DaveBirdsall commented on issue #1858: [TRAFODION-3328] 
Code cleanup in NADefaults
URL: https://github.com/apache/trafodion/pull/1858#issuecomment-537625819
 
 
   jenkins, retest
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322134)
Time Spent: 40m  (was: 0.5h)

> Code cleanup in NADefaults
> --
>
> Key: TRAFODION-3328
> URL: https://issues.apache.org/jira/browse/TRAFODION-3328
> Project: Apache Trafodion
>  Issue Type: Improvement
>  Components: sql-cmp
>Reporter: Selvaganesan Govindarajan
>Assignee: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 40m
>  Remaining Estimate: 0h
>
> With embedded compiler, there is a need to have many cmpContexts to compile 
> the query because the compile code is not re-entrant. 
> With many cmpContext, there is a need to ensure the elements of cmpContext 
> are managed in an optimal way. This Jira is  created to track  all the 
> improvements that can be done in this area. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Work logged] (TRAFODION-3327) LOB support in T2 driver

2019-10-02 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3327?focusedWorklogId=322131=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-322131
 ]

ASF GitHub Bot logged work on TRAFODION-3327:
-

Author: ASF GitHub Bot
Created on: 02/Oct/19 18:38
Start Date: 02/Oct/19 18:38
Worklog Time Spent: 10m 
  Work Description: DaveBirdsall commented on pull request #1857: 
[TRAFODION-3327] LOB support in T2 driver
URL: https://github.com/apache/trafodion/pull/1857#discussion_r330703710
 
 

 ##
 File path: core/conn/jdbc_type2/native/SrvrOthers.cpp
 ##
 @@ -1529,3 +1529,127 @@ odbc_SQLSvc_CloseUsingLabel_sme_(
 }
 FUNCTION_RETURN_VOID((NULL));
 }
+
+extern "C" void
+odbc_SQLSrvr_ExtractLob_sme_(
+/* In*/ void *objtag_
+  , /* In*/ const CEE_handle_def *call_id_
+  , /* Out   */ odbc_SQLsrvr_ExtractLob_exc_ *exception_
+  , /* In*/ long dialogueId
+  , /* In*/ IDL_short extractLobAPI
+  , /* In*/ IDL_string lobHandle
+  , /* In*/ IDL_long_long 
+  , /* Out   */ IDL_long_long 
+  , /* Out   */ BYTE *& extractData
+  )
+{
+char lobExtractQuery[1000] = {0};
+long sqlcode;
+SRVR_STMT_HDL  *QryLobExtractSrvrStmt = NULL;
+
+if ((QryLobExtractSrvrStmt = createSrvrStmt(dialogueId, 
"MXOSRVR_EXTRACTLOB", , 
+   NULL, 0, 0, TYPE_UNKNOWN, false,false)) == NULL) 
+{
+   exception_->exception_nr = odbc_SQLSvc_ExtractLob_SQLInvalidhandle_exn_;
+   return;
+}
+switch (extractLobAPI) {
+case 0:
+snprintf(lobExtractQuery, sizeof(lobExtractQuery), "EXTRACT 
LOBLENGTH(LOB'%s') LOCATION %llu", lobHandle, (Int64));
 
 Review comment:
   Is there a maximum size on strlen(lobHandle)? If not, then long lobHandle 
values (on the order of 980 characters or so) will cause truncation of 
lobExtractQuery, resulting in a SQL error. One way to work around this is to 
use a dynamic array size when declaring the lobExtractQuery array, so we can 
guarantee enough space.
 

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


Issue Time Tracking
---

Worklog Id: (was: 322131)
Time Spent: 40m  (was: 0.5h)

> LOB support in T2 driver
> 
>
> Key: TRAFODION-3327
> URL: https://issues.apache.org/jira/browse/TRAFODION-3327
> Project: Apache Trafodion
>  Issue Type: New Feature
>  Components: client-jdbc-t2
>Reporter: Selvaganesan Govindarajan
>Priority: Major
>  Time Spent: 40m
>  Remaining Estimate: 0h
>
> LOB support in T2 driver doesn't use the concepts of LOB in Trafodion SQL 
> engine.  The existing code used the legacy code that was inherited from HP 
> that couldn't be used with new CLOB/BLOB concepts in Trafodion SQL engine.  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)