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