ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/testsuite/FB2reference.log
Revision: 333
Committed: Fri Feb 26 16:34:26 2021 UTC (3 years, 1 month ago) by tony
File size: 73082 byte(s)
Log Message: 
Add missing files

File Contents

# Content
1 Firebird API Test Suite
2 Copyright MWA Software 2016
3
4 Starting Tests
5 Client API Version = 2.5
6 Running Test 1: Create and Drop a Database
7 Creating a Database with empty parameters
8 Create Database fails (as expected):
9 unavailable database
10 Creating a Database using an SQL Statement
11 Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
12 SQL Dialect = 3
13 DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
14 DB Charset ID = 0
15 DB SQL Dialect = 3
16 DB Remote Protocol = TCPv4
17 DB ODS Major Version = 11
18 DB ODS Minor Version = 2
19 User Authentication Method = Legacy_Auth
20 Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
21 DB Client Implementation Version = 2.5
22 DPB
23 Count = 3
24 28 = SYSDBA
25 29 = masterkey
26 65 = 3
27
28 Dropping Database
29 Creating a Database with a DPD
30 DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
31 DB Charset ID = 4
32 DB SQL Dialect = 3
33 DB Remote Protocol = TCPv4
34 DB ODS Major Version = 11
35 DB ODS Minor Version = 2
36 User Authentication Method = Legacy_Auth
37 Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
38 DB Client Implementation Version = 2.5
39 Dropping Database
40 DPB
41 Count = 4
42 28 = SYSDBA
43 29 = masterkey
44 48 = UTF8
45 65 = 3
46
47 Creating a Database with a DPD
48 Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
49 ODS major = 11
50 ODS minor = 2
51 DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
52 DB Charset ID = 4
53 DB SQL Dialect = 3
54 DB Remote Protocol = TCPv4
55 DB ODS Major Version = 11
56 DB ODS Minor Version = 2
57 User Authentication Method = Legacy_Auth
58 Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
59 DB Client Implementation Version = 2.5
60 RDB$DESCRIPTION =
61 RDB$RELATION_ID = 128
62 RDB$SECURITY_CLASS =
63 RDB$CHARACTER_SET_NAME = UTF8
64 Dropping Database
65
66
67 Running Test 2: Open the employee database and run a query
68 Opening localhost:employee
69 Database Open, SQL Dialect = 3
70 Metadata
71 SQLType =SQL_SHORT
72 sub type = 0
73 Table = EMPLOYEE
74 Owner = SYSDBA
75 Column Name = EMP_NO
76 Alias Name = EMP_NO
77 Field Name = EMP_NO
78 Scale = 0
79 Charset id = 0
80 Not Null
81 Size = 2
82
83 SQLType =SQL_VARYING
84 sub type = 0
85 Table = EMPLOYEE
86 Owner = SYSDBA
87 Column Name = FIRST_NAME
88 Alias Name = FIRST_NAME
89 Field Name = FIRST_NAME
90 Scale = 0
91 Charset id = 0
92 Not Null
93 Size = 15
94
95 SQLType =SQL_VARYING
96 sub type = 0
97 Table = EMPLOYEE
98 Owner = SYSDBA
99 Column Name = LAST_NAME
100 Alias Name = LAST_NAME
101 Field Name = LAST_NAME
102 Scale = 0
103 Charset id = 0
104 Not Null
105 Size = 20
106
107 SQLType =SQL_VARYING
108 sub type = 0
109 Table = EMPLOYEE
110 Owner = SYSDBA
111 Column Name = PHONE_EXT
112 Alias Name = PHONE_EXT
113 Field Name = PHONE_EXT
114 Scale = 0
115 Charset id = 0
116 Nullable
117 Size = 4
118
119 SQLType =SQL_TIMESTAMP
120 sub type = 0
121 Table = EMPLOYEE
122 Owner = SYSDBA
123 Column Name = HIRE_DATE
124 Alias Name = HIRE_DATE
125 Field Name = HIRE_DATE
126 Scale = 0
127 Charset id = 0
128 Not Null
129 Size = 8
130
131 SQLType =SQL_TEXT
132 sub type = 0
133 Table = EMPLOYEE
134 Owner = SYSDBA
135 Column Name = DEPT_NO
136 Alias Name = DEPT_NO
137 Field Name = DEPT_NO
138 Scale = 0
139 Charset id = 0
140 Not Null
141 Size = 3
142
143 SQLType =SQL_VARYING
144 sub type = 0
145 Table = EMPLOYEE
146 Owner = SYSDBA
147 Column Name = JOB_CODE
148 Alias Name = JOB_CODE
149 Field Name = JOB_CODE
150 Scale = 0
151 Charset id = 0
152 Not Null
153 Size = 5
154
155 SQLType =SQL_SHORT
156 sub type = 0
157 Table = EMPLOYEE
158 Owner = SYSDBA
159 Column Name = JOB_GRADE
160 Alias Name = JOB_GRADE
161 Field Name = JOB_GRADE
162 Scale = 0
163 Charset id = 0
164 Not Null
165 Size = 2
166
167 SQLType =SQL_VARYING
168 sub type = 0
169 Table = EMPLOYEE
170 Owner = SYSDBA
171 Column Name = JOB_COUNTRY
172 Alias Name = JOB_COUNTRY
173 Field Name = JOB_COUNTRY
174 Scale = 0
175 Charset id = 0
176 Not Null
177 Size = 15
178
179 SQLType =SQL_INT64
180 sub type = 0
181 Table = EMPLOYEE
182 Owner = SYSDBA
183 Column Name = SALARY
184 Alias Name = SALARY
185 Field Name = SALARY
186 Scale = -2
187 Charset id = 0
188 Not Null
189 Size = 8
190
191 SQLType =SQL_VARYING
192 sub type = 0
193 Table = EMPLOYEE
194 Owner = SYSDBA
195 Column Name = FULL_NAME
196 Alias Name = FULL_NAME
197 Field Name = FULL_NAME
198 Scale = 0
199 Charset id = 0
200 Nullable
201 Size = 37
202
203 Plan =
204 PLAN (EMPLOYEE NATURAL)
205 -- SQL style inline comment
206 /* this is a comment */ Select First 3 * from EMPLOYEE
207
208 EMP_NO = 2
209 FIRST_NAME = Robert
210 LAST_NAME = Nelson
211 PHONE_EXT = 250
212 HIRE_DATE = 28/12/1988 00:00:00.000
213 DEPT_NO = 600
214 JOB_CODE = VP
215 JOB_GRADE = 2
216 JOB_COUNTRY = USA
217 SALARY = 105,900.00
218 FULL_NAME = Nelson, Robert
219 EMP_NO = 4
220 FIRST_NAME = Bruce
221 LAST_NAME = Young
222 PHONE_EXT = 233
223 HIRE_DATE = 28/12/1988 00:00:00.000
224 DEPT_NO = 621
225 JOB_CODE = Eng
226 JOB_GRADE = 2
227 JOB_COUNTRY = USA
228 SALARY = 97,500.00
229 FULL_NAME = Young, Bruce
230 EMP_NO = 5
231 FIRST_NAME = Kim
232 LAST_NAME = Lambert
233 PHONE_EXT = 22
234 HIRE_DATE = 6/2/1989 00:00:00.000
235 DEPT_NO = 130
236 JOB_CODE = Eng
237 JOB_GRADE = 2
238 JOB_COUNTRY = USA
239 SALARY = 102,750.00
240 FULL_NAME = Lambert, Kim
241
242 Select * from EMPLOYEE Where EMP_NO = ?
243 SQL Params
244 SQLType =SQL_SHORT
245 sub type = 0
246 Field Name =
247 Scale = 0
248 Charset id = 0
249 Not Null
250 Size = 2
251
252 EMP_NO = 8
253 FIRST_NAME = Leslie
254 LAST_NAME = Johnson
255 PHONE_EXT = 410
256 HIRE_DATE = 5/4/1989 00:00:00.000
257 DEPT_NO = 180
258 JOB_CODE = Mktg
259 JOB_GRADE = 3
260 JOB_COUNTRY = USA
261 SALARY = 64,635.00
262 FULL_NAME = Johnson, Leslie
263
264 With param names
265 Select * from EMPLOYEE Where EMP_NO = :EMP_NO
266 SQL Params
267 SQLType =SQL_SHORT
268 sub type = 0
269 Field Name = EMP_NO
270 Scale = 0
271 Charset id = 0
272 Not Null
273 Size = 2
274
275 EMP_NO = 8
276 FIRST_NAME = Leslie
277 LAST_NAME = Johnson
278 PHONE_EXT = 410
279 HIRE_DATE = 5/4/1989 00:00:00.000
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
288
289 Running Test 3: ad hoc queries
290 Opening localhost:employee
291 Database Open
292 Employee Count = 42
293 Employee Count = 41
294 Employee Count = 42
295 Employee Count = 41
296 Employee Count = 42
297 Constrained Employee Count = 3
298 "Johnson" Employee Count = 2
299 "Yanowski" Employee Count = 1
300
301
302 Running Test 4: Update, Insert and Delete Queries
303 Opening localhost:employee
304 Database Open
305 Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
306 Firebird/linux AMD64 (remote server), version "LI-V2.5.9.27139 Firebird 2.5/tcp (zeus)/P12"
307 Firebird/linux AMD64 (remote interface), version "LI-V2.5.9.27139 Firebird 2.5/tcp (zeus)/P12"
308 on disk structure version 11.2
309 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
310 EMP_NO = 8
311 FIRST_NAME = Leslie
312 LAST_NAME = Johnson
313 PHONE_EXT = 410
314 HIRE_DATE = 5/4/1989 00:00:00.000
315 DEPT_NO = 180
316 JOB_CODE = Mktg
317 JOB_GRADE = 3
318 JOB_COUNTRY = USA
319 SALARY = 64,635.00
320 FULL_NAME = Johnson, Leslie
321
322 Current memory = 948664
323 Delta memory = 1400
324 Max memory = 992600
325 Elapsed time= 0.002 sec
326 Cpu = 0.000 sec
327 Buffers = 75
328 Reads = 0
329 Writes = 0
330 Fetches = 4
331 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
332 Relation Name = EMPLOYEE
333 Metadata
334 SQLType =SQL_SHORT
335 sub type = 0
336 Table = EMPLOYEE
337 Owner = SYSDBA
338 Column Name = EMP_NO
339 Alias Name = EMP_NO
340 Field Name = EMP_NO
341 Scale = 0
342 Charset id = 0
343 Not Null
344 Size = 2
345
346 SQLType =SQL_VARYING
347 sub type = 0
348 Table = EMPLOYEE
349 Owner = SYSDBA
350 Column Name = FIRST_NAME
351 Alias Name = FIRST_NAME
352 Field Name = FIRST_NAME
353 Scale = 0
354 Charset id = 0
355 Not Null
356 Size = 15
357
358 SQLType =SQL_VARYING
359 sub type = 0
360 Table = EMPLOYEE
361 Owner = SYSDBA
362 Column Name = LAST_NAME
363 Alias Name = LAST_NAME
364 Field Name = LAST_NAME
365 Scale = 0
366 Charset id = 0
367 Not Null
368 Size = 20
369
370 SQLType =SQL_VARYING
371 sub type = 0
372 Table = EMPLOYEE
373 Owner = SYSDBA
374 Column Name = PHONE_EXT
375 Alias Name = PHONE_EXT
376 Field Name = PHONE_EXT
377 Scale = 0
378 Charset id = 0
379 Nullable
380 Size = 4
381
382 SQLType =SQL_TIMESTAMP
383 sub type = 0
384 Table = EMPLOYEE
385 Owner = SYSDBA
386 Column Name = HIRE_DATE
387 Alias Name = HIRE_DATE
388 Field Name = HIRE_DATE
389 Scale = 0
390 Charset id = 0
391 Not Null
392 Size = 8
393
394 SQLType =SQL_TEXT
395 sub type = 0
396 Table = EMPLOYEE
397 Owner = SYSDBA
398 Column Name = DEPT_NO
399 Alias Name = DEPT_NO
400 Field Name = DEPT_NO
401 Scale = 0
402 Charset id = 0
403 Not Null
404 Size = 3
405
406 SQLType =SQL_VARYING
407 sub type = 0
408 Table = EMPLOYEE
409 Owner = SYSDBA
410 Column Name = JOB_CODE
411 Alias Name = JOB_CODE
412 Field Name = JOB_CODE
413 Scale = 0
414 Charset id = 0
415 Not Null
416 Size = 5
417
418 SQLType =SQL_SHORT
419 sub type = 0
420 Table = EMPLOYEE
421 Owner = SYSDBA
422 Column Name = JOB_GRADE
423 Alias Name = JOB_GRADE
424 Field Name = JOB_GRADE
425 Scale = 0
426 Charset id = 0
427 Not Null
428 Size = 2
429
430 SQLType =SQL_VARYING
431 sub type = 0
432 Table = EMPLOYEE
433 Owner = SYSDBA
434 Column Name = JOB_COUNTRY
435 Alias Name = JOB_COUNTRY
436 Field Name = JOB_COUNTRY
437 Scale = 0
438 Charset id = 0
439 Not Null
440 Size = 15
441
442 SQLType =SQL_INT64
443 sub type = 0
444 Table = EMPLOYEE
445 Owner = SYSDBA
446 Column Name = SALARY
447 Alias Name = SALARY
448 Field Name = SALARY
449 Scale = -2
450 Charset id = 0
451 Not Null
452 Size = 8
453
454 SQLType =SQL_VARYING
455 sub type = 0
456 Table = EMPLOYEE
457 Owner = SYSDBA
458 Column Name = FULL_NAME
459 Alias Name = FULL_NAME
460 Field Name = FULL_NAME
461 Scale = 0
462 Charset id = 0
463 Nullable
464 Size = 37
465
466 EMP_NO = 150
467 FIRST_NAME = John
468 LAST_NAME = Doe
469 PHONE_EXT =
470 HIRE_DATE = 1/4/2015 00:00:00.000
471 DEPT_NO = 600
472 JOB_CODE = Eng
473 JOB_GRADE = 4
474 JOB_COUNTRY = England
475 SALARY = 41,000.89
476 FULL_NAME = Doe, John
477
478 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
479 EMP_NO = 151
480 FIRST_NAME = Major
481 LAST_NAME = Major
482 PHONE_EXT =
483 HIRE_DATE = 1/4/2015 00:00:00.000
484 DEPT_NO = 600
485 JOB_CODE = Eng
486 JOB_GRADE = 4
487 JOB_COUNTRY = England
488 SALARY = 40,000.59
489 FULL_NAME = Major, Major
490
491 Now Delete the rows
492 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
493 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
494 Inserting
495 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
496 EMP_NO = 150
497 FIRST_NAME = Jane
498 LAST_NAME = Doe
499 PHONE_EXT = NULL
500 HIRE_DATE = 1/4/2015 00:00:00.000
501 DEPT_NO = 600
502 JOB_CODE = Eng
503 JOB_GRADE = 4
504 JOB_COUNTRY = England
505 SALARY = 41,000.89
506 FULL_NAME = Doe, Jane
507
508 Employee Count = 43
509 Updating
510 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 0
511 Prepare Query again
512
513 EMP_NO = 150
514 FIRST_NAME = Jayne's
515 LAST_NAME = Doe
516 PHONE_EXT = NULL
517 HIRE_DATE = 1/4/2015 00:00:00.000
518 DEPT_NO = 600
519 JOB_CODE = Eng
520 JOB_GRADE = 4
521 JOB_COUNTRY = England
522 SALARY = 41,000.89
523 FULL_NAME = Doe, Jayne's
524
525 Prepare Query again with a different transaction
526
527 EMP_NO = 8
528 FIRST_NAME = Leslie
529 LAST_NAME = Johnson
530 PHONE_EXT = 410
531 HIRE_DATE = 5/4/1989 00:00:00.000
532 DEPT_NO = 180
533 JOB_CODE = Mktg
534 JOB_GRADE = 3
535 JOB_COUNTRY = USA
536 SALARY = 64,635.00
537 FULL_NAME = Johnson, Leslie
538
539 Open Cursor with a different transaction
540
541 EMP_NO = 8
542 FIRST_NAME = Leslie
543 LAST_NAME = Johnson
544 PHONE_EXT = 410
545 HIRE_DATE = 5/4/1989 00:00:00.000
546 DEPT_NO = 180
547 JOB_CODE = Mktg
548 JOB_GRADE = 3
549 JOB_COUNTRY = USA
550 SALARY = 64,635.00
551 FULL_NAME = Johnson, Leslie
552 Same Statement - updated params
553 EMP_NO = 9
554 FIRST_NAME = Phil
555 LAST_NAME = Forest
556 PHONE_EXT = 229
557 HIRE_DATE = 17/4/1989 00:00:00.000
558 DEPT_NO = 622
559 JOB_CODE = Mngr
560 JOB_GRADE = 3
561 JOB_COUNTRY = USA
562 SALARY = 75,060.00
563 FULL_NAME = Forest, Phil
564
565 Test using Execute Block
566 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
567 EMP_NO = 8
568 FIRST_NAME = Leslie
569 LAST_NAME = Johnson
570 PHONE_EXT = 410
571 HIRE_DATE = 31/1/2015 00:00:00.000
572 DEPT_NO = 180
573 JOB_CODE = Mktg
574 JOB_GRADE = 3
575 JOB_COUNTRY = USA
576 SALARY = 64,635.00
577 FULL_NAME = Johnson, Leslie
578
579
580
581 Running Test 5: Update Returning and Activity Check
582 Opening localhost:employee
583 Database Open
584 Database Closed
585 Database Open
586 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
587 Last Name = Johnson
588 EMP_NO = 8
589 FIRST_NAME = Leslie
590 LAST_NAME = Johnson
591 PHONE_EXT = 410
592 HIRE_DATE = 31/1/2016 00:00:00.000
593 DEPT_NO = 180
594 JOB_CODE = Mktg
595 JOB_GRADE = 3
596 JOB_COUNTRY = USA
597 SALARY = 64,635.00
598 FULL_NAME = Johnson, Leslie
599
600 Inserting
601 Full Name = Doe, John
602 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
603 Database Activity = TRUE
604 Transaction Activity = TRUE
605 Database Activity = FALSE
606 Transaction Activity = FALSE
607 Employee Count = 43
608 Database Activity = TRUE
609 Transaction Activity = TRUE
610 Transaction Active
611 Transaction inactive
612
613
614 Running Test 6: Blob Handling
615 Metadata
616 SQLType =SQL_TEXT
617 sub type = 0
618 Table = RDB$CHARACTER_SETS
619 Owner = SYSDBA
620 Column Name = RDB$CHARACTER_SET_NAME
621 Alias Name = RDB$CHARACTER_SET_NAME
622 Field Name = RDB$CHARACTER_SET_NAME
623 Scale = 0
624 Charset id = 4
625 Nullable
626 Size = 124
627
628 SQLType =SQL_SHORT
629 sub type = 0
630 Table = RDB$CHARACTER_SETS
631 Owner = SYSDBA
632 Column Name = RDB$CHARACTER_SET_ID
633 Alias Name = RDB$CHARACTER_SET_ID
634 Field Name = RDB$CHARACTER_SET_ID
635 Scale = 0
636 Charset id = 0
637 Nullable
638 Size = 2
639
640 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31)
641 RDB$CHARACTER_SET_ID = 0
642 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
643 RDB$CHARACTER_SET_ID = 1
644 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31)
645 RDB$CHARACTER_SET_ID = 2
646 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
647 RDB$CHARACTER_SET_ID = 3
648 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
649 RDB$CHARACTER_SET_ID = 4
650 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
651 RDB$CHARACTER_SET_ID = 5
652 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
653 RDB$CHARACTER_SET_ID = 6
654 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
655 RDB$CHARACTER_SET_ID = 9
656 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
657 RDB$CHARACTER_SET_ID = 10
658 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
659 RDB$CHARACTER_SET_ID = 11
660 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
661 RDB$CHARACTER_SET_ID = 12
662 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
663 RDB$CHARACTER_SET_ID = 13
664 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
665 RDB$CHARACTER_SET_ID = 14
666 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
667 RDB$CHARACTER_SET_ID = 15
668 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
669 RDB$CHARACTER_SET_ID = 16
670 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
671 RDB$CHARACTER_SET_ID = 17
672 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
673 RDB$CHARACTER_SET_ID = 18
674 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31)
675 RDB$CHARACTER_SET_ID = 19
676 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
677 RDB$CHARACTER_SET_ID = 21
678 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
679 RDB$CHARACTER_SET_ID = 22
680 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
681 RDB$CHARACTER_SET_ID = 23
682 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
683 RDB$CHARACTER_SET_ID = 34
684 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
685 RDB$CHARACTER_SET_ID = 35
686 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
687 RDB$CHARACTER_SET_ID = 36
688 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
689 RDB$CHARACTER_SET_ID = 37
690 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
691 RDB$CHARACTER_SET_ID = 38
692 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
693 RDB$CHARACTER_SET_ID = 39
694 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
695 RDB$CHARACTER_SET_ID = 40
696 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
697 RDB$CHARACTER_SET_ID = 44
698 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
699 RDB$CHARACTER_SET_ID = 45
700 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
701 RDB$CHARACTER_SET_ID = 46
702 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
703 RDB$CHARACTER_SET_ID = 47
704 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
705 RDB$CHARACTER_SET_ID = 48
706 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
707 RDB$CHARACTER_SET_ID = 49
708 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31)
709 RDB$CHARACTER_SET_ID = 50
710 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
711 RDB$CHARACTER_SET_ID = 51
712 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
713 RDB$CHARACTER_SET_ID = 52
714 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
715 RDB$CHARACTER_SET_ID = 53
716 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
717 RDB$CHARACTER_SET_ID = 54
718 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
719 RDB$CHARACTER_SET_ID = 55
720 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
721 RDB$CHARACTER_SET_ID = 56
722 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
723 RDB$CHARACTER_SET_ID = 57
724 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
725 RDB$CHARACTER_SET_ID = 58
726 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
727 RDB$CHARACTER_SET_ID = 59
728 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
729 RDB$CHARACTER_SET_ID = 60
730 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31)
731 RDB$CHARACTER_SET_ID = 63
732 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31)
733 RDB$CHARACTER_SET_ID = 64
734 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
735 RDB$CHARACTER_SET_ID = 65
736 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
737 RDB$CHARACTER_SET_ID = 66
738 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31)
739 RDB$CHARACTER_SET_ID = 67
740 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31)
741 RDB$CHARACTER_SET_ID = 68
742 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
743 RDB$CHARACTER_SET_ID = 69
744
745 Metadata
746 SQLType =SQL_LONG
747 sub type = 0
748 Table = TESTDATA
749 Owner = SYSDBA
750 Column Name = ROWID
751 Alias Name = ROWID
752 Field Name = ROWID
753 Scale = 0
754 Charset id = 0
755 Not Null
756 Size = 4
757
758 SQLType =SQL_LONG
759 sub type = 0
760 Table = TESTDATA
761 Owner = SYSDBA
762 Column Name = FIXEDPOINT
763 Alias Name = FIXEDPOINT
764 Field Name = FIXEDPOINT
765 Scale = -2
766 Charset id = 0
767 Nullable
768 Size = 4
769
770 SQLType =SQL_DOUBLE
771 sub type = 0
772 Table = TESTDATA
773 Owner = SYSDBA
774 Column Name = FLOATINGPOINT
775 Alias Name = FLOATINGPOINT
776 Field Name = FLOATINGPOINT
777 Scale = 0
778 Charset id = 0
779 Nullable
780 Size = 8
781
782 SQLType =SQL_VARYING
783 sub type = 0
784 Table = TESTDATA
785 Owner = SYSDBA
786 Column Name = TITLE
787 Alias Name = TITLE
788 Field Name = TITLE
789 Scale = 0
790 Charset id = 4
791 Nullable
792 Size = 128
793
794 SQLType =SQL_BLOB
795 sub type = 1
796 Table = TESTDATA
797 Owner = SYSDBA
798 Column Name = BLOBDATA
799 Alias Name = BLOBDATA
800 Field Name = BLOBDATA
801 Scale = 0
802 Charset id = 4
803 Nullable
804 Size = 8
805
806 Blob Meta Data
807 SQL SubType =1
808 Table = TESTDATA
809 Column = BLOBDATA
810 CharSetID = 4
811 Segment Size = 80
812
813
814 SQL Params
815 SQLType =SQL_LONG
816 sub type = 0
817 Field Name = ROWID
818 Scale = 0
819 Charset id = 0
820 Not Null
821 Size = 4
822
823 SQLType =SQL_VARYING
824 sub type = 0
825 Field Name = TITLE
826 Scale = 0
827 Charset id = 4
828 Nullable
829 Size = 128
830
831 SQLType =SQL_LONG
832 sub type = 0
833 Field Name = FP
834 Scale = -2
835 Charset id = 0
836 Nullable
837 Size = 4
838
839 SQLType =SQL_DOUBLE
840 sub type = 0
841 Field Name = DP
842 Scale = 0
843 Charset id = 0
844 Nullable
845 Size = 8
846
847 ROWID = 1
848 FIXEDPOINT = 20.28
849 FLOATINGPOINT = 3.14
850 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
851 BLOBDATA = NULL
852
853 SQL Params
854 SQLType =SQL_BLOB
855 sub type = 1
856 Field Name =
857 Scale = 0
858 Charset id = 4
859 Nullable
860 Size = 8
861
862 SQLType =SQL_LONG
863 sub type = 0
864 Field Name =
865 Scale = 0
866 Charset id = 0
867 Not Null
868 Size = 4
869
870 ROWID = 1
871 FIXEDPOINT = 20.28
872 FLOATINGPOINT = 3.14
873 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
874 BLOBDATA (Charset Id = 4 Codepage = 65001)
875
876 To be or not to be-that is the question:
877 Whether 'tis nobler in the mind to suffer
878 The slings and arrows of outrageous fortune,
879 Or to take arms against a sea of troubles,
880 And, by opposing, end them. To die, to sleep-
881 No more-and by a sleep to say we end
882 The heartache and the thousand natural shocks
883 That flesh is heir to-'tis a consummation
884 Devoutly to be wished. To die, to sleep-
885 To sleep, perchance to dream. Aye, there's the rub,
886 For in that sleep of death what dreams may come,
887 When we have shuffled off this mortal coil,
888 Must give us pause. There's the respect
889 That makes calamity of so long life.
890 For who would bear the whips and scorns of time,
891 Th' oppressor's wrong, the proud man's contumely,
892 The pangs of despised love, the law’s delay,
893 The insolence of office, and the spurns
894 That patient merit of the unworthy takes,
895 When he himself might his quietus make
896 With a bare bodkin? Who would fardels bear,
897 To grunt and sweat under a weary life,
898 But that the dread of something after death,
899 The undiscovered country from whose bourn
900 No traveler returns, puzzles the will
901 And makes us rather bear those ills we have
902 Than fly to others that we know not of?
903 Thus conscience does make cowards of us all,
904 And thus the native hue of resolution
905 Is sicklied o'er with the pale cast of thought,
906 And enterprises of great pitch and moment,
907 With this regard their currents turn awry,
908 And lose the name of action.-Soft you now,
909 The fair Ophelia.-Nymph, in thy orisons
910 Be all my sins remembered
911
912
913 SQL Params
914 SQLType =SQL_LONG
915 sub type = 0
916 Field Name = ROWID
917 Scale = 0
918 Charset id = 0
919 Not Null
920 Size = 4
921
922 SQLType =SQL_VARYING
923 sub type = 0
924 Field Name = TITLE
925 Scale = 0
926 Charset id = 4
927 Nullable
928 Size = 128
929
930 SQLType =SQL_LONG
931 sub type = 0
932 Field Name = FP
933 Scale = -2
934 Charset id = 0
935 Nullable
936 Size = 4
937
938 SQLType =SQL_DOUBLE
939 sub type = 0
940 Field Name = DP
941 Scale = 0
942 Charset id = 0
943 Nullable
944 Size = 8
945
946 ROWID = 1
947 FIXEDPOINT = 20.28
948 FLOATINGPOINT = 3.14
949 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
950 BLOBDATA (Charset Id = 4 Codepage = 65001)
951
952 To be or not to be-that is the question:
953 Whether 'tis nobler in the mind to suffer
954 The slings and arrows of outrageous fortune,
955 Or to take arms against a sea of troubles,
956 And, by opposing, end them. To die, to sleep-
957 No more-and by a sleep to say we end
958 The heartache and the thousand natural shocks
959 That flesh is heir to-'tis a consummation
960 Devoutly to be wished. To die, to sleep-
961 To sleep, perchance to dream. Aye, there's the rub,
962 For in that sleep of death what dreams may come,
963 When we have shuffled off this mortal coil,
964 Must give us pause. There's the respect
965 That makes calamity of so long life.
966 For who would bear the whips and scorns of time,
967 Th' oppressor's wrong, the proud man's contumely,
968 The pangs of despised love, the law’s delay,
969 The insolence of office, and the spurns
970 That patient merit of the unworthy takes,
971 When he himself might his quietus make
972 With a bare bodkin? Who would fardels bear,
973 To grunt and sweat under a weary life,
974 But that the dread of something after death,
975 The undiscovered country from whose bourn
976 No traveler returns, puzzles the will
977 And makes us rather bear those ills we have
978 Than fly to others that we know not of?
979 Thus conscience does make cowards of us all,
980 And thus the native hue of resolution
981 Is sicklied o'er with the pale cast of thought,
982 And enterprises of great pitch and moment,
983 With this regard their currents turn awry,
984 And lose the name of action.-Soft you now,
985 The fair Ophelia.-Nymph, in thy orisons
986 Be all my sins remembered
987
988 ROWID = 2
989 FIXEDPOINT = NULL
990 FLOATINGPOINT = NULL
991 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
992 BLOBDATA (Charset Id = 4 Codepage = 65001)
993
994 To be or not to be-that is the question:
995 Whether 'tis nobler in the mind to suffer
996 The slings and arrows of outrageous fortune,
997 Or to take arms against a sea of troubles,
998 And, by opposing, end them. To die, to sleep-
999 No more-and by a sleep to say we end
1000 The heartache and the thousand natural shocks
1001 That flesh is heir to-'tis a consummation
1002 Devoutly to be wished. To die, to sleep-
1003 To sleep, perchance to dream. Aye, there's the rub,
1004 For in that sleep of death what dreams may come,
1005 When we have shuffled off this mortal coil,
1006 Must give us pause. There's the respect
1007 That makes calamity of so long life.
1008 For who would bear the whips and scorns of time,
1009 Th' oppressor's wrong, the proud man's contumely,
1010 The pangs of despised love, the law’s delay,
1011 The insolence of office, and the spurns
1012 That patient merit of the unworthy takes,
1013 When he himself might his quietus make
1014 With a bare bodkin? Who would fardels bear,
1015 To grunt and sweat under a weary life,
1016 But that the dread of something after death,
1017 The undiscovered country from whose bourn
1018 No traveler returns, puzzles the will
1019 And makes us rather bear those ills we have
1020 Than fly to others that we know not of?
1021 Thus conscience does make cowards of us all,
1022 And thus the native hue of resolution
1023 Is sicklied o'er with the pale cast of thought,
1024 And enterprises of great pitch and moment,
1025 With this regard their currents turn awry,
1026 And lose the name of action.-Soft you now,
1027 The fair Ophelia.-Nymph, in thy orisons
1028 Be all my sins remembered
1029
1030
1031 Testing Blob as stored proc parameter
1032 Metadata
1033 SQLType =SQL_BLOB
1034 sub type = 1
1035 Table = TESTPROC
1036 Owner = SYSDBA
1037 Column Name = BLOBDATA
1038 Alias Name = BLOBDATA
1039 Field Name = BLOBDATA
1040 Scale = 0
1041 Charset id = 4
1042 Nullable
1043 Size = 8
1044
1045 Blob Meta Data
1046 SQL SubType =1
1047 Table = TESTPROC
1048 Column = BLOBDATA
1049 CharSetID = 4
1050 Segment Size = 80
1051
1052
1053 BLOBDATA (Charset Id = 4 Codepage = 65001)
1054
1055 To be or not to be-that is the question:
1056 Whether 'tis nobler in the mind to suffer
1057 The slings and arrows of outrageous fortune,
1058 Or to take arms against a sea of troubles,
1059 And, by opposing, end them. To die, to sleep-
1060 No more-and by a sleep to say we end
1061 The heartache and the thousand natural shocks
1062 That flesh is heir to-'tis a consummation
1063 Devoutly to be wished. To die, to sleep-
1064 To sleep, perchance to dream. Aye, there's the rub,
1065 For in that sleep of death what dreams may come,
1066 When we have shuffled off this mortal coil,
1067 Must give us pause. There's the respect
1068 That makes calamity of so long life.
1069 For who would bear the whips and scorns of time,
1070 Th' oppressor's wrong, the proud man's contumely,
1071 The pangs of despised love, the law’s delay,
1072 The insolence of office, and the spurns
1073 That patient merit of the unworthy takes,
1074 When he himself might his quietus make
1075 With a bare bodkin? Who would fardels bear,
1076 To grunt and sweat under a weary life,
1077 But that the dread of something after death,
1078 The undiscovered country from whose bourn
1079 No traveler returns, puzzles the will
1080 And makes us rather bear those ills we have
1081 Than fly to others that we know not of?
1082 Thus conscience does make cowards of us all,
1083 And thus the native hue of resolution
1084 Is sicklied o'er with the pale cast of thought,
1085 And enterprises of great pitch and moment,
1086 With this regard their currents turn awry,
1087 And lose the name of action.-Soft you now,
1088 The fair Ophelia.-Nymph, in thy orisons
1089 Be all my sins remembered
1090
1091 Metadata
1092 SQLType =SQL_TEXT
1093 sub type = 0
1094 Table = RDB$CHARACTER_SETS
1095 Owner = SYSDBA
1096 Column Name = RDB$CHARACTER_SET_NAME
1097 Alias Name = RDB$CHARACTER_SET_NAME
1098 Field Name = RDB$CHARACTER_SET_NAME
1099 Scale = 0
1100 Charset id = 53
1101 Nullable
1102 Size = 31
1103
1104 SQLType =SQL_SHORT
1105 sub type = 0
1106 Table = RDB$CHARACTER_SETS
1107 Owner = SYSDBA
1108 Column Name = RDB$CHARACTER_SET_ID
1109 Alias Name = RDB$CHARACTER_SET_ID
1110 Field Name = RDB$CHARACTER_SET_ID
1111 Scale = 0
1112 Charset id = 0
1113 Nullable
1114 Size = 2
1115
1116 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1117 RDB$CHARACTER_SET_ID = 0
1118 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1119 RDB$CHARACTER_SET_ID = 1
1120 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1121 RDB$CHARACTER_SET_ID = 2
1122 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1123 RDB$CHARACTER_SET_ID = 3
1124 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1125 RDB$CHARACTER_SET_ID = 4
1126 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1127 RDB$CHARACTER_SET_ID = 5
1128 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1129 RDB$CHARACTER_SET_ID = 6
1130 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1131 RDB$CHARACTER_SET_ID = 9
1132 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1133 RDB$CHARACTER_SET_ID = 10
1134 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1135 RDB$CHARACTER_SET_ID = 11
1136 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1137 RDB$CHARACTER_SET_ID = 12
1138 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1139 RDB$CHARACTER_SET_ID = 13
1140 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1141 RDB$CHARACTER_SET_ID = 14
1142 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1143 RDB$CHARACTER_SET_ID = 15
1144 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1145 RDB$CHARACTER_SET_ID = 16
1146 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1147 RDB$CHARACTER_SET_ID = 17
1148 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1149 RDB$CHARACTER_SET_ID = 18
1150 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1151 RDB$CHARACTER_SET_ID = 19
1152 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1153 RDB$CHARACTER_SET_ID = 21
1154 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1155 RDB$CHARACTER_SET_ID = 22
1156 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1157 RDB$CHARACTER_SET_ID = 23
1158 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1159 RDB$CHARACTER_SET_ID = 34
1160 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1161 RDB$CHARACTER_SET_ID = 35
1162 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1163 RDB$CHARACTER_SET_ID = 36
1164 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1165 RDB$CHARACTER_SET_ID = 37
1166 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1167 RDB$CHARACTER_SET_ID = 38
1168 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1169 RDB$CHARACTER_SET_ID = 39
1170 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1171 RDB$CHARACTER_SET_ID = 40
1172 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1173 RDB$CHARACTER_SET_ID = 44
1174 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1175 RDB$CHARACTER_SET_ID = 45
1176 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1177 RDB$CHARACTER_SET_ID = 46
1178 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1179 RDB$CHARACTER_SET_ID = 47
1180 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1181 RDB$CHARACTER_SET_ID = 48
1182 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1183 RDB$CHARACTER_SET_ID = 49
1184 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1185 RDB$CHARACTER_SET_ID = 50
1186 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1187 RDB$CHARACTER_SET_ID = 51
1188 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1189 RDB$CHARACTER_SET_ID = 52
1190 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1191 RDB$CHARACTER_SET_ID = 53
1192 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1193 RDB$CHARACTER_SET_ID = 54
1194 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1195 RDB$CHARACTER_SET_ID = 55
1196 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1197 RDB$CHARACTER_SET_ID = 56
1198 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1199 RDB$CHARACTER_SET_ID = 57
1200 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1201 RDB$CHARACTER_SET_ID = 58
1202 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1203 RDB$CHARACTER_SET_ID = 59
1204 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1205 RDB$CHARACTER_SET_ID = 60
1206 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1207 RDB$CHARACTER_SET_ID = 63
1208 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1209 RDB$CHARACTER_SET_ID = 64
1210 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1211 RDB$CHARACTER_SET_ID = 65
1212 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1213 RDB$CHARACTER_SET_ID = 66
1214 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1215 RDB$CHARACTER_SET_ID = 67
1216 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1217 RDB$CHARACTER_SET_ID = 68
1218 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1219 RDB$CHARACTER_SET_ID = 69
1220
1221 Metadata
1222 SQLType =SQL_LONG
1223 sub type = 0
1224 Table = TESTDATA
1225 Owner = SYSDBA
1226 Column Name = ROWID
1227 Alias Name = ROWID
1228 Field Name = ROWID
1229 Scale = 0
1230 Charset id = 0
1231 Not Null
1232 Size = 4
1233
1234 SQLType =SQL_LONG
1235 sub type = 0
1236 Table = TESTDATA
1237 Owner = SYSDBA
1238 Column Name = FIXEDPOINT
1239 Alias Name = FIXEDPOINT
1240 Field Name = FIXEDPOINT
1241 Scale = -2
1242 Charset id = 0
1243 Nullable
1244 Size = 4
1245
1246 SQLType =SQL_DOUBLE
1247 sub type = 0
1248 Table = TESTDATA
1249 Owner = SYSDBA
1250 Column Name = FLOATINGPOINT
1251 Alias Name = FLOATINGPOINT
1252 Field Name = FLOATINGPOINT
1253 Scale = 0
1254 Charset id = 0
1255 Nullable
1256 Size = 8
1257
1258 SQLType =SQL_VARYING
1259 sub type = 0
1260 Table = TESTDATA
1261 Owner = SYSDBA
1262 Column Name = TITLE
1263 Alias Name = TITLE
1264 Field Name = TITLE
1265 Scale = 0
1266 Charset id = 53
1267 Nullable
1268 Size = 32
1269
1270 SQLType =SQL_BLOB
1271 sub type = 1
1272 Table = TESTDATA
1273 Owner = SYSDBA
1274 Column Name = BLOBDATA
1275 Alias Name = BLOBDATA
1276 Field Name = BLOBDATA
1277 Scale = 0
1278 Charset id = 53
1279 Nullable
1280 Size = 8
1281
1282 Blob Meta Data
1283 SQL SubType =1
1284 Table = TESTDATA
1285 Column = BLOBDATA
1286 CharSetID = 53
1287 Segment Size = 80
1288
1289
1290 SQL Params
1291 SQLType =SQL_LONG
1292 sub type = 0
1293 Field Name = ROWID
1294 Scale = 0
1295 Charset id = 0
1296 Not Null
1297 Size = 4
1298
1299 SQLType =SQL_VARYING
1300 sub type = 0
1301 Field Name = TITLE
1302 Scale = 0
1303 Charset id = 53
1304 Nullable
1305 Size = 32
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 = 53 Codepage = 1252 Byte Length = 15)
1327 BLOBDATA = NULL
1328
1329 SQL Params
1330 SQLType =SQL_BLOB
1331 sub type = 1
1332 Field Name =
1333 Scale = 0
1334 Charset id = 53
1335 Nullable
1336 Size = 8
1337
1338 SQLType =SQL_LONG
1339 sub type = 0
1340 Field Name =
1341 Scale = 0
1342 Charset id = 0
1343 Not Null
1344 Size = 4
1345
1346 ROWID = 1
1347 FIXEDPOINT = 20.28
1348 FLOATINGPOINT = 3.14
1349 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1350 BLOBDATA (Charset Id = 53 Codepage = 1252)
1351
1352 To be or not to be-that is the question:
1353 Whether 'tis nobler in the mind to suffer
1354 The slings and arrows of outrageous fortune,
1355 Or to take arms against a sea of troubles,
1356 And, by opposing, end them. To die, to sleep-
1357 No more-and by a sleep to say we end
1358 The heartache and the thousand natural shocks
1359 That flesh is heir to-'tis a consummation
1360 Devoutly to be wished. To die, to sleep-
1361 To sleep, perchance to dream. Aye, there's the rub,
1362 For in that sleep of death what dreams may come,
1363 When we have shuffled off this mortal coil,
1364 Must give us pause. There's the respect
1365 That makes calamity of so long life.
1366 For who would bear the whips and scorns of time,
1367 Th' oppressor's wrong, the proud man's contumely,
1368 The pangs of despised love, the law’s delay,
1369 The insolence of office, and the spurns
1370 That patient merit of the unworthy takes,
1371 When he himself might his quietus make
1372 With a bare bodkin? Who would fardels bear,
1373 To grunt and sweat under a weary life,
1374 But that the dread of something after death,
1375 The undiscovered country from whose bourn
1376 No traveler returns, puzzles the will
1377 And makes us rather bear those ills we have
1378 Than fly to others that we know not of?
1379 Thus conscience does make cowards of us all,
1380 And thus the native hue of resolution
1381 Is sicklied o'er with the pale cast of thought,
1382 And enterprises of great pitch and moment,
1383 With this regard their currents turn awry,
1384 And lose the name of action.-Soft you now,
1385 The fair Ophelia.-Nymph, in thy orisons
1386 Be all my sins remembered
1387
1388
1389 SQL Params
1390 SQLType =SQL_LONG
1391 sub type = 0
1392 Field Name = ROWID
1393 Scale = 0
1394 Charset id = 0
1395 Not Null
1396 Size = 4
1397
1398 SQLType =SQL_VARYING
1399 sub type = 0
1400 Field Name = TITLE
1401 Scale = 0
1402 Charset id = 53
1403 Nullable
1404 Size = 32
1405
1406 SQLType =SQL_LONG
1407 sub type = 0
1408 Field Name = FP
1409 Scale = -2
1410 Charset id = 0
1411 Nullable
1412 Size = 4
1413
1414 SQLType =SQL_DOUBLE
1415 sub type = 0
1416 Field Name = DP
1417 Scale = 0
1418 Charset id = 0
1419 Nullable
1420 Size = 8
1421
1422 ROWID = 1
1423 FIXEDPOINT = 20.28
1424 FLOATINGPOINT = 3.14
1425 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1426 BLOBDATA (Charset Id = 53 Codepage = 1252)
1427
1428 To be or not to be-that is the question:
1429 Whether 'tis nobler in the mind to suffer
1430 The slings and arrows of outrageous fortune,
1431 Or to take arms against a sea of troubles,
1432 And, by opposing, end them. To die, to sleep-
1433 No more-and by a sleep to say we end
1434 The heartache and the thousand natural shocks
1435 That flesh is heir to-'tis a consummation
1436 Devoutly to be wished. To die, to sleep-
1437 To sleep, perchance to dream. Aye, there's the rub,
1438 For in that sleep of death what dreams may come,
1439 When we have shuffled off this mortal coil,
1440 Must give us pause. There's the respect
1441 That makes calamity of so long life.
1442 For who would bear the whips and scorns of time,
1443 Th' oppressor's wrong, the proud man's contumely,
1444 The pangs of despised love, the law’s delay,
1445 The insolence of office, and the spurns
1446 That patient merit of the unworthy takes,
1447 When he himself might his quietus make
1448 With a bare bodkin? Who would fardels bear,
1449 To grunt and sweat under a weary life,
1450 But that the dread of something after death,
1451 The undiscovered country from whose bourn
1452 No traveler returns, puzzles the will
1453 And makes us rather bear those ills we have
1454 Than fly to others that we know not of?
1455 Thus conscience does make cowards of us all,
1456 And thus the native hue of resolution
1457 Is sicklied o'er with the pale cast of thought,
1458 And enterprises of great pitch and moment,
1459 With this regard their currents turn awry,
1460 And lose the name of action.-Soft you now,
1461 The fair Ophelia.-Nymph, in thy orisons
1462 Be all my sins remembered
1463
1464 ROWID = 2
1465 FIXEDPOINT = NULL
1466 FLOATINGPOINT = NULL
1467 TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1468 BLOBDATA (Charset Id = 53 Codepage = 1252)
1469
1470 To be or not to be-that is the question:
1471 Whether 'tis nobler in the mind to suffer
1472 The slings and arrows of outrageous fortune,
1473 Or to take arms against a sea of troubles,
1474 And, by opposing, end them. To die, to sleep-
1475 No more-and by a sleep to say we end
1476 The heartache and the thousand natural shocks
1477 That flesh is heir to-'tis a consummation
1478 Devoutly to be wished. To die, to sleep-
1479 To sleep, perchance to dream. Aye, there's the rub,
1480 For in that sleep of death what dreams may come,
1481 When we have shuffled off this mortal coil,
1482 Must give us pause. There's the respect
1483 That makes calamity of so long life.
1484 For who would bear the whips and scorns of time,
1485 Th' oppressor's wrong, the proud man's contumely,
1486 The pangs of despised love, the law’s delay,
1487 The insolence of office, and the spurns
1488 That patient merit of the unworthy takes,
1489 When he himself might his quietus make
1490 With a bare bodkin? Who would fardels bear,
1491 To grunt and sweat under a weary life,
1492 But that the dread of something after death,
1493 The undiscovered country from whose bourn
1494 No traveler returns, puzzles the will
1495 And makes us rather bear those ills we have
1496 Than fly to others that we know not of?
1497 Thus conscience does make cowards of us all,
1498 And thus the native hue of resolution
1499 Is sicklied o'er with the pale cast of thought,
1500 And enterprises of great pitch and moment,
1501 With this regard their currents turn awry,
1502 And lose the name of action.-Soft you now,
1503 The fair Ophelia.-Nymph, in thy orisons
1504 Be all my sins remembered
1505
1506
1507 Testing Blob as stored proc parameter
1508 Metadata
1509 SQLType =SQL_BLOB
1510 sub type = 1
1511 Table = TESTPROC
1512 Owner = SYSDBA
1513 Column Name = BLOBDATA
1514 Alias Name = BLOBDATA
1515 Field Name = BLOBDATA
1516 Scale = 0
1517 Charset id = 53
1518 Nullable
1519 Size = 8
1520
1521 Blob Meta Data
1522 SQL SubType =1
1523 Table = TESTPROC
1524 Column = BLOBDATA
1525 CharSetID = 53
1526 Segment Size = 80
1527
1528
1529 BLOBDATA (Charset Id = 53 Codepage = 1252)
1530
1531 To be or not to be-that is the question:
1532 Whether 'tis nobler in the mind to suffer
1533 The slings and arrows of outrageous fortune,
1534 Or to take arms against a sea of troubles,
1535 And, by opposing, end them. To die, to sleep-
1536 No more-and by a sleep to say we end
1537 The heartache and the thousand natural shocks
1538 That flesh is heir to-'tis a consummation
1539 Devoutly to be wished. To die, to sleep-
1540 To sleep, perchance to dream. Aye, there's the rub,
1541 For in that sleep of death what dreams may come,
1542 When we have shuffled off this mortal coil,
1543 Must give us pause. There's the respect
1544 That makes calamity of so long life.
1545 For who would bear the whips and scorns of time,
1546 Th' oppressor's wrong, the proud man's contumely,
1547 The pangs of despised love, the law’s delay,
1548 The insolence of office, and the spurns
1549 That patient merit of the unworthy takes,
1550 When he himself might his quietus make
1551 With a bare bodkin? Who would fardels bear,
1552 To grunt and sweat under a weary life,
1553 But that the dread of something after death,
1554 The undiscovered country from whose bourn
1555 No traveler returns, puzzles the will
1556 And makes us rather bear those ills we have
1557 Than fly to others that we know not of?
1558 Thus conscience does make cowards of us all,
1559 And thus the native hue of resolution
1560 Is sicklied o'er with the pale cast of thought,
1561 And enterprises of great pitch and moment,
1562 With this regard their currents turn awry,
1563 And lose the name of action.-Soft you now,
1564 The fair Ophelia.-Nymph, in thy orisons
1565 Be all my sins remembered
1566
1567 Metadata
1568 SQLType =SQL_TEXT
1569 sub type = 0
1570 Table = RDB$CHARACTER_SETS
1571 Owner = SYSDBA
1572 Column Name = RDB$CHARACTER_SET_NAME
1573 Alias Name = RDB$CHARACTER_SET_NAME
1574 Field Name = RDB$CHARACTER_SET_NAME
1575 Scale = 0
1576 Charset id = 3
1577 Nullable
1578 Size = 93
1579
1580 SQLType =SQL_SHORT
1581 sub type = 0
1582 Table = RDB$CHARACTER_SETS
1583 Owner = SYSDBA
1584 Column Name = RDB$CHARACTER_SET_ID
1585 Alias Name = RDB$CHARACTER_SET_ID
1586 Field Name = RDB$CHARACTER_SET_ID
1587 Scale = 0
1588 Charset id = 0
1589 Nullable
1590 Size = 2
1591
1592 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1593 RDB$CHARACTER_SET_ID = 0
1594 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1595 RDB$CHARACTER_SET_ID = 1
1596 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1597 RDB$CHARACTER_SET_ID = 2
1598 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1599 RDB$CHARACTER_SET_ID = 3
1600 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1601 RDB$CHARACTER_SET_ID = 4
1602 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1603 RDB$CHARACTER_SET_ID = 5
1604 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1605 RDB$CHARACTER_SET_ID = 6
1606 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1607 RDB$CHARACTER_SET_ID = 9
1608 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1609 RDB$CHARACTER_SET_ID = 10
1610 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1611 RDB$CHARACTER_SET_ID = 11
1612 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1613 RDB$CHARACTER_SET_ID = 12
1614 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1615 RDB$CHARACTER_SET_ID = 13
1616 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1617 RDB$CHARACTER_SET_ID = 14
1618 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1619 RDB$CHARACTER_SET_ID = 15
1620 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1621 RDB$CHARACTER_SET_ID = 16
1622 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1623 RDB$CHARACTER_SET_ID = 17
1624 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1625 RDB$CHARACTER_SET_ID = 18
1626 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1627 RDB$CHARACTER_SET_ID = 19
1628 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1629 RDB$CHARACTER_SET_ID = 21
1630 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1631 RDB$CHARACTER_SET_ID = 22
1632 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1633 RDB$CHARACTER_SET_ID = 23
1634 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1635 RDB$CHARACTER_SET_ID = 34
1636 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1637 RDB$CHARACTER_SET_ID = 35
1638 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1639 RDB$CHARACTER_SET_ID = 36
1640 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1641 RDB$CHARACTER_SET_ID = 37
1642 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1643 RDB$CHARACTER_SET_ID = 38
1644 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1645 RDB$CHARACTER_SET_ID = 39
1646 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1647 RDB$CHARACTER_SET_ID = 40
1648 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1649 RDB$CHARACTER_SET_ID = 44
1650 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1651 RDB$CHARACTER_SET_ID = 45
1652 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1653 RDB$CHARACTER_SET_ID = 46
1654 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1655 RDB$CHARACTER_SET_ID = 47
1656 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1657 RDB$CHARACTER_SET_ID = 48
1658 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1659 RDB$CHARACTER_SET_ID = 49
1660 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1661 RDB$CHARACTER_SET_ID = 50
1662 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1663 RDB$CHARACTER_SET_ID = 51
1664 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1665 RDB$CHARACTER_SET_ID = 52
1666 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1667 RDB$CHARACTER_SET_ID = 53
1668 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1669 RDB$CHARACTER_SET_ID = 54
1670 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1671 RDB$CHARACTER_SET_ID = 55
1672 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1673 RDB$CHARACTER_SET_ID = 56
1674 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1675 RDB$CHARACTER_SET_ID = 57
1676 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1677 RDB$CHARACTER_SET_ID = 58
1678 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1679 RDB$CHARACTER_SET_ID = 59
1680 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1681 RDB$CHARACTER_SET_ID = 60
1682 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1683 RDB$CHARACTER_SET_ID = 63
1684 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1685 RDB$CHARACTER_SET_ID = 64
1686 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1687 RDB$CHARACTER_SET_ID = 65
1688 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1689 RDB$CHARACTER_SET_ID = 66
1690 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1691 RDB$CHARACTER_SET_ID = 67
1692 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1693 RDB$CHARACTER_SET_ID = 68
1694 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1695 RDB$CHARACTER_SET_ID = 69
1696
1697 Metadata
1698 SQLType =SQL_LONG
1699 sub type = 0
1700 Table = TESTDATA
1701 Owner = SYSDBA
1702 Column Name = ROWID
1703 Alias Name = ROWID
1704 Field Name = ROWID
1705 Scale = 0
1706 Charset id = 0
1707 Not Null
1708 Size = 4
1709
1710 SQLType =SQL_LONG
1711 sub type = 0
1712 Table = TESTDATA
1713 Owner = SYSDBA
1714 Column Name = FIXEDPOINT
1715 Alias Name = FIXEDPOINT
1716 Field Name = FIXEDPOINT
1717 Scale = -2
1718 Charset id = 0
1719 Nullable
1720 Size = 4
1721
1722 SQLType =SQL_DOUBLE
1723 sub type = 0
1724 Table = TESTDATA
1725 Owner = SYSDBA
1726 Column Name = FLOATINGPOINT
1727 Alias Name = FLOATINGPOINT
1728 Field Name = FLOATINGPOINT
1729 Scale = 0
1730 Charset id = 0
1731 Nullable
1732 Size = 8
1733
1734 SQLType =SQL_VARYING
1735 sub type = 0
1736 Table = TESTDATA
1737 Owner = SYSDBA
1738 Column Name = TITLE
1739 Alias Name = TITLE
1740 Field Name = TITLE
1741 Scale = 0
1742 Charset id = 4
1743 Nullable
1744 Size = 128
1745
1746 SQLType =SQL_BLOB
1747 sub type = 1
1748 Table = TESTDATA
1749 Owner = SYSDBA
1750 Column Name = BLOBDATA
1751 Alias Name = BLOBDATA
1752 Field Name = BLOBDATA
1753 Scale = 0
1754 Charset id = 4
1755 Nullable
1756 Size = 8
1757
1758 Blob Meta Data
1759 SQL SubType =1
1760 Table = TESTDATA
1761 Column = BLOBDATA
1762 CharSetID = 4
1763 Segment Size = 80
1764
1765
1766 SQL Params
1767 SQLType =SQL_LONG
1768 sub type = 0
1769 Field Name = ROWID
1770 Scale = 0
1771 Charset id = 0
1772 Not Null
1773 Size = 4
1774
1775 SQLType =SQL_VARYING
1776 sub type = 0
1777 Field Name = TITLE
1778 Scale = 0
1779 Charset id = 4
1780 Nullable
1781 Size = 128
1782
1783 SQLType =SQL_LONG
1784 sub type = 0
1785 Field Name = FP
1786 Scale = -2
1787 Charset id = 0
1788 Nullable
1789 Size = 4
1790
1791 SQLType =SQL_DOUBLE
1792 sub type = 0
1793 Field Name = DP
1794 Scale = 0
1795 Charset id = 0
1796 Nullable
1797 Size = 8
1798
1799 ROWID = 1
1800 FIXEDPOINT = 20.28
1801 FLOATINGPOINT = 3.14
1802 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1803 BLOBDATA = NULL
1804
1805 SQL Params
1806 SQLType =SQL_BLOB
1807 sub type = 1
1808 Field Name =
1809 Scale = 0
1810 Charset id = 4
1811 Nullable
1812 Size = 8
1813
1814 SQLType =SQL_LONG
1815 sub type = 0
1816 Field Name =
1817 Scale = 0
1818 Charset id = 0
1819 Not Null
1820 Size = 4
1821
1822 ROWID = 1
1823 FIXEDPOINT = 20.28
1824 FLOATINGPOINT = 3.14
1825 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1826 BLOBDATA (Charset Id = 4 Codepage = 65001)
1827
1828 To be or not to be-that is the question:
1829 Whether 'tis nobler in the mind to suffer
1830 The slings and arrows of outrageous fortune,
1831 Or to take arms against a sea of troubles,
1832 And, by opposing, end them. To die, to sleep-
1833 No more-and by a sleep to say we end
1834 The heartache and the thousand natural shocks
1835 That flesh is heir to-'tis a consummation
1836 Devoutly to be wished. To die, to sleep-
1837 To sleep, perchance to dream. Aye, there's the rub,
1838 For in that sleep of death what dreams may come,
1839 When we have shuffled off this mortal coil,
1840 Must give us pause. There's the respect
1841 That makes calamity of so long life.
1842 For who would bear the whips and scorns of time,
1843 Th' oppressor's wrong, the proud man's contumely,
1844 The pangs of despised love, the law’s delay,
1845 The insolence of office, and the spurns
1846 That patient merit of the unworthy takes,
1847 When he himself might his quietus make
1848 With a bare bodkin? Who would fardels bear,
1849 To grunt and sweat under a weary life,
1850 But that the dread of something after death,
1851 The undiscovered country from whose bourn
1852 No traveler returns, puzzles the will
1853 And makes us rather bear those ills we have
1854 Than fly to others that we know not of?
1855 Thus conscience does make cowards of us all,
1856 And thus the native hue of resolution
1857 Is sicklied o'er with the pale cast of thought,
1858 And enterprises of great pitch and moment,
1859 With this regard their currents turn awry,
1860 And lose the name of action.-Soft you now,
1861 The fair Ophelia.-Nymph, in thy orisons
1862 Be all my sins remembered
1863
1864
1865 SQL Params
1866 SQLType =SQL_LONG
1867 sub type = 0
1868 Field Name = ROWID
1869 Scale = 0
1870 Charset id = 0
1871 Not Null
1872 Size = 4
1873
1874 SQLType =SQL_VARYING
1875 sub type = 0
1876 Field Name = TITLE
1877 Scale = 0
1878 Charset id = 4
1879 Nullable
1880 Size = 128
1881
1882 SQLType =SQL_LONG
1883 sub type = 0
1884 Field Name = FP
1885 Scale = -2
1886 Charset id = 0
1887 Nullable
1888 Size = 4
1889
1890 SQLType =SQL_DOUBLE
1891 sub type = 0
1892 Field Name = DP
1893 Scale = 0
1894 Charset id = 0
1895 Nullable
1896 Size = 8
1897
1898 ROWID = 1
1899 FIXEDPOINT = 20.28
1900 FLOATINGPOINT = 3.14
1901 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1902 BLOBDATA (Charset Id = 4 Codepage = 65001)
1903
1904 To be or not to be-that is the question:
1905 Whether 'tis nobler in the mind to suffer
1906 The slings and arrows of outrageous fortune,
1907 Or to take arms against a sea of troubles,
1908 And, by opposing, end them. To die, to sleep-
1909 No more-and by a sleep to say we end
1910 The heartache and the thousand natural shocks
1911 That flesh is heir to-'tis a consummation
1912 Devoutly to be wished. To die, to sleep-
1913 To sleep, perchance to dream. Aye, there's the rub,
1914 For in that sleep of death what dreams may come,
1915 When we have shuffled off this mortal coil,
1916 Must give us pause. There's the respect
1917 That makes calamity of so long life.
1918 For who would bear the whips and scorns of time,
1919 Th' oppressor's wrong, the proud man's contumely,
1920 The pangs of despised love, the law’s delay,
1921 The insolence of office, and the spurns
1922 That patient merit of the unworthy takes,
1923 When he himself might his quietus make
1924 With a bare bodkin? Who would fardels bear,
1925 To grunt and sweat under a weary life,
1926 But that the dread of something after death,
1927 The undiscovered country from whose bourn
1928 No traveler returns, puzzles the will
1929 And makes us rather bear those ills we have
1930 Than fly to others that we know not of?
1931 Thus conscience does make cowards of us all,
1932 And thus the native hue of resolution
1933 Is sicklied o'er with the pale cast of thought,
1934 And enterprises of great pitch and moment,
1935 With this regard their currents turn awry,
1936 And lose the name of action.-Soft you now,
1937 The fair Ophelia.-Nymph, in thy orisons
1938 Be all my sins remembered
1939
1940 ROWID = 2
1941 FIXEDPOINT = NULL
1942 FLOATINGPOINT = NULL
1943 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1944 BLOBDATA (Charset Id = 4 Codepage = 65001)
1945
1946 To be or not to be-that is the question:
1947 Whether 'tis nobler in the mind to suffer
1948 The slings and arrows of outrageous fortune,
1949 Or to take arms against a sea of troubles,
1950 And, by opposing, end them. To die, to sleep-
1951 No more-and by a sleep to say we end
1952 The heartache and the thousand natural shocks
1953 That flesh is heir to-'tis a consummation
1954 Devoutly to be wished. To die, to sleep-
1955 To sleep, perchance to dream. Aye, there's the rub,
1956 For in that sleep of death what dreams may come,
1957 When we have shuffled off this mortal coil,
1958 Must give us pause. There's the respect
1959 That makes calamity of so long life.
1960 For who would bear the whips and scorns of time,
1961 Th' oppressor's wrong, the proud man's contumely,
1962 The pangs of despised love, the law’s delay,
1963 The insolence of office, and the spurns
1964 That patient merit of the unworthy takes,
1965 When he himself might his quietus make
1966 With a bare bodkin? Who would fardels bear,
1967 To grunt and sweat under a weary life,
1968 But that the dread of something after death,
1969 The undiscovered country from whose bourn
1970 No traveler returns, puzzles the will
1971 And makes us rather bear those ills we have
1972 Than fly to others that we know not of?
1973 Thus conscience does make cowards of us all,
1974 And thus the native hue of resolution
1975 Is sicklied o'er with the pale cast of thought,
1976 And enterprises of great pitch and moment,
1977 With this regard their currents turn awry,
1978 And lose the name of action.-Soft you now,
1979 The fair Ophelia.-Nymph, in thy orisons
1980 Be all my sins remembered
1981
1982
1983 Testing Blob as stored proc parameter
1984 Metadata
1985 SQLType =SQL_BLOB
1986 sub type = 1
1987 Table = TESTPROC
1988 Owner = SYSDBA
1989 Column Name = BLOBDATA
1990 Alias Name = BLOBDATA
1991 Field Name = BLOBDATA
1992 Scale = 0
1993 Charset id = 4
1994 Nullable
1995 Size = 8
1996
1997 Blob Meta Data
1998 SQL SubType =1
1999 Table = TESTPROC
2000 Column = BLOBDATA
2001 CharSetID = 4
2002 Segment Size = 80
2003
2004
2005 BLOBDATA (Charset Id = 4 Codepage = 65001)
2006
2007 To be or not to be-that is the question:
2008 Whether 'tis nobler in the mind to suffer
2009 The slings and arrows of outrageous fortune,
2010 Or to take arms against a sea of troubles,
2011 And, by opposing, end them. To die, to sleep-
2012 No more-and by a sleep to say we end
2013 The heartache and the thousand natural shocks
2014 That flesh is heir to-'tis a consummation
2015 Devoutly to be wished. To die, to sleep-
2016 To sleep, perchance to dream. Aye, there's the rub,
2017 For in that sleep of death what dreams may come,
2018 When we have shuffled off this mortal coil,
2019 Must give us pause. There's the respect
2020 That makes calamity of so long life.
2021 For who would bear the whips and scorns of time,
2022 Th' oppressor's wrong, the proud man's contumely,
2023 The pangs of despised love, the law’s delay,
2024 The insolence of office, and the spurns
2025 That patient merit of the unworthy takes,
2026 When he himself might his quietus make
2027 With a bare bodkin? Who would fardels bear,
2028 To grunt and sweat under a weary life,
2029 But that the dread of something after death,
2030 The undiscovered country from whose bourn
2031 No traveler returns, puzzles the will
2032 And makes us rather bear those ills we have
2033 Than fly to others that we know not of?
2034 Thus conscience does make cowards of us all,
2035 And thus the native hue of resolution
2036 Is sicklied o'er with the pale cast of thought,
2037 And enterprises of great pitch and moment,
2038 With this regard their currents turn awry,
2039 And lose the name of action.-Soft you now,
2040 The fair Ophelia.-Nymph, in thy orisons
2041 Be all my sins remembered
2042
2043
2044
2045 Running Test 7: Create and read back an Array
2046 Metadata
2047 SQLType =SQL_LONG
2048 sub type = 0
2049 Table = TESTDATA
2050 Owner = SYSDBA
2051 Column Name = ROWID
2052 Alias Name = ROWID
2053 Field Name = ROWID
2054 Scale = 0
2055 Charset id = 0
2056 Not Null
2057 Size = 4
2058
2059 SQLType =SQL_VARYING
2060 sub type = 0
2061 Table = TESTDATA
2062 Owner = SYSDBA
2063 Column Name = TITLE
2064 Alias Name = TITLE
2065 Field Name = TITLE
2066 Scale = 0
2067 Charset id = 4
2068 Nullable
2069 Size = 128
2070
2071 SQLType =SQL_TIMESTAMP
2072 sub type = 0
2073 Table = TESTDATA
2074 Owner = SYSDBA
2075 Column Name = DATED
2076 Alias Name = DATED
2077 Field Name = DATED
2078 Scale = 0
2079 Charset id = 0
2080 Nullable
2081 Size = 8
2082
2083 SQLType =SQL_VARYING
2084 sub type = 0
2085 Table = TESTDATA
2086 Owner = SYSDBA
2087 Column Name = NOTES
2088 Alias Name = NOTES
2089 Field Name = NOTES
2090 Scale = 0
2091 Charset id = 4
2092 Nullable
2093 Size = 256
2094
2095 SQLType =SQL_ARRAY
2096 sub type = 0
2097 Table = TESTDATA
2098 Owner = SYSDBA
2099 Column Name = MYARRAY
2100 Alias Name = MYARRAY
2101 Field Name = MYARRAY
2102 Scale = 0
2103 Charset id = 0
2104 Nullable
2105 Size = 8
2106 Array Meta Data:
2107 SQLType =SQL_LONG
2108 Scale = 0
2109 Charset id = 0
2110 Size = 4
2111 Table = TESTDATA
2112 Column = MYARRAY
2113 Dimensions = 1
2114 Bounds: (0:16)
2115
2116 SQL Params
2117 SQLType =SQL_LONG
2118 sub type = 0
2119 Field Name = ROWID
2120 Scale = 0
2121 Charset id = 0
2122 Not Null
2123 Size = 4
2124
2125 SQLType =SQL_VARYING
2126 sub type = 0
2127 Field Name = TITLE
2128 Scale = 0
2129 Charset id = 4
2130 Nullable
2131 Size = 128
2132
2133 SQLType =SQL_TIMESTAMP
2134 sub type = 0
2135 Field Name = DATED
2136 Scale = 0
2137 Charset id = 0
2138 Nullable
2139 Size = 8
2140
2141 SQLType =SQL_VARYING
2142 sub type = 0
2143 Field Name = NOTES
2144 Scale = 0
2145 Charset id = 4
2146 Nullable
2147 Size = 256
2148
2149 Param Name = ROWID
2150 Param Name = TITLE
2151 Param Name = DATED
2152 Param Name = NOTES
2153 ROWID = 1
2154 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2155 DATED = 1/4/2016 09:30:00.100
2156 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2157 MYARRAY = NULL
2158
2159 SQL Params
2160 SQLType =SQL_ARRAY
2161 sub type = 0
2162 Field Name = MYARRAY
2163 Scale = 0
2164 Charset id = 0
2165 Nullable
2166 Size = 8
2167
2168 ROWID = 1
2169 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2170 DATED = 1/4/2016 09:30:00.100
2171 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2172 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)
2173
2174 Shrink to 2:10
2175 Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2176 Write updated reduced slice
2177 Show update array
2178 ROWID = 1
2179 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2180 DATED = 1/4/2016 09:30:00.100
2181 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2182 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)
2183
2184
2185
2186 Running Test 8: Create and read back an Array with 2 dimensions
2187 Metadata
2188 SQLType =SQL_LONG
2189 sub type = 0
2190 Table = TESTDATA
2191 Owner = SYSDBA
2192 Column Name = ROWID
2193 Alias Name = ROWID
2194 Field Name = ROWID
2195 Scale = 0
2196 Charset id = 0
2197 Not Null
2198 Size = 4
2199
2200 SQLType =SQL_VARYING
2201 sub type = 0
2202 Table = TESTDATA
2203 Owner = SYSDBA
2204 Column Name = TITLE
2205 Alias Name = TITLE
2206 Field Name = TITLE
2207 Scale = 0
2208 Charset id = 4
2209 Nullable
2210 Size = 128
2211
2212 SQLType =SQL_ARRAY
2213 sub type = 0
2214 Table = TESTDATA
2215 Owner = SYSDBA
2216 Column Name = MYARRAY
2217 Alias Name = MYARRAY
2218 Field Name = MYARRAY
2219 Scale = 0
2220 Charset id = 4
2221 Nullable
2222 Size = 8
2223 Array Meta Data:
2224 SQLType =SQL_VARYING
2225 Scale = 0
2226 Charset id = 4
2227 Size = 16
2228 Table = TESTDATA
2229 Column = MYARRAY
2230 Dimensions = 2
2231 Bounds: (0:16) (-1:7)
2232
2233 SQL Params
2234 SQLType =SQL_LONG
2235 sub type = 0
2236 Field Name = ROWID
2237 Scale = 0
2238 Charset id = 0
2239 Not Null
2240 Size = 4
2241
2242 SQLType =SQL_VARYING
2243 sub type = 0
2244 Field Name = TITLE
2245 Scale = 0
2246 Charset id = 4
2247 Nullable
2248 Size = 128
2249
2250 ROWID = 1
2251 TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2252 MYARRAY = NULL
2253
2254 ROWID = 1
2255 TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2256 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)
2257
2258
2259
2260 Running Test 9: Database Information tests
2261 Database ID = 4 FB = /opt/firebird2.5.9/examples/empbuild/employee.fdb SN = zeus
2262 Pages =272
2263 Base Level = 13,4,0,3,
2264 Implementation = 11,7,0,3,66,1,66,
2265 Reserved = 0
2266 ODS minor = 2
2267 ODS major = 11
2268 Page Size = 4096
2269 Version = 1: LI-V6.3.9.27139 Firebird 2.5
2270 Database is Read/Write
2271 Database Created: 17/6/2019 19:37:08
2272 Unknown Response 3
2273 Unknown Response 3
2274 Server Memory = 841392
2275 Forced Writes = 1
2276 Max Memory = 879352
2277 Num Buffers = 75
2278 Sweep Interval = 20000
2279 Logged in Users: SYSDBA,
2280 Active Transaction Count = 0
2281 Fetches = 1040
2282 Writes = 6
2283 Reads = 84
2284 Page Writes = 6
2285 Record Version Removals Operation Counts
2286
2287 Deletes Operation Counts
2288
2289 Expunge Count Operation Counts
2290
2291 Insert Count Operation Counts
2292
2293 Purge Count Countites Operation Counts
2294
2295 Indexed Reads Count Operation Counts
2296 Table ID = 2
2297 Count = 14
2298 Table ID = 5
2299 Count = 28
2300 Table ID = 6
2301 Count = 58
2302 Table ID = 11
2303 Count = 3
2304 Table ID = 12
2305 Count = 36
2306 Table ID = 28
2307 Count = 9
2308 Table ID = 29
2309 Count = 7
2310
2311 Sequential Table Scans Operation Counts
2312 Table ID = 0
2313 Count = 88
2314 Table ID = 1
2315 Count = 1
2316
2317 Update Count Operation Counts
2318
2319 Page Size = 4096
2320
2321
2322 Running Test 10: Event Handling
2323 Call Async Wait
2324 Async Wait Called
2325 Event Signalled
2326 First Event - usually ignored
2327 Signal Event
2328 Event Counts: TESTEVENT, Count = 1
2329 Two more events
2330 Call Async Wait
2331 Async Wait Called
2332 Event Signalled
2333 Signal Event
2334 Event Counts: TESTEVENT, Count = 2
2335 Async Wait: Test Cancel
2336 Event Signalled
2337 Async Wait Called
2338 Event Cancelled
2339 Time Out - Cancel Worked!
2340 Sync wait
2341 Event Signalled
2342 Event Counts: TESTEVENT, Count = 2
2343
2344
2345 Running Test 11: Services API
2346 Service Manager Version = 2
2347 Server Version = LI-V2.5.9.27139 Firebird 2.5
2348 Implementation = Firebird/linux AMD64
2349
2350 Lock Directory = /tmp/firebird/
2351 Message File = /opt/firebird2.5.9/
2352 Security File = /opt/firebird2.5.9/security2.fdb
2353
2354 DB Attachments
2355 No. of Attachments = 0
2356 Databases In Use = 0
2357
2358 Sec. Database User
2359 User Name = SYSDBA
2360 First Name = Sql
2361 Middle Name = Server
2362 Last Name = Administrator
2363 User ID = 0
2364 Group ID = 0
2365
2366
2367 Licence Info:
2368 feature is not supported
2369 -feature is not supported
2370
2371 Licence Mask Info:
2372 feature is not supported
2373
2374 Capabilities = 260
2375
2376
2377 Get Limbo transactions
2378
2379 Limbo Transactions
2380
2381
2382 Local Backup
2383
2384
2385
2386 Local Backup Complete
2387
2388 Local Restore
2389
2390
2391
2392
2393
2394
2395 Local Restore Complete
2396
2397 Open Database Check
2398 Database OK
2399 Database Dropped
2400
2401
2402 Running Test 12: Character Sets
2403 SQL Params
2404 SQLType =SQL_LONG
2405 sub type = 0
2406 Field Name = ROWID
2407 Scale = 0
2408 Charset id = 0
2409 Not Null
2410 Size = 4
2411
2412 SQLType =SQL_VARYING
2413 sub type = 0
2414 Field Name = TITLE
2415 Scale = 0
2416 Charset id = 4
2417 Nullable
2418 Size = 128
2419
2420 SQLType =SQL_VARYING
2421 sub type = 0
2422 Field Name = NOTES
2423 Scale = 0
2424 Charset id = 4
2425 Nullable
2426 Size = 256
2427
2428 SQLType =SQL_BLOB
2429 sub type = 1
2430 Field Name = BLOBDATA
2431 Scale = 0
2432 Charset id = 4
2433 Nullable
2434 Size = 8
2435
2436 SQLType =SQL_BLOB
2437 sub type = 1
2438 Field Name = BLOBDATA2
2439 Scale = 0
2440 Charset id = 4
2441 Nullable
2442 Size = 8
2443
2444 SQLType =SQL_VARYING
2445 sub type = 0
2446 Field Name = INCLEAR
2447 Scale = 0
2448 Charset id = 1
2449 Nullable
2450 Size = 16
2451
2452 SQLType =SQL_TEXT
2453 sub type = 0
2454 Field Name = FIXEDWIDTH
2455 Scale = 0
2456 Charset id = 4
2457 Nullable
2458 Size = 16
2459
2460 Connection Character Set UTF8
2461 ROWID = 1
2462 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2463 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2464 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)
2465 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)
2466 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2467 FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001 Byte Length = 5)
2468
2469 Connection Character Set NONE
2470 ROWID = 1
2471 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2472 NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591 Byte Length = 10)
2473 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)
2474 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)
2475 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2476 FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001 Byte Length = 5)
2477
2478 Connection Character Set WIN1252
2479 ROWID = 1
2480 TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252 Byte Length = 12)
2481 NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252 Byte Length = 10)
2482 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)
2483 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)
2484 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2485 FIXEDWIDTH = C9 (Charset Id = 53 Codepage = 1252 Byte Length = 4)
2486
2487
2488
2489 Running Test 13: Transaction over two databases
2490 Init Database 1
2491 ROWID = 1
2492 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2493 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2494 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)
2495 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)
2496 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2497
2498 Init Database 2
2499 ROWID = 1
2500 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2501 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2502 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)
2503 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)
2504 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2505
2506 ROWID = 1
2507 TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001 Byte Length = 9)
2508 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2509 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)
2510 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)
2511 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2512
2513 ROWID = 1
2514 TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001 Byte Length = 9)
2515 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2516 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)
2517 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)
2518 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2519
2520
2521
2522 Running Test 14: Non select procedures
2523 Default Character set Name = UTF8
2524 Metadata
2525 SQLType =SQL_LONG
2526 sub type = 0
2527 Table = SHOWDATA
2528 Owner = SYSDBA
2529 Column Name = ROWID
2530 Alias Name = ROWID
2531 Field Name = ROWID
2532 Scale = 0
2533 Charset id = 0
2534 Nullable
2535 Size = 4
2536
2537 SQLType =SQL_VARYING
2538 sub type = 0
2539 Table = SHOWDATA
2540 Owner = SYSDBA
2541 Column Name = TITLE
2542 Alias Name = TITLE
2543 Field Name = TITLE
2544 Scale = 0
2545 Charset id = 4
2546 Nullable
2547 Size = 128
2548
2549 ROWID = 1
2550 TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
2551
2552 Repeat with a different execute transaction
2553
2554 ROWID = 1
2555 TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
2556
2557 Repeat with a original transaction
2558
2559 ROWID = 1
2560 TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
2561
2562
2563 Running Test 15: Blob Handling and BPBs
2564
2565 Testdata
2566
2567 ROWID = 1
2568 TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
2569 BLOBDATA = (blob), Length = 92514
2570
2571
2572 Testdata 2
2573
2574 ROWID = 1
2575 TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
2576 BLOBDATA (Charset Id = 4 Codepage = 65001)
2577
2578 Écoute moi
2579
2580
2581
2582 Running Test 16: Error handling
2583 Invalid Database Name Test
2584 Error Handled:
2585 I/O error during "open" operation for file "Malformed Name"
2586 -Error while trying to open file
2587 -No such file or directory
2588 Invalid User Name Test
2589 Error Handled:
2590 Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2591 Invalid password Test
2592 Error Handled:
2593 Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2594 Invalid Prepare SQL Test
2595 Error Handled:
2596 Dynamic SQL Error
2597 -SQL error code = -206
2598 -Column unknown
2599 -UNKNOWN_DATE
2600 -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
2601 Invalid Open Cursor SQL Test
2602 Error Handled:
2603 Dynamic SQL Error
2604 -SQL error code = -206
2605 -Column unknown
2606 -X
2607 -At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE
2608 Transaction not started Test
2609 Error Handled: Transaction is not active
2610 Invalid Param SQL Type Test
2611 Error Handled: Field "EMP_NO" not found
2612 Case sensitive Param SQL Test
2613 Error Handled: Field "EMP_NO" not found
2614 Invalid Server Name Test
2615 Error Handled:
2616 Unable to complete network request to host "unknown".
2617 -Failed to locate host machine
2618 Invalid User Name Test
2619 Error Handled:
2620 Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2621 Invalid password Test
2622 Error Handled:
2623 Your user name and password are not defined. Ask your database administrator to set up a Firebird login
2624
2625
2626 Test Suite Ends