Trafodion

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
Fix to ensure infostats command from trafci works as expected.

Fix to ensure that trafci returns the correct status message of the recent sql command instead of returning "--- SQL operation complete" always.

Optimizing and avoiding unnecessary function calls shown as hot spots in jprofile - part-IIa

Removed ununsed code

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

New member variables were not initialized in the CliGlobals constructor

Optimizing and avoiding unnecessary function calls shown as hot spots in jprofile - part-II

Changed Hashtable to HashMap where possible with the assumption that the JDBC connection

shouldn't be used from different threads. TrafT4Connection object needs be made thread-safe.

Optimized org.trafodion.jdbc.t4.TrafT4ResultSet.findColumn by using HashMap of columnName to

columnIndex. This should avoid excessive calls to java.lang.String.equalsIgnoreCase.

Removed excessive calls to java.lang.Class.getMethod from TrafT4ResultSet

Rework addressing Qifan's suggestions