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

# User Rev Content
1 tony 381 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