http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/a3477192/core/sql/regress/udr/EXPECTED002 ---------------------------------------------------------------------- diff --git a/core/sql/regress/udr/EXPECTED002 b/core/sql/regress/udr/EXPECTED002 index 79603dd..0245a11 100644 --- a/core/sql/regress/udr/EXPECTED002 +++ b/core/sql/regress/udr/EXPECTED002 @@ -6570,17 +6570,17 @@ NUM_EVENTS NUM_LINES NUM_QUERY_IDS NUM_PARSE_ERRORS +> and (log_file_line in (1,3,8,16,23) or parse_status <> ' ') +>order by log_file_line; -LOG_TS SEVERITY COMPONENT NODE_NUMBER CPU PIN PROCESS_NAME SQL_CODE QUERY_ID MESSAGE LOG_FILE_NODE LOG_FILE_NAME LOG_FILE_LINE PARSE_STATUS --------------------------- ---------- ------------------------ ----------- ----------- ----------- ------------ ----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ------------ +LOG_TS SEVERITY COMPONENT NODE_NUMBER CPU PIN PROCESS_NAME SQL_CODE QUERY_ID MESSAGE LOG_FILE_NODE LOG_FILE_NAME LOG_FILE_LINE PARSE_STATUS +-------------------------- ---------- -------------------------------------------------- ----------- ----------- ----------- ------------ ----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ------------ -2015-02-03 00:08:03.480000 INFO SQL.EXE 0 0 25816 $Z000L2L ? ? An executor process is launched. 0 master_exec_regr_999_99999.log 1 -2015-02-03 00:08:11.037000 INFO SQL.COMP 0 0 25952 $Z000L6H ? ? A compiler process is launched. 0 master_exec_regr_999_99999.log 3 -2015-02-03 00:08:31.884000 ERROR SQL.EXE 0 0 25816 $Z000L2L 11252 MXID11000025816212289682083477587000000000206U3333300_1438___SQLCI_DML_LAST__ *** ERROR[11252] Column not found (SQLSTATE 38900) 0 master_exec_regr_999_99999.log 8 -2015-02-03 00:08:33.418000 ERROR SQL.EXE 0 0 25816 $Z000L2L 11246 MXID11000025816212289682083477587000000000206U3333300_1593___SQLCI_DML_LAST__ *** ERROR[11246] An error occurred locating function 'SESSIONIZE_NON_EXISTENT' in library '/opt/home/zellerh/trafodion/core/sqf/rundir/udr/TEST001.dll'. 2015-02-03 00:this is a bad timestamp and should be appended to the previous message 0 master_exec_regr_999_99999.log 16 -2015-02-03 00:08:33.500000 ERROR ? ? ? ? ? ? ? this should produce a parse error with this message 0 master_exec_regr_999_99999.log 20 E -2015-02-03 00:08:34.114000 ERROR SQL.EXE 0 0 25816 $Z000L2L 15001 MXID11000025816212289682083477587000000000206U3333300_1710___SQLCI_DML_LAST__ *** ERROR[15001] A syntax error occurred at or before: select * from udf(sessionize_dynamic(TABLE(SELECT userid, JULIANTIMESTAMP(ts) a s TS FROM clicks PARTITION BY userid ORDER BY ts), TABLE(SELECT userid, JULIANTIMESTAMP(ts) as TS FROM clicks PARTITION BY userid ORDER BY ts), cast('TS' as char(2)), 'USERID', 60000000)) XOX; ^ (409 characters from start of SQL statement) 0 master_exec_regr_999_99999.log 23 -2015-02-03 00:08:34.461000 ERROR SQL.EXE 0 0 25816 $Z000L2L 11252 MXID11000025816212289682083477587000000000206U3333300_1711___SQLCI_DML_LAST__ Some Chinese UTF8 characters: ??????????? and invalid UTF-8 characters: ??hould see replacement characters to the left 0 master_exec_regr_999_99999.log 30 C -2015-02-03 00:08:34.461000 ERROR SQL.EXE 0 0 25816 $Z000L2L 11252 MXID11000025816212289682083477587000000000206U3333300_1711___SQLCI_DML_LAST__ Parse error in continuation line: Invalid UTF-8 characters: ??hould see replacement characters to the left 0 master_exec_regr_999_99999.log 31 C +2015-02-03 00:08:03.480000 INFO SQL.EXE 0 0 25816 $Z000L2L ? ? An executor process is launched. 0 master_exec_regr_999_99999.log 1 +2015-02-03 00:08:11.037000 INFO SQL.COMP 0 0 25952 $Z000L6H ? ? A compiler process is launched. 0 master_exec_regr_999_99999.log 3 +2015-02-03 00:08:31.884000 ERROR SQL.EXE 0 0 25816 $Z000L2L 11252 MXID11000025816212289682083477587000000000206U3333300_1438___SQLCI_DML_LAST__ *** ERROR[11252] Column not found (SQLSTATE 38900) 0 master_exec_regr_999_99999.log 8 +2015-02-03 00:08:33.418000 ERROR SQL.EXE 0 0 25816 $Z000L2L 11246 MXID11000025816212289682083477587000000000206U3333300_1593___SQLCI_DML_LAST__ *** ERROR[11246] An error occurred locating function 'SESSIONIZE_NON_EXISTENT' in library '/opt/home/zellerh/trafodion/core/sqf/rundir/udr/TEST001.dll'. 2015-02-03 00:this is a bad timestamp and should be appended to the previous message 0 master_exec_regr_999_99999.log 16 +2015-02-03 00:08:33.500000 ERROR ? ? ? ? ? ? ? this should produce a parse error with this message 0 master_exec_regr_999_99999.log 20 E +2015-02-03 00:08:34.114000 ERROR SQL.EXE 0 0 25816 $Z000L2L 15001 MXID11000025816212289682083477587000000000206U3333300_1710___SQLCI_DML_LAST__ *** ERROR[15001] A syntax error occurred at or before: select * from udf(sessionize_dynamic(TABLE(SELECT userid, JULIANTIMESTAMP(ts) a s TS FROM clicks PARTITION BY userid ORDER BY ts), TABLE(SELECT userid, JULIANTIMESTAMP(ts) as TS FROM clicks PARTITION BY userid ORDER BY ts), cast('TS' as char(2)), 'USERID', 60000000)) XOX; ^ (409 characters from start of SQL statement) 0 master_exec_regr_999_99999.log 23 +2015-02-03 00:08:34.461000 ERROR SQL.EXE 0 0 25816 $Z000L2L 11252 MXID11000025816212289682083477587000000000206U3333300_1711___SQLCI_DML_LAST__ Some Chinese UTF8 characters: ??????????? and invalid UTF-8 characters: ??hould see replacement characters to the left 0 master_exec_regr_999_99999.log 30 C +2015-02-03 00:08:34.461000 ERROR SQL.EXE 0 0 25816 $Z000L2L 11252 MXID11000025816212289682083477587000000000206U3333300_1711___SQLCI_DML_LAST__ Parse error in continuation line: Invalid UTF-8 characters: ??hould see replacement characters to the left
<TRUNCATED>
