Trafodion

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Merge pull request #1834 from liuyu000/comparison_rounding_function

[TRAFODION-3303] Add the Comparison of Rounding Functions in the Trafodion SQL Reference Manual

[TRAFODION-3303] Add the Comparison of Rounding Functions in the Trafodion SQL Reference Manual

Merge pull request #1832 from liuyu000/empty_mapping_options

[TRAFODION-3301] Add considerations for empty mapping options in the Trafodion odb User Guide

[TRAFODION-3299] More improvements to binder messages in Messages Guide

    • -8
    • +8
    /core/sql/regress/executor/EXPECTED001
[TRAFODION-3301] Add considerations for empty mapping options in the Trafodion odb User Guide

[TRAFODION-3300] Fix overflow issues with extreme big nums + ROUND

    • -40
    • +490
    /core/sql/regress/executor/EXPECTED101.SB
Merge pull request #1830 from liuyu000/floor_function

[TRAFODION-3298] Add the FLOOR Function and the Comparison between Four Functions of Rounding Numbers in the Trafodion SQL Reference Manual

Incorporate Comments 1

Merge pull request #1828 from DaveBirdsall/Trafodion3296

[TRAFODION-3296] Fix handling of [first n] + ORDER BY subqueries

[TRAFODION-3298] Add the FLOOR Function and the Comparison between Four Functions of Rounding Numbers in the Trafodion SQL Reference Manual

Merge pull request #1829 from DaveBirdsall/Trafodion3297

[TRAFODION-3297] Update Messages Guide for some more binder messages

[TRAFODION-3297] Update Messages Guide for some more binder messages

Fix regression test core/TESET002

    • -6
    • +6
    /core/sql/regress/core/EXPECTED002.LINUX
Merge pull request #1827 from liuyu000/without_lob_columns

[TRAFODION-3295] Add syntax descriptions and examples of *WITHOUT LOB COLUMNS* for CREATE TABLE LIKE Statement in Trafodion SQL Reference Manual

Incorporate Comments 1

[TRAFODION-3296] Fix handling of [first n] + ORDER BY subqueries

    • -0
    • +133
    /core/sql/optimizer/BindRelExpr.cpp
    • -18
    • +152
    /core/sql/regress/core/EXPECTED002.LINUX
Merge pull request #1825 from liuyu000/aes_encrypt

[TRAFODION-3293] Add the AES_ENCRYPT Function in the Trafodion SQL Reference Manual

Correct a mistake in TRANSPOSE Clause

Merge pull request #1824 from selvaganesang/trafodion-3280_3

[TRAFODION-3280] Reduce path length in Trafodion for improved performance and scalability

Merge pull request #1826 from DaveBirdsall/Trafodion3294

[TRAFODION-3294] Updated Messages Guide for some binder messages

Incorporate Comments 1

[TRAFODION-3295] Add syntax descriptions and examples of *WITHOUT LOB COLUMNS* for CREATE TABLE LIKE Statement in Trafodion SQL Reference Manual

[TRAFODION-3294] Updated Messages Guide for some binder messages

Merge pull request #1821 from DaveBirdsall/UpdateStatsBugs

[TRAFODION-3291] Fix core when multi-column stats are done on lots of columns

[TRAFODION-3293] Add the AES_ENCRYPT Function in the Trafodion SQL Reference Manual

[TRAFODION-3280] Reduce path length in Trafodion for improved performance and scalability

There are many places in Trafodion code getenv is called repeatedly. Cleaned up code so that

repeated getenv calls are avoided during prepare and execute operations.

    • -3
    • +1
    /core/sql/exp/ExpPCodeOptsNativeExpr.cpp
Merge pull request #1823 from selvaganesang/trafodio_3280_2

Fix for cores seen with T2 JDBC applications caused by PR 1820

Merge pull request #1822 from DaveBirdsall/master

[TRAFODION-3290] Give better errors for case where table is all LOB columns

Fix for phoenix T2 tests in FunkyNamesTest

FunkyNamesTest has been removed temporarily

EsgynDB is not able to support delimited column names correctly. It has always been returning incorrect results.

We have modified FunkyNamesTest to suit our behavior. With the change to move from Array to HashMap for performance

reasons in both T4 and T2 driver code. However, the incorrect results differ between T2 and T4 when there are

more than one delimited column name matches due to uppercasing the column name always. This needs some change

in the descriptor information sent from SQL engine to denote that column names are delimited to preserve case.

We need to use the case preserving key String for delimited column names and case insensitive key String for

regular column names in the HashMap to convert from column names to column index.

    • -2
    • +3
    /core/sqf/sql/scripts/install_traf_components
Fix for the failure of testLTrimFunction, testTrimFunction and testRTrimFunction of VariableLengthPKTest in phoenix T4 tests.

When the statement type is TYPE_UNKNOWN, mxosrvr was executing the extra code

to load controls, GetHashInfo etc. GetHashInfo was corrupting the sqlString by

truncating spaces in between the literals.

Removed these code from mxosrvr because it is specific to QueryStatsServer as part of

NeoView and WMS.

    • -1038
    • +21
    /core/conn/odbc/src/odbc/nsksrvr/SrvrConnect.cpp