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, 6 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

# 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 tony 47 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 tony 45 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 tony 47 Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = mint18-FB3
26     ODS major = 12
27     ODS minor = 0
28 tony 45 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 tony 70 "Johnson" Employee Count = 2
269     "Yanowski" Employee Count = 1
270 tony 45
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 tony 61 Current memory = 1.959857600000000000E+0007
289 tony 70 Delta memory = 2.952000000000000000E+0003
290     Max memory = 1.966170400000000000E+0007
291     Elapsed time= 0.007 sec
292 tony 47 Cpu = 0.000 sec
293 tony 61 Buffers = 2.048000000000000000E+0003
294     Reads = 0.000000000000000000E+0000
295     Writes = 0.000000000000000000E+0000
296     Fetches = 2.000000000000000000E+0000
297 tony 45 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 tony 47
863 tony 45 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 tony 47
938 tony 45 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 tony 47
981 tony 45 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 tony 47
1279 tony 45 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 tony 47
1354 tony 45 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 tony 47
1399 tony 45 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 tony 47 Database ID = 4 FB = /opt/firebird/examples/empbuild/employee.fdb SN = mint18-FB3
1616 tony 45 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 tony 47 Version = 1: LI-V6.3.1.32609 Firebird 3.0
1624 tony 61 Database is Read/Write
1625     Server Memory = 18908760
1626 tony 45 Forced Writes = 1
1627 tony 61 Max Memory = 18945880
1628 tony 45 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 tony 47 Event Signalled
1675     First Event - usually ignored
1676 tony 45 Signal Event
1677     Event Signalled
1678 tony 47 Event Counts: TESTEVENT, Count = 1
1679 tony 45 Two more events
1680     Call Async Wait
1681     Async Wait Called
1682 tony 47 Event Signalled
1683     Deferred Events Caught
1684     Event Counts: TESTEVENT, Count = 2
1685 tony 45 Signal Event
1686     Event Signalled
1687 tony 47 Event Counts: TESTEVENT, Count = 1
1688 tony 45 Async Wait: Test Cancel
1689     Async Wait Called
1690 tony 47 Event Cancelled
1691 tony 45 Time Out - Cancel Worked!
1692     Sync wait
1693     Event Signalled
1694 tony 47 Event Counts: TESTEVENT, Count = 1
1695 tony 45
1696    
1697     Running Test 11: Services API
1698     Service Manager Version = 2
1699 tony 47 Server Version = LI-V3.0.1.32609 Firebird 3.0
1700 tony 45 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 tony 47 Charset id = 1
1799 tony 45 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 tony 47 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1809 tony 45
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 tony 47 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1817 tony 45
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 tony 47 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1825 tony 45
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 tony 47 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1836 tony 45
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 tony 47 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1844 tony 45
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 tony 47 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1851 tony 45
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 tony 47 INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535)
1858 tony 45
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