BindItemExpr.cpp

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

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

Spec attached to jira.

new test regress/seabase/TEST004 added.

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

  1. … 4 more files 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. … 13 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. … 12 more files in changeset.
tochar enhancement

  1. … 5 more files in changeset.
merge [TRAFODION 3091] revert the change provisionally for test case issue

[TRAFODION 3091] revert the change provisionally for test case issue.

  1. … 1 more file in changeset.
Merge [TRAFODION 3091] Unnamed Dynamic parameter doesn't work in WITH state… PR-1585

[TRAFODION 3091] Unnamed Dynamic parameter doesn't work in WITH statement

  1. … 1 more file in changeset.
[TRAFODION-3071] Add missing binder checks for DATEDIFF etc. + other fixes

  1. … 9 more files in changeset.
Merge [TRAFODION-3018] PR 1506 Fix issue with UPPER on an UPSHIFT column

PR-1507 Changes after PR 1502 review, plus jenkins compGeneral crash fix

  1. … 1 more file in changeset.
Merge remote branch 'origin/master' into ansharma_trafixes_deliver2_br

Conflicts:

core/sql/executor/ExExeUtilGet.cpp

  1. … 1 more file in changeset.
  1. … 11 more files in changeset.
review changes from PR 1502, plus jenkins compGeneral crash fix

  1. … 4 more files in changeset.
Merge remote branch 'origin/pr/1503/head' into merge_1503

  1. … 8 more files in changeset.
[TRAFODION-3018] Fix issue with UPPER on an UPSHIFT column

various fixes

-- JIRA 2980 support for INSTR function.

INSTR(source_string, pattern, startPos, occurrence)

Search for pattern in source_string.

Start at startPos'th character. Optional, default 1

Return occurrence'th occurrence. Optional, default 1

(exp/exp_function.cpp/h, exp/ExpPCodeClauseGen.cpp,

generator/GenItemFunc.cpp, optimizer/BindItemExpr.cpp, ItemExpr.cpp,

optimizer/ItemFunc.h, SynthType.cpp, parser/sqlparser.y)

-- hivemd returns precision, scale, display_datatype

(comexe/ComTdbExeUtil.h, common/BaseTypes.cpp,NAType.cpp/h,

executor/ExExeUtilGet.cpp, ExExeUtil.h)

-- hive decimal type is treated as sql NUMERIC for performance.

(common/NAType.cpp)

-- hive select from hivemd with prepare and multiple executes work

(executor/ExExeUtilGet.cpp)

-- fix for crash in sql buffer pool when allocating large size rows.

(executor/sql_buffer.cpp)

-- SIGN(op) now returns error if op is not numeric

(BindItemExpr.cpp)

-- strings of length zero are no longer cached. Caching them causes problem

during backpatching.

(optimizer/ItemCache.cpp)

--- compile time predicates on constants were not being created correctly

in some cases. That has been fixed.

(ValueDesc.cpp)

-- trim now supported on scaled numeric, float and bignum datatypes

(BindItemExpr.cpp)

-- CASE is now supported on scaled numerics, float, bignum

(BindItemExpr.cpp)

-- char_length is now supported on numerics

(ItemFunc.h, BindItemExpr.cpp)

-- DAYOFMONTH now allowed only on datetime datatypes

(common/OperTypeEnum.h, sqlparser.y, BindItemExpr.cpp, ItemExpr.cpp)

-- TO_TIME now allowed only on 'datetime with time' or character datatypes.

(BindItemExpr.cpp, bin/SqlciErrors.txt)

-- updated expected file for compGeneral/test042

  1. … 31 more files in changeset.
Performance changes for LOB and increasing limit for larger varchars/bobs to use with batch input.

  1. … 17 more files in changeset.
update the regression test and various fixes

  1. … 6 more files in changeset.
[TRAFODION-2954] add MySQL function unix_timestamp,uuid,sleep

  1. … 11 more files in changeset.
make the uuid evaluate once per statement

  1. … 5 more files in changeset.
[TRAFODION-2157] add MySQL function unix_timestamp,uuid,sleep

  1. … 15 more files in changeset.
Merge [TRAFODION-2886] PR-1380 fix the nullpointer error scanned by TScanCode

  1. … 4 more files in changeset.
[TRAFODION-2904] optionally add leading space when get a number column to display

[TRAFODION-2904] optionally add leading space when get a number column to display

fix the nullpointer error scaned by TScanCode

  1. … 20 more files in changeset.
[TRAFODION-2888] Streamline setjmp/longjmp concepts in Trafodion

First set of changes to streamline setjmp/longjmp.

a) Removed the setjmp in heap management within Trafodion.

b) Removed obsolete code related to No-wait operation concepts in SQL

  1. … 30 more files in changeset.
[TRAFODION-2768] Make Trafodion code base to compile in RH7

  1. … 126 more files in changeset.