ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/udr/testsuite/FB4reference.log
Revision: 338
Committed: Wed Jun 9 12:07:56 2021 UTC (2 years, 10 months ago) by tony
Original Path: ibx/trunk/fbintf/testsuite/FB4reference.log
File size: 101662 byte(s)
Log Message: 
Merge Fixes

File Contents

# User Rev Content
1 tony 333 Firebird API Test Suite
2     Copyright MWA Software 2016-2021
3    
4     Starting Tests
5     Client API Version = 4.0
6 tony 338 Firebird Environment Variable = /opt/firebird4.0.0
7     Firebird Bin Directory = /opt/firebird4.0.0/bin
8     Firebird Conf Directory = /opt/firebird4.0.0/
9     Firebird Client Library Path = /opt/firebird4.0.0/lib/libfbclient.so
10 tony 333 Running Test 1: Create and Drop a Database
11     Creating a Database with empty parameters
12     Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
13     -Error while trying to create file
14     -No such file or directory
15     Creating a Database using an SQL Statement
16     Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
17     SQL Dialect = 3
18     DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
19     DB Charset ID = 0
20     DB SQL Dialect = 3
21     DB Remote Protocol = TCPv4
22     DB ODS Major Version = 13
23     DB ODS Minor Version = 0
24     User Authentication Method = Srp256
25 tony 338 Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
26 tony 333 DB Client Implementation Version = 4.0
27     DPB: Item Count = 3
28     isc_dpb_user_name = SYSDBA
29     isc_dpb_password = masterkey
30     isc_dpb_set_db_sql_dialect = 3
31    
32     Firebird Server Version Info
33 tony 338 Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
34     Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C"
35     Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C"
36 tony 333 on disk structure version 13.0
37    
38     Dropping Database
39     Creating a Database with a DPD
40     DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
41     DB Charset ID = 4
42     DB SQL Dialect = 3
43     DB Remote Protocol = TCPv4
44     DB ODS Major Version = 13
45     DB ODS Minor Version = 0
46     User Authentication Method = Srp256
47 tony 338 Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
48 tony 333 DB Client Implementation Version = 4.0
49     Dropping Database
50     DPB: Item Count = 4
51     isc_dpb_user_name = SYSDBA
52     isc_dpb_password = masterkey
53     isc_dpb_lc_ctype = UTF8
54     isc_dpb_set_db_sql_dialect = 3
55    
56     Creating a Database with a DPD
57     Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
58     ODS major = 13
59     ODS minor = 0
60     DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
61     DB Charset ID = 4
62     DB SQL Dialect = 3
63     DB Remote Protocol = TCPv4
64     DB ODS Major Version = 13
65     DB ODS Minor Version = 0
66     User Authentication Method = Srp256
67 tony 338 Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
68 tony 333 DB Client Implementation Version = 4.0
69     RDB$DESCRIPTION =
70     RDB$RELATION_ID = 128
71 tony 338 RDB$SECURITY_CLASS = SQL$385
72 tony 333 RDB$CHARACTER_SET_NAME = UTF8
73     RDB$LINGER =
74     RDB$SQL_SECURITY =
75     Dropping Database
76    
77    
78     ------------------------------------------------------
79     Running Test 2: Open the employee database and run a query
80     Opening inet://localhost/employee
81     Database Open, SQL Dialect = 3
82     TPB: Item Count = 3
83     isc_tpb_read
84     isc_tpb_nowait
85     isc_tpb_concurrency
86    
87     Metadata
88     SQLType =SQL_SHORT
89     sub type = 0
90     Table = EMPLOYEE
91     Owner = SYSDBA
92     Column Name = EMP_NO
93     Alias Name = EMP_NO
94     Field Name = EMP_NO
95     Scale = 0
96     Charset id = 0
97     Not Null
98     Size = 2
99    
100     SQLType =SQL_VARYING
101     sub type = 0
102     Table = EMPLOYEE
103     Owner = SYSDBA
104     Column Name = FIRST_NAME
105     Alias Name = FIRST_NAME
106     Field Name = FIRST_NAME
107     Scale = 0
108     Charset id = 0
109     Not Null
110     Size = 15
111    
112     SQLType =SQL_VARYING
113     sub type = 0
114     Table = EMPLOYEE
115     Owner = SYSDBA
116     Column Name = LAST_NAME
117     Alias Name = LAST_NAME
118     Field Name = LAST_NAME
119     Scale = 0
120     Charset id = 0
121     Not Null
122     Size = 20
123    
124     SQLType =SQL_VARYING
125     sub type = 0
126     Table = EMPLOYEE
127     Owner = SYSDBA
128     Column Name = PHONE_EXT
129     Alias Name = PHONE_EXT
130     Field Name = PHONE_EXT
131     Scale = 0
132     Charset id = 0
133     Nullable
134     Size = 4
135    
136     SQLType =SQL_TIMESTAMP
137     sub type = 0
138     Table = EMPLOYEE
139     Owner = SYSDBA
140     Column Name = HIRE_DATE
141     Alias Name = HIRE_DATE
142     Field Name = HIRE_DATE
143     Scale = 0
144     Charset id = 0
145     Not Null
146     Size = 8
147    
148     SQLType =SQL_TEXT
149     sub type = 0
150     Table = EMPLOYEE
151     Owner = SYSDBA
152     Column Name = DEPT_NO
153     Alias Name = DEPT_NO
154     Field Name = DEPT_NO
155     Scale = 0
156     Charset id = 0
157     Not Null
158     Size = 3
159    
160     SQLType =SQL_VARYING
161     sub type = 0
162     Table = EMPLOYEE
163     Owner = SYSDBA
164     Column Name = JOB_CODE
165     Alias Name = JOB_CODE
166     Field Name = JOB_CODE
167     Scale = 0
168     Charset id = 0
169     Not Null
170     Size = 5
171    
172     SQLType =SQL_SHORT
173     sub type = 0
174     Table = EMPLOYEE
175     Owner = SYSDBA
176     Column Name = JOB_GRADE
177     Alias Name = JOB_GRADE
178     Field Name = JOB_GRADE
179     Scale = 0
180     Charset id = 0
181     Not Null
182     Size = 2
183    
184     SQLType =SQL_VARYING
185     sub type = 0
186     Table = EMPLOYEE
187     Owner = SYSDBA
188     Column Name = JOB_COUNTRY
189     Alias Name = JOB_COUNTRY
190     Field Name = JOB_COUNTRY
191     Scale = 0
192     Charset id = 0
193     Not Null
194     Size = 15
195    
196     SQLType =SQL_INT64
197     sub type = 0
198     Table = EMPLOYEE
199     Owner = SYSDBA
200     Column Name = SALARY
201     Alias Name = SALARY
202     Field Name = SALARY
203     Scale = -2
204     Charset id = 0
205     Not Null
206     Size = 8
207    
208     SQLType =SQL_VARYING
209     sub type = 0
210     Table = EMPLOYEE
211     Owner = SYSDBA
212     Column Name = FULL_NAME
213     Alias Name = FULL_NAME
214     Field Name = FULL_NAME
215     Scale = 0
216     Charset id = 0
217     Nullable
218     Size = 37
219    
220     Plan =
221     Select Expression
222     -> First N Records
223     -> Table "EMPLOYEE" Full Scan
224     -- SQL style inline comment
225     /* this is a comment */ Select First 3 * from EMPLOYEE
226    
227     EMP_NO = 2
228     FIRST_NAME = Robert
229     LAST_NAME = Nelson
230     PHONE_EXT = 250
231     HIRE_DATE = 1988/12/28 00:00:00.0000
232     DEPT_NO = 600
233     JOB_CODE = VP
234     JOB_GRADE = 2
235     JOB_COUNTRY = USA
236     SALARY = 105,900.00
237     FULL_NAME = Nelson, Robert
238     EMP_NO = 4
239     FIRST_NAME = Bruce
240     LAST_NAME = Young
241     PHONE_EXT = 233
242     HIRE_DATE = 1988/12/28 00:00:00.0000
243     DEPT_NO = 621
244     JOB_CODE = Eng
245     JOB_GRADE = 2
246     JOB_COUNTRY = USA
247     SALARY = 97,500.00
248     FULL_NAME = Young, Bruce
249     EMP_NO = 5
250     FIRST_NAME = Kim
251     LAST_NAME = Lambert
252     PHONE_EXT = 22
253     HIRE_DATE = 1989/02/06 00:00:00.0000
254     DEPT_NO = 130
255     JOB_CODE = Eng
256     JOB_GRADE = 2
257     JOB_COUNTRY = USA
258     SALARY = 102,750.00
259     FULL_NAME = Lambert, Kim
260    
261     Select * from EMPLOYEE Where EMP_NO = ?
262     SQL Params
263     SQLType =SQL_SHORT
264     sub type = 0
265     Field Name =
266     Scale = 0
267     Charset id = 0
268     Not Null
269     Size = 2
270    
271     EMP_NO = 8
272     FIRST_NAME = Leslie
273     LAST_NAME = Johnson
274     PHONE_EXT = 410
275     HIRE_DATE = 1989/04/05 00:00:00.0000
276     DEPT_NO = 180
277     JOB_CODE = Mktg
278     JOB_GRADE = 3
279     JOB_COUNTRY = USA
280     SALARY = 64,635.00
281     FULL_NAME = Johnson, Leslie
282    
283     With param names
284     Select * from EMPLOYEE Where EMP_NO = :EMP_NO
285     SQL Params
286     SQLType =SQL_SHORT
287     sub type = 0
288     Field Name = EMP_NO
289     Scale = 0
290     Charset id = 0
291     Not Null
292     Size = 2
293    
294     EMP_NO = 8
295     FIRST_NAME = Leslie
296     LAST_NAME = Johnson
297     PHONE_EXT = 410
298     HIRE_DATE = 1989/04/05 00:00:00.0000
299     DEPT_NO = 180
300     JOB_CODE = Mktg
301     JOB_GRADE = 3
302     JOB_COUNTRY = USA
303     SALARY = 64,635.00
304     FULL_NAME = Johnson, Leslie
305    
306     Now open the employee database as a local database
307     TPB: Item Count = 3
308     isc_tpb_read
309     isc_tpb_nowait
310     isc_tpb_concurrency
311    
312     Metadata
313     SQLType =SQL_SHORT
314     sub type = 0
315     Table = EMPLOYEE
316     Owner = SYSDBA
317     Column Name = EMP_NO
318     Alias Name = EMP_NO
319     Field Name = EMP_NO
320     Scale = 0
321     Charset id = 0
322     Not Null
323     Size = 2
324    
325     SQLType =SQL_VARYING
326     sub type = 0
327     Table = EMPLOYEE
328     Owner = SYSDBA
329     Column Name = FIRST_NAME
330     Alias Name = FIRST_NAME
331     Field Name = FIRST_NAME
332     Scale = 0
333     Charset id = 0
334     Not Null
335     Size = 15
336    
337     SQLType =SQL_VARYING
338     sub type = 0
339     Table = EMPLOYEE
340     Owner = SYSDBA
341     Column Name = LAST_NAME
342     Alias Name = LAST_NAME
343     Field Name = LAST_NAME
344     Scale = 0
345     Charset id = 0
346     Not Null
347     Size = 20
348    
349     SQLType =SQL_VARYING
350     sub type = 0
351     Table = EMPLOYEE
352     Owner = SYSDBA
353     Column Name = PHONE_EXT
354     Alias Name = PHONE_EXT
355     Field Name = PHONE_EXT
356     Scale = 0
357     Charset id = 0
358     Nullable
359     Size = 4
360    
361     SQLType =SQL_TIMESTAMP
362     sub type = 0
363     Table = EMPLOYEE
364     Owner = SYSDBA
365     Column Name = HIRE_DATE
366     Alias Name = HIRE_DATE
367     Field Name = HIRE_DATE
368     Scale = 0
369     Charset id = 0
370     Not Null
371     Size = 8
372    
373     SQLType =SQL_TEXT
374     sub type = 0
375     Table = EMPLOYEE
376     Owner = SYSDBA
377     Column Name = DEPT_NO
378     Alias Name = DEPT_NO
379     Field Name = DEPT_NO
380     Scale = 0
381     Charset id = 0
382     Not Null
383     Size = 3
384    
385     SQLType =SQL_VARYING
386     sub type = 0
387     Table = EMPLOYEE
388     Owner = SYSDBA
389     Column Name = JOB_CODE
390     Alias Name = JOB_CODE
391     Field Name = JOB_CODE
392     Scale = 0
393     Charset id = 0
394     Not Null
395     Size = 5
396    
397     SQLType =SQL_SHORT
398     sub type = 0
399     Table = EMPLOYEE
400     Owner = SYSDBA
401     Column Name = JOB_GRADE
402     Alias Name = JOB_GRADE
403     Field Name = JOB_GRADE
404     Scale = 0
405     Charset id = 0
406     Not Null
407     Size = 2
408    
409     SQLType =SQL_VARYING
410     sub type = 0
411     Table = EMPLOYEE
412     Owner = SYSDBA
413     Column Name = JOB_COUNTRY
414     Alias Name = JOB_COUNTRY
415     Field Name = JOB_COUNTRY
416     Scale = 0
417     Charset id = 0
418     Not Null
419     Size = 15
420    
421     SQLType =SQL_INT64
422     sub type = 0
423     Table = EMPLOYEE
424     Owner = SYSDBA
425     Column Name = SALARY
426     Alias Name = SALARY
427     Field Name = SALARY
428     Scale = -2
429     Charset id = 0
430     Not Null
431     Size = 8
432    
433     SQLType =SQL_VARYING
434     sub type = 0
435     Table = EMPLOYEE
436     Owner = SYSDBA
437     Column Name = FULL_NAME
438     Alias Name = FULL_NAME
439     Field Name = FULL_NAME
440     Scale = 0
441     Charset id = 0
442     Nullable
443     Size = 37
444    
445     Plan =
446     Select Expression
447     -> First N Records
448     -> Table "EMPLOYEE" Full Scan
449     -- SQL style inline comment
450     /* this is a comment */ Select First 3 * from EMPLOYEE
451    
452     EMP_NO = 2
453     FIRST_NAME = Robert
454     LAST_NAME = Nelson
455     PHONE_EXT = 250
456     HIRE_DATE = 1988/12/28 00:00:00.0000
457     DEPT_NO = 600
458     JOB_CODE = VP
459     JOB_GRADE = 2
460     JOB_COUNTRY = USA
461     SALARY = 105,900.00
462     FULL_NAME = Nelson, Robert
463     EMP_NO = 4
464     FIRST_NAME = Bruce
465     LAST_NAME = Young
466     PHONE_EXT = 233
467     HIRE_DATE = 1988/12/28 00:00:00.0000
468     DEPT_NO = 621
469     JOB_CODE = Eng
470     JOB_GRADE = 2
471     JOB_COUNTRY = USA
472     SALARY = 97,500.00
473     FULL_NAME = Young, Bruce
474     EMP_NO = 5
475     FIRST_NAME = Kim
476     LAST_NAME = Lambert
477     PHONE_EXT = 22
478     HIRE_DATE = 1989/02/06 00:00:00.0000
479     DEPT_NO = 130
480     JOB_CODE = Eng
481     JOB_GRADE = 2
482     JOB_COUNTRY = USA
483     SALARY = 102,750.00
484     FULL_NAME = Lambert, Kim
485    
486     Select * from EMPLOYEE Where EMP_NO = ?
487     SQL Params
488     SQLType =SQL_SHORT
489     sub type = 0
490     Field Name =
491     Scale = 0
492     Charset id = 0
493     Not Null
494     Size = 2
495    
496     EMP_NO = 8
497     FIRST_NAME = Leslie
498     LAST_NAME = Johnson
499     PHONE_EXT = 410
500     HIRE_DATE = 1989/04/05 00:00:00.0000
501     DEPT_NO = 180
502     JOB_CODE = Mktg
503     JOB_GRADE = 3
504     JOB_COUNTRY = USA
505     SALARY = 64,635.00
506     FULL_NAME = Johnson, Leslie
507    
508     With param names
509     Select * from EMPLOYEE Where EMP_NO = :EMP_NO
510     SQL Params
511     SQLType =SQL_SHORT
512     sub type = 0
513     Field Name = EMP_NO
514     Scale = 0
515     Charset id = 0
516     Not Null
517     Size = 2
518    
519     EMP_NO = 8
520     FIRST_NAME = Leslie
521     LAST_NAME = Johnson
522     PHONE_EXT = 410
523     HIRE_DATE = 1989/04/05 00:00:00.0000
524     DEPT_NO = 180
525     JOB_CODE = Mktg
526     JOB_GRADE = 3
527     JOB_COUNTRY = USA
528     SALARY = 64,635.00
529     FULL_NAME = Johnson, Leslie
530    
531    
532    
533     ------------------------------------------------------
534     Running Test 3: ad hoc queries
535     Opening inet://localhost/employee
536     Database Open
537     Employee Count = 42
538     Employee Count = 41
539     Employee Count = 42
540     Employee Count = 41
541     Employee Count = 42
542     Constrained Employee Count = 3
543     "Johnson" Employee Count = 2
544     "Yanowski" Employee Count = 1
545    
546    
547     ------------------------------------------------------
548     Running Test 4: Update, Insert and Delete Queries
549     Opening inet://localhost/employee
550     Database Open
551 tony 338 Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
552     Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
553     Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
554 tony 333 on disk structure version 13.0
555     Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
556     EMP_NO = 8
557     FIRST_NAME = Leslie
558     LAST_NAME = Johnson
559     PHONE_EXT = 410
560     HIRE_DATE = 1989/04/05 00:00:00.0000
561     DEPT_NO = 180
562     JOB_CODE = Mktg
563     JOB_GRADE = 3
564     JOB_COUNTRY = USA
565     SALARY = 64,635.00
566     FULL_NAME = Johnson, Leslie
567    
568 tony 338 Current memory = 19,763,536
569 tony 333 Delta memory = 4,464
570 tony 338 Max memory = 19,809,408
571 tony 333 Elapsed time= 0.002 sec
572     Cpu = 0.000 sec
573     Buffers = 2048
574     Reads = 0
575     Writes = 0
576     Fetches = 3
577     Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
578     Relation Name = EMPLOYEE
579     Metadata
580     SQLType =SQL_SHORT
581     sub type = 0
582     Table = EMPLOYEE
583     Owner = SYSDBA
584     Column Name = EMP_NO
585     Alias Name = EMP_NO
586     Field Name = EMP_NO
587     Scale = 0
588     Charset id = 0
589     Not Null
590     Size = 2
591    
592     SQLType =SQL_VARYING
593     sub type = 0
594     Table = EMPLOYEE
595     Owner = SYSDBA
596     Column Name = FIRST_NAME
597     Alias Name = FIRST_NAME
598     Field Name = FIRST_NAME
599     Scale = 0
600     Charset id = 0
601     Not Null
602     Size = 15
603    
604     SQLType =SQL_VARYING
605     sub type = 0
606     Table = EMPLOYEE
607     Owner = SYSDBA
608     Column Name = LAST_NAME
609     Alias Name = LAST_NAME
610     Field Name = LAST_NAME
611     Scale = 0
612     Charset id = 0
613     Not Null
614     Size = 20
615    
616     SQLType =SQL_VARYING
617     sub type = 0
618     Table = EMPLOYEE
619     Owner = SYSDBA
620     Column Name = PHONE_EXT
621     Alias Name = PHONE_EXT
622     Field Name = PHONE_EXT
623     Scale = 0
624     Charset id = 0
625     Nullable
626     Size = 4
627    
628     SQLType =SQL_TIMESTAMP
629     sub type = 0
630     Table = EMPLOYEE
631     Owner = SYSDBA
632     Column Name = HIRE_DATE
633     Alias Name = HIRE_DATE
634     Field Name = HIRE_DATE
635     Scale = 0
636     Charset id = 0
637     Not Null
638     Size = 8
639    
640     SQLType =SQL_TEXT
641     sub type = 0
642     Table = EMPLOYEE
643     Owner = SYSDBA
644     Column Name = DEPT_NO
645     Alias Name = DEPT_NO
646     Field Name = DEPT_NO
647     Scale = 0
648     Charset id = 0
649     Not Null
650     Size = 3
651    
652     SQLType =SQL_VARYING
653     sub type = 0
654     Table = EMPLOYEE
655     Owner = SYSDBA
656     Column Name = JOB_CODE
657     Alias Name = JOB_CODE
658     Field Name = JOB_CODE
659     Scale = 0
660     Charset id = 0
661     Not Null
662     Size = 5
663    
664     SQLType =SQL_SHORT
665     sub type = 0
666     Table = EMPLOYEE
667     Owner = SYSDBA
668     Column Name = JOB_GRADE
669     Alias Name = JOB_GRADE
670     Field Name = JOB_GRADE
671     Scale = 0
672     Charset id = 0
673     Not Null
674     Size = 2
675    
676     SQLType =SQL_VARYING
677     sub type = 0
678     Table = EMPLOYEE
679     Owner = SYSDBA
680     Column Name = JOB_COUNTRY
681     Alias Name = JOB_COUNTRY
682     Field Name = JOB_COUNTRY
683     Scale = 0
684     Charset id = 0
685     Not Null
686     Size = 15
687    
688     SQLType =SQL_INT64
689     sub type = 0
690     Table = EMPLOYEE
691     Owner = SYSDBA
692     Column Name = SALARY
693     Alias Name = SALARY
694     Field Name = SALARY
695     Scale = -2
696     Charset id = 0
697     Not Null
698     Size = 8
699    
700     SQLType =SQL_VARYING
701     sub type = 0
702     Table = EMPLOYEE
703     Owner = SYSDBA
704     Column Name = FULL_NAME
705     Alias Name = FULL_NAME
706     Field Name = FULL_NAME
707     Scale = 0
708     Charset id = 0
709     Nullable
710     Size = 37
711    
712     EMP_NO = 150
713     FIRST_NAME = John
714     LAST_NAME = Doe
715     PHONE_EXT =
716     HIRE_DATE = 2015/04/01 00:00:00.0000
717     DEPT_NO = 600
718     JOB_CODE = Eng
719     JOB_GRADE = 4
720     JOB_COUNTRY = England
721     SALARY = 41,000.89
722     FULL_NAME = Doe, John
723    
724     Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
725     EMP_NO = 151
726     FIRST_NAME = Major
727     LAST_NAME = Major
728     PHONE_EXT =
729     HIRE_DATE = 2015/04/01 00:00:00.0000
730     DEPT_NO = 600
731     JOB_CODE = Eng
732     JOB_GRADE = 4
733     JOB_COUNTRY = England
734     SALARY = 40,000.59
735     FULL_NAME = Major, Major
736    
737     Now Delete the rows
738     Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
739     Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
740     Inserting
741     Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
742     EMP_NO = 150
743     FIRST_NAME = Jane
744     LAST_NAME = Doe
745     PHONE_EXT = NULL
746     HIRE_DATE = 2015/04/01 00:00:00.0000
747     DEPT_NO = 600
748     JOB_CODE = Eng
749     JOB_GRADE = 4
750     JOB_COUNTRY = England
751     SALARY = 41,000.89
752     FULL_NAME = Doe, Jane
753    
754     Employee Count = 43
755     Updating
756     Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 0
757     Prepare Query again
758    
759     EMP_NO = 150
760     FIRST_NAME = Jayne's
761     LAST_NAME = Doe
762     PHONE_EXT = NULL
763     HIRE_DATE = 2015/04/01 00:00:00.0000
764     DEPT_NO = 600
765     JOB_CODE = Eng
766     JOB_GRADE = 4
767     JOB_COUNTRY = England
768     SALARY = 41,000.89
769     FULL_NAME = Doe, Jayne's
770    
771     Prepare Query again with a different transaction
772    
773     EMP_NO = 8
774     FIRST_NAME = Leslie
775     LAST_NAME = Johnson
776     PHONE_EXT = 410
777     HIRE_DATE = 1989/04/05 00:00:00.0000
778     DEPT_NO = 180
779     JOB_CODE = Mktg
780     JOB_GRADE = 3
781     JOB_COUNTRY = USA
782     SALARY = 64,635.00
783     FULL_NAME = Johnson, Leslie
784    
785     Open Cursor with a different transaction
786    
787     EMP_NO = 8
788     FIRST_NAME = Leslie
789     LAST_NAME = Johnson
790     PHONE_EXT = 410
791     HIRE_DATE = 1989/04/05 00:00:00.0000
792     DEPT_NO = 180
793     JOB_CODE = Mktg
794     JOB_GRADE = 3
795     JOB_COUNTRY = USA
796     SALARY = 64,635.00
797     FULL_NAME = Johnson, Leslie
798     Same Statement - updated params
799     EMP_NO = 9
800     FIRST_NAME = Phil
801     LAST_NAME = Forest
802     PHONE_EXT = 229
803     HIRE_DATE = 1989/04/17 00:00:00.0000
804     DEPT_NO = 622
805     JOB_CODE = Mngr
806     JOB_GRADE = 3
807     JOB_COUNTRY = USA
808     SALARY = 75,060.00
809     FULL_NAME = Forest, Phil
810    
811     Test using Execute Block
812     Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
813     EMP_NO = 8
814     FIRST_NAME = Leslie
815     LAST_NAME = Johnson
816     PHONE_EXT = 410
817     HIRE_DATE = 2015/01/31 00:00:00.0000
818     DEPT_NO = 180
819     JOB_CODE = Mktg
820     JOB_GRADE = 3
821     JOB_COUNTRY = USA
822     SALARY = 64,635.00
823     FULL_NAME = Johnson, Leslie
824    
825    
826    
827     ------------------------------------------------------
828     Running Test 5: Update Returning and Activity Check
829     Opening inet://localhost/employee
830     Database Open
831     Database Closed
832     Database Open
833     Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
834     Last Name = Johnson
835     EMP_NO = 8
836     FIRST_NAME = Leslie
837     LAST_NAME = Johnson
838     PHONE_EXT = 410
839     HIRE_DATE = 2016/01/31 00:00:00.0000
840     DEPT_NO = 180
841     JOB_CODE = Mktg
842     JOB_GRADE = 3
843     JOB_COUNTRY = USA
844     SALARY = 64,635.00
845     FULL_NAME = Johnson, Leslie
846    
847     Inserting
848     Full Name = Doe, John
849     Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
850     Database Activity = TRUE
851     Transaction Activity = TRUE
852     Database Activity = FALSE
853     Transaction Activity = FALSE
854     Employee Count = 43
855     Database Activity = TRUE
856     Transaction Activity = TRUE
857     Transaction Active
858     Transaction inactive
859    
860    
861     ------------------------------------------------------
862     Running Test 6: Blob Handling
863     Metadata
864     SQLType =SQL_TEXT
865     sub type = 0
866     Table = RDB$CHARACTER_SETS
867     Owner = SYSDBA
868     Column Name = RDB$CHARACTER_SET_NAME
869     Alias Name = RDB$CHARACTER_SET_NAME
870     Field Name = RDB$CHARACTER_SET_NAME
871     Scale = 0
872     Charset id = 4
873     Nullable
874     Size = 252
875    
876     SQLType =SQL_SHORT
877     sub type = 0
878     Table = RDB$CHARACTER_SETS
879     Owner = SYSDBA
880     Column Name = RDB$CHARACTER_SET_ID
881     Alias Name = RDB$CHARACTER_SET_ID
882     Field Name = RDB$CHARACTER_SET_ID
883     Scale = 0
884     Charset id = 0
885     Nullable
886     Size = 2
887    
888     RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
889     RDB$CHARACTER_SET_ID = 0
890     RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
891     RDB$CHARACTER_SET_ID = 1
892     RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
893     RDB$CHARACTER_SET_ID = 2
894     RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
895     RDB$CHARACTER_SET_ID = 3
896     RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
897     RDB$CHARACTER_SET_ID = 4
898     RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
899     RDB$CHARACTER_SET_ID = 5
900     RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
901     RDB$CHARACTER_SET_ID = 6
902     RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
903     RDB$CHARACTER_SET_ID = 9
904     RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
905     RDB$CHARACTER_SET_ID = 10
906     RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
907     RDB$CHARACTER_SET_ID = 11
908     RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
909     RDB$CHARACTER_SET_ID = 12
910     RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
911     RDB$CHARACTER_SET_ID = 13
912     RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
913     RDB$CHARACTER_SET_ID = 14
914     RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
915     RDB$CHARACTER_SET_ID = 15
916     RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
917     RDB$CHARACTER_SET_ID = 16
918     RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
919     RDB$CHARACTER_SET_ID = 17
920     RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
921     RDB$CHARACTER_SET_ID = 18
922     RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
923     RDB$CHARACTER_SET_ID = 19
924     RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
925     RDB$CHARACTER_SET_ID = 21
926     RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
927     RDB$CHARACTER_SET_ID = 22
928     RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
929     RDB$CHARACTER_SET_ID = 23
930     RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
931     RDB$CHARACTER_SET_ID = 34
932     RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
933     RDB$CHARACTER_SET_ID = 35
934     RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
935     RDB$CHARACTER_SET_ID = 36
936     RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
937     RDB$CHARACTER_SET_ID = 37
938     RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
939     RDB$CHARACTER_SET_ID = 38
940     RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
941     RDB$CHARACTER_SET_ID = 39
942     RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
943     RDB$CHARACTER_SET_ID = 40
944     RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
945     RDB$CHARACTER_SET_ID = 44
946     RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
947     RDB$CHARACTER_SET_ID = 45
948     RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
949     RDB$CHARACTER_SET_ID = 46
950     RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
951     RDB$CHARACTER_SET_ID = 47
952     RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
953     RDB$CHARACTER_SET_ID = 48
954     RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
955     RDB$CHARACTER_SET_ID = 49
956     RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
957     RDB$CHARACTER_SET_ID = 50
958     RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
959     RDB$CHARACTER_SET_ID = 51
960     RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
961     RDB$CHARACTER_SET_ID = 52
962     RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
963     RDB$CHARACTER_SET_ID = 53
964     RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
965     RDB$CHARACTER_SET_ID = 54
966     RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
967     RDB$CHARACTER_SET_ID = 55
968     RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
969     RDB$CHARACTER_SET_ID = 56
970     RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
971     RDB$CHARACTER_SET_ID = 57
972     RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
973     RDB$CHARACTER_SET_ID = 58
974     RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
975     RDB$CHARACTER_SET_ID = 59
976     RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
977     RDB$CHARACTER_SET_ID = 60
978     RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
979     RDB$CHARACTER_SET_ID = 63
980     RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
981     RDB$CHARACTER_SET_ID = 64
982     RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
983     RDB$CHARACTER_SET_ID = 65
984     RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
985     RDB$CHARACTER_SET_ID = 66
986     RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
987     RDB$CHARACTER_SET_ID = 67
988     RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
989     RDB$CHARACTER_SET_ID = 68
990     RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
991     RDB$CHARACTER_SET_ID = 69
992    
993     Metadata
994     SQLType =SQL_LONG
995     sub type = 0
996     Table = TESTDATA
997     Owner = SYSDBA
998     Column Name = ROWID
999     Alias Name = ROWID
1000     Field Name = ROWID
1001     Scale = 0
1002     Charset id = 0
1003     Not Null
1004     Size = 4
1005    
1006     SQLType =SQL_LONG
1007     sub type = 0
1008     Table = TESTDATA
1009     Owner = SYSDBA
1010     Column Name = FIXEDPOINT
1011     Alias Name = FIXEDPOINT
1012     Field Name = FIXEDPOINT
1013     Scale = -2
1014     Charset id = 0
1015     Nullable
1016     Size = 4
1017    
1018     SQLType =SQL_DOUBLE
1019     sub type = 0
1020     Table = TESTDATA
1021     Owner = SYSDBA
1022     Column Name = FLOATINGPOINT
1023     Alias Name = FLOATINGPOINT
1024     Field Name = FLOATINGPOINT
1025     Scale = 0
1026     Charset id = 0
1027     Nullable
1028     Size = 8
1029    
1030     SQLType =SQL_VARYING
1031     sub type = 0
1032     Table = TESTDATA
1033     Owner = SYSDBA
1034     Column Name = TITLE
1035     Alias Name = TITLE
1036     Field Name = TITLE
1037     Scale = 0
1038     Charset id = 4
1039     Nullable
1040     Size = 128
1041    
1042     SQLType =SQL_BLOB
1043     sub type = 1
1044     Table = TESTDATA
1045     Owner = SYSDBA
1046     Column Name = BLOBDATA
1047     Alias Name = BLOBDATA
1048     Field Name = BLOBDATA
1049     Scale = 0
1050     Charset id = 4
1051     Nullable
1052     Size = 8
1053    
1054     Blob Meta Data
1055     SQL SubType =1
1056     Table = TESTDATA
1057     Column = BLOBDATA
1058     CharSetID = 4
1059     Segment Size = 80
1060    
1061    
1062     SQL Params
1063     SQLType =SQL_LONG
1064     sub type = 0
1065     Field Name = ROWID
1066     Scale = 0
1067     Charset id = 0
1068     Not Null
1069     Size = 4
1070    
1071     SQLType =SQL_VARYING
1072     sub type = 0
1073     Field Name = TITLE
1074     Scale = 0
1075     Charset id = 4
1076     Nullable
1077     Size = 128
1078    
1079     SQLType =SQL_LONG
1080     sub type = 0
1081     Field Name = FP
1082     Scale = -2
1083     Charset id = 0
1084     Nullable
1085     Size = 4
1086    
1087     SQLType =SQL_DOUBLE
1088     sub type = 0
1089     Field Name = DP
1090     Scale = 0
1091     Charset id = 0
1092     Nullable
1093     Size = 8
1094    
1095     ROWID = 1
1096     FIXEDPOINT = 20.28
1097     FLOATINGPOINT = 3.14
1098     TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1099     BLOBDATA = NULL
1100    
1101     SQL Params
1102     SQLType =SQL_BLOB
1103     sub type = 1
1104     Field Name =
1105     Scale = 0
1106     Charset id = 4
1107     Nullable
1108     Size = 8
1109    
1110     SQLType =SQL_LONG
1111     sub type = 0
1112     Field Name =
1113     Scale = 0
1114     Charset id = 0
1115     Not Null
1116     Size = 4
1117    
1118     ROWID = 1
1119     FIXEDPOINT = 20.28
1120     FLOATINGPOINT = 3.14
1121     TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1122     BLOBDATA (Charset Id = 4 Codepage = 65001)
1123    
1124     To be or not to be-that is the question:
1125     Whether 'tis nobler in the mind to suffer
1126     The slings and arrows of outrageous fortune,
1127     Or to take arms against a sea of troubles,
1128     And, by opposing, end them. To die, to sleep-
1129     No more-and by a sleep to say we end
1130     The heartache and the thousand natural shocks
1131     That flesh is heir to-'tis a consummation
1132     Devoutly to be wished. To die, to sleep-
1133     To sleep, perchance to dream. Aye, there's the rub,
1134     For in that sleep of death what dreams may come,
1135     When we have shuffled off this mortal coil,
1136     Must give us pause. There's the respect
1137     That makes calamity of so long life.
1138     For who would bear the whips and scorns of time,
1139     Th' oppressor's wrong, the proud man's contumely,
1140     The pangs of despised love, the law’s delay,
1141     The insolence of office, and the spurns
1142     That patient merit of the unworthy takes,
1143     When he himself might his quietus make
1144     With a bare bodkin? Who would fardels bear,
1145     To grunt and sweat under a weary life,
1146     But that the dread of something after death,
1147     The undiscovered country from whose bourn
1148     No traveler returns, puzzles the will
1149     And makes us rather bear those ills we have
1150     Than fly to others that we know not of?
1151     Thus conscience does make cowards of us all,
1152     And thus the native hue of resolution
1153     Is sicklied o'er with the pale cast of thought,
1154     And enterprises of great pitch and moment,
1155     With this regard their currents turn awry,
1156     And lose the name of action.-Soft you now,
1157     The fair Ophelia.-Nymph, in thy orisons
1158     Be all my sins remembered
1159    
1160    
1161     SQL Params
1162     SQLType =SQL_LONG
1163     sub type = 0
1164     Field Name = ROWID
1165     Scale = 0
1166     Charset id = 0
1167     Not Null
1168     Size = 4
1169    
1170     SQLType =SQL_VARYING
1171     sub type = 0
1172     Field Name = TITLE
1173     Scale = 0
1174     Charset id = 4
1175     Nullable
1176     Size = 128
1177    
1178     SQLType =SQL_LONG
1179     sub type = 0
1180     Field Name = FP
1181     Scale = -2
1182     Charset id = 0
1183     Nullable
1184     Size = 4
1185    
1186     SQLType =SQL_DOUBLE
1187     sub type = 0
1188     Field Name = DP
1189     Scale = 0
1190     Charset id = 0
1191     Nullable
1192     Size = 8
1193    
1194     ROWID = 1
1195     FIXEDPOINT = 20.28
1196     FLOATINGPOINT = 3.14
1197     TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1198     BLOBDATA (Charset Id = 4 Codepage = 65001)
1199    
1200     To be or not to be-that is the question:
1201     Whether 'tis nobler in the mind to suffer
1202     The slings and arrows of outrageous fortune,
1203     Or to take arms against a sea of troubles,
1204     And, by opposing, end them. To die, to sleep-
1205     No more-and by a sleep to say we end
1206     The heartache and the thousand natural shocks
1207     That flesh is heir to-'tis a consummation
1208     Devoutly to be wished. To die, to sleep-
1209     To sleep, perchance to dream. Aye, there's the rub,
1210     For in that sleep of death what dreams may come,
1211     When we have shuffled off this mortal coil,
1212     Must give us pause. There's the respect
1213     That makes calamity of so long life.
1214     For who would bear the whips and scorns of time,
1215     Th' oppressor's wrong, the proud man's contumely,
1216     The pangs of despised love, the law’s delay,
1217     The insolence of office, and the spurns
1218     That patient merit of the unworthy takes,
1219     When he himself might his quietus make
1220     With a bare bodkin? Who would fardels bear,
1221     To grunt and sweat under a weary life,
1222     But that the dread of something after death,
1223     The undiscovered country from whose bourn
1224     No traveler returns, puzzles the will
1225     And makes us rather bear those ills we have
1226     Than fly to others that we know not of?
1227     Thus conscience does make cowards of us all,
1228     And thus the native hue of resolution
1229     Is sicklied o'er with the pale cast of thought,
1230     And enterprises of great pitch and moment,
1231     With this regard their currents turn awry,
1232     And lose the name of action.-Soft you now,
1233     The fair Ophelia.-Nymph, in thy orisons
1234     Be all my sins remembered
1235    
1236     ROWID = 2
1237     FIXEDPOINT = NULL
1238     FLOATINGPOINT = NULL
1239     TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1240     BLOBDATA (Charset Id = 4 Codepage = 65001)
1241    
1242     To be or not to be-that is the question:
1243     Whether 'tis nobler in the mind to suffer
1244     The slings and arrows of outrageous fortune,
1245     Or to take arms against a sea of troubles,
1246     And, by opposing, end them. To die, to sleep-
1247     No more-and by a sleep to say we end
1248     The heartache and the thousand natural shocks
1249     That flesh is heir to-'tis a consummation
1250     Devoutly to be wished. To die, to sleep-
1251     To sleep, perchance to dream. Aye, there's the rub,
1252     For in that sleep of death what dreams may come,
1253     When we have shuffled off this mortal coil,
1254     Must give us pause. There's the respect
1255     That makes calamity of so long life.
1256     For who would bear the whips and scorns of time,
1257     Th' oppressor's wrong, the proud man's contumely,
1258     The pangs of despised love, the law’s delay,
1259     The insolence of office, and the spurns
1260     That patient merit of the unworthy takes,
1261     When he himself might his quietus make
1262     With a bare bodkin? Who would fardels bear,
1263     To grunt and sweat under a weary life,
1264     But that the dread of something after death,
1265     The undiscovered country from whose bourn
1266     No traveler returns, puzzles the will
1267     And makes us rather bear those ills we have
1268     Than fly to others that we know not of?
1269     Thus conscience does make cowards of us all,
1270     And thus the native hue of resolution
1271     Is sicklied o'er with the pale cast of thought,
1272     And enterprises of great pitch and moment,
1273     With this regard their currents turn awry,
1274     And lose the name of action.-Soft you now,
1275     The fair Ophelia.-Nymph, in thy orisons
1276     Be all my sins remembered
1277    
1278    
1279     Testing Blob as stored proc parameter
1280     Metadata
1281     SQLType =SQL_BLOB
1282     sub type = 1
1283     Table = TESTPROC
1284     Owner = SYSDBA
1285     Column Name = BLOBDATA
1286     Alias Name = BLOBDATA
1287     Field Name = BLOBDATA
1288     Scale = 0
1289     Charset id = 4
1290     Nullable
1291     Size = 8
1292    
1293     Blob Meta Data
1294     SQL SubType =1
1295     Table = TESTPROC
1296     Column = BLOBDATA
1297     CharSetID = 4
1298     Segment Size = 80
1299    
1300    
1301     BLOBDATA (Charset Id = 4 Codepage = 65001)
1302    
1303     To be or not to be-that is the question:
1304     Whether 'tis nobler in the mind to suffer
1305     The slings and arrows of outrageous fortune,
1306     Or to take arms against a sea of troubles,
1307     And, by opposing, end them. To die, to sleep-
1308     No more-and by a sleep to say we end
1309     The heartache and the thousand natural shocks
1310     That flesh is heir to-'tis a consummation
1311     Devoutly to be wished. To die, to sleep-
1312     To sleep, perchance to dream. Aye, there's the rub,
1313     For in that sleep of death what dreams may come,
1314     When we have shuffled off this mortal coil,
1315     Must give us pause. There's the respect
1316     That makes calamity of so long life.
1317     For who would bear the whips and scorns of time,
1318     Th' oppressor's wrong, the proud man's contumely,
1319     The pangs of despised love, the law’s delay,
1320     The insolence of office, and the spurns
1321     That patient merit of the unworthy takes,
1322     When he himself might his quietus make
1323     With a bare bodkin? Who would fardels bear,
1324     To grunt and sweat under a weary life,
1325     But that the dread of something after death,
1326     The undiscovered country from whose bourn
1327     No traveler returns, puzzles the will
1328     And makes us rather bear those ills we have
1329     Than fly to others that we know not of?
1330     Thus conscience does make cowards of us all,
1331     And thus the native hue of resolution
1332     Is sicklied o'er with the pale cast of thought,
1333     And enterprises of great pitch and moment,
1334     With this regard their currents turn awry,
1335     And lose the name of action.-Soft you now,
1336     The fair Ophelia.-Nymph, in thy orisons
1337     Be all my sins remembered
1338    
1339     Metadata
1340     SQLType =SQL_TEXT
1341     sub type = 0
1342     Table = RDB$CHARACTER_SETS
1343     Owner = SYSDBA
1344     Column Name = RDB$CHARACTER_SET_NAME
1345     Alias Name = RDB$CHARACTER_SET_NAME
1346     Field Name = RDB$CHARACTER_SET_NAME
1347     Scale = 0
1348     Charset id = 53
1349     Nullable
1350     Size = 63
1351    
1352     SQLType =SQL_SHORT
1353     sub type = 0
1354     Table = RDB$CHARACTER_SETS
1355     Owner = SYSDBA
1356     Column Name = RDB$CHARACTER_SET_ID
1357     Alias Name = RDB$CHARACTER_SET_ID
1358     Field Name = RDB$CHARACTER_SET_ID
1359     Scale = 0
1360     Charset id = 0
1361     Nullable
1362     Size = 2
1363    
1364     RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1365     RDB$CHARACTER_SET_ID = 0
1366     RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1367     RDB$CHARACTER_SET_ID = 1
1368     RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1369     RDB$CHARACTER_SET_ID = 2
1370     RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1371     RDB$CHARACTER_SET_ID = 3
1372     RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1373     RDB$CHARACTER_SET_ID = 4
1374     RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1375     RDB$CHARACTER_SET_ID = 5
1376     RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1377     RDB$CHARACTER_SET_ID = 6
1378     RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1379     RDB$CHARACTER_SET_ID = 9
1380     RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1381     RDB$CHARACTER_SET_ID = 10
1382     RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1383     RDB$CHARACTER_SET_ID = 11
1384     RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1385     RDB$CHARACTER_SET_ID = 12
1386     RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1387     RDB$CHARACTER_SET_ID = 13
1388     RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1389     RDB$CHARACTER_SET_ID = 14
1390     RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1391     RDB$CHARACTER_SET_ID = 15
1392     RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1393     RDB$CHARACTER_SET_ID = 16
1394     RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1395     RDB$CHARACTER_SET_ID = 17
1396     RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1397     RDB$CHARACTER_SET_ID = 18
1398     RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1399     RDB$CHARACTER_SET_ID = 19
1400     RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1401     RDB$CHARACTER_SET_ID = 21
1402     RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1403     RDB$CHARACTER_SET_ID = 22
1404     RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1405     RDB$CHARACTER_SET_ID = 23
1406     RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1407     RDB$CHARACTER_SET_ID = 34
1408     RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1409     RDB$CHARACTER_SET_ID = 35
1410     RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1411     RDB$CHARACTER_SET_ID = 36
1412     RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1413     RDB$CHARACTER_SET_ID = 37
1414     RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1415     RDB$CHARACTER_SET_ID = 38
1416     RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1417     RDB$CHARACTER_SET_ID = 39
1418     RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1419     RDB$CHARACTER_SET_ID = 40
1420     RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1421     RDB$CHARACTER_SET_ID = 44
1422     RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1423     RDB$CHARACTER_SET_ID = 45
1424     RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1425     RDB$CHARACTER_SET_ID = 46
1426     RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1427     RDB$CHARACTER_SET_ID = 47
1428     RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1429     RDB$CHARACTER_SET_ID = 48
1430     RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1431     RDB$CHARACTER_SET_ID = 49
1432     RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1433     RDB$CHARACTER_SET_ID = 50
1434     RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1435     RDB$CHARACTER_SET_ID = 51
1436     RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1437     RDB$CHARACTER_SET_ID = 52
1438     RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1439     RDB$CHARACTER_SET_ID = 53
1440     RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1441     RDB$CHARACTER_SET_ID = 54
1442     RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1443     RDB$CHARACTER_SET_ID = 55
1444     RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1445     RDB$CHARACTER_SET_ID = 56
1446     RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1447     RDB$CHARACTER_SET_ID = 57
1448     RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1449     RDB$CHARACTER_SET_ID = 58
1450     RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1451     RDB$CHARACTER_SET_ID = 59
1452     RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1453     RDB$CHARACTER_SET_ID = 60
1454     RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1455     RDB$CHARACTER_SET_ID = 63
1456     RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1457     RDB$CHARACTER_SET_ID = 64
1458     RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1459     RDB$CHARACTER_SET_ID = 65
1460     RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1461     RDB$CHARACTER_SET_ID = 66
1462     RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1463     RDB$CHARACTER_SET_ID = 67
1464     RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1465     RDB$CHARACTER_SET_ID = 68
1466     RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1467     RDB$CHARACTER_SET_ID = 69
1468    
1469     Metadata
1470     SQLType =SQL_LONG
1471     sub type = 0
1472     Table = TESTDATA
1473     Owner = SYSDBA
1474     Column Name = ROWID
1475     Alias Name = ROWID
1476     Field Name = ROWID
1477     Scale = 0
1478     Charset id = 0
1479     Not Null
1480     Size = 4
1481    
1482     SQLType =SQL_LONG
1483     sub type = 0
1484     Table = TESTDATA
1485     Owner = SYSDBA
1486     Column Name = FIXEDPOINT
1487     Alias Name = FIXEDPOINT
1488     Field Name = FIXEDPOINT
1489     Scale = -2
1490     Charset id = 0
1491     Nullable
1492     Size = 4
1493    
1494     SQLType =SQL_DOUBLE
1495     sub type = 0
1496     Table = TESTDATA
1497     Owner = SYSDBA
1498     Column Name = FLOATINGPOINT
1499     Alias Name = FLOATINGPOINT
1500     Field Name = FLOATINGPOINT
1501     Scale = 0
1502     Charset id = 0
1503     Nullable
1504     Size = 8
1505    
1506     SQLType =SQL_VARYING
1507     sub type = 0
1508     Table = TESTDATA
1509     Owner = SYSDBA
1510     Column Name = TITLE
1511     Alias Name = TITLE
1512     Field Name = TITLE
1513     Scale = 0
1514     Charset id = 53
1515     Nullable
1516     Size = 32
1517    
1518     SQLType =SQL_BLOB
1519     sub type = 1
1520     Table = TESTDATA
1521     Owner = SYSDBA
1522     Column Name = BLOBDATA
1523     Alias Name = BLOBDATA
1524     Field Name = BLOBDATA
1525     Scale = 0
1526     Charset id = 53
1527     Nullable
1528     Size = 8
1529    
1530     Blob Meta Data
1531     SQL SubType =1
1532     Table = TESTDATA
1533     Column = BLOBDATA
1534     CharSetID = 53
1535     Segment Size = 80
1536    
1537    
1538     SQL Params
1539     SQLType =SQL_LONG
1540     sub type = 0
1541     Field Name = ROWID
1542     Scale = 0
1543     Charset id = 0
1544     Not Null
1545     Size = 4
1546    
1547     SQLType =SQL_VARYING
1548     sub type = 0
1549     Field Name = TITLE
1550     Scale = 0
1551     Charset id = 53
1552     Nullable
1553     Size = 32
1554    
1555     SQLType =SQL_LONG
1556     sub type = 0
1557     Field Name = FP
1558     Scale = -2
1559     Charset id = 0
1560     Nullable
1561     Size = 4
1562    
1563     SQLType =SQL_DOUBLE
1564     sub type = 0
1565     Field Name = DP
1566     Scale = 0
1567     Charset id = 0
1568     Nullable
1569     Size = 8
1570    
1571     ROWID = 1
1572     FIXEDPOINT = 20.28
1573     FLOATINGPOINT = 3.14
1574     TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1575     BLOBDATA = NULL
1576    
1577     SQL Params
1578     SQLType =SQL_BLOB
1579     sub type = 1
1580     Field Name =
1581     Scale = 0
1582     Charset id = 53
1583     Nullable
1584     Size = 8
1585    
1586     SQLType =SQL_LONG
1587     sub type = 0
1588     Field Name =
1589     Scale = 0
1590     Charset id = 0
1591     Not Null
1592     Size = 4
1593    
1594     ROWID = 1
1595     FIXEDPOINT = 20.28
1596     FLOATINGPOINT = 3.14
1597     TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1598     BLOBDATA (Charset Id = 53 Codepage = 1252)
1599    
1600     To be or not to be-that is the question:
1601     Whether 'tis nobler in the mind to suffer
1602     The slings and arrows of outrageous fortune,
1603     Or to take arms against a sea of troubles,
1604     And, by opposing, end them. To die, to sleep-
1605     No more-and by a sleep to say we end
1606     The heartache and the thousand natural shocks
1607     That flesh is heir to-'tis a consummation
1608     Devoutly to be wished. To die, to sleep-
1609     To sleep, perchance to dream. Aye, there's the rub,
1610     For in that sleep of death what dreams may come,
1611     When we have shuffled off this mortal coil,
1612     Must give us pause. There's the respect
1613     That makes calamity of so long life.
1614     For who would bear the whips and scorns of time,
1615     Th' oppressor's wrong, the proud man's contumely,
1616     The pangs of despised love, the law’s delay,
1617     The insolence of office, and the spurns
1618     That patient merit of the unworthy takes,
1619     When he himself might his quietus make
1620     With a bare bodkin? Who would fardels bear,
1621     To grunt and sweat under a weary life,
1622     But that the dread of something after death,
1623     The undiscovered country from whose bourn
1624     No traveler returns, puzzles the will
1625     And makes us rather bear those ills we have
1626     Than fly to others that we know not of?
1627     Thus conscience does make cowards of us all,
1628     And thus the native hue of resolution
1629     Is sicklied o'er with the pale cast of thought,
1630     And enterprises of great pitch and moment,
1631     With this regard their currents turn awry,
1632     And lose the name of action.-Soft you now,
1633     The fair Ophelia.-Nymph, in thy orisons
1634     Be all my sins remembered
1635    
1636    
1637     SQL Params
1638     SQLType =SQL_LONG
1639     sub type = 0
1640     Field Name = ROWID
1641     Scale = 0
1642     Charset id = 0
1643     Not Null
1644     Size = 4
1645    
1646     SQLType =SQL_VARYING
1647     sub type = 0
1648     Field Name = TITLE
1649     Scale = 0
1650     Charset id = 53
1651     Nullable
1652     Size = 32
1653    
1654     SQLType =SQL_LONG
1655     sub type = 0
1656     Field Name = FP
1657     Scale = -2
1658     Charset id = 0
1659     Nullable
1660     Size = 4
1661    
1662     SQLType =SQL_DOUBLE
1663     sub type = 0
1664     Field Name = DP
1665     Scale = 0
1666     Charset id = 0
1667     Nullable
1668     Size = 8
1669    
1670     ROWID = 1
1671     FIXEDPOINT = 20.28
1672     FLOATINGPOINT = 3.14
1673     TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1674     BLOBDATA (Charset Id = 53 Codepage = 1252)
1675    
1676     To be or not to be-that is the question:
1677     Whether 'tis nobler in the mind to suffer
1678     The slings and arrows of outrageous fortune,
1679     Or to take arms against a sea of troubles,
1680     And, by opposing, end them. To die, to sleep-
1681     No more-and by a sleep to say we end
1682     The heartache and the thousand natural shocks
1683     That flesh is heir to-'tis a consummation
1684     Devoutly to be wished. To die, to sleep-
1685     To sleep, perchance to dream. Aye, there's the rub,
1686     For in that sleep of death what dreams may come,
1687     When we have shuffled off this mortal coil,
1688     Must give us pause. There's the respect
1689     That makes calamity of so long life.
1690     For who would bear the whips and scorns of time,
1691     Th' oppressor's wrong, the proud man's contumely,
1692     The pangs of despised love, the law’s delay,
1693     The insolence of office, and the spurns
1694     That patient merit of the unworthy takes,
1695     When he himself might his quietus make
1696     With a bare bodkin? Who would fardels bear,
1697     To grunt and sweat under a weary life,
1698     But that the dread of something after death,
1699     The undiscovered country from whose bourn
1700     No traveler returns, puzzles the will
1701     And makes us rather bear those ills we have
1702     Than fly to others that we know not of?
1703     Thus conscience does make cowards of us all,
1704     And thus the native hue of resolution
1705     Is sicklied o'er with the pale cast of thought,
1706     And enterprises of great pitch and moment,
1707     With this regard their currents turn awry,
1708     And lose the name of action.-Soft you now,
1709     The fair Ophelia.-Nymph, in thy orisons
1710     Be all my sins remembered
1711    
1712     ROWID = 2
1713     FIXEDPOINT = NULL
1714     FLOATINGPOINT = NULL
1715     TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1716     BLOBDATA (Charset Id = 53 Codepage = 1252)
1717    
1718     To be or not to be-that is the question:
1719     Whether 'tis nobler in the mind to suffer
1720     The slings and arrows of outrageous fortune,
1721     Or to take arms against a sea of troubles,
1722     And, by opposing, end them. To die, to sleep-
1723     No more-and by a sleep to say we end
1724     The heartache and the thousand natural shocks
1725     That flesh is heir to-'tis a consummation
1726     Devoutly to be wished. To die, to sleep-
1727     To sleep, perchance to dream. Aye, there's the rub,
1728     For in that sleep of death what dreams may come,
1729     When we have shuffled off this mortal coil,
1730     Must give us pause. There's the respect
1731     That makes calamity of so long life.
1732     For who would bear the whips and scorns of time,
1733     Th' oppressor's wrong, the proud man's contumely,
1734     The pangs of despised love, the law’s delay,
1735     The insolence of office, and the spurns
1736     That patient merit of the unworthy takes,
1737     When he himself might his quietus make
1738     With a bare bodkin? Who would fardels bear,
1739     To grunt and sweat under a weary life,
1740     But that the dread of something after death,
1741     The undiscovered country from whose bourn
1742     No traveler returns, puzzles the will
1743     And makes us rather bear those ills we have
1744     Than fly to others that we know not of?
1745     Thus conscience does make cowards of us all,
1746     And thus the native hue of resolution
1747     Is sicklied o'er with the pale cast of thought,
1748     And enterprises of great pitch and moment,
1749     With this regard their currents turn awry,
1750     And lose the name of action.-Soft you now,
1751     The fair Ophelia.-Nymph, in thy orisons
1752     Be all my sins remembered
1753    
1754    
1755     Testing Blob as stored proc parameter
1756     Metadata
1757     SQLType =SQL_BLOB
1758     sub type = 1
1759     Table = TESTPROC
1760     Owner = SYSDBA
1761     Column Name = BLOBDATA
1762     Alias Name = BLOBDATA
1763     Field Name = BLOBDATA
1764     Scale = 0
1765     Charset id = 53
1766     Nullable
1767     Size = 8
1768    
1769     Blob Meta Data
1770     SQL SubType =1
1771     Table = TESTPROC
1772     Column = BLOBDATA
1773     CharSetID = 53
1774     Segment Size = 80
1775    
1776    
1777     BLOBDATA (Charset Id = 53 Codepage = 1252)
1778    
1779     To be or not to be-that is the question:
1780     Whether 'tis nobler in the mind to suffer
1781     The slings and arrows of outrageous fortune,
1782     Or to take arms against a sea of troubles,
1783     And, by opposing, end them. To die, to sleep-
1784     No more-and by a sleep to say we end
1785     The heartache and the thousand natural shocks
1786     That flesh is heir to-'tis a consummation
1787     Devoutly to be wished. To die, to sleep-
1788     To sleep, perchance to dream. Aye, there's the rub,
1789     For in that sleep of death what dreams may come,
1790     When we have shuffled off this mortal coil,
1791     Must give us pause. There's the respect
1792     That makes calamity of so long life.
1793     For who would bear the whips and scorns of time,
1794     Th' oppressor's wrong, the proud man's contumely,
1795     The pangs of despised love, the law’s delay,
1796     The insolence of office, and the spurns
1797     That patient merit of the unworthy takes,
1798     When he himself might his quietus make
1799     With a bare bodkin? Who would fardels bear,
1800     To grunt and sweat under a weary life,
1801     But that the dread of something after death,
1802     The undiscovered country from whose bourn
1803     No traveler returns, puzzles the will
1804     And makes us rather bear those ills we have
1805     Than fly to others that we know not of?
1806     Thus conscience does make cowards of us all,
1807     And thus the native hue of resolution
1808     Is sicklied o'er with the pale cast of thought,
1809     And enterprises of great pitch and moment,
1810     With this regard their currents turn awry,
1811     And lose the name of action.-Soft you now,
1812     The fair Ophelia.-Nymph, in thy orisons
1813     Be all my sins remembered
1814    
1815     Metadata
1816     SQLType =SQL_TEXT
1817     sub type = 0
1818     Table = RDB$CHARACTER_SETS
1819     Owner = SYSDBA
1820     Column Name = RDB$CHARACTER_SET_NAME
1821     Alias Name = RDB$CHARACTER_SET_NAME
1822     Field Name = RDB$CHARACTER_SET_NAME
1823     Scale = 0
1824     Charset id = 4
1825     Nullable
1826     Size = 252
1827    
1828     SQLType =SQL_SHORT
1829     sub type = 0
1830     Table = RDB$CHARACTER_SETS
1831     Owner = SYSDBA
1832     Column Name = RDB$CHARACTER_SET_ID
1833     Alias Name = RDB$CHARACTER_SET_ID
1834     Field Name = RDB$CHARACTER_SET_ID
1835     Scale = 0
1836     Charset id = 0
1837     Nullable
1838     Size = 2
1839    
1840     RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
1841     RDB$CHARACTER_SET_ID = 0
1842     RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
1843     RDB$CHARACTER_SET_ID = 1
1844     RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
1845     RDB$CHARACTER_SET_ID = 2
1846     RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
1847     RDB$CHARACTER_SET_ID = 3
1848     RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
1849     RDB$CHARACTER_SET_ID = 4
1850     RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
1851     RDB$CHARACTER_SET_ID = 5
1852     RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
1853     RDB$CHARACTER_SET_ID = 6
1854     RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
1855     RDB$CHARACTER_SET_ID = 9
1856     RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
1857     RDB$CHARACTER_SET_ID = 10
1858     RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
1859     RDB$CHARACTER_SET_ID = 11
1860     RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
1861     RDB$CHARACTER_SET_ID = 12
1862     RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
1863     RDB$CHARACTER_SET_ID = 13
1864     RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
1865     RDB$CHARACTER_SET_ID = 14
1866     RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
1867     RDB$CHARACTER_SET_ID = 15
1868     RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
1869     RDB$CHARACTER_SET_ID = 16
1870     RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
1871     RDB$CHARACTER_SET_ID = 17
1872     RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
1873     RDB$CHARACTER_SET_ID = 18
1874     RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
1875     RDB$CHARACTER_SET_ID = 19
1876     RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
1877     RDB$CHARACTER_SET_ID = 21
1878     RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
1879     RDB$CHARACTER_SET_ID = 22
1880     RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
1881     RDB$CHARACTER_SET_ID = 23
1882     RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
1883     RDB$CHARACTER_SET_ID = 34
1884     RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
1885     RDB$CHARACTER_SET_ID = 35
1886     RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
1887     RDB$CHARACTER_SET_ID = 36
1888     RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
1889     RDB$CHARACTER_SET_ID = 37
1890     RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
1891     RDB$CHARACTER_SET_ID = 38
1892     RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
1893     RDB$CHARACTER_SET_ID = 39
1894     RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
1895     RDB$CHARACTER_SET_ID = 40
1896     RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
1897     RDB$CHARACTER_SET_ID = 44
1898     RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
1899     RDB$CHARACTER_SET_ID = 45
1900     RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
1901     RDB$CHARACTER_SET_ID = 46
1902     RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
1903     RDB$CHARACTER_SET_ID = 47
1904     RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
1905     RDB$CHARACTER_SET_ID = 48
1906     RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
1907     RDB$CHARACTER_SET_ID = 49
1908     RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
1909     RDB$CHARACTER_SET_ID = 50
1910     RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
1911     RDB$CHARACTER_SET_ID = 51
1912     RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
1913     RDB$CHARACTER_SET_ID = 52
1914     RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
1915     RDB$CHARACTER_SET_ID = 53
1916     RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
1917     RDB$CHARACTER_SET_ID = 54
1918     RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
1919     RDB$CHARACTER_SET_ID = 55
1920     RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
1921     RDB$CHARACTER_SET_ID = 56
1922     RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
1923     RDB$CHARACTER_SET_ID = 57
1924     RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
1925     RDB$CHARACTER_SET_ID = 58
1926     RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
1927     RDB$CHARACTER_SET_ID = 59
1928     RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
1929     RDB$CHARACTER_SET_ID = 60
1930     RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
1931     RDB$CHARACTER_SET_ID = 63
1932     RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
1933     RDB$CHARACTER_SET_ID = 64
1934     RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
1935     RDB$CHARACTER_SET_ID = 65
1936     RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
1937     RDB$CHARACTER_SET_ID = 66
1938     RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
1939     RDB$CHARACTER_SET_ID = 67
1940     RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
1941     RDB$CHARACTER_SET_ID = 68
1942     RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
1943     RDB$CHARACTER_SET_ID = 69
1944    
1945     Metadata
1946     SQLType =SQL_LONG
1947     sub type = 0
1948     Table = TESTDATA
1949     Owner = SYSDBA
1950     Column Name = ROWID
1951     Alias Name = ROWID
1952     Field Name = ROWID
1953     Scale = 0
1954     Charset id = 0
1955     Not Null
1956     Size = 4
1957    
1958     SQLType =SQL_LONG
1959     sub type = 0
1960     Table = TESTDATA
1961     Owner = SYSDBA
1962     Column Name = FIXEDPOINT
1963     Alias Name = FIXEDPOINT
1964     Field Name = FIXEDPOINT
1965     Scale = -2
1966     Charset id = 0
1967     Nullable
1968     Size = 4
1969    
1970     SQLType =SQL_DOUBLE
1971     sub type = 0
1972     Table = TESTDATA
1973     Owner = SYSDBA
1974     Column Name = FLOATINGPOINT
1975     Alias Name = FLOATINGPOINT
1976     Field Name = FLOATINGPOINT
1977     Scale = 0
1978     Charset id = 0
1979     Nullable
1980     Size = 8
1981    
1982     SQLType =SQL_VARYING
1983     sub type = 0
1984     Table = TESTDATA
1985     Owner = SYSDBA
1986     Column Name = TITLE
1987     Alias Name = TITLE
1988     Field Name = TITLE
1989     Scale = 0
1990     Charset id = 4
1991     Nullable
1992     Size = 128
1993    
1994     SQLType =SQL_BLOB
1995     sub type = 1
1996     Table = TESTDATA
1997     Owner = SYSDBA
1998     Column Name = BLOBDATA
1999     Alias Name = BLOBDATA
2000     Field Name = BLOBDATA
2001     Scale = 0
2002     Charset id = 4
2003     Nullable
2004     Size = 8
2005    
2006     Blob Meta Data
2007     SQL SubType =1
2008     Table = TESTDATA
2009     Column = BLOBDATA
2010     CharSetID = 4
2011     Segment Size = 80
2012    
2013    
2014     SQL Params
2015     SQLType =SQL_LONG
2016     sub type = 0
2017     Field Name = ROWID
2018     Scale = 0
2019     Charset id = 0
2020     Not Null
2021     Size = 4
2022    
2023     SQLType =SQL_VARYING
2024     sub type = 0
2025     Field Name = TITLE
2026     Scale = 0
2027     Charset id = 4
2028     Nullable
2029     Size = 128
2030    
2031     SQLType =SQL_LONG
2032     sub type = 0
2033     Field Name = FP
2034     Scale = -2
2035     Charset id = 0
2036     Nullable
2037     Size = 4
2038    
2039     SQLType =SQL_DOUBLE
2040     sub type = 0
2041     Field Name = DP
2042     Scale = 0
2043     Charset id = 0
2044     Nullable
2045     Size = 8
2046    
2047     ROWID = 1
2048     FIXEDPOINT = 20.28
2049     FLOATINGPOINT = 3.14
2050     TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2051     BLOBDATA = NULL
2052    
2053     SQL Params
2054     SQLType =SQL_BLOB
2055     sub type = 1
2056     Field Name =
2057     Scale = 0
2058     Charset id = 4
2059     Nullable
2060     Size = 8
2061    
2062     SQLType =SQL_LONG
2063     sub type = 0
2064     Field Name =
2065     Scale = 0
2066     Charset id = 0
2067     Not Null
2068     Size = 4
2069    
2070     ROWID = 1
2071     FIXEDPOINT = 20.28
2072     FLOATINGPOINT = 3.14
2073     TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2074     BLOBDATA (Charset Id = 4 Codepage = 65001)
2075    
2076     To be or not to be-that is the question:
2077     Whether 'tis nobler in the mind to suffer
2078     The slings and arrows of outrageous fortune,
2079     Or to take arms against a sea of troubles,
2080     And, by opposing, end them. To die, to sleep-
2081     No more-and by a sleep to say we end
2082     The heartache and the thousand natural shocks
2083     That flesh is heir to-'tis a consummation
2084     Devoutly to be wished. To die, to sleep-
2085     To sleep, perchance to dream. Aye, there's the rub,
2086     For in that sleep of death what dreams may come,
2087     When we have shuffled off this mortal coil,
2088     Must give us pause. There's the respect
2089     That makes calamity of so long life.
2090     For who would bear the whips and scorns of time,
2091     Th' oppressor's wrong, the proud man's contumely,
2092     The pangs of despised love, the law’s delay,
2093     The insolence of office, and the spurns
2094     That patient merit of the unworthy takes,
2095     When he himself might his quietus make
2096     With a bare bodkin? Who would fardels bear,
2097     To grunt and sweat under a weary life,
2098     But that the dread of something after death,
2099     The undiscovered country from whose bourn
2100     No traveler returns, puzzles the will
2101     And makes us rather bear those ills we have
2102     Than fly to others that we know not of?
2103     Thus conscience does make cowards of us all,
2104     And thus the native hue of resolution
2105     Is sicklied o'er with the pale cast of thought,
2106     And enterprises of great pitch and moment,
2107     With this regard their currents turn awry,
2108     And lose the name of action.-Soft you now,
2109     The fair Ophelia.-Nymph, in thy orisons
2110     Be all my sins remembered
2111    
2112    
2113     SQL Params
2114     SQLType =SQL_LONG
2115     sub type = 0
2116     Field Name = ROWID
2117     Scale = 0
2118     Charset id = 0
2119     Not Null
2120     Size = 4
2121    
2122     SQLType =SQL_VARYING
2123     sub type = 0
2124     Field Name = TITLE
2125     Scale = 0
2126     Charset id = 4
2127     Nullable
2128     Size = 128
2129    
2130     SQLType =SQL_LONG
2131     sub type = 0
2132     Field Name = FP
2133     Scale = -2
2134     Charset id = 0
2135     Nullable
2136     Size = 4
2137    
2138     SQLType =SQL_DOUBLE
2139     sub type = 0
2140     Field Name = DP
2141     Scale = 0
2142     Charset id = 0
2143     Nullable
2144     Size = 8
2145    
2146     ROWID = 1
2147     FIXEDPOINT = 20.28
2148     FLOATINGPOINT = 3.14
2149     TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2150     BLOBDATA (Charset Id = 4 Codepage = 65001)
2151    
2152     To be or not to be-that is the question:
2153     Whether 'tis nobler in the mind to suffer
2154     The slings and arrows of outrageous fortune,
2155     Or to take arms against a sea of troubles,
2156     And, by opposing, end them. To die, to sleep-
2157     No more-and by a sleep to say we end
2158     The heartache and the thousand natural shocks
2159     That flesh is heir to-'tis a consummation
2160     Devoutly to be wished. To die, to sleep-
2161     To sleep, perchance to dream. Aye, there's the rub,
2162     For in that sleep of death what dreams may come,
2163     When we have shuffled off this mortal coil,
2164     Must give us pause. There's the respect
2165     That makes calamity of so long life.
2166     For who would bear the whips and scorns of time,
2167     Th' oppressor's wrong, the proud man's contumely,
2168     The pangs of despised love, the law’s delay,
2169     The insolence of office, and the spurns
2170     That patient merit of the unworthy takes,
2171     When he himself might his quietus make
2172     With a bare bodkin? Who would fardels bear,
2173     To grunt and sweat under a weary life,
2174     But that the dread of something after death,
2175     The undiscovered country from whose bourn
2176     No traveler returns, puzzles the will
2177     And makes us rather bear those ills we have
2178     Than fly to others that we know not of?
2179     Thus conscience does make cowards of us all,
2180     And thus the native hue of resolution
2181     Is sicklied o'er with the pale cast of thought,
2182     And enterprises of great pitch and moment,
2183     With this regard their currents turn awry,
2184     And lose the name of action.-Soft you now,
2185     The fair Ophelia.-Nymph, in thy orisons
2186     Be all my sins remembered
2187    
2188     ROWID = 2
2189     FIXEDPOINT = NULL
2190     FLOATINGPOINT = NULL
2191     TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2192     BLOBDATA (Charset Id = 4 Codepage = 65001)
2193    
2194     To be or not to be-that is the question:
2195     Whether 'tis nobler in the mind to suffer
2196     The slings and arrows of outrageous fortune,
2197     Or to take arms against a sea of troubles,
2198     And, by opposing, end them. To die, to sleep-
2199     No more-and by a sleep to say we end
2200     The heartache and the thousand natural shocks
2201     That flesh is heir to-'tis a consummation
2202     Devoutly to be wished. To die, to sleep-
2203     To sleep, perchance to dream. Aye, there's the rub,
2204     For in that sleep of death what dreams may come,
2205     When we have shuffled off this mortal coil,
2206     Must give us pause. There's the respect
2207     That makes calamity of so long life.
2208     For who would bear the whips and scorns of time,
2209     Th' oppressor's wrong, the proud man's contumely,
2210     The pangs of despised love, the law’s delay,
2211     The insolence of office, and the spurns
2212     That patient merit of the unworthy takes,
2213     When he himself might his quietus make
2214     With a bare bodkin? Who would fardels bear,
2215     To grunt and sweat under a weary life,
2216     But that the dread of something after death,
2217     The undiscovered country from whose bourn
2218     No traveler returns, puzzles the will
2219     And makes us rather bear those ills we have
2220     Than fly to others that we know not of?
2221     Thus conscience does make cowards of us all,
2222     And thus the native hue of resolution
2223     Is sicklied o'er with the pale cast of thought,
2224     And enterprises of great pitch and moment,
2225     With this regard their currents turn awry,
2226     And lose the name of action.-Soft you now,
2227     The fair Ophelia.-Nymph, in thy orisons
2228     Be all my sins remembered
2229    
2230    
2231     Testing Blob as stored proc parameter
2232     Metadata
2233     SQLType =SQL_BLOB
2234     sub type = 1
2235     Table = TESTPROC
2236     Owner = SYSDBA
2237     Column Name = BLOBDATA
2238     Alias Name = BLOBDATA
2239     Field Name = BLOBDATA
2240     Scale = 0
2241     Charset id = 4
2242     Nullable
2243     Size = 8
2244    
2245     Blob Meta Data
2246     SQL SubType =1
2247     Table = TESTPROC
2248     Column = BLOBDATA
2249     CharSetID = 4
2250     Segment Size = 80
2251    
2252    
2253     BLOBDATA (Charset Id = 4 Codepage = 65001)
2254    
2255     To be or not to be-that is the question:
2256     Whether 'tis nobler in the mind to suffer
2257     The slings and arrows of outrageous fortune,
2258     Or to take arms against a sea of troubles,
2259     And, by opposing, end them. To die, to sleep-
2260     No more-and by a sleep to say we end
2261     The heartache and the thousand natural shocks
2262     That flesh is heir to-'tis a consummation
2263     Devoutly to be wished. To die, to sleep-
2264     To sleep, perchance to dream. Aye, there's the rub,
2265     For in that sleep of death what dreams may come,
2266     When we have shuffled off this mortal coil,
2267     Must give us pause. There's the respect
2268     That makes calamity of so long life.
2269     For who would bear the whips and scorns of time,
2270     Th' oppressor's wrong, the proud man's contumely,
2271     The pangs of despised love, the law’s delay,
2272     The insolence of office, and the spurns
2273     That patient merit of the unworthy takes,
2274     When he himself might his quietus make
2275     With a bare bodkin? Who would fardels bear,
2276     To grunt and sweat under a weary life,
2277     But that the dread of something after death,
2278     The undiscovered country from whose bourn
2279     No traveler returns, puzzles the will
2280     And makes us rather bear those ills we have
2281     Than fly to others that we know not of?
2282     Thus conscience does make cowards of us all,
2283     And thus the native hue of resolution
2284     Is sicklied o'er with the pale cast of thought,
2285     And enterprises of great pitch and moment,
2286     With this regard their currents turn awry,
2287     And lose the name of action.-Soft you now,
2288     The fair Ophelia.-Nymph, in thy orisons
2289     Be all my sins remembered
2290    
2291    
2292    
2293     ------------------------------------------------------
2294     Running Test 7: Create and read back an Array
2295     Metadata
2296     SQLType =SQL_LONG
2297     sub type = 0
2298     Table = TESTDATA
2299     Owner = SYSDBA
2300     Column Name = ROWID
2301     Alias Name = ROWID
2302     Field Name = ROWID
2303     Scale = 0
2304     Charset id = 0
2305     Not Null
2306     Size = 4
2307    
2308     SQLType =SQL_VARYING
2309     sub type = 0
2310     Table = TESTDATA
2311     Owner = SYSDBA
2312     Column Name = TITLE
2313     Alias Name = TITLE
2314     Field Name = TITLE
2315     Scale = 0
2316     Charset id = 4
2317     Nullable
2318     Size = 128
2319    
2320     SQLType =SQL_TIMESTAMP
2321     sub type = 0
2322     Table = TESTDATA
2323     Owner = SYSDBA
2324     Column Name = DATED
2325     Alias Name = DATED
2326     Field Name = DATED
2327     Scale = 0
2328     Charset id = 0
2329     Nullable
2330     Size = 8
2331    
2332     SQLType =SQL_VARYING
2333     sub type = 0
2334     Table = TESTDATA
2335     Owner = SYSDBA
2336     Column Name = NOTES
2337     Alias Name = NOTES
2338     Field Name = NOTES
2339     Scale = 0
2340     Charset id = 4
2341     Nullable
2342     Size = 256
2343    
2344     SQLType =SQL_ARRAY
2345     sub type = 0
2346     Table = TESTDATA
2347     Owner = SYSDBA
2348     Column Name = MYARRAY
2349     Alias Name = MYARRAY
2350     Field Name = MYARRAY
2351     Scale = 0
2352     Charset id = 0
2353     Nullable
2354     Size = 8
2355     Array Meta Data:
2356     SQLType =SQL_LONG
2357     Scale = 0
2358     Charset id = 0
2359     Size = 4
2360     Table = TESTDATA
2361     Column = MYARRAY
2362     Dimensions = 1
2363     Bounds: (0:16)
2364    
2365     SQLType =SQL_ARRAY
2366     sub type = 0
2367     Table = TESTDATA
2368     Owner = SYSDBA
2369     Column Name = MYARRAY2
2370     Alias Name = MYARRAY2
2371     Field Name = MYARRAY2
2372     Scale = 0
2373     Charset id = 0
2374     Nullable
2375     Size = 8
2376     Array Meta Data:
2377     SQLType =SQL_TIMESTAMP
2378     Scale = 0
2379     Charset id = 0
2380     Size = 8
2381     Table = TESTDATA
2382     Column = MYARRAY2
2383     Dimensions = 1
2384     Bounds: (0:16)
2385    
2386     SQLType =SQL_ARRAY
2387     sub type = 0
2388     Table = TESTDATA
2389     Owner = SYSDBA
2390     Column Name = MYARRAY3
2391     Alias Name = MYARRAY3
2392     Field Name = MYARRAY3
2393     Scale = 0
2394     Charset id = 0
2395     Nullable
2396     Size = 8
2397     Array Meta Data:
2398     SQLType =SQL_INT64
2399     Scale = -2
2400     Charset id = 0
2401     Size = 8
2402     Table = TESTDATA
2403     Column = MYARRAY3
2404     Dimensions = 1
2405     Bounds: (0:16)
2406    
2407     SQL Params
2408     SQLType =SQL_LONG
2409     sub type = 0
2410     Field Name = ROWID
2411     Scale = 0
2412     Charset id = 0
2413     Not Null
2414     Size = 4
2415    
2416     SQLType =SQL_VARYING
2417     sub type = 0
2418     Field Name = TITLE
2419     Scale = 0
2420     Charset id = 4
2421     Nullable
2422     Size = 128
2423    
2424     SQLType =SQL_TIMESTAMP
2425     sub type = 0
2426     Field Name = DATED
2427     Scale = 0
2428     Charset id = 0
2429     Nullable
2430     Size = 8
2431    
2432     SQLType =SQL_VARYING
2433     sub type = 0
2434     Field Name = NOTES
2435     Scale = 0
2436     Charset id = 4
2437     Nullable
2438     Size = 256
2439    
2440     Param Name = ROWID
2441     Param Name = TITLE
2442     Param Name = DATED
2443     Param Name = NOTES
2444     ROWID = 1
2445     TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2446     DATED = 2016/04/01 09:30:00.1000
2447     NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2448     MYARRAY = NULL
2449     MYARRAY2 = NULL
2450     MYARRAY3 = NULL
2451    
2452     SQL Params
2453     SQLType =SQL_ARRAY
2454     sub type = 0
2455     Field Name = MYARRAY
2456     Scale = 0
2457     Charset id = 0
2458     Nullable
2459     Size = 8
2460    
2461     SQL Params
2462     SQLType =SQL_ARRAY
2463     sub type = 0
2464     Field Name = MYARRAY2
2465     Scale = 0
2466     Charset id = 0
2467     Nullable
2468     Size = 8
2469    
2470     SQL Params
2471     SQLType =SQL_ARRAY
2472     sub type = 0
2473     Field Name = MYARRAY3
2474     Scale = 0
2475     Charset id = 0
2476     Nullable
2477     Size = 8
2478    
2479     Metadata
2480     SQLType =SQL_LONG
2481     sub type = 0
2482     Table = TESTDATA
2483     Owner = SYSDBA
2484     Column Name = ROWID
2485     Alias Name = ROWID
2486     Field Name = ROWID
2487     Scale = 0
2488     Charset id = 0
2489     Not Null
2490     Size = 4
2491    
2492     SQLType =SQL_VARYING
2493     sub type = 0
2494     Table = TESTDATA
2495     Owner = SYSDBA
2496     Column Name = TITLE
2497     Alias Name = TITLE
2498     Field Name = TITLE
2499     Scale = 0
2500     Charset id = 4
2501     Nullable
2502     Size = 128
2503    
2504     SQLType =SQL_TIMESTAMP
2505     sub type = 0
2506     Table = TESTDATA
2507     Owner = SYSDBA
2508     Column Name = DATED
2509     Alias Name = DATED
2510     Field Name = DATED
2511     Scale = 0
2512     Charset id = 0
2513     Nullable
2514     Size = 8
2515    
2516     SQLType =SQL_VARYING
2517     sub type = 0
2518     Table = TESTDATA
2519     Owner = SYSDBA
2520     Column Name = NOTES
2521     Alias Name = NOTES
2522     Field Name = NOTES
2523     Scale = 0
2524     Charset id = 4
2525     Nullable
2526     Size = 256
2527    
2528     SQLType =SQL_ARRAY
2529     sub type = 0
2530     Table = TESTDATA
2531     Owner = SYSDBA
2532     Column Name = MYARRAY
2533     Alias Name = MYARRAY
2534     Field Name = MYARRAY
2535     Scale = 0
2536     Charset id = 0
2537     Nullable
2538     Size = 8
2539     Array Meta Data:
2540     SQLType =SQL_LONG
2541     Scale = 0
2542     Charset id = 0
2543     Size = 4
2544     Table = TESTDATA
2545     Column = MYARRAY
2546     Dimensions = 1
2547     Bounds: (0:16)
2548    
2549     SQLType =SQL_ARRAY
2550     sub type = 0
2551     Table = TESTDATA
2552     Owner = SYSDBA
2553     Column Name = MYARRAY2
2554     Alias Name = MYARRAY2
2555     Field Name = MYARRAY2
2556     Scale = 0
2557     Charset id = 0
2558     Nullable
2559     Size = 8
2560     Array Meta Data:
2561     SQLType =SQL_TIMESTAMP
2562     Scale = 0
2563     Charset id = 0
2564     Size = 8
2565     Table = TESTDATA
2566     Column = MYARRAY2
2567     Dimensions = 1
2568     Bounds: (0:16)
2569    
2570     SQLType =SQL_ARRAY
2571     sub type = 0
2572     Table = TESTDATA
2573     Owner = SYSDBA
2574     Column Name = MYARRAY3
2575     Alias Name = MYARRAY3
2576     Field Name = MYARRAY3
2577     Scale = 0
2578     Charset id = 0
2579     Nullable
2580     Size = 8
2581     Array Meta Data:
2582     SQLType =SQL_INT64
2583     Scale = -2
2584     Charset id = 0
2585     Size = 8
2586     Table = TESTDATA
2587     Column = MYARRAY3
2588     Dimensions = 1
2589     Bounds: (0:16)
2590    
2591     ROWID = 1
2592     TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2593     DATED = 2016/04/01 09:30:00.1000
2594     NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2595     MYARRAY = Array: (0: 100) (1: 99) (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84)
2596    
2597     MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00)
2598    
2599     MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79)
2600    
2601    
2602     Shrink to 2:10
2603     Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2604    
2605     Write updated reduced slice
2606     Show update array
2607     ROWID = 1
2608     TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2609     DATED = 2016/04/01 09:30:00.1000
2610     NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2611     MYARRAY = Array: (0: 100) (1: 99) (2: 1000) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84)
2612    
2613     MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00)
2614    
2615     MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79)
2616    
2617    
2618    
2619    
2620     ------------------------------------------------------
2621     Running Test 8: Create and read back an Array with 2 dimensions
2622     Metadata
2623     SQLType =SQL_LONG
2624     sub type = 0
2625     Table = TESTDATA
2626     Owner = SYSDBA
2627     Column Name = ROWID
2628     Alias Name = ROWID
2629     Field Name = ROWID
2630     Scale = 0
2631     Charset id = 0
2632     Not Null
2633     Size = 4
2634    
2635     SQLType =SQL_VARYING
2636     sub type = 0
2637     Table = TESTDATA
2638     Owner = SYSDBA
2639     Column Name = TITLE
2640     Alias Name = TITLE
2641     Field Name = TITLE
2642     Scale = 0
2643     Charset id = 4
2644     Nullable
2645     Size = 128
2646    
2647     SQLType =SQL_ARRAY
2648     sub type = 0
2649     Table = TESTDATA
2650     Owner = SYSDBA
2651     Column Name = MYARRAY
2652     Alias Name = MYARRAY
2653     Field Name = MYARRAY
2654     Scale = 0
2655     Charset id = 4
2656     Nullable
2657     Size = 8
2658     Array Meta Data:
2659     SQLType =SQL_VARYING
2660     Scale = 0
2661     Charset id = 4
2662     Size = 16
2663     Table = TESTDATA
2664     Column = MYARRAY
2665     Dimensions = 2
2666     Bounds: (0:16) (-1:7)
2667    
2668     SQL Params
2669     SQLType =SQL_LONG
2670     sub type = 0
2671     Field Name = ROWID
2672     Scale = 0
2673     Charset id = 0
2674     Not Null
2675     Size = 4
2676    
2677     SQLType =SQL_VARYING
2678     sub type = 0
2679     Field Name = TITLE
2680     Scale = 0
2681     Charset id = 4
2682     Nullable
2683     Size = 128
2684    
2685     ROWID = 1
2686     TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2687     MYARRAY = NULL
2688    
2689     ROWID = 1
2690     TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2691     MYARRAY = Array: (0,-1: A50) (0,0: A51) (0,1: A52) (0,2: A53) (0,3: A54) (0,4: A55) (0,5: A56) (0,6: A57) (0,7: A58) (1,-1: A59) (1,0: A60) (1,1: A61) (1,2: A62) (1,3: A63) (1,4: A64) (1,5: A65) (1,6: A66) (1,7: A67) (2,-1: A68) (2,0: A69) (2,1: A70) (2,2: A71) (2,3: A72) (2,4: A73) (2,5: A74) (2,6: A75) (2,7: A76) (3,-1: A77) (3,0: A78) (3,1: A79) (3,2: A80) (3,3: A81) (3,4: A82) (3,5: A83) (3,6: A84) (3,7: A85) (4,-1: A86) (4,0: A87) (4,1: A88) (4,2: A89) (4,3: A90) (4,4: A91) (4,5: A92) (4,6: A93) (4,7: A94) (5,-1: A95) (5,0: A96) (5,1: A97) (5,2: A98) (5,3: A99) (5,4: A100) (5,5: A101) (5,6: A102) (5,7: A103) (6,-1: A104) (6,0: A105) (6,1: A106) (6,2: A107) (6,3: A108) (6,4: A109) (6,5: A110) (6,6: A111) (6,7: A112) (7,-1: A113) (7,0: A114) (7,1: A115) (7,2: A116) (7,3: A117) (7,4: A118) (7,5: A119) (7,6: A120) (7,7: A121) (8,-1: A122) (8,0: A123) (8,1: A124) (8,2: A125) (8,3: A126) (8,4: A127) (8,5: A128) (8,6: A129) (8,7: A130) (9,-1: A131) (9,0: A132) (9,1: A133) (9,2: A134) (9,3: A135) (9,4: A136) (9,5: A137) (9,6: A138) (9,7: A139) (10,-1: A140) (10,0: A141) (10,1: A142) (10,2: A143) (10,3: A144) (10,4: A145) (10,5: A146) (10,6: A147) (10,7: A148) (11,-1: A149) (11,0: A150) (11,1: A151) (11,2: A152) (11,3: A153) (11,4: A154) (11,5: A155) (11,6: A156) (11,7: A157) (12,-1: A158) (12,0: A159) (12,1: A160) (12,2: A161) (12,3: A162) (12,4: A163) (12,5: A164) (12,6: A165) (12,7: A166) (13,-1: A167) (13,0: A168) (13,1: A169) (13,2: A170) (13,3: A171) (13,4: A172) (13,5: A173) (13,6: A174) (13,7: A175) (14,-1: A176) (14,0: A177) (14,1: A178) (14,2: A179) (14,3: A180) (14,4: A181) (14,5: A182) (14,6: A183) (14,7: A184) (15,-1: A185) (15,0: A186) (15,1: A187) (15,2: A188) (15,3: A189) (15,4: A190) (15,5: A191) (15,6: A192) (15,7: A193) (16,-1: A194) (16,0: A195) (16,1: A196) (16,2: A197) (16,3: A198) (16,4: A199) (16,5: A200) (16,6: A201) (16,7: A202)
2692    
2693    
2694    
2695    
2696     ------------------------------------------------------
2697     Running Test 9: Database Information tests
2698 tony 338 Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus
2699 tony 333 Pages =346
2700     Base Level = 13,4,0,3,
2701     Implementation = 11,7,0,3,66,1,66,
2702     Reserved = 0
2703     ODS minor = 0
2704     ODS major = 13
2705     Page Size = 8192
2706 tony 338 Version = 1: LI-V6.3.0.2496 Firebird 4.0
2707 tony 333 Database is Read/Write
2708 tony 338 Database Created: 29/5/2021 16:47:30
2709 tony 333 Pages Used = 310
2710     Pages Free = 36
2711 tony 338 Server Memory = 19481792
2712 tony 333 Forced Writes = 1
2713 tony 338 Max Memory = 19627808
2714 tony 333 Num Buffers = 2048
2715     Sweep Interval = 20000
2716     Logged in Users: SYSDBA,
2717     Active Transaction Count = 0
2718     Fetches = 1634
2719     Writes = 8
2720     Reads = 91
2721     Page Writes = 4
2722     Record Version Removals Operation Counts
2723    
2724     Deletes Operation Counts
2725    
2726     Expunge Count Operation Counts
2727    
2728     Insert Count Operation Counts
2729    
2730     Purge Count Countites Operation Counts
2731    
2732     Indexed Reads Count Operation Counts
2733     Table ID = 4
2734     Count = 63
2735     Table ID = 6
2736     Count = 23
2737     Table ID = 9
2738     Count = 3
2739     Table ID = 11
2740     Count = 2
2741     Table ID = 12
2742     Count = 24
2743     Table ID = 18
2744     Count = 805
2745     Table ID = 20
2746     Count = 5
2747     Table ID = 28
2748     Count = 2
2749     Table ID = 29
2750     Count = 2
2751     Table ID = 31
2752     Count = 1
2753    
2754     Sequential Table Scans Operation Counts
2755     Table ID = 0
2756     Count = 98
2757     Table ID = 1
2758     Count = 24
2759    
2760     Update Count Operation Counts
2761    
2762     Page Size = 8192
2763    
2764    
2765     ------------------------------------------------------
2766     Running Test 10: Event Handling
2767     Call Async Wait
2768     Async Wait Called
2769     Event Signalled
2770     First Event - usually ignored
2771     Signal Event
2772     Event Counts: TESTEVENT, Count = 1
2773     Two more events
2774     Call Async Wait
2775     Async Wait Called
2776     Event Signalled
2777     Event Signalled
2778     Deferred Events Caught
2779     Event Counts: TESTEVENT, Count = 2
2780     Signal Event
2781     Event Counts: TESTEVENT, Count = 1
2782     Async Wait: Test Cancel
2783     Event Signalled
2784     Async Wait Called
2785     Event Cancelled
2786     Time Out - Cancel Worked!
2787     Sync wait
2788     Event Signalled
2789     Event Counts: TESTEVENT, Count = 1
2790    
2791    
2792     ------------------------------------------------------
2793     Running Test 11: Services API
2794     SPB: Item Count = 2
2795     user_name = SYSDBA
2796     password = masterkey
2797    
2798     Service Manager Version = 2
2799 tony 338 Server Version = LI-V4.0.0.2496 Firebird 4.0
2800 tony 333 Implementation = Firebird/Linux/AMD/Intel/x64
2801    
2802     Lock Directory = /tmp/firebird/
2803 tony 338 Message File = /opt/firebird4.0.0/
2804     Security File = /opt/firebird4.0.0/security4.fdb
2805 tony 333
2806     DB Attachments
2807     No. of Attachments = 0
2808     Databases In Use = 0
2809    
2810     Sec. Database User
2811     User Name = SYSDBA
2812     First Name =
2813     Middle Name =
2814     Last Name =
2815     User ID = 0
2816     Group ID = 0
2817    
2818    
2819     Licence Info: feature is not supported
2820     -feature is not supported
2821    
2822     Licence Mask Info: feature is not supported
2823    
2824     Capabilities = 6
2825    
2826    
2827     Get Limbo transactions
2828    
2829     Limbo Transactions
2830    
2831    
2832     Local Backup
2833    
2834    
2835    
2836     Local Backup Complete
2837    
2838     Local Restore
2839    
2840    
2841    
2842    
2843    
2844    
2845     Local Restore Complete
2846    
2847     Open Database Check
2848     Database OK
2849     Database Dropped
2850    
2851    
2852     ------------------------------------------------------
2853     Running Test 12: Character Sets
2854     SQL Params
2855     SQLType =SQL_LONG
2856     sub type = 0
2857     Field Name = ROWID
2858     Scale = 0
2859     Charset id = 0
2860     Not Null
2861     Size = 4
2862    
2863     SQLType =SQL_VARYING
2864     sub type = 0
2865     Field Name = TITLE
2866     Scale = 0
2867     Charset id = 4
2868     Nullable
2869     Size = 128
2870    
2871     SQLType =SQL_VARYING
2872     sub type = 0
2873     Field Name = NOTES
2874     Scale = 0
2875     Charset id = 4
2876     Nullable
2877     Size = 256
2878    
2879     SQLType =SQL_BLOB
2880     sub type = 1
2881     Field Name = BLOBDATA
2882     Scale = 0
2883     Charset id = 4
2884     Nullable
2885     Size = 8
2886    
2887     SQLType =SQL_BLOB
2888     sub type = 1
2889     Field Name = BLOBDATA2
2890     Scale = 0
2891     Charset id = 4
2892     Nullable
2893     Size = 8
2894    
2895     SQLType =SQL_VARYING
2896     sub type = 0
2897     Field Name = INCLEAR
2898     Scale = 0
2899     Charset id = 1
2900     Nullable
2901     Size = 16
2902    
2903     SQLType =SQL_TEXT
2904     sub type = 0
2905     Field Name = FIXEDWIDTH
2906     Scale = 0
2907     Charset id = 4
2908     Nullable
2909     Size = 16
2910    
2911     Connection Character Set UTF8
2912     ROWID = 1
2913     TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2914     NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2915     BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2916     BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2917     INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2918     FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001)
2919    
2920     Connection Character Set NONE
2921     ROWID = 1
2922     TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2923     NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591)
2924     BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252)
2925     BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2926     INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2927     FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001)
2928    
2929     Connection Character Set WIN1252
2930     ROWID = 1
2931     TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252)
2932     NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252)
2933     BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252)
2934     BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252)
2935     INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2936     FIXEDWIDTH = C9 (Charset Id = 53 Codepage = 1252)
2937    
2938    
2939    
2940     ------------------------------------------------------
2941     Running Test 13: Transaction over two databases
2942     Init Database 1
2943     ROWID = 1
2944     TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2945     NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2946     BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2947     BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2948     INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2949    
2950     Init Database 2
2951     ROWID = 1
2952     TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
2953     NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2954     BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2955     BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2956     INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2957    
2958     ROWID = 1
2959     TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001)
2960     NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2961     BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2962     BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2963     INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2964    
2965     ROWID = 1
2966     TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001)
2967     NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
2968     BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2969     BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001)
2970     INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
2971    
2972    
2973    
2974     ------------------------------------------------------
2975     Running Test 14: Non select procedures
2976     Default Character set Name = UTF8
2977     Metadata
2978     SQLType =SQL_LONG
2979     sub type = 0
2980     Table = SHOWDATA
2981     Owner = SYSDBA
2982     Column Name = ROWID
2983     Alias Name = ROWID
2984     Field Name = ROWID
2985     Scale = 0
2986     Charset id = 0
2987     Nullable
2988     Size = 4
2989    
2990     SQLType =SQL_VARYING
2991     sub type = 0
2992     Table = SHOWDATA
2993     Owner = SYSDBA
2994     Column Name = TITLE
2995     Alias Name = TITLE
2996     Field Name = TITLE
2997     Scale = 0
2998     Charset id = 4
2999     Nullable
3000     Size = 128
3001    
3002     ROWID = 1
3003     TITLE = Testing (Charset Id = 4 Codepage = 65001)
3004    
3005     Repeat with a different execute transaction
3006    
3007     ROWID = 1
3008     TITLE = Testing (Charset Id = 4 Codepage = 65001)
3009    
3010     Repeat with a original transaction
3011    
3012     ROWID = 1
3013     TITLE = Testing (Charset Id = 4 Codepage = 65001)
3014    
3015    
3016     ------------------------------------------------------
3017     Running Test 15: Blob Handling and BPBs
3018    
3019     Testdata
3020    
3021     ROWID = 1
3022     TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3023     BLOBDATA = (blob), Length = 92514
3024    
3025    
3026     Testdata 2
3027    
3028     ROWID = 1
3029     TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3030     BLOBDATA (Charset Id = 4 Codepage = 65001)
3031    
3032     Écoute moi
3033    
3034    
3035    
3036     ------------------------------------------------------
3037     Running Test 16: Error handling
3038     Invalid Database Name Test
3039     Error Handled: I/O error during "open" operation for file "Malformed Name"
3040     -Error while trying to open file
3041     -No such file or directory
3042     Invalid User Name Test
3043     Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3044     Invalid password Test
3045     Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3046     Invalid Prepare SQL Test
3047     Error Handled: Dynamic SQL Error
3048     -SQL error code = -206
3049     -Column unknown
3050     -UNKNOWN_DATE
3051     -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3052     Invalid Open Cursor SQL Test
3053     Error Handled: Dynamic SQL Error
3054     -SQL error code = -206
3055     -Column unknown
3056     -X
3057     -At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE
3058     Transaction not started Test
3059     Error Handled: Transaction is not active
3060     Invalid Param SQL Type Test
3061     Error Handled: Field "EMP_NO" not found
3062     Case sensitive Param SQL Test
3063     Error Handled: Field "EMP_NO" not found
3064     Invalid Server Name Test
3065     Error Handled: Unable to complete network request to host "unknown".
3066     -Failed to locate host machine.
3067     -The specified name was not found in the hosts file or Domain Name Services
3068     Invalid User Name Test
3069     Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3070     Invalid password Test
3071     Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3072    
3073    
3074     ------------------------------------------------------
3075     Running Test 17: Date/Time tests and Firebird 4 extensions
3076 tony 338 FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
3077 tony 333 Has Local TZ DB = TRUE
3078    
3079     Testdata
3080    
3081     Metadata
3082     SQLType =SQL_LONG
3083     sub type = 0
3084     Table = TESTDATA
3085     Owner = SYSDBA
3086     Column Name = ROWID
3087     Alias Name = ROWID
3088     Field Name = ROWID
3089     Scale = 0
3090     Charset id = 0
3091     Not Null
3092     Size = 4
3093    
3094     SQLType =SQL_TYPE_DATE
3095     sub type = 0
3096     Table = TESTDATA
3097     Owner = SYSDBA
3098     Column Name = DATECOL
3099     Alias Name = DATECOL
3100     Field Name = DATECOL
3101     Scale = 0
3102     Charset id = 0
3103     Nullable
3104     Size = 4
3105    
3106     SQLType =SQL_TYPE_TIME
3107     sub type = 0
3108     Table = TESTDATA
3109     Owner = SYSDBA
3110     Column Name = TIMECOL
3111     Alias Name = TIMECOL
3112     Field Name = TIMECOL
3113     Scale = 0
3114     Charset id = 0
3115     Nullable
3116     Size = 4
3117    
3118     SQLType =SQL_TIMESTAMP
3119     sub type = 0
3120     Table = TESTDATA
3121     Owner = SYSDBA
3122     Column Name = TIMESTAMPCOL
3123     Alias Name = TIMESTAMPCOL
3124     Field Name = TIMESTAMPCOL
3125     Scale = 0
3126     Charset id = 0
3127     Nullable
3128     Size = 8
3129    
3130     ROWID = 1
3131     DATECOL = 2019/04/01
3132     TIMECOL = 11:31:05.0001
3133     TIMESTAMPCOL = 2016/02/29 22:02:35.0001
3134     ROWID = 2
3135     DATECOL = 1939/09/03
3136     TIMECOL = 15:40:00.0002
3137     TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3138     ROWID = 3
3139     DATECOL = 1066/10/14
3140     TIMECOL = 23:59:59.9994
3141     TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3142     ROWID = 4
3143     DATECOL = 1815/06/18
3144     TIMECOL = 00:01:40.1115
3145     TIMESTAMPCOL = 1945/05/08 22:10:00.0010
3146    
3147    
3148     Testdata - second pass
3149    
3150     1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
3151     2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3152     3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
3153     4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
3154     Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1
3155    
3156     Firebird 4 extension types
3157     ==========================
3158    
3159    
3160     Using local FB Client with server TZ database
3161    
3162     Local Time Zone Name = Europe/London, ID = 65071
3163     Test Time Zone Setting
3164     Time Zone GMT = GMT
3165     Time Zone Zagreb = Europe/Zagreb
3166     Time Zone Offset -08:00 = -08:00
3167     Time Zone Offset +13:39 = +13:39
3168     Time Zone ID = 1799
3169     Time Zone ID = 959, UTC Time = 23/1/2020 10:30:00
3170     Time Zone ID = 64920
3171     Local Time Zone ID = 65071
3172     Local Time = 22/1/2020 18:30:00, Time Zone = -08:00
3173     Time Zone Offset = 60
3174     Time Zone Offset = 60
3175     Time Zone Offset = 60
3176     Time Zone Offset = 0
3177     Time Zone Offset = 60
3178     Time Zone Offset = Bad Timestamp or missing time zone DB entry (26/3/1989 01:30:00) TZ ID = 65071
3179     Date = 29/11/1969 23:30:00, TimeZone = GMT
3180     Date = 01/4/2001 22:30:10.0010, TimeZone = -08:00
3181     Time = 23:59:10.2000, TimeZone = Europe/London
3182     Show Parameter 2
3183     =
3184     AsString = 11/11/1918 00:11:00.0000 +04:00
3185     Formatted = 1918/11/11 00:11:00.0000 +04:00
3186     TimeZoneID = 1679
3187     Time Zone Name = +04:00
3188     UTC Time = 10/11/1918 20:11:00
3189     DST Offset = 240
3190    
3191     FB4 Testdata_TZ
3192    
3193     Metadata
3194     SQLType =SQL_LONG
3195     sub type = 0
3196     Table = FB4TESTDATA_TZ
3197     Owner = SYSDBA
3198     Column Name = ROWID
3199     Alias Name = ROWID
3200     Field Name = ROWID
3201     Scale = 0
3202     Charset id = 0
3203     Not Null
3204     Size = 4
3205    
3206     SQLType =SQL_TIME_TZ
3207     sub type = 0
3208     Table = FB4TESTDATA_TZ
3209     Owner = SYSDBA
3210     Column Name = TIMECOL
3211     Alias Name = TIMECOL
3212     Field Name = TIMECOL
3213     Scale = 0
3214     Charset id = 0
3215     Nullable
3216     Size = 8
3217    
3218     SQLType =SQL_TIMESTAMP_TZ
3219     sub type = 0
3220     Table = FB4TESTDATA_TZ
3221     Owner = SYSDBA
3222     Column Name = TIMESTAMPCOL
3223     Alias Name = TIMESTAMPCOL
3224     Field Name = TIMESTAMPCOL
3225     Scale = 0
3226     Charset id = 0
3227     Nullable
3228     Size = 12
3229    
3230     SQLType =SQL_SHORT
3231     sub type = 0
3232     Table =
3233     Owner =
3234     Column Name = EXTRACT
3235     Alias Name = TZ_HOUR
3236     Field Name = TZ_HOUR
3237     Scale = 0
3238     Charset id = 0
3239     Nullable
3240     Size = 2
3241    
3242     SQLType =SQL_SHORT
3243     sub type = 0
3244     Table =
3245     Owner =
3246     Column Name = EXTRACT
3247     Alias Name = TZ_MINUTE
3248     Field Name = TZ_MINUTE
3249     Scale = 0
3250     Charset id = 0
3251     Nullable
3252     Size = 2
3253    
3254     ROWID = 1
3255     TIMECOL =
3256     AsString = 11:32:10.0002 -05:00
3257     Formatted = 11:32:10.0002 -05:00
3258     TimeZoneID = 1139
3259     Time Zone Name = -05:00
3260     UTC Time = 16:32:10
3261     DST Offset = -300
3262     TIMESTAMPCOL =
3263     AsString = 01/4/2020 11:31:05.0001 +01:00
3264     Formatted = 2020/04/01 11:31:05.0001 +01:00
3265     TimeZoneID = 1499
3266     Time Zone Name = +01:00
3267     UTC Time = 01/4/2020 10:31:05
3268     DST Offset = 60
3269     TZ_HOUR = -5
3270     TZ_MINUTE = 0
3271     ROWID = 2
3272     TIMECOL =
3273     AsString = 14:02:10.0050 -08:00
3274     Formatted = 14:02:10.0050 -08:00
3275     TimeZoneID = 959
3276     Time Zone Name = -08:00
3277     UTC Time = 22:02:10
3278     DST Offset = -480
3279     TIMESTAMPCOL =
3280     AsString = 11/11/1918 11:11:00.0000 00:00
3281     Formatted = 1918/11/11 11:11:00.0000 Europe/London
3282     TimeZoneID = 65071
3283     Time Zone Name = Europe/London
3284     UTC Time = 11/11/1918 11:11:00
3285     DST Offset = 0
3286     TZ_HOUR = -8
3287     TZ_MINUTE = 0
3288     ROWID = 3
3289     TIMECOL =
3290     AsString = 22:02:10.0050 -08:00
3291     Formatted = 22:02:10.0050 -08:00
3292     TimeZoneID = 959
3293     Time Zone Name = -08:00
3294     UTC Time = 06:02:10
3295     DST Offset = -480
3296     TIMESTAMPCOL =
3297     AsString = 11/11/1918 00:11:00.0000 +04:00
3298     Formatted = 1918/11/11 00:11:00.0000 +04:00
3299     TimeZoneID = 1679
3300     Time Zone Name = +04:00
3301     UTC Time = 10/11/1918 20:11:00
3302     DST Offset = 240
3303     TZ_HOUR = -8
3304     TZ_MINUTE = 0
3305     ROWID = 4
3306     TIMECOL =
3307     AsString = 14:02:10.5000 -08:00
3308     Formatted = 14:02:10.5000 -08:00
3309     TimeZoneID = 959
3310     Time Zone Name = -08:00
3311     UTC Time = 22:02:10
3312     DST Offset = -480
3313     TIMESTAMPCOL =
3314     AsString = 11/11/1918 11:11:00.0000 00:00
3315     Formatted = 1918/11/11 11:11:00.0000 Europe/London
3316     TimeZoneID = 65071
3317     Time Zone Name = Europe/London
3318     UTC Time = 11/11/1918 11:11:00
3319     DST Offset = 0
3320     TZ_HOUR = -8
3321     TZ_MINUTE = 0
3322     ROWID = 5
3323     TIMECOL =
3324     AsString = 11:31:05.0001 -05:00
3325     Formatted = 11:31:05.0001 America/New_York
3326     TimeZoneID = 65361
3327     Time Zone Name = America/New_York
3328     UTC Time = 16:31:05
3329     DST Offset = -300
3330     TIMESTAMPCOL =
3331     AsString = 04/7/2020 07:00:00.0000 -04:00
3332     Formatted = 2020/07/04 07:00:00.0000 America/New_York
3333     TimeZoneID = 65361
3334     Time Zone Name = America/New_York
3335     UTC Time = 04/7/2020 11:00:00
3336     DST Offset = -240
3337     TZ_HOUR = -5
3338     TZ_MINUTE = 0
3339     ROWID = 6
3340     TIMECOL =
3341     AsString = 11:31:05.0001 -05:00
3342     Formatted = 11:31:05.0001 EST5EDT
3343     TimeZoneID = 65135
3344     Time Zone Name = EST5EDT
3345     UTC Time = 16:31:05
3346     DST Offset = -300
3347     TIMESTAMPCOL =
3348     AsString = 01/7/2020 07:00:00.0000 -04:00
3349     Formatted = 2020/07/01 07:00:00.0000 America/New_York
3350     TimeZoneID = 65361
3351     Time Zone Name = America/New_York
3352     UTC Time = 01/7/2020 11:00:00
3353     DST Offset = -240
3354     TZ_HOUR = -5
3355     TZ_MINUTE = 0
3356     ROWID = 7
3357     TIMECOL =
3358     AsString = 11:31:05.0001 +06:00
3359     Formatted = 11:31:05.0001 BST
3360     TimeZoneID = 65162
3361     Time Zone Name = BST
3362     UTC Time = 05:31:05
3363     DST Offset = 360
3364     TIMESTAMPCOL =
3365     AsString = 01/7/2020 07:00:00.0000 -04:00
3366     Formatted = 2020/07/01 07:00:00.0000 EST5EDT
3367     TimeZoneID = 65135
3368     Time Zone Name = EST5EDT
3369     UTC Time = 01/7/2020 11:00:00
3370     DST Offset = -240
3371     TZ_HOUR = 6
3372     TZ_MINUTE = 0
3373     ROWID = 8
3374     TIMECOL =
3375     AsString = 11:31:05.0001 +01:00
3376     Formatted = 11:31:05.0001 Europe/Paris
3377     TimeZoneID = 65061
3378     Time Zone Name = Europe/Paris
3379     UTC Time = 10:31:05
3380     DST Offset = 60
3381     TIMESTAMPCOL =
3382     AsString = 01/7/2020 06:00:00.0000 -05:00
3383     Formatted = 2020/07/01 06:00:00.0000 EST
3384     TimeZoneID = 65136
3385     Time Zone Name = EST
3386     UTC Time = 01/7/2020 11:00:00
3387     DST Offset = -300
3388     TZ_HOUR = 1
3389     TZ_MINUTE = 0
3390    
3391    
3392     Using local TZ database
3393    
3394     Test Time Zone Setting
3395     Time Zone GMT = GMT
3396     Time Zone Zagreb = Europe/Zagreb
3397     Time Zone Offset -08:00 = -08:00
3398     Time Zone Offset +13:39 = +13:39
3399     Time Zone ID = 1799
3400     Time Zone ID = 959, UTC Time = 23/1/2020 10:30:00
3401     Time Zone ID = 64920
3402     Local Time Zone ID = 65071
3403     Local Time = 23/1/2020 10:30:00, Time Zone = -08:00
3404     Time Zone Offset = 60
3405     Time Zone Offset = 60
3406     Time Zone Offset = 60
3407     Time Zone Offset = 0
3408     Time Zone Offset = 60
3409     Time Zone Offset = 0
3410     Date = 29/11/1969 23:30:00, TimeZone = GMT
3411     Date = 01/4/2001 22:30:10.0010, TimeZone = -08:00
3412     Time = 23:59:10.2000, TimeZone = Europe/London
3413     Show Parameter 2
3414     =
3415     AsString = 11/11/1918 00:11:00.0000 +04:00
3416     Formatted = 1918/11/11 00:11:00.0000 +04:00
3417     TimeZoneID = 1679
3418     Time Zone Name = +04:00
3419     UTC Time = 10/11/1918 20:11:00
3420     DST Offset = 240
3421    
3422     FB4 Testdata_TZ
3423    
3424     Metadata
3425     SQLType =SQL_LONG
3426     sub type = 0
3427     Table = FB4TESTDATA_TZ
3428     Owner = SYSDBA
3429     Column Name = ROWID
3430     Alias Name = ROWID
3431     Field Name = ROWID
3432     Scale = 0
3433     Charset id = 0
3434     Not Null
3435     Size = 4
3436    
3437     SQLType =SQL_TIME_TZ
3438     sub type = 0
3439     Table = FB4TESTDATA_TZ
3440     Owner = SYSDBA
3441     Column Name = TIMECOL
3442     Alias Name = TIMECOL
3443     Field Name = TIMECOL
3444     Scale = 0
3445     Charset id = 0
3446     Nullable
3447     Size = 8
3448    
3449     SQLType =SQL_TIMESTAMP_TZ
3450     sub type = 0
3451     Table = FB4TESTDATA_TZ
3452     Owner = SYSDBA
3453     Column Name = TIMESTAMPCOL
3454     Alias Name = TIMESTAMPCOL
3455     Field Name = TIMESTAMPCOL
3456     Scale = 0
3457     Charset id = 0
3458     Nullable
3459     Size = 12
3460    
3461     SQLType =SQL_SHORT
3462     sub type = 0
3463     Table =
3464     Owner =
3465     Column Name = EXTRACT
3466     Alias Name = TZ_HOUR
3467     Field Name = TZ_HOUR
3468     Scale = 0
3469     Charset id = 0
3470     Nullable
3471     Size = 2
3472    
3473     SQLType =SQL_SHORT
3474     sub type = 0
3475     Table =
3476     Owner =
3477     Column Name = EXTRACT
3478     Alias Name = TZ_MINUTE
3479     Field Name = TZ_MINUTE
3480     Scale = 0
3481     Charset id = 0
3482     Nullable
3483     Size = 2
3484    
3485     ROWID = 1
3486     TIMECOL =
3487     AsString = 11:32:10.0002 -05:00
3488     Formatted = 11:32:10.0002 -05:00
3489     TimeZoneID = 1139
3490     Time Zone Name = -05:00
3491     UTC Time = 16:32:10
3492     DST Offset = -300
3493     TIMESTAMPCOL =
3494     AsString = 01/4/2020 11:31:05.0001 +01:00
3495     Formatted = 2020/04/01 11:31:05.0001 +01:00
3496     TimeZoneID = 1499
3497     Time Zone Name = +01:00
3498     UTC Time = 01/4/2020 10:31:05
3499     DST Offset = 60
3500     TZ_HOUR = -5
3501     TZ_MINUTE = 0
3502     ROWID = 2
3503     TIMECOL =
3504     AsString = 14:02:10.0050 -08:00
3505     Formatted = 14:02:10.0050 -08:00
3506     TimeZoneID = 959
3507     Time Zone Name = -08:00
3508     UTC Time = 22:02:10
3509     DST Offset = -480
3510     TIMESTAMPCOL =
3511     AsString = 11/11/1918 11:11:00.0000 00:00
3512     Formatted = 1918/11/11 11:11:00.0000 Europe/London
3513     TimeZoneID = 65071
3514     Time Zone Name = Europe/London
3515     UTC Time = 11/11/1918 11:11:00
3516     DST Offset = 0
3517     TZ_HOUR = -8
3518     TZ_MINUTE = 0
3519     ROWID = 3
3520     TIMECOL =
3521     AsString = 22:02:10.0050 -08:00
3522     Formatted = 22:02:10.0050 -08:00
3523     TimeZoneID = 959
3524     Time Zone Name = -08:00
3525     UTC Time = 06:02:10
3526     DST Offset = -480
3527     TIMESTAMPCOL =
3528     AsString = 11/11/1918 00:11:00.0000 +04:00
3529     Formatted = 1918/11/11 00:11:00.0000 +04:00
3530     TimeZoneID = 1679
3531     Time Zone Name = +04:00
3532     UTC Time = 10/11/1918 20:11:00
3533     DST Offset = 240
3534     TZ_HOUR = -8
3535     TZ_MINUTE = 0
3536     ROWID = 4
3537     TIMECOL =
3538     AsString = 14:02:10.5000 -08:00
3539     Formatted = 14:02:10.5000 -08:00
3540     TimeZoneID = 959
3541     Time Zone Name = -08:00
3542     UTC Time = 22:02:10
3543     DST Offset = -480
3544     TIMESTAMPCOL =
3545     AsString = 11/11/1918 11:11:00.0000 00:00
3546     Formatted = 1918/11/11 11:11:00.0000 Europe/London
3547     TimeZoneID = 65071
3548     Time Zone Name = Europe/London
3549     UTC Time = 11/11/1918 11:11:00
3550     DST Offset = 0
3551     TZ_HOUR = -8
3552     TZ_MINUTE = 0
3553     ROWID = 5
3554     TIMECOL =
3555     AsString = 11:31:05.0001 -05:00
3556     Formatted = 11:31:05.0001 America/New_York
3557     TimeZoneID = 65361
3558     Time Zone Name = America/New_York
3559     UTC Time = 16:31:05
3560     DST Offset = -300
3561     TIMESTAMPCOL =
3562     AsString = 04/7/2020 07:00:00.0000 -04:00
3563     Formatted = 2020/07/04 07:00:00.0000 America/New_York
3564     TimeZoneID = 65361
3565     Time Zone Name = America/New_York
3566     UTC Time = 04/7/2020 11:00:00
3567     DST Offset = -240
3568     TZ_HOUR = -5
3569     TZ_MINUTE = 0
3570     ROWID = 6
3571     TIMECOL =
3572     AsString = 11:31:05.0001 -05:00
3573     Formatted = 11:31:05.0001 EST5EDT
3574     TimeZoneID = 65135
3575     Time Zone Name = EST5EDT
3576     UTC Time = 16:31:05
3577     DST Offset = -300
3578     TIMESTAMPCOL =
3579     AsString = 01/7/2020 07:00:00.0000 -04:00
3580     Formatted = 2020/07/01 07:00:00.0000 America/New_York
3581     TimeZoneID = 65361
3582     Time Zone Name = America/New_York
3583     UTC Time = 01/7/2020 11:00:00
3584     DST Offset = -240
3585     TZ_HOUR = -5
3586     TZ_MINUTE = 0
3587     ROWID = 7
3588     TIMECOL =
3589     AsString = 11:31:05.0001 +06:00
3590     Formatted = 11:31:05.0001 BST
3591     TimeZoneID = 65162
3592     Time Zone Name = BST
3593     UTC Time = 05:31:05
3594     DST Offset = 360
3595     TIMESTAMPCOL =
3596     AsString = 01/7/2020 07:00:00.0000 -04:00
3597     Formatted = 2020/07/01 07:00:00.0000 EST5EDT
3598     TimeZoneID = 65135
3599     Time Zone Name = EST5EDT
3600     UTC Time = 01/7/2020 11:00:00
3601     DST Offset = -240
3602     TZ_HOUR = 6
3603     TZ_MINUTE = 0
3604     ROWID = 8
3605     TIMECOL =
3606     AsString = 11:31:05.0001 +01:00
3607     Formatted = 11:31:05.0001 Europe/Paris
3608     TimeZoneID = 65061
3609     Time Zone Name = Europe/Paris
3610     UTC Time = 10:31:05
3611     DST Offset = 60
3612     TIMESTAMPCOL =
3613     AsString = 01/7/2020 06:00:00.0000 -05:00
3614     Formatted = 2020/07/01 06:00:00.0000 EST
3615     TimeZoneID = 65136
3616     Time Zone Name = EST
3617     UTC Time = 01/7/2020 11:00:00
3618     DST Offset = -300
3619     TZ_HOUR = 1
3620     TZ_MINUTE = 0
3621    
3622    
3623     Using Extended TZ Data Type
3624    
3625     Show Parameter 2
3626     =
3627     AsString = 11/11/1918 00:11:00.0000 +04:00
3628     Formatted = 1918/11/11 00:11:00.0000 +04:00
3629     TimeZoneID = 1679
3630     Time Zone Name = +04:00
3631     UTC Time = 10/11/1918 20:11:00
3632     DST Offset = 240
3633    
3634     FB4 Testdata_TZ
3635    
3636     Metadata
3637     SQLType =SQL_LONG
3638     sub type = 0
3639     Table = FB4TESTDATA_TZ
3640     Owner = SYSDBA
3641     Column Name = ROWID
3642     Alias Name = ROWID
3643     Field Name = ROWID
3644     Scale = 0
3645     Charset id = 0
3646     Not Null
3647     Size = 4
3648    
3649     SQLType =SQL_TIME_TZ_EX
3650     sub type = 0
3651     Table = FB4TESTDATA_TZ
3652     Owner = SYSDBA
3653     Column Name = TIMECOL
3654     Alias Name = TIMECOL
3655     Field Name = TIMECOL
3656     Scale = 0
3657     Charset id = 0
3658     Nullable
3659     Size = 8
3660    
3661     SQLType =SQL_TIMESTAMP_TZ_EX
3662     sub type = 0
3663     Table = FB4TESTDATA_TZ
3664     Owner = SYSDBA
3665     Column Name = TIMESTAMPCOL
3666     Alias Name = TIMESTAMPCOL
3667     Field Name = TIMESTAMPCOL
3668     Scale = 0
3669     Charset id = 0
3670     Nullable
3671     Size = 12
3672    
3673     SQLType =SQL_SHORT
3674     sub type = 0
3675     Table =
3676     Owner =
3677     Column Name = EXTRACT
3678     Alias Name = TZ_HOUR
3679     Field Name = TZ_HOUR
3680     Scale = 0
3681     Charset id = 0
3682     Nullable
3683     Size = 2
3684    
3685     SQLType =SQL_SHORT
3686     sub type = 0
3687     Table =
3688     Owner =
3689     Column Name = EXTRACT
3690     Alias Name = TZ_MINUTE
3691     Field Name = TZ_MINUTE
3692     Scale = 0
3693     Charset id = 0
3694     Nullable
3695     Size = 2
3696    
3697     ROWID = 1
3698     TIMECOL =
3699     AsString = 11:32:10.0002 -05:00
3700     Formatted = 11:32:10.0002 -05:00
3701     TimeZoneID = 1139
3702     Time Zone Name = -05:00
3703     UTC Time = 16:32:10
3704     DST Offset = -300
3705     TIMESTAMPCOL =
3706     AsString = 01/4/2020 11:31:05.0001 +01:00
3707     Formatted = 2020/04/01 11:31:05.0001 +01:00
3708     TimeZoneID = 1499
3709     Time Zone Name = +01:00
3710     UTC Time = 01/4/2020 10:31:05
3711     DST Offset = 60
3712     TZ_HOUR = -5
3713     TZ_MINUTE = 0
3714     ROWID = 2
3715     TIMECOL =
3716     AsString = 14:02:10.0050 -08:00
3717     Formatted = 14:02:10.0050 -08:00
3718     TimeZoneID = 959
3719     Time Zone Name = -08:00
3720     UTC Time = 22:02:10
3721     DST Offset = -480
3722     TIMESTAMPCOL =
3723     AsString = 11/11/1918 11:11:00.0000 00:00
3724     Formatted = 1918/11/11 11:11:00.0000 Europe/London
3725     TimeZoneID = 65071
3726     Time Zone Name = Europe/London
3727     UTC Time = 11/11/1918 11:11:00
3728     DST Offset = 0
3729     TZ_HOUR = -8
3730     TZ_MINUTE = 0
3731     ROWID = 3
3732     TIMECOL =
3733     AsString = 22:02:10.0050 -08:00
3734     Formatted = 22:02:10.0050 -08:00
3735     TimeZoneID = 959
3736     Time Zone Name = -08:00
3737     UTC Time = 06:02:10
3738     DST Offset = -480
3739     TIMESTAMPCOL =
3740     AsString = 11/11/1918 00:11:00.0000 +04:00
3741     Formatted = 1918/11/11 00:11:00.0000 +04:00
3742     TimeZoneID = 1679
3743     Time Zone Name = +04:00
3744     UTC Time = 10/11/1918 20:11:00
3745     DST Offset = 240
3746     TZ_HOUR = -8
3747     TZ_MINUTE = 0
3748     ROWID = 4
3749     TIMECOL =
3750     AsString = 14:02:10.5000 -08:00
3751     Formatted = 14:02:10.5000 -08:00
3752     TimeZoneID = 959
3753     Time Zone Name = -08:00
3754     UTC Time = 22:02:10
3755     DST Offset = -480
3756     TIMESTAMPCOL =
3757     AsString = 11/11/1918 11:11:00.0000 00:00
3758     Formatted = 1918/11/11 11:11:00.0000 Europe/London
3759     TimeZoneID = 65071
3760     Time Zone Name = Europe/London
3761     UTC Time = 11/11/1918 11:11:00
3762     DST Offset = 0
3763     TZ_HOUR = -8
3764     TZ_MINUTE = 0
3765     ROWID = 5
3766     TIMECOL =
3767     AsString = 11:31:05.0001 -05:00
3768     Formatted = 11:31:05.0001 America/New_York
3769     TimeZoneID = 65361
3770     Time Zone Name = America/New_York
3771     UTC Time = 16:31:05
3772     DST Offset = -300
3773     TIMESTAMPCOL =
3774     AsString = 04/7/2020 07:00:00.0000 -04:00
3775     Formatted = 2020/07/04 07:00:00.0000 America/New_York
3776     TimeZoneID = 65361
3777     Time Zone Name = America/New_York
3778     UTC Time = 04/7/2020 11:00:00
3779     DST Offset = -240
3780     TZ_HOUR = -5
3781     TZ_MINUTE = 0
3782     ROWID = 6
3783     TIMECOL =
3784     AsString = 11:31:05.0001 -05:00
3785     Formatted = 11:31:05.0001 EST5EDT
3786     TimeZoneID = 65135
3787     Time Zone Name = EST5EDT
3788     UTC Time = 16:31:05
3789     DST Offset = -300
3790     TIMESTAMPCOL =
3791     AsString = 01/7/2020 07:00:00.0000 -04:00
3792     Formatted = 2020/07/01 07:00:00.0000 America/New_York
3793     TimeZoneID = 65361
3794     Time Zone Name = America/New_York
3795     UTC Time = 01/7/2020 11:00:00
3796     DST Offset = -240
3797     TZ_HOUR = -5
3798     TZ_MINUTE = 0
3799     ROWID = 7
3800     TIMECOL =
3801     AsString = 11:31:05.0001 +06:00
3802     Formatted = 11:31:05.0001 BST
3803     TimeZoneID = 65162
3804     Time Zone Name = BST
3805     UTC Time = 05:31:05
3806     DST Offset = 360
3807     TIMESTAMPCOL =
3808     AsString = 01/7/2020 07:00:00.0000 -04:00
3809     Formatted = 2020/07/01 07:00:00.0000 EST5EDT
3810     TimeZoneID = 65135
3811     Time Zone Name = EST5EDT
3812     UTC Time = 01/7/2020 11:00:00
3813     DST Offset = -240
3814     TZ_HOUR = 6
3815     TZ_MINUTE = 0
3816     ROWID = 8
3817     TIMECOL =
3818     AsString = 11:31:05.0001 +01:00
3819     Formatted = 11:31:05.0001 Europe/Paris
3820     TimeZoneID = 65061
3821     Time Zone Name = Europe/Paris
3822     UTC Time = 10:31:05
3823     DST Offset = 60
3824     TIMESTAMPCOL =
3825     AsString = 01/7/2020 06:00:00.0000 -05:00
3826     Formatted = 2020/07/01 06:00:00.0000 EST
3827     TimeZoneID = 65136
3828     Time Zone Name = EST
3829     UTC Time = 01/7/2020 11:00:00
3830     DST Offset = -300
3831     TZ_HOUR = 1
3832     TZ_MINUTE = 0
3833    
3834    
3835    
3836     ------------------------------------------------------
3837     Running Test 18: Firebird 4 Decfloat extensions
3838 tony 338 FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
3839 tony 333
3840     FB4 Testdata_DECFloat
3841    
3842     Metadata
3843     SQLType =SQL_LONG
3844     sub type = 0
3845     Table = FB4TESTDATA_DECFLOAT
3846     Owner = SYSDBA
3847     Column Name = ROWID
3848     Alias Name = ROWID
3849     Field Name = ROWID
3850     Scale = 0
3851     Charset id = 0
3852     Not Null
3853     Size = 4
3854    
3855     SQLType =SQL_DEC16
3856     sub type = 0
3857     Table = FB4TESTDATA_DECFLOAT
3858     Owner = SYSDBA
3859     Column Name = FLOAT16
3860     Alias Name = FLOAT16
3861     Field Name = FLOAT16
3862     Scale = 0
3863     Charset id = 0
3864     Nullable
3865     Size = 8
3866    
3867     SQLType =SQL_DEC34
3868     sub type = 0
3869     Table = FB4TESTDATA_DECFLOAT
3870     Owner = SYSDBA
3871     Column Name = FLOAT34
3872     Alias Name = FLOAT34
3873     Field Name = FLOAT34
3874     Scale = 0
3875     Charset id = 0
3876     Nullable
3877     Size = 16
3878    
3879     SQLType =SQL_INT128
3880     sub type = 0
3881     Table = FB4TESTDATA_DECFLOAT
3882     Owner = SYSDBA
3883     Column Name = BIGNUMBER
3884     Alias Name = BIGNUMBER
3885     Field Name = BIGNUMBER
3886     Scale = -6
3887     Charset id = 0
3888     Nullable
3889     Size = 16
3890    
3891     SQLType =SQL_INT128
3892     sub type = 0
3893     Table = FB4TESTDATA_DECFLOAT
3894     Owner = SYSDBA
3895     Column Name = BIGGERNUMBER
3896     Alias Name = BIGGERNUMBER
3897     Field Name = BIGGERNUMBER
3898     Scale = -4
3899     Charset id = 0
3900     Nullable
3901     Size = 16
3902    
3903     SQLType =SQL_INT128
3904     sub type = 0
3905     Table = FB4TESTDATA_DECFLOAT
3906     Owner = SYSDBA
3907     Column Name = BIGINTEGER
3908     Alias Name = BIGINTEGER
3909     Field Name = BIGINTEGER
3910     Scale = 0
3911     Charset id = 0
3912     Nullable
3913     Size = 16
3914    
3915     RowID = 1
3916     Float16 = 64000000000.01
3917     Precision = 13
3918     Sign = 0
3919     Special = 0
3920     Places = 2
3921     Digits = 64 00 00 00 00 00 10
3922     Float34 = 123456789123456789.12345678
3923     Precision = 26
3924     Sign = 0
3925     Special = 0
3926     Places = 8
3927     Digits = 12 34 56 78 91 23 45 67 89 12 34 56 78
3928     BigNumber = 123456123456.123456
3929     Precision = 18
3930     Sign = 0
3931     Special = 0
3932     Places = 6
3933     Digits = 12 34 56 12 34 56 12 34 56
3934     BigInteger = 123456789123456789
3935     Precision = 18
3936     Sign = 0
3937     Special = 0
3938     Places = 0
3939     Digits = 12 34 56 78 91 23 45 67 89
3940     RowID = 2
3941     Float16 = -64000000000.01
3942     Precision = 13
3943     Sign = 1
3944     Special = 0
3945     Places = 2
3946     Digits = 64 00 00 00 00 00 10
3947     Float34 = -123456789123456789.12345678
3948     Precision = 26
3949     Sign = 1
3950     Special = 0
3951     Places = 8
3952     Digits = 12 34 56 78 91 23 45 67 89 12 34 56 78
3953     BigNumber = -123456123456.123456
3954     Precision = 18
3955     Sign = 1
3956     Special = 0
3957     Places = 6
3958     Digits = 12 34 56 12 34 56 12 34 56
3959     BigInteger = Null
3960     RowID = 3
3961     Float16 = 64100000000.011
3962     Precision = 14
3963     Sign = 0
3964     Special = 0
3965     Places = 3
3966     Digits = 64 10 00 00 00 00 11
3967     Float34 = 12345678912.1200
3968     Precision = 15
3969     Sign = 0
3970     Special = 0
3971     Places = 4
3972     Digits = 12 34 56 78 91 21 20 00
3973     BigNumber = 1234561234567.123456
3974     Precision = 19
3975     Sign = 0
3976     Special = 0
3977     Places = 6
3978     Digits = 12 34 56 12 34 56 71 23 45 60
3979     BiggerNumber = 11123456123456123456123456123456.1235
3980     Precision = 36
3981     Sign = 0
3982     Special = 0
3983     Places = 4
3984     Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35
3985     BigInteger = Null
3986     RowID = 4
3987     Float16 = 0
3988     Precision = 0
3989     Sign = 0
3990     Special = 0
3991     Places = 0
3992     Digits =
3993     Float34 = -1
3994     Precision = 1
3995     Sign = 1
3996     Special = 0
3997     Places = 0
3998     Digits = 10
3999     BigNumber = 0.000000
4000     Precision = 0
4001     Sign = 0
4002     Special = 0
4003     Places = 0
4004     Digits =
4005     BiggerNumber = 0.0000
4006     Precision = 0
4007     Sign = 0
4008     Special = 0
4009     Places = 0
4010     Digits =
4011     BigInteger = Null
4012     Metadata
4013     SQLType =SQL_LONG
4014     sub type = 0
4015     Table = FB4TESTDATA_DECFLOAT_AR
4016     Owner = SYSDBA
4017     Column Name = ROWID
4018     Alias Name = ROWID
4019     Field Name = ROWID
4020     Scale = 0
4021     Charset id = 0
4022     Not Null
4023     Size = 4
4024    
4025     SQLType =SQL_ARRAY
4026     sub type = 0
4027     Table = FB4TESTDATA_DECFLOAT_AR
4028     Owner = SYSDBA
4029     Column Name = FLOAT16
4030     Alias Name = FLOAT16
4031     Field Name = FLOAT16
4032     Scale = 0
4033     Charset id = 0
4034     Nullable
4035     Size = 8
4036     Array Meta Data:
4037     SQLType =SQL_DEC16
4038     Scale = 0
4039     Charset id = 0
4040     Size = 8
4041     Table = FB4TESTDATA_DECFLOAT_AR
4042     Column = FLOAT16
4043     Dimensions = 1
4044     Bounds: (0:16)
4045    
4046     SQLType =SQL_ARRAY
4047     sub type = 0
4048     Table = FB4TESTDATA_DECFLOAT_AR
4049     Owner = SYSDBA
4050     Column Name = FLOAT34
4051     Alias Name = FLOAT34
4052     Field Name = FLOAT34
4053     Scale = 0
4054     Charset id = 0
4055     Nullable
4056     Size = 8
4057     Array Meta Data:
4058     SQLType =SQL_DEC34
4059     Scale = 0
4060     Charset id = 0
4061     Size = 16
4062     Table = FB4TESTDATA_DECFLOAT_AR
4063     Column = FLOAT34
4064     Dimensions = 1
4065     Bounds: (0:16)
4066    
4067     SQLType =SQL_ARRAY
4068     sub type = 0
4069     Table = FB4TESTDATA_DECFLOAT_AR
4070     Owner = SYSDBA
4071     Column Name = BIGNUMBER
4072     Alias Name = BIGNUMBER
4073     Field Name = BIGNUMBER
4074     Scale = 0
4075     Charset id = 0
4076     Nullable
4077     Size = 8
4078     Array Meta Data:
4079     SQLType =SQL_INT128
4080     Scale = -6
4081     Charset id = 0
4082     Size = 16
4083     Table = FB4TESTDATA_DECFLOAT_AR
4084     Column = BIGNUMBER
4085     Dimensions = 1
4086     Bounds: (0:16)
4087    
4088    
4089     Decfloat Arrays
4090     Row No 1
4091     Float16 Array: (0: 64100000000.011) (1: 64100000001.011) (2: 64100000002.011) (3: 64100000003.011) (4: 64100000004.011) (5: 64100000005.011) (6: 64100000006.011) (7: 64100000007.011) (8: 64100000008.011) (9: 64100000009.011) (10: 64100000010.011) (11: 64100000011.011) (12: 64100000012.011) (13: 64100000013.011) (14: 64100000014.011) (15: 64100000015.011) (16: 64100000016.011)
4092    
4093     Float34 Array: (0: 123456789123456789.12345678) (1: 123456789123456790.12345678) (2: 123456789123456791.12345678) (3: 123456789123456792.12345678) (4: 123456789123456793.12345678) (5: 123456789123456794.12345678) (6: 123456789123456795.12345678) (7: 123456789123456796.12345678) (8: 123456789123456797.12345678) (9: 123456789123456798.12345678) (10: 123456789123456799.12345678) (11: 123456789123456800.12345678) (12: 123456789123456801.12345678) (13: 123456789123456802.12345678) (14: 123456789123456803.12345678) (15: 123456789123456804.12345678) (16: 123456789123456805.12345678)
4094    
4095     BigNumber Array: (0: 123456123400.123456) (1: 123456123401.623456) (2: 123456123403.123456) (3: 123456123404.623456) (4: 123456123406.123456) (5: 123456123407.623456) (6: 123456123409.123456) (7: 123456123410.623456) (8: 123456123412.123456) (9: 123456123413.623456) (10: 123456123415.123456) (11: 123456123416.623456) (12: 123456123418.123456) (13: 123456123419.623456) (14: 123456123421.123456) (15: 123456123422.623456) (16: 123456123424.123456)
4096    
4097    
4098    
4099     ------------------------------------------------------
4100     Test Suite Ends