Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[TRAFODION-3299] More improvements to binder messages in Messages Guide

  1. … 2 more files in changeset.
[TRAFODION-3300] Fix overflow issues with extreme big nums + ROUND

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

Spec attached to jira.

new test regress/seabase/TEST004 added.

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

  1. … 8 more files in changeset.
Remove code that empties the LOB data file when creating an empty_blob.

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

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

  1. … 45 more files in changeset.
Follow on to TRAFODION-3192 that caused one regression failure on Jenkins alone since the queue resizing caused the executor/TEST106 that tests cancel to not work as expected. The upsert subtest was running too fast to get cancelled. So added some CQds to use smaller queue sizes and override dynamic queue resizing.Now it runs long enough to get canceled and give expected results.

  1. … 1 more file in changeset.
Regression expected file fix

[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. … 7 more files in changeset.
[TRAFODION-3162] fix regression failure get command

  1. … 3 more files in changeset.
add regress test for sys_guid

merge [TRAFODION-3101] enhance get command to show rows get

  1. … 2 more files in changeset.
[TRAFODION-3101] enhance get command to show rows get

  1. … 7 more files in changeset.
update to test executor/test022

TRAFODION-3115 Support nanosec precision for Timestamp/Interval datatypes

  1. … 5 more files in changeset.
[TRAFODION-3110] Refactor LOB access to use the new implementation of HdfsClient

This feature is enabled by default. To disable, set a variable USE_LIBHDFS=1 in

$TRAF_HOME/etc/ms.env and restart the trafodion cluster.

This feature includes the following:

1. Uses single FSDataInputStream for each LOB column in a query as

opposed to the opening the hdfs file for every row.

2. Uses FSDataOutputStream to write the lob data but closes it

immediately to allow concurrent writes to the hdfs file. HDFS supports

a single writer at a time. Need to conform if multiple writes can

be done without the need for RMS lock feature.

3. Improved error messaging that displays the java exception stack to the

end user.

4. LOB worker threads are no longer created

  1. … 12 more files in changeset.
nanosecs precision for timestamp/interval datatypes

  1. … 30 more files in changeset.
review comment + fix to executor/test020 from a different checkin.

  1. … 2 more files in changeset.
nonnull pkey, commit #1

  1. … 21 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. … 7 more files in changeset.
add regression test

JIRA TRAFODION-3027 Enhance jenkins checktests to include more tests.

Details in jira.

  1. … 30 more files in changeset.
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. … 30 more files in changeset.
[TRAFODION-3007] update statistics report error on volatile table

  1. … 5 more files in changeset.
[TRAFODION-2853] memory leak of ComDiagsArea in CmpContext heap of mxosrvr

Fixed a memory leak in ComDiagsArea that was missed out earlier. Also

took care of the review comments from the earlier PR

  1. … 17 more files in changeset.
[TRAFODION-2853] memory leak of ComDiagsArea in CmpContext heap of mxosrvr

Fixes for the regression failures seen with b97982c4494e078c5de2d883442d86265f24dadc

This includes the change to report the error at the time of compilation

for invoke, showddl commands. Earlier errors were ignored during

prepare time and reported only at the time of execute for these commands

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

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

  1. … 1 more file in changeset.
add regression test