GenRelUpdate.cpp

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Changes to update queue sizes and add dynamic queue resizing to some missing operators. (cherry picked from commit f26c0f448a6adf5cdefddc74c4ba840b030e8cf5)

Conflicts:

core/sql/generator/Generator.cpp

core/sql/generator/Generator.h

core/sql/sqlcomp/nadefaults.cpp

  1. … 11 more files in changeset.
Fixes for TRAFODION-3107, TRAFODION-3092, TRAFODION-3004

  1. … 11 more files in changeset.
[TRAFODION-2977] Fix issues with maximum key length detection

  1. … 4 more files in changeset.
[TRAFODION-2854] Load encounter Operating system error 201

When load returns an error during insert, the row is reconstructed

to log in the same format as the source. During the reconstruction process

a wrong tuple format was used.

[TRAFODION-2775] Insert does not raise duplicate row error for hbase format table with defaulted first column

There was a problem with column being checked during CheckAndPut call for such tables. We were always checking the first column in the row, which may not have existed in the previous version of this rowid. Please see JIRA for a complete explanation.

  1. … 9 more files in changeset.
Rework some comments

Reworks based on Hans review comments

  1. … 3 more files in changeset.
Fix bug noticed on pull request review

[TRAFODION-1610][TRAFODION-2630] Generate constr exprs on update operators

  1. … 5 more files in changeset.
[TRAFODION-2727] Memory leak in the compiler part of the code in Trafodion

Compiler objects were refactored to use the heap infrastructure to ensure

that it is accounted and allocated within the trafodion memory management.

The commonly used NAType and derived classes are mostly created via heap,

but the heap was not passed in the constructor. The embedded objects

used the system heap though the container object is allocated in the compiler

heap. This could result in memory leak when the container object is

destroyed.

  1. … 63 more files in changeset.
[TRAFODION-2586] UPSERT USING LOAD running slower than UPSERT with transactions disabled

Showplan indicates problem is likely in initial queue length. Particularly for rowset upserts that are used for trickle loading, the number of rows in each statement si not sufficient for the queue resize to kick in.

Fixed reviews comments. Reworked "if" statement in method isUpsertThatNeedsTransformation. Added test cases to distinguish the merge transformation from the new transformation in cases with omitted columns.

  1. … 4 more files in changeset.
Merge remote branch 'origin/master' into vsbb_upsert

  1. … 2 more files in changeset.
Changes to remove restriction to use vsbb for upserts on base table.

  1. … 2 more files in changeset.
[TRAFODION-2438] Unnecessary and sometimes wrong delete during upsert/merge with IM

This change is done by Hans. Design by Selva.

Please see JIRA for an explanation.

  1. … 15 more files in changeset.
TRAFODION-1586 Add support for external Traf tables mappedd to HBase tables

This is the initial support for HBase mapped tables.

A doc for external manuals will be added later.

regress/seabase/TEST022 contains various testcases.

  1. … 77 more files in changeset.
jira [trafodion-2290] and few other bug fixes

-- trafodion-2290: pcode support for added columns on aligned tables

-- lob conversion error is reported instead of crash

-- alter table rename is restricted to not run under a user xn

-- error during alter table rename are handled correctly

-- error during alter/drop cols on aligned tables are handled correctly.

-- aligned format drop column with delimited names are handled correctly

-- rollup grouping now work correctly on expressions and renamed columns

  1. … 23 more files in changeset.
Post merge commit. All files here relate to NAList

  1. … 64 more files in changeset.
[TRAFODION-2247] upsert on altered aligned format table with missing columns inserts incorrect values

While generating mergeInsertExpr or updateExpr, the added columns were not considered. This resulted

in incorrect relative offset value in the expressions in case of aligned row format and the row got

corrupted.

  1. … 4 more files in changeset.
jira TRAFIDION-1435 SQL support for region transactions

This checkin is to add support for sql compiler/executor support

for dtm region transactions.

cqd traf_use_region_xn 'ON' enables it.

Off by default for now until dtm support is complete and tested.

Explain (full and short) will also show if region transactions

are being used.

core/test116 has been enhanced with additional tests

  1. … 19 more files in changeset.
Merge remote branch 'origin/master' into ddlxns_br

[TRAFODION-1918] Remove auto flush concept in Trafodion

The auto flush is on by default in insertRows method. But insertRows was

incorrectly called with the wrong parameter. In fixing this issue, it was

observed that auto flush is deprecated in HBase 1.x. It is also incorrect

to disable auto flush in Trafodion. Hence removed the code related to

auto flush, flush table and flush all tables in Trafodion.

All these are dormant code in Trafodion.

Also disabled executor/TEST106 for now because it seems to cause a hang

at the time of drop table.

  1. … 13 more files in changeset.
Merge remote branch 'origin/master' into ddlxns_br

  1. … 1 more file in changeset.
commit #1

  1. … 25 more files in changeset.
The CQD TRAF_UPSERT_WITH_INSERT_DEFAULT_SEMANTICS is replaced with TRAF_UPSERT_MODE. This CQD takes 3 values

MERGE - If the row exists, use the old values for omitted columns. This

doesn't necessarily mean that MERGE command is used

REPLACE - Always replace the column with default values for omitted columns

OPTIMAL - Chooses MERGE like concept for non-aligned format table

REPLACE for aligned format table

MERGE is the default.

  1. … 5 more files in changeset.
update

  1. … 298 more files in changeset.
[TRAFODION-1896] CQD TRAF_UPSERT_WITH_INSERT_DEFAULT_SEMANTICS for non-aligned format

This CQD is now honored for non-aligned format by replacing the column

value with default values for omitted columns and put into hbase table.

  1. … 3 more files in changeset.
Merge remote branch 'origin/master' into lob_gc_work

Conflicts:

core/sql/sqlcomp/CmpSeabaseDDLtable.cpp

  1. … 11 more files in changeset.
[TRAFODION-1700] Upsert with omitted default value columns leave the aligned format table in corrupted state. [TRAFODION-1847] Upsert with omitted timestamp columns having current_timestamp as default in a non-aligned format table returns wrong value for this column

For TRAFODION-1847, the upsert is transformed into merge.

For TRAFODION-1700, the upsert is transformed into merge when the CQD

TRAF_UPSERT_WITH_INSERT_DEFAULT_SEMANTICS is set to OFF. By default this CQD is

set to OFF. When this CQD is ON, the upsert will add a new row with the omitted

columns filled with default values always.

  1. … 12 more files in changeset.
Anoop's delete expresssion change

  1. … 8 more files in changeset.