[jira] [Resolved] (TRAFODION-3325) Inefficient plan when using a join to a tuple list

2019-09-17 Thread David Wayne Birdsall (Jira)
[ https://issues.apache.org/jira/browse/TRAFODION-3325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3325. - Fix Version/s: 2.4 Resolution: Fixed > Inefficient plan when

[jira] [Created] (TRAFODION-3326) Rewrite logsort utility

2019-09-16 Thread David Wayne Birdsall (Jira)
David Wayne Birdsall created TRAFODION-3326: --- Summary: Rewrite logsort utility Key: TRAFODION-3326 URL: https://issues.apache.org/jira/browse/TRAFODION-3326 Project: Apache Trafodion

[jira] [Work started] (TRAFODION-3325) Inefficient plan when using a join to a tuple list

2019-09-09 Thread David Wayne Birdsall (Jira)
[ https://issues.apache.org/jira/browse/TRAFODION-3325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3325 started by David Wayne Birdsall. --- > Inefficient plan when using a join to a tuple list

[jira] [Updated] (TRAFODION-3325) Inefficient plan when using a join to a tuple list

2019-09-09 Thread David Wayne Birdsall (Jira)
[ https://issues.apache.org/jira/browse/TRAFODION-3325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall updated TRAFODION-3325: Attachment: repro.sql.txt > Inefficient plan when using a join to a

[jira] [Updated] (TRAFODION-3325) Inefficient plan when using a join to a tuple list

2019-09-09 Thread David Wayne Birdsall (Jira)
[ https://issues.apache.org/jira/browse/TRAFODION-3325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall updated TRAFODION-3325: Description: In the example below, statement s1 gets a hash join plan

[jira] [Created] (TRAFODION-3325) Inefficient plan when using a join to a tuple list

2019-09-09 Thread David Wayne Birdsall (Jira)
David Wayne Birdsall created TRAFODION-3325: --- Summary: Inefficient plan when using a join to a tuple list Key: TRAFODION-3325 URL: https://issues.apache.org/jira/browse/TRAFODION-3325

[jira] [Resolved] (TRAFODION-3324) Make compiler a bit more robust when Hive DDL changes are done in Hive

2019-08-14 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3324. - Resolution: Fixed Fix Version/s: 2.4 > Make compiler a bit

[jira] [Work started] (TRAFODION-3324) Make compiler a bit more robust when Hive DDL changes are done in Hive

2019-08-12 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3324 started by David Wayne Birdsall. --- > Make compiler a bit more robust when Hive DDL

[jira] [Resolved] (TRAFODION-3323) Remove obsolete line from odbc.ini file in documentation

2019-08-12 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3323. - Resolution: Fixed Fix Version/s: 2.4 > Remove obsolete line

[jira] [Created] (TRAFODION-3324) Make compiler a bit more robust when Hive DDL changes are done in Hive

2019-08-08 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3324: --- Summary: Make compiler a bit more robust when Hive DDL changes are done in Hive Key: TRAFODION-3324 URL:

[jira] [Created] (TRAFODION-3323) Remove obsolete line from odbc.ini file in documentation

2019-08-07 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3323: --- Summary: Remove obsolete line from odbc.ini file in documentation Key: TRAFODION-3323 URL: https://issues.apache.org/jira/browse/TRAFODION-3323

[jira] [Commented] (TRAFODION-3322) odb incorrectly generates 0 rows in a certain scenario

2019-08-07 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16902483#comment-16902483 ] David Wayne Birdsall commented on TRAFODION-3322: - I debugged this. The bug seems to

[jira] [Updated] (TRAFODION-3322) odb incorrectly generates 0 rows in a certain scenario

2019-08-07 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall updated TRAFODION-3322: Description: In the following scenario, odb generates 0 rows when it

[jira] [Created] (TRAFODION-3322) odb incorrectly generates 0 rows in a certain scenario

2019-08-07 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3322: --- Summary: odb incorrectly generates 0 rows in a certain scenario Key: TRAFODION-3322 URL: https://issues.apache.org/jira/browse/TRAFODION-3322

[jira] [Resolved] (TRAFODION-3321) odb Generate and Load Data documentation incorrect

2019-08-07 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3321. - Resolution: Fixed Fix Version/s: 2.4 > odb Generate and Load

[jira] [Updated] (TRAFODION-3321) odb Generate and Load Data documentation incorrect

2019-08-05 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall updated TRAFODION-3321: Description: In section 5.5 Generate and Load Data in the odb User

[jira] [Resolved] (TRAFODION-3316) Fix some issues with incremental UPDATE STATISTICS

2019-07-10 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3316. - Resolution: Fixed Fix Version/s: 2.4 > Fix some issues with

[jira] [Work started] (TRAFODION-3316) Fix some issues with incremental UPDATE STATISTICS

2019-07-09 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3316 started by David Wayne Birdsall. --- > Fix some issues with incremental UPDATE STATISTICS

[jira] [Created] (TRAFODION-3316) Fix some issues with incremental UPDATE STATISTICS

2019-07-08 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3316: --- Summary: Fix some issues with incremental UPDATE STATISTICS Key: TRAFODION-3316 URL: https://issues.apache.org/jira/browse/TRAFODION-3316

[jira] [Resolved] (TRAFODION-3315) OSIM gives no error detail when Hive failures occur

2019-07-08 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3315. - Resolution: Fixed > OSIM gives no error detail when Hive failures

[jira] [Work started] (TRAFODION-3315) OSIM gives no error detail when Hive failures occur

2019-07-03 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3315 started by David Wayne Birdsall. --- > OSIM gives no error detail when Hive failures occur

[jira] [Resolved] (TRAFODION-3314) OSIM generates redundant DDL for unique constraints

2019-07-03 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3314. - Resolution: Fixed Fix Version/s: 2.4 > OSIM generates

[jira] [Created] (TRAFODION-3315) OSIM gives no error detail when Hive failures occur

2019-07-03 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3315: --- Summary: OSIM gives no error detail when Hive failures occur Key: TRAFODION-3315 URL: https://issues.apache.org/jira/browse/TRAFODION-3315

[jira] [Work started] (TRAFODION-3314) OSIM generates redundant DDL for unique constraints

2019-07-02 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3314 started by David Wayne Birdsall. --- > OSIM generates redundant DDL for unique constraints

[jira] [Created] (TRAFODION-3314) OSIM generates redundant DDL for unique constraints

2019-07-01 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3314: --- Summary: OSIM generates redundant DDL for unique constraints Key: TRAFODION-3314 URL: https://issues.apache.org/jira/browse/TRAFODION-3314

[jira] [Resolved] (TRAFODION-3309) Improve analyzeMessagesGuide.py for errors in 2000 range

2019-05-21 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3309. - Resolution: Fixed Fix Version/s: 2.4 > Improve

[jira] [Resolved] (TRAFODION-3308) Uninformative error messages when executables are unavailable

2019-05-16 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3308. - Resolution: Fixed Fix Version/s: 2.4 > Uninformative error

[jira] [Created] (TRAFODION-3309) Improve analyzeMessagesGuide.py for errors in 2000 range

2019-05-16 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3309: --- Summary: Improve analyzeMessagesGuide.py for errors in 2000 range Key: TRAFODION-3309 URL: https://issues.apache.org/jira/browse/TRAFODION-3309

[jira] [Created] (TRAFODION-3308) Uninformative error messages when executables are unavailable

2019-05-14 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3308: --- Summary: Uninformative error messages when executables are unavailable Key: TRAFODION-3308 URL: https://issues.apache.org/jira/browse/TRAFODION-3308

[jira] [Resolved] (TRAFODION-3300) ROUND function on extreme data types fails with numeric overflows

2019-04-24 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3300. - Resolution: Fixed Fix Version/s: 2.4 > ROUND function on

[jira] [Resolved] (TRAFODION-3299) Update Messages Guide for still more binder messages

2019-04-24 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3299. - Resolution: Fixed Fix Version/s: 2.4 > Update Messages Guide

[jira] [Created] (TRAFODION-3300) ROUND function on extreme data types fails with numeric overflows

2019-04-18 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3300: --- Summary: ROUND function on extreme data types fails with numeric overflows Key: TRAFODION-3300 URL: https://issues.apache.org/jira/browse/TRAFODION-3300

[jira] [Created] (TRAFODION-3299) Update Messages Guide for still more binder messages

2019-04-17 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3299: --- Summary: Update Messages Guide for still more binder messages Key: TRAFODION-3299 URL: https://issues.apache.org/jira/browse/TRAFODION-3299

[jira] [Resolved] (TRAFODION-3296) Subquery with [first n] + ORDER BY gives wrong answer

2019-04-16 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3296. - Resolution: Fixed Fix Version/s: 2.4 > Subquery with [first

[jira] [Assigned] (TRAFODION-3294) Update Messages Guide for some binder messages

2019-04-15 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall reassigned TRAFODION-3294: --- Assignee: David Wayne Birdsall > Update Messages Guide for some

[jira] [Resolved] (TRAFODION-3297) Update Messages Guide for some more binder messages

2019-04-15 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3297. - Resolution: Fixed Fix Version/s: 2.4 > Update Messages Guide

[jira] [Created] (TRAFODION-3297) Update Messages Guide for some more binder messages

2019-04-12 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3297: --- Summary: Update Messages Guide for some more binder messages Key: TRAFODION-3297 URL: https://issues.apache.org/jira/browse/TRAFODION-3297

[jira] [Created] (TRAFODION-3296) Subquery with [first n] + ORDER BY gives wrong answer

2019-04-09 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3296: --- Summary: Subquery with [first n] + ORDER BY gives wrong answer Key: TRAFODION-3296 URL: https://issues.apache.org/jira/browse/TRAFODION-3296

[jira] [Resolved] (TRAFODION-3294) Update Messages Guide for some binder messages

2019-04-08 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3294. - Resolution: Fixed Fix Version/s: 2.4 > Update Messages Guide

[jira] [Resolved] (TRAFODION-3291) UPDATE STATISTICS on wide tables causes a tdm_arkcmp core

2019-04-05 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3291. - Resolution: Fixed Fix Version/s: 2.4 > UPDATE STATISTICS on

[jira] [Created] (TRAFODION-3294) Update Messages Guide for some binder messages

2019-04-05 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3294: --- Summary: Update Messages Guide for some binder messages Key: TRAFODION-3294 URL: https://issues.apache.org/jira/browse/TRAFODION-3294 Project:

[jira] [Resolved] (TRAFODION-3290) Creating a sample table on an all-LOB table fails with syntax error

2019-04-04 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3290. - Resolution: Fixed Fix Version/s: 2.4 > Creating a sample

[jira] [Created] (TRAFODION-3291) UPDATE STATISTICS on wide tables causes a tdm_arkcmp core

2019-03-27 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3291: --- Summary: UPDATE STATISTICS on wide tables causes a tdm_arkcmp core Key: TRAFODION-3291 URL: https://issues.apache.org/jira/browse/TRAFODION-3291

[jira] [Created] (TRAFODION-3290) Creating a sample table on an all-LOB table fails with syntax error

2019-03-27 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3290: --- Summary: Creating a sample table on an all-LOB table fails with syntax error Key: TRAFODION-3290 URL: https://issues.apache.org/jira/browse/TRAFODION-3290

[jira] [Resolved] (TRAFODION-3284) SUM aggregate overflow criteria are inconsistent with rest of product

2019-03-12 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3284. - Resolution: Fixed Fix Version/s: 2.4 > SUM aggregate overflow

[jira] [Created] (TRAFODION-3284) SUM aggregate overflow criteria are inconsistent with rest of product

2019-03-11 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3284: --- Summary: SUM aggregate overflow criteria are inconsistent with rest of product Key: TRAFODION-3284 URL: https://issues.apache.org/jira/browse/TRAFODION-3284

[jira] [Resolved] (TRAFODION-3282) Buffer overrun in ExHdfsScan::work in certain conditions

2019-03-05 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3282?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3282. - Resolution: Fixed Fix Version/s: 2.4 > Buffer overrun in

[jira] [Created] (TRAFODION-3282) Buffer overrun in ExHdfsScan::work in certain conditions

2019-03-04 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3282: --- Summary: Buffer overrun in ExHdfsScan::work in certain conditions Key: TRAFODION-3282 URL: https://issues.apache.org/jira/browse/TRAFODION-3282

[jira] [Resolved] (TRAFODION-3276) Fix regression caused by [TRAFODION-3270]

2019-02-14 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3276. - Resolution: Fixed Fix Version/s: 2.4 > Fix regression caused

[jira] [Created] (TRAFODION-3276) Fix regression caused by [TRAFODION-3270]

2019-02-13 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3276: --- Summary: Fix regression caused by [TRAFODION-3270] Key: TRAFODION-3276 URL: https://issues.apache.org/jira/browse/TRAFODION-3276 Project: Apache

[jira] [Resolved] (TRAFODION-3273) Cli can go off the end of a wide descriptor

2019-02-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3273. - Resolution: Fixed Fix Version/s: 2.4 > Cli can go off the end

[jira] [Resolved] (TRAFODION-3261) Improve logsort utility to sort output from GET SCHEMA etc. statements

2019-02-12 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3261. - Resolution: Fixed Fix Version/s: 2.4 > Improve logsort

[jira] [Created] (TRAFODION-3273) Cli can go off the end of a wide descriptor

2019-02-07 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3273: --- Summary: Cli can go off the end of a wide descriptor Key: TRAFODION-3273 URL: https://issues.apache.org/jira/browse/TRAFODION-3273 Project:

[jira] [Resolved] (TRAFODION-3270) Query that has mismatched datatypes on an IN predicate cores on debug builds

2019-02-06 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3270?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3270. - Resolution: Fixed Fix Version/s: 2.4 > Query that has

[jira] [Commented] (TRAFODION-3270) Query that has mismatched datatypes on an IN predicate cores on debug builds

2019-02-06 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16761946#comment-16761946 ] David Wayne Birdsall commented on TRAFODION-3270: - The logic to handle incompatible

[jira] [Created] (TRAFODION-3270) Query that has mismatched datatypes on an IN predicate cores on debug builds

2019-02-04 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3270: --- Summary: Query that has mismatched datatypes on an IN predicate cores on debug builds Key: TRAFODION-3270 URL:

[jira] [Resolved] (TRAFODION-3266) UPDATE STATISTICS should use SKIP CONFLICT ACCESS when accessing the base table

2019-01-31 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3266. - Resolution: Fixed Fix Version/s: 2.4 > UPDATE STATISTICS

[jira] [Created] (TRAFODION-3266) UPDATE STATISTICS should use SKIP CONFLICT ACCESS when accessing the base table

2019-01-29 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3266: --- Summary: UPDATE STATISTICS should use SKIP CONFLICT ACCESS when accessing the base table Key: TRAFODION-3266 URL:

[jira] [Created] (TRAFODION-3261) Improve logsort utility to sort output from GET SCHEMA etc. statements

2019-01-22 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3261: --- Summary: Improve logsort utility to sort output from GET SCHEMA etc. statements Key: TRAFODION-3261 URL:

[jira] [Resolved] (TRAFODION-3256) Missing error return in Statement::doHiveTableSimCheck

2019-01-16 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3256. - Resolution: Fixed Fix Version/s: 2.4 > Missing error return

[jira] [Created] (TRAFODION-3257) SPLIT_PART behavior for null values is inconsistent

2019-01-15 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3257: --- Summary: SPLIT_PART behavior for null values is inconsistent Key: TRAFODION-3257 URL: https://issues.apache.org/jira/browse/TRAFODION-3257

[jira] [Work started] (TRAFODION-3256) Missing error return in Statement::doHiveTableSimCheck

2019-01-15 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-3256 started by David Wayne Birdsall. --- > Missing error return in

[jira] [Created] (TRAFODION-3256) Missing error return in Statement::doHiveTableSimCheck

2019-01-15 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3256: --- Summary: Missing error return in Statement::doHiveTableSimCheck Key: TRAFODION-3256 URL: https://issues.apache.org/jira/browse/TRAFODION-3256

[jira] [Resolved] (TRAFODION-3237) Incorrect results for INTERVAL addition in an uncommon case

2018-12-12 Thread David Wayne Birdsall (JIRA)
[ 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

[jira] [Created] (TRAFODION-3243) Dereference of deallocated NAString in UPDATE STATISTICS can cause cores

2018-12-05 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3243: --- Summary: Dereference of deallocated NAString in UPDATE STATISTICS can cause cores Key: TRAFODION-3243 URL:

[jira] [Created] (TRAFODION-3237) Incorrect results for INTERVAL addition in an uncommon case

2018-11-26 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3237: --- Summary: Incorrect results for INTERVAL addition in an uncommon case Key: TRAFODION-3237 URL: https://issues.apache.org/jira/browse/TRAFODION-3237

[jira] [Resolved] (TRAFODION-3223) Row count estimation code works poorly on time-ordered aged-out data

2018-10-18 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3223?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3223. - Resolution: Fixed Fix Version/s: 2.4 > Row count estimation

[jira] [Created] (TRAFODION-3223) Row count estimation code works poorly on time-ordered aged-out data

2018-10-16 Thread David Wayne Birdsall (JIRA)
David Wayne Birdsall created TRAFODION-3223: --- Summary: Row count estimation code works poorly on time-ordered aged-out data Key: TRAFODION-3223 URL: https://issues.apache.org/jira/browse/TRAFODION-3223

[jira] [Closed] (TRAFODION-3153) CREATE EXTERNAL TABLE doesn't report error if Hive table already exists

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3153. --- > CREATE EXTERNAL TABLE doesn't report error if Hive table already exists >

[jira] [Closed] (TRAFODION-3152) UPDATE STATISTICS ... CREATE SAMPLE failure on Hive table

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3152. --- > UPDATE STATISTICS ... CREATE SAMPLE failure on Hive table >

[jira] [Closed] (TRAFODION-3138) Remove obsolete code from UPDATE STATISTICS

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3138. --- > Remove obsolete code from UPDATE STATISTICS >

[jira] [Closed] (TRAFODION-3140) Apache trafodion main page news updates

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3140. --- > Apache trafodion main page news updates >

[jira] [Closed] (TRAFODION-3135) Remove some obsolete cruft from the SQL parser and related modules

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3135?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3135. --- > Remove some obsolete cruft from the SQL parser and related modules >

[jira] [Closed] (TRAFODION-3131) Use of reserved words as names fails in many places

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3131. --- > Use of reserved words as names fails in many places >

[jira] [Closed] (TRAFODION-3128) INTERVAL SECOND(m,n) in multi-column key results in 6003 warnings

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3128. --- > INTERVAL SECOND(m,n) in multi-column key results in 6003 warnings >

[jira] [Closed] (TRAFODION-3088) Multi-value BETWEEN on interval key column gives wrong result

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3088?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3088. --- > Multi-value BETWEEN on interval key column gives wrong result >

[jira] [Closed] (TRAFODION-2926) Link to JIRA should use https:

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2926. --- > Link to JIRA should use https: > -- > >

[jira] [Closed] (TRAFODION-3083) Trafodion compiles fail on CentOS7

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3083. --- > Trafodion compiles fail on CentOS7 > -- >

[jira] [Closed] (TRAFODION-3071) DATEDIFF function gives strange results when executed on interval data types

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3071?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3071. --- > DATEDIFF function gives strange results when executed on interval data

[jira] [Closed] (TRAFODION-3052) Core in pCode evaluator for query on million-row non-partitioned table

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3052. --- > Core in pCode evaluator for query on million-row non-partitioned table >

[jira] [Closed] (TRAFODION-3066) Deeply nested subqueries may have warning 2053 at compile time

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3066. --- > Deeply nested subqueries may have warning 2053 at compile time >

[jira] [Closed] (TRAFODION-3056) UPDATE STATISTICS fails with error 8838 when RMS is not running

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3056. --- > UPDATE STATISTICS fails with error 8838 when RMS is not running >

[jira] [Closed] (TRAFODION-3023) Add more enum files to analyzeMessageGuide.py

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3023?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3023. --- > Add more enum files to analyzeMessageGuide.py >

[jira] [Closed] (TRAFODION-3043) DATE_PART(YEARQUARTER|YEARMONTH|YEARWEEK, ) should return a proper error

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3043?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3043. --- > DATE_PART(YEARQUARTER|YEARMONTH|YEARWEEK, ) should return a proper >

[jira] [Closed] (TRAFODION-3031) Query with nested subqueries chooses bad plan

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3031. --- > Query with nested subqueries chooses bad plan >

[jira] [Closed] (TRAFODION-3002) UPDATE STATS fails on certain INTERVAL columns

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3002. --- > UPDATE STATS fails on certain INTERVAL columns >

[jira] [Closed] (TRAFODION-3000) MERGE DELETE on table with unique index fails with error 4002

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3000. --- > MERGE DELETE on table with unique index fails with error 4002 >

[jira] [Closed] (TRAFODION-3018) Select of UPPER on upshifted column in join predicate cores

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3018. --- > Select of UPPER on upshifted column in join predicate cores >

[jira] [Closed] (TRAFODION-2977) Trafodion allows creating objects with longer key lengths than HBase supports

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2977. --- > Trafodion allows creating objects with longer key lengths than HBase

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

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-3005. --- > CREATE INDEX on certain long chars fails with Java exceptions >

[jira] [Closed] (TRAFODION-2990) CREATE TABLE LIKE fails with long numeric default value

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2990?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2990. --- > CREATE TABLE LIKE fails with long numeric default value >

[jira] [Closed] (TRAFODION-2969) Subquery with [first 1] in select list results in Normalizer internal error

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2969. --- > Subquery with [first 1] in select list results in Normalizer internal

[jira] [Closed] (TRAFODION-2983) Query fails with an internal error in the generator

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2983. --- > Query fails with an internal error in the generator >

[jira] [Closed] (TRAFODION-2964) New MDAM costing code incorrectly assumes key column is always on the left

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2964. --- > New MDAM costing code incorrectly assumes key column is always on the left

[jira] [Closed] (TRAFODION-2967) UPDATE STATISTICS sometimes cores in CommonLogger::buildMsgBuffer

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2967. --- > UPDATE STATISTICS sometimes cores in CommonLogger::buildMsgBuffer >

[jira] [Closed] (TRAFODION-2840) ORDER BY clause on a view circumvents [first n] updatability check

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2840?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2840. --- > ORDER BY clause on a view circumvents [first n] updatability check >

[jira] [Closed] (TRAFODION-2645) MDAM costing overestimates I/O cost

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2645. --- > MDAM costing overestimates I/O cost > ---

[jira] [Closed] (TRAFODION-2966) New MDAM costing code does not always respect CQS forcing MDAM

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2966. --- > New MDAM costing code does not always respect CQS forcing MDAM >

[jira] [Closed] (TRAFODION-2927) Keep log information for UPDATE STATISTICS in case of errors

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2927. --- > Keep log information for UPDATE STATISTICS in case of errors >

[jira] [Closed] (TRAFODION-2928) Add news articles about Trafodion to Trafodion web site

2018-08-13 Thread David Wayne Birdsall (JIRA)
[ https://issues.apache.org/jira/browse/TRAFODION-2928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2928. --- > Add news articles about Trafodion to Trafodion web site >

  1   2   3   >