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