Trafodion

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Merge [TRAFODION-2084] PR-555 Handling of invalid data inserts into hive table

Added sqf/DISCLAIMER to the .gitignore file also.

Added DISCLAIMER file to sqf/.gitignore file since this file is not tracked by git. Also reverted last changed, .rat-excludes does not need to be changed to support DISCLAIMER file. The rat tool has support to handle these types of mandatory files.

change to validate hardcoded nadefault values

Values specified in hardcoded defaultDefaults array were not

being validated. As a result, some invalid values were being

set up. All values have been corrected and a validation step

for hardcoded defaults has been added. This is done during initial

set up.

    • -26
    • +26
    /core/sql/sqlcomp/nadefaults.cpp
Added DISCLAIMER filel to rat-excludes, does not have an Apache header

Fixes for TRAFODION-2068

TRAFODION-2068: Missing DISCLAIMER files for release package

Added DISCLAIMER file to servers package.

[TRAFODION-2069] Fixed sqcheck to use TRAF_EXCLUDE_LIST when calculating counts Code review fix.

Fixes for TRAFODION-2068

TRAFODION-2068: Missing DISCLAIMER files for release package

Added DISCLAIMER file to servers package.

JIRA TRAFODION-2084 Handling of invalid data inserts into hive tables

cqd hive_insert_error_mode '<val>' has been added to control

insert behavior.

if 0, datatype error check is not done during inserts into hive tables.

Invalid values may get inserted.

This is the behavior prior to this JIRA fix.

if 1, error check done, row is not inserted if conversion error.

Insertion stops. This is new default behavior.

if 2, error check done, row is not inserted if conversion error.

Insertion continues with next row

if 3, null inserted if conversion error.

Insertion processing continues. This is hive behavior.

    • -1
    • +7
    /core/sql/comexe/ComTdbFastTransport.h
    • -3
    • +13
    /core/sql/executor/ExFastTransport.cpp
    • -2
    • +72
    /core/sql/generator/GenFastTransport.cpp
    • -10
    • +167
    /core/sql/regress/hive/EXPECTED005
    • -0
    • +7
    /core/sql/regress/hive/TEST005_a.hive.sql
    • -0
    • +15
    /core/sql/sqlcomp/DefaultValidator.cpp
[TRAFODION-2069] Fixed sqcheck to use TRAF_EXCLUDE_LIST when calculating counts

Merge remote branch 'origin/master' into ansharma_uint64_br

    • -51
    • +40
    /core/sql/generator/GenPreCode.cpp
    • -15
    • +110
    /core/sql/optimizer/NATable.cpp
Merge [TRAFODION-2072] PR-552 Handling long varchars plus couple more changes

    • -52
    • +72
    /core/sql/sqlcomp/CmpSeabaseDDL.h
    • -5
    • +22
    /core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp
    • -8
    • +127
    /core/sql/sqlcomp/CmpSeabaseDDLtable.cpp
Merge [TRAFODION-2068] [TRAFODION-2082] PR 554 License and disclaimer files

Fixes for TRAFODION-2068 and TRAFODION-2082

TRAFODION-2068: Missing DISCLAIMER files for release package

TRAFODION-2082: BSD-4 license for swsprintf and swscanf unclear

Added DISCLAIMER file to clients and installer packages

Updated BSD license text in swsprintf.cpp and swscanf.cpp

Merge [TRAFODION-1698] PR 551 Add ODBC SQLForeignKeys API support

Merge [TRAFODION-2074] PR 550 Create index transaction changes

    • -40
    • +43
    /core/sql/sqlcomp/CmpSeabaseDDLindex.cpp
Merge [TRAFODION-1129] PR 549 Remove current catalog/schema assert

Merge [TRAFODION-1745] Show more info on TRANSLATE errors

[TRAFODION-2074] Create index should avoid populating the index within a transaction

    • -1
    • +8
    /core/sql/sqlcomp/CmpSeabaseDDLindex.cpp
Merge branch 'master' of github.com:apache/incubator-trafodion into index_issue

Conflicts:

core/sql/bin/SqlciErrors.txt

    • -48
    • +40
    /core/sql/generator/GenPreCode.cpp
    • -20
    • +56
    /core/sql/regress/core/EXPECTED116
    • -3
    • +59
    /core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp
    • -26
    • +24
    /core/sql/sqlcomp/CmpSeabaseDDLindex.cpp
Merge remote branch 'origin/master' into ansharma_uint64_br

JIRA TRAFODION-2072 plus few more

-- long varchars (> 32K) are handled for traf (regular and aligned)

and hive tables

-- showddl for hive tables shows traf and hive definitions

-- traf external tables can optionally take columns attrs that would

overwrite corresponding hive col attrs

-- metadata is updated with info no whether col attrs were specified

-- 'repeat' function can optionally take a max length parameter

-- error is returned if an external table is created for non-hive

-- tests added to regress/seabase/TEST031 and hive/TEST009

    • -12
    • +13
    /core/sql/optimizer/BindRelExpr.cpp
  1. … 30 more files in changeset.
Merge [TRAFODION-2039] PR 530 Add support for ALTER LIBRARY FILE '<file-name>'

[TRAFODION-1698]ODBC: trafodion doesn't support API SQLForeignKeys

[TRAFODION-2074] Create index should avoid populating the index within a transaction

Fix for regression failure core/TEST116

Fix to return the error 8034 when an inconsistency due to missing column values

is detected at the time of fetching the row.

    • -0
    • +26
    /core/sql/executor/ExHbaseAccess.cpp
support for largeint unsigned: commit #1

  1. … 13 more files in changeset.
[TRAFODION-2074] Create index should avoid populating the index within the transaction

Fix for failure in core/TEST116

    • -27
    • +29
    /core/sql/regress/core/EXPECTED116
[TRAFODION-2074] Create index should avoid populating the index within a transaction Create index is now done in multiple transactions when there is no active transaction. 1) creating the index table in transaction 1. 2) populate the index without any transaction. If it fails, cleanup the index table. 3) If it succeeds complete the rest of the index creation in transaction 2. 4) If there are any failures, cleanup the index table.

When there is an active transaction while the create index is issued, then

all the above steps are done within the user transaction.

Also did some cleanup to return proper errors instead of dumping core

    • -51
    • +39
    /core/sql/generator/GenPreCode.cpp
    • -18
    • +72
    /core/sql/regress/core/EXPECTED116
    • -3
    • +6
    /core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp
    • -14
    • +12
    /core/sql/sqlcomp/CmpSeabaseDDLindex.cpp
    • -10
    • +13
    /core/sql/sqlcomp/CmpSeabaseDDLtable.cpp
Merge [TRAFODION-2022] PR-548 Some more changes related to hive truncate

Turning off LDAP by default - it was inadvertantly set to Y.