You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by hz...@apache.org on 2015/12/11 00:23:14 UTC
[4/7] incubator-trafodion git commit: [TRAFODION-1581] TMUDF for JDBC
queries
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>