Running UDR Lib Testsuite ------------------------ Running Test01 ------------------------ No entry for terminal type "xterm-256color"; using dumb terminal settings. MYROWCOUNT ============ 42 MYROWCOUNT ============ 21 MYROWCOUNT ============ Statement failed, SQLSTATE = 42S02 Dynamic SQL Error -SQL error code = -204 -Table unknown -BAD -At line 1, column 22 -At function 'MYROWCOUNT' UDRINFO =============================== Hello World ------------------------ Running Test02 ------------------------ No entry for terminal type "xterm-256color"; using dumb terminal settings. SALARY FULLNAME ===================== ==================================== 81810.19 Fisher, Pete ------------------------ Running Test03 ------------------------ No entry for terminal type "xterm-256color"; using dumb terminal settings. FULLNAME SALARY ACCSALARY ==================================== ===================== ===================== Nelson, Robert 105900.00 105900.00 Young, Bruce 97500.00 203400.00 Lambert, Kim 102750.00 306150.00 Johnson, Leslie 64635.00 370785.00 Forest, Phil 75060.00 445845.00 Weston, K. J. 86292.94 532137.94 Lee, Terri 53793.00 585930.94 Hall, Stewart 69482.63 655413.57 Young, Katherine 67241.25 722654.82 Papadopoulos, Chris 89655.00 812309.82 Fisher, Pete 81810.19 894120.01 Bennet, Ann 22935.00 917055.01 De Souza, Roger 69482.63 986537.64 Baldwin, Janet 61637.81 1048175.45 Reeves, Roger 33620.63 1081796.08 Stansbury, Willie 39224.06 1121020.14 Phong, Leslie 56034.38 1177054.52 Ramanathan, Ashok 80689.50 1257744.02 Steadman, Walter 116100.00 1373844.02 Nordstrom, Carol 42742.50 1416586.52 FULLNAME SALARY ACCSALARY ==================================== ===================== ===================== Leung, Luke 68805.00 1485391.52 O'Brien, Sue Anne 31275.00 1516666.52 Burbank, Jennifer M. 53167.50 1569834.02 Sutherland, Claudia 100914.00 1670748.02 Bishop, Dana 62550.00 1733298.02 MacDonald, Mary S. 111262.50 1844560.52 Williams, Randy 56295.00 1900855.52 Bender, Oliver H. 212850.00 2113705.52 Cook, Kevin 111262.50 2224968.02 Brown, Kelly 27000.00 2251968.02 Ichida, Yuki 6000000.00 8251968.02 Page, Mary 48000.00 8299968.02 Parker, Bill 35000.00 8334968.02 Yamamoto, Takashi 7480000.00 15814968.02 Ferrari, Roberto 33000.00 15847968.02 Yanowski, Michael 44000.00 15891968.02 Glon, Jacques 38500.00 15930468.02 Johnson, Scott 60000.00 15990468.02 Green, T.J. 36000.00 16026468.02 Osborne, Pierre 110000.00 16136468.02 FULLNAME SALARY ACCSALARY ==================================== ===================== ===================== Montgomery, John 35000.00 16171468.02 Guckenheimer, Mark 32000.00 16203468.02 TEXT ==================================================================================================== To be or not to be-that is the question: Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And, by opposing, end them. To die, to sleep- No more-and by a sleep to say we end The heartache and the thousand natural shocks That flesh is heir to-'tis a consummation Devoutly to be wished. To die, to sleep- To sleep, perchance to dream. Aye, there's the rub, For in that sleep of death what dreams may come, When we have shuffled off this mortal coil, Must give us pause. There's the respect That makes calamity of so long life. For who would bear the whips and scorns of time, Th' oppressor's wrong, the proud man's contumely, The pangs of despised love, the law’s delay, The insolence of office, and the spurns That patient merit of the unworthy takes, When he himself might his quietus make TEXT ==================================================================================================== With a bare bodkin? Who would fardels bear, To grunt and sweat under a weary life, But that the dread of something after death, The undiscovered country from whose bourn No traveler returns, puzzles the will And makes us rather bear those ills we have Than fly to others that we know not of? Thus conscience does make cowards of us all, And thus the native hue of resolution Is sicklied o'er with the pale cast of thought, And enterprises of great pitch and moment, With this regard their currents turn awry, And lose the name of action.-Soft you now, The fair Ophelia.-Nymph, in thy orisons Be all my sins remembered ------------------------ Running Test04 ------------------------ No entry for terminal type "xterm-256color"; using dumb terminal settings. PHONE_EXT PREVIOUS_PHONE_EXT ========= ================== 999 250 PHONE_EXT PREVIOUS_PHONE_EXT ========= ================== 250 999 UDR Log Contents ---------------- @dd-mm-yy hh:mm:ss.zzzz:Registering Function row_count @dd-mm-yy hh:mm:ss.zzzz:Registering Function bad_row_count @dd-mm-yy hh:mm:ss.zzzz:Registering Function return_info @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure test_proc @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure select_proc @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure read_txt @dd-mm-yy hh:mm:ss.zzzz:Registering Trigger my_employee_update @dd-mm-yy hh:mm:ss.zzzz:Setup Function row_count @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYROWCOUNT Entry Point = fbudrtests!row_count (fbudrtests,row_count,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 36 Field No. 0 Field Name = TABLE_NAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 31 Scale = 0 Offset = 0 Null Offset = 34 Message Length = 31 Output Metadata: Field Count = 1 Alignment = 4 Aligned Length = 8 Field No. 0 Field Name = Relation Name = Alias Name = SQLType = SQL_LONG IsNullable = yes SubType = 0 Length = 4 Scale = 0 Offset = 0 Null Offset = 4 Message Length = 4 @dd-mm-yy hh:mm:ss.zzzz:Setup Function row_count @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYROWCOUNT Entry Point = fbudrtests!row_count (fbudrtests,row_count,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 36 Field No. 0 Field Name = TABLE_NAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 31 Scale = 0 Offset = 0 Null Offset = 34 Message Length = 31 Output Metadata: Field Count = 1 Alignment = 4 Aligned Length = 8 Field No. 0 Field Name = Relation Name = Alias Name = SQLType = SQL_LONG IsNullable = yes SubType = 0 Length = 4 Scale = 0 Offset = 0 Null Offset = 4 Message Length = 4 @dd-mm-yy hh:mm:ss.zzzz:Setup Function bad_row_count @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = BADROWCOUNT Entry Point = fbudrtests!bad_row_count (fbudrtests,bad_row_count,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 36 Field No. 0 Field Name = TABLE_NAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 31 Scale = 0 Offset = 0 Null Offset = 34 Message Length = 31 Output Metadata: Field Count = 1 Alignment = 4 Aligned Length = 8 Field No. 0 Field Name = Relation Name = Alias Name = SQLType = SQL_LONG IsNullable = yes SubType = 0 Length = 4 Scale = 0 Offset = 0 Null Offset = 4 Message Length = 4 @dd-mm-yy hh:mm:ss.zzzz:Setup Function bad_row_count @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = BADROWCOUNT Entry Point = fbudrtests!bad_row_count (fbudrtests,bad_row_count,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 36 Field No. 0 Field Name = TABLE_NAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 31 Scale = 0 Offset = 0 Null Offset = 34 Message Length = 31 Output Metadata: Field Count = 1 Alignment = 4 Aligned Length = 8 Field No. 0 Field Name = Relation Name = Alias Name = SQLType = SQL_LONG IsNullable = yes SubType = 0 Length = 4 Scale = 0 Offset = 0 Null Offset = 4 Message Length = 4 @dd-mm-yy hh:mm:ss.zzzz:Setup Function return_info @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = UDRINFO Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World) Body = Input Metadata: Field Count = 0 Alignment = 2 Aligned Length = 0 Output Metadata: Field Count = 1 Alignment = 2 Aligned Length = 36 Field No. 0 Field Name = Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 31 Scale = 0 Offset = 0 Null Offset = 34 Message Length = 31 @dd-mm-yy hh:mm:ss.zzzz:Setup Function return_info @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = UDRINFO Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World) Body = Input Metadata: Field Count = 0 Alignment = 2 Aligned Length = 0 Output Metadata: Field Count = 1 Alignment = 2 Aligned Length = 36 Field No. 0 Field Name = Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 31 Scale = 0 Offset = 0 Null Offset = 34 Message Length = 31 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure test_proc @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYTESTPROC Entry Point = fbudrtests!test_proc (fbudrtests,test_proc,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 4 Field No. 0 Field Name = EMP_NO Relation Name = Alias Name = SQLType = SQL_SHORT IsNullable = yes SubType = 0 Length = 2 Scale = 0 Offset = 0 Null Offset = 2 Message Length = 2 Output Metadata: Field Count = 2 Alignment = 8 Aligned Length = 56 Field No. 0 Field Name = SALARY Relation Name = Alias Name = SQLType = SQL_INT64 IsNullable = yes SubType = 1 Length = 8 Scale = -2 Offset = 0 Null Offset = 8 Message Length = 8 Field No. 1 Field Name = FULLNAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 36 Scale = 0 Offset = 10 Null Offset = 48 Message Length = 36 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure test_proc @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYTESTPROC Entry Point = fbudrtests!test_proc (fbudrtests,test_proc,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 4 Field No. 0 Field Name = EMP_NO Relation Name = Alias Name = SQLType = SQL_SHORT IsNullable = yes SubType = 0 Length = 2 Scale = 0 Offset = 0 Null Offset = 2 Message Length = 2 Output Metadata: Field Count = 2 Alignment = 8 Aligned Length = 56 Field No. 0 Field Name = SALARY Relation Name = Alias Name = SQLType = SQL_INT64 IsNullable = yes SubType = 1 Length = 8 Scale = -2 Offset = 0 Null Offset = 8 Message Length = 8 Field No. 1 Field Name = FULLNAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 36 Scale = 0 Offset = 10 Null Offset = 48 Message Length = 36 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure select_proc @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYSELECTPROC Entry Point = fbudrtests!select_proc (fbudrtests,select_proc,) Body = Input Metadata: Field Count = 0 Alignment = 2 Aligned Length = 0 Output Metadata: Field Count = 3 Alignment = 8 Aligned Length = 72 Field No. 0 Field Name = FULLNAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 36 Scale = 0 Offset = 0 Null Offset = 38 Message Length = 36 Field No. 1 Field Name = SALARY Relation Name = Alias Name = SQLType = SQL_INT64 IsNullable = yes SubType = 1 Length = 8 Scale = -2 Offset = 40 Null Offset = 48 Message Length = 8 Field No. 2 Field Name = ACCSALARY Relation Name = Alias Name = SQLType = SQL_INT64 IsNullable = yes SubType = 1 Length = 8 Scale = -2 Offset = 56 Null Offset = 64 Message Length = 8 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure select_proc @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYSELECTPROC Entry Point = fbudrtests!select_proc (fbudrtests,select_proc,) Body = Input Metadata: Field Count = 0 Alignment = 2 Aligned Length = 0 Output Metadata: Field Count = 3 Alignment = 8 Aligned Length = 72 Field No. 0 Field Name = FULLNAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 36 Scale = 0 Offset = 0 Null Offset = 38 Message Length = 36 Field No. 1 Field Name = SALARY Relation Name = Alias Name = SQLType = SQL_INT64 IsNullable = yes SubType = 1 Length = 8 Scale = -2 Offset = 40 Null Offset = 48 Message Length = 8 Field No. 2 Field Name = ACCSALARY Relation Name = Alias Name = SQLType = SQL_INT64 IsNullable = yes SubType = 1 Length = 8 Scale = -2 Offset = 56 Null Offset = 64 Message Length = 8 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure read_txt @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYREADTEXT Entry Point = fbudrtests!read_txt (fbudrtests,read_txt,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 204 Field No. 0 Field Name = PATH Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = no SubType = 0 Length = 200 Scale = 0 Offset = 0 Null Offset = 202 Message Length = 200 Output Metadata: Field Count = 1 Alignment = 2 Aligned Length = 104 Field No. 0 Field Name = TEXT Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = no SubType = 0 Length = 100 Scale = 0 Offset = 0 Null Offset = 102 Message Length = 100 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure read_txt @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYREADTEXT Entry Point = fbudrtests!read_txt (fbudrtests,read_txt,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 204 Field No. 0 Field Name = PATH Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = no SubType = 0 Length = 200 Scale = 0 Offset = 0 Null Offset = 202 Message Length = 200 Output Metadata: Field Count = 1 Alignment = 2 Aligned Length = 104 Field No. 0 Field Name = TEXT Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = no SubType = 0 Length = 100 Scale = 0 Offset = 0 Null Offset = 102 Message Length = 100 @dd-mm-yy hh:mm:ss.zzzz:Setup Function row_count @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYROWCOUNT Entry Point = fbudrtests!row_count (fbudrtests,row_count,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 36 Field No. 0 Field Name = TABLE_NAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 31 Scale = 0 Offset = 0 Null Offset = 34 Message Length = 31 Output Metadata: Field Count = 1 Alignment = 4 Aligned Length = 8 Field No. 0 Field Name = Relation Name = Alias Name = SQLType = SQL_LONG IsNullable = yes SubType = 0 Length = 4 Scale = 0 Offset = 0 Null Offset = 4 Message Length = 4 @dd-mm-yy hh:mm:ss.zzzz:Function row_count created @dd-mm-yy hh:mm:ss.zzzz:Package Name = Name = MYROWCOUNT Entry Point = fbudrtests!row_count (fbudrtests,row_count,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 36 Field No. 0 Field Name = TABLE_NAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 31 Scale = 0 Offset = 0 Null Offset = 34 Message Length = 31 Output Metadata: Field Count = 1 Alignment = 4 Aligned Length = 8 Field No. 0 Field Name = Relation Name = Alias Name = SQLType = SQL_LONG IsNullable = yes SubType = 0 Length = 4 Scale = 0 Offset = 0 Null Offset = 4 Message Length = 4 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count @dd-mm-yy hh:mm:ss.zzzz:External Context: Attachment ID = 1374 Transaction ID = 4964 User Name = SYSDBA Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb Client Character Set = NONE @dd-mm-yy hh:mm:ss.zzzz:Input Parameters Parameter 0: Field Name = TABLE_NAME Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 31 Value = EMPLOYEE @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data Column 0 Field Name = SQLType = SQL_LONG sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 42 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count @dd-mm-yy hh:mm:ss.zzzz:External Context: Attachment ID = 1374 Transaction ID = 4964 User Name = SYSDBA Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb Client Character Set = NONE @dd-mm-yy hh:mm:ss.zzzz:Input Parameters Parameter 0: Field Name = TABLE_NAME Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 31 Value = DEPARTMENT @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data Column 0 Field Name = SQLType = SQL_LONG sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 21 @dd-mm-yy hh:mm:ss.zzzz:Execute Function row_count @dd-mm-yy hh:mm:ss.zzzz:External Context: Attachment ID = 1374 Transaction ID = 4964 User Name = SYSDBA Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb Client Character Set = NONE @dd-mm-yy hh:mm:ss.zzzz:Input Parameters Parameter 0: Field Name = TABLE_NAME Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 31 Value = BAD @dd-mm-yy hh:mm:ss.zzzz:Exception raised SQLCODE: -999 Engine Code: 335544569 Dynamic SQL Error -SQL error code = -204 -Table unknown -BAD -At line 1, column 22 When Executing: Select count(*) from BAD @dd-mm-yy hh:mm:ss.zzzz:Setup Function return_info @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = UDRINFO Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World) Body = Input Metadata: Field Count = 0 Alignment = 2 Aligned Length = 0 Output Metadata: Field Count = 1 Alignment = 2 Aligned Length = 36 Field No. 0 Field Name = Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 31 Scale = 0 Offset = 0 Null Offset = 34 Message Length = 31 @dd-mm-yy hh:mm:ss.zzzz:Function return_info created @dd-mm-yy hh:mm:ss.zzzz:Package Name = Name = UDRINFO Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World) Body = Input Metadata: Field Count = 0 Alignment = 2 Aligned Length = 0 Output Metadata: Field Count = 1 Alignment = 2 Aligned Length = 36 Field No. 0 Field Name = Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 31 Scale = 0 Offset = 0 Null Offset = 34 Message Length = 31 @dd-mm-yy hh:mm:ss.zzzz:Execute Function return_info @dd-mm-yy hh:mm:ss.zzzz:External Context: Attachment ID = 1374 Transaction ID = 4964 User Name = SYSDBA Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb Client Character Set = NONE @dd-mm-yy hh:mm:ss.zzzz:Input Parameters @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data Column 0 Field Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 31 Value = Hello World @dd-mm-yy hh:mm:ss.zzzz:Function return_info: dispose called @dd-mm-yy hh:mm:ss.zzzz:Function row_count: dispose called @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure test_proc @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYTESTPROC Entry Point = fbudrtests!test_proc (fbudrtests,test_proc,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 4 Field No. 0 Field Name = EMP_NO Relation Name = Alias Name = SQLType = SQL_SHORT IsNullable = yes SubType = 0 Length = 2 Scale = 0 Offset = 0 Null Offset = 2 Message Length = 2 Output Metadata: Field Count = 2 Alignment = 8 Aligned Length = 56 Field No. 0 Field Name = SALARY Relation Name = Alias Name = SQLType = SQL_INT64 IsNullable = yes SubType = 1 Length = 8 Scale = -2 Offset = 0 Null Offset = 8 Message Length = 8 Field No. 1 Field Name = FULLNAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 36 Scale = 0 Offset = 10 Null Offset = 48 Message Length = 36 @dd-mm-yy hh:mm:ss.zzzz:Open Execute Procedure test_proc @dd-mm-yy hh:mm:ss.zzzz:External Context: Attachment ID = 1377 Transaction ID = 4976 User Name = SYSDBA Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb Client Character Set = NONE @dd-mm-yy hh:mm:ss.zzzz:Input Parameters Parameter 0: Field Name = EMP_NO Alias Name = SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Nullable Size = 2 Value = 24 @dd-mm-yy hh:mm:ss.zzzz:Output Parameters Column 0 Field Name = SALARY SQLType = SQL_INT64 sub type = 0 Scale = -2 Charset = NONE Nullable Size = 8 Value = NULL Column 1 Field Name = FULLNAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 36 Value = NULL @dd-mm-yy hh:mm:ss.zzzz:Output Parameters with data Column 0 Field Name = SALARY SQLType = SQL_INT64 sub type = 0 Scale = -2 Charset = NONE Nullable Size = 8 Value = 81810.19 Column 1 Field Name = FULLNAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 36 Value = Fisher, Pete @dd-mm-yy hh:mm:ss.zzzz:Procedure test_proc: dispose called with refcount = 2 @dd-mm-yy hh:mm:ss.zzzz:Procedure test_proc: dispose called with refcount = 1 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure select_proc @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYSELECTPROC Entry Point = fbudrtests!select_proc (fbudrtests,select_proc,) Body = Input Metadata: Field Count = 0 Alignment = 2 Aligned Length = 0 Output Metadata: Field Count = 3 Alignment = 8 Aligned Length = 72 Field No. 0 Field Name = FULLNAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 36 Scale = 0 Offset = 0 Null Offset = 38 Message Length = 36 Field No. 1 Field Name = SALARY Relation Name = Alias Name = SQLType = SQL_INT64 IsNullable = yes SubType = 1 Length = 8 Scale = -2 Offset = 40 Null Offset = 48 Message Length = 8 Field No. 2 Field Name = ACCSALARY Relation Name = Alias Name = SQLType = SQL_INT64 IsNullable = yes SubType = 1 Length = 8 Scale = -2 Offset = 56 Null Offset = 64 Message Length = 8 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure select_proc @dd-mm-yy hh:mm:ss.zzzz:External Context: Attachment ID = 1380 Transaction ID = 4983 User Name = SYSDBA Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb Client Character Set = NONE @dd-mm-yy hh:mm:ss.zzzz:Input Parameters @dd-mm-yy hh:mm:ss.zzzz:Output Parameters Column 0 Field Name = FULLNAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 36 Value = NULL Column 1 Field Name = SALARY SQLType = SQL_INT64 sub type = 0 Scale = -2 Charset = NONE Nullable Size = 8 Value = NULL Column 2 Field Name = ACCSALARY SQLType = SQL_INT64 sub type = 0 Scale = -2 Charset = NONE Nullable Size = 8 Value = NULL @dd-mm-yy hh:mm:ss.zzzz:Procedure select_proc: dispose called with refcount = 2 @dd-mm-yy hh:mm:ss.zzzz:Setup Procedure read_txt @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYREADTEXT Entry Point = fbudrtests!read_txt (fbudrtests,read_txt,) Body = Input Metadata: Field Count = 1 Alignment = 2 Aligned Length = 204 Field No. 0 Field Name = PATH Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = no SubType = 0 Length = 200 Scale = 0 Offset = 0 Null Offset = 202 Message Length = 200 Output Metadata: Field Count = 1 Alignment = 2 Aligned Length = 104 Field No. 0 Field Name = TEXT Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = no SubType = 0 Length = 100 Scale = 0 Offset = 0 Null Offset = 102 Message Length = 100 @dd-mm-yy hh:mm:ss.zzzz:Open Select Procedure read_txt @dd-mm-yy hh:mm:ss.zzzz:External Context: Attachment ID = 1380 Transaction ID = 4983 User Name = SYSDBA Database Name = /opt/firebird4.0.1/examples/empbuild/employee.fdb Client Character Set = NONE @dd-mm-yy hh:mm:ss.zzzz:Input Parameters Parameter 0: Field Name = PATH Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 200 Value = /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/testtext.txt @dd-mm-yy hh:mm:ss.zzzz:Read Text called in directory /tmp @dd-mm-yy hh:mm:ss.zzzz:Reading from /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite/udrlib/testtext.txt @dd-mm-yy hh:mm:ss.zzzz:Output Parameters Column 0 Field Name = TEXT SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 100 Value = @dd-mm-yy hh:mm:ss.zzzz:Procedure read_txt: dispose called with refcount = 2 @dd-mm-yy hh:mm:ss.zzzz:Procedure select_proc: dispose called with refcount = 1 @dd-mm-yy hh:mm:ss.zzzz:Procedure read_txt: dispose called with refcount = 1 @dd-mm-yy hh:mm:ss.zzzz:Setup Trigger my_employee_update @dd-mm-yy hh:mm:ss.zzzz:Routine Metadata Package Name = Name = MYEMPLOYEEUPDATE Entry Point = fbudrtests!my_employee_update (fbudrtests,my_employee_update,) Body = Input Metadata: (nil) Output Metadata: (nil)Trigger Metadata: Field Count = 12 Alignment = 0 Aligned Length = 0 Field No. 0 Field Name = EMP_NO Relation Name = Alias Name = SQLType = SQL_SHORT IsNullable = no SubType = 0 Length = 2 Scale = 0 Offset = 0 Null Offset = 0 Message Length = 2 Field No. 1 Field Name = FIRST_NAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = no SubType = 0 Length = 15 Scale = 0 Offset = 0 Null Offset = 0 Message Length = 15 Field No. 2 Field Name = LAST_NAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = no SubType = 0 Length = 20 Scale = 0 Offset = 0 Null Offset = 0 Message Length = 20 Field No. 3 Field Name = PHONE_EXT Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 4 Scale = 0 Offset = 0 Null Offset = 0 Message Length = 4 Field No. 4 Field Name = HIRE_DATE Relation Name = Alias Name = SQLType = SQL_TIMESTAMP IsNullable = no SubType = 0 Length = 8 Scale = 0 Offset = 0 Null Offset = 0 Message Length = 8 Field No. 5 Field Name = DEPT_NO Relation Name = Alias Name = SQLType = SQL_TEXT IsNullable = no SubType = 0 Length = 3 Scale = 0 Offset = 0 Null Offset = 0 Message Length = 3 Field No. 6 Field Name = JOB_CODE Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = no SubType = 0 Length = 5 Scale = 0 Offset = 0 Null Offset = 0 Message Length = 5 Field No. 7 Field Name = JOB_GRADE Relation Name = Alias Name = SQLType = SQL_SHORT IsNullable = no SubType = 0 Length = 2 Scale = 0 Offset = 0 Null Offset = 0 Message Length = 2 Field No. 8 Field Name = JOB_COUNTRY Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = no SubType = 0 Length = 15 Scale = 0 Offset = 0 Null Offset = 0 Message Length = 15 Field No. 9 Field Name = SALARY Relation Name = Alias Name = SQLType = SQL_INT64 IsNullable = no SubType = 1 Length = 8 Scale = -2 Offset = 0 Null Offset = 0 Message Length = 8 Field No. 10 Field Name = FULL_NAME Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 37 Scale = 0 Offset = 0 Null Offset = 0 Message Length = 37 Field No. 11 Field Name = PREVIOUS_PHONE_EXT Relation Name = Alias Name = SQLType = SQL_VARYING IsNullable = yes SubType = 0 Length = 4 Scale = 0 Offset = 0 Null Offset = 0 Message Length = 4 Trigger Table = EMPLOYEE Trigger Type = Before @dd-mm-yy hh:mm:ss.zzzz:Execute Trigger my_employee_update @dd-mm-yy hh:mm:ss.zzzz:Old Field Values: Parameter 0: Field Name = EMP_NO Alias Name = SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Parameter 1: Field Name = FIRST_NAME Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = Robert Parameter 2: Field Name = LAST_NAME Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 20 Value = Nelson Parameter 3: Field Name = PHONE_EXT Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 250 Parameter 4: Field Name = HIRE_DATE Alias Name = SQLType = SQL_TIMESTAMP sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 8 Value = dd-mm-yy hh:mm:ss.zzzz Parameter 5: Field Name = DEPT_NO Alias Name = SQLType = SQL_TEXT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 3 Value = 600 Parameter 6: Field Name = JOB_CODE Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 5 Value = VP Parameter 7: Field Name = JOB_GRADE Alias Name = SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Parameter 8: Field Name = JOB_COUNTRY Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = USA Parameter 9: Field Name = SALARY Alias Name = SQLType = SQL_INT64 sub type = 0 Scale = -2 Charset = NONE Not Nullable Size = 8 Value = 105900 Parameter 10: Field Name = FULL_NAME Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 37 Value = Nelson, Robert Parameter 11: Field Name = PREVIOUS_PHONE_EXT Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = NULL @dd-mm-yy hh:mm:ss.zzzz:New Field Values: Column 0 Field Name = EMP_NO SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Column 1 Field Name = FIRST_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = Robert Column 2 Field Name = LAST_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 20 Value = Nelson Column 3 Field Name = PHONE_EXT SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 999 Column 4 Field Name = HIRE_DATE SQLType = SQL_TIMESTAMP sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 8 Value = dd-mm-yy hh:mm:ss.zzzz Column 5 Field Name = DEPT_NO SQLType = SQL_TEXT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 3 Value = 600 Column 6 Field Name = JOB_CODE SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 5 Value = VP Column 7 Field Name = JOB_GRADE SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Column 8 Field Name = JOB_COUNTRY SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = USA Column 9 Field Name = SALARY SQLType = SQL_INT64 sub type = 0 Scale = -2 Charset = NONE Not Nullable Size = 8 Value = 105900 Column 10 Field Name = FULL_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 37 Value = Nelson, Robert Column 11 Field Name = PREVIOUS_PHONE_EXT SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = NULL @dd-mm-yy hh:mm:ss.zzzz:New Field Values after trigger execution Column 0 Field Name = EMP_NO SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Column 1 Field Name = FIRST_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = Robert Column 2 Field Name = LAST_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 20 Value = Nelson Column 3 Field Name = PHONE_EXT SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 999 Column 4 Field Name = HIRE_DATE SQLType = SQL_TIMESTAMP sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 8 Value = dd-mm-yy hh:mm:ss.zzzz Column 5 Field Name = DEPT_NO SQLType = SQL_TEXT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 3 Value = 600 Column 6 Field Name = JOB_CODE SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 5 Value = VP Column 7 Field Name = JOB_GRADE SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Column 8 Field Name = JOB_COUNTRY SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = USA Column 9 Field Name = SALARY SQLType = SQL_INT64 sub type = 0 Scale = -2 Charset = NONE Not Nullable Size = 8 Value = 105900 Column 10 Field Name = FULL_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 37 Value = Nelson, Robert Column 11 Field Name = PREVIOUS_PHONE_EXT SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 250 @dd-mm-yy hh:mm:ss.zzzz:Execute Trigger my_employee_update @dd-mm-yy hh:mm:ss.zzzz:Old Field Values: Parameter 0: Field Name = EMP_NO Alias Name = SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Parameter 1: Field Name = FIRST_NAME Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = Robert Parameter 2: Field Name = LAST_NAME Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 20 Value = Nelson Parameter 3: Field Name = PHONE_EXT Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 999 Parameter 4: Field Name = HIRE_DATE Alias Name = SQLType = SQL_TIMESTAMP sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 8 Value = dd-mm-yy hh:mm:ss.zzzz Parameter 5: Field Name = DEPT_NO Alias Name = SQLType = SQL_TEXT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 3 Value = 600 Parameter 6: Field Name = JOB_CODE Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 5 Value = VP Parameter 7: Field Name = JOB_GRADE Alias Name = SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Parameter 8: Field Name = JOB_COUNTRY Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = USA Parameter 9: Field Name = SALARY Alias Name = SQLType = SQL_INT64 sub type = 0 Scale = -2 Charset = NONE Not Nullable Size = 8 Value = 105900 Parameter 10: Field Name = FULL_NAME Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 37 Value = Nelson, Robert Parameter 11: Field Name = PREVIOUS_PHONE_EXT Alias Name = SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 250 @dd-mm-yy hh:mm:ss.zzzz:New Field Values: Column 0 Field Name = EMP_NO SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Column 1 Field Name = FIRST_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = Robert Column 2 Field Name = LAST_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 20 Value = Nelson Column 3 Field Name = PHONE_EXT SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 250 Column 4 Field Name = HIRE_DATE SQLType = SQL_TIMESTAMP sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 8 Value = dd-mm-yy hh:mm:ss.zzzz Column 5 Field Name = DEPT_NO SQLType = SQL_TEXT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 3 Value = 600 Column 6 Field Name = JOB_CODE SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 5 Value = VP Column 7 Field Name = JOB_GRADE SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Column 8 Field Name = JOB_COUNTRY SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = USA Column 9 Field Name = SALARY SQLType = SQL_INT64 sub type = 0 Scale = -2 Charset = NONE Not Nullable Size = 8 Value = 105900 Column 10 Field Name = FULL_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 37 Value = Nelson, Robert Column 11 Field Name = PREVIOUS_PHONE_EXT SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 250 @dd-mm-yy hh:mm:ss.zzzz:New Field Values after trigger execution Column 0 Field Name = EMP_NO SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Column 1 Field Name = FIRST_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = Robert Column 2 Field Name = LAST_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 20 Value = Nelson Column 3 Field Name = PHONE_EXT SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 250 Column 4 Field Name = HIRE_DATE SQLType = SQL_TIMESTAMP sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 8 Value = dd-mm-yy hh:mm:ss.zzzz Column 5 Field Name = DEPT_NO SQLType = SQL_TEXT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 3 Value = 600 Column 6 Field Name = JOB_CODE SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 5 Value = VP Column 7 Field Name = JOB_GRADE SQLType = SQL_SHORT sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 2 Value = 2 Column 8 Field Name = JOB_COUNTRY SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Not Nullable Size = 15 Value = USA Column 9 Field Name = SALARY SQLType = SQL_INT64 sub type = 0 Scale = -2 Charset = NONE Not Nullable Size = 8 Value = 105900 Column 10 Field Name = FULL_NAME SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 37 Value = Nelson, Robert Column 11 Field Name = PREVIOUS_PHONE_EXT SQLType = SQL_VARYING sub type = 0 Scale = 0 Charset = NONE Nullable Size = 4 Value = 999 @dd-mm-yy hh:mm:ss.zzzz:Trigger my_employee_update: dispose called