ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/journaling/fbintf/testsuite/FB4reference.log
Revision: 363
Committed: Tue Dec 7 13:30:05 2021 UTC (8 months ago) by tony
File size: 123325 byte(s)
Log Message:
add fbintf
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/firebird4.0.0
7 Firebird Bin Directory = /opt/firebird4.0.0/bin
8 Firebird Conf Directory = /opt/firebird4.0.0/
9 Firebird Client Library Path = /opt/firebird4.0.0/lib/libfbclient.so
10 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/firebird4.0.0/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.2496 Firebird 4.0"
34 Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C"
35 Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C"
36 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/firebird4.0.0/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 Attachment ID = 4
61 DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
62 DB Charset ID = 4
63 DB SQL Dialect = 3
64 DB Remote Protocol = TCPv4
65 DB ODS Major Version = 13
66 DB ODS Minor Version = 0
67 User Authentication Method = Srp256
68 Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
69 DB Client Implementation Version = 4.0
70 RDB$DESCRIPTION =
71 RDB$RELATION_ID = 128
72 RDB$SECURITY_CLASS = SQL$385
73 RDB$CHARACTER_SET_NAME = UTF8
74 RDB$LINGER =
75 RDB$SQL_SECURITY =
76 Dropping Database
77
78
79 ------------------------------------------------------
80 Running Test 2: Open the employee database and run a query
81 Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
82 Opening inet://localhost/employee
83 Database Open, SQL Dialect = 3
84 TPB: Item Count = 3
85 isc_tpb_read
86 isc_tpb_nowait
87 isc_tpb_concurrency
88
89 Metadata
90 SQLType =SQL_SHORT
91 sub type = 0
92 Table = EMPLOYEE
93 Owner = SYSDBA
94 Column Name = EMP_NO
95 Alias Name = EMP_NO
96 Field Name = EMP_NO
97 Scale = 0
98 Charset id = 0
99 Not Null
100 Size = 2
101
102 SQLType =SQL_VARYING
103 sub type = 0
104 Table = EMPLOYEE
105 Owner = SYSDBA
106 Column Name = FIRST_NAME
107 Alias Name = FIRST_NAME
108 Field Name = FIRST_NAME
109 Scale = 0
110 Charset id = 0
111 Not Null
112 Size = 15
113
114 SQLType =SQL_VARYING
115 sub type = 0
116 Table = EMPLOYEE
117 Owner = SYSDBA
118 Column Name = LAST_NAME
119 Alias Name = LAST_NAME
120 Field Name = LAST_NAME
121 Scale = 0
122 Charset id = 0
123 Not Null
124 Size = 20
125
126 SQLType =SQL_VARYING
127 sub type = 0
128 Table = EMPLOYEE
129 Owner = SYSDBA
130 Column Name = PHONE_EXT
131 Alias Name = PHONE_EXT
132 Field Name = PHONE_EXT
133 Scale = 0
134 Charset id = 0
135 Nullable
136 Size = 4
137
138 SQLType =SQL_TIMESTAMP
139 sub type = 0
140 Table = EMPLOYEE
141 Owner = SYSDBA
142 Column Name = HIRE_DATE
143 Alias Name = HIRE_DATE
144 Field Name = HIRE_DATE
145 Scale = 0
146 Charset id = 0
147 Not Null
148 Size = 8
149
150 SQLType =SQL_TEXT
151 sub type = 0
152 Table = EMPLOYEE
153 Owner = SYSDBA
154 Column Name = DEPT_NO
155 Alias Name = DEPT_NO
156 Field Name = DEPT_NO
157 Scale = 0
158 Charset id = 0
159 Not Null
160 Size = 3
161
162 SQLType =SQL_VARYING
163 sub type = 0
164 Table = EMPLOYEE
165 Owner = SYSDBA
166 Column Name = JOB_CODE
167 Alias Name = JOB_CODE
168 Field Name = JOB_CODE
169 Scale = 0
170 Charset id = 0
171 Not Null
172 Size = 5
173
174 SQLType =SQL_SHORT
175 sub type = 0
176 Table = EMPLOYEE
177 Owner = SYSDBA
178 Column Name = JOB_GRADE
179 Alias Name = JOB_GRADE
180 Field Name = JOB_GRADE
181 Scale = 0
182 Charset id = 0
183 Not Null
184 Size = 2
185
186 SQLType =SQL_VARYING
187 sub type = 0
188 Table = EMPLOYEE
189 Owner = SYSDBA
190 Column Name = JOB_COUNTRY
191 Alias Name = JOB_COUNTRY
192 Field Name = JOB_COUNTRY
193 Scale = 0
194 Charset id = 0
195 Not Null
196 Size = 15
197
198 SQLType =SQL_INT64
199 sub type = 0
200 Table = EMPLOYEE
201 Owner = SYSDBA
202 Column Name = SALARY
203 Alias Name = SALARY
204 Field Name = SALARY
205 Scale = -2
206 Charset id = 0
207 Not Null
208 Size = 8
209
210 SQLType =SQL_VARYING
211 sub type = 0
212 Table = EMPLOYEE
213 Owner = SYSDBA
214 Column Name = FULL_NAME
215 Alias Name = FULL_NAME
216 Field Name = FULL_NAME
217 Scale = 0
218 Charset id = 0
219 Nullable
220 Size = 37
221
222 Plan =
223 Select Expression
224 -> First N Records
225 -> Table "EMPLOYEE" Full Scan
226 -- SQL style inline comment
227 /* this is a comment */ Select First 3 * from EMPLOYEE
228
229 EMP_NO = 2
230 FIRST_NAME = Robert
231 LAST_NAME = Nelson
232 PHONE_EXT = 250
233 HIRE_DATE = 1988/12/28 00:00:00.0000
234 DEPT_NO = 600
235 JOB_CODE = VP
236 JOB_GRADE = 2
237 JOB_COUNTRY = USA
238 SALARY = 105,900.00
239 FULL_NAME = Nelson, Robert
240 EMP_NO = 4
241 FIRST_NAME = Bruce
242 LAST_NAME = Young
243 PHONE_EXT = 233
244 HIRE_DATE = 1988/12/28 00:00:00.0000
245 DEPT_NO = 621
246 JOB_CODE = Eng
247 JOB_GRADE = 2
248 JOB_COUNTRY = USA
249 SALARY = 97,500.00
250 FULL_NAME = Young, Bruce
251 EMP_NO = 5
252 FIRST_NAME = Kim
253 LAST_NAME = Lambert
254 PHONE_EXT = 22
255 HIRE_DATE = 1989/02/06 00:00:00.0000
256 DEPT_NO = 130
257 JOB_CODE = Eng
258 JOB_GRADE = 2
259 JOB_COUNTRY = USA
260 SALARY = 102,750.00
261 FULL_NAME = Lambert, Kim
262
263 Select * from EMPLOYEE Where EMP_NO = ?
264 SQL Params
265 SQLType =SQL_SHORT
266 sub type = 0
267 Field Name =
268 Scale = 0
269 Charset id = 0
270 Not Null
271 Size = 2
272 Value = 0
273
274 EMP_NO = 8
275 FIRST_NAME = Leslie
276 LAST_NAME = Johnson
277 PHONE_EXT = 410
278 HIRE_DATE = 1989/04/05 00:00:00.0000
279 DEPT_NO = 180
280 JOB_CODE = Mktg
281 JOB_GRADE = 3
282 JOB_COUNTRY = USA
283 SALARY = 64,635.00
284 FULL_NAME = Johnson, Leslie
285
286 With param names
287 Select * from EMPLOYEE Where EMP_NO = :EMP_NO
288 SQL Params
289 SQLType =SQL_SHORT
290 sub type = 0
291 Field Name = EMP_NO
292 Scale = 0
293 Charset id = 0
294 Not Null
295 Size = 2
296 Value = 0
297
298 Results for Cursor: Test Cursor
299 EMP_NO = 8
300 FIRST_NAME = Leslie
301 LAST_NAME = Johnson
302 PHONE_EXT = 410
303 HIRE_DATE = 1989/04/05 00:00:00.0000
304 DEPT_NO = 180
305 JOB_CODE = Mktg
306 JOB_GRADE = 3
307 JOB_COUNTRY = USA
308 SALARY = 64,635.00
309 FULL_NAME = Johnson, Leslie
310
311 Scollable Cursors
312 DB Connect String = inet://localhost/employee
313 DB Charset ID = 4
314 DB SQL Dialect = 3
315 DB Remote Protocol = TCPv4
316 DB ODS Major Version = 13
317 DB ODS Minor Version = 0
318 User Authentication Method = Srp256
319 Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
320 DB Client Implementation Version = 4.0
321 Do Fetch Next:
322 EMP_NO = 2
323 FIRST_NAME = Robert
324 LAST_NAME = Nelson
325 PHONE_EXT = 250
326 HIRE_DATE = 1988/12/28 00:00:00.0000
327 DEPT_NO = 600
328 JOB_CODE = VP
329 JOB_GRADE = 2
330 JOB_COUNTRY = USA
331 SALARY = 105,900.00
332 FULL_NAME = Nelson, Robert
333 Do Fetch Last:
334 Remote Scrollable cursors test fails feature is not supported
335 Now open the employee database as a local database
336 TPB: Item Count = 3
337 isc_tpb_read
338 isc_tpb_nowait
339 isc_tpb_concurrency
340
341 Metadata
342 SQLType =SQL_SHORT
343 sub type = 0
344 Table = EMPLOYEE
345 Owner = SYSDBA
346 Column Name = EMP_NO
347 Alias Name = EMP_NO
348 Field Name = EMP_NO
349 Scale = 0
350 Charset id = 0
351 Not Null
352 Size = 2
353
354 SQLType =SQL_VARYING
355 sub type = 0
356 Table = EMPLOYEE
357 Owner = SYSDBA
358 Column Name = FIRST_NAME
359 Alias Name = FIRST_NAME
360 Field Name = FIRST_NAME
361 Scale = 0
362 Charset id = 0
363 Not Null
364 Size = 15
365
366 SQLType =SQL_VARYING
367 sub type = 0
368 Table = EMPLOYEE
369 Owner = SYSDBA
370 Column Name = LAST_NAME
371 Alias Name = LAST_NAME
372 Field Name = LAST_NAME
373 Scale = 0
374 Charset id = 0
375 Not Null
376 Size = 20
377
378 SQLType =SQL_VARYING
379 sub type = 0
380 Table = EMPLOYEE
381 Owner = SYSDBA
382 Column Name = PHONE_EXT
383 Alias Name = PHONE_EXT
384 Field Name = PHONE_EXT
385 Scale = 0
386 Charset id = 0
387 Nullable
388 Size = 4
389
390 SQLType =SQL_TIMESTAMP
391 sub type = 0
392 Table = EMPLOYEE
393 Owner = SYSDBA
394 Column Name = HIRE_DATE
395 Alias Name = HIRE_DATE
396 Field Name = HIRE_DATE
397 Scale = 0
398 Charset id = 0
399 Not Null
400 Size = 8
401
402 SQLType =SQL_TEXT
403 sub type = 0
404 Table = EMPLOYEE
405 Owner = SYSDBA
406 Column Name = DEPT_NO
407 Alias Name = DEPT_NO
408 Field Name = DEPT_NO
409 Scale = 0
410 Charset id = 0
411 Not Null
412 Size = 3
413
414 SQLType =SQL_VARYING
415 sub type = 0
416 Table = EMPLOYEE
417 Owner = SYSDBA
418 Column Name = JOB_CODE
419 Alias Name = JOB_CODE
420 Field Name = JOB_CODE
421 Scale = 0
422 Charset id = 0
423 Not Null
424 Size = 5
425
426 SQLType =SQL_SHORT
427 sub type = 0
428 Table = EMPLOYEE
429 Owner = SYSDBA
430 Column Name = JOB_GRADE
431 Alias Name = JOB_GRADE
432 Field Name = JOB_GRADE
433 Scale = 0
434 Charset id = 0
435 Not Null
436 Size = 2
437
438 SQLType =SQL_VARYING
439 sub type = 0
440 Table = EMPLOYEE
441 Owner = SYSDBA
442 Column Name = JOB_COUNTRY
443 Alias Name = JOB_COUNTRY
444 Field Name = JOB_COUNTRY
445 Scale = 0
446 Charset id = 0
447 Not Null
448 Size = 15
449
450 SQLType =SQL_INT64
451 sub type = 0
452 Table = EMPLOYEE
453 Owner = SYSDBA
454 Column Name = SALARY
455 Alias Name = SALARY
456 Field Name = SALARY
457 Scale = -2
458 Charset id = 0
459 Not Null
460 Size = 8
461
462 SQLType =SQL_VARYING
463 sub type = 0
464 Table = EMPLOYEE
465 Owner = SYSDBA
466 Column Name = FULL_NAME
467 Alias Name = FULL_NAME
468 Field Name = FULL_NAME
469 Scale = 0
470 Charset id = 0
471 Nullable
472 Size = 37
473
474 Plan =
475 Select Expression
476 -> First N Records
477 -> Table "EMPLOYEE" Full Scan
478 -- SQL style inline comment
479 /* this is a comment */ Select First 3 * from EMPLOYEE
480
481 EMP_NO = 2
482 FIRST_NAME = Robert
483 LAST_NAME = Nelson
484 PHONE_EXT = 250
485 HIRE_DATE = 1988/12/28 00:00:00.0000
486 DEPT_NO = 600
487 JOB_CODE = VP
488 JOB_GRADE = 2
489 JOB_COUNTRY = USA
490 SALARY = 105,900.00
491 FULL_NAME = Nelson, Robert
492 EMP_NO = 4
493 FIRST_NAME = Bruce
494 LAST_NAME = Young
495 PHONE_EXT = 233
496 HIRE_DATE = 1988/12/28 00:00:00.0000
497 DEPT_NO = 621
498 JOB_CODE = Eng
499 JOB_GRADE = 2
500 JOB_COUNTRY = USA
501 SALARY = 97,500.00
502 FULL_NAME = Young, Bruce
503 EMP_NO = 5
504 FIRST_NAME = Kim
505 LAST_NAME = Lambert
506 PHONE_EXT = 22
507 HIRE_DATE = 1989/02/06 00:00:00.0000
508 DEPT_NO = 130
509 JOB_CODE = Eng
510 JOB_GRADE = 2
511 JOB_COUNTRY = USA
512 SALARY = 102,750.00
513 FULL_NAME = Lambert, Kim
514
515 Select * from EMPLOYEE Where EMP_NO = ?
516 SQL Params
517 SQLType =SQL_SHORT
518 sub type = 0
519 Field Name =
520 Scale = 0
521 Charset id = 0
522 Not Null
523 Size = 2
524 Value = 0
525
526 EMP_NO = 8
527 FIRST_NAME = Leslie
528 LAST_NAME = Johnson
529 PHONE_EXT = 410
530 HIRE_DATE = 1989/04/05 00:00:00.0000
531 DEPT_NO = 180
532 JOB_CODE = Mktg
533 JOB_GRADE = 3
534 JOB_COUNTRY = USA
535 SALARY = 64,635.00
536 FULL_NAME = Johnson, Leslie
537
538 With param names
539 Select * from EMPLOYEE Where EMP_NO = :EMP_NO
540 SQL Params
541 SQLType =SQL_SHORT
542 sub type = 0
543 Field Name = EMP_NO
544 Scale = 0
545 Charset id = 0
546 Not Null
547 Size = 2
548 Value = 0
549
550 Results for Cursor: Test Cursor
551 EMP_NO = 8
552 FIRST_NAME = Leslie
553 LAST_NAME = Johnson
554 PHONE_EXT = 410
555 HIRE_DATE = 1989/04/05 00:00:00.0000
556 DEPT_NO = 180
557 JOB_CODE = Mktg
558 JOB_GRADE = 3
559 JOB_COUNTRY = USA
560 SALARY = 64,635.00
561 FULL_NAME = Johnson, Leslie
562
563 Scollable Cursors
564 DB Connect String = employee
565 DB Charset ID = 4
566 DB SQL Dialect = 3
567 DB Remote Protocol =
568 DB ODS Major Version = 13
569 DB ODS Minor Version = 0
570 User Authentication Method = User name in DPB
571 Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
572 DB Client Implementation Version = 4.0
573 Do Fetch Next:
574 EMP_NO = 2
575 FIRST_NAME = Robert
576 LAST_NAME = Nelson
577 PHONE_EXT = 250
578 HIRE_DATE = 1988/12/28 00:00:00.0000
579 DEPT_NO = 600
580 JOB_CODE = VP
581 JOB_GRADE = 2
582 JOB_COUNTRY = USA
583 SALARY = 105,900.00
584 FULL_NAME = Nelson, Robert
585 Do Fetch Last:
586 EMP_NO = 145
587 FIRST_NAME = Mark
588 LAST_NAME = Guckenheimer
589 PHONE_EXT = 221
590 HIRE_DATE = 1994/05/02 00:00:00.0000
591 DEPT_NO = 622
592 JOB_CODE = Eng
593 JOB_GRADE = 5
594 JOB_COUNTRY = USA
595 SALARY = 32,000.00
596 FULL_NAME = Guckenheimer, Mark
597 Do Fetch Prior:
598 EMP_NO = 144
599 FIRST_NAME = John
600 LAST_NAME = Montgomery
601 PHONE_EXT = 820
602 HIRE_DATE = 1994/03/30 00:00:00.0000
603 DEPT_NO = 672
604 JOB_CODE = Eng
605 JOB_GRADE = 5
606 JOB_COUNTRY = USA
607 SALARY = 35,000.00
608 FULL_NAME = Montgomery, John
609 Do Fetch First:
610 EMP_NO = 2
611 FIRST_NAME = Robert
612 LAST_NAME = Nelson
613 PHONE_EXT = 250
614 HIRE_DATE = 1988/12/28 00:00:00.0000
615 DEPT_NO = 600
616 JOB_CODE = VP
617 JOB_GRADE = 2
618 JOB_COUNTRY = USA
619 SALARY = 105,900.00
620 FULL_NAME = Nelson, Robert
621 Do Fetch Abs 8 :
622 EMP_NO = 14
623 FIRST_NAME = Stewart
624 LAST_NAME = Hall
625 PHONE_EXT = 227
626 HIRE_DATE = 1990/06/04 00:00:00.0000
627 DEPT_NO = 900
628 JOB_CODE = Finan
629 JOB_GRADE = 3
630 JOB_COUNTRY = USA
631 SALARY = 69,482.63
632 FULL_NAME = Hall, Stewart
633 Do Fetch Relative -2 :
634 EMP_NO = 11
635 FIRST_NAME = K. J.
636 LAST_NAME = Weston
637 PHONE_EXT = 34
638 HIRE_DATE = 1990/01/17 00:00:00.0000
639 DEPT_NO = 130
640 JOB_CODE = SRep
641 JOB_GRADE = 4
642 JOB_COUNTRY = USA
643 SALARY = 86,292.94
644 FULL_NAME = Weston, K. J.
645 Do Fetch beyond EOF :
646 Fetch returned false
647
648
649 ------------------------------------------------------
650 Running Test 3: ad hoc queries
651 Opening inet://localhost/employee
652 Database Open
653 Employee Count = 42
654 Transaction ID = 6547
655 Transaction is Read/Write
656 Transaction Database Path = inet://localhost/employee
657 Transaction ID = 6547
658 Oldest Interesting = 6545
659 Oldest Action = 6546
660 Oldest Snapshot = 6546
661 Oldest Snapshot Number = 2
662 Lock Timeout = 0
663 Transaction Access = isc_info_tra_readwrite
664 Isolation Type = isc_info_tra_concurrency
665 Employee Count = 41
666 Employee Count = 42
667 Employee Count = 41
668 Employee Count = 42
669 Constrained Employee Count = 3
670 "Johnson" Employee Count = 2
671 "Yanowski" Employee Count = 1
672
673
674 ------------------------------------------------------
675 Running Test 4: Update, Insert and Delete Queries
676 Opening inet://localhost/employee
677 Database Open
678 Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
679 Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
680 Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
681 on disk structure version 13.0
682 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
683 EMP_NO = 8
684 FIRST_NAME = Leslie
685 LAST_NAME = Johnson
686 PHONE_EXT = 410
687 HIRE_DATE = 1989/04/05 00:00:00.0000
688 DEPT_NO = 180
689 JOB_CODE = Mktg
690 JOB_GRADE = 3
691 JOB_COUNTRY = USA
692 SALARY = 64,635.00
693 FULL_NAME = Johnson, Leslie
694
695 Current memory = 19,767,952
696 Delta memory = 4,464
697 Max memory = 19,813,568
698 Elapsed time= 0.001 sec
699 Cpu = 0.000 sec
700 Buffers = 2048
701 Reads = 0
702 Writes = 0
703 Fetches = 3
704 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
705 Relation Name = EMPLOYEE
706 Metadata
707 SQLType =SQL_SHORT
708 sub type = 0
709 Table = EMPLOYEE
710 Owner = SYSDBA
711 Column Name = EMP_NO
712 Alias Name = EMP_NO
713 Field Name = EMP_NO
714 Scale = 0
715 Charset id = 0
716 Not Null
717 Size = 2
718
719 SQLType =SQL_VARYING
720 sub type = 0
721 Table = EMPLOYEE
722 Owner = SYSDBA
723 Column Name = FIRST_NAME
724 Alias Name = FIRST_NAME
725 Field Name = FIRST_NAME
726 Scale = 0
727 Charset id = 0
728 Not Null
729 Size = 15
730
731 SQLType =SQL_VARYING
732 sub type = 0
733 Table = EMPLOYEE
734 Owner = SYSDBA
735 Column Name = LAST_NAME
736 Alias Name = LAST_NAME
737 Field Name = LAST_NAME
738 Scale = 0
739 Charset id = 0
740 Not Null
741 Size = 20
742
743 SQLType =SQL_VARYING
744 sub type = 0
745 Table = EMPLOYEE
746 Owner = SYSDBA
747 Column Name = PHONE_EXT
748 Alias Name = PHONE_EXT
749 Field Name = PHONE_EXT
750 Scale = 0
751 Charset id = 0
752 Nullable
753 Size = 4
754
755 SQLType =SQL_TIMESTAMP
756 sub type = 0
757 Table = EMPLOYEE
758 Owner = SYSDBA
759 Column Name = HIRE_DATE
760 Alias Name = HIRE_DATE
761 Field Name = HIRE_DATE
762 Scale = 0
763 Charset id = 0
764 Not Null
765 Size = 8
766
767 SQLType =SQL_TEXT
768 sub type = 0
769 Table = EMPLOYEE
770 Owner = SYSDBA
771 Column Name = DEPT_NO
772 Alias Name = DEPT_NO
773 Field Name = DEPT_NO
774 Scale = 0
775 Charset id = 0
776 Not Null
777 Size = 3
778
779 SQLType =SQL_VARYING
780 sub type = 0
781 Table = EMPLOYEE
782 Owner = SYSDBA
783 Column Name = JOB_CODE
784 Alias Name = JOB_CODE
785 Field Name = JOB_CODE
786 Scale = 0
787 Charset id = 0
788 Not Null
789 Size = 5
790
791 SQLType =SQL_SHORT
792 sub type = 0
793 Table = EMPLOYEE
794 Owner = SYSDBA
795 Column Name = JOB_GRADE
796 Alias Name = JOB_GRADE
797 Field Name = JOB_GRADE
798 Scale = 0
799 Charset id = 0
800 Not Null
801 Size = 2
802
803 SQLType =SQL_VARYING
804 sub type = 0
805 Table = EMPLOYEE
806 Owner = SYSDBA
807 Column Name = JOB_COUNTRY
808 Alias Name = JOB_COUNTRY
809 Field Name = JOB_COUNTRY
810 Scale = 0
811 Charset id = 0
812 Not Null
813 Size = 15
814
815 SQLType =SQL_INT64
816 sub type = 0
817 Table = EMPLOYEE
818 Owner = SYSDBA
819 Column Name = SALARY
820 Alias Name = SALARY
821 Field Name = SALARY
822 Scale = -2
823 Charset id = 0
824 Not Null
825 Size = 8
826
827 SQLType =SQL_VARYING
828 sub type = 0
829 Table = EMPLOYEE
830 Owner = SYSDBA
831 Column Name = FULL_NAME
832 Alias Name = FULL_NAME
833 Field Name = FULL_NAME
834 Scale = 0
835 Charset id = 0
836 Nullable
837 Size = 37
838
839 EMP_NO = 150
840 FIRST_NAME = John
841 LAST_NAME = Doe
842 PHONE_EXT =
843 HIRE_DATE = 2015/04/01 00:00:00.0000
844 DEPT_NO = 600
845 JOB_CODE = Eng
846 JOB_GRADE = 4
847 JOB_COUNTRY = England
848 SALARY = 41,000.89
849 FULL_NAME = Doe, John
850
851 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
852 EMP_NO = 151
853 FIRST_NAME = Major
854 LAST_NAME = Major
855 PHONE_EXT =
856 HIRE_DATE = 2015/04/01 00:00:00.0000
857 DEPT_NO = 600
858 JOB_CODE = Eng
859 JOB_GRADE = 4
860 JOB_COUNTRY = England
861 SALARY = 40,000.59
862 FULL_NAME = Major, Major
863
864 Now Delete the rows
865 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
866 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
867 Inserting
868 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
869 EMP_NO = 150
870 FIRST_NAME = Jane
871 LAST_NAME = Doe
872 PHONE_EXT = NULL
873 HIRE_DATE = 2015/04/01 00:00:00.0000
874 DEPT_NO = 600
875 JOB_CODE = Eng
876 JOB_GRADE = 4
877 JOB_COUNTRY = England
878 SALARY = 41,000.89
879 FULL_NAME = Doe, Jane
880
881 Employee Count = 43
882 Updating
883 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 0
884 Prepare Query again
885
886 EMP_NO = 150
887 FIRST_NAME = Jayne's
888 LAST_NAME = Doe
889 PHONE_EXT = NULL
890 HIRE_DATE = 2015/04/01 00:00:00.0000
891 DEPT_NO = 600
892 JOB_CODE = Eng
893 JOB_GRADE = 4
894 JOB_COUNTRY = England
895 SALARY = 41,000.89
896 FULL_NAME = Doe, Jayne's
897
898 Prepare Query again with a different transaction
899
900 EMP_NO = 8
901 FIRST_NAME = Leslie
902 LAST_NAME = Johnson
903 PHONE_EXT = 410
904 HIRE_DATE = 1989/04/05 00:00:00.0000
905 DEPT_NO = 180
906 JOB_CODE = Mktg
907 JOB_GRADE = 3
908 JOB_COUNTRY = USA
909 SALARY = 64,635.00
910 FULL_NAME = Johnson, Leslie
911
912 Open Cursor with a different transaction
913
914 EMP_NO = 8
915 FIRST_NAME = Leslie
916 LAST_NAME = Johnson
917 PHONE_EXT = 410
918 HIRE_DATE = 1989/04/05 00:00:00.0000
919 DEPT_NO = 180
920 JOB_CODE = Mktg
921 JOB_GRADE = 3
922 JOB_COUNTRY = USA
923 SALARY = 64,635.00
924 FULL_NAME = Johnson, Leslie
925 Same Statement - updated params
926 EMP_NO = 9
927 FIRST_NAME = Phil
928 LAST_NAME = Forest
929 PHONE_EXT = 229
930 HIRE_DATE = 1989/04/17 00:00:00.0000
931 DEPT_NO = 622
932 JOB_CODE = Mngr
933 JOB_GRADE = 3
934 JOB_COUNTRY = USA
935 SALARY = 75,060.00
936 FULL_NAME = Forest, Phil
937
938 Test using Execute Block
939 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
940 EMP_NO = 8
941 FIRST_NAME = Leslie
942 LAST_NAME = Johnson
943 PHONE_EXT = 410
944 HIRE_DATE = 2015/01/31 00:00:00.0000
945 DEPT_NO = 180
946 JOB_CODE = Mktg
947 JOB_GRADE = 3
948 JOB_COUNTRY = USA
949 SALARY = 64,635.00
950 FULL_NAME = Johnson, Leslie
951
952
953
954 ------------------------------------------------------
955 Running Test 5: Update Returning and Activity Check
956 Opening inet://localhost/employee
957 Database Open
958 Database Closed
959 Database Open
960 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
961 Last Name = Johnson
962 EMP_NO = 8
963 FIRST_NAME = Leslie
964 LAST_NAME = Johnson
965 PHONE_EXT = 410
966 HIRE_DATE = 2016/01/31 00:00:00.0000
967 DEPT_NO = 180
968 JOB_CODE = Mktg
969 JOB_GRADE = 3
970 JOB_COUNTRY = USA
971 SALARY = 64,635.00
972 FULL_NAME = Johnson, Leslie
973
974 Inserting
975 Full Name = Doe, John
976 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
977 Database Activity = TRUE
978 Transaction Activity = TRUE
979 Database Activity = FALSE
980 Transaction Activity = FALSE
981 Employee Count = 43
982 Database Activity = TRUE
983 Transaction Activity = TRUE
984 Transaction Active
985 Transaction inactive
986
987
988 ------------------------------------------------------
989 Running Test 6: Blob Handling
990 Metadata
991 SQLType =SQL_TEXT
992 sub type = 0
993 Table = RDB$CHARACTER_SETS
994 Owner = SYSDBA
995 Column Name = RDB$CHARACTER_SET_NAME
996 Alias Name = RDB$CHARACTER_SET_NAME
997 Field Name = RDB$CHARACTER_SET_NAME
998 Scale = 0
999 Charset id = 4
1000 Nullable
1001 Size = 252
1002
1003 SQLType =SQL_SHORT
1004 sub type = 0
1005 Table = RDB$CHARACTER_SETS
1006 Owner = SYSDBA
1007 Column Name = RDB$CHARACTER_SET_ID
1008 Alias Name = RDB$CHARACTER_SET_ID
1009 Field Name = RDB$CHARACTER_SET_ID
1010 Scale = 0
1011 Charset id = 0
1012 Nullable
1013 Size = 2
1014
1015 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
1016 RDB$CHARACTER_SET_ID = 0
1017 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
1018 RDB$CHARACTER_SET_ID = 1
1019 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
1020 RDB$CHARACTER_SET_ID = 2
1021 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
1022 RDB$CHARACTER_SET_ID = 3
1023 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
1024 RDB$CHARACTER_SET_ID = 4
1025 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
1026 RDB$CHARACTER_SET_ID = 5
1027 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
1028 RDB$CHARACTER_SET_ID = 6
1029 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
1030 RDB$CHARACTER_SET_ID = 9
1031 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
1032 RDB$CHARACTER_SET_ID = 10
1033 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
1034 RDB$CHARACTER_SET_ID = 11
1035 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
1036 RDB$CHARACTER_SET_ID = 12
1037 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
1038 RDB$CHARACTER_SET_ID = 13
1039 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
1040 RDB$CHARACTER_SET_ID = 14
1041 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
1042 RDB$CHARACTER_SET_ID = 15
1043 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
1044 RDB$CHARACTER_SET_ID = 16
1045 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
1046 RDB$CHARACTER_SET_ID = 17
1047 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
1048 RDB$CHARACTER_SET_ID = 18
1049 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
1050 RDB$CHARACTER_SET_ID = 19
1051 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
1052 RDB$CHARACTER_SET_ID = 21
1053 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
1054 RDB$CHARACTER_SET_ID = 22
1055 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
1056 RDB$CHARACTER_SET_ID = 23
1057 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
1058 RDB$CHARACTER_SET_ID = 34
1059 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
1060 RDB$CHARACTER_SET_ID = 35
1061 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
1062 RDB$CHARACTER_SET_ID = 36
1063 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
1064 RDB$CHARACTER_SET_ID = 37
1065 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
1066 RDB$CHARACTER_SET_ID = 38
1067 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
1068 RDB$CHARACTER_SET_ID = 39
1069 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
1070 RDB$CHARACTER_SET_ID = 40
1071 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
1072 RDB$CHARACTER_SET_ID = 44
1073 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
1074 RDB$CHARACTER_SET_ID = 45
1075 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
1076 RDB$CHARACTER_SET_ID = 46
1077 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
1078 RDB$CHARACTER_SET_ID = 47
1079 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
1080 RDB$CHARACTER_SET_ID = 48
1081 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
1082 RDB$CHARACTER_SET_ID = 49
1083 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
1084 RDB$CHARACTER_SET_ID = 50
1085 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
1086 RDB$CHARACTER_SET_ID = 51
1087 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
1088 RDB$CHARACTER_SET_ID = 52
1089 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
1090 RDB$CHARACTER_SET_ID = 53
1091 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
1092 RDB$CHARACTER_SET_ID = 54
1093 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
1094 RDB$CHARACTER_SET_ID = 55
1095 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
1096 RDB$CHARACTER_SET_ID = 56
1097 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
1098 RDB$CHARACTER_SET_ID = 57
1099 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
1100 RDB$CHARACTER_SET_ID = 58
1101 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
1102 RDB$CHARACTER_SET_ID = 59
1103 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
1104 RDB$CHARACTER_SET_ID = 60
1105 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
1106 RDB$CHARACTER_SET_ID = 63
1107 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
1108 RDB$CHARACTER_SET_ID = 64
1109 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
1110 RDB$CHARACTER_SET_ID = 65
1111 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
1112 RDB$CHARACTER_SET_ID = 66
1113 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
1114 RDB$CHARACTER_SET_ID = 67
1115 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
1116 RDB$CHARACTER_SET_ID = 68
1117 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
1118 RDB$CHARACTER_SET_ID = 69
1119
1120 Metadata
1121 SQLType =SQL_LONG
1122 sub type = 0
1123 Table = TESTDATA
1124 Owner = SYSDBA
1125 Column Name = ROWID
1126 Alias Name = ROWID
1127 Field Name = ROWID
1128 Scale = 0
1129 Charset id = 0
1130 Not Null
1131 Size = 4
1132
1133 SQLType =SQL_LONG
1134 sub type = 0
1135 Table = TESTDATA
1136 Owner = SYSDBA
1137 Column Name = FIXEDPOINT
1138 Alias Name = FIXEDPOINT
1139 Field Name = FIXEDPOINT
1140 Scale = -2
1141 Charset id = 0
1142 Nullable
1143 Size = 4
1144
1145 SQLType =SQL_DOUBLE
1146 sub type = 0
1147 Table = TESTDATA
1148 Owner = SYSDBA
1149 Column Name = FLOATINGPOINT
1150 Alias Name = FLOATINGPOINT
1151 Field Name = FLOATINGPOINT
1152 Scale = 0
1153 Charset id = 0
1154 Nullable
1155 Size = 8
1156
1157 SQLType =SQL_VARYING
1158 sub type = 0
1159 Table = TESTDATA
1160 Owner = SYSDBA
1161 Column Name = TITLE
1162 Alias Name = TITLE
1163 Field Name = TITLE
1164 Scale = 0
1165 Charset id = 4
1166 Nullable
1167 Size = 128
1168
1169 SQLType =SQL_BLOB
1170 sub type = 1
1171 Table = TESTDATA
1172 Owner = SYSDBA
1173 Column Name = BLOBDATA
1174 Alias Name = BLOBDATA
1175 Field Name = BLOBDATA
1176 Scale = 0
1177 Charset id = 4
1178 Nullable
1179 Size = 8
1180
1181 Blob Meta Data
1182 SQL SubType =1
1183 Table = TESTDATA
1184 Column = BLOBDATA
1185 CharSetID = 4
1186 Segment Size = 80
1187
1188
1189 SQL Params
1190 SQLType =SQL_LONG
1191 sub type = 0
1192 Field Name = ROWID
1193 Scale = 0
1194 Charset id = 0
1195 Not Null
1196 Size = 4
1197 Value = 0
1198
1199 SQLType =SQL_VARYING
1200 sub type = 0
1201 Field Name = TITLE
1202 Scale = 0
1203 Charset id = 4
1204 Nullable
1205 Size = 128
1206
1207 SQLType =SQL_LONG
1208 sub type = 0
1209 Field Name = FP
1210 Scale = -2
1211 Charset id = 0
1212 Nullable
1213 Size = 4
1214
1215 SQLType =SQL_DOUBLE
1216 sub type = 0
1217 Field Name = DP
1218 Scale = 0
1219 Charset id = 0
1220 Nullable
1221 Size = 8
1222
1223 ROWID = 1
1224 FIXEDPOINT = 20.28
1225 FLOATINGPOINT = 3.14
1226 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1227 BLOBDATA = NULL
1228
1229 SQL Params
1230 SQLType =SQL_BLOB
1231 sub type = 1
1232 Field Name =
1233 Scale = 0
1234 Charset id = 4
1235 Nullable
1236 Size = 8
1237
1238 SQLType =SQL_LONG
1239 sub type = 0
1240 Field Name =
1241 Scale = 0
1242 Charset id = 0
1243 Not Null
1244 Size = 4
1245 Value = 0
1246
1247 ROWID = 1
1248 FIXEDPOINT = 20.28
1249 FLOATINGPOINT = 3.14
1250 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1251 BLOBDATA (Charset Id = 4 Codepage = 65001)
1252
1253 To be or not to be-that is the question:
1254 Whether 'tis nobler in the mind to suffer
1255 The slings and arrows of outrageous fortune,
1256 Or to take arms against a sea of troubles,
1257 And, by opposing, end them. To die, to sleep-
1258 No more-and by a sleep to say we end
1259 The heartache and the thousand natural shocks
1260 That flesh is heir to-'tis a consummation
1261 Devoutly to be wished. To die, to sleep-
1262 To sleep, perchance to dream. Aye, there's the rub,
1263 For in that sleep of death what dreams may come,
1264 When we have shuffled off this mortal coil,
1265 Must give us pause. There's the respect
1266 That makes calamity of so long life.
1267 For who would bear the whips and scorns of time,
1268 Th' oppressor's wrong, the proud man's contumely,
1269 The pangs of despised love, the law’s delay,
1270 The insolence of office, and the spurns
1271 That patient merit of the unworthy takes,
1272 When he himself might his quietus make
1273 With a bare bodkin? Who would fardels bear,
1274 To grunt and sweat under a weary life,
1275 But that the dread of something after death,
1276 The undiscovered country from whose bourn
1277 No traveler returns, puzzles the will
1278 And makes us rather bear those ills we have
1279 Than fly to others that we know not of?
1280 Thus conscience does make cowards of us all,
1281 And thus the native hue of resolution
1282 Is sicklied o'er with the pale cast of thought,
1283 And enterprises of great pitch and moment,
1284 With this regard their currents turn awry,
1285 And lose the name of action.-Soft you now,
1286 The fair Ophelia.-Nymph, in thy orisons
1287 Be all my sins remembered
1288
1289
1290 SQL Params
1291 SQLType =SQL_LONG
1292 sub type = 0
1293 Field Name = ROWID
1294 Scale = 0
1295 Charset id = 0
1296 Not Null
1297 Size = 4
1298 Value = 0
1299
1300 SQLType =SQL_VARYING
1301 sub type = 0
1302 Field Name = TITLE
1303 Scale = 0
1304 Charset id = 4
1305 Nullable
1306 Size = 128
1307
1308 SQLType =SQL_LONG
1309 sub type = 0
1310 Field Name = FP
1311 Scale = -2
1312 Charset id = 0
1313 Nullable
1314 Size = 4
1315
1316 SQLType =SQL_DOUBLE
1317 sub type = 0
1318 Field Name = DP
1319 Scale = 0
1320 Charset id = 0
1321 Nullable
1322 Size = 8
1323
1324 ROWID = 1
1325 FIXEDPOINT = 20.28
1326 FLOATINGPOINT = 3.14
1327 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1328 BLOBDATA (Charset Id = 4 Codepage = 65001)
1329
1330 To be or not to be-that is the question:
1331 Whether 'tis nobler in the mind to suffer
1332 The slings and arrows of outrageous fortune,
1333 Or to take arms against a sea of troubles,
1334 And, by opposing, end them. To die, to sleep-
1335 No more-and by a sleep to say we end
1336 The heartache and the thousand natural shocks
1337 That flesh is heir to-'tis a consummation
1338 Devoutly to be wished. To die, to sleep-
1339 To sleep, perchance to dream. Aye, there's the rub,
1340 For in that sleep of death what dreams may come,
1341 When we have shuffled off this mortal coil,
1342 Must give us pause. There's the respect
1343 That makes calamity of so long life.
1344 For who would bear the whips and scorns of time,
1345 Th' oppressor's wrong, the proud man's contumely,
1346 The pangs of despised love, the law’s delay,
1347 The insolence of office, and the spurns
1348 That patient merit of the unworthy takes,
1349 When he himself might his quietus make
1350 With a bare bodkin? Who would fardels bear,
1351 To grunt and sweat under a weary life,
1352 But that the dread of something after death,
1353 The undiscovered country from whose bourn
1354 No traveler returns, puzzles the will
1355 And makes us rather bear those ills we have
1356 Than fly to others that we know not of?
1357 Thus conscience does make cowards of us all,
1358 And thus the native hue of resolution
1359 Is sicklied o'er with the pale cast of thought,
1360 And enterprises of great pitch and moment,
1361 With this regard their currents turn awry,
1362 And lose the name of action.-Soft you now,
1363 The fair Ophelia.-Nymph, in thy orisons
1364 Be all my sins remembered
1365
1366 ROWID = 2
1367 FIXEDPOINT = NULL
1368 FLOATINGPOINT = NULL
1369 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1370 BLOBDATA (Charset Id = 4 Codepage = 65001)
1371
1372 To be or not to be-that is the question:
1373 Whether 'tis nobler in the mind to suffer
1374 The slings and arrows of outrageous fortune,
1375 Or to take arms against a sea of troubles,
1376 And, by opposing, end them. To die, to sleep-
1377 No more-and by a sleep to say we end
1378 The heartache and the thousand natural shocks
1379 That flesh is heir to-'tis a consummation
1380 Devoutly to be wished. To die, to sleep-
1381 To sleep, perchance to dream. Aye, there's the rub,
1382 For in that sleep of death what dreams may come,
1383 When we have shuffled off this mortal coil,
1384 Must give us pause. There's the respect
1385 That makes calamity of so long life.
1386 For who would bear the whips and scorns of time,
1387 Th' oppressor's wrong, the proud man's contumely,
1388 The pangs of despised love, the law’s delay,
1389 The insolence of office, and the spurns
1390 That patient merit of the unworthy takes,
1391 When he himself might his quietus make
1392 With a bare bodkin? Who would fardels bear,
1393 To grunt and sweat under a weary life,
1394 But that the dread of something after death,
1395 The undiscovered country from whose bourn
1396 No traveler returns, puzzles the will
1397 And makes us rather bear those ills we have
1398 Than fly to others that we know not of?
1399 Thus conscience does make cowards of us all,
1400 And thus the native hue of resolution
1401 Is sicklied o'er with the pale cast of thought,
1402 And enterprises of great pitch and moment,
1403 With this regard their currents turn awry,
1404 And lose the name of action.-Soft you now,
1405 The fair Ophelia.-Nymph, in thy orisons
1406 Be all my sins remembered
1407
1408
1409 Testing Blob as stored proc parameter
1410 Metadata
1411 SQLType =SQL_BLOB
1412 sub type = 1
1413 Table = TESTPROC
1414 Owner = SYSDBA
1415 Column Name = BLOBDATA
1416 Alias Name = BLOBDATA
1417 Field Name = BLOBDATA
1418 Scale = 0
1419 Charset id = 4
1420 Nullable
1421 Size = 8
1422
1423 Blob Meta Data
1424 SQL SubType =1
1425 Table = TESTPROC
1426 Column = BLOBDATA
1427 CharSetID = 4
1428 Segment Size = 80
1429
1430
1431 BLOBDATA (Charset Id = 4 Codepage = 65001)
1432
1433 To be or not to be-that is the question:
1434 Whether 'tis nobler in the mind to suffer
1435 The slings and arrows of outrageous fortune,
1436 Or to take arms against a sea of troubles,
1437 And, by opposing, end them. To die, to sleep-
1438 No more-and by a sleep to say we end
1439 The heartache and the thousand natural shocks
1440 That flesh is heir to-'tis a consummation
1441 Devoutly to be wished. To die, to sleep-
1442 To sleep, perchance to dream. Aye, there's the rub,
1443 For in that sleep of death what dreams may come,
1444 When we have shuffled off this mortal coil,
1445 Must give us pause. There's the respect
1446 That makes calamity of so long life.
1447 For who would bear the whips and scorns of time,
1448 Th' oppressor's wrong, the proud man's contumely,
1449 The pangs of despised love, the law’s delay,
1450 The insolence of office, and the spurns
1451 That patient merit of the unworthy takes,
1452 When he himself might his quietus make
1453 With a bare bodkin? Who would fardels bear,
1454 To grunt and sweat under a weary life,
1455 But that the dread of something after death,
1456 The undiscovered country from whose bourn
1457 No traveler returns, puzzles the will
1458 And makes us rather bear those ills we have
1459 Than fly to others that we know not of?
1460 Thus conscience does make cowards of us all,
1461 And thus the native hue of resolution
1462 Is sicklied o'er with the pale cast of thought,
1463 And enterprises of great pitch and moment,
1464 With this regard their currents turn awry,
1465 And lose the name of action.-Soft you now,
1466 The fair Ophelia.-Nymph, in thy orisons
1467 Be all my sins remembered
1468
1469 Metadata
1470 SQLType =SQL_TEXT
1471 sub type = 0
1472 Table = RDB$CHARACTER_SETS
1473 Owner = SYSDBA
1474 Column Name = RDB$CHARACTER_SET_NAME
1475 Alias Name = RDB$CHARACTER_SET_NAME
1476 Field Name = RDB$CHARACTER_SET_NAME
1477 Scale = 0
1478 Charset id = 53
1479 Nullable
1480 Size = 63
1481
1482 SQLType =SQL_SHORT
1483 sub type = 0
1484 Table = RDB$CHARACTER_SETS
1485 Owner = SYSDBA
1486 Column Name = RDB$CHARACTER_SET_ID
1487 Alias Name = RDB$CHARACTER_SET_ID
1488 Field Name = RDB$CHARACTER_SET_ID
1489 Scale = 0
1490 Charset id = 0
1491 Nullable
1492 Size = 2
1493
1494 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1495 RDB$CHARACTER_SET_ID = 0
1496 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1497 RDB$CHARACTER_SET_ID = 1
1498 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1499 RDB$CHARACTER_SET_ID = 2
1500 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1501 RDB$CHARACTER_SET_ID = 3
1502 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1503 RDB$CHARACTER_SET_ID = 4
1504 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1505 RDB$CHARACTER_SET_ID = 5
1506 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1507 RDB$CHARACTER_SET_ID = 6
1508 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1509 RDB$CHARACTER_SET_ID = 9
1510 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1511 RDB$CHARACTER_SET_ID = 10
1512 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1513 RDB$CHARACTER_SET_ID = 11
1514 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1515 RDB$CHARACTER_SET_ID = 12
1516 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1517 RDB$CHARACTER_SET_ID = 13
1518 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1519 RDB$CHARACTER_SET_ID = 14
1520 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1521 RDB$CHARACTER_SET_ID = 15
1522 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1523 RDB$CHARACTER_SET_ID = 16
1524 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1525 RDB$CHARACTER_SET_ID = 17
1526 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1527 RDB$CHARACTER_SET_ID = 18
1528 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1529 RDB$CHARACTER_SET_ID = 19
1530 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1531 RDB$CHARACTER_SET_ID = 21
1532 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1533 RDB$CHARACTER_SET_ID = 22
1534 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1535 RDB$CHARACTER_SET_ID = 23
1536 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1537 RDB$CHARACTER_SET_ID = 34
1538 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1539 RDB$CHARACTER_SET_ID = 35
1540 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1541 RDB$CHARACTER_SET_ID = 36
1542 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1543 RDB$CHARACTER_SET_ID = 37
1544 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1545 RDB$CHARACTER_SET_ID = 38
1546 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1547 RDB$CHARACTER_SET_ID = 39
1548 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1549 RDB$CHARACTER_SET_ID = 40
1550 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1551 RDB$CHARACTER_SET_ID = 44
1552 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1553 RDB$CHARACTER_SET_ID = 45
1554 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1555 RDB$CHARACTER_SET_ID = 46
1556 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1557 RDB$CHARACTER_SET_ID = 47
1558 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1559 RDB$CHARACTER_SET_ID = 48
1560 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1561 RDB$CHARACTER_SET_ID = 49
1562 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1563 RDB$CHARACTER_SET_ID = 50
1564 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1565 RDB$CHARACTER_SET_ID = 51
1566 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1567 RDB$CHARACTER_SET_ID = 52
1568 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1569 RDB$CHARACTER_SET_ID = 53
1570 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1571 RDB$CHARACTER_SET_ID = 54
1572 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1573 RDB$CHARACTER_SET_ID = 55
1574 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1575 RDB$CHARACTER_SET_ID = 56
1576 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1577 RDB$CHARACTER_SET_ID = 57
1578 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1579 RDB$CHARACTER_SET_ID = 58
1580 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1581 RDB$CHARACTER_SET_ID = 59
1582 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1583 RDB$CHARACTER_SET_ID = 60
1584 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1585 RDB$CHARACTER_SET_ID = 63
1586 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1587 RDB$CHARACTER_SET_ID = 64
1588 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1589 RDB$CHARACTER_SET_ID = 65
1590 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1591 RDB$CHARACTER_SET_ID = 66
1592 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1593 RDB$CHARACTER_SET_ID = 67
1594 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1595 RDB$CHARACTER_SET_ID = 68
1596 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1597 RDB$CHARACTER_SET_ID = 69
1598
1599 Metadata
1600 SQLType =SQL_LONG
1601 sub type = 0
1602 Table = TESTDATA
1603 Owner = SYSDBA
1604 Column Name = ROWID
1605 Alias Name = ROWID
1606 Field Name = ROWID
1607 Scale = 0
1608 Charset id = 0
1609 Not Null
1610 Size = 4
1611
1612 SQLType =SQL_LONG
1613 sub type = 0
1614 Table = TESTDATA
1615 Owner = SYSDBA
1616 Column Name = FIXEDPOINT
1617 Alias Name = FIXEDPOINT
1618 Field Name = FIXEDPOINT
1619 Scale = -2
1620 Charset id = 0
1621 Nullable
1622 Size = 4
1623
1624 SQLType =SQL_DOUBLE
1625 sub type = 0
1626 Table = TESTDATA
1627 Owner = SYSDBA
1628 Column Name = FLOATINGPOINT
1629 Alias Name = FLOATINGPOINT
1630 Field Name = FLOATINGPOINT
1631 Scale = 0
1632 Charset id = 0
1633 Nullable
1634 Size = 8
1635
1636 SQLType =SQL_VARYING
1637 sub type = 0
1638 Table = TESTDATA
1639 Owner = SYSDBA
1640 Column Name = TITLE
1641 Alias Name = TITLE
1642 Field Name = TITLE
1643 Scale = 0
1644 Charset id = 53
1645 Nullable
1646 Size = 32
1647
1648 SQLType =SQL_BLOB
1649 sub type = 1
1650 Table = TESTDATA
1651 Owner = SYSDBA
1652 Column Name = BLOBDATA
1653 Alias Name = BLOBDATA
1654 Field Name = BLOBDATA
1655 Scale = 0
1656 Charset id = 53
1657 Nullable
1658 Size = 8
1659
1660 Blob Meta Data
1661 SQL SubType =1
1662 Table = TESTDATA
1663 Column = BLOBDATA
1664 CharSetID = 53
1665 Segment Size = 80
1666
1667
1668 SQL Params
1669 SQLType =SQL_LONG
1670 sub type = 0
1671 Field Name = ROWID
1672 Scale = 0
1673 Charset id = 0
1674 Not Null
1675 Size = 4
1676 Value = 0
1677
1678 SQLType =SQL_VARYING
1679 sub type = 0
1680 Field Name = TITLE
1681 Scale = 0
1682 Charset id = 53
1683 Nullable
1684 Size = 32
1685
1686 SQLType =SQL_LONG
1687 sub type = 0
1688 Field Name = FP
1689 Scale = -2
1690 Charset id = 0
1691 Nullable
1692 Size = 4
1693
1694 SQLType =SQL_DOUBLE
1695 sub type = 0
1696 Field Name = DP
1697 Scale = 0
1698 Charset id = 0
1699 Nullable
1700 Size = 8
1701
1702 ROWID = 1
1703 FIXEDPOINT = 20.28
1704 FLOATINGPOINT = 3.14
1705 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1706 BLOBDATA = NULL
1707
1708 SQL Params
1709 SQLType =SQL_BLOB
1710 sub type = 1
1711 Field Name =
1712 Scale = 0
1713 Charset id = 53
1714 Nullable
1715 Size = 8
1716
1717 SQLType =SQL_LONG
1718 sub type = 0
1719 Field Name =
1720 Scale = 0
1721 Charset id = 0
1722 Not Null
1723 Size = 4
1724 Value = 0
1725
1726 ROWID = 1
1727 FIXEDPOINT = 20.28
1728 FLOATINGPOINT = 3.14
1729 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1730 BLOBDATA (Charset Id = 53 Codepage = 1252)
1731
1732 To be or not to be-that is the question:
1733 Whether 'tis nobler in the mind to suffer
1734 The slings and arrows of outrageous fortune,
1735 Or to take arms against a sea of troubles,
1736 And, by opposing, end them. To die, to sleep-
1737 No more-and by a sleep to say we end
1738 The heartache and the thousand natural shocks
1739 That flesh is heir to-'tis a consummation
1740 Devoutly to be wished. To die, to sleep-
1741 To sleep, perchance to dream. Aye, there's the rub,
1742 For in that sleep of death what dreams may come,
1743 When we have shuffled off this mortal coil,
1744 Must give us pause. There's the respect
1745 That makes calamity of so long life.
1746 For who would bear the whips and scorns of time,
1747 Th' oppressor's wrong, the proud man's contumely,
1748 The pangs of despised love, the law’s delay,
1749 The insolence of office, and the spurns
1750 That patient merit of the unworthy takes,
1751 When he himself might his quietus make
1752 With a bare bodkin? Who would fardels bear,
1753 To grunt and sweat under a weary life,
1754 But that the dread of something after death,
1755 The undiscovered country from whose bourn
1756 No traveler returns, puzzles the will
1757 And makes us rather bear those ills we have
1758 Than fly to others that we know not of?
1759 Thus conscience does make cowards of us all,
1760 And thus the native hue of resolution
1761 Is sicklied o'er with the pale cast of thought,
1762 And enterprises of great pitch and moment,
1763 With this regard their currents turn awry,
1764 And lose the name of action.-Soft you now,
1765 The fair Ophelia.-Nymph, in thy orisons
1766 Be all my sins remembered
1767
1768
1769 SQL Params
1770 SQLType =SQL_LONG
1771 sub type = 0
1772 Field Name = ROWID
1773 Scale = 0
1774 Charset id = 0
1775 Not Null
1776 Size = 4
1777 Value = 0
1778
1779 SQLType =SQL_VARYING
1780 sub type = 0
1781 Field Name = TITLE
1782 Scale = 0
1783 Charset id = 53
1784 Nullable
1785 Size = 32
1786
1787 SQLType =SQL_LONG
1788 sub type = 0
1789 Field Name = FP
1790 Scale = -2
1791 Charset id = 0
1792 Nullable
1793 Size = 4
1794
1795 SQLType =SQL_DOUBLE
1796 sub type = 0
1797 Field Name = DP
1798 Scale = 0
1799 Charset id = 0
1800 Nullable
1801 Size = 8
1802
1803 ROWID = 1
1804 FIXEDPOINT = 20.28
1805 FLOATINGPOINT = 3.14
1806 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1807 BLOBDATA (Charset Id = 53 Codepage = 1252)
1808
1809 To be or not to be-that is the question:
1810 Whether 'tis nobler in the mind to suffer
1811 The slings and arrows of outrageous fortune,
1812 Or to take arms against a sea of troubles,
1813 And, by opposing, end them. To die, to sleep-
1814 No more-and by a sleep to say we end
1815 The heartache and the thousand natural shocks
1816 That flesh is heir to-'tis a consummation
1817 Devoutly to be wished. To die, to sleep-
1818 To sleep, perchance to dream. Aye, there's the rub,
1819 For in that sleep of death what dreams may come,
1820 When we have shuffled off this mortal coil,
1821 Must give us pause. There's the respect
1822 That makes calamity of so long life.
1823 For who would bear the whips and scorns of time,
1824 Th' oppressor's wrong, the proud man's contumely,
1825 The pangs of despised love, the law’s delay,
1826 The insolence of office, and the spurns
1827 That patient merit of the unworthy takes,
1828 When he himself might his quietus make
1829 With a bare bodkin? Who would fardels bear,
1830 To grunt and sweat under a weary life,
1831 But that the dread of something after death,
1832 The undiscovered country from whose bourn
1833 No traveler returns, puzzles the will
1834 And makes us rather bear those ills we have
1835 Than fly to others that we know not of?
1836 Thus conscience does make cowards of us all,
1837 And thus the native hue of resolution
1838 Is sicklied o'er with the pale cast of thought,
1839 And enterprises of great pitch and moment,
1840 With this regard their currents turn awry,
1841 And lose the name of action.-Soft you now,
1842 The fair Ophelia.-Nymph, in thy orisons
1843 Be all my sins remembered
1844
1845 ROWID = 2
1846 FIXEDPOINT = NULL
1847 FLOATINGPOINT = NULL
1848 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1849 BLOBDATA (Charset Id = 53 Codepage = 1252)
1850
1851 To be or not to be-that is the question:
1852 Whether 'tis nobler in the mind to suffer
1853 The slings and arrows of outrageous fortune,
1854 Or to take arms against a sea of troubles,
1855 And, by opposing, end them. To die, to sleep-
1856 No more-and by a sleep to say we end
1857 The heartache and the thousand natural shocks
1858 That flesh is heir to-'tis a consummation
1859 Devoutly to be wished. To die, to sleep-
1860 To sleep, perchance to dream. Aye, there's the rub,
1861 For in that sleep of death what dreams may come,
1862 When we have shuffled off this mortal coil,
1863 Must give us pause. There's the respect
1864 That makes calamity of so long life.
1865 For who would bear the whips and scorns of time,
1866 Th' oppressor's wrong, the proud man's contumely,
1867 The pangs of despised love, the law’s delay,
1868 The insolence of office, and the spurns
1869 That patient merit of the unworthy takes,
1870 When he himself might his quietus make
1871 With a bare bodkin? Who would fardels bear,
1872 To grunt and sweat under a weary life,
1873 But that the dread of something after death,
1874 The undiscovered country from whose bourn
1875 No traveler returns, puzzles the will
1876 And makes us rather bear those ills we have
1877 Than fly to others that we know not of?
1878 Thus conscience does make cowards of us all,
1879 And thus the native hue of resolution
1880 Is sicklied o'er with the pale cast of thought,
1881 And enterprises of great pitch and moment,
1882 With this regard their currents turn awry,
1883 And lose the name of action.-Soft you now,
1884 The fair Ophelia.-Nymph, in thy orisons
1885 Be all my sins remembered
1886
1887
1888 Testing Blob as stored proc parameter
1889 Metadata
1890 SQLType =SQL_BLOB
1891 sub type = 1
1892 Table = TESTPROC
1893 Owner = SYSDBA
1894 Column Name = BLOBDATA
1895 Alias Name = BLOBDATA
1896 Field Name = BLOBDATA
1897 Scale = 0
1898 Charset id = 53
1899 Nullable
1900 Size = 8
1901
1902 Blob Meta Data
1903 SQL SubType =1
1904 Table = TESTPROC
1905 Column = BLOBDATA
1906 CharSetID = 53
1907 Segment Size = 80
1908
1909
1910 BLOBDATA (Charset Id = 53 Codepage = 1252)
1911
1912 To be or not to be-that is the question:
1913 Whether 'tis nobler in the mind to suffer
1914 The slings and arrows of outrageous fortune,
1915 Or to take arms against a sea of troubles,
1916 And, by opposing, end them. To die, to sleep-
1917 No more-and by a sleep to say we end
1918 The heartache and the thousand natural shocks
1919 That flesh is heir to-'tis a consummation
1920 Devoutly to be wished. To die, to sleep-
1921 To sleep, perchance to dream. Aye, there's the rub,
1922 For in that sleep of death what dreams may come,
1923 When we have shuffled off this mortal coil,
1924 Must give us pause. There's the respect
1925 That makes calamity of so long life.
1926 For who would bear the whips and scorns of time,
1927 Th' oppressor's wrong, the proud man's contumely,
1928 The pangs of despised love, the law’s delay,
1929 The insolence of office, and the spurns
1930 That patient merit of the unworthy takes,
1931 When he himself might his quietus make
1932 With a bare bodkin? Who would fardels bear,
1933 To grunt and sweat under a weary life,
1934 But that the dread of something after death,
1935 The undiscovered country from whose bourn
1936 No traveler returns, puzzles the will
1937 And makes us rather bear those ills we have
1938 Than fly to others that we know not of?
1939 Thus conscience does make cowards of us all,
1940 And thus the native hue of resolution
1941 Is sicklied o'er with the pale cast of thought,
1942 And enterprises of great pitch and moment,
1943 With this regard their currents turn awry,
1944 And lose the name of action.-Soft you now,
1945 The fair Ophelia.-Nymph, in thy orisons
1946 Be all my sins remembered
1947
1948 Metadata
1949 SQLType =SQL_TEXT
1950 sub type = 0
1951 Table = RDB$CHARACTER_SETS
1952 Owner = SYSDBA
1953 Column Name = RDB$CHARACTER_SET_NAME
1954 Alias Name = RDB$CHARACTER_SET_NAME
1955 Field Name = RDB$CHARACTER_SET_NAME
1956 Scale = 0
1957 Charset id = 4
1958 Nullable
1959 Size = 252
1960
1961 SQLType =SQL_SHORT
1962 sub type = 0
1963 Table = RDB$CHARACTER_SETS
1964 Owner = SYSDBA
1965 Column Name = RDB$CHARACTER_SET_ID
1966 Alias Name = RDB$CHARACTER_SET_ID
1967 Field Name = RDB$CHARACTER_SET_ID
1968 Scale = 0
1969 Charset id = 0
1970 Nullable
1971 Size = 2
1972
1973 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
1974 RDB$CHARACTER_SET_ID = 0
1975 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
1976 RDB$CHARACTER_SET_ID = 1
1977 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
1978 RDB$CHARACTER_SET_ID = 2
1979 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
1980 RDB$CHARACTER_SET_ID = 3
1981 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
1982 RDB$CHARACTER_SET_ID = 4
1983 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
1984 RDB$CHARACTER_SET_ID = 5
1985 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
1986 RDB$CHARACTER_SET_ID = 6
1987 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
1988 RDB$CHARACTER_SET_ID = 9
1989 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
1990 RDB$CHARACTER_SET_ID = 10
1991 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
1992 RDB$CHARACTER_SET_ID = 11
1993 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
1994 RDB$CHARACTER_SET_ID = 12
1995 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
1996 RDB$CHARACTER_SET_ID = 13
1997 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
1998 RDB$CHARACTER_SET_ID = 14
1999 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
2000 RDB$CHARACTER_SET_ID = 15
2001 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
2002 RDB$CHARACTER_SET_ID = 16
2003 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
2004 RDB$CHARACTER_SET_ID = 17
2005 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
2006 RDB$CHARACTER_SET_ID = 18
2007 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
2008 RDB$CHARACTER_SET_ID = 19
2009 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
2010 RDB$CHARACTER_SET_ID = 21
2011 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
2012 RDB$CHARACTER_SET_ID = 22
2013 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
2014 RDB$CHARACTER_SET_ID = 23
2015 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
2016 RDB$CHARACTER_SET_ID = 34
2017 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
2018 RDB$CHARACTER_SET_ID = 35
2019 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
2020 RDB$CHARACTER_SET_ID = 36
2021 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
2022 RDB$CHARACTER_SET_ID = 37
2023 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
2024 RDB$CHARACTER_SET_ID = 38
2025 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
2026 RDB$CHARACTER_SET_ID = 39
2027 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
2028 RDB$CHARACTER_SET_ID = 40
2029 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
2030 RDB$CHARACTER_SET_ID = 44
2031 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
2032 RDB$CHARACTER_SET_ID = 45
2033 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
2034 RDB$CHARACTER_SET_ID = 46
2035 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
2036 RDB$CHARACTER_SET_ID = 47
2037 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
2038 RDB$CHARACTER_SET_ID = 48
2039 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
2040 RDB$CHARACTER_SET_ID = 49
2041 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
2042 RDB$CHARACTER_SET_ID = 50
2043 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
2044 RDB$CHARACTER_SET_ID = 51
2045 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
2046 RDB$CHARACTER_SET_ID = 52
2047 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
2048 RDB$CHARACTER_SET_ID = 53
2049 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
2050 RDB$CHARACTER_SET_ID = 54
2051 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
2052 RDB$CHARACTER_SET_ID = 55
2053 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
2054 RDB$CHARACTER_SET_ID = 56
2055 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
2056 RDB$CHARACTER_SET_ID = 57
2057 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
2058 RDB$CHARACTER_SET_ID = 58
2059 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
2060 RDB$CHARACTER_SET_ID = 59
2061 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
2062 RDB$CHARACTER_SET_ID = 60
2063 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
2064 RDB$CHARACTER_SET_ID = 63
2065 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
2066 RDB$CHARACTER_SET_ID = 64
2067 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
2068 RDB$CHARACTER_SET_ID = 65
2069 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
2070 RDB$CHARACTER_SET_ID = 66
2071 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
2072 RDB$CHARACTER_SET_ID = 67
2073 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
2074 RDB$CHARACTER_SET_ID = 68
2075 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
2076 RDB$CHARACTER_SET_ID = 69
2077
2078 Metadata
2079 SQLType =SQL_LONG
2080 sub type = 0
2081 Table = TESTDATA
2082 Owner = SYSDBA
2083 Column Name = ROWID
2084 Alias Name = ROWID
2085 Field Name = ROWID
2086 Scale = 0
2087 Charset id = 0
2088 Not Null
2089 Size = 4
2090
2091 SQLType =SQL_LONG
2092 sub type = 0
2093 Table = TESTDATA
2094 Owner = SYSDBA
2095 Column Name = FIXEDPOINT
2096 Alias Name = FIXEDPOINT
2097 Field Name = FIXEDPOINT
2098 Scale = -2
2099 Charset id = 0
2100 Nullable
2101 Size = 4
2102
2103 SQLType =SQL_DOUBLE
2104 sub type = 0
2105 Table = TESTDATA
2106 Owner = SYSDBA
2107 Column Name = FLOATINGPOINT
2108 Alias Name = FLOATINGPOINT
2109 Field Name = FLOATINGPOINT
2110 Scale = 0
2111 Charset id = 0
2112 Nullable
2113 Size = 8
2114
2115 SQLType =SQL_VARYING
2116 sub type = 0
2117 Table = TESTDATA
2118 Owner = SYSDBA
2119 Column Name = TITLE
2120 Alias Name = TITLE
2121 Field Name = TITLE
2122 Scale = 0
2123 Charset id = 4
2124 Nullable
2125 Size = 128
2126
2127 SQLType =SQL_BLOB
2128 sub type = 1
2129 Table = TESTDATA
2130 Owner = SYSDBA
2131 Column Name = BLOBDATA
2132 Alias Name = BLOBDATA
2133 Field Name = BLOBDATA
2134 Scale = 0
2135 Charset id = 4
2136 Nullable
2137 Size = 8
2138
2139 Blob Meta Data
2140 SQL SubType =1
2141 Table = TESTDATA
2142 Column = BLOBDATA
2143 CharSetID = 4
2144 Segment Size = 80
2145
2146
2147 SQL Params
2148 SQLType =SQL_LONG
2149 sub type = 0
2150 Field Name = ROWID
2151 Scale = 0
2152 Charset id = 0
2153 Not Null
2154 Size = 4
2155 Value = 0
2156
2157 SQLType =SQL_VARYING
2158 sub type = 0
2159 Field Name = TITLE
2160 Scale = 0
2161 Charset id = 4
2162 Nullable
2163 Size = 128
2164
2165 SQLType =SQL_LONG
2166 sub type = 0
2167 Field Name = FP
2168 Scale = -2
2169 Charset id = 0
2170 Nullable
2171 Size = 4
2172
2173 SQLType =SQL_DOUBLE
2174 sub type = 0
2175 Field Name = DP
2176 Scale = 0
2177 Charset id = 0
2178 Nullable
2179 Size = 8
2180
2181 ROWID = 1
2182 FIXEDPOINT = 20.28
2183 FLOATINGPOINT = 3.14
2184 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2185 BLOBDATA = NULL
2186
2187 SQL Params
2188 SQLType =SQL_BLOB
2189 sub type = 1
2190 Field Name =
2191 Scale = 0
2192 Charset id = 4
2193 Nullable
2194 Size = 8
2195
2196 SQLType =SQL_LONG
2197 sub type = 0
2198 Field Name =
2199 Scale = 0
2200 Charset id = 0
2201 Not Null
2202 Size = 4
2203 Value = 0
2204
2205 ROWID = 1
2206 FIXEDPOINT = 20.28
2207 FLOATINGPOINT = 3.14
2208 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2209 BLOBDATA (Charset Id = 4 Codepage = 65001)
2210
2211 To be or not to be-that is the question:
2212 Whether 'tis nobler in the mind to suffer
2213 The slings and arrows of outrageous fortune,
2214 Or to take arms against a sea of troubles,
2215 And, by opposing, end them. To die, to sleep-
2216 No more-and by a sleep to say we end
2217 The heartache and the thousand natural shocks
2218 That flesh is heir to-'tis a consummation
2219 Devoutly to be wished. To die, to sleep-
2220 To sleep, perchance to dream. Aye, there's the rub,
2221 For in that sleep of death what dreams may come,
2222 When we have shuffled off this mortal coil,
2223 Must give us pause. There's the respect
2224 That makes calamity of so long life.
2225 For who would bear the whips and scorns of time,
2226 Th' oppressor's wrong, the proud man's contumely,
2227 The pangs of despised love, the law’s delay,
2228 The insolence of office, and the spurns
2229 That patient merit of the unworthy takes,
2230 When he himself might his quietus make
2231 With a bare bodkin? Who would fardels bear,
2232 To grunt and sweat under a weary life,
2233 But that the dread of something after death,
2234 The undiscovered country from whose bourn
2235 No traveler returns, puzzles the will
2236 And makes us rather bear those ills we have
2237 Than fly to others that we know not of?
2238 Thus conscience does make cowards of us all,
2239 And thus the native hue of resolution
2240 Is sicklied o'er with the pale cast of thought,
2241 And enterprises of great pitch and moment,
2242 With this regard their currents turn awry,
2243 And lose the name of action.-Soft you now,
2244 The fair Ophelia.-Nymph, in thy orisons
2245 Be all my sins remembered
2246
2247
2248 SQL Params
2249 SQLType =SQL_LONG
2250 sub type = 0
2251 Field Name = ROWID
2252 Scale = 0
2253 Charset id = 0
2254 Not Null
2255 Size = 4
2256 Value = 0
2257
2258 SQLType =SQL_VARYING
2259 sub type = 0
2260 Field Name = TITLE
2261 Scale = 0
2262 Charset id = 4
2263 Nullable
2264 Size = 128
2265
2266 SQLType =SQL_LONG
2267 sub type = 0
2268 Field Name = FP
2269 Scale = -2
2270 Charset id = 0
2271 Nullable
2272 Size = 4
2273
2274 SQLType =SQL_DOUBLE
2275 sub type = 0
2276 Field Name = DP
2277 Scale = 0
2278 Charset id = 0
2279 Nullable
2280 Size = 8
2281
2282 ROWID = 1
2283 FIXEDPOINT = 20.28
2284 FLOATINGPOINT = 3.14
2285 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2286 BLOBDATA (Charset Id = 4 Codepage = 65001)
2287
2288 To be or not to be-that is the question:
2289 Whether 'tis nobler in the mind to suffer
2290 The slings and arrows of outrageous fortune,
2291 Or to take arms against a sea of troubles,
2292 And, by opposing, end them. To die, to sleep-
2293 No more-and by a sleep to say we end
2294 The heartache and the thousand natural shocks
2295 That flesh is heir to-'tis a consummation
2296 Devoutly to be wished. To die, to sleep-
2297 To sleep, perchance to dream. Aye, there's the rub,
2298 For in that sleep of death what dreams may come,
2299 When we have shuffled off this mortal coil,
2300 Must give us pause. There's the respect
2301 That makes calamity of so long life.
2302 For who would bear the whips and scorns of time,
2303 Th' oppressor's wrong, the proud man's contumely,
2304 The pangs of despised love, the law’s delay,
2305 The insolence of office, and the spurns
2306 That patient merit of the unworthy takes,
2307 When he himself might his quietus make
2308 With a bare bodkin? Who would fardels bear,
2309 To grunt and sweat under a weary life,
2310 But that the dread of something after death,
2311 The undiscovered country from whose bourn
2312 No traveler returns, puzzles the will
2313 And makes us rather bear those ills we have
2314 Than fly to others that we know not of?
2315 Thus conscience does make cowards of us all,
2316 And thus the native hue of resolution
2317 Is sicklied o'er with the pale cast of thought,
2318 And enterprises of great pitch and moment,
2319 With this regard their currents turn awry,
2320 And lose the name of action.-Soft you now,
2321 The fair Ophelia.-Nymph, in thy orisons
2322 Be all my sins remembered
2323
2324 ROWID = 2
2325 FIXEDPOINT = NULL
2326 FLOATINGPOINT = NULL
2327 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2328 BLOBDATA (Charset Id = 4 Codepage = 65001)
2329
2330 To be or not to be-that is the question:
2331 Whether 'tis nobler in the mind to suffer
2332 The slings and arrows of outrageous fortune,
2333 Or to take arms against a sea of troubles,
2334 And, by opposing, end them. To die, to sleep-
2335 No more-and by a sleep to say we end
2336 The heartache and the thousand natural shocks
2337 That flesh is heir to-'tis a consummation
2338 Devoutly to be wished. To die, to sleep-
2339 To sleep, perchance to dream. Aye, there's the rub,
2340 For in that sleep of death what dreams may come,
2341 When we have shuffled off this mortal coil,
2342 Must give us pause. There's the respect
2343 That makes calamity of so long life.
2344 For who would bear the whips and scorns of time,
2345 Th' oppressor's wrong, the proud man's contumely,
2346 The pangs of despised love, the law’s delay,
2347 The insolence of office, and the spurns
2348 That patient merit of the unworthy takes,
2349 When he himself might his quietus make
2350 With a bare bodkin? Who would fardels bear,
2351 To grunt and sweat under a weary life,
2352 But that the dread of something after death,
2353 The undiscovered country from whose bourn
2354 No traveler returns, puzzles the will
2355 And makes us rather bear those ills we have
2356 Than fly to others that we know not of?
2357 Thus conscience does make cowards of us all,
2358 And thus the native hue of resolution
2359 Is sicklied o'er with the pale cast of thought,
2360 And enterprises of great pitch and moment,
2361 With this regard their currents turn awry,
2362 And lose the name of action.-Soft you now,
2363 The fair Ophelia.-Nymph, in thy orisons
2364 Be all my sins remembered
2365
2366
2367 Testing Blob as stored proc parameter
2368 Metadata
2369 SQLType =SQL_BLOB
2370 sub type = 1
2371 Table = TESTPROC
2372 Owner = SYSDBA
2373 Column Name = BLOBDATA
2374 Alias Name = BLOBDATA
2375 Field Name = BLOBDATA
2376 Scale = 0
2377 Charset id = 4
2378 Nullable
2379 Size = 8
2380
2381 Blob Meta Data
2382 SQL SubType =1
2383 Table = TESTPROC
2384 Column = BLOBDATA
2385 CharSetID = 4
2386 Segment Size = 80
2387
2388
2389 BLOBDATA (Charset Id = 4 Codepage = 65001)
2390
2391 To be or not to be-that is the question:
2392 Whether 'tis nobler in the mind to suffer
2393 The slings and arrows of outrageous fortune,
2394 Or to take arms against a sea of troubles,
2395 And, by opposing, end them. To die, to sleep-
2396 No more-and by a sleep to say we end
2397 The heartache and the thousand natural shocks
2398 That flesh is heir to-'tis a consummation
2399 Devoutly to be wished. To die, to sleep-
2400 To sleep, perchance to dream. Aye, there's the rub,
2401 For in that sleep of death what dreams may come,
2402 When we have shuffled off this mortal coil,
2403 Must give us pause. There's the respect
2404 That makes calamity of so long life.
2405 For who would bear the whips and scorns of time,
2406 Th' oppressor's wrong, the proud man's contumely,
2407 The pangs of despised love, the law’s delay,
2408 The insolence of office, and the spurns
2409 That patient merit of the unworthy takes,
2410 When he himself might his quietus make
2411 With a bare bodkin? Who would fardels bear,
2412 To grunt and sweat under a weary life,
2413 But that the dread of something after death,
2414 The undiscovered country from whose bourn
2415 No traveler returns, puzzles the will
2416 And makes us rather bear those ills we have
2417 Than fly to others that we know not of?
2418 Thus conscience does make cowards of us all,
2419 And thus the native hue of resolution
2420 Is sicklied o'er with the pale cast of thought,
2421 And enterprises of great pitch and moment,
2422 With this regard their currents turn awry,
2423 And lose the name of action.-Soft you now,
2424 The fair Ophelia.-Nymph, in thy orisons
2425 Be all my sins remembered
2426
2427
2428
2429 ------------------------------------------------------
2430 Running Test 7: Create and read back an Array
2431 Metadata
2432 SQLType =SQL_LONG
2433 sub type = 0
2434 Table = TESTDATA
2435 Owner = SYSDBA
2436 Column Name = ROWID
2437 Alias Name = ROWID
2438 Field Name = ROWID
2439 Scale = 0
2440 Charset id = 0
2441 Not Null
2442 Size = 4
2443
2444 SQLType =SQL_VARYING
2445 sub type = 0
2446 Table = TESTDATA
2447 Owner = SYSDBA
2448 Column Name = TITLE
2449 Alias Name = TITLE
2450 Field Name = TITLE
2451 Scale = 0
2452 Charset id = 4
2453 Nullable
2454 Size = 128
2455
2456 SQLType =SQL_TIMESTAMP
2457 sub type = 0
2458 Table = TESTDATA
2459 Owner = SYSDBA
2460 Column Name = DATED
2461 Alias Name = DATED
2462 Field Name = DATED
2463 Scale = 0
2464 Charset id = 0
2465 Nullable
2466 Size = 8
2467
2468 SQLType =SQL_VARYING
2469 sub type = 0
2470 Table = TESTDATA
2471 Owner = SYSDBA
2472 Column Name = NOTES
2473 Alias Name = NOTES
2474 Field Name = NOTES
2475 Scale = 0
2476 Charset id = 4
2477 Nullable
2478 Size = 256
2479
2480 SQLType =SQL_ARRAY
2481 sub type = 0
2482 Table = TESTDATA
2483 Owner = SYSDBA
2484 Column Name = MYARRAY
2485 Alias Name = MYARRAY
2486 Field Name = MYARRAY
2487 Scale = 0
2488 Charset id = 0
2489 Nullable
2490 Size = 8
2491 Array Meta Data:
2492 SQLType =SQL_LONG
2493 Scale = 0
2494 Charset id = 0
2495 Size = 4
2496 Table = TESTDATA
2497 Column = MYARRAY
2498 Dimensions = 1
2499 Bounds: (0:16)
2500
2501 SQLType =SQL_ARRAY
2502 sub type = 0
2503 Table = TESTDATA
2504 Owner = SYSDBA
2505 Column Name = MYARRAY2
2506 Alias Name = MYARRAY2
2507 Field Name = MYARRAY2
2508 Scale = 0
2509 Charset id = 0
2510 Nullable
2511 Size = 8
2512 Array Meta Data:
2513 SQLType =SQL_TIMESTAMP
2514 Scale = 0
2515 Charset id = 0
2516 Size = 8
2517 Table = TESTDATA
2518 Column = MYARRAY2
2519 Dimensions = 1
2520 Bounds: (0:16)
2521
2522 SQLType =SQL_ARRAY
2523 sub type = 0
2524 Table = TESTDATA
2525 Owner = SYSDBA
2526 Column Name = MYARRAY3
2527 Alias Name = MYARRAY3
2528 Field Name = MYARRAY3
2529 Scale = 0
2530 Charset id = 0
2531 Nullable
2532 Size = 8
2533 Array Meta Data:
2534 SQLType =SQL_INT64
2535 Scale = -2
2536 Charset id = 0
2537 Size = 8
2538 Table = TESTDATA
2539 Column = MYARRAY3
2540 Dimensions = 1
2541 Bounds: (0:16)
2542
2543 SQL Params
2544 SQLType =SQL_LONG
2545 sub type = 0
2546 Field Name = ROWID
2547 Scale = 0
2548 Charset id = 0
2549 Not Null
2550 Size = 4
2551 Value = 0
2552
2553 SQLType =SQL_VARYING
2554 sub type = 0
2555 Field Name = TITLE
2556 Scale = 0
2557 Charset id = 4
2558 Nullable
2559 Size = 128
2560
2561 SQLType =SQL_TIMESTAMP
2562 sub type = 0
2563 Field Name = DATED
2564 Scale = 0
2565 Charset id = 0
2566 Nullable
2567 Size = 8
2568
2569 SQLType =SQL_VARYING
2570 sub type = 0
2571 Field Name = NOTES
2572 Scale = 0
2573 Charset id = 4
2574 Nullable
2575 Size = 256
2576
2577 Param Name = ROWID
2578 Param Name = TITLE
2579 Param Name = DATED
2580 Param Name = NOTES
2581 ROWID = 1
2582 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2583 DATED = 2016/04/01 09:30:00.1000
2584 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2585 MYARRAY = NULL
2586 MYARRAY2 = NULL
2587 MYARRAY3 = NULL
2588
2589 SQL Params
2590 SQLType =SQL_ARRAY
2591 sub type = 0
2592 Field Name = MYARRAY
2593 Scale = 0
2594 Charset id = 0
2595 Nullable
2596 Size = 8
2597
2598 SQL Params
2599 SQLType =SQL_ARRAY
2600 sub type = 0
2601 Field Name = MYARRAY2
2602 Scale = 0
2603 Charset id = 0
2604 Nullable
2605 Size = 8
2606
2607 SQL Params
2608 SQLType =SQL_ARRAY
2609 sub type = 0
2610 Field Name = MYARRAY3
2611 Scale = 0
2612 Charset id = 0
2613 Nullable
2614 Size = 8
2615
2616 Metadata
2617 SQLType =SQL_LONG
2618 sub type = 0
2619 Table = TESTDATA
2620 Owner = SYSDBA
2621 Column Name = ROWID
2622 Alias Name = ROWID
2623 Field Name = ROWID
2624 Scale = 0
2625 Charset id = 0
2626 Not Null
2627 Size = 4
2628
2629 SQLType =SQL_VARYING
2630 sub type = 0
2631 Table = TESTDATA
2632 Owner = SYSDBA
2633 Column Name = TITLE
2634 Alias Name = TITLE
2635 Field Name = TITLE
2636 Scale = 0
2637 Charset id = 4
2638 Nullable
2639 Size = 128
2640
2641 SQLType =SQL_TIMESTAMP
2642 sub type = 0
2643 Table = TESTDATA
2644 Owner = SYSDBA
2645 Column Name = DATED
2646 Alias Name = DATED
2647 Field Name = DATED
2648 Scale = 0
2649 Charset id = 0
2650 Nullable
2651 Size = 8
2652
2653 SQLType =SQL_VARYING
2654 sub type = 0
2655 Table = TESTDATA
2656 Owner = SYSDBA
2657 Column Name = NOTES
2658 Alias Name = NOTES
2659 Field Name = NOTES
2660 Scale = 0
2661 Charset id = 4
2662 Nullable
2663 Size = 256
2664
2665 SQLType =SQL_ARRAY
2666 sub type = 0
2667 Table = TESTDATA
2668 Owner = SYSDBA
2669 Column Name = MYARRAY
2670 Alias Name = MYARRAY
2671 Field Name = MYARRAY
2672 Scale = 0
2673 Charset id = 0
2674 Nullable
2675 Size = 8
2676 Array Meta Data:
2677 SQLType =SQL_LONG
2678 Scale = 0
2679 Charset id = 0
2680 Size = 4
2681 Table = TESTDATA
2682 Column = MYARRAY
2683 Dimensions = 1
2684 Bounds: (0:16)
2685
2686 SQLType =SQL_ARRAY
2687 sub type = 0
2688 Table = TESTDATA
2689 Owner = SYSDBA
2690 Column Name = MYARRAY2
2691 Alias Name = MYARRAY2
2692 Field Name = MYARRAY2
2693 Scale = 0
2694 Charset id = 0
2695 Nullable
2696 Size = 8
2697 Array Meta Data:
2698 SQLType =SQL_TIMESTAMP
2699 Scale = 0
2700 Charset id = 0
2701 Size = 8
2702 Table = TESTDATA
2703 Column = MYARRAY2
2704 Dimensions = 1
2705 Bounds: (0:16)
2706
2707 SQLType =SQL_ARRAY
2708 sub type = 0
2709 Table = TESTDATA
2710 Owner = SYSDBA
2711 Column Name = MYARRAY3
2712 Alias Name = MYARRAY3
2713 Field Name = MYARRAY3
2714 Scale = 0
2715 Charset id = 0
2716 Nullable
2717 Size = 8
2718 Array Meta Data:
2719 SQLType =SQL_INT64
2720 Scale = -2
2721 Charset id = 0
2722 Size = 8
2723 Table = TESTDATA
2724 Column = MYARRAY3
2725 Dimensions = 1
2726 Bounds: (0:16)
2727
2728 ROWID = 1
2729 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2730 DATED = 2016/04/01 09:30:00.1000
2731 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2732 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)
2733
2734 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)
2735
2736 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: 0.42) (15: 42.45) (16: 4269)
2737
2738
2739 Shrink to 2:10
2740 Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2741
2742 Write updated reduced slice
2743 Show update array
2744 ROWID = 1
2745 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2746 DATED = 2016/04/01 09:30:00.1000
2747 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2748 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)
2749
2750 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)
2751
2752 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: 0.42) (15: 42.45) (16: 4269)
2753
2754
2755
2756
2757 ------------------------------------------------------
2758 Running Test 8: Create and read back an Array with 2 dimensions
2759 Metadata
2760 SQLType =SQL_LONG
2761 sub type = 0
2762 Table = TESTDATA
2763 Owner = SYSDBA
2764 Column Name = ROWID
2765 Alias Name = ROWID
2766 Field Name = ROWID
2767 Scale = 0
2768 Charset id = 0
2769 Not Null
2770 Size = 4
2771
2772 SQLType =SQL_VARYING
2773 sub type = 0
2774 Table = TESTDATA
2775 Owner = SYSDBA
2776 Column Name = TITLE
2777 Alias Name = TITLE
2778 Field Name = TITLE
2779 Scale = 0
2780 Charset id = 4
2781 Nullable
2782 Size = 128
2783
2784 SQLType =SQL_ARRAY
2785 sub type = 0
2786 Table = TESTDATA
2787 Owner = SYSDBA
2788 Column Name = MYARRAY
2789 Alias Name = MYARRAY
2790 Field Name = MYARRAY
2791 Scale = 0
2792 Charset id = 4
2793 Nullable
2794 Size = 8
2795 Array Meta Data:
2796 SQLType =SQL_VARYING
2797 Scale = 0
2798 Charset id = 4
2799 Size = 16
2800 Table = TESTDATA
2801 Column = MYARRAY
2802 Dimensions = 2
2803 Bounds: (0:16) (-1:7)
2804
2805 SQL Params
2806 SQLType =SQL_LONG
2807 sub type = 0
2808 Field Name = ROWID
2809 Scale = 0
2810 Charset id = 0
2811 Not Null
2812 Size = 4
2813 Value = 0
2814
2815 SQLType =SQL_VARYING
2816 sub type = 0
2817 Field Name = TITLE
2818 Scale = 0
2819 Charset id = 4
2820 Nullable
2821 Size = 128
2822
2823 ROWID = 1
2824 TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2825 MYARRAY = NULL
2826
2827 ROWID = 1
2828 TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2829 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)
2830
2831
2832
2833
2834 ------------------------------------------------------
2835 Running Test 9: Database Information tests
2836 Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus
2837 Pages =1075
2838 Base Level = 13,4,0,3,
2839 Implementation = 11,7,0,3,66,1,66,
2840 Reserved = 0
2841 ODS minor = 0
2842 ODS major = 13
2843 Page Size = 8192
2844 Version = 1: LI-V6.3.0.2496 Firebird 4.0
2845 Database is Read/Write
2846 Database Created: 29/5/2021 16:47:30
2847 Pages Used = 313
2848 Pages Free = 762
2849 Server Memory = 19484112
2850 Forced Writes = 1
2851 Max Memory = 19630384
2852 Num Buffers = 2048
2853 Sweep Interval = 20000
2854 Logged in Users: SYSDBA,
2855 Active Transaction Count = 0
2856 Fetches = 1653
2857 Writes = 8
2858 Reads = 92
2859 Page Writes = 4
2860 Record Version Removals Operation Counts
2861
2862 Deletes Operation Counts
2863
2864 Expunge Count Operation Counts
2865
2866 Insert Count Operation Counts
2867
2868 Purge Count Countites Operation Counts
2869
2870 Indexed Reads Count Operation Counts
2871 Table ID = 4
2872 Count = 63
2873 Table ID = 6
2874 Count = 23
2875 Table ID = 9
2876 Count = 3
2877 Table ID = 11
2878 Count = 2
2879 Table ID = 12
2880 Count = 24
2881 Table ID = 18
2882 Count = 821
2883 Table ID = 20
2884 Count = 5
2885 Table ID = 28
2886 Count = 2
2887 Table ID = 29
2888 Count = 2
2889 Table ID = 31
2890 Count = 1
2891
2892 Sequential Table Scans Operation Counts
2893 Table ID = 0
2894 Count = 100
2895 Table ID = 1
2896 Count = 24
2897
2898 Update Count Operation Counts
2899
2900 Page Size = 8192
2901
2902
2903 ------------------------------------------------------
2904 Running Test 10: Event Handling
2905 Call Async Wait
2906 Async Wait Called
2907 Event Signalled
2908 First Event - usually ignored
2909 Signal Event
2910 Event Counts: TESTEVENT, Count = 1
2911 Two more events
2912 Call Async Wait
2913 Async Wait Called
2914 Event Signalled
2915 Event Signalled
2916 Deferred Events Caught
2917 Event Counts: TESTEVENT, Count = 2
2918 Signal Event
2919 Event Counts: TESTEVENT, Count = 1
2920 Async Wait: Test Cancel
2921 Event Signalled
2922 Async Wait Called
2923 Event Cancelled
2924 Time Out - Cancel Worked!
2925 Sync wait
2926 Event Signalled
2927 Event Counts: TESTEVENT, Count = 1
2928
2929
2930 ------------------------------------------------------
2931 Running Test 11: Services API
2932 SPB: Item Count = 2
2933 user_name = SYSDBA
2934 password = masterkey
2935
2936 Service Manager Version = 2
2937 Server Version = LI-V4.0.0.2496 Firebird 4.0
2938 Implementation = Firebird/Linux/AMD/Intel/x64
2939
2940 Lock Directory = /tmp/firebird/
2941 Message File = /opt/firebird4.0.0/
2942 Security File = /opt/firebird4.0.0/security4.fdb
2943
2944 DB Attachments
2945 No. of Attachments = 0
2946 Databases In Use = 0
2947
2948 Sec. Database User
2949 User Name = SYSDBA
2950 First Name =
2951 Middle Name =
2952 Last Name =
2953 User ID = 0
2954 Group ID = 0
2955
2956
2957 Licence Info: feature is not supported
2958 -feature is not supported
2959
2960 Licence Mask Info: feature is not supported
2961
2962 Capabilities = 6
2963
2964
2965 Get Limbo transactions
2966
2967 Limbo Transactions
2968
2969
2970 Local Backup
2971
2972
2973
2974 Local Backup Complete
2975
2976 Local Restore
2977
2978
2979
2980
2981
2982
2983 Local Restore Complete
2984
2985 Open Database Check
2986 Database OK
2987 Database Dropped
2988
2989
2990 ------------------------------------------------------
2991 Running Test 12: Character Sets
2992 SQL Params
2993 SQLType =SQL_LONG
2994 sub type = 0
2995 Field Name = ROWID
2996 Scale = 0
2997 Charset id = 0
2998 Not Null
2999 Size = 4
3000 Value = 0
3001
3002 SQLType =SQL_VARYING
3003 sub type = 0
3004 Field Name = TITLE
3005 Scale = 0
3006 Charset id = 4
3007 Nullable
3008 Size = 128
3009
3010 SQLType =SQL_VARYING
3011 sub type = 0
3012 Field Name = NOTES
3013 Scale = 0
3014 Charset id = 4
3015 Nullable
3016 Size = 256
3017
3018 SQLType =SQL_BLOB
3019 sub type = 1
3020 Field Name = BLOBDATA
3021 Scale = 0
3022 Charset id = 4
3023 Nullable
3024 Size = 8
3025
3026 SQLType =SQL_BLOB
3027 sub type = 1
3028 Field Name = BLOBDATA2
3029 Scale = 0
3030 Charset id = 4
3031 Nullable
3032 Size = 8
3033
3034 SQLType =SQL_VARYING
3035 sub type = 0
3036 Field Name = INCLEAR
3037 Scale = 0
3038 Charset id = 1
3039 Nullable
3040 Size = 16
3041
3042 SQLType =SQL_TEXT
3043 sub type = 0
3044 Field Name = FIXEDWIDTH
3045 Scale = 0
3046 Charset id = 4
3047 Nullable
3048 Size = 16
3049
3050 Show Param Values
3051 SQL Params
3052 SQLType =SQL_LONG
3053 sub type = 0
3054 Field Name = ROWID
3055 Scale = 0
3056 Charset id = 0
3057 Not Null
3058 Size = 4
3059 Value = 1
3060
3061 SQLType =SQL_VARYING
3062 sub type = 0
3063 Field Name = TITLE
3064 Scale = 0
3065 Charset id = 4
3066 Nullable
3067 Size = 128
3068 Value = Blob Test ©€
3069
3070 SQLType =SQL_VARYING
3071 sub type = 0
3072 Field Name = NOTES
3073 Scale = 0
3074 Charset id = 4
3075 Nullable
3076 Size = 256
3077 Value = Écoute moi
3078
3079 SQLType =SQL_VARYING
3080 sub type = 1
3081 Field Name = BLOBDATA
3082 Scale = 0
3083 Charset id = 4
3084 Nullable
3085 Size = 8192
3086 Value = Some German Special Characters like ÖÄÜöäüß
3087
3088 SQLType =SQL_BLOB
3089 sub type = 1
3090 Field Name = BLOBDATA2
3091 Scale = 0
3092 Charset id = 4
3093 Nullable
3094 Size = 8
3095 Value = Some German Special Characters like ÖÄÜöäüß
3096
3097 SQLType =SQL_VARYING
3098 sub type = 0
3099 Field Name = INCLEAR
3100 Scale = 0
3101 Charset id = 1
3102 Nullable
3103 Size = 16
3104 Value = Test
3105
3106 SQLType =SQL_VARYING
3107 sub type = 0
3108 Field Name = FIXEDWIDTH
3109 Scale = 0
3110 Charset id = 4
3111 Nullable
3112 Size = 16
3113 Value = É
3114
3115 Connection Character Set UTF8
3116 ROWID = 1
3117 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
3118 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
3119 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)
3120 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)
3121 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
3122 FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001)
3123
3124 Connection Character Set NONE
3125 ROWID = 1
3126 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
3127 NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591)
3128 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)
3129 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)
3130 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
3131 FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001)
3132
3133 Connection Character Set WIN1252
3134 ROWID = 1
3135 TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252)
3136 NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252)
3137 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)
3138 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)
3139 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
3140 FIXEDWIDTH = C9 (Charset Id = 53 Codepage = 1252)
3141
3142
3143
3144 ------------------------------------------------------
3145 Running Test 13: Transaction over two databases
3146 Init Database 1
3147 ROWID = 1
3148 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
3149 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
3150 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)
3151 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)
3152 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
3153
3154 Init Database 2
3155 ROWID = 1
3156 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
3157 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
3158 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)
3159 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)
3160 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
3161
3162 ROWID = 1
3163 TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001)
3164 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
3165 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)
3166 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)
3167 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
3168
3169 ROWID = 1
3170 TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001)
3171 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
3172 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)
3173 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)
3174 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
3175
3176
3177
3178 ------------------------------------------------------
3179 Running Test 14: Non select procedures
3180 Default Character set Name = UTF8
3181 Metadata
3182 SQLType =SQL_LONG
3183 sub type = 0
3184 Table = SHOWDATA
3185 Owner = SYSDBA
3186 Column Name = ROWID
3187 Alias Name = ROWID
3188 Field Name = ROWID
3189 Scale = 0
3190 Charset id = 0
3191 Nullable
3192 Size = 4
3193
3194 SQLType =SQL_VARYING
3195 sub type = 0
3196 Table = SHOWDATA
3197 Owner = SYSDBA
3198 Column Name = TITLE
3199 Alias Name = TITLE
3200 Field Name = TITLE
3201 Scale = 0
3202 Charset id = 4
3203 Nullable
3204 Size = 128
3205
3206 ROWID = 1
3207 TITLE = Testing (Charset Id = 4 Codepage = 65001)
3208
3209 Repeat with a different execute transaction
3210
3211 ROWID = 1
3212 TITLE = Testing (Charset Id = 4 Codepage = 65001)
3213
3214 Repeat with a original transaction
3215
3216 ROWID = 1
3217 TITLE = Testing (Charset Id = 4 Codepage = 65001)
3218
3219
3220 ------------------------------------------------------
3221 Running Test 15: Blob Handling and BPBs
3222
3223 Testdata
3224
3225 ROWID = 1
3226 TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3227 BLOBDATA = (blob), Length = 92514
3228
3229 ROWID = 2
3230 TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3231 BLOBDATA = (blob), Length = 13
3232 0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3233
3234 Testdata 2
3235
3236 ROWID = 1
3237 TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3238 BLOBDATA (Charset Id = 4 Codepage = 65001)
3239
3240 Écoute moi
3241
3242
3243
3244 ------------------------------------------------------
3245 Running Test 16: Error handling
3246 Invalid Database Name Test
3247 Error Handled: I/O error during "open" operation for file "Malformed Name"
3248 -Error while trying to open file
3249 -No such file or directory
3250 Invalid User Name Test
3251 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3252 Invalid password Test
3253 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3254 Invalid Prepare SQL Test
3255 Error Handled: Dynamic SQL Error
3256 -SQL error code = -206
3257 -Column unknown
3258 -UNKNOWN_DATE
3259 -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3260 Invalid Open Cursor SQL Test
3261 Error Handled: Dynamic SQL Error
3262 -SQL error code = -206
3263 -Column unknown
3264 -X
3265 -At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE
3266 Transaction not started Test
3267 Error Handled: Transaction is not active
3268 Invalid Param SQL Type Test
3269 Error Handled: Field "EMP_NO" not found
3270 Case sensitive Param SQL Test
3271 Error Handled: Field "EMP_NO" not found
3272 Stale Reference Check
3273 First test correct usage
3274 COUNTER = 42
3275
3276 New Transaction before param set
3277 Error Handled: This interface is no longer up-to-date
3278 New Transaction before Open Cursor
3279 Error Handled: This interface is no longer up-to-date
3280 Stop Stale Reference Checks
3281 New Transaction before param set
3282 COUNTER = 42
3283
3284 New Transaction before Open Cursor
3285 COUNTER = 42
3286
3287 Invalid Server Name Test
3288 Error Handled: Unable to complete network request to host "unknown".
3289 -Failed to locate host machine.
3290 -The specified name was not found in the hosts file or Domain Name Services
3291 Invalid User Name Test
3292 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3293 Invalid password Test
3294 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3295
3296
3297 ------------------------------------------------------
3298 Running Test 17: Date/Time tests and Firebird 4 extensions
3299 FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
3300 Has Local TZ DB = TRUE
3301
3302 Testdata
3303
3304 Metadata
3305 SQLType =SQL_LONG
3306 sub type = 0
3307 Table = TESTDATA
3308 Owner = SYSDBA
3309 Column Name = ROWID
3310 Alias Name = ROWID
3311 Field Name = ROWID
3312 Scale = 0
3313 Charset id = 0
3314 Not Null
3315 Size = 4
3316
3317 SQLType =SQL_TYPE_DATE
3318 sub type = 0
3319 Table = TESTDATA
3320 Owner = SYSDBA
3321 Column Name = DATECOL
3322 Alias Name = DATECOL
3323 Field Name = DATECOL
3324 Scale = 0
3325 Charset id = 0
3326 Nullable
3327 Size = 4
3328
3329 SQLType =SQL_TYPE_TIME
3330 sub type = 0
3331 Table = TESTDATA
3332 Owner = SYSDBA
3333 Column Name = TIMECOL
3334 Alias Name = TIMECOL
3335 Field Name = TIMECOL
3336 Scale = 0
3337 Charset id = 0
3338 Nullable
3339 Size = 4
3340
3341 SQLType =SQL_TIMESTAMP
3342 sub type = 0
3343 Table = TESTDATA
3344 Owner = SYSDBA
3345 Column Name = TIMESTAMPCOL
3346 Alias Name = TIMESTAMPCOL
3347 Field Name = TIMESTAMPCOL
3348 Scale = 0
3349 Charset id = 0
3350 Nullable
3351 Size = 8
3352
3353 ROWID = 1
3354 DATECOL = 2019/04/01
3355 TIMECOL = 11:31:05.0001
3356 TIMESTAMPCOL = 2016/02/29 22:02:35.0001
3357 ROWID = 2
3358 DATECOL = 1939/09/03
3359 TIMECOL = 15:40:00.0002
3360 TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3361 ROWID = 3
3362 DATECOL = 1066/10/14
3363 TIMECOL = 23:59:59.9994
3364 TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3365 ROWID = 4
3366 DATECOL = 1815/06/18
3367 TIMECOL = 00:01:40.1115
3368 TIMESTAMPCOL = 1945/05/08 22:10:00.0010
3369
3370
3371 Testdata - second pass
3372
3373 1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
3374 2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3375 3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
3376 4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
3377 Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1
3378
3379 Firebird 4 extension types
3380 ==========================
3381
3382
3383 Using local FB Client with server TZ database
3384
3385 Local Time Zone Name = Europe/London, ID = 65071
3386 Test Time Zone Setting
3387 Time Zone GMT = GMT
3388 Time Zone Zagreb = Europe/Zagreb
3389 Time Zone Offset -08:00 = -08:00
3390 Time Zone Offset +13:39 = +13:39
3391 Time Zone ID = 1799
3392 Time Zone ID = 959, UTC Time = 23/1/2020 10:30:00
3393 Time Zone ID = 64920
3394 Local Time Zone ID = 65071
3395 Local Time = 22/1/2020 18:30:00, Time Zone = -08:00
3396 Time Zone Offset = 60
3397 Time Zone Offset = 60
3398 Time Zone Offset = 60
3399 Time Zone Offset = 0
3400 Time Zone Offset = 60
3401 Time Zone Offset = Bad Timestamp or missing time zone DB entry (26/3/1989 01:30:00) TZ ID = 65071
3402 Date = 29/11/1969 23:30:00, TimeZone = GMT
3403 Date = 01/4/2001 22:30:10.0010, TimeZone = -08:00
3404 Time = 23:59:10.2000, TimeZone = Europe/London
3405 Show Parameter 2
3406 =
3407 AsString = 11/11/1918 00:11:00.0000 +04:00
3408 Formatted = 1918/11/11 00:11:00.0000 +04:00
3409 TimeZoneID = 1679
3410 Time Zone Name = +04:00
3411 UTC Time = 10/11/1918 20:11:00
3412 DST Offset = 240
3413
3414 FB4 Testdata_TZ
3415
3416 Metadata
3417 SQLType =SQL_LONG
3418 sub type = 0
3419 Table = FB4TESTDATA_TZ
3420 Owner = SYSDBA
3421 Column Name = ROWID
3422 Alias Name = ROWID
3423 Field Name = ROWID
3424 Scale = 0
3425 Charset id = 0
3426 Not Null
3427 Size = 4
3428
3429 SQLType =SQL_TIME_TZ
3430 sub type = 0
3431 Table = FB4TESTDATA_TZ
3432 Owner = SYSDBA
3433 Column Name = TIMECOL
3434 Alias Name = TIMECOL
3435 Field Name = TIMECOL
3436 Scale = 0
3437 Charset id = 0
3438 Nullable
3439 Size = 8
3440
3441 SQLType =SQL_TIMESTAMP_TZ
3442 sub type = 0
3443 Table = FB4TESTDATA_TZ
3444 Owner = SYSDBA
3445 Column Name = TIMESTAMPCOL
3446 Alias Name = TIMESTAMPCOL
3447 Field Name = TIMESTAMPCOL
3448 Scale = 0
3449 Charset id = 0
3450 Nullable
3451 Size = 12
3452
3453 SQLType =SQL_SHORT
3454 sub type = 0
3455 Table =
3456 Owner =
3457 Column Name = EXTRACT
3458 Alias Name = TZ_HOUR
3459 Field Name = TZ_HOUR
3460 Scale = 0
3461 Charset id = 0
3462 Nullable
3463 Size = 2
3464
3465 SQLType =SQL_SHORT
3466 sub type = 0
3467 Table =
3468 Owner =
3469 Column Name = EXTRACT
3470 Alias Name = TZ_MINUTE
3471 Field Name = TZ_MINUTE
3472 Scale = 0
3473 Charset id = 0
3474 Nullable
3475 Size = 2
3476
3477 ROWID = 1
3478 TIMECOL =
3479 AsString = 11:32:10.0002 -05:00
3480 Formatted = 11:32:10.0002 -05:00
3481 TimeZoneID = 1139
3482 Time Zone Name = -05:00
3483 UTC Time = 16:32:10
3484 DST Offset = -300
3485 TIMESTAMPCOL =
3486 AsString = 01/4/2020 11:31:05.0001 +01:00
3487 Formatted = 2020/04/01 11:31:05.0001 +01:00
3488 TimeZoneID = 1499
3489 Time Zone Name = +01:00
3490 UTC Time = 01/4/2020 10:31:05
3491 DST Offset = 60
3492 TZ_HOUR = -5
3493 TZ_MINUTE = 0
3494 ROWID = 2
3495 TIMECOL =
3496 AsString = 14:02:10.0050 -08:00
3497 Formatted = 14:02:10.0050 -08:00
3498 TimeZoneID = 959
3499 Time Zone Name = -08:00
3500 UTC Time = 22:02:10
3501 DST Offset = -480
3502 TIMESTAMPCOL =
3503 AsString = 11/11/1918 11:11:00.0000 00:00
3504 Formatted = 1918/11/11 11:11:00.0000 Europe/London
3505 TimeZoneID = 65071
3506 Time Zone Name = Europe/London
3507 UTC Time = 11/11/1918 11:11:00
3508 DST Offset = 0
3509 TZ_HOUR = -8
3510 TZ_MINUTE = 0
3511 ROWID = 3
3512 TIMECOL =
3513 AsString = 22:02:10.0050 -08:00
3514 Formatted = 22:02:10.0050 -08:00
3515 TimeZoneID = 959
3516 Time Zone Name = -08:00
3517 UTC Time = 06:02:10
3518 DST Offset = -480
3519 TIMESTAMPCOL =
3520 AsString = 11/11/1918 00:11:00.0000 +04:00
3521 Formatted = 1918/11/11 00:11:00.0000 +04:00
3522 TimeZoneID = 1679
3523 Time Zone Name = +04:00
3524 UTC Time = 10/11/1918 20:11:00
3525 DST Offset = 240
3526 TZ_HOUR = -8
3527 TZ_MINUTE = 0
3528 ROWID = 4
3529 TIMECOL =
3530 AsString = 14:02:10.5000 -08:00
3531 Formatted = 14:02:10.5000 -08:00
3532 TimeZoneID = 959
3533 Time Zone Name = -08:00
3534 UTC Time = 22:02:10
3535 DST Offset = -480
3536 TIMESTAMPCOL =
3537 AsString = 11/11/1918 11:11:00.0000 00:00
3538 Formatted = 1918/11/11 11:11:00.0000 Europe/London
3539 TimeZoneID = 65071
3540 Time Zone Name = Europe/London
3541 UTC Time = 11/11/1918 11:11:00
3542 DST Offset = 0
3543 TZ_HOUR = -8
3544 TZ_MINUTE = 0
3545 ROWID = 5
3546 TIMECOL =
3547 AsString = 11:31:05.0001 -05:00
3548 Formatted = 11:31:05.0001 America/New_York
3549 TimeZoneID = 65361
3550 Time Zone Name = America/New_York
3551 UTC Time = 16:31:05
3552 DST Offset = -300
3553 TIMESTAMPCOL =
3554 AsString = 04/7/2020 07:00:00.0000 -04:00
3555 Formatted = 2020/07/04 07:00:00.0000 America/New_York
3556 TimeZoneID = 65361
3557 Time Zone Name = America/New_York
3558 UTC Time = 04/7/2020 11:00:00
3559 DST Offset = -240
3560 TZ_HOUR = -5
3561 TZ_MINUTE = 0
3562 ROWID = 6
3563 TIMECOL =
3564 AsString = 11:31:05.0001 -05:00
3565 Formatted = 11:31:05.0001 EST5EDT
3566 TimeZoneID = 65135
3567 Time Zone Name = EST5EDT
3568 UTC Time = 16:31:05
3569 DST Offset = -300
3570 TIMESTAMPCOL =
3571 AsString = 01/7/2020 07:00:00.0000 -04:00
3572 Formatted = 2020/07/01 07:00:00.0000 America/New_York
3573 TimeZoneID = 65361
3574 Time Zone Name = America/New_York
3575 UTC Time = 01/7/2020 11:00:00
3576 DST Offset = -240
3577 TZ_HOUR = -5
3578 TZ_MINUTE = 0
3579 ROWID = 7
3580 TIMECOL =
3581 AsString = 11:31:05.0001 +06:00
3582 Formatted = 11:31:05.0001 BST
3583 TimeZoneID = 65162
3584 Time Zone Name = BST
3585 UTC Time = 05:31:05
3586 DST Offset = 360
3587 TIMESTAMPCOL =
3588 AsString = 01/7/2020 07:00:00.0000 -04:00
3589 Formatted = 2020/07/01 07:00:00.0000 EST5EDT
3590 TimeZoneID = 65135
3591 Time Zone Name = EST5EDT
3592 UTC Time = 01/7/2020 11:00:00
3593 DST Offset = -240
3594 TZ_HOUR = 6
3595 TZ_MINUTE = 0
3596 ROWID = 8
3597 TIMECOL =
3598 AsString = 11:31:05.0001 +01:00
3599 Formatted = 11:31:05.0001 Europe/Paris
3600 TimeZoneID = 65061
3601 Time Zone Name = Europe/Paris
3602 UTC Time = 10:31:05
3603 DST Offset = 60
3604 TIMESTAMPCOL =
3605 AsString = 01/7/2020 06:00:00.0000 -05:00
3606 Formatted = 2020/07/01 06:00:00.0000 EST
3607 TimeZoneID = 65136
3608 Time Zone Name = EST
3609 UTC Time = 01/7/2020 11:00:00
3610 DST Offset = -300
3611 TZ_HOUR = 1
3612 TZ_MINUTE = 0
3613
3614
3615 Using local TZ database
3616
3617 Test Time Zone Setting
3618 Time Zone GMT = GMT
3619 Time Zone Zagreb = Europe/Zagreb
3620 Time Zone Offset -08:00 = -08:00
3621 Time Zone Offset +13:39 = +13:39
3622 Time Zone ID = 1799
3623 Time Zone ID = 959, UTC Time = 23/1/2020 10:30:00
3624 Time Zone ID = 64920
3625 Local Time Zone ID = 65071
3626 Local Time = 23/1/2020 10:30:00, Time Zone = -08:00
3627 Time Zone Offset = 60
3628 Time Zone Offset = 60
3629 Time Zone Offset = 60
3630 Time Zone Offset = 0
3631 Time Zone Offset = 60
3632 Time Zone Offset = 0
3633 Date = 29/11/1969 23:30:00, TimeZone = GMT
3634 Date = 01/4/2001 22:30:10.0010, TimeZone = -08:00
3635 Time = 23:59:10.2000, TimeZone = Europe/London
3636 Show Parameter 2
3637 =
3638 AsString = 11/11/1918 00:11:00.0000 +04:00
3639 Formatted = 1918/11/11 00:11:00.0000 +04:00
3640 TimeZoneID = 1679
3641 Time Zone Name = +04:00
3642 UTC Time = 10/11/1918 20:11:00
3643 DST Offset = 240
3644
3645 FB4 Testdata_TZ
3646
3647 Metadata
3648 SQLType =SQL_LONG
3649 sub type = 0
3650 Table = FB4TESTDATA_TZ
3651 Owner = SYSDBA
3652 Column Name = ROWID
3653 Alias Name = ROWID
3654 Field Name = ROWID
3655 Scale = 0
3656 Charset id = 0
3657 Not Null
3658 Size = 4
3659
3660 SQLType =SQL_TIME_TZ
3661 sub type = 0
3662 Table = FB4TESTDATA_TZ
3663 Owner = SYSDBA
3664 Column Name = TIMECOL
3665 Alias Name = TIMECOL
3666 Field Name = TIMECOL
3667 Scale = 0
3668 Charset id = 0
3669 Nullable
3670 Size = 8
3671
3672 SQLType =SQL_TIMESTAMP_TZ
3673 sub type = 0
3674 Table = FB4TESTDATA_TZ
3675 Owner = SYSDBA
3676 Column Name = TIMESTAMPCOL
3677 Alias Name = TIMESTAMPCOL
3678 Field Name = TIMESTAMPCOL
3679 Scale = 0
3680 Charset id = 0
3681 Nullable
3682 Size = 12
3683
3684 SQLType =SQL_SHORT
3685 sub type = 0
3686 Table =
3687 Owner =
3688 Column Name = EXTRACT
3689 Alias Name = TZ_HOUR
3690 Field Name = TZ_HOUR
3691 Scale = 0
3692 Charset id = 0
3693 Nullable
3694 Size = 2
3695
3696 SQLType =SQL_SHORT
3697 sub type = 0
3698 Table =
3699 Owner =
3700 Column Name = EXTRACT
3701 Alias Name = TZ_MINUTE
3702 Field Name = TZ_MINUTE
3703 Scale = 0
3704 Charset id = 0
3705 Nullable
3706 Size = 2
3707
3708 ROWID = 1
3709 TIMECOL =
3710 AsString = 11:32:10.0002 -05:00
3711 Formatted = 11:32:10.0002 -05:00
3712 TimeZoneID = 1139
3713 Time Zone Name = -05:00
3714 UTC Time = 16:32:10
3715 DST Offset = -300
3716 TIMESTAMPCOL =
3717 AsString = 01/4/2020 11:31:05.0001 +01:00
3718 Formatted = 2020/04/01 11:31:05.0001 +01:00
3719 TimeZoneID = 1499
3720 Time Zone Name = +01:00
3721 UTC Time = 01/4/2020 10:31:05
3722 DST Offset = 60
3723 TZ_HOUR = -5
3724 TZ_MINUTE = 0
3725 ROWID = 2
3726 TIMECOL =
3727 AsString = 14:02:10.0050 -08:00
3728 Formatted = 14:02:10.0050 -08:00
3729 TimeZoneID = 959
3730 Time Zone Name = -08:00
3731 UTC Time = 22:02:10
3732 DST Offset = -480
3733 TIMESTAMPCOL =
3734 AsString = 11/11/1918 11:11:00.0000 00:00
3735 Formatted = 1918/11/11 11:11:00.0000 Europe/London
3736 TimeZoneID = 65071
3737 Time Zone Name = Europe/London
3738 UTC Time = 11/11/1918 11:11:00
3739 DST Offset = 0
3740 TZ_HOUR = -8
3741 TZ_MINUTE = 0
3742 ROWID = 3
3743 TIMECOL =
3744 AsString = 22:02:10.0050 -08:00
3745 Formatted = 22:02:10.0050 -08:00
3746 TimeZoneID = 959
3747 Time Zone Name = -08:00
3748 UTC Time = 06:02:10
3749 DST Offset = -480
3750 TIMESTAMPCOL =
3751 AsString = 11/11/1918 00:11:00.0000 +04:00
3752 Formatted = 1918/11/11 00:11:00.0000 +04:00
3753 TimeZoneID = 1679
3754 Time Zone Name = +04:00
3755 UTC Time = 10/11/1918 20:11:00
3756 DST Offset = 240
3757 TZ_HOUR = -8
3758 TZ_MINUTE = 0
3759 ROWID = 4
3760 TIMECOL =
3761 AsString = 14:02:10.5000 -08:00
3762 Formatted = 14:02:10.5000 -08:00
3763 TimeZoneID = 959
3764 Time Zone Name = -08:00
3765 UTC Time = 22:02:10
3766 DST Offset = -480
3767 TIMESTAMPCOL =
3768 AsString = 11/11/1918 11:11:00.0000 00:00
3769 Formatted = 1918/11/11 11:11:00.0000 Europe/London
3770 TimeZoneID = 65071
3771 Time Zone Name = Europe/London
3772 UTC Time = 11/11/1918 11:11:00
3773 DST Offset = 0
3774 TZ_HOUR = -8
3775 TZ_MINUTE = 0
3776 ROWID = 5
3777 TIMECOL =
3778 AsString = 11:31:05.0001 -05:00
3779 Formatted = 11:31:05.0001 America/New_York
3780 TimeZoneID = 65361
3781 Time Zone Name = America/New_York
3782 UTC Time = 16:31:05
3783 DST Offset = -300
3784 TIMESTAMPCOL =
3785 AsString = 04/7/2020 07:00:00.0000 -04:00
3786 Formatted = 2020/07/04 07:00:00.0000 America/New_York
3787 TimeZoneID = 65361
3788 Time Zone Name = America/New_York
3789 UTC Time = 04/7/2020 11:00:00
3790 DST Offset = -240
3791 TZ_HOUR = -5
3792 TZ_MINUTE = 0
3793 ROWID = 6
3794 TIMECOL =
3795 AsString = 11:31:05.0001 -05:00
3796 Formatted = 11:31:05.0001 EST5EDT
3797 TimeZoneID = 65135
3798 Time Zone Name = EST5EDT
3799 UTC Time = 16:31:05
3800 DST Offset = -300
3801 TIMESTAMPCOL =
3802 AsString = 01/7/2020 07:00:00.0000 -04:00
3803 Formatted = 2020/07/01 07:00:00.0000 America/New_York
3804 TimeZoneID = 65361
3805 Time Zone Name = America/New_York
3806 UTC Time = 01/7/2020 11:00:00
3807 DST Offset = -240
3808 TZ_HOUR = -5
3809 TZ_MINUTE = 0
3810 ROWID = 7
3811 TIMECOL =
3812 AsString = 11:31:05.0001 +06:00
3813 Formatted = 11:31:05.0001 BST
3814 TimeZoneID = 65162
3815 Time Zone Name = BST
3816 UTC Time = 05:31:05
3817 DST Offset = 360
3818 TIMESTAMPCOL =
3819 AsString = 01/7/2020 07:00:00.0000 -04:00
3820 Formatted = 2020/07/01 07:00:00.0000 EST5EDT
3821 TimeZoneID = 65135
3822 Time Zone Name = EST5EDT
3823 UTC Time = 01/7/2020 11:00:00
3824 DST Offset = -240
3825 TZ_HOUR = 6
3826 TZ_MINUTE = 0
3827 ROWID = 8
3828 TIMECOL =
3829 AsString = 11:31:05.0001 +01:00
3830 Formatted = 11:31:05.0001 Europe/Paris
3831 TimeZoneID = 65061
3832 Time Zone Name = Europe/Paris
3833 UTC Time = 10:31:05
3834 DST Offset = 60
3835 TIMESTAMPCOL =
3836 AsString = 01/7/2020 06:00:00.0000 -05:00
3837 Formatted = 2020/07/01 06:00:00.0000 EST
3838 TimeZoneID = 65136
3839 Time Zone Name = EST
3840 UTC Time = 01/7/2020 11:00:00
3841 DST Offset = -300
3842 TZ_HOUR = 1
3843 TZ_MINUTE = 0
3844
3845
3846 Using Extended TZ Data Type
3847
3848 Show Parameter 2
3849 =
3850 AsString = 11/11/1918 00:11:00.0000 +04:00
3851 Formatted = 1918/11/11 00:11:00.0000 +04:00
3852 TimeZoneID = 1679
3853 Time Zone Name = +04:00
3854 UTC Time = 10/11/1918 20:11:00
3855 DST Offset = 240
3856
3857 FB4 Testdata_TZ
3858
3859 Metadata
3860 SQLType =SQL_LONG
3861 sub type = 0
3862 Table = FB4TESTDATA_TZ
3863 Owner = SYSDBA
3864 Column Name = ROWID
3865 Alias Name = ROWID
3866 Field Name = ROWID
3867 Scale = 0
3868 Charset id = 0
3869 Not Null
3870 Size = 4
3871
3872 SQLType =SQL_TIME_TZ_EX
3873 sub type = 0
3874 Table = FB4TESTDATA_TZ
3875 Owner = SYSDBA
3876 Column Name = TIMECOL
3877 Alias Name = TIMECOL
3878 Field Name = TIMECOL
3879 Scale = 0
3880 Charset id = 0
3881 Nullable
3882 Size = 8
3883
3884 SQLType =SQL_TIMESTAMP_TZ_EX
3885 sub type = 0
3886 Table = FB4TESTDATA_TZ
3887 Owner = SYSDBA
3888 Column Name = TIMESTAMPCOL
3889 Alias Name = TIMESTAMPCOL
3890 Field Name = TIMESTAMPCOL
3891 Scale = 0
3892 Charset id = 0
3893 Nullable
3894 Size = 12
3895
3896 SQLType =SQL_SHORT
3897 sub type = 0
3898 Table =
3899 Owner =
3900 Column Name = EXTRACT
3901 Alias Name = TZ_HOUR
3902 Field Name = TZ_HOUR
3903 Scale = 0
3904 Charset id = 0
3905 Nullable
3906 Size = 2
3907
3908 SQLType =SQL_SHORT
3909 sub type = 0
3910 Table =
3911 Owner =
3912 Column Name = EXTRACT
3913 Alias Name = TZ_MINUTE
3914 Field Name = TZ_MINUTE
3915 Scale = 0
3916 Charset id = 0
3917 Nullable
3918 Size = 2
3919
3920 ROWID = 1
3921 TIMECOL =
3922 AsString = 11:32:10.0002 -05:00
3923 Formatted = 11:32:10.0002 -05:00
3924 TimeZoneID = 1139
3925 Time Zone Name = -05:00
3926 UTC Time = 16:32:10
3927 DST Offset = -300
3928 TIMESTAMPCOL =
3929 AsString = 01/4/2020 11:31:05.0001 +01:00
3930 Formatted = 2020/04/01 11:31:05.0001 +01:00
3931 TimeZoneID = 1499
3932 Time Zone Name = +01:00
3933 UTC Time = 01/4/2020 10:31:05
3934 DST Offset = 60
3935 TZ_HOUR = -5
3936 TZ_MINUTE = 0
3937 ROWID = 2
3938 TIMECOL =
3939 AsString = 14:02:10.0050 -08:00
3940 Formatted = 14:02:10.0050 -08:00
3941 TimeZoneID = 959
3942 Time Zone Name = -08:00
3943 UTC Time = 22:02:10
3944 DST Offset = -480
3945 TIMESTAMPCOL =
3946 AsString = 11/11/1918 11:11:00.0000 00:00
3947 Formatted = 1918/11/11 11:11:00.0000 Europe/London
3948 TimeZoneID = 65071
3949 Time Zone Name = Europe/London
3950 UTC Time = 11/11/1918 11:11:00
3951 DST Offset = 0
3952 TZ_HOUR = -8
3953 TZ_MINUTE = 0
3954 ROWID = 3
3955 TIMECOL =
3956 AsString = 22:02:10.0050 -08:00
3957 Formatted = 22:02:10.0050 -08:00
3958 TimeZoneID = 959
3959 Time Zone Name = -08:00
3960 UTC Time = 06:02:10
3961 DST Offset = -480
3962 TIMESTAMPCOL =
3963 AsString = 11/11/1918 00:11:00.0000 +04:00
3964 Formatted = 1918/11/11 00:11:00.0000 +04:00
3965 TimeZoneID = 1679
3966 Time Zone Name = +04:00
3967 UTC Time = 10/11/1918 20:11:00
3968 DST Offset = 240
3969 TZ_HOUR = -8
3970 TZ_MINUTE = 0
3971 ROWID = 4
3972 TIMECOL =
3973 AsString = 14:02:10.5000 -08:00
3974 Formatted = 14:02:10.5000 -08:00
3975 TimeZoneID = 959
3976 Time Zone Name = -08:00
3977 UTC Time = 22:02:10
3978 DST Offset = -480
3979 TIMESTAMPCOL =
3980 AsString = 11/11/1918 11:11:00.0000 00:00
3981 Formatted = 1918/11/11 11:11:00.0000 Europe/London
3982 TimeZoneID = 65071
3983 Time Zone Name = Europe/London
3984 UTC Time = 11/11/1918 11:11:00
3985 DST Offset = 0
3986 TZ_HOUR = -8
3987 TZ_MINUTE = 0
3988 ROWID = 5
3989 TIMECOL =
3990 AsString = 11:31:05.0001 -05:00
3991 Formatted = 11:31:05.0001 America/New_York
3992 TimeZoneID = 65361
3993 Time Zone Name = America/New_York
3994 UTC Time = 16:31:05
3995 DST Offset = -300
3996 TIMESTAMPCOL =
3997 AsString = 04/7/2020 07:00:00.0000 -04:00
3998 Formatted = 2020/07/04 07:00:00.0000 America/New_York
3999 TimeZoneID = 65361
4000 Time Zone Name = America/New_York
4001 UTC Time = 04/7/2020 11:00:00
4002 DST Offset = -240
4003 TZ_HOUR = -5
4004 TZ_MINUTE = 0
4005 ROWID = 6
4006 TIMECOL =
4007 AsString = 11:31:05.0001 -05:00
4008 Formatted = 11:31:05.0001 EST5EDT
4009 TimeZoneID = 65135
4010 Time Zone Name = EST5EDT
4011 UTC Time = 16:31:05
4012 DST Offset = -300
4013 TIMESTAMPCOL =
4014 AsString = 01/7/2020 07:00:00.0000 -04:00
4015 Formatted = 2020/07/01 07:00:00.0000 America/New_York
4016 TimeZoneID = 65361
4017 Time Zone Name = America/New_York
4018 UTC Time = 01/7/2020 11:00:00
4019 DST Offset = -240
4020 TZ_HOUR = -5
4021 TZ_MINUTE = 0
4022 ROWID = 7
4023 TIMECOL =
4024 AsString = 11:31:05.0001 +06:00
4025 Formatted = 11:31:05.0001 BST
4026 TimeZoneID = 65162
4027 Time Zone Name = BST
4028 UTC Time = 05:31:05
4029 DST Offset = 360
4030 TIMESTAMPCOL =
4031 AsString = 01/7/2020 07:00:00.0000 -04:00
4032 Formatted = 2020/07/01 07:00:00.0000 EST5EDT
4033 TimeZoneID = 65135
4034 Time Zone Name = EST5EDT
4035 UTC Time = 01/7/2020 11:00:00
4036 DST Offset = -240
4037 TZ_HOUR = 6
4038 TZ_MINUTE = 0
4039 ROWID = 8
4040 TIMECOL =
4041 AsString = 11:31:05.0001 +01:00
4042 Formatted = 11:31:05.0001 Europe/Paris
4043 TimeZoneID = 65061
4044 Time Zone Name = Europe/Paris
4045 UTC Time = 10:31:05
4046 DST Offset = 60
4047 TIMESTAMPCOL =
4048 AsString = 01/7/2020 06:00:00.0000 -05:00
4049 Formatted = 2020/07/01 06:00:00.0000 EST
4050 TimeZoneID = 65136
4051 Time Zone Name = EST
4052 UTC Time = 01/7/2020 11:00:00
4053 DST Offset = -300
4054 TZ_HOUR = 1
4055 TZ_MINUTE = 0
4056
4057
4058
4059 ------------------------------------------------------
4060 Running Test 18: Firebird 4 Decfloat extensions
4061 FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4062
4063 FB4 Testdata_DECFloat
4064
4065 Metadata
4066 SQLType =SQL_LONG
4067 sub type = 0
4068 Table = FB4TESTDATA_DECFLOAT
4069 Owner = SYSDBA
4070 Column Name = ROWID
4071 Alias Name = ROWID
4072 Field Name = ROWID
4073 Scale = 0
4074 Charset id = 0
4075 Not Null
4076 Size = 4
4077
4078 SQLType =SQL_DEC16
4079 sub type = 0
4080 Table = FB4TESTDATA_DECFLOAT
4081 Owner = SYSDBA
4082 Column Name = FLOAT16
4083 Alias Name = FLOAT16
4084 Field Name = FLOAT16
4085 Scale = 0
4086 Charset id = 0
4087 Nullable
4088 Size = 8
4089
4090 SQLType =SQL_DEC34
4091 sub type = 0
4092 Table = FB4TESTDATA_DECFLOAT
4093 Owner = SYSDBA
4094 Column Name = FLOAT34
4095 Alias Name = FLOAT34
4096 Field Name = FLOAT34
4097 Scale = 0
4098 Charset id = 0
4099 Nullable
4100 Size = 16
4101
4102 SQLType =SQL_INT128
4103 sub type = 0
4104 Table = FB4TESTDATA_DECFLOAT
4105 Owner = SYSDBA
4106 Column Name = BIGNUMBER
4107 Alias Name = BIGNUMBER
4108 Field Name = BIGNUMBER
4109 Scale = -6
4110 Charset id = 0
4111 Nullable
4112 Size = 16
4113
4114 SQLType =SQL_INT128
4115 sub type = 0
4116 Table = FB4TESTDATA_DECFLOAT
4117 Owner = SYSDBA
4118 Column Name = BIGGERNUMBER
4119 Alias Name = BIGGERNUMBER
4120 Field Name = BIGGERNUMBER
4121 Scale = -4
4122 Charset id = 0
4123 Nullable
4124 Size = 16
4125
4126 SQLType =SQL_INT128
4127 sub type = 0
4128 Table = FB4TESTDATA_DECFLOAT
4129 Owner = SYSDBA
4130 Column Name = BIGINTEGER
4131 Alias Name = BIGINTEGER
4132 Field Name = BIGINTEGER
4133 Scale = 0
4134 Charset id = 0
4135 Nullable
4136 Size = 16
4137
4138 RowID = 1
4139 Float16 = 64000000000.01
4140 Precision = 13
4141 Sign = 0
4142 Special = 0
4143 Places = 2
4144 Digits = 64 00 00 00 00 00 10
4145 Float34 = 123456789123456789.12345678
4146 Precision = 26
4147 Sign = 0
4148 Special = 0
4149 Places = 8
4150 Digits = 12 34 56 78 91 23 45 67 89 12 34 56 78
4151 BigNumber = 123456123456.123456
4152 Precision = 18
4153 Sign = 0
4154 Special = 0
4155 Places = 6
4156 Digits = 12 34 56 12 34 56 12 34 56
4157 BigInteger = 123456789123456789
4158 Precision = 18
4159 Sign = 0
4160 Special = 0
4161 Places = 0
4162 Digits = 12 34 56 78 91 23 45 67 89
4163
4164 RowID = 2
4165 Float16 = -64000000000.01
4166 Precision = 13
4167 Sign = 1
4168 Special = 0
4169 Places = 2
4170 Digits = 64 00 00 00 00 00 10
4171 Float34 = -123456789123456789.12345678
4172 Precision = 26
4173 Sign = 1
4174 Special = 0
4175 Places = 8
4176 Digits = 12 34 56 78 91 23 45 67 89 12 34 56 78
4177 BigNumber = -123456123456.123456
4178 Precision = 18
4179 Sign = 1
4180 Special = 0
4181 Places = 6
4182 Digits = 12 34 56 12 34 56 12 34 56
4183 BigInteger = Null
4184
4185 RowID = 3
4186 Float16 = 64100000000.011
4187 Precision = 14
4188 Sign = 0
4189 Special = 0
4190 Places = 3
4191 Digits = 64 10 00 00 00 00 11
4192 Float34 = 12345678912.1200
4193 Precision = 15
4194 Sign = 0
4195 Special = 0
4196 Places = 4
4197 Digits = 12 34 56 78 91 21 20 00
4198 BigNumber = 1234561234567.123456
4199 Precision = 19
4200 Sign = 0
4201 Special = 0
4202 Places = 6
4203 Digits = 12 34 56 12 34 56 71 23 45 60
4204 BiggerNumber = 11123456123456123456123456123456.1235
4205 Precision = 36
4206 Sign = 0
4207 Special = 0
4208 Places = 4
4209 Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35
4210 BigInteger = Null
4211
4212 RowID = 4
4213 Float16 = 0
4214 Precision = 0
4215 Sign = 0
4216 Special = 0
4217 Places = 0
4218 Digits =
4219 Float34 = -1
4220 Precision = 1
4221 Sign = 1
4222 Special = 0
4223 Places = 0
4224 Digits = 10
4225 BigNumber = 0.000000
4226 Precision = 0
4227 Sign = 0
4228 Special = 0
4229 Places = 0
4230 Digits =
4231 BiggerNumber = 0.0000
4232 Precision = 0
4233 Sign = 0
4234 Special = 0
4235 Places = 0
4236 Digits =
4237 BigInteger = Null
4238
4239 Metadata
4240 SQLType =SQL_LONG
4241 sub type = 0
4242 Table = FB4TESTDATA_DECFLOAT_AR
4243 Owner = SYSDBA
4244 Column Name = ROWID
4245 Alias Name = ROWID
4246 Field Name = ROWID
4247 Scale = 0
4248 Charset id = 0
4249 Not Null
4250 Size = 4
4251
4252 SQLType =SQL_ARRAY
4253 sub type = 0
4254 Table = FB4TESTDATA_DECFLOAT_AR
4255 Owner = SYSDBA
4256 Column Name = FLOAT16
4257 Alias Name = FLOAT16
4258 Field Name = FLOAT16
4259 Scale = 0
4260 Charset id = 0
4261 Nullable
4262 Size = 8
4263 Array Meta Data:
4264 SQLType =SQL_DEC16
4265 Scale = 0
4266 Charset id = 0
4267 Size = 8
4268 Table = FB4TESTDATA_DECFLOAT_AR
4269 Column = FLOAT16
4270 Dimensions = 1
4271 Bounds: (0:16)
4272
4273 SQLType =SQL_ARRAY
4274 sub type = 0
4275 Table = FB4TESTDATA_DECFLOAT_AR
4276 Owner = SYSDBA
4277 Column Name = FLOAT34
4278 Alias Name = FLOAT34
4279 Field Name = FLOAT34
4280 Scale = 0
4281 Charset id = 0
4282 Nullable
4283 Size = 8
4284 Array Meta Data:
4285 SQLType =SQL_DEC34
4286 Scale = 0
4287 Charset id = 0
4288 Size = 16
4289 Table = FB4TESTDATA_DECFLOAT_AR
4290 Column = FLOAT34
4291 Dimensions = 1
4292 Bounds: (0:16)
4293
4294 SQLType =SQL_ARRAY
4295 sub type = 0
4296 Table = FB4TESTDATA_DECFLOAT_AR
4297 Owner = SYSDBA
4298 Column Name = BIGNUMBER
4299 Alias Name = BIGNUMBER
4300 Field Name = BIGNUMBER
4301 Scale = 0
4302 Charset id = 0
4303 Nullable
4304 Size = 8
4305 Array Meta Data:
4306 SQLType =SQL_INT128
4307 Scale = -6
4308 Charset id = 0
4309 Size = 16
4310 Table = FB4TESTDATA_DECFLOAT_AR
4311 Column = BIGNUMBER
4312 Dimensions = 1
4313 Bounds: (0:16)
4314
4315
4316 Decfloat Arrays
4317 Row No 1
4318 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)
4319
4320 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)
4321
4322 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)
4323
4324
4325
4326 ------------------------------------------------------
4327 Running Test 19: Batch Update and Insert Queries
4328 Opening inet://localhost/employee
4329 Database Open
4330 Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4331 Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4332 Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4333 on disk structure version 13.0
4334 Rows before update
4335 EMP_NO = 2
4336 FIRST_NAME = Robert
4337 LAST_NAME = Nelson
4338 PHONE_EXT = 250
4339 HIRE_DATE = 1988/12/28 00:00:00.0000
4340 DEPT_NO = 600
4341 JOB_CODE = VP
4342 JOB_GRADE = 2
4343 JOB_COUNTRY = USA
4344 SALARY = 105,900.00
4345 FULL_NAME = Nelson, Robert
4346 EMP_NO = 8
4347 FIRST_NAME = Leslie
4348 LAST_NAME = Johnson
4349 PHONE_EXT = 410
4350 HIRE_DATE = 1989/04/05 00:00:00.0000
4351 DEPT_NO = 180
4352 JOB_CODE = Mktg
4353 JOB_GRADE = 3
4354 JOB_COUNTRY = USA
4355 SALARY = 64,635.00
4356 FULL_NAME = Johnson, Leslie
4357
4358 Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4359 Batch Completion Info
4360 Total rows processed = 2
4361 Updated Records = 2
4362 Row 1 State = bcNoMoreErrors Msg =
4363 Row 2 State = bcNoMoreErrors Msg =
4364 Rows after update
4365 EMP_NO = 2
4366 FIRST_NAME = Robert
4367 LAST_NAME = Nelson
4368 PHONE_EXT = 250
4369 HIRE_DATE = 2018/05/28 00:00:00.0000
4370 DEPT_NO = 600
4371 JOB_CODE = VP
4372 JOB_GRADE = 2
4373 JOB_COUNTRY = USA
4374 SALARY = 105,900.00
4375 FULL_NAME = Nelson, Robert
4376 EMP_NO = 8
4377 FIRST_NAME = Leslie
4378 LAST_NAME = Johnson
4379 PHONE_EXT = 410
4380 HIRE_DATE = 2016/01/31 00:00:00.0000
4381 DEPT_NO = 180
4382 JOB_CODE = Mktg
4383 JOB_GRADE = 3
4384 JOB_COUNTRY = USA
4385 SALARY = 64,635.00
4386 FULL_NAME = Johnson, Leslie
4387
4388
4389 Repeat but with a last dummy row that is ignored
4390 Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4391 Batch Completion Info
4392 Total rows processed = 2
4393 Updated Records = 2
4394 Row 1 State = bcNoMoreErrors Msg =
4395 Row 2 State = bcNoMoreErrors Msg =
4396 Rows after update
4397 EMP_NO = 2
4398 FIRST_NAME = Robert
4399 LAST_NAME = Nelson
4400 PHONE_EXT = 250
4401 HIRE_DATE = 2018/05/28 00:00:00.0000
4402 DEPT_NO = 600
4403 JOB_CODE = VP
4404 JOB_GRADE = 2
4405 JOB_COUNTRY = USA
4406 SALARY = 105,900.00
4407 FULL_NAME = Nelson, Robert
4408 EMP_NO = 8
4409 FIRST_NAME = Leslie
4410 LAST_NAME = Johnson
4411 PHONE_EXT = 410
4412 HIRE_DATE = 2016/01/31 00:00:00.0000
4413 DEPT_NO = 180
4414 JOB_CODE = Mktg
4415 JOB_GRADE = 3
4416 JOB_COUNTRY = USA
4417 SALARY = 64,635.00
4418 FULL_NAME = Johnson, Leslie
4419
4420
4421 Insert rows
4422 Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0
4423 Batch Completion Info
4424 Total rows processed = 3
4425 Updated Records = 3
4426 Row 1 State = bcNoMoreErrors Msg =
4427 Row 2 State = bcNoMoreErrors Msg =
4428 Row 3 State = bcNoMoreErrors Msg =
4429 Rows after insert
4430 EMP_NO = 150
4431 FIRST_NAME = John
4432 LAST_NAME = Doe
4433 PHONE_EXT =
4434 HIRE_DATE = 2015/04/01 00:00:00.0000
4435 DEPT_NO = 600
4436 JOB_CODE = Eng
4437 JOB_GRADE = 4
4438 JOB_COUNTRY = England
4439 SALARY = 41,000.89
4440 FULL_NAME = Doe, John
4441 EMP_NO = 151
4442 FIRST_NAME = Jane
4443 LAST_NAME = Doe
4444 PHONE_EXT =
4445 HIRE_DATE = 2015/04/02 00:00:00.0000
4446 DEPT_NO = 600
4447 JOB_CODE = Eng
4448 JOB_GRADE = 4
4449 JOB_COUNTRY = England
4450 SALARY = 42,000.89
4451 FULL_NAME = Doe, Jane
4452 EMP_NO = 152
4453 FIRST_NAME = John
4454 LAST_NAME = SmithAndJonesFamily1
4455 PHONE_EXT =
4456 HIRE_DATE = 2015/04/03 00:00:00.0000
4457 DEPT_NO = 600
4458 JOB_CODE = Eng
4459 JOB_GRADE = 4
4460 JOB_COUNTRY = England
4461 SALARY = 41,000.99
4462 FULL_NAME = SmithAndJonesFamily1, John
4463
4464
4465 Insert rows - and then cancel
4466 Cancel Batch - note - next step will fail with a duplicate key if cancel fails
4467
4468 Insert rows - ignore last row
4469 Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4470 Batch Completion Info
4471 Total rows processed = 2
4472 Updated Records = 2
4473 Row 1 State = bcNoMoreErrors Msg =
4474 Row 2 State = bcNoMoreErrors Msg =
4475 Rows after insert
4476 EMP_NO = 150
4477 FIRST_NAME = John
4478 LAST_NAME = Doe
4479 PHONE_EXT =
4480 HIRE_DATE = 2015/04/01 00:00:00.0000
4481 DEPT_NO = 600
4482 JOB_CODE = Eng
4483 JOB_GRADE = 4
4484 JOB_COUNTRY = England
4485 SALARY = 41,000.89
4486 FULL_NAME = Doe, John
4487 EMP_NO = 151
4488 FIRST_NAME = Jane
4489 LAST_NAME = Doe
4490 PHONE_EXT =
4491 HIRE_DATE = 2015/04/02 00:00:00.0000
4492 DEPT_NO = 600
4493 JOB_CODE = Eng
4494 JOB_GRADE = 4
4495 JOB_COUNTRY = England
4496 SALARY = 42,000.89
4497 FULL_NAME = Doe, Jane
4498
4499 Insert with inline blob
4500 Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4501 Batch Completion Info
4502 Total rows processed = 2
4503 Updated Records = 2
4504 Row 1 State = bcNoMoreErrors Msg =
4505 Row 2 State = bcNoMoreErrors Msg =
4506 Rows after insert
4507 JOB_CODE = ABC
4508 JOB_GRADE = 3
4509 JOB_COUNTRY = England
4510 JOB_TITLE = Chief Tester
4511 MIN_SALARY = 21,000.00
4512 MAX_SALARY = 24,000.99
4513 JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4514
4515 The quick brown fox jumped over the lazy dog
4516 LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4517
4518 JOB_CODE = DEF
4519 JOB_GRADE = 3
4520 JOB_COUNTRY = England
4521 JOB_TITLE = Deputy Tester
4522 MIN_SALARY = 21,000.00
4523 MAX_SALARY = 24,000.99
4524 JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4525
4526 The quick brown fox jumped over the running dog
4527 LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4528
4529
4530
4531 Insert with explicit blob
4532 Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4533 Batch Completion Info
4534 Total rows processed = 2
4535 Updated Records = 2
4536 Row 1 State = bcNoMoreErrors Msg =
4537 Row 2 State = bcNoMoreErrors Msg =
4538 Rows after insert
4539 JOB_CODE = ABC
4540 JOB_GRADE = 3
4541 JOB_COUNTRY = England
4542 JOB_TITLE = Chief Tester
4543 MIN_SALARY = 21,000.00
4544 MAX_SALARY = 24,000.99
4545 JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4546
4547 The quick brown fox jumped over the lazy dog
4548 LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4549
4550 JOB_CODE = DEF
4551 JOB_GRADE = 3
4552 JOB_COUNTRY = England
4553 JOB_TITLE = Deputy Tester
4554 MIN_SALARY = 21,000.00
4555 MAX_SALARY = 24,000.99
4556 JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4557
4558 The quick brown fox jumped over the running dog
4559 LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4560
4561
4562 Test Error Handling
4563 Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING
4564 Test Error Handling - Update returning should fail
4565 Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4566 Error handling when Insert rows - duplicate key
4567 Error reported when inserting: Error Processing update/insert batch on row number 2 - violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4568 -Problematic key value is ("EMP_NO" = 150)
4569 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4570 Batch Completion Info
4571 Total rows processed = 2
4572 Updated Records = 1
4573 Row 1 State = bcNoMoreErrors Msg =
4574 Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4575 -Problematic key value is ("EMP_NO" = 150)
4576
4577
4578 ------------------------------------------------------
4579 Running Test 20: Stress Test IBatch interface
4580 FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4581 10000 rows added
4582 20000 rows added
4583 30000 rows added
4584 40000 rows added
4585 50000 rows added
4586 Batch Execute
4587 Intermediate Apply Batch on row 50001
4588 Batch Completion Info
4589 Total rows processed = 50000
4590 Updated Rows = 50000
4591 Row 50000 State = bcNoMoreErrors Msg =
4592 60000 rows added
4593 70000 rows added
4594 80000 rows added
4595 90000 rows added
4596 100000 rows added
4597 Batch Execute
4598 Batch Completion Info
4599 Total rows processed = 50000
4600 Updated Rows = 50000
4601 Row 50000 State = bcNoMoreErrors Msg =
4602 Rows in Dataset = 100000
4603 Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4604 Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4605 Test Completed Successfully
4606
4607
4608 ------------------------------------------------------
4609 Running Test 21: Exercise setting and getting of numeric data types
4610 1234.567 parsed to 1234567 scale = -3
4611 As Float = 1.2345670000000000E+003
4612 -765.4321 parsed to -7654321 scale = -4
4613 As Float = -7.6543209999999999E+002
4614 0.1 parsed to 1 scale = -1
4615 As Float = 1.0000000000000001E-001
4616 0.01 parsed to 1 scale = -2
4617 As Float = 1.0000000000000000E-002
4618 +123 parsed to 123 scale = 0
4619 As Float = 1.2300000000000000E+002
4620 1.23456E308 parsed to 123456 scale = 303
4621 As Float = 1.2345600000000001E+308
4622 -1.2e-02 parsed to -12 scale = -3
4623 As Float = -1.2000000000000000E-002
4624 10. parsed to 10 scale = 0
4625 As Float = 1.0000000000000000E+001
4626 .12 parsed to 12 scale = -2
4627 As Float = 1.2000000000000000E-001
4628 0.12 parsed to 12 scale = -2
4629 As Float = 1.2000000000000000E-001
4630 Parsing of 1.2E1.2 failed
4631 Parsing of 1,000 failed
4632 Parsing of 1e1e1 failed
4633 Parsing of 1.2+3 failed
4634 SQL Params
4635 SQLType =SQL_LONG
4636 sub type = 0
4637 Field Name =
4638 Scale = 0
4639 Charset id = 0
4640 Not Null
4641 Size = 4
4642 Value = 0
4643
4644 SQLType =SQL_LONG
4645 sub type = 0
4646 Field Name =
4647 Scale = 0
4648 Charset id = 0
4649 Nullable
4650 Size = 4
4651
4652 SQLType =SQL_INT64
4653 sub type = 0
4654 Field Name =
4655 Scale = 0
4656 Charset id = 0
4657 Nullable
4658 Size = 8
4659
4660 SQLType =SQL_INT64
4661 sub type = 0
4662 Field Name =
4663 Scale = -4
4664 Charset id = 0
4665 Nullable
4666 Size = 8
4667
4668 SQLType =SQL_DOUBLE
4669 sub type = 0
4670 Field Name =
4671 Scale = 0
4672 Charset id = 0
4673 Nullable
4674 Size = 8
4675
4676 SQLType =SQL_INT64
4677 sub type = 0
4678 Field Name =
4679 Scale = -6
4680 Charset id = 0
4681 Nullable
4682 Size = 8
4683
4684 Expected Error - SQLCODE: -303
4685 Engine Code: 335544569 Incompatible column/host variable data type
4686 Dynamic SQL Error
4687 -SQL error code = -303
4688 -conversion error from string "1,000"
4689 Expected Error - SQLCODE: -303
4690 Engine Code: 335544569 Incompatible column/host variable data type
4691 Dynamic SQL Error
4692 -SQL error code = -303
4693 -conversion error from string "10.0.0"
4694 ROWID = 1
4695 ITYPE = 101
4696 I64TYPE = 9223372036854775807
4697 CURRTYPE = 10,000.12340000
4698 DTYPE = 9,999.12345678
4699 FIXEDPOINT = 1,234,567,890.12345700
4700 ROWID = 2
4701 ITYPE = -32457
4702 I64TYPE = -9223372036854775808
4703 CURRTYPE = 1,000,001.12000000
4704 DTYPE = 1.7E308
4705 FIXEDPOINT = -1,234,567,890.12345700
4706 ROWID = 3
4707 ITYPE = 0
4708 I64TYPE = 0
4709 CURRTYPE = .00000000
4710 DTYPE = .00000000
4711 FIXEDPOINT = .00000000
4712 ROWID = 4
4713 ITYPE = 1
4714 I64TYPE = 10
4715 CURRTYPE = .02300000
4716 DTYPE = .00110000
4717 FIXEDPOINT = 233.45600000
4718
4719
4720
4721 ------------------------------------------------------
4722 Running Test 22: Journalling
4723 Start Journaling. Session ID = 1
4724 1234.567 parsed to 1234567 scale = -3
4725 As Float = 1.2345670000000000E+003
4726 -765.4321 parsed to -7654321 scale = -4
4727 As Float = -7.6543209999999999E+002
4728 0.1 parsed to 1 scale = -1
4729 As Float = 1.0000000000000001E-001
4730 0.01 parsed to 1 scale = -2
4731 As Float = 1.0000000000000000E-002
4732 +123 parsed to 123 scale = 0
4733 As Float = 1.2300000000000000E+002
4734 1.23456E308 parsed to 123456 scale = 303
4735 As Float = 1.2345600000000001E+308
4736 -1.2e-02 parsed to -12 scale = -3
4737 As Float = -1.2000000000000000E-002
4738 10. parsed to 10 scale = 0
4739 As Float = 1.0000000000000000E+001
4740 .12 parsed to 12 scale = -2
4741 As Float = 1.2000000000000000E-001
4742 0.12 parsed to 12 scale = -2
4743 As Float = 1.2000000000000000E-001
4744 Parsing of 1.2E1.2 failed
4745 Parsing of 1,000 failed
4746 Parsing of 1e1e1 failed
4747 Parsing of 1.2+3 failed
4748 SQL Params
4749 SQLType =SQL_LONG
4750 sub type = 0
4751 Field Name =
4752 Scale = 0
4753 Charset id = 0
4754 Not Null
4755 Size = 4
4756 Value = 0
4757
4758 SQLType =SQL_LONG
4759 sub type = 0
4760 Field Name =
4761 Scale = 0
4762 Charset id = 0
4763 Nullable
4764 Size = 4
4765
4766 SQLType =SQL_INT64
4767 sub type = 0
4768 Field Name =
4769 Scale = 0
4770 Charset id = 0
4771 Nullable
4772 Size = 8
4773
4774 SQLType =SQL_INT64
4775 sub type = 0
4776 Field Name =
4777 Scale = -4
4778 Charset id = 0
4779 Nullable
4780 Size = 8
4781
4782 SQLType =SQL_DOUBLE
4783 sub type = 0
4784 Field Name =
4785 Scale = 0
4786 Charset id = 0
4787 Nullable
4788 Size = 8
4789
4790 SQLType =SQL_INT64
4791 sub type = 0
4792 Field Name =
4793 Scale = -6
4794 Charset id = 0
4795 Nullable
4796 Size = 8
4797
4798
4799 Text Tests
4800 SQL Params
4801 SQLType =SQL_LONG
4802 sub type = 0
4803 Field Name =
4804 Scale = 0
4805 Charset id = 0
4806 Not Null
4807 Size = 4
4808 Value = 0
4809
4810 SQLType =SQL_VARYING
4811 sub type = 0
4812 Field Name =
4813 Scale = 0
4814 Charset id = 4
4815 Nullable
4816 Size = 1024
4817
4818 SQLType =SQL_BLOB
4819 sub type = 1
4820 Field Name =
4821 Scale = 0
4822 Charset id = 4
4823 Nullable
4824 Size = 8
4825
4826
4827 Binary Blob Tests
4828
4829 Array Test
4830 SQL Params
4831 SQLType =SQL_LONG
4832 sub type = 0
4833 Field Name =
4834 Scale = 0
4835 Charset id = 0
4836 Not Null
4837 Size = 4
4838 Value = 0
4839
4840 SQLType =SQL_ARRAY
4841 sub type = 0
4842 Field Name =
4843 Scale = 0
4844 Charset id = 0
4845 Nullable
4846 Size = 8
4847
4848 ROWID = 1
4849 ITYPE = 101
4850 I64TYPE = 9223372036854775807
4851 CURRTYPE = 10,000.12340000
4852 DTYPE = 9,999.12345678
4853 FIXEDPOINT = 1,234,567,890.12345700
4854 STR = NULL
4855 TEXTBLOB = NULL
4856 OTHERBLOB = NULL
4857 MYARRAY = NULL
4858 ROWID = 2
4859 ITYPE = -32457
4860 I64TYPE = -9223372036854775808
4861 CURRTYPE = 1,000,001.12000000
4862 DTYPE = 1.7E308
4863 FIXEDPOINT = -1,234,567,890.12345700
4864 STR = NULL
4865 TEXTBLOB = NULL
4866 OTHERBLOB = NULL
4867 MYARRAY = NULL
4868 ROWID = 4
4869 ITYPE = 1
4870 I64TYPE = 10
4871 CURRTYPE = .02300000
4872 DTYPE = .00110000
4873 FIXEDPOINT = 233.45600000
4874 STR = NULL
4875 TEXTBLOB = NULL
4876 OTHERBLOB = NULL
4877 MYARRAY = NULL
4878
4879 Journal Table
4880 IBX$SESSIONID = 1
4881 IBX$TRANSACTIONID = 9
4882 IBX$OLDTRANSACTIONID = NULL
4883 IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4884 IBX$CREATED = 2021/12/07 09:50:08.4430
4885 IBX$SESSIONID = 1
4886 IBX$TRANSACTIONID = 11
4887 IBX$OLDTRANSACTIONID = 10
4888 IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4889 IBX$CREATED = 2021/12/07 09:50:08.7940
4890
4891 Journal Entries
4892 Journal Entry = jeTransStart(Transaction Start)
4893 Timestamp = 2021/12/07 09:50:08.4700
4894 Session ID = 1
4895 Transaction ID = 9
4896 Transaction Name = "Transaction_29_1"
4897 TPB: Item Count = 3
4898 isc_tpb_write
4899 isc_tpb_nowait
4900 isc_tpb_concurrency
4901
4902 Default Completion = TACommit
4903
4904 Journal Entry = jeQuery(Query)
4905 Timestamp = 2021/12/07 09:50:08.5300
4906 Session ID = 1
4907 Transaction ID = 9
4908 Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
4909
4910 Journal Entry = jeQuery(Query)
4911 Timestamp = 2021/12/07 09:50:08.5510
4912 Session ID = 1
4913 Transaction ID = 9
4914 Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
4915
4916 Journal Entry = jeTransCommitRet(Commit Retaining)
4917 Timestamp = 2021/12/07 09:50:08.6650
4918 Session ID = 1
4919 Transaction ID = 10
4920 Old TransactionID = 9
4921
4922 Journal Entry = jeQuery(Query)
4923 Timestamp = 2021/12/07 09:50:08.6870
4924 Session ID = 1
4925 Transaction ID = 10
4926 Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
4927
4928 Journal Entry = jeTransRollbackRet(Rollback Retaining)
4929 Timestamp = 2021/12/07 09:50:08.7900
4930 Session ID = 1
4931 Transaction ID = 11
4932 Old TransactionID = 10
4933
4934 Journal Entry = jeQuery(Query)
4935 Timestamp = 2021/12/07 09:50:08.8140
4936 Session ID = 1
4937 Transaction ID = 11
4938 Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
4939
4940 Journal Entry = jeTransStart(Transaction Start)
4941 Timestamp = 2021/12/07 09:50:08.8260
4942 Session ID = 1
4943 Transaction ID = 12
4944 Transaction Name = "Transaction_29_2"
4945 TPB: Item Count = 3
4946 isc_tpb_write
4947 isc_tpb_nowait
4948 isc_tpb_concurrency
4949
4950 Default Completion = TARollback
4951
4952 Journal Entry = jeTransCommit(Commit)
4953 Timestamp = 2021/12/07 09:50:08.8860
4954 Session ID = 1
4955 Transaction ID = 11
4956
4957 Journal Entry = jeQuery(Query)
4958 Timestamp = 2021/12/07 09:50:08.9660
4959 Session ID = 1
4960 Transaction ID = 12
4961 Query = Insert into TestData(RowID, Str, TextBlob) Values(5,'It''s the quick brown fox jumps over the lazy dog','To be or not to be-that is the question:
4962 Whether ''tis nobler in the mind to suffer
4963 The slings and arrows of outrageous fortune,
4964 Or to take arms against a sea of troubles,
4965 And, by opposing, end them. To die, to sleep-
4966 No more-and by a sleep to say we end
4967 The heartache and the thousand natural shocks
4968 That flesh is heir to-''tis a consummation
4969 Devoutly to be wished. To die, to sleep-
4970 To sleep, perchance to dream. Aye, there''s the rub,
4971 For in that sleep of death what dreams may come,
4972 When we have shuffled off this mortal coil,
4973 Must give us pause. There''s the respect
4974 That makes calamity of so long life.
4975 For who would bear the whips and scorns of time,
4976 Th'' oppressor''s wrong, the proud man''s contumely,
4977 The pangs of despised love, the law’s delay,
4978 The insolence of office, and the spurns
4979 That patient merit of the unworthy takes,
4980 When he himself might his quietus make
4981 With a bare bodkin? Who would fardels bear,
4982 To grunt and sweat under a weary life,
4983 But that the dread of something after death,
4984 The undiscovered country from whose bourn
4985 No traveler returns, puzzles the will
4986 And makes us rather bear those ills we have
4987 Than fly to others that we know not of?
4988 Thus conscience does make cowards of us all,
4989 And thus the native hue of resolution
4990 Is sicklied o''er with the pale cast of thought,
4991 And enterprises of great pitch and moment,
4992 With this regard their currents turn awry,
4993 And lose the name of action.-Soft you now,
4994 The fair Ophelia.-Nymph, in thy orisons
4995 Be all my sins remembered
4996 ')
4997
4998 Journal Entry = jeQuery(Query)
4999 Timestamp = 2021/12/07 09:50:09.0130
5000 Session ID = 1
5001 Transaction ID = 12
5002 Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
5003 FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
5004 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
5005 01000000010000001A01050001000000DA000000
5006 </blob>
5007 )
5008
5009 Journal Entry = jeQuery(Query)
5010 Timestamp = 2021/12/07 09:50:09.0380
5011 Session ID = 1
5012 Transaction ID = 12
5013 Query = Insert into TestData(RowID,MyArray) Values (7,<array dim = "1" sqltype = "496" length = "4" relation_name = "TESTDATA" column_name = "MYARRAY" scale = "0" bounds="0:16">
5014 <elt ix="0">100</elt>
5015 <elt ix="1">99</elt>
5016 <elt ix="2">98</elt>
5017 <elt ix="3">97</elt>
5018 <elt ix="4">96</elt>
5019 <elt ix="5">95</elt>
5020 <elt ix="6">94</elt>
5021 <elt ix="7">93</elt>
5022 <elt ix="8">92</elt>
5023 <elt ix="9">91</elt>
5024 <elt ix="10">90</elt>
5025 <elt ix="11">89</elt>
5026 <elt ix="12">88</elt>
5027 <elt ix="13">87</elt>
5028 <elt ix="14">86</elt>
5029 <elt ix="15">85</elt>
5030 <elt ix="16">84</elt>
5031 </array>
5032 )
5033
5034 Journal Entry = jeTransRollback(Rollback)
5035 Timestamp = 2021/12/07 09:50:09.1560
5036 Session ID = 1
5037 Transaction ID = 12
5038
5039
5040
5041 ------------------------------------------------------
5042 Test Suite Ends