ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/testsuite/reference.log
Revision: 70
Committed: Thu Oct 26 12:59:51 2017 UTC (6 years, 5 months ago) by tony
File size: 50013 byte(s)
Log Message:
FBAttachment: Avoid string reference count error when processing an Ansistring
    parameter in an array of const passed to IAttachment.OpenCursor, etc.

FBAttachment: Allow for WideString and UnicodeString parameters in an array
    of const passed to IAttachment.OpenCursor, etc.

File Contents

# Content
1 Firebird API Test Suite
2 Copyright MWA Software 2016
3
4 Starting Tests
5 Client API Version = 3.768
6 Running Test 1: Create and Drop a Database
7 Creating a Database with empty parameters
8 Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
9 Error while trying to create file
10 No such file or directory
11 Creating a Database using an SQL Statement
12 Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = mint18-FB3
13 SQL Dialect = 3
14 Dropping Database
15 Creating a Database with a DPD
16 Dropping Database
17 DPB
18 Count = 4
19 28 = SYSDBA
20 29 = masterkey
21 48 = UTF8
22 65 = 3
23
24 Creating a Database with a DPD
25 Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = mint18-FB3
26 ODS major = 12
27 ODS minor = 0
28 RDB$DESCRIPTION =
29 RDB$RELATION_ID = 128
30 RDB$SECURITY_CLASS = SQL$363
31 RDB$CHARACTER_SET_NAME = UTF8
32 RDB$LINGER =
33 Dropping Database
34
35
36 Running Test 2: Open the employee database and run a query
37 Opening localhost:employee
38 Database Open
39 Metadata
40 SQLType =SQL_SHORT
41 sub type = 0
42 Table = EMPLOYEE
43 Owner = SYSDBA
44 Column Name = EMP_NO
45 Alias Name = EMP_NO
46 Field Name = EMP_NO
47 Scale = 0
48 Charset id = 0
49 Not Null
50 Size = 2
51
52 SQLType =SQL_VARYING
53 sub type = 0
54 Table = EMPLOYEE
55 Owner = SYSDBA
56 Column Name = FIRST_NAME
57 Alias Name = FIRST_NAME
58 Field Name = FIRST_NAME
59 Scale = 0
60 Charset id = 0
61 Not Null
62 Size = 15
63
64 SQLType =SQL_VARYING
65 sub type = 0
66 Table = EMPLOYEE
67 Owner = SYSDBA
68 Column Name = LAST_NAME
69 Alias Name = LAST_NAME
70 Field Name = LAST_NAME
71 Scale = 0
72 Charset id = 0
73 Not Null
74 Size = 20
75
76 SQLType =SQL_VARYING
77 sub type = 0
78 Table = EMPLOYEE
79 Owner = SYSDBA
80 Column Name = PHONE_EXT
81 Alias Name = PHONE_EXT
82 Field Name = PHONE_EXT
83 Scale = 0
84 Charset id = 0
85 Nullable
86 Size = 4
87
88 SQLType =SQL_TIMESTAMP
89 sub type = 0
90 Table = EMPLOYEE
91 Owner = SYSDBA
92 Column Name = HIRE_DATE
93 Alias Name = HIRE_DATE
94 Field Name = HIRE_DATE
95 Scale = 0
96 Charset id = 0
97 Not Null
98 Size = 8
99
100 SQLType =SQL_TEXT
101 sub type = 0
102 Table = EMPLOYEE
103 Owner = SYSDBA
104 Column Name = DEPT_NO
105 Alias Name = DEPT_NO
106 Field Name = DEPT_NO
107 Scale = 0
108 Charset id = 0
109 Not Null
110 Size = 3
111
112 SQLType =SQL_VARYING
113 sub type = 0
114 Table = EMPLOYEE
115 Owner = SYSDBA
116 Column Name = JOB_CODE
117 Alias Name = JOB_CODE
118 Field Name = JOB_CODE
119 Scale = 0
120 Charset id = 0
121 Not Null
122 Size = 5
123
124 SQLType =SQL_SHORT
125 sub type = 0
126 Table = EMPLOYEE
127 Owner = SYSDBA
128 Column Name = JOB_GRADE
129 Alias Name = JOB_GRADE
130 Field Name = JOB_GRADE
131 Scale = 0
132 Charset id = 0
133 Not Null
134 Size = 2
135
136 SQLType =SQL_VARYING
137 sub type = 0
138 Table = EMPLOYEE
139 Owner = SYSDBA
140 Column Name = JOB_COUNTRY
141 Alias Name = JOB_COUNTRY
142 Field Name = JOB_COUNTRY
143 Scale = 0
144 Charset id = 0
145 Not Null
146 Size = 15
147
148 SQLType =SQL_INT64
149 sub type = 0
150 Table = EMPLOYEE
151 Owner = SYSDBA
152 Column Name = SALARY
153 Alias Name = SALARY
154 Field Name = SALARY
155 Scale = -2
156 Charset id = 0
157 Not Null
158 Size = 8
159
160 SQLType =SQL_VARYING
161 sub type = 0
162 Table = EMPLOYEE
163 Owner = SYSDBA
164 Column Name = FULL_NAME
165 Alias Name = FULL_NAME
166 Field Name = FULL_NAME
167 Scale = 0
168 Charset id = 0
169 Nullable
170 Size = 37
171
172 Plan =
173 Select Expression
174 -> First N Records
175 -> Table "EMPLOYEE" Full Scan
176 Select First 3 * from EMPLOYEE
177
178 EMP_NO = 2
179 FIRST_NAME = Robert
180 LAST_NAME = Nelson
181 PHONE_EXT = 250
182 HIRE_DATE = 28/12/1988 00:00:00.000
183 DEPT_NO = 600
184 JOB_CODE = VP
185 JOB_GRADE = 2
186 JOB_COUNTRY = USA
187 SALARY = 105,900.00
188 FULL_NAME = Nelson, Robert
189 EMP_NO = 4
190 FIRST_NAME = Bruce
191 LAST_NAME = Young
192 PHONE_EXT = 233
193 HIRE_DATE = 28/12/1988 00:00:00.000
194 DEPT_NO = 621
195 JOB_CODE = Eng
196 JOB_GRADE = 2
197 JOB_COUNTRY = USA
198 SALARY = 97,500.00
199 FULL_NAME = Young, Bruce
200 EMP_NO = 5
201 FIRST_NAME = Kim
202 LAST_NAME = Lambert
203 PHONE_EXT = 22
204 HIRE_DATE = 6/2/1989 00:00:00.000
205 DEPT_NO = 130
206 JOB_CODE = Eng
207 JOB_GRADE = 2
208 JOB_COUNTRY = USA
209 SALARY = 102,750.00
210 FULL_NAME = Lambert, Kim
211
212 Select * from EMPLOYEE Where EMP_NO = ?
213 SQL Params
214 SQLType =SQL_SHORT
215 sub type = 0
216 Field Name =
217 Scale = 0
218 Charset id = 0
219 Not Null
220 Size = 2
221
222 EMP_NO = 8
223 FIRST_NAME = Leslie
224 LAST_NAME = Johnson
225 PHONE_EXT = 410
226 HIRE_DATE = 5/4/1989 00:00:00.000
227 DEPT_NO = 180
228 JOB_CODE = Mktg
229 JOB_GRADE = 3
230 JOB_COUNTRY = USA
231 SALARY = 64,635.00
232 FULL_NAME = Johnson, Leslie
233
234 With param names
235 Select * from EMPLOYEE Where EMP_NO = :EMP_NO
236 SQL Params
237 SQLType =SQL_SHORT
238 sub type = 0
239 Field Name = EMP_NO
240 Scale = 0
241 Charset id = 0
242 Not Null
243 Size = 2
244
245 EMP_NO = 8
246 FIRST_NAME = Leslie
247 LAST_NAME = Johnson
248 PHONE_EXT = 410
249 HIRE_DATE = 5/4/1989 00:00:00.000
250 DEPT_NO = 180
251 JOB_CODE = Mktg
252 JOB_GRADE = 3
253 JOB_COUNTRY = USA
254 SALARY = 64,635.00
255 FULL_NAME = Johnson, Leslie
256
257
258
259 Running Test 3: ad hoc queries
260 Opening localhost:employee
261 Database Open
262 Employee Count = 42
263 Employee Count = 41
264 Employee Count = 42
265 Employee Count = 41
266 Employee Count = 42
267 Constrained Employee Count = 3
268 "Johnson" Employee Count = 2
269 "Yanowski" Employee Count = 1
270
271
272 Running Test 4: Update, Insert and Delete Queries
273 Opening localhost:employee
274 Database Open
275 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
276 EMP_NO = 8
277 FIRST_NAME = Leslie
278 LAST_NAME = Johnson
279 PHONE_EXT = 410
280 HIRE_DATE = 5/4/1989 00:00:00.000
281 DEPT_NO = 180
282 JOB_CODE = Mktg
283 JOB_GRADE = 3
284 JOB_COUNTRY = USA
285 SALARY = 64,635.00
286 FULL_NAME = Johnson, Leslie
287
288 Current memory = 1.959857600000000000E+0007
289 Delta memory = 2.952000000000000000E+0003
290 Max memory = 1.966170400000000000E+0007
291 Elapsed time= 0.007 sec
292 Cpu = 0.000 sec
293 Buffers = 2.048000000000000000E+0003
294 Reads = 0.000000000000000000E+0000
295 Writes = 0.000000000000000000E+0000
296 Fetches = 2.000000000000000000E+0000
297 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
298 Relation Name = EMPLOYEE
299 Metadata
300 SQLType =SQL_SHORT
301 sub type = 0
302 Table = EMPLOYEE
303 Owner = SYSDBA
304 Column Name = EMP_NO
305 Alias Name = EMP_NO
306 Field Name = EMP_NO
307 Scale = 0
308 Charset id = 0
309 Not Null
310 Size = 2
311
312 SQLType =SQL_VARYING
313 sub type = 0
314 Table = EMPLOYEE
315 Owner = SYSDBA
316 Column Name = FIRST_NAME
317 Alias Name = FIRST_NAME
318 Field Name = FIRST_NAME
319 Scale = 0
320 Charset id = 0
321 Not Null
322 Size = 15
323
324 SQLType =SQL_VARYING
325 sub type = 0
326 Table = EMPLOYEE
327 Owner = SYSDBA
328 Column Name = LAST_NAME
329 Alias Name = LAST_NAME
330 Field Name = LAST_NAME
331 Scale = 0
332 Charset id = 0
333 Not Null
334 Size = 20
335
336 SQLType =SQL_VARYING
337 sub type = 0
338 Table = EMPLOYEE
339 Owner = SYSDBA
340 Column Name = PHONE_EXT
341 Alias Name = PHONE_EXT
342 Field Name = PHONE_EXT
343 Scale = 0
344 Charset id = 0
345 Nullable
346 Size = 4
347
348 SQLType =SQL_TIMESTAMP
349 sub type = 0
350 Table = EMPLOYEE
351 Owner = SYSDBA
352 Column Name = HIRE_DATE
353 Alias Name = HIRE_DATE
354 Field Name = HIRE_DATE
355 Scale = 0
356 Charset id = 0
357 Not Null
358 Size = 8
359
360 SQLType =SQL_TEXT
361 sub type = 0
362 Table = EMPLOYEE
363 Owner = SYSDBA
364 Column Name = DEPT_NO
365 Alias Name = DEPT_NO
366 Field Name = DEPT_NO
367 Scale = 0
368 Charset id = 0
369 Not Null
370 Size = 3
371
372 SQLType =SQL_VARYING
373 sub type = 0
374 Table = EMPLOYEE
375 Owner = SYSDBA
376 Column Name = JOB_CODE
377 Alias Name = JOB_CODE
378 Field Name = JOB_CODE
379 Scale = 0
380 Charset id = 0
381 Not Null
382 Size = 5
383
384 SQLType =SQL_SHORT
385 sub type = 0
386 Table = EMPLOYEE
387 Owner = SYSDBA
388 Column Name = JOB_GRADE
389 Alias Name = JOB_GRADE
390 Field Name = JOB_GRADE
391 Scale = 0
392 Charset id = 0
393 Not Null
394 Size = 2
395
396 SQLType =SQL_VARYING
397 sub type = 0
398 Table = EMPLOYEE
399 Owner = SYSDBA
400 Column Name = JOB_COUNTRY
401 Alias Name = JOB_COUNTRY
402 Field Name = JOB_COUNTRY
403 Scale = 0
404 Charset id = 0
405 Not Null
406 Size = 15
407
408 SQLType =SQL_INT64
409 sub type = 0
410 Table = EMPLOYEE
411 Owner = SYSDBA
412 Column Name = SALARY
413 Alias Name = SALARY
414 Field Name = SALARY
415 Scale = -2
416 Charset id = 0
417 Not Null
418 Size = 8
419
420 SQLType =SQL_VARYING
421 sub type = 0
422 Table = EMPLOYEE
423 Owner = SYSDBA
424 Column Name = FULL_NAME
425 Alias Name = FULL_NAME
426 Field Name = FULL_NAME
427 Scale = 0
428 Charset id = 0
429 Nullable
430 Size = 37
431
432 EMP_NO = 150
433 FIRST_NAME = John
434 LAST_NAME = Doe
435 PHONE_EXT =
436 HIRE_DATE = 1/4/2015 00:00:00.000
437 DEPT_NO = 600
438 JOB_CODE = Eng
439 JOB_GRADE = 4
440 JOB_COUNTRY = England
441 SALARY = 41,000.89
442 FULL_NAME = Doe, John
443
444 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
445 EMP_NO = 151
446 FIRST_NAME = Major
447 LAST_NAME = Major
448 PHONE_EXT =
449 HIRE_DATE = 1/4/2015 00:00:00.000
450 DEPT_NO = 600
451 JOB_CODE = Eng
452 JOB_GRADE = 4
453 JOB_COUNTRY = England
454 SALARY = 40,000.59
455 FULL_NAME = Major, Major
456
457 Now Delete the rows
458 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
459 Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 1
460 Inserting
461 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
462 EMP_NO = 150
463 FIRST_NAME = Jane
464 LAST_NAME = Doe
465 PHONE_EXT = NULL
466 HIRE_DATE = 1/4/2015 00:00:00.000
467 DEPT_NO = 600
468 JOB_CODE = Eng
469 JOB_GRADE = 4
470 JOB_COUNTRY = England
471 SALARY = 41,000.89
472 FULL_NAME = Doe, Jane
473
474 Employee Count = 43
475 Prepare Query again
476
477 EMP_NO = 150
478 FIRST_NAME = Jane
479 LAST_NAME = Doe
480 PHONE_EXT = NULL
481 HIRE_DATE = 1/4/2015 00:00:00.000
482 DEPT_NO = 600
483 JOB_CODE = Eng
484 JOB_GRADE = 4
485 JOB_COUNTRY = England
486 SALARY = 41,000.89
487 FULL_NAME = Doe, Jane
488
489 Prepare Query again with a different transaction
490
491 EMP_NO = 8
492 FIRST_NAME = Leslie
493 LAST_NAME = Johnson
494 PHONE_EXT = 410
495 HIRE_DATE = 5/4/1989 00:00:00.000
496 DEPT_NO = 180
497 JOB_CODE = Mktg
498 JOB_GRADE = 3
499 JOB_COUNTRY = USA
500 SALARY = 64,635.00
501 FULL_NAME = Johnson, Leslie
502
503 Open Cursor with a different transaction
504
505 EMP_NO = 8
506 FIRST_NAME = Leslie
507 LAST_NAME = Johnson
508 PHONE_EXT = 410
509 HIRE_DATE = 5/4/1989 00:00:00.000
510 DEPT_NO = 180
511 JOB_CODE = Mktg
512 JOB_GRADE = 3
513 JOB_COUNTRY = USA
514 SALARY = 64,635.00
515 FULL_NAME = Johnson, Leslie
516 Same Statement - updated params
517 EMP_NO = 9
518 FIRST_NAME = Phil
519 LAST_NAME = Forest
520 PHONE_EXT = 229
521 HIRE_DATE = 17/4/1989 00:00:00.000
522 DEPT_NO = 622
523 JOB_CODE = Mngr
524 JOB_GRADE = 3
525 JOB_COUNTRY = USA
526 SALARY = 75,060.00
527 FULL_NAME = Forest, Phil
528
529
530
531 Running Test 5: Update Returning and Activity Check
532 Opening localhost:employee
533 Database Open
534 Database Closed
535 Database Open
536 Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
537 Last Name = Johnson
538 EMP_NO = 8
539 FIRST_NAME = Leslie
540 LAST_NAME = Johnson
541 PHONE_EXT = 410
542 HIRE_DATE = 31/1/2016 00:00:00.000
543 DEPT_NO = 180
544 JOB_CODE = Mktg
545 JOB_GRADE = 3
546 JOB_COUNTRY = USA
547 SALARY = 64,635.00
548 FULL_NAME = Johnson, Leslie
549
550 Inserting
551 Full Name = Doe, John
552 Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
553 Database Activity = TRUE
554 Transaction Activity = TRUE
555 Database Activity = FALSE
556 Transaction Activity = FALSE
557 Employee Count = 43
558 Database Activity = TRUE
559 Transaction Activity = TRUE
560 Transaction Active
561 Transaction inactive
562
563
564 Running Test 6: Blob Handling
565 Metadata
566 SQLType =SQL_TEXT
567 sub type = 0
568 Table = RDB$CHARACTER_SETS
569 Owner = SYSDBA
570 Column Name = RDB$CHARACTER_SET_NAME
571 Alias Name = RDB$CHARACTER_SET_NAME
572 Field Name = RDB$CHARACTER_SET_NAME
573 Scale = 0
574 Charset id = 4
575 Nullable
576 Size = 124
577
578 SQLType =SQL_SHORT
579 sub type = 0
580 Table = RDB$CHARACTER_SETS
581 Owner = SYSDBA
582 Column Name = RDB$CHARACTER_SET_ID
583 Alias Name = RDB$CHARACTER_SET_ID
584 Field Name = RDB$CHARACTER_SET_ID
585 Scale = 0
586 Charset id = 0
587 Nullable
588 Size = 2
589
590 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
591 RDB$CHARACTER_SET_ID = 0
592 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
593 RDB$CHARACTER_SET_ID = 1
594 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
595 RDB$CHARACTER_SET_ID = 2
596 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
597 RDB$CHARACTER_SET_ID = 3
598 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
599 RDB$CHARACTER_SET_ID = 4
600 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
601 RDB$CHARACTER_SET_ID = 5
602 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
603 RDB$CHARACTER_SET_ID = 6
604 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
605 RDB$CHARACTER_SET_ID = 9
606 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
607 RDB$CHARACTER_SET_ID = 10
608 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
609 RDB$CHARACTER_SET_ID = 11
610 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
611 RDB$CHARACTER_SET_ID = 12
612 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
613 RDB$CHARACTER_SET_ID = 13
614 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
615 RDB$CHARACTER_SET_ID = 14
616 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
617 RDB$CHARACTER_SET_ID = 15
618 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
619 RDB$CHARACTER_SET_ID = 16
620 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
621 RDB$CHARACTER_SET_ID = 17
622 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
623 RDB$CHARACTER_SET_ID = 18
624 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
625 RDB$CHARACTER_SET_ID = 19
626 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
627 RDB$CHARACTER_SET_ID = 21
628 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
629 RDB$CHARACTER_SET_ID = 22
630 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
631 RDB$CHARACTER_SET_ID = 23
632 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
633 RDB$CHARACTER_SET_ID = 34
634 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
635 RDB$CHARACTER_SET_ID = 35
636 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
637 RDB$CHARACTER_SET_ID = 36
638 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
639 RDB$CHARACTER_SET_ID = 37
640 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
641 RDB$CHARACTER_SET_ID = 38
642 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
643 RDB$CHARACTER_SET_ID = 39
644 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
645 RDB$CHARACTER_SET_ID = 40
646 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
647 RDB$CHARACTER_SET_ID = 44
648 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
649 RDB$CHARACTER_SET_ID = 45
650 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
651 RDB$CHARACTER_SET_ID = 46
652 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
653 RDB$CHARACTER_SET_ID = 47
654 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
655 RDB$CHARACTER_SET_ID = 48
656 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
657 RDB$CHARACTER_SET_ID = 49
658 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
659 RDB$CHARACTER_SET_ID = 50
660 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
661 RDB$CHARACTER_SET_ID = 51
662 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
663 RDB$CHARACTER_SET_ID = 52
664 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
665 RDB$CHARACTER_SET_ID = 53
666 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
667 RDB$CHARACTER_SET_ID = 54
668 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
669 RDB$CHARACTER_SET_ID = 55
670 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
671 RDB$CHARACTER_SET_ID = 56
672 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
673 RDB$CHARACTER_SET_ID = 57
674 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
675 RDB$CHARACTER_SET_ID = 58
676 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
677 RDB$CHARACTER_SET_ID = 59
678 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
679 RDB$CHARACTER_SET_ID = 60
680 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
681 RDB$CHARACTER_SET_ID = 63
682 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
683 RDB$CHARACTER_SET_ID = 64
684 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
685 RDB$CHARACTER_SET_ID = 65
686 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
687 RDB$CHARACTER_SET_ID = 66
688 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
689 RDB$CHARACTER_SET_ID = 67
690 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
691 RDB$CHARACTER_SET_ID = 68
692 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
693 RDB$CHARACTER_SET_ID = 69
694
695 Metadata
696 SQLType =SQL_LONG
697 sub type = 0
698 Table = TESTDATA
699 Owner = SYSDBA
700 Column Name = ROWID
701 Alias Name = ROWID
702 Field Name = ROWID
703 Scale = 0
704 Charset id = 0
705 Not Null
706 Size = 4
707
708 SQLType =SQL_LONG
709 sub type = 0
710 Table = TESTDATA
711 Owner = SYSDBA
712 Column Name = FIXEDPOINT
713 Alias Name = FIXEDPOINT
714 Field Name = FIXEDPOINT
715 Scale = -2
716 Charset id = 0
717 Nullable
718 Size = 4
719
720 SQLType =SQL_DOUBLE
721 sub type = 0
722 Table = TESTDATA
723 Owner = SYSDBA
724 Column Name = FLOATINGPOINT
725 Alias Name = FLOATINGPOINT
726 Field Name = FLOATINGPOINT
727 Scale = 0
728 Charset id = 0
729 Nullable
730 Size = 8
731
732 SQLType =SQL_VARYING
733 sub type = 0
734 Table = TESTDATA
735 Owner = SYSDBA
736 Column Name = TITLE
737 Alias Name = TITLE
738 Field Name = TITLE
739 Scale = 0
740 Charset id = 4
741 Nullable
742 Size = 128
743
744 SQLType =SQL_BLOB
745 sub type = 1
746 Table = TESTDATA
747 Owner = SYSDBA
748 Column Name = BLOBDATA
749 Alias Name = BLOBDATA
750 Field Name = BLOBDATA
751 Scale = 0
752 Charset id = 4
753 Nullable
754 Size = 8
755
756 Blob Meta Data
757 SQL SubType =1
758 Table = TESTDATA
759 Column = BLOBDATA
760 CharSetID = 4
761 Segment Size = 80
762
763
764 SQL Params
765 SQLType =SQL_LONG
766 sub type = 0
767 Field Name = ROWID
768 Scale = 0
769 Charset id = 0
770 Not Null
771 Size = 4
772
773 SQLType =SQL_VARYING
774 sub type = 0
775 Field Name = TITLE
776 Scale = 0
777 Charset id = 4
778 Nullable
779 Size = 128
780
781 SQLType =SQL_LONG
782 sub type = 0
783 Field Name = FP
784 Scale = -2
785 Charset id = 0
786 Nullable
787 Size = 4
788
789 SQLType =SQL_DOUBLE
790 sub type = 0
791 Field Name = DP
792 Scale = 0
793 Charset id = 0
794 Nullable
795 Size = 8
796
797 ROWID = 1
798 FIXEDPOINT = 20.28
799 FLOATINGPOINT = 3.14
800 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
801 BLOBDATA = NULL
802
803 SQL Params
804 SQLType =SQL_BLOB
805 sub type = 1
806 Field Name =
807 Scale = 0
808 Charset id = 4
809 Nullable
810 Size = 8
811
812 SQLType =SQL_LONG
813 sub type = 0
814 Field Name =
815 Scale = 0
816 Charset id = 0
817 Not Null
818 Size = 4
819
820 ROWID = 1
821 FIXEDPOINT = 20.28
822 FLOATINGPOINT = 3.14
823 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
824 BLOBDATA (Charset Id = 4 Codepage = 65001)
825
826 To be or not to be-that is the question:
827 Whether 'tis nobler in the mind to suffer
828 The slings and arrows of outrageous fortune,
829 Or to take arms against a sea of troubles,
830 And, by opposing, end them. To die, to sleep-
831 No more-and by a sleep to say we end
832 The heartache and the thousand natural shocks
833 That flesh is heir to-'tis a consummation
834 Devoutly to be wished. To die, to sleep-
835 To sleep, perchance to dream. Aye, there's the rub,
836 For in that sleep of death what dreams may come,
837 When we have shuffled off this mortal coil,
838 Must give us pause. There's the respect
839 That makes calamity of so long life.
840 For who would bear the whips and scorns of time,
841 Th' oppressor's wrong, the proud man's contumely,
842 The pangs of despised love, the law’s delay,
843 The insolence of office, and the spurns
844 That patient merit of the unworthy takes,
845 When he himself might his quietus make
846 With a bare bodkin? Who would fardels bear,
847 To grunt and sweat under a weary life,
848 But that the dread of something after death,
849 The undiscovered country from whose bourn
850 No traveler returns, puzzles the will
851 And makes us rather bear those ills we have
852 Than fly to others that we know not of?
853 Thus conscience does make cowards of us all,
854 And thus the native hue of resolution
855 Is sicklied o'er with the pale cast of thought,
856 And enterprises of great pitch and moment,
857 With this regard their currents turn awry,
858 And lose the name of action.-Soft you now,
859 The fair Ophelia.-Nymph, in thy orisons
860 Be all my sins remembered
861
862
863 SQL Params
864 SQLType =SQL_LONG
865 sub type = 0
866 Field Name = ROWID
867 Scale = 0
868 Charset id = 0
869 Not Null
870 Size = 4
871
872 SQLType =SQL_VARYING
873 sub type = 0
874 Field Name = TITLE
875 Scale = 0
876 Charset id = 4
877 Nullable
878 Size = 128
879
880 SQLType =SQL_LONG
881 sub type = 0
882 Field Name = FP
883 Scale = -2
884 Charset id = 0
885 Nullable
886 Size = 4
887
888 SQLType =SQL_DOUBLE
889 sub type = 0
890 Field Name = DP
891 Scale = 0
892 Charset id = 0
893 Nullable
894 Size = 8
895
896 ROWID = 1
897 FIXEDPOINT = 20.28
898 FLOATINGPOINT = 3.14
899 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
900 BLOBDATA (Charset Id = 4 Codepage = 65001)
901
902 To be or not to be-that is the question:
903 Whether 'tis nobler in the mind to suffer
904 The slings and arrows of outrageous fortune,
905 Or to take arms against a sea of troubles,
906 And, by opposing, end them. To die, to sleep-
907 No more-and by a sleep to say we end
908 The heartache and the thousand natural shocks
909 That flesh is heir to-'tis a consummation
910 Devoutly to be wished. To die, to sleep-
911 To sleep, perchance to dream. Aye, there's the rub,
912 For in that sleep of death what dreams may come,
913 When we have shuffled off this mortal coil,
914 Must give us pause. There's the respect
915 That makes calamity of so long life.
916 For who would bear the whips and scorns of time,
917 Th' oppressor's wrong, the proud man's contumely,
918 The pangs of despised love, the law’s delay,
919 The insolence of office, and the spurns
920 That patient merit of the unworthy takes,
921 When he himself might his quietus make
922 With a bare bodkin? Who would fardels bear,
923 To grunt and sweat under a weary life,
924 But that the dread of something after death,
925 The undiscovered country from whose bourn
926 No traveler returns, puzzles the will
927 And makes us rather bear those ills we have
928 Than fly to others that we know not of?
929 Thus conscience does make cowards of us all,
930 And thus the native hue of resolution
931 Is sicklied o'er with the pale cast of thought,
932 And enterprises of great pitch and moment,
933 With this regard their currents turn awry,
934 And lose the name of action.-Soft you now,
935 The fair Ophelia.-Nymph, in thy orisons
936 Be all my sins remembered
937
938 ROWID = 2
939 FIXEDPOINT = NULL
940 FLOATINGPOINT = NULL
941 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
942 BLOBDATA (Charset Id = 4 Codepage = 65001)
943
944 To be or not to be-that is the question:
945 Whether 'tis nobler in the mind to suffer
946 The slings and arrows of outrageous fortune,
947 Or to take arms against a sea of troubles,
948 And, by opposing, end them. To die, to sleep-
949 No more-and by a sleep to say we end
950 The heartache and the thousand natural shocks
951 That flesh is heir to-'tis a consummation
952 Devoutly to be wished. To die, to sleep-
953 To sleep, perchance to dream. Aye, there's the rub,
954 For in that sleep of death what dreams may come,
955 When we have shuffled off this mortal coil,
956 Must give us pause. There's the respect
957 That makes calamity of so long life.
958 For who would bear the whips and scorns of time,
959 Th' oppressor's wrong, the proud man's contumely,
960 The pangs of despised love, the law’s delay,
961 The insolence of office, and the spurns
962 That patient merit of the unworthy takes,
963 When he himself might his quietus make
964 With a bare bodkin? Who would fardels bear,
965 To grunt and sweat under a weary life,
966 But that the dread of something after death,
967 The undiscovered country from whose bourn
968 No traveler returns, puzzles the will
969 And makes us rather bear those ills we have
970 Than fly to others that we know not of?
971 Thus conscience does make cowards of us all,
972 And thus the native hue of resolution
973 Is sicklied o'er with the pale cast of thought,
974 And enterprises of great pitch and moment,
975 With this regard their currents turn awry,
976 And lose the name of action.-Soft you now,
977 The fair Ophelia.-Nymph, in thy orisons
978 Be all my sins remembered
979
980
981 Metadata
982 SQLType =SQL_TEXT
983 sub type = 0
984 Table = RDB$CHARACTER_SETS
985 Owner = SYSDBA
986 Column Name = RDB$CHARACTER_SET_NAME
987 Alias Name = RDB$CHARACTER_SET_NAME
988 Field Name = RDB$CHARACTER_SET_NAME
989 Scale = 0
990 Charset id = 3
991 Nullable
992 Size = 93
993
994 SQLType =SQL_SHORT
995 sub type = 0
996 Table = RDB$CHARACTER_SETS
997 Owner = SYSDBA
998 Column Name = RDB$CHARACTER_SET_ID
999 Alias Name = RDB$CHARACTER_SET_ID
1000 Field Name = RDB$CHARACTER_SET_ID
1001 Scale = 0
1002 Charset id = 0
1003 Nullable
1004 Size = 2
1005
1006 RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1007 RDB$CHARACTER_SET_ID = 0
1008 RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1009 RDB$CHARACTER_SET_ID = 1
1010 RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1011 RDB$CHARACTER_SET_ID = 2
1012 RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1013 RDB$CHARACTER_SET_ID = 3
1014 RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1015 RDB$CHARACTER_SET_ID = 4
1016 RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1017 RDB$CHARACTER_SET_ID = 5
1018 RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1019 RDB$CHARACTER_SET_ID = 6
1020 RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1021 RDB$CHARACTER_SET_ID = 9
1022 RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1023 RDB$CHARACTER_SET_ID = 10
1024 RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1025 RDB$CHARACTER_SET_ID = 11
1026 RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1027 RDB$CHARACTER_SET_ID = 12
1028 RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1029 RDB$CHARACTER_SET_ID = 13
1030 RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1031 RDB$CHARACTER_SET_ID = 14
1032 RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1033 RDB$CHARACTER_SET_ID = 15
1034 RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1035 RDB$CHARACTER_SET_ID = 16
1036 RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
1037 RDB$CHARACTER_SET_ID = 17
1038 RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
1039 RDB$CHARACTER_SET_ID = 18
1040 RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
1041 RDB$CHARACTER_SET_ID = 19
1042 RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
1043 RDB$CHARACTER_SET_ID = 21
1044 RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
1045 RDB$CHARACTER_SET_ID = 22
1046 RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
1047 RDB$CHARACTER_SET_ID = 23
1048 RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
1049 RDB$CHARACTER_SET_ID = 34
1050 RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
1051 RDB$CHARACTER_SET_ID = 35
1052 RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
1053 RDB$CHARACTER_SET_ID = 36
1054 RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
1055 RDB$CHARACTER_SET_ID = 37
1056 RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
1057 RDB$CHARACTER_SET_ID = 38
1058 RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
1059 RDB$CHARACTER_SET_ID = 39
1060 RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
1061 RDB$CHARACTER_SET_ID = 40
1062 RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
1063 RDB$CHARACTER_SET_ID = 44
1064 RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
1065 RDB$CHARACTER_SET_ID = 45
1066 RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
1067 RDB$CHARACTER_SET_ID = 46
1068 RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
1069 RDB$CHARACTER_SET_ID = 47
1070 RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
1071 RDB$CHARACTER_SET_ID = 48
1072 RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
1073 RDB$CHARACTER_SET_ID = 49
1074 RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
1075 RDB$CHARACTER_SET_ID = 50
1076 RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
1077 RDB$CHARACTER_SET_ID = 51
1078 RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
1079 RDB$CHARACTER_SET_ID = 52
1080 RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
1081 RDB$CHARACTER_SET_ID = 53
1082 RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
1083 RDB$CHARACTER_SET_ID = 54
1084 RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
1085 RDB$CHARACTER_SET_ID = 55
1086 RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
1087 RDB$CHARACTER_SET_ID = 56
1088 RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
1089 RDB$CHARACTER_SET_ID = 57
1090 RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
1091 RDB$CHARACTER_SET_ID = 58
1092 RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
1093 RDB$CHARACTER_SET_ID = 59
1094 RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
1095 RDB$CHARACTER_SET_ID = 60
1096 RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
1097 RDB$CHARACTER_SET_ID = 63
1098 RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
1099 RDB$CHARACTER_SET_ID = 64
1100 RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
1101 RDB$CHARACTER_SET_ID = 65
1102 RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
1103 RDB$CHARACTER_SET_ID = 66
1104 RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
1105 RDB$CHARACTER_SET_ID = 67
1106 RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
1107 RDB$CHARACTER_SET_ID = 68
1108 RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
1109 RDB$CHARACTER_SET_ID = 69
1110
1111 Metadata
1112 SQLType =SQL_LONG
1113 sub type = 0
1114 Table = TESTDATA
1115 Owner = SYSDBA
1116 Column Name = ROWID
1117 Alias Name = ROWID
1118 Field Name = ROWID
1119 Scale = 0
1120 Charset id = 0
1121 Not Null
1122 Size = 4
1123
1124 SQLType =SQL_LONG
1125 sub type = 0
1126 Table = TESTDATA
1127 Owner = SYSDBA
1128 Column Name = FIXEDPOINT
1129 Alias Name = FIXEDPOINT
1130 Field Name = FIXEDPOINT
1131 Scale = -2
1132 Charset id = 0
1133 Nullable
1134 Size = 4
1135
1136 SQLType =SQL_DOUBLE
1137 sub type = 0
1138 Table = TESTDATA
1139 Owner = SYSDBA
1140 Column Name = FLOATINGPOINT
1141 Alias Name = FLOATINGPOINT
1142 Field Name = FLOATINGPOINT
1143 Scale = 0
1144 Charset id = 0
1145 Nullable
1146 Size = 8
1147
1148 SQLType =SQL_VARYING
1149 sub type = 0
1150 Table = TESTDATA
1151 Owner = SYSDBA
1152 Column Name = TITLE
1153 Alias Name = TITLE
1154 Field Name = TITLE
1155 Scale = 0
1156 Charset id = 4
1157 Nullable
1158 Size = 128
1159
1160 SQLType =SQL_BLOB
1161 sub type = 1
1162 Table = TESTDATA
1163 Owner = SYSDBA
1164 Column Name = BLOBDATA
1165 Alias Name = BLOBDATA
1166 Field Name = BLOBDATA
1167 Scale = 0
1168 Charset id = 4
1169 Nullable
1170 Size = 8
1171
1172 Blob Meta Data
1173 SQL SubType =1
1174 Table = TESTDATA
1175 Column = BLOBDATA
1176 CharSetID = 4
1177 Segment Size = 80
1178
1179
1180 SQL Params
1181 SQLType =SQL_LONG
1182 sub type = 0
1183 Field Name = ROWID
1184 Scale = 0
1185 Charset id = 0
1186 Not Null
1187 Size = 4
1188
1189 SQLType =SQL_VARYING
1190 sub type = 0
1191 Field Name = TITLE
1192 Scale = 0
1193 Charset id = 4
1194 Nullable
1195 Size = 128
1196
1197 SQLType =SQL_LONG
1198 sub type = 0
1199 Field Name = FP
1200 Scale = -2
1201 Charset id = 0
1202 Nullable
1203 Size = 4
1204
1205 SQLType =SQL_DOUBLE
1206 sub type = 0
1207 Field Name = DP
1208 Scale = 0
1209 Charset id = 0
1210 Nullable
1211 Size = 8
1212
1213 ROWID = 1
1214 FIXEDPOINT = 20.28
1215 FLOATINGPOINT = 3.14
1216 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1217 BLOBDATA = NULL
1218
1219 SQL Params
1220 SQLType =SQL_BLOB
1221 sub type = 1
1222 Field Name =
1223 Scale = 0
1224 Charset id = 4
1225 Nullable
1226 Size = 8
1227
1228 SQLType =SQL_LONG
1229 sub type = 0
1230 Field Name =
1231 Scale = 0
1232 Charset id = 0
1233 Not Null
1234 Size = 4
1235
1236 ROWID = 1
1237 FIXEDPOINT = 20.28
1238 FLOATINGPOINT = 3.14
1239 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1240 BLOBDATA (Charset Id = 4 Codepage = 65001)
1241
1242 To be or not to be-that is the question:
1243 Whether 'tis nobler in the mind to suffer
1244 The slings and arrows of outrageous fortune,
1245 Or to take arms against a sea of troubles,
1246 And, by opposing, end them. To die, to sleep-
1247 No more-and by a sleep to say we end
1248 The heartache and the thousand natural shocks
1249 That flesh is heir to-'tis a consummation
1250 Devoutly to be wished. To die, to sleep-
1251 To sleep, perchance to dream. Aye, there's the rub,
1252 For in that sleep of death what dreams may come,
1253 When we have shuffled off this mortal coil,
1254 Must give us pause. There's the respect
1255 That makes calamity of so long life.
1256 For who would bear the whips and scorns of time,
1257 Th' oppressor's wrong, the proud man's contumely,
1258 The pangs of despised love, the law’s delay,
1259 The insolence of office, and the spurns
1260 That patient merit of the unworthy takes,
1261 When he himself might his quietus make
1262 With a bare bodkin? Who would fardels bear,
1263 To grunt and sweat under a weary life,
1264 But that the dread of something after death,
1265 The undiscovered country from whose bourn
1266 No traveler returns, puzzles the will
1267 And makes us rather bear those ills we have
1268 Than fly to others that we know not of?
1269 Thus conscience does make cowards of us all,
1270 And thus the native hue of resolution
1271 Is sicklied o'er with the pale cast of thought,
1272 And enterprises of great pitch and moment,
1273 With this regard their currents turn awry,
1274 And lose the name of action.-Soft you now,
1275 The fair Ophelia.-Nymph, in thy orisons
1276 Be all my sins remembered
1277
1278
1279 SQL Params
1280 SQLType =SQL_LONG
1281 sub type = 0
1282 Field Name = ROWID
1283 Scale = 0
1284 Charset id = 0
1285 Not Null
1286 Size = 4
1287
1288 SQLType =SQL_VARYING
1289 sub type = 0
1290 Field Name = TITLE
1291 Scale = 0
1292 Charset id = 4
1293 Nullable
1294 Size = 128
1295
1296 SQLType =SQL_LONG
1297 sub type = 0
1298 Field Name = FP
1299 Scale = -2
1300 Charset id = 0
1301 Nullable
1302 Size = 4
1303
1304 SQLType =SQL_DOUBLE
1305 sub type = 0
1306 Field Name = DP
1307 Scale = 0
1308 Charset id = 0
1309 Nullable
1310 Size = 8
1311
1312 ROWID = 1
1313 FIXEDPOINT = 20.28
1314 FLOATINGPOINT = 3.14
1315 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1316 BLOBDATA (Charset Id = 4 Codepage = 65001)
1317
1318 To be or not to be-that is the question:
1319 Whether 'tis nobler in the mind to suffer
1320 The slings and arrows of outrageous fortune,
1321 Or to take arms against a sea of troubles,
1322 And, by opposing, end them. To die, to sleep-
1323 No more-and by a sleep to say we end
1324 The heartache and the thousand natural shocks
1325 That flesh is heir to-'tis a consummation
1326 Devoutly to be wished. To die, to sleep-
1327 To sleep, perchance to dream. Aye, there's the rub,
1328 For in that sleep of death what dreams may come,
1329 When we have shuffled off this mortal coil,
1330 Must give us pause. There's the respect
1331 That makes calamity of so long life.
1332 For who would bear the whips and scorns of time,
1333 Th' oppressor's wrong, the proud man's contumely,
1334 The pangs of despised love, the law’s delay,
1335 The insolence of office, and the spurns
1336 That patient merit of the unworthy takes,
1337 When he himself might his quietus make
1338 With a bare bodkin? Who would fardels bear,
1339 To grunt and sweat under a weary life,
1340 But that the dread of something after death,
1341 The undiscovered country from whose bourn
1342 No traveler returns, puzzles the will
1343 And makes us rather bear those ills we have
1344 Than fly to others that we know not of?
1345 Thus conscience does make cowards of us all,
1346 And thus the native hue of resolution
1347 Is sicklied o'er with the pale cast of thought,
1348 And enterprises of great pitch and moment,
1349 With this regard their currents turn awry,
1350 And lose the name of action.-Soft you now,
1351 The fair Ophelia.-Nymph, in thy orisons
1352 Be all my sins remembered
1353
1354 ROWID = 2
1355 FIXEDPOINT = NULL
1356 FLOATINGPOINT = NULL
1357 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1358 BLOBDATA (Charset Id = 4 Codepage = 65001)
1359
1360 To be or not to be-that is the question:
1361 Whether 'tis nobler in the mind to suffer
1362 The slings and arrows of outrageous fortune,
1363 Or to take arms against a sea of troubles,
1364 And, by opposing, end them. To die, to sleep-
1365 No more-and by a sleep to say we end
1366 The heartache and the thousand natural shocks
1367 That flesh is heir to-'tis a consummation
1368 Devoutly to be wished. To die, to sleep-
1369 To sleep, perchance to dream. Aye, there's the rub,
1370 For in that sleep of death what dreams may come,
1371 When we have shuffled off this mortal coil,
1372 Must give us pause. There's the respect
1373 That makes calamity of so long life.
1374 For who would bear the whips and scorns of time,
1375 Th' oppressor's wrong, the proud man's contumely,
1376 The pangs of despised love, the law’s delay,
1377 The insolence of office, and the spurns
1378 That patient merit of the unworthy takes,
1379 When he himself might his quietus make
1380 With a bare bodkin? Who would fardels bear,
1381 To grunt and sweat under a weary life,
1382 But that the dread of something after death,
1383 The undiscovered country from whose bourn
1384 No traveler returns, puzzles the will
1385 And makes us rather bear those ills we have
1386 Than fly to others that we know not of?
1387 Thus conscience does make cowards of us all,
1388 And thus the native hue of resolution
1389 Is sicklied o'er with the pale cast of thought,
1390 And enterprises of great pitch and moment,
1391 With this regard their currents turn awry,
1392 And lose the name of action.-Soft you now,
1393 The fair Ophelia.-Nymph, in thy orisons
1394 Be all my sins remembered
1395
1396
1397
1398
1399 Running Test 7: Create and read back an Array
1400 Metadata
1401 SQLType =SQL_LONG
1402 sub type = 0
1403 Table = TESTDATA
1404 Owner = SYSDBA
1405 Column Name = ROWID
1406 Alias Name = ROWID
1407 Field Name = ROWID
1408 Scale = 0
1409 Charset id = 0
1410 Not Null
1411 Size = 4
1412
1413 SQLType =SQL_VARYING
1414 sub type = 0
1415 Table = TESTDATA
1416 Owner = SYSDBA
1417 Column Name = TITLE
1418 Alias Name = TITLE
1419 Field Name = TITLE
1420 Scale = 0
1421 Charset id = 4
1422 Nullable
1423 Size = 128
1424
1425 SQLType =SQL_TIMESTAMP
1426 sub type = 0
1427 Table = TESTDATA
1428 Owner = SYSDBA
1429 Column Name = DATED
1430 Alias Name = DATED
1431 Field Name = DATED
1432 Scale = 0
1433 Charset id = 0
1434 Nullable
1435 Size = 8
1436
1437 SQLType =SQL_VARYING
1438 sub type = 0
1439 Table = TESTDATA
1440 Owner = SYSDBA
1441 Column Name = NOTES
1442 Alias Name = NOTES
1443 Field Name = NOTES
1444 Scale = 0
1445 Charset id = 4
1446 Nullable
1447 Size = 256
1448
1449 SQLType =SQL_ARRAY
1450 sub type = 0
1451 Table = TESTDATA
1452 Owner = SYSDBA
1453 Column Name = MYARRAY
1454 Alias Name = MYARRAY
1455 Field Name = MYARRAY
1456 Scale = 0
1457 Charset id = 0
1458 Nullable
1459 Size = 8
1460 Array Meta Data:
1461 SQLType =SQL_LONG
1462 Scale = 0
1463 Charset id = 0
1464 Size = 4
1465 Table = TESTDATA
1466 Column = MYARRAY
1467 Dimensions = 1
1468 Bounds: (0:16)
1469
1470 SQL Params
1471 SQLType =SQL_LONG
1472 sub type = 0
1473 Field Name = ROWID
1474 Scale = 0
1475 Charset id = 0
1476 Not Null
1477 Size = 4
1478
1479 SQLType =SQL_VARYING
1480 sub type = 0
1481 Field Name = TITLE
1482 Scale = 0
1483 Charset id = 4
1484 Nullable
1485 Size = 128
1486
1487 SQLType =SQL_TIMESTAMP
1488 sub type = 0
1489 Field Name = DATED
1490 Scale = 0
1491 Charset id = 0
1492 Nullable
1493 Size = 8
1494
1495 SQLType =SQL_VARYING
1496 sub type = 0
1497 Field Name = NOTES
1498 Scale = 0
1499 Charset id = 4
1500 Nullable
1501 Size = 256
1502
1503 Param Name = ROWID
1504 Param Name = TITLE
1505 Param Name = DATED
1506 Param Name = NOTES
1507 ROWID = 1
1508 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1509 DATED = 1/4/2016 09:30:00.100
1510 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
1511 MYARRAY = NULL
1512
1513 SQL Params
1514 SQLType =SQL_ARRAY
1515 sub type = 0
1516 Field Name = MYARRAY
1517 Scale = 0
1518 Charset id = 0
1519 Nullable
1520 Size = 8
1521
1522 ROWID = 1
1523 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1524 DATED = 1/4/2016 09:30:00.100
1525 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
1526 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)
1527
1528 Shrink to 2:10
1529 Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
1530 Write updated reduced slice
1531 Show update array
1532 ROWID = 1
1533 TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1534 DATED = 1/4/2016 09:30:00.100
1535 NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
1536 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)
1537
1538
1539
1540 Running Test 8: Create and read back an Array with 2 dimensions
1541 Metadata
1542 SQLType =SQL_LONG
1543 sub type = 0
1544 Table = TESTDATA
1545 Owner = SYSDBA
1546 Column Name = ROWID
1547 Alias Name = ROWID
1548 Field Name = ROWID
1549 Scale = 0
1550 Charset id = 0
1551 Not Null
1552 Size = 4
1553
1554 SQLType =SQL_VARYING
1555 sub type = 0
1556 Table = TESTDATA
1557 Owner = SYSDBA
1558 Column Name = TITLE
1559 Alias Name = TITLE
1560 Field Name = TITLE
1561 Scale = 0
1562 Charset id = 4
1563 Nullable
1564 Size = 128
1565
1566 SQLType =SQL_ARRAY
1567 sub type = 0
1568 Table = TESTDATA
1569 Owner = SYSDBA
1570 Column Name = MYARRAY
1571 Alias Name = MYARRAY
1572 Field Name = MYARRAY
1573 Scale = 0
1574 Charset id = 4
1575 Nullable
1576 Size = 8
1577 Array Meta Data:
1578 SQLType =SQL_VARYING
1579 Scale = 0
1580 Charset id = 4
1581 Size = 16
1582 Table = TESTDATA
1583 Column = MYARRAY
1584 Dimensions = 2
1585 Bounds: (0:16) (-1:7)
1586
1587 SQL Params
1588 SQLType =SQL_LONG
1589 sub type = 0
1590 Field Name = ROWID
1591 Scale = 0
1592 Charset id = 0
1593 Not Null
1594 Size = 4
1595
1596 SQLType =SQL_VARYING
1597 sub type = 0
1598 Field Name = TITLE
1599 Scale = 0
1600 Charset id = 4
1601 Nullable
1602 Size = 128
1603
1604 ROWID = 1
1605 TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
1606 MYARRAY = NULL
1607
1608 ROWID = 1
1609 TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
1610 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)
1611
1612
1613
1614 Running Test 9: Database Information tests
1615 Database ID = 4 FB = /opt/firebird/examples/empbuild/employee.fdb SN = mint18-FB3
1616 Pages =307
1617 Base Level = 13,4,0,3,
1618 Implementation = 11,7,0,3,66,1,66,
1619 Reserved = 0
1620 ODS minor = 0
1621 ODS major = 12
1622 Page Size = 8192
1623 Version = 1: LI-V6.3.1.32609 Firebird 3.0
1624 Database is Read/Write
1625 Server Memory = 18908760
1626 Forced Writes = 1
1627 Max Memory = 18945880
1628 Num Buffers = 2048
1629 Sweep Interval = 20000
1630 Logged in Users: SYSDBA,
1631 Fetches = 491
1632 Writes = 4
1633 Reads = 51
1634 Page Writes = 2
1635 Record Version Removals Operation Counts
1636
1637 Deletes Operation Counts
1638
1639 Expunge Count Operation Counts
1640
1641 Insert Count Operation Counts
1642
1643 Purge Count Countites Operation Counts
1644
1645 Indexed Reads Count Operation Counts
1646 Table ID = 4
1647 Count = 28
1648 Table ID = 6
1649 Count = 5
1650 Table ID = 9
1651 Count = 1
1652 Table ID = 11
1653 Count = 1
1654 Table ID = 12
1655 Count = 15
1656 Table ID = 28
1657 Count = 1
1658 Table ID = 29
1659 Count = 1
1660
1661 Sequential Table Scans Operation Counts
1662 Table ID = 0
1663 Count = 94
1664 Table ID = 1
1665 Count = 2
1666
1667 Update Count Operation Counts
1668
1669
1670
1671 Running Test 10: Event Handling
1672 Call Async Wait
1673 Async Wait Called
1674 Event Signalled
1675 First Event - usually ignored
1676 Signal Event
1677 Event Signalled
1678 Event Counts: TESTEVENT, Count = 1
1679 Two more events
1680 Call Async Wait
1681 Async Wait Called
1682 Event Signalled
1683 Deferred Events Caught
1684 Event Counts: TESTEVENT, Count = 2
1685 Signal Event
1686 Event Signalled
1687 Event Counts: TESTEVENT, Count = 1
1688 Async Wait: Test Cancel
1689 Async Wait Called
1690 Event Cancelled
1691 Time Out - Cancel Worked!
1692 Sync wait
1693 Event Signalled
1694 Event Counts: TESTEVENT, Count = 1
1695
1696
1697 Running Test 11: Services API
1698 Service Manager Version = 2
1699 Server Version = LI-V3.0.1.32609 Firebird 3.0
1700 Implementation = Firebird/Linux/AMD/Intel/x64
1701
1702 Lock Directory = /tmp/firebird/
1703 Message File = /opt/firebird/
1704 Security File = /opt/firebird/security3.fdb
1705
1706 DB Attachments
1707 No. of Attachments = 0
1708 Databases In Use = 0
1709
1710 Sec. Database User
1711 User Name = SYSDBA
1712 First Name =
1713 Middle Name =
1714 Last Name =
1715 User ID = 0
1716 Group ID = 0
1717
1718
1719 Licence Info: feature is not supported
1720 feature is not supported
1721
1722 Licence Mask Info: feature is not supported
1723
1724 Capabilities = 6
1725
1726
1727 Get Limbo transactions
1728
1729 Limbo Transactions
1730
1731
1732 Local Backup
1733
1734
1735
1736 Local Backup Complete
1737
1738 Local Restore
1739
1740
1741
1742
1743
1744
1745 Local Restore Complete
1746
1747 Open Database Check
1748 Database OK
1749 Database Dropped
1750
1751
1752 Running Test 12: Character Sets
1753 SQL Params
1754 SQLType =SQL_LONG
1755 sub type = 0
1756 Field Name = ROWID
1757 Scale = 0
1758 Charset id = 0
1759 Not Null
1760 Size = 4
1761
1762 SQLType =SQL_VARYING
1763 sub type = 0
1764 Field Name = TITLE
1765 Scale = 0
1766 Charset id = 4
1767 Nullable
1768 Size = 128
1769
1770 SQLType =SQL_VARYING
1771 sub type = 0
1772 Field Name = NOTES
1773 Scale = 0
1774 Charset id = 4
1775 Nullable
1776 Size = 256
1777
1778 SQLType =SQL_BLOB
1779 sub type = 1
1780 Field Name = BLOBDATA
1781 Scale = 0
1782 Charset id = 4
1783 Nullable
1784 Size = 8
1785
1786 SQLType =SQL_BLOB
1787 sub type = 1
1788 Field Name = BLOBDATA2
1789 Scale = 0
1790 Charset id = 4
1791 Nullable
1792 Size = 8
1793
1794 SQLType =SQL_VARYING
1795 sub type = 0
1796 Field Name = INCLEAR
1797 Scale = 0
1798 Charset id = 1
1799 Nullable
1800 Size = 16
1801
1802 Connection Character Set UTF8
1803 ROWID = 1
1804 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
1805 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
1806 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)
1807 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)
1808 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1809
1810 Connection Character Set NONE
1811 ROWID = 1
1812 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
1813 NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591)
1814 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)
1815 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)
1816 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1817
1818 Connection Character Set WIN1252
1819 ROWID = 1
1820 TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252)
1821 NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252)
1822 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)
1823 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)
1824 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1825
1826
1827
1828 Running Test 13: Transaction over two databases
1829 Init Database 1
1830 ROWID = 1
1831 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
1832 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
1833 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)
1834 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)
1835 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1836
1837 Init Database 2
1838 ROWID = 1
1839 TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001)
1840 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
1841 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)
1842 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)
1843 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1844
1845 ROWID = 1
1846 TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001)
1847 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
1848 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)
1849 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)
1850 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1851
1852 ROWID = 1
1853 TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001)
1854 NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001)
1855 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)
1856 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)
1857 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1858
1859
1860
1861 Running Test 14: Non select procedures
1862 Default Character set Name = UTF8
1863 Metadata
1864 SQLType =SQL_LONG
1865 sub type = 0
1866 Table = SHOWDATA
1867 Owner = SYSDBA
1868 Column Name = ROWID
1869 Alias Name = ROWID
1870 Field Name = ROWID
1871 Scale = 0
1872 Charset id = 0
1873 Nullable
1874 Size = 4
1875
1876 SQLType =SQL_VARYING
1877 sub type = 0
1878 Table = SHOWDATA
1879 Owner = SYSDBA
1880 Column Name = TITLE
1881 Alias Name = TITLE
1882 Field Name = TITLE
1883 Scale = 0
1884 Charset id = 4
1885 Nullable
1886 Size = 128
1887
1888 ROWID = 1
1889 TITLE = Testing (Charset Id = 4 Codepage = 65001)
1890
1891 Repeat with a different execute transaction
1892
1893 ROWID = 1
1894 TITLE = Testing (Charset Id = 4 Codepage = 65001)
1895
1896 Repeat with a original transaction
1897
1898 ROWID = 1
1899 TITLE = Testing (Charset Id = 4 Codepage = 65001)
1900
1901
1902 Running Test 15: Blob Handling and BPBs
1903
1904 Testdata
1905
1906 ROWID = 1
1907 TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
1908 BLOBDATA = (blob), Length = 92514
1909
1910
1911 Testdata 2
1912
1913 ROWID = 1
1914 TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
1915 BLOBDATA (Charset Id = 4 Codepage = 65001)
1916
1917 Écoute moi
1918
1919
1920
1921 Running Test 16: Error handling
1922 Invalid Database Name Test
1923 Error Handled: I/O error during "open" operation for file "Malformed Name"
1924 Error while trying to open file
1925 No such file or directory
1926 Invalid User Name Test
1927 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
1928 Invalid password Test
1929 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
1930 Invalid Prepare SQL Test
1931 Error Handled: Dynamic SQL Error
1932 SQL error code = -206
1933 Column unknown
1934 UNKNOWN_DATE
1935 At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
1936 Invalid Open Cursor SQL Test
1937 Error Handled: Dynamic SQL Error
1938 SQL error code = -206
1939 Column unknown
1940 X
1941 At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE
1942 Transaction not started Test
1943 Error Handled: Transaction is not active
1944 Invalid Param SQL Type Test
1945 Error Handled: Field "EMP_NO" not found
1946 Invalid Server Name Test
1947 Error Handled: Unable to complete network request to host "unknown".
1948 Failed to locate host machine.
1949 The specified name was not found in the hosts file or Domain Name Services
1950 Invalid User Name Test
1951 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
1952 Invalid password Test
1953 Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
1954
1955
1956 Test Suite Ends