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