Clone Tools
Constraints: committers
Constraints: files
Constraints: dates
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.
[TRAFODION-2952] large amount of data will cause error in sequence generating

  1. … 8 more files in changeset.
fixed checktest failure due to incorrect strcpy.

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.


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.
Merge branch 'master' of https://github.com/apache/trafodion into TRAFODION-3147

  1. … 7 more files in changeset.
[TRAFODION-3147] support sys_guid function

  1. … 7 more files in changeset.
modified: core/sql/bin/SqlciErrors.txt modified: core/sql/exp/ExpErrorEnums.h modified: core/sql/exp/exp_function.cpp modified: core/sql/optimizer/SynthType.cpp modified: core/sql/regress/core/EXPECTED038.LINUX modified: docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc modified: docs/messages_guide/src/asciidoc/_chapters/executor_msgs.adoc

  1. … 6 more files in changeset.
modified: core/sql/bin/SqlciErrors.txt modified: core/sql/common/OperTypeEnum.h modified: core/sql/exp/ExpPackDefs.cpp modified: core/sql/exp/exp_clause.cpp modified: core/sql/exp/exp_clause.h modified: core/sql/exp/exp_function.cpp modified: core/sql/exp/exp_function.h modified: core/sql/generator/GenItemFunc.cpp modified: core/sql/optimizer/ItemExpr.cpp modified: core/sql/optimizer/ItemFunc.h modified: core/sql/optimizer/SynthType.cpp modified: core/sql/parser/ParKeyWords.cpp modified: core/sql/parser/sqlparser.y modified: core/sql/regress/core/EXPECTED038.LINUX modified: core/sql/regress/core/TEST038 modified: docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc

  1. … 15 more files in changeset.
tochar enhancement

  1. … 5 more files in changeset.
fix code error

add nonreserved_word and tests

  1. … 4 more files in changeset.
trafodion-3118 Improve on parts of EXTRACT

  1. … 10 more files in changeset.
Merge [TRAFODION-3042] RAND() function is not always random PR-1539

[TRAFODION-3042] Addressed review comment

[TRAFODION-3042] Switch to nanosecond-resolution time

Getting ready for the day where we can do two RAND() calls

in a microsecond - hopefully soon :-)

[TRAFODION-3042] RAND() function is not always random

When called without a seed, we use a seed based on the

system timestamp. The random generator we use generates similar

output values for seeds that are close together. Adding another

randomization step to avoid that.

[TRAFODION 3024] function lower() return null for varchar column when pcode is disabled

Changes to report the error -1571 and -1572 correctly.

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.


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


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


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


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

during backpatching.


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

in some cases. That has been fixed.


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


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


-- 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.
[TRAFODION-3006] unix_timestamp runtime core dump issue

[TRAFODION-2998] sleep execution code cannot build on CentOS 7

[TRAFODION-2954] add MySQL function unix_timestamp,uuid,sleep

  1. … 11 more files in changeset.
fix an issue, add regress tests

  1. … 3 more files in changeset.
modify for the review comments to strictly check the input to unix_timestamp

[TRAFODION-2157] fix various issues

  1. … 6 more files in changeset.
Merge branch 'master' of git://git.apache.org/trafodion into TRAFODION-2157

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

  1. … 15 more files in changeset.
[TRAFODION-2772] - retrieve a value from Json string got an error: using array to replace dynamic memory

[TRAFODION-2772] - retrieve a value from Json string got an error: release memory to heap

[TRAFODION-2772] - retrieve a value from Json string got an error