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