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-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.
merge [TRAFODION-2335]

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

  1. … 8 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.
[TRAFODION-2335] support some functions as column default, part1 commit

  1. … 15 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.
[TRAFODION-2768] Make Trafodion code base to compile in RH7

  1. … 126 more files in changeset.
[TRAFODION-2719] Check for truncation of character columns

When inserting into a UTF-8 character column with a fixed number

of characters, do a check whether the source string contains no

more than the allowed number of characters (just checking the

byte length is not enough). This bug does not show when using

sqlci, since sqlci does its own check before calling the

executor. It only happens when using JDBC or trafci.

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

  1. … 392 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.
[TRAFODION-2727] Memory leak in the compiler part of the code in Trafodion

Compiler objects were refactored to use the heap infrastructure to ensure

that it is accounted and allocated within the trafodion memory management.

The commonly used NAType and derived classes are mostly created via heap,

but the heap was not passed in the constructor. The embedded objects

used the system heap though the container object is allocated in the compiler

heap. This could result in memory leak when the container object is


  1. … 63 more files in changeset.
Fix for seabase/test020 failure

TRAFODION-1586 Add support for external Traf tables mappedd to HBase tables

This is the initial support for HBase mapped tables.

A doc for external manuals will be added later.

regress/seabase/TEST022 contains various testcases.

  1. … 77 more files in changeset.
jira [trafodion-2290] and few other bug fixes

-- trafodion-2290: pcode support for added columns on aligned tables

-- lob conversion error is reported instead of crash

-- alter table rename is restricted to not run under a user xn

-- error during alter table rename are handled correctly

-- error during alter/drop cols on aligned tables are handled correctly.

-- aligned format drop column with delimited names are handled correctly

-- rollup grouping now work correctly on expressions and renamed columns

  1. … 23 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.
Various fixes, details listed below

--error message returned during string to float conversion error was not

correct. That has been fixed.

-- ordering was not getting set correctly during key encoding.

-- stored descriptor was not getting stored correctly if

the generated length was exactly 10000 bytes (max length of TEXT.text col).

-- time part of european date format is now handled correctly

by using '.' as delimiter instead of ':'

-- repeat function was crashing if specified maxlength was not sufficient

to hold the result. It now returns an overflow error.

-- tinyint key columns were not handling the case of overflow/underflow

when used in a key predicate. That has been fixed.

-- Numeric datatype with precision less than 3 is now created as tinyint

and handled in expressions.

-- some non-tinyint datatypes(float, decimal) were not being handled

correctly when converted to tinyint. That has been fixed.

-- some more pcode instructions involving tinyint range check and

conversions have been added.

  1. … 30 more files in changeset.
[TRAFODION-2131] Fix USTATS cores + some other issues

  1. … 3 more files in changeset.
JIRA TRAFODION-2099 Add support for boolean datatype

-- boolean datatype support in create, cast and params


create table t (a boolean);

insert into t values (true), (false);

select * from t where a = true;

-- boolean datatype support for hive columns

-- unarith op support. Currently used for '!' operator that

negates a boolean value.

Ex: select * from t where !a = false;

-- support for more tinyint and largeint unsigned conversion/comparison

operations in expressions and pcode

-- some code cleanup: removed reference to downrev compiler code genration

-- create table if not exists as select... syntax support

-- regress/seabase/TEST003 updated with additional tests

  1. … 81 more files in changeset.
added enhanced check to handle default values copy

Current code has an optimization to move source default

value to target if total length (null+VClen+length) match.

This is sufficient for current scenarios where the difference

between source and target is only in VClen indicator (2 or 4 bytes).

But that assumption may not be true in future and was pointed out

by reviewer. An enhanced check has been added to make sure

that all sub-parts (nullLen, vcLen, dataLen) also match.

commit #1

  1. … 25 more files in changeset.

  1. … 298 more files in changeset.
Adding charset info for lobhandle. New regression test for execrcising GC.

  1. … 11 more files in changeset.
[TRAFODION-1423] indexes are now created in aligned format by default

The indexes row format is now independent of the table. The table

can be in format that aids in pushing down the predicates to

hbase, but the index is now created in aligned format by default.

SHOWDDL <table_name> now shows the row format of the index when it

is in aligned row format.

  1. … 9 more files in changeset.
Fix for a few JIRA issues

[TRAFODION 1462] : Change HBASE_SERIALIZATION to ON by default

[TRAFODION 1463] : Support UPSERT into serialized table with index

[TRAFODION 1464] : UPSERT into indexed table with idendity by default key causes inconsistency

[TRAFODION 1465] : MERGE with select on source side into indexes table causes inconsistency

[TRAFODION 1466] : Bulk load into seralized indexed table causes inconsistency

[TRAFODION 1254] : Various inconsistency issues with Bulk load and upsert, changed a cqd name to finally close it.

  1. … 9 more files in changeset.
Part 2 of changes to update license text in Trafodion source

This check-in updates license text in all source files in the

core/sql directory. Remaining directories will be done in

later check-ins.

  1. … 3147 more files in changeset.
Merge remote branch 'core/master'

  1. … 108 more files in changeset.