optimizer

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[TRAFODION-3300] Fix overflow issues with extreme big nums + ROUND

  1. … 14 more files in changeset.
[TRAFODION-3296] Fix handling of [first n] + ORDER BY subqueries

  1. … 6 more files in changeset.
[TRAFODION-3280] Reduce path length in Trafodion for improved performance and scalability

There are many places in Trafodion code getenv is called repeatedly. Cleaned up code so that

repeated getenv calls are avoided during prepare and execute operations.

  1. … 8 more files in changeset.
jira TRAFODION-3157 Add support for BINARY/VARBINARY datatype

Spec attached to jira.

new test regress/seabase/TEST004 added.

  1. … 77 more files in changeset.
Fix buffer overrun issue

  1. … 1 more file in changeset.
[TRAFODION-3265] INSERT values to VARCHAR column of UTF8 charset can be extremely slow

  1. … 4 more files in changeset.
Library manager fixes and LOB alter fix

  1. … 8 more files in changeset.
modified: core/sql/optimizer/ItemFunc.h

[TRAFODION-3234] Refactor hive meta calls

Hive similarity check was detecting if there is a change in the hive

directory timestamp only. It has been changed to detect the DDL changes too.

Cleaned up code further and removed all the unwanted code.

  1. … 15 more files in changeset.
[TRAFODION-3234] Refactor hive meta calls to be less resource intensive to support hive partitions if needed

Removed some more unneeded data modification timestamp check code

  1. … 1 more file in changeset.
[TRAFODION-3234] Refactor hive meta calls to be less resource intensive to support hive partitions if needed

Fixes for hive/TEST005 failure.

This also made some of the earlier failed test cases in this test suite to return correct results.

Data modification check was unnecessarily done in the scan operator. This has been removed.

  1. … 4 more files in changeset.
[TRAFODION-3234] Refactor hive meta calls to be less resource intensive to support hive partitions if needed

There was yet another method that called HiveMetaStoreClient.listPartitions API. This method is

called whenever the hive table entry is picked from the NATable cache.

Replaced listParitions call with Trafodion specific HDFSClient.getHiveTableModificationTS call

that is less expensive.

HiveMetaStoreClient is now made as ThreadLocal variable to ensure that HiveMetaStoreClient methods

can be invoked in a thread safe manner.

  1. … 5 more files in changeset.
[TRAFODION-3234] Add support for hive partitioned tables

Refactored the interaction with hive metastore to use the efficient APIs to obtain the necessary

information to construct the hive table descriptors. This refactoring is expected to reduce the

memory requirements, efficient and high performing even when there are thousands of partitions.

  1. … 13 more files in changeset.
Fixes for regression tests and expected files

  1. … 5 more files in changeset.
Merge remote branch 'origin/pr/1721/head' into merge_1721

  1. … 10 more files in changeset.
Merge [TRAFODION-3218] pr 1723 user still has privilege after user's role revoked

  1. … 2 more files in changeset.
iChanges based on review comments

  1. … 14 more files in changeset.
[TRAFODION-3220] Executor GUI

Adding the ability to display query execution with the "display"

command in Trafodion (sqlci only, requires an X Windows display,

just as the compiler GUI does).

  1. … 42 more files in changeset.
TRAFODION - 3218 User still has privilege after user's role has been revoked ...

Partial support for column level privileges with QI support for:

column select

column insert

column references

column update

Also, as part of this, updated privilege code in a couple of areas:

Changed object caching code in NATable and NARoutine to store all privileges

assigned to the object when the object is cached (privDescs_). During the load

operation, the code creates bitmaps (privInfo_) for the current user. Privilege

checks are performed against the user bitmaps (privInfo_). This is in

anticipation for some performance updates when connecting to Trafodion (mxosrvr)

with different users.

Change getRoleList to include the roleID and the granteeID that granted the

privilege. The grantee can be a user or a role.

When a privilege is revoked from a role, send QI keys for every user that has

been granted to role.

  1. … 35 more files in changeset.
Fixees to support stroring Udr libraries s Blobs.

  1. … 43 more files in changeset.
[Trafodion 3202] Case when used in the sorting sequence of paging functions. execution error

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.
[TRAFODION-3110] Refactor LOB access to use the new implementation of HdfsClient

LOB: Extract lobtofile() to a hdfs file returns 8442 error

Implemented the missing code to support this functionality via the new

implementation.

  1. … 8 more files in changeset.
remove that unused code

[TRAFODION-1881] A better way to solve TRAFODION-1858

  1. … 3 more files in changeset.
PR-1677 TRAFODION-3146 Support ANSI OVERLAY function

  1. … 1 more file in changeset.
Merge [TRAFODION-3155] PR 1658 Implement OVERLAPS predicate

  1. … 1 more file in changeset.
TRAFODION-3146 Support ANSI OVERLAY function

OVERLAY modifies a source string by replacing a given

substring of the string, which is specified by a given numeric starting

position and a given numeric length, with a replacement string).

When the length of the substring is zero, nothing is removed

from the source string and the string returned by the function is the

result of inserting the replacement string into the source string at the

starting position.

STUFF is syntactic variation of OVERLAY.

Example:

overlay ('source original string' placing 'modified ' from 8 for 9)

stuff ('source original string', 8, 9, 'modified ')

will return:

'source modified string'

overlay ('source original string' placing 'modified ' from 8 for 0)

will return:

'source modified original string'

  1. … 10 more files in changeset.
modified: core/sql/generator/GenPreCode.cpp modified: core/sql/optimizer/ItemExpr.cpp modified: core/sql/regress/qat/eqatdml03

  1. … 2 more files in changeset.
modified: core/sql/generator/GenPreCode.cpp modified: core/sql/optimizer/BindItemExpr.cpp modified: core/sql/optimizer/ItemExpr.cpp modified: core/sql/optimizer/ItemFunc.h modified: core/sql/optimizer/SynthType.cpp modified: core/sql/parser/sqlparser.y modified: core/sql/regress/qat/eqatddl06 modified: core/sql/regress/qat/eqatddl09 modified: core/sql/regress/qat/eqatdml03 modified: core/sql/regress/qat/qatddl00 modified: core/sql/regress/qat/qatddl06 modified: core/sql/regress/qat/qatddl09 modified: core/sql/regress/qat/qatdml03

  1. … 9 more files in changeset.