[jira] [Closed] (TRAFODION-823) LP Bug: 1402031 - Update stats gets wrong row counts with the first run after loading data

[ https://issues.apache.org/jira/browse/TRAFODION-823?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-823. -- > LP Bug: 1402031 - Update stats gets wrong row counts with the first run after

[jira] [Closed] (TRAFODION-2041) UPDATE STATS uses select count(*) on large tables on HDP 2.3.4

[ https://issues.apache.org/jira/browse/TRAFODION-2041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-2041. --- > UPDATE STATS uses select count(*) on large tables on HDP 2.3.4 >

[jira] [Closed] (TRAFODION-882) LP Bug: 1409937 - Following update statistics, stats do not take effect immediately.

[ https://issues.apache.org/jira/browse/TRAFODION-882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall closed TRAFODION-882. -- > LP Bug: 1409937 - Following update statistics, stats do not take effect >

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

[ https://issues.apache.org/jira/browse/TRAFODION-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-3005. - Resolution: Fixed Fix Version/s: 2.3 > CREATE INDEX on certain

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

[ 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

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

[ https://issues.apache.org/jira/browse/TRAFODION-3000?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16405576#comment-16405576 ] David Wayne Birdsall commented on TRAFODION-3000: - The bug is in the index maintenance

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

David Wayne Birdsall created TRAFODION-3000: --- Summary: MERGE DELETE on table with unique index fails with error 4002 Key: TRAFODION-3000 URL: https://issues.apache.org/jira/browse/TRAFODION-3000

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

[ https://issues.apache.org/jira/browse/TRAFODION-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2977. - Resolution: Fixed Fix Version/s: 2.3 > Trafodion allows

[jira] [Commented] (TRAFODION-2988) Prepare query returns 2006 internal error

[ https://issues.apache.org/jira/browse/TRAFODION-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16399232#comment-16399232 ] David Wayne Birdsall commented on TRAFODION-2988: - Looks like a fix has been submitted

[jira] [Commented] (TRAFODION-2988) Prepare query returns 2006 internal error

[ https://issues.apache.org/jira/browse/TRAFODION-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16399062#comment-16399062 ] David Wayne Birdsall commented on TRAFODION-2988: - I was able to reproduce the issue

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

[ https://issues.apache.org/jira/browse/TRAFODION-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16397314#comment-16397314 ] David Wayne Birdsall commented on TRAFODION-2977: - A related issue. If one tries to

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

[ https://issues.apache.org/jira/browse/TRAFODION-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2977 started by David Wayne Birdsall. --- > Trafodion allows creating objects with longer key

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

[ https://issues.apache.org/jira/browse/TRAFODION-2990?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2990. - Resolution: Fixed Fix Version/s: 2.3 > CREATE TABLE LIKE fails

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

David Wayne Birdsall created TRAFODION-2990: --- Summary: CREATE TABLE LIKE fails with long numeric default value Key: TRAFODION-2990 URL: https://issues.apache.org/jira/browse/TRAFODION-2990

[jira] [Commented] (TRAFODION-2988) Prepare query returns 2006 internal error

[ https://issues.apache.org/jira/browse/TRAFODION-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16395314#comment-16395314 ] David Wayne Birdsall commented on TRAFODION-2988: - Is this a Trafodion issue or a

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

[ https://issues.apache.org/jira/browse/TRAFODION-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2983. - Resolution: Fixed Fix Version/s: 2.3 > Query fails with an

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

[ https://issues.apache.org/jira/browse/TRAFODION-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall updated TRAFODION-2983: Description: The following script reproduces the problem:

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

David Wayne Birdsall created TRAFODION-2983: --- Summary: Query fails with an internal error in the generator Key: TRAFODION-2983 URL: https://issues.apache.org/jira/browse/TRAFODION-2983

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

David Wayne Birdsall created TRAFODION-2977: --- Summary: Trafodion allows creating objects with longer key lengths than HBase supports Key: TRAFODION-2977 URL:

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

[ https://issues.apache.org/jira/browse/TRAFODION-2969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2969. - Resolution: Fixed Fix Version/s: 2.3 > Subquery with [first 1]

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

[ https://issues.apache.org/jira/browse/TRAFODION-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2966. - Resolution: Fixed Fix Version/s: 2.3 > New MDAM costing code

[jira] [Commented] (TRAFODION-2972) Follow up on supposed non-deterministic query in core/TEST002

[ https://issues.apache.org/jira/browse/TRAFODION-2972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16379089#comment-16379089 ] David Wayne Birdsall commented on TRAFODION-2972: - Thinking about the query a little

[jira] [Created] (TRAFODION-2972) Follow up on supposed non-deterministic query in core/TEST002

David Wayne Birdsall created TRAFODION-2972: --- Summary: Follow up on supposed non-deterministic query in core/TEST002 Key: TRAFODION-2972 URL: https://issues.apache.org/jira/browse/TRAFODION-2972

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

David Wayne Birdsall created TRAFODION-2969: --- Summary: Subquery with [first 1] in select list results in Normalizer internal error Key: TRAFODION-2969 URL:

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

[ https://issues.apache.org/jira/browse/TRAFODION-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2967. - Resolution: Fixed Fix Version/s: 2.3 > UPDATE STATISTICS

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

Project: Apache Trafodion Issue Type: Bug Components: sql-cmp Affects Versions: 2.3 Reporter: David Wayne Birdsall Assignee: David Wayne Birdsall Jira TRAFODION-2927 refactored the UPDATE STATISTICS logging logic to use the CommonLogger

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

David Wayne Birdsall created TRAFODION-2966: --- Summary: New MDAM costing code does not always respect CQS forcing MDAM Key: TRAFODION-2966 URL: https://issues.apache.org/jira/browse/TRAFODION-2966

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

David Wayne Birdsall created TRAFODION-2964: --- Summary: New MDAM costing code incorrectly assumes key column is always on the left Key: TRAFODION-2964 URL:

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

[ https://issues.apache.org/jira/browse/TRAFODION-2927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2927. - Resolution: Fixed Fix Version/s: 2.3 > Keep log information

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

[ https://issues.apache.org/jira/browse/TRAFODION-2927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16355899#comment-16355899 ] David Wayne Birdsall commented on TRAFODION-2927: - Note: I changed the default for CQD

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

David Wayne Birdsall created TRAFODION-2928: --- Summary: Add news articles about Trafodion to Trafodion web site Key: TRAFODION-2928 URL: https://issues.apache.org/jira/browse/TRAFODION-2928

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

David Wayne Birdsall created TRAFODION-2927: --- Summary: Keep log information for UPDATE STATISTICS in case of errors Key: TRAFODION-2927 URL: https://issues.apache.org/jira/browse/TRAFODION-2927

[jira] [Created] (TRAFODION-2924) Refactor FirstN handling for queries using output rowsets

David Wayne Birdsall created TRAFODION-2924: --- Summary: Refactor FirstN handling for queries using output rowsets Key: TRAFODION-2924 URL: https://issues.apache.org/jira/browse/TRAFODION-2924

[jira] [Resolved] (TRAFODION-2913) Tweak some MDAM-related heuristics

[ https://issues.apache.org/jira/browse/TRAFODION-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2913. - Resolution: Fixed Fix Version/s: 2.3 > Tweak some MDAM-related

[jira] [Updated] (TRAFODION-2913) Tweak some MDAM-related heuristics

[ https://issues.apache.org/jira/browse/TRAFODION-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall updated TRAFODION-2913: Attachment: MdamTests2.py.txt > Tweak some MDAM-related heuristics >

[jira] [Comment Edited] (TRAFODION-2913) Tweak some MDAM-related heuristics

[ https://issues.apache.org/jira/browse/TRAFODION-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16329117#comment-16329117 ] David Wayne Birdsall edited comment on TRAFODION-2913 at 1/17/18 6:07 PM:

[jira] [Updated] (TRAFODION-2913) Tweak some MDAM-related heuristics

[ https://issues.apache.org/jira/browse/TRAFODION-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall updated TRAFODION-2913: Description: While debugging a plan choice issue on a customer query,

[jira] [Created] (TRAFODION-2913) Tweak some MDAM-related heuristics

David Wayne Birdsall created TRAFODION-2913: --- Summary: Tweak some MDAM-related heuristics Key: TRAFODION-2913 URL: https://issues.apache.org/jira/browse/TRAFODION-2913 Project: Apache

[jira] [Resolved] (TRAFODION-2895) Update Messages Guide for range 1700-1999 and some other cleanups

[ https://issues.apache.org/jira/browse/TRAFODION-2895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2895. - Resolution: Fixed Fix Version/s: 2.3 > Update Messages Guide

[jira] [Created] (TRAFODION-2895) Update Messages Guide for range 1700-1999 and some other cleanups

David Wayne Birdsall created TRAFODION-2895: --- Summary: Update Messages Guide for range 1700-1999 and some other cleanups Key: TRAFODION-2895 URL: https://issues.apache.org/jira/browse/TRAFODION-2895

[jira] [Resolved] (TRAFODION-2880) Update Messages Guide for some messages in the range 1500-1599

[ https://issues.apache.org/jira/browse/TRAFODION-2880?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2880. - Resolution: Fixed Fix Version/s: 2.3 > Update Messages Guide

[jira] [Work started] (TRAFODION-2880) Update Messages Guide for some messages in the range 1500-1599

[ https://issues.apache.org/jira/browse/TRAFODION-2880?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2880 started by David Wayne Birdsall. --- > Update Messages Guide for some messages in the range

[jira] [Commented] (TRAFODION-2865) Update Messages Guide for some messages in the range 1300-1399

[ https://issues.apache.org/jira/browse/TRAFODION-2865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16312091#comment-16312091 ] David Wayne Birdsall commented on TRAFODION-2865: - The fix above actually takes care

[jira] [Resolved] (TRAFODION-2875) Fix some inaccurate comparisons in analyzeMessageGuide.py

[ https://issues.apache.org/jira/browse/TRAFODION-2875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2875. - Resolution: Fixed Fix Version/s: 2.3 > Fix some inaccurate

[jira] [Resolved] (TRAFODION-2865) Update Messages Guide for some messages in the range 1300-1399

[ https://issues.apache.org/jira/browse/TRAFODION-2865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2865. - Resolution: Fixed Fix Version/s: 2.3 > Update Messages Guide

[jira] [Created] (TRAFODION-2875) Fix some inaccurate comparisons in analyzeMessageGuide.py

David Wayne Birdsall created TRAFODION-2875: --- Summary: Fix some inaccurate comparisons in analyzeMessageGuide.py Key: TRAFODION-2875 URL: https://issues.apache.org/jira/browse/TRAFODION-2875

[jira] [Work started] (TRAFODION-2283) DDL Messages section in Messages Guide is out-of-date

[ https://issues.apache.org/jira/browse/TRAFODION-2283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2283 started by David Wayne Birdsall. --- > DDL Messages section in Messages Guide is

[jira] [Work started] (TRAFODION-2875) Fix some inaccurate comparisons in analyzeMessageGuide.py

[ https://issues.apache.org/jira/browse/TRAFODION-2875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2875 started by David Wayne Birdsall. --- > Fix some inaccurate comparisons in

[jira] [Work started] (TRAFODION-2865) Update Messages Guide for some messages in the range 1300-1399

[ https://issues.apache.org/jira/browse/TRAFODION-2865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2865 started by David Wayne Birdsall. --- > Update Messages Guide for some messages in the range

[jira] [Created] (TRAFODION-2865) Update Messages Guide for some messages in the range 1300-1399

David Wayne Birdsall created TRAFODION-2865: --- Summary: Update Messages Guide for some messages in the range 1300-1399 Key: TRAFODION-2865 URL: https://issues.apache.org/jira/browse/TRAFODION-2865

[jira] [Resolved] (TRAFODION-2852) Update Messages Guide for some messages in the range 1200-1299

[ https://issues.apache.org/jira/browse/TRAFODION-2852?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-2852. - Resolution: Fixed Fix Version/s: 2.3 > Update Messages Guide

<    1   2   3