Trafodion

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Miscellaneous minor changes

1) Revert a part of previous change to ComTdbHbaseAccess::displayRowId() for

SHOWPLAN. Each valid row id should have 2 bytes of length followed by the

value of id, if it is not missing or null. We need to treat the id as

binary value so we'll print each id byte as 2-digit hex value up to 20

bytes.

2) Remove the part of comments in sql/sqlcomp/DefineConstants.h that

requires not to delete and reuse existing constants. This is no longer

mandatory in Trafodion.

3) Enable NA memory overflow checking when running executor and qat

suites in debug flavor. This would increase the run time for these two

suites by about 10%.

Rework according to review comments. Explanations above changed too.

Change-Id: I854ec776fa5fb815c39677d469f8f46f18d51402

    • -20
    • +11
    /sql/comexe/ComTdbHbaseAccess.cpp
    • -0
    • +5
    /sql/regress/tools/runregr_executor.ksh
Merge "Lookup object UID for Sequence generator"

Merge "Changes to first review comments from Ruo-Yu"

Lookup object UID for Sequence generator

The NATable object representing a Sequence generator sometimes has

an object UID of 0 at the time privileges are checked, resulting

in failure to locate the object and denial of access. This change

looks up the UID if the corresponding NATable member variable is 0.

Change-Id: I889d2d823b8c0faca5318572250b45e07134b6cf

Merge "Fix for bug 1400963"

Merge "Changes to delay region split if txn present"

Merge "Give warning, not error, when Hadoop not found"

Updated Phoenix tests to cope with ANSI schemas

Updated Phoenix tests to do 'create schema' and 'drop schema' before and after

each test to cope with the new behavior with ANSI schemas. Up to now, schemas

in Trafodion do not need to be created or dropped, but the ANSI schema support

will change that. This update for Phoenix tests need to go in first before

the implement of ANSI schemas can go in, to ensure a smooth transition for

Jenkins builds. Since 'create schema' and 'drop schema' are just no-op right

now, Phoenix tests will continue to work for the existing builds even with this

update.

Change-Id: Ifa6902a122c78bdb899516cf8121295092cad0a9

Enable Phoenix T2 to work in local_hadoop environment

This will enable Phoenix T2 to work in developer's local_hadoop

environment. It makes the assumption that HBase/Hive lib

directory is at the same level as the HBase/Hive directory.

Change-Id: If2a2c84dca1d7cd8fc17da0ad56485c8bfdb9e74

Merge "TMUDF C++ compiler interface, part of log-reading TMUDF"

    • -0
    • +331
    /sql/optimizer/OptPhysRelExpr.cpp
Fixes and removal of obsolete code.

-- LP 1400556 'get tables in schema' is not supported on external

hbase tables. An error is now returned.

-- LP 1400553 Insert into external hbase tables in _ROW_ format must use

column_create function and VALUES clause to create rows.

An error is returned otherwise.

-- a bug with that prevented a boundary case when sequence increment value

was one less than largeint max has been fixed.

-- error message to indicate what options can be used during alter sequence

has been updated

-- create table as select stmt now returns an error if running within a user

transaction. This is the same behavior as other DDL operations.

This will be

removed once we have transaction support for DDL stmts.

-- create table as select now uses non-transactional 'upsert using load' to

populate target table instead of transactional 'insert...select' stmt.

-- hive/test020 has been enabled. This tests for access to ORC files.

-- obsolete sidetree insert and NVT user load code has been removed.

Change-Id: I14d321deaa52321777acd1d8ca55420f1e973367

    • -2800
    • +367
    /sql/executor/ExExeUtilLoad.cpp
    • -369
    • +16
    /sql/generator/GenRelExeUtil.cpp
    • -126
    • +76
    /sql/optimizer/BindRelExpr.cpp
  1. … 17 more files in changeset.
Changes to delay region split if txn present

Region splits will be delayed until no more transactions

are in the active or pending list of the region. Split work

is being checked-in separately from the balance changes.

Change-Id: I800b06711d14f019d7f1a23d1c3d123e7aa805ff

Give warning, not error, when Hadoop not found

When Trafodion has just been untarred from a product file obtained from

downloads.trafodion.org, and no Hadoop is found, give a warning instead of

an error and suggest that install_local_hadoop may be needed.

In that situation, do not put 4 colons at front of CLASSPATH.

Change-Id: If207b5999df37d3139015ff88bc4bde4686f7919

Fix node down processing and stale branch

Change-Id: Idb4e8df05c99a349118942725fefac70a8e1a318

Removing confusing typo in trafodion_mods

trafodion_mods stated it was only for cloudera.

Change-Id: Ic78e8f2022b0b96c883e20b1cde596ec2f386cfb

Fix for bug 1400963

OEW test with T2 multithread cored at NAList<CollationDB*>::removeCounted

User collation code had static member variable that was cauing this issue.

User collation feature is not supported and hence removed part of this featu

and reworked the rest to make it thread safe.

Change-Id: I4aec79ace3e331692549809cee81502a9102993d

