ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/testsuite/FB4reference.log
Revision: 421
Committed: Sat Oct 21 14:22:28 2023 UTC (13 months ago) by tony
File size: 132831 byte(s)
Log Message: 
Release 2.6.3 Merged

File Contents

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