Clone
 

weiqing xu <weiqing.xu@esgyn.cn> in Trafodion

[TRAFODION-2753]LOB: filetolob() no longer works in trafci

[TRAFODION-2704]reslove the random schema not exist issue

[TRAFODION-2740]add property to set the LOB chunk size

[TRAFODION-2740]remove unused code

[TRAFODION-2740]JDBC extract LOB context in chunks

[TRAFODION-2704]close unused statment in JDBC regression

[TRAFODION-2308]remove unused lob code

fix LOB size error for dynamic parameters

throw exception whe calling APIs of LOB after free() is called

rename LOB_BATCH_SIZE to LOB_INPUT_LIMIT_FOR_BATCH

fix the LOB length for ExpLOBInterfaceUpdateAppend

[TRAFODION-2646]mxosrvr change to AVAILABLE after timeout if no client connect

    • -41
    • +48
    /core/conn/odbc/src/odbc/nsksrvr/SrvrConnect.cpp
[TRAFODION-2640]JDBC T2 support UTF-8

[TRAFODION-2308]JDBC support insert LOB

  1. … 27 more files in changeset.
[TRAFODION-2541]"UPDATE LOB" default max lob size error

The default lob max size for "UPDATE LOB" operator should be 10000MB

rather than 10000B

[TRAFODION-2228]fix shift/reduce conflict for AES_ENCRYPT/AES_DECRYPT

[TRAFODION-2228]Add AES_ENCRYPT/AES_DECRYPT functions

Add two functions which used to encrypt and decrypt the data using the

official AES (Advanced Encryption Standard) algorithm.

AES_ENCRYPT(str, key_str[, init_vector])

AES_DECRYPT(crypt_str, key_str[, init_vector])

Both these two function have optional init_vector argument which

provides an initalization vector for block encryption modes that

require it. For modes that require the optional init_vector argument, an error

occurs if init_vector is missing. For modes that don't need

init_vector, it will raise a unused argument waring if init_vector is

provided.

The new CQD block_encryption_mode controls the mode for

block-based

encryption algorithm. The default value is 0, which use

aes-128-ecb.

Here is the list for diffferent values for

block_encryption_mode

CQD value algorithm

0 aes-128-ecb

1 aes_192_ecb

2 aes_256_ecb

3 aes_128_cbc

4 aes_192_cbc

5 aes_256_cbc

6 aes_128_cfb1

7 aes_192_cfb1

8 aes_256_cfb1

9 aes_128_cfb8

10 aes_192_cfb8

11 aes_256_cfb8

12 aes_128_cfb128

13 aes_192_cfb128

14 aes_256_cfb128

15 aes_128_ofb

16 aes_192_ofb

17 aes_256_ofb

    • -0
    • +7
    /core/conn/odbc/src/odbc/Common/QSData.cpp
    • -0
    • +12
    /core/conn/odbc/src/odbc/Common/QSData.h
    • -0
    • +49
    /core/sql/common/ComSSL.cpp
    • -0
    • +60
    /core/sql/common/ComSSL.h
    • -2
    • +23
    /core/sql/generator/GenItemFunc.cpp
  1. … 7 more files in changeset.
update the error message for SHA2

return fixed length char for SHA2 function

    • -2
    • +23
    /core/sql/generator/GenItemFunc.cpp
    • -12
    • +21
    /core/sql/optimizer/SynthType.cpp
[TRAFODION-2229]SHA2 function enhancement

SHA2 support more funtcions than SHA-256. Now, it support SHA-224,

SHA-256, SHA-384, SHA-512.

SHA2(str, hash_length)

The first argument is the string to be hashed.

The second is the desired bit length of the result, which must have a

value of 224, 256, 384, 512, or 0(which is same with 256).

error handle in mxosrvr side for get lob

[TRAFODION-2308][JDBC]add test case for CLOB

[TRAFODION-1698]ODBC: trafodon doesn't support SQLForeginKeys

Fix the error of the old implementation and add test cases for it.

correct the FS_DATA_TYPE of INTERVAL DAY for SQLColumns

[TRAFODION-2145]sqlcolumns returned error info for some datatype

The root cause is the FS_DATA_TYPE is not right for some datatype in the

query for SQLCOLUMNS.

add test to check if the getIndexOf return real null

fix a compilation failure of TestGetIndexInfo

add apache license for TestGetIndexInfo.java

add JDBC test for getIndexInfo

[TRAFODION-2079]Catalog API support get indexes

After this comment, both JDBC type4 and ODBC Catalog API will support

get the information about index.

[TRAFODION-2079]([3rd party tool-Squirrel] indexes won't show up on

objects panel, sql command line works fine) which related to Catalog

API of JDBC type, it is fixed also.