ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/testsuite/reference.log
Revision: 45
Committed: Tue Dec 6 10:33:46 2016 UTC (7 years, 4 months ago) by tony
File size: 49275 byte(s)
Log Message: 
Committing updates for Release R2-0-0

File Contents

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