Add support for DCS and phoenix_tests to local_hadoop

By default it gets the latest DCS from github, but env variables

can be used to over-ride and get DCS from another URL or local

workspace.

Includes a convenience script to run phoenix tests. Phoenix tests

only works with T4 driver in local_hadoop environment so far.

Change-Id: I2574ab637bd7db23b42e4d7eb67afc9ad27c7bb6

    • -2
    • +169
    /sqf/sql/scripts/install_local_hadoop
SHOWPLAN related changes

Reworked the fix for bug 1392522 - mxosrvr core dumped doing showplan

(with N.E. enabled), plus other related code changes.

1) The native code (also known as native expression), if generated, is

stored in the expression's constant area. SHOWPLAN will dump the native

code in the assembly format. The display can be disabled by CQD

PCODE_NE_IN_SHOWPLAN to "OFF". It is "ON" by default. This part had been

reviewed by Jim Capps and Mike Hanlon.

2) Add several SHOWPLAN statements in core/TEST019 without logging the

output. This is to ensure no core generated when getting executor

operator (TDBs) info via SHOWPLAN.

3) A temporary fix to ComTdbHbaseAccess::displayRowId(). The current way

of retrieving begin or end row IDs from the HbaseScanRows for SHOWPLAN

does not match with the way those row IDs are generated (see

HbaseAccess::genListsOfRows), causing core dumps in some cases.

Change-Id: Id33e8c854452c03e15c4bd21f668f123180d9471

    • -26
    • +31
    /sql/exp/ExpPCodeOptsNativeExpr.cpp
Merge "Avoiding Thread.sleep() when thread is exiting"

Merge "Indentation fix - recovery node down message"

Merge "NJ costing changes."

Avoiding Thread.sleep() when thread is exiting

Change-Id: Idf71e71d176395258fe1297dcd366b586d5d40fd

Indentation fix - recovery node down message

Fixed indentation on method to send node ID on node down

event for recovery.

Change-Id: I86dd1cde53277b5b6415170ef263c0c91c16d558

TMUDF C++ compiler interface, part of log-reading TMUDF

This is the infrastructure for a new C++ interface for TMUDFs

(table-mapping UDFs). It is used by a new log-reading TMUDF that

is not yet complete, but should be finished in the next few days.

See blueprint cmp-tmudf-compile-time-interface for more info.

Change-Id: I5a74e461462313b6d9722ac0deb21cd16c4b02ce

    • -0
    • +29
    /sql/nskgmake/udr_predef/Makefile
    • -119
    • +47
    /sql/optimizer/BindRelExpr.cpp
  1. … 41 more files in changeset.
Hybrid Query Cache feature implemented.

The Hybrid Query Cache (HQC) is an enhancement of existing Query Cache,

which is trying to find match queries in existing query cache at an earlier point,

i.e. just after parser and before binder so as to avoid binder overhead if there's a hit.

Two virutal table ISPs are added to show stats of Hybrid Query Cache.

Add control of ISP to run locally or remotely.

Changes after reviewers' comments.

Fixup errors in SqlciErrors.txt that cause core/TEST014 failure.

Fix minor issues about (hybrid)query cache ISP.

Add HQC virtual table ISP tests to compGeneral/TEST042.

Change-Id: Ib5be56e04990639153747255834b30fc9c3f3829

    • -5
    • +124
    /sql/executor/ex_stored_proc.cpp
  1. … 26 more files in changeset.
fix compatibility issue with .netframework 4.0

Change-Id: I3fa37c858f63c40dfab272e5acb19c4f6ccaf6ce

Remove deprecated code

Change-Id: I5e054ea76ea1e29d526be55c72acde959edd73c4

    • -3
    • +3
    /sqf/src/seatrans/tm/hbasetmlib2/Makefile
Merge "Remove filler / fix RpcClient$CallTimeoutException"

Fix for several security/QI bugs

Amended: CmpSeabaseDDLtable to dynamically allocate the qi structure and

updated TEST122 to include a test for QI processing after a drop index

Fix for bug 1396774 & bug 1396746:

When indexes are dropped as part of drop table, cache entries are not

being removed correctly from the compiler process(es)

Fix for BY <owner> create table bug:

When using the undocumented BY <owner> clause for CREATE TABLE and an

unregistered user name is specified, the object owner is incorrectly

set to 0. Once 0, a subsequent drop table fails without giving an error

MANAGE_LIBRARY support:

Require a user to be assigned the MANAGE_LIBRARY component privilege in

order to create a library. This is in addition to other privileges.

Change-Id: I0379b1ab9cd26c334c5a4343577aec27a8d43401

    • -4
    • +115
    /sql/regress/executor/EXPECTED122
    • -0
    • +20
    /sql/sqlcomp/CmpSeabaseDDLroutine.cpp
    • -7
    • +47
    /sql/sqlcomp/CmpSeabaseDDLtable.cpp
Redelivery after merge of HA for tracing and new exception handling

Change-Id: I6064ba7305ad05ed979fd2afd5405864c5d5f347