ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/testsuite/FB4reference.log
Revision: 333
Committed: Fri Feb 26 16:34:26 2021 UTC (16 months ago) by tony
File size: 101852 byte(s)
Log Message:
Add missing files
Line File contents
1 Firebird API Test Suite
2 Copyright MWA Software 2016-2021
3
4 Starting Tests
5 Client API Version = 4.0
6 Firebird Environment Variable = /opt/firebird4rc1
7 Firebird Bin Directory = /opt/firebird4rc1/bin
8 Firebird Conf Directory = /opt/firebird4rc1/
9 Firebird Client Library Path = /opt/firebird4rc1/lib/libfbclient.so
10 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 Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so
26 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 Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
34 Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:C"
35 Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:C"
36 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 Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so
48 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 Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so
68 DB Client Implementation Version = 4.0
69 RDB$DESCRIPTION =
70 RDB$RELATION_ID = 128
71 RDB$SECURITY_CLASS = SQL$384
72 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 Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
552 Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
553 Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
554 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 Current memory = 19,747,376
569 Delta memory = 4,464
570 Max memory = 19,793,248
571 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 Database ID = 4 FB = /opt/firebird4rc1/examples/empbuild/employee.fdb SN = zeus
2699 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 Version = 1: LI-V6.3.0.2353 Firebird 4.0 Release Candidate 1
2707 Database is Read/Write
2708 Database Created: 01/2/2021 14:57:08
2709 Pages Used = 310
2710 Pages Free = 36
2711 Server Memory = 19466032
2712 Forced Writes = 1
2713 Max Memory = 19612048
2714 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 Server Version = LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1
2800 Implementation = Firebird/Linux/AMD/Intel/x64
2801
2802 Lock Directory = /tmp/firebird/
2803 Message File = /opt/firebird4rc1/
2804 Security File = /opt/firebird4rc1/security4.fdb
2805
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 FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
3077 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 FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
3839
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