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.
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/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.
[TRAFODION-3097] At times the query involving sequence function fail and dumps core

BiArithmetic sum expression clause in Sequence expression can't have

pcode generated like an arithmetic expression that supports augmented

assignment operation such as a += b.

  1. … 8 more files in changeset.
[TRAFODION-2157] fix various issues

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

  1. … 15 more files in changeset.
Remove commented out lines.

TRAFODION-2873. Fix for avoiding cores during expression eval for inserts into LOB tables. The fix involves cleaning up the LOBGlibals and eliminating unneeded datamemebers and keeping only the ExLobGlobals members. Also cleaned up all LobLoad related code since it is obsolete and worked only with DP2.



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

  1. … 126 more files in changeset.
TRAFODION-2731 CodeCleanup: Phase 4. Remove legacy/obsolete pragmas

  1. … 392 more files in changeset.
Merge branch 'master' of git://git.apache.org/incubator-trafodion into master_stats_core_issue



  1. … 21 more files in changeset.
[TRAFODION-2754] Get statistics cores sqlci or mxosrvr at str_sprintf()

Switched str_sprinf to use the standard sprintf function to ensure

that the format specification and the passed in parameters are consistent

  1. … 65 more files in changeset.
lcov: commit #1

  1. … 333 more files in changeset.
TRAFODION-2731 CodeCleanup: Remove obsolete, legacy and unused code

This phase handles the following:

-- removal of code that dealt with:

-- mpalias, NSK, MP, mploc, resource fork, rfork

-- ARLIB, DISK, VOLUME, PFS, compiler version info

-- interpretasrow/IAR, AuditImage, ExtractColumns functions

-- ARKCMP_SINGLE_PROCESS and oneProcess()

-- recompControl, remoteDefaults, rtdu, module

-- latebind thru nsk defines, guardian names, nametype nsk

-- SHADOW implementation


-- older sqlcat ReadTableDef


-- internal cli methods no longer used by any caller

Code within the following defines is removed if it is obsolete

or the define itself is removed if that feature is always on:

-- removed NA_EIDPROC

-- removed SQLEXP_LIB_FUNC

-- removed NA_CMPDLL


-- removed SQ_NEW_PHANDLE

-- removed __EID

-- removed ARKFS_OPEN

-- removed STAND_ALONE

-- removed __TANDEM

-- removed NA_C89

-- removed NA_NSK


-- removed SQLCLI_LIB_FUNC

-- removed CLI_PRIV_SRL

-- removed PRIV_SRL

-- removed NA_LINUX

-- removed NA_HSC_LINUX

-- removed NA_UNIX

-- removed NA_WINNT

-- removed HAVE_MMAP

-- removed NA_NO_C_RUNTIME

-- removed NA_DEBUG_C_RUNTIME(replaced with _DEBUG)

-- removed NA_64BIT usage except in sqlcli.h

-- removed dg64

-- removed SQLEXPORT_LIB

-- removed NA_ARKFS

-- removed NA_IEEE_FLOAT

-- removed NA_GUARDIAN_MSG

-- removed NA_HSC


-- removed ERROR

-- removed ERROR_STATE


Contents of these files have been removed.

Next checkin fill remove the files itself from git:


executor/ExMeas.h, ExMeas.cpp

executor/tempfile.h, .cpp


executor/stubs.cpp, stubs2.cpp


cli/rtdu.h, rtdu2.h, rtdu.cpp, rtdu.cpp












sqlcat/ReadTableDef.h, cpp

sqlcat/readRealArk.h, cpp

  1. … 460 more files in changeset.
JIRA 2485,2540,2582,2591, plus other bug fixes

[TRAFODION-2485] Add support for REVERSE function

(OperTypeEnum.h, exp/*, sqlparser.y,

BindItemExpr.cpp, ItemExpr.cpp, SynthType.cpp,


[TRAFODION-2540] Alter Drop column on table with identity

"generated always" fails

(file CmpSeabaseDDLtable.cpp)

[TRAFODION-2582] "timestamp - timestamp" returns "days" instead of "seconds"

(file: BindItemExpr.cpp)

[TRAFODION-2591] Create index on added column returns incorrect results.

(file generator/GenRelScan.cpp)

Bug: Invalid "set transaction" stmt syntax no longer causes assertion failure

or abend. An error is issued instead.

(file BindRelExpr.cpp)

Bug: Hive inserts with mismatched tgt/src datatypes would sometimes do not

insert or insert incorrect values.

(file GenFastTransport.cpp)

Bug: an error indication is now returned if buildEncodeTree method is

called to encode a "NULL" value for a non-null column.

(file EncodedKeyValue.cpp)

hive/TEST007 now does initialize auth and register user

  1. … 25 more files in changeset.

Add two functions which used to encrypt and decrypt the data using the

official AES (Advanced Encryption Standard) algorithm.

AES_ENCRYPT(str, key_str[, init_vector])

AES_DECRYPT(crypt_str, key_str[, init_vector])

Both these two function have optional init_vector argument which

provides an initalization vector for block encryption modes that

require it. For modes that require the optional init_vector argument, an error

occurs if init_vector is missing. For modes that don't need

init_vector, it will raise a unused argument waring if init_vector is


The new CQD block_encryption_mode controls the mode for


encryption algorithm. The default value is 0, which use


Here is the list for diffferent values for


CQD value algorithm

0 aes-128-ecb

1 aes_192_ecb

2 aes_256_ecb

3 aes_128_cbc

4 aes_192_cbc

5 aes_256_cbc

6 aes_128_cfb1

7 aes_192_cfb1

8 aes_256_cfb1

9 aes_128_cfb8

10 aes_192_cfb8

11 aes_256_cfb8

12 aes_128_cfb128

13 aes_192_cfb128

14 aes_256_cfb128

15 aes_128_ofb

16 aes_192_ofb

17 aes_256_ofb

  1. … 21 more files in changeset.
fix conflicts

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



  1. … 13 more files in changeset.
return fixed length char for SHA2 function

  1. … 8 more files in changeset.
[TRAFODION-2353] initial execution part

  1. … 8 more files in changeset.
jira 2227

  1. … 21 more files in changeset.
Implement builtin function SOUNDEX

  1. … 12 more files in changeset.
fix for PR comments

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



  1. … 9 more files in changeset.
second round of function support

  1. … 8 more files in changeset.
[TRAFODION-2229] add hashing functions, commit set 1

  1. … 10 more files in changeset.
[TRAFODION-2312] Add support for GROUPING function for rollup aggr.

  1. … 25 more files in changeset.
groupby rollup commit #1

  1. … 31 more files in changeset.
[TRAFODION-2208] function support: log2,IS_IPV4,IS_IPV6 etc

  1. … 12 more files in changeset.