ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/udr/udr/testsuite/Reference.log
Revision: 381
Committed: Sat Jan 15 00:06:22 2022 UTC (2 years, 2 months ago) by tony
File size: 30295 byte(s)
Log Message:
Release Candidate 1

File Contents

# Content
1 FB UDR Test Suite
2 Copyright MWA Software 2016-2021
3
4 Starting Tests
5 Client API Version = 4.0
6 Firebird Environment Variable = /opt/firebird4.0.1
7 Firebird Bin Directory = /opt/firebird4.0.1/bin
8 Firebird Conf Directory = /opt/firebird4.0.1/
9 Firebird Client Library Path = /opt/firebird4.0.1/lib/libfbclient.so
10 Running Test 01: Open the employee database and run a simple UDR Function
11 Row Count for Employee
12 SQL Params
13 SQLType =SQL_VARYING
14 sub type = 0
15 Field Name = TABLE_NAME
16 Scale = 0
17 Charset id = 0
18 Not Null
19 Size = 31
20 Value = EMPLOYEE
21
22 Employee Row Count = 42
23
24 SQL Params
25 SQLType =SQL_VARYING
26 sub type = 0
27 Field Name = TABLE_NAME
28 Scale = 0
29 Charset id = 0
30 Not Null
31 Size = 31
32 Value = DEPARTMENT
33
34 Dept Row Count = 21
35
36 SQL Params
37 SQLType =SQL_VARYING
38 sub type = 0
39 Field Name = TABLE_NAME
40 Scale = 0
41 Charset id = 0
42 Not Null
43 Size = 31
44 Value = BAD
45
46 Expected exception: Dynamic SQL Error
47 -SQL error code = -204
48 -Table unknown
49 -BAD
50 -At line 1, column 22
51
52 Row Count for Employee
53 SQL Params
54 SQLType =SQL_VARYING
55 sub type = 0
56 Field Name = TABLE_NAME
57 Scale = 0
58 Charset id = 0
59 Not Null
60 Size = 31
61 Value = EMPLOYEE
62
63 Employee Row Count = Expected exception: Empty query
64 Info returned = Hello World
65
66
67 ------------------------------------------------------
68 Running Test 02: Execute Procedure Tests
69 Salary and Name of Employee 24
70 SQL Params
71 SQLType =SQL_LONG
72 sub type = 0
73 Field Name = EMP_NO
74 Scale = 0
75 Charset id = 0
76 Nullable
77 Size = 2
78 Value = 24
79
80 Salary = 81810.19
81 Fisher, Pete
82
83
84
85 ------------------------------------------------------
86 Running Test 03: UDR Select Procedure Test
87 List Employees, salaries and accumulated salary
88 Nelson, Robert, Salary = 105900 Acc Salary = $105900
89 Young, Bruce, Salary = 97500 Acc Salary = $203400
90 Lambert, Kim, Salary = 102750 Acc Salary = $306150
91 Johnson, Leslie, Salary = 64635 Acc Salary = $370785
92 Forest, Phil, Salary = 75060 Acc Salary = $445845
93 Weston, K. J., Salary = 86292.94 Acc Salary = $532137.94
94 Lee, Terri, Salary = 53793 Acc Salary = $585930.94
95 Hall, Stewart, Salary = 69482.63 Acc Salary = $655413.57
96 Young, Katherine, Salary = 67241.25 Acc Salary = $722654.82
97 Papadopoulos, Chris, Salary = 89655 Acc Salary = $812309.82
98 Fisher, Pete, Salary = 81810.19 Acc Salary = $894120.01
99 Bennet, Ann, Salary = 22935 Acc Salary = $917055.01
100 De Souza, Roger, Salary = 69482.63 Acc Salary = $986537.64
101 Baldwin, Janet, Salary = 61637.81 Acc Salary = $1048175.45
102 Reeves, Roger, Salary = 33620.63 Acc Salary = $1081796.08
103 Stansbury, Willie, Salary = 39224.06 Acc Salary = $1121020.14
104 Phong, Leslie, Salary = 56034.38 Acc Salary = $1177054.52
105 Ramanathan, Ashok, Salary = 80689.5 Acc Salary = $1257744.02
106 Steadman, Walter, Salary = 116100 Acc Salary = $1373844.02
107 Nordstrom, Carol, Salary = 42742.5 Acc Salary = $1416586.52
108 Leung, Luke, Salary = 68805 Acc Salary = $1485391.52
109 O'Brien, Sue Anne, Salary = 31275 Acc Salary = $1516666.52
110 Burbank, Jennifer M., Salary = 53167.5 Acc Salary = $1569834.02
111 Sutherland, Claudia, Salary = 100914 Acc Salary = $1670748.02
112 Bishop, Dana, Salary = 62550 Acc Salary = $1733298.02
113 MacDonald, Mary S., Salary = 111262.5 Acc Salary = $1844560.52
114 Williams, Randy, Salary = 56295 Acc Salary = $1900855.52
115 Bender, Oliver H., Salary = 212850 Acc Salary = $2113705.52
116 Cook, Kevin, Salary = 111262.5 Acc Salary = $2224968.02
117 Brown, Kelly, Salary = 27000 Acc Salary = $2251968.02
118 Ichida, Yuki, Salary = 6000000 Acc Salary = $8251968.02
119 Page, Mary, Salary = 48000 Acc Salary = $8299968.02
120 Parker, Bill, Salary = 35000 Acc Salary = $8334968.02
121 Yamamoto, Takashi, Salary = 7480000 Acc Salary = $15814968.02
122 Ferrari, Roberto, Salary = 33000 Acc Salary = $15847968.02
123 Yanowski, Michael, Salary = 44000 Acc Salary = $15891968.02
124 Glon, Jacques, Salary = 38500 Acc Salary = $15930468.02
125 Johnson, Scott, Salary = 60000 Acc Salary = $15990468.02
126 Green, T.J., Salary = 36000 Acc Salary = $16026468.02
127 Osborne, Pierre, Salary = 110000 Acc Salary = $16136468.02
128 Montgomery, John, Salary = 35000 Acc Salary = $16171468.02
129 Guckenheimer, Mark, Salary = 32000 Acc Salary = $16203468.02
130
131 Dump text file - testsuite.conf
132 [Controller]
133 LogOptions = [loLogFunctions, loLogProcedures, loLogTriggers, loDetails,
134 loModifyQueries, loReadOnlyQueries]
135 EOF
136
137
138
139 ------------------------------------------------------
140 Running Test 04: UDR Trigger Test
141 Update EMPLOYEE 2
142
143
144
145 ------------------------------------------------------
146 Test Suite Ends
147 Server Side Log
148 ---------------
149 @dd-mm-yy hh:mm:ss.zzzz:Registering Function row_count
150 @dd-mm-yy hh:mm:ss.zzzz:Registering Function bad_row_count
151 @dd-mm-yy hh:mm:ss.zzzz:Registering Function return_info
152 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure test_proc
153 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure select_proc
154 @dd-mm-yy hh:mm:ss.zzzz:Registering Procedure read_txt
155 @dd-mm-yy hh:mm:ss.zzzz:Registering Trigger my_employee_update
156 @dd-mm-yy hh:mm:ss.zzzz:Reading Configuration File: testsuite.conf
157 @dd-mm-yy hh:mm:ss.zzzz:LogFileNameTemplate = serverside.log
158 @dd-mm-yy hh:mm:ss.zzzz:ForceWriteLogEntries = false
159 @dd-mm-yy hh:mm:ss.zzzz:ThreadSafeLogging = false
160 @dd-mm-yy hh:mm:ss.zzzz:Malformed LogOptions Config string "[loLogFunctions, loLogProcedures, loLogTriggers, loDetails," at position 60
161 @dd-mm-yy hh:mm:ss.zzzz:LogOptions = [loLogFunctions,loLogProcedures,loLogTriggers,loDetails]
162 @13/1/2022 23:18:09.8100:Setup Function row_count
163 @13/1/2022 23:18:09.8110:Routine Metadata
164 Package Name =
165 Name = MYROWCOUNT
166 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
167 Body =
168 Input Metadata:
169 Field Count = 1
170 Alignment = 2
171 Aligned Length = 36
172 Field No. 0
173 Field Name = TABLE_NAME
174 Relation Name =
175 Alias Name = TABLE_NAME
176 SQLType = SQL_VARYING
177 IsNullable = no
178 SubType = 0
179 Length = 31
180 Scale = 0
181 Offset = 0
182 Null Offset = 34
183 Message Length = 31
184
185 Output Metadata:
186 Field Count = 1
187 Alignment = 4
188 Aligned Length = 8
189 Field No. 0
190 Field Name = MYROWCOUNT
191 Relation Name =
192 Alias Name = MYROWCOUNT
193 SQLType = SQL_LONG
194 IsNullable = yes
195 SubType = 0
196 Length = 4
197 Scale = 0
198 Offset = 0
199 Null Offset = 4
200 Message Length = 4
201
202 @13/1/2022 23:18:09.8160:Function row_count created
203 @13/1/2022 23:18:09.8160:Package Name =
204 Name = MYROWCOUNT
205 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
206 Body =
207 Input Metadata:
208 Field Count = 1
209 Alignment = 2
210 Aligned Length = 36
211 Field No. 0
212 Field Name = TABLE_NAME
213 Relation Name =
214 Alias Name = TABLE_NAME
215 SQLType = SQL_VARYING
216 IsNullable = no
217 SubType = 0
218 Length = 31
219 Scale = 0
220 Offset = 0
221 Null Offset = 34
222 Message Length = 31
223
224 Output Metadata:
225 Field Count = 1
226 Alignment = 4
227 Aligned Length = 8
228 Field No. 0
229 Field Name = MYROWCOUNT
230 Relation Name =
231 Alias Name = MYROWCOUNT
232 SQLType = SQL_LONG
233 IsNullable = yes
234 SubType = 0
235 Length = 4
236 Scale = 0
237 Offset = 0
238 Null Offset = 4
239 Message Length = 4
240
241 @13/1/2022 23:18:09.8170:Execute Function row_count
242 @13/1/2022 23:18:09.8180:External Context:
243 Attachment ID = 2554
244 Transaction ID = 8098
245 User Name = SYSDBA
246 Database Name = employee
247 Client Character Set = UTF8
248
249 @13/1/2022 23:18:09.8180:Input Parameters
250 Parameter 0:
251 Field Name = TABLE_NAME
252 Alias Name = TABLE_NAME
253 SQLType = SQL_VARYING
254 sub type = 0
255 Scale = 0
256 Charset = NONE
257 Not Nullable
258 Size = 31
259 Value = EMPLOYEE
260
261 @13/1/2022 23:18:09.8230:Output Parameters with data
262 Column 0
263 Field Name =
264 SQLType = SQL_LONG
265 sub type = 0
266 Scale = 0
267 Charset = NONE
268 Nullable
269 Size = 4
270 Value = 42
271
272 @13/1/2022 23:18:09.8230:Function row_count: dispose called
273 @13/1/2022 23:18:09.8230:Setup Function row_count
274 @13/1/2022 23:18:09.8240:Routine Metadata
275 Package Name =
276 Name = MYROWCOUNT
277 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
278 Body =
279 Input Metadata:
280 Field Count = 1
281 Alignment = 2
282 Aligned Length = 36
283 Field No. 0
284 Field Name = TABLE_NAME
285 Relation Name =
286 Alias Name = TABLE_NAME
287 SQLType = SQL_VARYING
288 IsNullable = no
289 SubType = 0
290 Length = 31
291 Scale = 0
292 Offset = 0
293 Null Offset = 34
294 Message Length = 31
295
296 Output Metadata:
297 Field Count = 1
298 Alignment = 4
299 Aligned Length = 8
300 Field No. 0
301 Field Name = MYROWCOUNT
302 Relation Name =
303 Alias Name = MYROWCOUNT
304 SQLType = SQL_LONG
305 IsNullable = yes
306 SubType = 0
307 Length = 4
308 Scale = 0
309 Offset = 0
310 Null Offset = 4
311 Message Length = 4
312
313 @13/1/2022 23:18:09.8280:Function row_count created
314 @13/1/2022 23:18:09.8290:Package Name =
315 Name = MYROWCOUNT
316 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
317 Body =
318 Input Metadata:
319 Field Count = 1
320 Alignment = 2
321 Aligned Length = 36
322 Field No. 0
323 Field Name = TABLE_NAME
324 Relation Name =
325 Alias Name = TABLE_NAME
326 SQLType = SQL_VARYING
327 IsNullable = no
328 SubType = 0
329 Length = 31
330 Scale = 0
331 Offset = 0
332 Null Offset = 34
333 Message Length = 31
334
335 Output Metadata:
336 Field Count = 1
337 Alignment = 4
338 Aligned Length = 8
339 Field No. 0
340 Field Name = MYROWCOUNT
341 Relation Name =
342 Alias Name = MYROWCOUNT
343 SQLType = SQL_LONG
344 IsNullable = yes
345 SubType = 0
346 Length = 4
347 Scale = 0
348 Offset = 0
349 Null Offset = 4
350 Message Length = 4
351
352 @13/1/2022 23:18:09.8300:Execute Function row_count
353 @13/1/2022 23:18:09.8310:External Context:
354 Attachment ID = 2554
355 Transaction ID = 8098
356 User Name = SYSDBA
357 Database Name = employee
358 Client Character Set = UTF8
359
360 @13/1/2022 23:18:09.8310:Input Parameters
361 Parameter 0:
362 Field Name = TABLE_NAME
363 Alias Name = TABLE_NAME
364 SQLType = SQL_VARYING
365 sub type = 0
366 Scale = 0
367 Charset = NONE
368 Not Nullable
369 Size = 31
370 Value = DEPARTMENT
371
372 @13/1/2022 23:18:09.8340:Output Parameters with data
373 Column 0
374 Field Name =
375 SQLType = SQL_LONG
376 sub type = 0
377 Scale = 0
378 Charset = NONE
379 Nullable
380 Size = 4
381 Value = 21
382
383 @13/1/2022 23:18:09.8340:Function row_count: dispose called
384 @13/1/2022 23:18:09.8340:Setup Function row_count
385 @13/1/2022 23:18:09.8350:Routine Metadata
386 Package Name =
387 Name = MYROWCOUNT
388 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
389 Body =
390 Input Metadata:
391 Field Count = 1
392 Alignment = 2
393 Aligned Length = 36
394 Field No. 0
395 Field Name = TABLE_NAME
396 Relation Name =
397 Alias Name = TABLE_NAME
398 SQLType = SQL_VARYING
399 IsNullable = no
400 SubType = 0
401 Length = 31
402 Scale = 0
403 Offset = 0
404 Null Offset = 34
405 Message Length = 31
406
407 Output Metadata:
408 Field Count = 1
409 Alignment = 4
410 Aligned Length = 8
411 Field No. 0
412 Field Name = MYROWCOUNT
413 Relation Name =
414 Alias Name = MYROWCOUNT
415 SQLType = SQL_LONG
416 IsNullable = yes
417 SubType = 0
418 Length = 4
419 Scale = 0
420 Offset = 0
421 Null Offset = 4
422 Message Length = 4
423
424 @13/1/2022 23:18:09.8390:Function row_count created
425 @13/1/2022 23:18:09.8400:Package Name =
426 Name = MYROWCOUNT
427 Entry Point = fbudrtests!row_count (fbudrtests,row_count,)
428 Body =
429 Input Metadata:
430 Field Count = 1
431 Alignment = 2
432 Aligned Length = 36
433 Field No. 0
434 Field Name = TABLE_NAME
435 Relation Name =
436 Alias Name = TABLE_NAME
437 SQLType = SQL_VARYING
438 IsNullable = no
439 SubType = 0
440 Length = 31
441 Scale = 0
442 Offset = 0
443 Null Offset = 34
444 Message Length = 31
445
446 Output Metadata:
447 Field Count = 1
448 Alignment = 4
449 Aligned Length = 8
450 Field No. 0
451 Field Name = MYROWCOUNT
452 Relation Name =
453 Alias Name = MYROWCOUNT
454 SQLType = SQL_LONG
455 IsNullable = yes
456 SubType = 0
457 Length = 4
458 Scale = 0
459 Offset = 0
460 Null Offset = 4
461 Message Length = 4
462
463 @13/1/2022 23:18:09.8400:Execute Function row_count
464 @13/1/2022 23:18:09.8410:External Context:
465 Attachment ID = 2554
466 Transaction ID = 8098
467 User Name = SYSDBA
468 Database Name = employee
469 Client Character Set = UTF8
470
471 @13/1/2022 23:18:09.8410:Input Parameters
472 Parameter 0:
473 Field Name = TABLE_NAME
474 Alias Name = TABLE_NAME
475 SQLType = SQL_VARYING
476 sub type = 0
477 Scale = 0
478 Charset = NONE
479 Not Nullable
480 Size = 31
481 Value = BAD
482
483 @13/1/2022 23:18:09.8430:Exception raised
484 SQLCODE: -999
485 Engine Code: 335544569
486 Dynamic SQL Error
487 -SQL error code = -204
488 -Table unknown
489 -BAD
490 -At line 1, column 22 When Executing: Select count(*) from BAD
491 @13/1/2022 23:18:09.8430:Function row_count: dispose called
492 @13/1/2022 23:18:09.8640:Setup Function bad_row_count
493 @13/1/2022 23:18:09.8670:Routine Metadata
494 Package Name =
495 Name = BADROWCOUNT
496 Entry Point = fbudrtests!bad_row_count (fbudrtests,bad_row_count,)
497 Body =
498 Input Metadata:
499 Field Count = 1
500 Alignment = 2
501 Aligned Length = 36
502 Field No. 0
503 Field Name = TABLE_NAME
504 Relation Name =
505 Alias Name = TABLE_NAME
506 SQLType = SQL_VARYING
507 IsNullable = no
508 SubType = 0
509 Length = 31
510 Scale = 0
511 Offset = 0
512 Null Offset = 34
513 Message Length = 31
514
515 Output Metadata:
516 Field Count = 1
517 Alignment = 4
518 Aligned Length = 8
519 Field No. 0
520 Field Name = BADROWCOUNT
521 Relation Name =
522 Alias Name = BADROWCOUNT
523 SQLType = SQL_LONG
524 IsNullable = yes
525 SubType = 0
526 Length = 4
527 Scale = 0
528 Offset = 0
529 Null Offset = 4
530 Message Length = 4
531
532 @13/1/2022 23:18:09.8720:Function bad_row_count created
533 @13/1/2022 23:18:09.8730:Package Name =
534 Name = BADROWCOUNT
535 Entry Point = fbudrtests!bad_row_count (fbudrtests,bad_row_count,)
536 Body =
537 Input Metadata:
538 Field Count = 1
539 Alignment = 2
540 Aligned Length = 36
541 Field No. 0
542 Field Name = TABLE_NAME
543 Relation Name =
544 Alias Name = TABLE_NAME
545 SQLType = SQL_VARYING
546 IsNullable = no
547 SubType = 0
548 Length = 31
549 Scale = 0
550 Offset = 0
551 Null Offset = 34
552 Message Length = 31
553
554 Output Metadata:
555 Field Count = 1
556 Alignment = 4
557 Aligned Length = 8
558 Field No. 0
559 Field Name = BADROWCOUNT
560 Relation Name =
561 Alias Name = BADROWCOUNT
562 SQLType = SQL_LONG
563 IsNullable = yes
564 SubType = 0
565 Length = 4
566 Scale = 0
567 Offset = 0
568 Null Offset = 4
569 Message Length = 4
570
571 @13/1/2022 23:18:09.8740:Execute Function bad_row_count
572 @13/1/2022 23:18:09.8750:External Context:
573 Attachment ID = 2554
574 Transaction ID = 8105
575 User Name = SYSDBA
576 Database Name = employee
577 Client Character Set = UTF8
578
579 @13/1/2022 23:18:09.8760:Input Parameters
580 Parameter 0:
581 Field Name = TABLE_NAME
582 Alias Name = TABLE_NAME
583 SQLType = SQL_VARYING
584 sub type = 0
585 Scale = 0
586 Charset = NONE
587 Not Nullable
588 Size = 31
589 Value = EMPLOYEE
590
591 @13/1/2022 23:18:09.8760:Exception raised
592 Empty query
593 @13/1/2022 23:18:09.8760:Function bad_row_count: dispose called
594 @13/1/2022 23:18:09.8960:Setup Function return_info
595 @13/1/2022 23:18:09.8970:Routine Metadata
596 Package Name =
597 Name = RETURNINFO
598 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
599 Body =
600 Output Metadata:
601 Field Count = 1
602 Alignment = 2
603 Aligned Length = 36
604 Field No. 0
605 Field Name = RETURNINFO
606 Relation Name =
607 Alias Name = RETURNINFO
608 SQLType = SQL_VARYING
609 IsNullable = yes
610 SubType = 0
611 Length = 32
612 Scale = 0
613 Offset = 0
614 Null Offset = 34
615 Message Length = 32
616
617 @13/1/2022 23:18:09.9000:Function return_info created
618 @13/1/2022 23:18:09.9010:Package Name =
619 Name = RETURNINFO
620 Entry Point = fbudrtests!return_info!Hello World (fbudrtests,return_info,Hello World)
621 Body =
622 Output Metadata:
623 Field Count = 1
624 Alignment = 2
625 Aligned Length = 36
626 Field No. 0
627 Field Name = RETURNINFO
628 Relation Name =
629 Alias Name = RETURNINFO
630 SQLType = SQL_VARYING
631 IsNullable = yes
632 SubType = 0
633 Length = 32
634 Scale = 0
635 Offset = 0
636 Null Offset = 34
637 Message Length = 32
638
639 @13/1/2022 23:18:09.9010:Execute Function return_info
640 @13/1/2022 23:18:09.9020:External Context:
641 Attachment ID = 2554
642 Transaction ID = 8110
643 User Name = SYSDBA
644 Database Name = employee
645 Client Character Set = UTF8
646
647 @13/1/2022 23:18:09.9020:Output Parameters with data
648 Column 0
649 Field Name =
650 SQLType = SQL_VARYING
651 sub type = 0
652 Scale = 0
653 Charset = NONE
654 Nullable
655 Size = 32
656 Value = Hello World
657
658 @13/1/2022 23:18:09.9020:Function return_info: dispose called
659 @13/1/2022 23:18:11.0170:Setup Procedure test_proc
660 @13/1/2022 23:18:11.0180:Routine Metadata
661 Package Name =
662 Name = MYTESTPROC
663 Entry Point = fbudrtests!test_proc (fbudrtests,test_proc,)
664 Body =
665 Input Metadata:
666 Field Count = 1
667 Alignment = 4
668 Aligned Length = 8
669 Field No. 0
670 Field Name = EMP_NO
671 Relation Name =
672 Alias Name = EMP_NO
673 SQLType = SQL_LONG
674 IsNullable = no
675 SubType = 0
676 Length = 4
677 Scale = 0
678 Offset = 0
679 Null Offset = 4
680 Message Length = 4
681
682 Output Metadata:
683 Field Count = 2
684 Alignment = 8
685 Aligned Length = 56
686 Field No. 0
687 Field Name = SALARY
688 Relation Name = MYTESTPROC
689 Alias Name = SALARY
690 SQLType = SQL_INT64
691 IsNullable = yes
692 SubType = 1
693 Length = 8
694 Scale = -2
695 Offset = 0
696 Null Offset = 8
697 Message Length = 8
698 Field No. 1
699 Field Name = FULLNAME
700 Relation Name = MYTESTPROC
701 Alias Name = FULLNAME
702 SQLType = SQL_VARYING
703 IsNullable = yes
704 SubType = 0
705 Length = 36
706 Scale = 0
707 Offset = 10
708 Null Offset = 48
709 Message Length = 36
710
711 @13/1/2022 23:18:11.0280:Open Execute Procedure test_proc
712 @13/1/2022 23:18:11.0290:External Context:
713 Attachment ID = 2557
714 Transaction ID = 8122
715 User Name = SYSDBA
716 Database Name = employee
717 Client Character Set = UTF8
718
719 @13/1/2022 23:18:11.0290:Input Parameters
720 Parameter 0:
721 Field Name = EMP_NO
722 Alias Name = EMP_NO
723 SQLType = SQL_LONG
724 sub type = 0
725 Scale = 0
726 Charset = NONE
727 Not Nullable
728 Size = 4
729 Value = 24
730
731 @13/1/2022 23:18:11.0300:Output Parameters
732 Column 0
733 Field Name = SALARY
734 SQLType = SQL_INT64
735 sub type = 0
736 Scale = -2
737 Charset = NONE
738 Nullable
739 Size = 8
740 Value = NULL
741 Column 1
742 Field Name = FULLNAME
743 SQLType = SQL_VARYING
744 sub type = 0
745 Scale = 0
746 Charset = NONE
747 Nullable
748 Size = 36
749 Value = NULL
750
751 @13/1/2022 23:18:11.0340:Procedure test_proc: dispose called with refcount = 2
752 @13/1/2022 23:18:11.0350:Output Parameters with data
753 Column 0
754 Field Name = SALARY
755 SQLType = SQL_INT64
756 sub type = 0
757 Scale = -2
758 Charset = NONE
759 Nullable
760 Size = 8
761 Value = 81810.19
762 Column 1
763 Field Name = FULLNAME
764 SQLType = SQL_VARYING
765 sub type = 0
766 Scale = 0
767 Charset = NONE
768 Nullable
769 Size = 36
770 Value = Fisher, Pete
771
772 @13/1/2022 23:18:11.0350:Procedure test_proc: dispose called with refcount = 1
773 @13/1/2022 23:18:12.0750:Setup Procedure select_proc
774 @13/1/2022 23:18:12.0790:Routine Metadata
775 Package Name =
776 Name = MYSELECTPROC
777 Entry Point = fbudrtests!select_proc (fbudrtests,select_proc,)
778 Body =
779 Output Metadata:
780 Field Count = 3
781 Alignment = 8
782 Aligned Length = 72
783 Field No. 0
784 Field Name = FULLNAME
785 Relation Name = MYSELECTPROC
786 Alias Name = FULLNAME
787 SQLType = SQL_VARYING
788 IsNullable = yes
789 SubType = 0
790 Length = 36
791 Scale = 0
792 Offset = 0
793 Null Offset = 38
794 Message Length = 36
795 Field No. 1
796 Field Name = SALARY
797 Relation Name = MYSELECTPROC
798 Alias Name = SALARY
799 SQLType = SQL_INT64
800 IsNullable = yes
801 SubType = 1
802 Length = 8
803 Scale = -2
804 Offset = 40
805 Null Offset = 48
806 Message Length = 8
807 Field No. 2
808 Field Name = ACCSALARY
809 Relation Name = MYSELECTPROC
810 Alias Name = ACCSALARY
811 SQLType = SQL_INT64
812 IsNullable = yes
813 SubType = 1
814 Length = 8
815 Scale = -2
816 Offset = 56
817 Null Offset = 64
818 Message Length = 8
819
820 @13/1/2022 23:18:12.0870:Open Select Procedure select_proc
821 @13/1/2022 23:18:12.0880:External Context:
822 Attachment ID = 2560
823 Transaction ID = 8132
824 User Name = SYSDBA
825 Database Name = employee
826 Client Character Set = UTF8
827
828 @13/1/2022 23:18:12.0920:Output Parameters
829 Column 0
830 Field Name = FULLNAME
831 SQLType = SQL_VARYING
832 sub type = 0
833 Scale = 0
834 Charset = NONE
835 Nullable
836 Size = 36
837 Value = NULL
838 Column 1
839 Field Name = SALARY
840 SQLType = SQL_INT64
841 sub type = 0
842 Scale = -2
843 Charset = NONE
844 Nullable
845 Size = 8
846 Value = NULL
847 Column 2
848 Field Name = ACCSALARY
849 SQLType = SQL_INT64
850 sub type = 0
851 Scale = -2
852 Charset = NONE
853 Nullable
854 Size = 8
855 Value = NULL
856
857 @13/1/2022 23:18:12.0920:Procedure select_proc: dispose called with refcount = 2
858 @13/1/2022 23:18:12.1000:Procedure select_proc: dispose called with refcount = 1
859 @13/1/2022 23:18:12.1260:Setup Procedure read_txt
860 @13/1/2022 23:18:12.1270:Routine Metadata
861 Package Name =
862 Name = MYREADTEXT
863 Entry Point = fbudrtests!read_txt (fbudrtests,read_txt,)
864 Body =
865 Input Metadata:
866 Field Count = 1
867 Alignment = 2
868 Aligned Length = 204
869 Field No. 0
870 Field Name = PATH
871 Relation Name =
872 Alias Name = PATH
873 SQLType = SQL_VARYING
874 IsNullable = no
875 SubType = 0
876 Length = 200
877 Scale = 0
878 Offset = 0
879 Null Offset = 202
880 Message Length = 200
881
882 Output Metadata:
883 Field Count = 1
884 Alignment = 2
885 Aligned Length = 3004
886 Field No. 0
887 Field Name = TEXT
888 Relation Name = MYREADTEXT
889 Alias Name = TEXT
890 SQLType = SQL_VARYING
891 IsNullable = no
892 SubType = 0
893 Length = 3000
894 Scale = 0
895 Offset = 0
896 Null Offset = 3002
897 Message Length = 3000
898
899 @13/1/2022 23:18:12.1360:Open Select Procedure read_txt
900 @13/1/2022 23:18:12.1370:External Context:
901 Attachment ID = 2560
902 Transaction ID = 8139
903 User Name = SYSDBA
904 Database Name = employee
905 Client Character Set = UTF8
906
907 @13/1/2022 23:18:12.1380:Input Parameters
908 Parameter 0:
909 Field Name = PATH
910 Alias Name = PATH
911 SQLType = SQL_VARYING
912 sub type = 0
913 Scale = 0
914 Charset = NONE
915 Not Nullable
916 Size = 200
917 Value = testsuite.conf
918
919 @13/1/2022 23:18:12.1380:Read Text called in directory /home/tony/lazarus/2.2/otherComponents/fbintf/udr/testsuite
920 @13/1/2022 23:18:12.1380:Reading from testsuite.conf
921 @13/1/2022 23:18:12.1380:Output Parameters
922 Column 0
923 Field Name = TEXT
924 SQLType = SQL_VARYING
925 sub type = 0
926 Scale = 0
927 Charset = NONE
928 Not Nullable
929 Size = 3000
930 Value =
931
932 @13/1/2022 23:18:12.1380:Procedure read_txt: dispose called with refcount = 2
933 @13/1/2022 23:18:12.1390:Procedure read_txt: dispose called with refcount = 1
934 @13/1/2022 23:18:13.4310:Setup Trigger my_employee_update
935 @13/1/2022 23:18:13.4410:Routine Metadata
936 Package Name =
937 Name = MyEmployeeUpdate
938 Entry Point = fbudrtests!my_employee_update (fbudrtests,my_employee_update,)
939 Body =
940 Trigger Metadata:
941 Field Count = 12
942 Alignment = 8
943 Aligned Length = 176
944 Field No. 0
945 Field Name = EMP_NO
946 Relation Name = EMPLOYEE
947 Alias Name = EMP_NO
948 SQLType = SQL_SHORT
949 IsNullable = no
950 SubType = 0
951 Length = 2
952 Scale = 0
953 Offset = 0
954 Null Offset = 2
955 Message Length = 2
956 Field No. 1
957 Field Name = FIRST_NAME
958 Relation Name = EMPLOYEE
959 Alias Name = FIRST_NAME
960 SQLType = SQL_VARYING
961 IsNullable = no
962 SubType = 0
963 Length = 15
964 Scale = 0
965 Offset = 4
966 Null Offset = 22
967 Message Length = 15
968 Field No. 2
969 Field Name = LAST_NAME
970 Relation Name = EMPLOYEE
971 Alias Name = LAST_NAME
972 SQLType = SQL_VARYING
973 IsNullable = no
974 SubType = 0
975 Length = 20
976 Scale = 0
977 Offset = 24
978 Null Offset = 46
979 Message Length = 20
980 Field No. 3
981 Field Name = PHONE_EXT
982 Relation Name = EMPLOYEE
983 Alias Name = PHONE_EXT
984 SQLType = SQL_VARYING
985 IsNullable = yes
986 SubType = 0
987 Length = 4
988 Scale = 0
989 Offset = 48
990 Null Offset = 54
991 Message Length = 4
992 Field No. 4
993 Field Name = HIRE_DATE
994 Relation Name = EMPLOYEE
995 Alias Name = HIRE_DATE
996 SQLType = SQL_TIMESTAMP
997 IsNullable = no
998 SubType = 0
999 Length = 8
1000 Scale = 0
1001 Offset = 56
1002 Null Offset = 64
1003 Message Length = 8
1004 Field No. 5
1005 Field Name = DEPT_NO
1006 Relation Name = EMPLOYEE
1007 Alias Name = DEPT_NO
1008 SQLType = SQL_TEXT
1009 IsNullable = no
1010 SubType = 0
1011 Length = 3
1012 Scale = 0
1013 Offset = 66
1014 Null Offset = 70
1015 Message Length = 3
1016 Field No. 6
1017 Field Name = JOB_CODE
1018 Relation Name = EMPLOYEE
1019 Alias Name = JOB_CODE
1020 SQLType = SQL_VARYING
1021 IsNullable = no
1022 SubType = 0
1023 Length = 5
1024 Scale = 0
1025 Offset = 72
1026 Null Offset = 80
1027 Message Length = 5
1028 Field No. 7
1029 Field Name = JOB_GRADE
1030 Relation Name = EMPLOYEE
1031 Alias Name = JOB_GRADE
1032 SQLType = SQL_SHORT
1033 IsNullable = no
1034 SubType = 0
1035 Length = 2
1036 Scale = 0
1037 Offset = 82
1038 Null Offset = 84
1039 Message Length = 2
1040 Field No. 8
1041 Field Name = JOB_COUNTRY
1042 Relation Name = EMPLOYEE
1043 Alias Name = JOB_COUNTRY
1044 SQLType = SQL_VARYING
1045 IsNullable = no
1046 SubType = 0
1047 Length = 15
1048 Scale = 0
1049 Offset = 86
1050 Null Offset = 104
1051 Message Length = 15
1052 Field No. 9
1053 Field Name = SALARY
1054 Relation Name = EMPLOYEE
1055 Alias Name = SALARY
1056 SQLType = SQL_INT64
1057 IsNullable = no
1058 SubType = 1
1059 Length = 8
1060 Scale = -2
1061 Offset = 112
1062 Null Offset = 120
1063 Message Length = 8
1064 Field No. 10
1065 Field Name = FULL_NAME
1066 Relation Name = EMPLOYEE
1067 Alias Name = FULL_NAME
1068 SQLType = SQL_VARYING
1069 IsNullable = yes
1070 SubType = 0
1071 Length = 37
1072 Scale = 0
1073 Offset = 122
1074 Null Offset = 162
1075 Message Length = 37
1076 Field No. 11
1077 Field Name = PREVIOUS_PHONE_EXT
1078 Relation Name = EMPLOYEE
1079 Alias Name = PREVIOUS_PHONE_EXT
1080 SQLType = SQL_VARYING
1081 IsNullable = yes
1082 SubType = 0
1083 Length = 4
1084 Scale = 0
1085 Offset = 164
1086 Null Offset = 170
1087 Message Length = 4
1088 Trigger Table = EMPLOYEE
1089 Trigger Type = Before
1090
1091 @13/1/2022 23:18:13.4490:Execute Trigger my_employee_update
1092 @13/1/2022 23:18:13.4520:Old Field Values:
1093 Parameter 0:
1094 Field Name = EMP_NO
1095 Alias Name = EMP_NO
1096 SQLType = SQL_SHORT
1097 sub type = 0
1098 Scale = 0
1099 Charset = NONE
1100 Not Nullable
1101 Size = 2
1102 Value = 2
1103 Parameter 1:
1104 Field Name = FIRST_NAME
1105 Alias Name = FIRST_NAME
1106 SQLType = SQL_VARYING
1107 sub type = 0
1108 Scale = 0
1109 Charset = NONE
1110 Not Nullable
1111 Size = 15
1112 Value =
1113 Parameter 2:
1114 Field Name = LAST_NAME
1115 Alias Name = LAST_NAME
1116 SQLType = SQL_VARYING
1117 sub type = 0
1118 Scale = 0
1119 Charset = NONE
1120 Not Nullable
1121 Size = 20
1122 Value =
1123 Parameter 3:
1124 Field Name = PHONE_EXT
1125 Alias Name = PHONE_EXT
1126 SQLType = SQL_VARYING
1127 sub type = 0
1128 Scale = 0
1129 Charset = NONE
1130 Nullable
1131 Size = 4
1132 Value = 250
1133 Parameter 4:
1134 Field Name = HIRE_DATE
1135 Alias Name = HIRE_DATE
1136 SQLType = SQL_TIMESTAMP
1137 sub type = 0
1138 Scale = 0
1139 Charset = NONE
1140 Not Nullable
1141 Size = 8
1142 Value = 17/11/1858 00:00:00.0000
1143 Parameter 5:
1144 Field Name = DEPT_NO
1145 Alias Name = DEPT_NO
1146 SQLType = SQL_TEXT
1147 sub type = 0
1148 Scale = 0
1149 Charset = NONE
1150 Not Nullable
1151 Size = 3
1152 Value =
1153 Parameter 6:
1154 Field Name = JOB_CODE
1155 Alias Name = JOB_CODE
1156 SQLType = SQL_VARYING
1157 sub type = 0
1158 Scale = 0
1159 Charset = NONE
1160 Not Nullable
1161 Size = 5
1162 Value =
1163 Parameter 7:
1164 Field Name = JOB_GRADE
1165 Alias Name = JOB_GRADE
1166 SQLType = SQL_SHORT
1167 sub type = 0
1168 Scale = 0
1169 Charset = NONE
1170 Not Nullable
1171 Size = 2
1172 Value = 0
1173 Parameter 8:
1174 Field Name = JOB_COUNTRY
1175 Alias Name = JOB_COUNTRY
1176 SQLType = SQL_VARYING
1177 sub type = 0
1178 Scale = 0
1179 Charset = NONE
1180 Not Nullable
1181 Size = 15
1182 Value =
1183 Parameter 9:
1184 Field Name = SALARY
1185 Alias Name = SALARY
1186 SQLType = SQL_INT64
1187 sub type = 0
1188 Scale = -2
1189 Charset = NONE
1190 Not Nullable
1191 Size = 8
1192 Value = 0
1193 Parameter 10:
1194 Field Name = FULL_NAME
1195 Alias Name = FULL_NAME
1196 SQLType = SQL_VARYING
1197 sub type = 0
1198 Scale = 0
1199 Charset = NONE
1200 Nullable
1201 Size = 37
1202 Value = NULL
1203 Parameter 11:
1204 Field Name = PREVIOUS_PHONE_EXT
1205 Alias Name = PREVIOUS_PHONE_EXT
1206 SQLType = SQL_VARYING
1207 sub type = 0
1208 Scale = 0
1209 Charset = NONE
1210 Nullable
1211 Size = 4
1212 Value = NULL
1213
1214 @13/1/2022 23:18:13.4550:New Field Values:
1215 Column 0
1216 Field Name = EMP_NO
1217 SQLType = SQL_SHORT
1218 sub type = 0
1219 Scale = 0
1220 Charset = NONE
1221 Nullable
1222 Size = 2
1223 Value = NULL
1224 Column 1
1225 Field Name = FIRST_NAME
1226 SQLType = SQL_VARYING
1227 sub type = 0
1228 Scale = 0
1229 Charset = NONE
1230 Nullable
1231 Size = 15
1232 Value = NULL
1233 Column 2
1234 Field Name = LAST_NAME
1235 SQLType = SQL_VARYING
1236 sub type = 0
1237 Scale = 0
1238 Charset = NONE
1239 Nullable
1240 Size = 20
1241 Value = NULL
1242 Column 3
1243 Field Name = PHONE_EXT
1244 SQLType = SQL_VARYING
1245 sub type = 0
1246 Scale = 0
1247 Charset = NONE
1248 Nullable
1249 Size = 4
1250 Value = 999
1251 Column 4
1252 Field Name = HIRE_DATE
1253 SQLType = SQL_TIMESTAMP
1254 sub type = 0
1255 Scale = 0
1256 Charset = NONE
1257 Nullable
1258 Size = 8
1259 Value = NULL
1260 Column 5
1261 Field Name = DEPT_NO
1262 SQLType = SQL_TEXT
1263 sub type = 0
1264 Scale = 0
1265 Charset = NONE
1266 Nullable
1267 Size = 3
1268 Value = NULL
1269 Column 6
1270 Field Name = JOB_CODE
1271 SQLType = SQL_VARYING
1272 sub type = 0
1273 Scale = 0
1274 Charset = NONE
1275 Nullable
1276 Size = 5
1277 Value = NULL
1278 Column 7
1279 Field Name = JOB_GRADE
1280 SQLType = SQL_SHORT
1281 sub type = 0
1282 Scale = 0
1283 Charset = NONE
1284 Nullable
1285 Size = 2
1286 Value = NULL
1287 Column 8
1288 Field Name = JOB_COUNTRY
1289 SQLType = SQL_VARYING
1290 sub type = 0
1291 Scale = 0
1292 Charset = NONE
1293 Nullable
1294 Size = 15
1295 Value = NULL
1296 Column 9
1297 Field Name = SALARY
1298 SQLType = SQL_INT64
1299 sub type = 0
1300 Scale = -2
1301 Charset = NONE
1302 Nullable
1303 Size = 8
1304 Value = NULL
1305 Column 10
1306 Field Name = FULL_NAME
1307 SQLType = SQL_VARYING
1308 sub type = 0
1309 Scale = 0
1310 Charset = NONE
1311 Nullable
1312 Size = 37
1313 Value = NULL
1314 Column 11
1315 Field Name = PREVIOUS_PHONE_EXT
1316 SQLType = SQL_VARYING
1317 sub type = 0
1318 Scale = 0
1319 Charset = NONE
1320 Nullable
1321 Size = 4
1322 Value = NULL
1323
1324 @13/1/2022 23:18:13.4590:New Field Values after trigger execution
1325 Column 0
1326 Field Name = EMP_NO
1327 SQLType = SQL_SHORT
1328 sub type = 0
1329 Scale = 0
1330 Charset = NONE
1331 Nullable
1332 Size = 2
1333 Value = NULL
1334 Column 1
1335 Field Name = FIRST_NAME
1336 SQLType = SQL_VARYING
1337 sub type = 0
1338 Scale = 0
1339 Charset = NONE
1340 Nullable
1341 Size = 15
1342 Value = NULL
1343 Column 2
1344 Field Name = LAST_NAME
1345 SQLType = SQL_VARYING
1346 sub type = 0
1347 Scale = 0
1348 Charset = NONE
1349 Nullable
1350 Size = 20
1351 Value = NULL
1352 Column 3
1353 Field Name = PHONE_EXT
1354 SQLType = SQL_VARYING
1355 sub type = 0
1356 Scale = 0
1357 Charset = NONE
1358 Nullable
1359 Size = 4
1360 Value = 999
1361 Column 4
1362 Field Name = HIRE_DATE
1363 SQLType = SQL_TIMESTAMP
1364 sub type = 0
1365 Scale = 0
1366 Charset = NONE
1367 Nullable
1368 Size = 8
1369 Value = NULL
1370 Column 5
1371 Field Name = DEPT_NO
1372 SQLType = SQL_TEXT
1373 sub type = 0
1374 Scale = 0
1375 Charset = NONE
1376 Nullable
1377 Size = 3
1378 Value = NULL
1379 Column 6
1380 Field Name = JOB_CODE
1381 SQLType = SQL_VARYING
1382 sub type = 0
1383 Scale = 0
1384 Charset = NONE
1385 Nullable
1386 Size = 5
1387 Value = NULL
1388 Column 7
1389 Field Name = JOB_GRADE
1390 SQLType = SQL_SHORT
1391 sub type = 0
1392 Scale = 0
1393 Charset = NONE
1394 Nullable
1395 Size = 2
1396 Value = NULL
1397 Column 8
1398 Field Name = JOB_COUNTRY
1399 SQLType = SQL_VARYING
1400 sub type = 0
1401 Scale = 0
1402 Charset = NONE
1403 Nullable
1404 Size = 15
1405 Value = NULL
1406 Column 9
1407 Field Name = SALARY
1408 SQLType = SQL_INT64
1409 sub type = 0
1410 Scale = -2
1411 Charset = NONE
1412 Nullable
1413 Size = 8
1414 Value = NULL
1415 Column 10
1416 Field Name = FULL_NAME
1417 SQLType = SQL_VARYING
1418 sub type = 0
1419 Scale = 0
1420 Charset = NONE
1421 Nullable
1422 Size = 37
1423 Value = NULL
1424 Column 11
1425 Field Name = PREVIOUS_PHONE_EXT
1426 SQLType = SQL_VARYING
1427 sub type = 0
1428 Scale = 0
1429 Charset = NONE
1430 Nullable
1431 Size = 4
1432 Value = 250
1433
1434 @13/1/2022 23:18:13.4590:Trigger my_employee_update: dispose called

Properties

Name Value
svn:eol-style native