Clone Tools
Constraints: committers
Constraints: files
Constraints: dates
tochar enhancement

  1. … 5 more files in changeset.
add nonreserved_word and tests

  1. … 4 more files in changeset.
fix yacc conflicts

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

  1. … 10 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.


-- 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.
jira trafodion-2621, trafodion-2619 + others

-- trafodion-2621: add support to create like native hive or hbase tables

-- trafodion-2619: support to_date format 'yyyy/mm/dd'

-- alter table drop column on a table with user indexes would sometime

fail. That has been fixed.

-- get schemas in a session where default catalog is set to hive,

now correctly returns hive schemas

-- update stats on hive tables succeeds

-- update stats on hive view returns error as this operation

is not supported

  1. … 15 more files in changeset.
TRAFODION-2610 Register native HBase tables in traf MD plus couple more

-- support for registering hbase native cell/row format tables in traf MD


register [internal] hbase table [if not exists] <table-name>

unregister [internal] hbase table [if exists] <table-name>

-- support to get info related to registered hbase tables

Syntax: get hbase registered table in catalog trafodion

-- enhancements to HBase mapped tables and bug fixes

-- disabling of creation of external tables on native hbase

tables unless they are mapped tables

-- support for case-insensitive format string in TO_DATE function


-- regress/seabase/TEST022 enhanced with additional tests

  1. … 48 more files in changeset.
[TRAFODION-2493] to_char with format 'MONTH DD, YYYY, HH:MI' is wrong

  1. … 1 more file in changeset.
TRAFODION-2442 timestamp/date comparison bug. And couple other fixes.

-- TRAFODION-2442 timestamp comparison with date returns incorrect results.

that has been fixed. Date value is expanded to timestamp datatype and

then compared.

Fix is for timestamp/date comparison only.

TIMESTAMP comparison to TIME, and DATE comparison to TIME is not allowed.

-- row length of aligned format tables is now calculated correctly and

stored in metadata.

-- optimizer cost method for sort had a high limit of MEMORY_UNITS_SIZE

default set to 20M. For large rows in the range of 10 Mb,

this caused an overflow.

Fix is to allocate space for MAXOF default and size of 2 rows.

  1. … 7 more files in changeset.
[TRAFODION-2394] Add documentation for TO_CHAR + fix some bugs in it

  1. … 6 more files in changeset.
[TRAFODION-2285] Rework 2: Restrict TO_DATE and TO_TIME; also bug fixes

  1. … 8 more files in changeset.
Merge [TRAFODION-1676] PR-684 rework, fix executor regression test022 failures

further regression test core/030 seabase/038 and code refactor

  1. … 2 more files in changeset.
Additional changes to JIRA TRAFODION-2060 plus couple other fixes

-- interval computations involving tinyint are fixed.

-- hive data mod mismatch error now prints the compile and runtime

timestamps that caused the mismatch.

-- hive test003 updated to truncate data before insert

  1. … 21 more files in changeset.
JIRA TRAFODION-2180 enable/externalize non-ansi sql syntax/functionality

Enabled and externalized support for following functionality:

-- RANDOM and RANDOM(seed) functions

-- CEIL (same as CEILING) math function

-- GREATEST(val1, val2), LEAST(val1, val2)

-- return greater or lesser value between val1 and val2

-- MONTHS_BETWEEN(date1, date2)

-- number of months between date1 and date2.

+ve, if date1 > date2. -ve, otherwise

-- LAST_DAY(<date>)

-- date of the last day of the month of <date>

-- NEXT_DAY(<date>, <string>)

-- returns the date of the first weekday named by <string>

that is later than the date <date>


-- TO_NUMBER. Limited support.

-- TO_TIMESTAMP. Limited support.

-- syntax BYTEINT (same as TINYINT)

-- select UNIQUE ... from <tab>. Same as DISTINCT

-- NOT NULL ENABLE syntax in col defn (same as NOT NULL)

-- Removal of all reserved keywords

-- support for 'select * from DUAL'

Other changes:

-- error 8413 to indicate that source data being displayed is in hex

-- "-failed" option to runregr and runallsb.

It will rerun only the tests that have failed

-- removed mode_special_2, mode_special_3, mode_special_5 cqds

-- fixed an issue with hive data modification check

-- alter rename stmt now writes generated object into metadata

-- Infrastructure support for couple of JIRAs.

These have not been enabled as default for this ckin but

developer regressions are run after enabling them.

-- JIRA TRAFODION-2181 Incompatible operations

-- JIRA TRAFODION-2184 Groupby/Orderby extensions

  1. … 86 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-1843: allow 'default user' in create table statement

-- TRAFODION-2106: fix bug with use of to_date function in where clause

  1. … 7 more files in changeset.
[TRAFODION-1676]support better runtime error message when a SQL function meet fital error

  1. … 9 more files in changeset.
Various fixes (details below)

-- ddl_transactions cqd is now on by default.

All ddl, where allowed and supported, will run

within one transaction

-- drop schema has been disabled to run within one transaction.

When jira 1948 is fixed, it will be enabled.

-- hdfs scan handles hive col values > 32K

-- pcode handles varchar with len > 32K

-- errors (gaps, unsorted order) for cqd values in nadefaults are

detected without crashing arkcmp.

-- volatile and regular schema drop returns the reason if an error occured

(for ex: name of objects that could not be dropped)

-- dateformat displays european format correctly with a blank

seperator between date and time values

-- dateformat timestamp in usa format displayes time with AM/PM

-- dateformat inside a cast function returns correct values.

  1. … 19 more files in changeset.
commit #1

  1. … 25 more files in changeset.

  1. … 298 more files in changeset.
JIRA 1899, Various fixes. Details below.

-- time datatype with no fraction precision was not getting converted

correctly and was putting out null characters.

-- dateformat usa was not displaying AM/PM with time datatype

-- update of primary key that got transformed into delete/insert

would incorrectly delete the row if insert ran into an error

-- rename cascade option is not supported. An error is now returned.

-- rename table with check constraint is not supported.

An error is now returned.

-- add/drop of primary key constraint now gives consistent behavior.

Primary key columns are used as clustering key if primary key constraint

is specified during create table.

Primary key constraint creates a unique index if it is specified

after create table and no user specified primary or store by clause

was specified during create.

Drop of primary key constraint succeeds only if that primary key

is not the clustering key.

-- invalid ddl with salt clause no longer crashes and returns an error instead.

-- parser now gives a syntax error on MV and Triggers queries since

these features are not externalized.

-- regress/seabase/TEST031 has been added for misc fixes

  1. … 12 more files in changeset.
JIRA TRAFODION-1873 Support for to_date, to_char functions

Support for to_date, to_char functions.

Code cleanup and simplification.

Bug fixes.

New test regress/seabase/TEST030.

  1. … 7 more files in changeset.
datetime functions: commit #1

  1. … 17 more files in changeset.