1 |
|
Firebird API Test Suite |
2 |
< |
Copyright MWA Software 2016 |
2 |
> |
Copyright MWA Software 2016-2021 |
3 |
|
|
4 |
|
Starting Tests |
5 |
|
Client API Version = 2.5 |
6 |
+ |
Firebird Environment Variable = /opt/firebird2.5.9 |
7 |
+ |
Firebird Client Library Path = /opt/firebird2.5.9/lib/libfbembed.so |
8 |
|
Running Test 1: Create and Drop a Database |
9 |
|
Creating a Database with empty parameters |
10 |
< |
Create Database fails (as expected): |
11 |
< |
unavailable database |
10 |
> |
Create Database fails (as expected): I/O error during "open O_CREAT" operation for file "" |
11 |
> |
-Error while trying to create file |
12 |
> |
-No such file or directory |
13 |
|
Creating a Database using an SQL Statement |
14 |
|
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
15 |
|
SQL Dialect = 3 |
16 |
< |
DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb |
16 |
> |
DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb |
17 |
|
DB Charset ID = 0 |
18 |
|
DB SQL Dialect = 3 |
19 |
|
DB Remote Protocol = TCPv4 |
20 |
|
DB ODS Major Version = 11 |
21 |
|
DB ODS Minor Version = 2 |
22 |
|
User Authentication Method = Legacy_Auth |
23 |
< |
Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so |
23 |
> |
Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so |
24 |
|
DB Client Implementation Version = 2.5 |
25 |
< |
DPB |
26 |
< |
Count = 3 |
27 |
< |
28 = SYSDBA |
28 |
< |
29 = masterkey |
29 |
< |
65 = 3 |
25 |
> |
DPB: Item Count = 3 |
26 |
> |
isc_dpb_user_name = SYSDBA |
27 |
> |
isc_dpb_password = masterkey |
28 |
> |
isc_dpb_set_db_sql_dialect = 3 |
29 |
> |
|
30 |
> |
Firebird Server Version Info |
31 |
> |
Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5" |
32 |
> |
Firebird/linux AMD64 (remote server), version "LI-V2.5.9.27139 Firebird 2.5/tcp (zeus)/P12" |
33 |
> |
Firebird/linux AMD64 (remote interface), version "LI-V2.5.9.27139 Firebird 2.5/tcp (zeus)/P12" |
34 |
> |
on disk structure version 11.2 |
35 |
|
|
36 |
|
Dropping Database |
37 |
|
Creating a Database with a DPD |
38 |
< |
DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb |
38 |
> |
DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb |
39 |
|
DB Charset ID = 4 |
40 |
|
DB SQL Dialect = 3 |
41 |
|
DB Remote Protocol = TCPv4 |
42 |
|
DB ODS Major Version = 11 |
43 |
|
DB ODS Minor Version = 2 |
44 |
|
User Authentication Method = Legacy_Auth |
45 |
< |
Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so |
45 |
> |
Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so |
46 |
|
DB Client Implementation Version = 2.5 |
47 |
|
Dropping Database |
48 |
< |
DPB |
49 |
< |
Count = 4 |
50 |
< |
28 = SYSDBA |
51 |
< |
29 = masterkey |
52 |
< |
48 = UTF8 |
45 |
< |
65 = 3 |
48 |
> |
DPB: Item Count = 4 |
49 |
> |
isc_dpb_user_name = SYSDBA |
50 |
> |
isc_dpb_password = masterkey |
51 |
> |
isc_dpb_lc_ctype = UTF8 |
52 |
> |
isc_dpb_set_db_sql_dialect = 3 |
53 |
|
|
54 |
|
Creating a Database with a DPD |
55 |
|
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
56 |
|
ODS major = 11 |
57 |
|
ODS minor = 2 |
58 |
< |
DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb |
58 |
> |
DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb |
59 |
|
DB Charset ID = 4 |
60 |
|
DB SQL Dialect = 3 |
61 |
|
DB Remote Protocol = TCPv4 |
62 |
|
DB ODS Major Version = 11 |
63 |
|
DB ODS Minor Version = 2 |
64 |
|
User Authentication Method = Legacy_Auth |
65 |
< |
Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so |
65 |
> |
Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so |
66 |
|
DB Client Implementation Version = 2.5 |
67 |
|
RDB$DESCRIPTION = |
68 |
|
RDB$RELATION_ID = 128 |
71 |
|
Dropping Database |
72 |
|
|
73 |
|
|
74 |
+ |
------------------------------------------------------ |
75 |
|
Running Test 2: Open the employee database and run a query |
76 |
|
Opening localhost:employee |
77 |
|
Database Open, SQL Dialect = 3 |
78 |
+ |
TPB: Item Count = 3 |
79 |
+ |
isc_tpb_read |
80 |
+ |
isc_tpb_nowait |
81 |
+ |
isc_tpb_concurrency |
82 |
+ |
|
83 |
+ |
Metadata |
84 |
+ |
SQLType =SQL_SHORT |
85 |
+ |
sub type = 0 |
86 |
+ |
Table = EMPLOYEE |
87 |
+ |
Owner = SYSDBA |
88 |
+ |
Column Name = EMP_NO |
89 |
+ |
Alias Name = EMP_NO |
90 |
+ |
Field Name = EMP_NO |
91 |
+ |
Scale = 0 |
92 |
+ |
Charset id = 0 |
93 |
+ |
Not Null |
94 |
+ |
Size = 2 |
95 |
+ |
|
96 |
+ |
SQLType =SQL_VARYING |
97 |
+ |
sub type = 0 |
98 |
+ |
Table = EMPLOYEE |
99 |
+ |
Owner = SYSDBA |
100 |
+ |
Column Name = FIRST_NAME |
101 |
+ |
Alias Name = FIRST_NAME |
102 |
+ |
Field Name = FIRST_NAME |
103 |
+ |
Scale = 0 |
104 |
+ |
Charset id = 0 |
105 |
+ |
Not Null |
106 |
+ |
Size = 15 |
107 |
+ |
|
108 |
+ |
SQLType =SQL_VARYING |
109 |
+ |
sub type = 0 |
110 |
+ |
Table = EMPLOYEE |
111 |
+ |
Owner = SYSDBA |
112 |
+ |
Column Name = LAST_NAME |
113 |
+ |
Alias Name = LAST_NAME |
114 |
+ |
Field Name = LAST_NAME |
115 |
+ |
Scale = 0 |
116 |
+ |
Charset id = 0 |
117 |
+ |
Not Null |
118 |
+ |
Size = 20 |
119 |
+ |
|
120 |
+ |
SQLType =SQL_VARYING |
121 |
+ |
sub type = 0 |
122 |
+ |
Table = EMPLOYEE |
123 |
+ |
Owner = SYSDBA |
124 |
+ |
Column Name = PHONE_EXT |
125 |
+ |
Alias Name = PHONE_EXT |
126 |
+ |
Field Name = PHONE_EXT |
127 |
+ |
Scale = 0 |
128 |
+ |
Charset id = 0 |
129 |
+ |
Nullable |
130 |
+ |
Size = 4 |
131 |
+ |
|
132 |
+ |
SQLType =SQL_TIMESTAMP |
133 |
+ |
sub type = 0 |
134 |
+ |
Table = EMPLOYEE |
135 |
+ |
Owner = SYSDBA |
136 |
+ |
Column Name = HIRE_DATE |
137 |
+ |
Alias Name = HIRE_DATE |
138 |
+ |
Field Name = HIRE_DATE |
139 |
+ |
Scale = 0 |
140 |
+ |
Charset id = 0 |
141 |
+ |
Not Null |
142 |
+ |
Size = 8 |
143 |
+ |
|
144 |
+ |
SQLType =SQL_TEXT |
145 |
+ |
sub type = 0 |
146 |
+ |
Table = EMPLOYEE |
147 |
+ |
Owner = SYSDBA |
148 |
+ |
Column Name = DEPT_NO |
149 |
+ |
Alias Name = DEPT_NO |
150 |
+ |
Field Name = DEPT_NO |
151 |
+ |
Scale = 0 |
152 |
+ |
Charset id = 0 |
153 |
+ |
Not Null |
154 |
+ |
Size = 3 |
155 |
+ |
|
156 |
+ |
SQLType =SQL_VARYING |
157 |
+ |
sub type = 0 |
158 |
+ |
Table = EMPLOYEE |
159 |
+ |
Owner = SYSDBA |
160 |
+ |
Column Name = JOB_CODE |
161 |
+ |
Alias Name = JOB_CODE |
162 |
+ |
Field Name = JOB_CODE |
163 |
+ |
Scale = 0 |
164 |
+ |
Charset id = 0 |
165 |
+ |
Not Null |
166 |
+ |
Size = 5 |
167 |
+ |
|
168 |
+ |
SQLType =SQL_SHORT |
169 |
+ |
sub type = 0 |
170 |
+ |
Table = EMPLOYEE |
171 |
+ |
Owner = SYSDBA |
172 |
+ |
Column Name = JOB_GRADE |
173 |
+ |
Alias Name = JOB_GRADE |
174 |
+ |
Field Name = JOB_GRADE |
175 |
+ |
Scale = 0 |
176 |
+ |
Charset id = 0 |
177 |
+ |
Not Null |
178 |
+ |
Size = 2 |
179 |
+ |
|
180 |
+ |
SQLType =SQL_VARYING |
181 |
+ |
sub type = 0 |
182 |
+ |
Table = EMPLOYEE |
183 |
+ |
Owner = SYSDBA |
184 |
+ |
Column Name = JOB_COUNTRY |
185 |
+ |
Alias Name = JOB_COUNTRY |
186 |
+ |
Field Name = JOB_COUNTRY |
187 |
+ |
Scale = 0 |
188 |
+ |
Charset id = 0 |
189 |
+ |
Not Null |
190 |
+ |
Size = 15 |
191 |
+ |
|
192 |
+ |
SQLType =SQL_INT64 |
193 |
+ |
sub type = 0 |
194 |
+ |
Table = EMPLOYEE |
195 |
+ |
Owner = SYSDBA |
196 |
+ |
Column Name = SALARY |
197 |
+ |
Alias Name = SALARY |
198 |
+ |
Field Name = SALARY |
199 |
+ |
Scale = -2 |
200 |
+ |
Charset id = 0 |
201 |
+ |
Not Null |
202 |
+ |
Size = 8 |
203 |
+ |
|
204 |
+ |
SQLType =SQL_VARYING |
205 |
+ |
sub type = 0 |
206 |
+ |
Table = EMPLOYEE |
207 |
+ |
Owner = SYSDBA |
208 |
+ |
Column Name = FULL_NAME |
209 |
+ |
Alias Name = FULL_NAME |
210 |
+ |
Field Name = FULL_NAME |
211 |
+ |
Scale = 0 |
212 |
+ |
Charset id = 0 |
213 |
+ |
Nullable |
214 |
+ |
Size = 37 |
215 |
+ |
|
216 |
+ |
Plan = |
217 |
+ |
PLAN (EMPLOYEE NATURAL) |
218 |
+ |
-- SQL style inline comment |
219 |
+ |
/* this is a comment */ Select First 3 * from EMPLOYEE |
220 |
+ |
|
221 |
+ |
EMP_NO = 2 |
222 |
+ |
FIRST_NAME = Robert |
223 |
+ |
LAST_NAME = Nelson |
224 |
+ |
PHONE_EXT = 250 |
225 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
226 |
+ |
DEPT_NO = 600 |
227 |
+ |
JOB_CODE = VP |
228 |
+ |
JOB_GRADE = 2 |
229 |
+ |
JOB_COUNTRY = USA |
230 |
+ |
SALARY = 105,900.00 |
231 |
+ |
FULL_NAME = Nelson, Robert |
232 |
+ |
EMP_NO = 4 |
233 |
+ |
FIRST_NAME = Bruce |
234 |
+ |
LAST_NAME = Young |
235 |
+ |
PHONE_EXT = 233 |
236 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
237 |
+ |
DEPT_NO = 621 |
238 |
+ |
JOB_CODE = Eng |
239 |
+ |
JOB_GRADE = 2 |
240 |
+ |
JOB_COUNTRY = USA |
241 |
+ |
SALARY = 97,500.00 |
242 |
+ |
FULL_NAME = Young, Bruce |
243 |
+ |
EMP_NO = 5 |
244 |
+ |
FIRST_NAME = Kim |
245 |
+ |
LAST_NAME = Lambert |
246 |
+ |
PHONE_EXT = 22 |
247 |
+ |
HIRE_DATE = 1989/02/06 00:00:00.0000 |
248 |
+ |
DEPT_NO = 130 |
249 |
+ |
JOB_CODE = Eng |
250 |
+ |
JOB_GRADE = 2 |
251 |
+ |
JOB_COUNTRY = USA |
252 |
+ |
SALARY = 102,750.00 |
253 |
+ |
FULL_NAME = Lambert, Kim |
254 |
+ |
|
255 |
+ |
Select * from EMPLOYEE Where EMP_NO = ? |
256 |
+ |
SQL Params |
257 |
+ |
SQLType =SQL_SHORT |
258 |
+ |
sub type = 0 |
259 |
+ |
Field Name = |
260 |
+ |
Scale = 0 |
261 |
+ |
Charset id = 0 |
262 |
+ |
Not Null |
263 |
+ |
Size = 2 |
264 |
+ |
Value = 0 |
265 |
+ |
|
266 |
+ |
EMP_NO = 8 |
267 |
+ |
FIRST_NAME = Leslie |
268 |
+ |
LAST_NAME = Johnson |
269 |
+ |
PHONE_EXT = 410 |
270 |
+ |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
271 |
+ |
DEPT_NO = 180 |
272 |
+ |
JOB_CODE = Mktg |
273 |
+ |
JOB_GRADE = 3 |
274 |
+ |
JOB_COUNTRY = USA |
275 |
+ |
SALARY = 64,635.00 |
276 |
+ |
FULL_NAME = Johnson, Leslie |
277 |
+ |
|
278 |
+ |
With param names |
279 |
+ |
Select * from EMPLOYEE Where EMP_NO = :EMP_NO |
280 |
+ |
SQL Params |
281 |
+ |
SQLType =SQL_SHORT |
282 |
+ |
sub type = 0 |
283 |
+ |
Field Name = EMP_NO |
284 |
+ |
Scale = 0 |
285 |
+ |
Charset id = 0 |
286 |
+ |
Not Null |
287 |
+ |
Size = 2 |
288 |
+ |
Value = 0 |
289 |
+ |
|
290 |
+ |
EMP_NO = 8 |
291 |
+ |
FIRST_NAME = Leslie |
292 |
+ |
LAST_NAME = Johnson |
293 |
+ |
PHONE_EXT = 410 |
294 |
+ |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
295 |
+ |
DEPT_NO = 180 |
296 |
+ |
JOB_CODE = Mktg |
297 |
+ |
JOB_GRADE = 3 |
298 |
+ |
JOB_COUNTRY = USA |
299 |
+ |
SALARY = 64,635.00 |
300 |
+ |
FULL_NAME = Johnson, Leslie |
301 |
+ |
|
302 |
+ |
Now open the employee database as a local database |
303 |
+ |
TPB: Item Count = 3 |
304 |
+ |
isc_tpb_read |
305 |
+ |
isc_tpb_nowait |
306 |
+ |
isc_tpb_concurrency |
307 |
+ |
|
308 |
|
Metadata |
309 |
|
SQLType =SQL_SHORT |
310 |
|
sub type = 0 |
447 |
|
FIRST_NAME = Robert |
448 |
|
LAST_NAME = Nelson |
449 |
|
PHONE_EXT = 250 |
450 |
< |
HIRE_DATE = 28/12/1988 00:00:00.000 |
450 |
> |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
451 |
|
DEPT_NO = 600 |
452 |
|
JOB_CODE = VP |
453 |
|
JOB_GRADE = 2 |
458 |
|
FIRST_NAME = Bruce |
459 |
|
LAST_NAME = Young |
460 |
|
PHONE_EXT = 233 |
461 |
< |
HIRE_DATE = 28/12/1988 00:00:00.000 |
461 |
> |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
462 |
|
DEPT_NO = 621 |
463 |
|
JOB_CODE = Eng |
464 |
|
JOB_GRADE = 2 |
469 |
|
FIRST_NAME = Kim |
470 |
|
LAST_NAME = Lambert |
471 |
|
PHONE_EXT = 22 |
472 |
< |
HIRE_DATE = 6/2/1989 00:00:00.000 |
472 |
> |
HIRE_DATE = 1989/02/06 00:00:00.0000 |
473 |
|
DEPT_NO = 130 |
474 |
|
JOB_CODE = Eng |
475 |
|
JOB_GRADE = 2 |
486 |
|
Charset id = 0 |
487 |
|
Not Null |
488 |
|
Size = 2 |
489 |
+ |
Value = 0 |
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 |
495 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
496 |
|
DEPT_NO = 180 |
497 |
|
JOB_CODE = Mktg |
498 |
|
JOB_GRADE = 3 |
510 |
|
Charset id = 0 |
511 |
|
Not Null |
512 |
|
Size = 2 |
513 |
+ |
Value = 0 |
514 |
|
|
515 |
|
EMP_NO = 8 |
516 |
|
FIRST_NAME = Leslie |
517 |
|
LAST_NAME = Johnson |
518 |
|
PHONE_EXT = 410 |
519 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
519 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
520 |
|
DEPT_NO = 180 |
521 |
|
JOB_CODE = Mktg |
522 |
|
JOB_GRADE = 3 |
526 |
|
|
527 |
|
|
528 |
|
|
529 |
+ |
------------------------------------------------------ |
530 |
|
Running Test 3: ad hoc queries |
531 |
|
Opening localhost:employee |
532 |
|
Database Open |
540 |
|
"Yanowski" Employee Count = 1 |
541 |
|
|
542 |
|
|
543 |
+ |
------------------------------------------------------ |
544 |
|
Running Test 4: Update, Insert and Delete Queries |
545 |
|
Opening localhost:employee |
546 |
|
Database Open |
553 |
|
FIRST_NAME = Leslie |
554 |
|
LAST_NAME = Johnson |
555 |
|
PHONE_EXT = 410 |
556 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
556 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
557 |
|
DEPT_NO = 180 |
558 |
|
JOB_CODE = Mktg |
559 |
|
JOB_GRADE = 3 |
561 |
|
SALARY = 64,635.00 |
562 |
|
FULL_NAME = Johnson, Leslie |
563 |
|
|
564 |
< |
Current memory = 948664 |
565 |
< |
Delta memory = 1400 |
566 |
< |
Max memory = 992600 |
564 |
> |
Current memory = 948,560 |
565 |
> |
Delta memory = 1,400 |
566 |
> |
Max memory = 992,504 |
567 |
|
Elapsed time= 0.002 sec |
568 |
|
Cpu = 0.000 sec |
569 |
|
Buffers = 75 |
709 |
|
FIRST_NAME = John |
710 |
|
LAST_NAME = Doe |
711 |
|
PHONE_EXT = |
712 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
712 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
713 |
|
DEPT_NO = 600 |
714 |
|
JOB_CODE = Eng |
715 |
|
JOB_GRADE = 4 |
722 |
|
FIRST_NAME = Major |
723 |
|
LAST_NAME = Major |
724 |
|
PHONE_EXT = |
725 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
725 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
726 |
|
DEPT_NO = 600 |
727 |
|
JOB_CODE = Eng |
728 |
|
JOB_GRADE = 4 |
739 |
|
FIRST_NAME = Jane |
740 |
|
LAST_NAME = Doe |
741 |
|
PHONE_EXT = NULL |
742 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
742 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
743 |
|
DEPT_NO = 600 |
744 |
|
JOB_CODE = Eng |
745 |
|
JOB_GRADE = 4 |
756 |
|
FIRST_NAME = Jayne's |
757 |
|
LAST_NAME = Doe |
758 |
|
PHONE_EXT = NULL |
759 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
759 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
760 |
|
DEPT_NO = 600 |
761 |
|
JOB_CODE = Eng |
762 |
|
JOB_GRADE = 4 |
770 |
|
FIRST_NAME = Leslie |
771 |
|
LAST_NAME = Johnson |
772 |
|
PHONE_EXT = 410 |
773 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
773 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
774 |
|
DEPT_NO = 180 |
775 |
|
JOB_CODE = Mktg |
776 |
|
JOB_GRADE = 3 |
784 |
|
FIRST_NAME = Leslie |
785 |
|
LAST_NAME = Johnson |
786 |
|
PHONE_EXT = 410 |
787 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
787 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
788 |
|
DEPT_NO = 180 |
789 |
|
JOB_CODE = Mktg |
790 |
|
JOB_GRADE = 3 |
796 |
|
FIRST_NAME = Phil |
797 |
|
LAST_NAME = Forest |
798 |
|
PHONE_EXT = 229 |
799 |
< |
HIRE_DATE = 17/4/1989 00:00:00.000 |
799 |
> |
HIRE_DATE = 1989/04/17 00:00:00.0000 |
800 |
|
DEPT_NO = 622 |
801 |
|
JOB_CODE = Mngr |
802 |
|
JOB_GRADE = 3 |
810 |
|
FIRST_NAME = Leslie |
811 |
|
LAST_NAME = Johnson |
812 |
|
PHONE_EXT = 410 |
813 |
< |
HIRE_DATE = 31/1/2015 00:00:00.000 |
813 |
> |
HIRE_DATE = 2015/01/31 00:00:00.0000 |
814 |
|
DEPT_NO = 180 |
815 |
|
JOB_CODE = Mktg |
816 |
|
JOB_GRADE = 3 |
820 |
|
|
821 |
|
|
822 |
|
|
823 |
+ |
------------------------------------------------------ |
824 |
|
Running Test 5: Update Returning and Activity Check |
825 |
|
Opening localhost:employee |
826 |
|
Database Open |
832 |
|
FIRST_NAME = Leslie |
833 |
|
LAST_NAME = Johnson |
834 |
|
PHONE_EXT = 410 |
835 |
< |
HIRE_DATE = 31/1/2016 00:00:00.000 |
835 |
> |
HIRE_DATE = 2016/01/31 00:00:00.0000 |
836 |
|
DEPT_NO = 180 |
837 |
|
JOB_CODE = Mktg |
838 |
|
JOB_GRADE = 3 |
854 |
|
Transaction inactive |
855 |
|
|
856 |
|
|
857 |
+ |
------------------------------------------------------ |
858 |
|
Running Test 6: Blob Handling |
859 |
|
Metadata |
860 |
|
SQLType =SQL_TEXT |
881 |
|
Nullable |
882 |
|
Size = 2 |
883 |
|
|
884 |
< |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
884 |
> |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001) |
885 |
|
RDB$CHARACTER_SET_ID = 0 |
886 |
< |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
886 |
> |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001) |
887 |
|
RDB$CHARACTER_SET_ID = 1 |
888 |
< |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
888 |
> |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001) |
889 |
|
RDB$CHARACTER_SET_ID = 2 |
890 |
< |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
890 |
> |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001) |
891 |
|
RDB$CHARACTER_SET_ID = 3 |
892 |
< |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
892 |
> |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001) |
893 |
|
RDB$CHARACTER_SET_ID = 4 |
894 |
< |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
894 |
> |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001) |
895 |
|
RDB$CHARACTER_SET_ID = 5 |
896 |
< |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
896 |
> |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001) |
897 |
|
RDB$CHARACTER_SET_ID = 6 |
898 |
< |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
898 |
> |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001) |
899 |
|
RDB$CHARACTER_SET_ID = 9 |
900 |
< |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
900 |
> |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001) |
901 |
|
RDB$CHARACTER_SET_ID = 10 |
902 |
< |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
902 |
> |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001) |
903 |
|
RDB$CHARACTER_SET_ID = 11 |
904 |
< |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
904 |
> |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001) |
905 |
|
RDB$CHARACTER_SET_ID = 12 |
906 |
< |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
906 |
> |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001) |
907 |
|
RDB$CHARACTER_SET_ID = 13 |
908 |
< |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
908 |
> |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001) |
909 |
|
RDB$CHARACTER_SET_ID = 14 |
910 |
< |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
910 |
> |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001) |
911 |
|
RDB$CHARACTER_SET_ID = 15 |
912 |
< |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
912 |
> |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001) |
913 |
|
RDB$CHARACTER_SET_ID = 16 |
914 |
< |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
914 |
> |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001) |
915 |
|
RDB$CHARACTER_SET_ID = 17 |
916 |
< |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
916 |
> |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001) |
917 |
|
RDB$CHARACTER_SET_ID = 18 |
918 |
< |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
918 |
> |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001) |
919 |
|
RDB$CHARACTER_SET_ID = 19 |
920 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
920 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001) |
921 |
|
RDB$CHARACTER_SET_ID = 21 |
922 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
922 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001) |
923 |
|
RDB$CHARACTER_SET_ID = 22 |
924 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
924 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001) |
925 |
|
RDB$CHARACTER_SET_ID = 23 |
926 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
926 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001) |
927 |
|
RDB$CHARACTER_SET_ID = 34 |
928 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
928 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001) |
929 |
|
RDB$CHARACTER_SET_ID = 35 |
930 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
930 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001) |
931 |
|
RDB$CHARACTER_SET_ID = 36 |
932 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
932 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001) |
933 |
|
RDB$CHARACTER_SET_ID = 37 |
934 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
934 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001) |
935 |
|
RDB$CHARACTER_SET_ID = 38 |
936 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
936 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001) |
937 |
|
RDB$CHARACTER_SET_ID = 39 |
938 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
938 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001) |
939 |
|
RDB$CHARACTER_SET_ID = 40 |
940 |
< |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
940 |
> |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001) |
941 |
|
RDB$CHARACTER_SET_ID = 44 |
942 |
< |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
942 |
> |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001) |
943 |
|
RDB$CHARACTER_SET_ID = 45 |
944 |
< |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
944 |
> |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001) |
945 |
|
RDB$CHARACTER_SET_ID = 46 |
946 |
< |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
946 |
> |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001) |
947 |
|
RDB$CHARACTER_SET_ID = 47 |
948 |
< |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
948 |
> |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001) |
949 |
|
RDB$CHARACTER_SET_ID = 48 |
950 |
< |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
950 |
> |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001) |
951 |
|
RDB$CHARACTER_SET_ID = 49 |
952 |
< |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
952 |
> |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001) |
953 |
|
RDB$CHARACTER_SET_ID = 50 |
954 |
< |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
954 |
> |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001) |
955 |
|
RDB$CHARACTER_SET_ID = 51 |
956 |
< |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
956 |
> |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001) |
957 |
|
RDB$CHARACTER_SET_ID = 52 |
958 |
< |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
958 |
> |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001) |
959 |
|
RDB$CHARACTER_SET_ID = 53 |
960 |
< |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
960 |
> |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001) |
961 |
|
RDB$CHARACTER_SET_ID = 54 |
962 |
< |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
962 |
> |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001) |
963 |
|
RDB$CHARACTER_SET_ID = 55 |
964 |
< |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
964 |
> |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001) |
965 |
|
RDB$CHARACTER_SET_ID = 56 |
966 |
< |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
966 |
> |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001) |
967 |
|
RDB$CHARACTER_SET_ID = 57 |
968 |
< |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
968 |
> |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001) |
969 |
|
RDB$CHARACTER_SET_ID = 58 |
970 |
< |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
970 |
> |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001) |
971 |
|
RDB$CHARACTER_SET_ID = 59 |
972 |
< |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
972 |
> |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001) |
973 |
|
RDB$CHARACTER_SET_ID = 60 |
974 |
< |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
974 |
> |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001) |
975 |
|
RDB$CHARACTER_SET_ID = 63 |
976 |
< |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
976 |
> |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001) |
977 |
|
RDB$CHARACTER_SET_ID = 64 |
978 |
< |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
978 |
> |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001) |
979 |
|
RDB$CHARACTER_SET_ID = 65 |
980 |
< |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
980 |
> |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001) |
981 |
|
RDB$CHARACTER_SET_ID = 66 |
982 |
< |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
982 |
> |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001) |
983 |
|
RDB$CHARACTER_SET_ID = 67 |
984 |
< |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
984 |
> |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001) |
985 |
|
RDB$CHARACTER_SET_ID = 68 |
986 |
< |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
986 |
> |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001) |
987 |
|
RDB$CHARACTER_SET_ID = 69 |
988 |
|
|
989 |
|
Metadata |
1063 |
|
Charset id = 0 |
1064 |
|
Not Null |
1065 |
|
Size = 4 |
1066 |
+ |
Value = 0 |
1067 |
|
|
1068 |
|
SQLType =SQL_VARYING |
1069 |
|
sub type = 0 |
1092 |
|
ROWID = 1 |
1093 |
|
FIXEDPOINT = 20.28 |
1094 |
|
FLOATINGPOINT = 3.14 |
1095 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1095 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1096 |
|
BLOBDATA = NULL |
1097 |
|
|
1098 |
|
SQL Params |
1111 |
|
Charset id = 0 |
1112 |
|
Not Null |
1113 |
|
Size = 4 |
1114 |
+ |
Value = 0 |
1115 |
|
|
1116 |
|
ROWID = 1 |
1117 |
|
FIXEDPOINT = 20.28 |
1118 |
|
FLOATINGPOINT = 3.14 |
1119 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1119 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1120 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
1121 |
|
|
1122 |
|
To be or not to be-that is the question: |
1164 |
|
Charset id = 0 |
1165 |
|
Not Null |
1166 |
|
Size = 4 |
1167 |
+ |
Value = 0 |
1168 |
|
|
1169 |
|
SQLType =SQL_VARYING |
1170 |
|
sub type = 0 |
1193 |
|
ROWID = 1 |
1194 |
|
FIXEDPOINT = 20.28 |
1195 |
|
FLOATINGPOINT = 3.14 |
1196 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1196 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1197 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
1198 |
|
|
1199 |
|
To be or not to be-that is the question: |
1235 |
|
ROWID = 2 |
1236 |
|
FIXEDPOINT = NULL |
1237 |
|
FLOATINGPOINT = NULL |
1238 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1238 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1239 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
1240 |
|
|
1241 |
|
To be or not to be-that is the question: |
1360 |
|
Nullable |
1361 |
|
Size = 2 |
1362 |
|
|
1363 |
< |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1363 |
> |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252) |
1364 |
|
RDB$CHARACTER_SET_ID = 0 |
1365 |
< |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1365 |
> |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252) |
1366 |
|
RDB$CHARACTER_SET_ID = 1 |
1367 |
< |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1367 |
> |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252) |
1368 |
|
RDB$CHARACTER_SET_ID = 2 |
1369 |
< |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1369 |
> |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252) |
1370 |
|
RDB$CHARACTER_SET_ID = 3 |
1371 |
< |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1371 |
> |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252) |
1372 |
|
RDB$CHARACTER_SET_ID = 4 |
1373 |
< |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1373 |
> |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252) |
1374 |
|
RDB$CHARACTER_SET_ID = 5 |
1375 |
< |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1375 |
> |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252) |
1376 |
|
RDB$CHARACTER_SET_ID = 6 |
1377 |
< |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1377 |
> |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252) |
1378 |
|
RDB$CHARACTER_SET_ID = 9 |
1379 |
< |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1379 |
> |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252) |
1380 |
|
RDB$CHARACTER_SET_ID = 10 |
1381 |
< |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1381 |
> |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252) |
1382 |
|
RDB$CHARACTER_SET_ID = 11 |
1383 |
< |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1383 |
> |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252) |
1384 |
|
RDB$CHARACTER_SET_ID = 12 |
1385 |
< |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1385 |
> |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252) |
1386 |
|
RDB$CHARACTER_SET_ID = 13 |
1387 |
< |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1387 |
> |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252) |
1388 |
|
RDB$CHARACTER_SET_ID = 14 |
1389 |
< |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1389 |
> |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252) |
1390 |
|
RDB$CHARACTER_SET_ID = 15 |
1391 |
< |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1391 |
> |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252) |
1392 |
|
RDB$CHARACTER_SET_ID = 16 |
1393 |
< |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1393 |
> |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252) |
1394 |
|
RDB$CHARACTER_SET_ID = 17 |
1395 |
< |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1395 |
> |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252) |
1396 |
|
RDB$CHARACTER_SET_ID = 18 |
1397 |
< |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1397 |
> |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252) |
1398 |
|
RDB$CHARACTER_SET_ID = 19 |
1399 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1399 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252) |
1400 |
|
RDB$CHARACTER_SET_ID = 21 |
1401 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1401 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252) |
1402 |
|
RDB$CHARACTER_SET_ID = 22 |
1403 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1403 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252) |
1404 |
|
RDB$CHARACTER_SET_ID = 23 |
1405 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1405 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252) |
1406 |
|
RDB$CHARACTER_SET_ID = 34 |
1407 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1407 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252) |
1408 |
|
RDB$CHARACTER_SET_ID = 35 |
1409 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1409 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252) |
1410 |
|
RDB$CHARACTER_SET_ID = 36 |
1411 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1411 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252) |
1412 |
|
RDB$CHARACTER_SET_ID = 37 |
1413 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1413 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252) |
1414 |
|
RDB$CHARACTER_SET_ID = 38 |
1415 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1415 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252) |
1416 |
|
RDB$CHARACTER_SET_ID = 39 |
1417 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1417 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252) |
1418 |
|
RDB$CHARACTER_SET_ID = 40 |
1419 |
< |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1419 |
> |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252) |
1420 |
|
RDB$CHARACTER_SET_ID = 44 |
1421 |
< |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1421 |
> |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252) |
1422 |
|
RDB$CHARACTER_SET_ID = 45 |
1423 |
< |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1423 |
> |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252) |
1424 |
|
RDB$CHARACTER_SET_ID = 46 |
1425 |
< |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1425 |
> |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252) |
1426 |
|
RDB$CHARACTER_SET_ID = 47 |
1427 |
< |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1427 |
> |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252) |
1428 |
|
RDB$CHARACTER_SET_ID = 48 |
1429 |
< |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1429 |
> |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252) |
1430 |
|
RDB$CHARACTER_SET_ID = 49 |
1431 |
< |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1431 |
> |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252) |
1432 |
|
RDB$CHARACTER_SET_ID = 50 |
1433 |
< |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1433 |
> |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252) |
1434 |
|
RDB$CHARACTER_SET_ID = 51 |
1435 |
< |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1435 |
> |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252) |
1436 |
|
RDB$CHARACTER_SET_ID = 52 |
1437 |
< |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1437 |
> |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252) |
1438 |
|
RDB$CHARACTER_SET_ID = 53 |
1439 |
< |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1439 |
> |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252) |
1440 |
|
RDB$CHARACTER_SET_ID = 54 |
1441 |
< |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1441 |
> |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252) |
1442 |
|
RDB$CHARACTER_SET_ID = 55 |
1443 |
< |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1443 |
> |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252) |
1444 |
|
RDB$CHARACTER_SET_ID = 56 |
1445 |
< |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1445 |
> |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252) |
1446 |
|
RDB$CHARACTER_SET_ID = 57 |
1447 |
< |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1447 |
> |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252) |
1448 |
|
RDB$CHARACTER_SET_ID = 58 |
1449 |
< |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1449 |
> |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252) |
1450 |
|
RDB$CHARACTER_SET_ID = 59 |
1451 |
< |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1451 |
> |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252) |
1452 |
|
RDB$CHARACTER_SET_ID = 60 |
1453 |
< |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1453 |
> |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252) |
1454 |
|
RDB$CHARACTER_SET_ID = 63 |
1455 |
< |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1455 |
> |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252) |
1456 |
|
RDB$CHARACTER_SET_ID = 64 |
1457 |
< |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1457 |
> |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252) |
1458 |
|
RDB$CHARACTER_SET_ID = 65 |
1459 |
< |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1459 |
> |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252) |
1460 |
|
RDB$CHARACTER_SET_ID = 66 |
1461 |
< |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1461 |
> |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252) |
1462 |
|
RDB$CHARACTER_SET_ID = 67 |
1463 |
< |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1463 |
> |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252) |
1464 |
|
RDB$CHARACTER_SET_ID = 68 |
1465 |
< |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1465 |
> |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252) |
1466 |
|
RDB$CHARACTER_SET_ID = 69 |
1467 |
|
|
1468 |
|
Metadata |
1542 |
|
Charset id = 0 |
1543 |
|
Not Null |
1544 |
|
Size = 4 |
1545 |
+ |
Value = 0 |
1546 |
|
|
1547 |
|
SQLType =SQL_VARYING |
1548 |
|
sub type = 0 |
1571 |
|
ROWID = 1 |
1572 |
|
FIXEDPOINT = 20.28 |
1573 |
|
FLOATINGPOINT = 3.14 |
1574 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1574 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1575 |
|
BLOBDATA = NULL |
1576 |
|
|
1577 |
|
SQL Params |
1590 |
|
Charset id = 0 |
1591 |
|
Not Null |
1592 |
|
Size = 4 |
1593 |
+ |
Value = 0 |
1594 |
|
|
1595 |
|
ROWID = 1 |
1596 |
|
FIXEDPOINT = 20.28 |
1597 |
|
FLOATINGPOINT = 3.14 |
1598 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1598 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1599 |
|
BLOBDATA (Charset Id = 53 Codepage = 1252) |
1600 |
|
|
1601 |
|
To be or not to be-that is the question: |
1643 |
|
Charset id = 0 |
1644 |
|
Not Null |
1645 |
|
Size = 4 |
1646 |
+ |
Value = 0 |
1647 |
|
|
1648 |
|
SQLType =SQL_VARYING |
1649 |
|
sub type = 0 |
1672 |
|
ROWID = 1 |
1673 |
|
FIXEDPOINT = 20.28 |
1674 |
|
FLOATINGPOINT = 3.14 |
1675 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1675 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1676 |
|
BLOBDATA (Charset Id = 53 Codepage = 1252) |
1677 |
|
|
1678 |
|
To be or not to be-that is the question: |
1714 |
|
ROWID = 2 |
1715 |
|
FIXEDPOINT = NULL |
1716 |
|
FLOATINGPOINT = NULL |
1717 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1717 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1718 |
|
BLOBDATA (Charset Id = 53 Codepage = 1252) |
1719 |
|
|
1720 |
|
To be or not to be-that is the question: |
1839 |
|
Nullable |
1840 |
|
Size = 2 |
1841 |
|
|
1842 |
< |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1842 |
> |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001) |
1843 |
|
RDB$CHARACTER_SET_ID = 0 |
1844 |
< |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1844 |
> |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001) |
1845 |
|
RDB$CHARACTER_SET_ID = 1 |
1846 |
< |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1846 |
> |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001) |
1847 |
|
RDB$CHARACTER_SET_ID = 2 |
1848 |
< |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1848 |
> |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001) |
1849 |
|
RDB$CHARACTER_SET_ID = 3 |
1850 |
< |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1850 |
> |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001) |
1851 |
|
RDB$CHARACTER_SET_ID = 4 |
1852 |
< |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1852 |
> |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001) |
1853 |
|
RDB$CHARACTER_SET_ID = 5 |
1854 |
< |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1854 |
> |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001) |
1855 |
|
RDB$CHARACTER_SET_ID = 6 |
1856 |
< |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1856 |
> |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001) |
1857 |
|
RDB$CHARACTER_SET_ID = 9 |
1858 |
< |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1858 |
> |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001) |
1859 |
|
RDB$CHARACTER_SET_ID = 10 |
1860 |
< |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1860 |
> |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001) |
1861 |
|
RDB$CHARACTER_SET_ID = 11 |
1862 |
< |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1862 |
> |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001) |
1863 |
|
RDB$CHARACTER_SET_ID = 12 |
1864 |
< |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1864 |
> |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001) |
1865 |
|
RDB$CHARACTER_SET_ID = 13 |
1866 |
< |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1866 |
> |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001) |
1867 |
|
RDB$CHARACTER_SET_ID = 14 |
1868 |
< |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1868 |
> |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001) |
1869 |
|
RDB$CHARACTER_SET_ID = 15 |
1870 |
< |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1870 |
> |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001) |
1871 |
|
RDB$CHARACTER_SET_ID = 16 |
1872 |
< |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1872 |
> |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001) |
1873 |
|
RDB$CHARACTER_SET_ID = 17 |
1874 |
< |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1874 |
> |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001) |
1875 |
|
RDB$CHARACTER_SET_ID = 18 |
1876 |
< |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1876 |
> |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001) |
1877 |
|
RDB$CHARACTER_SET_ID = 19 |
1878 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1878 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001) |
1879 |
|
RDB$CHARACTER_SET_ID = 21 |
1880 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1880 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001) |
1881 |
|
RDB$CHARACTER_SET_ID = 22 |
1882 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1882 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001) |
1883 |
|
RDB$CHARACTER_SET_ID = 23 |
1884 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1884 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001) |
1885 |
|
RDB$CHARACTER_SET_ID = 34 |
1886 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1886 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001) |
1887 |
|
RDB$CHARACTER_SET_ID = 35 |
1888 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1888 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001) |
1889 |
|
RDB$CHARACTER_SET_ID = 36 |
1890 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1890 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001) |
1891 |
|
RDB$CHARACTER_SET_ID = 37 |
1892 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1892 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001) |
1893 |
|
RDB$CHARACTER_SET_ID = 38 |
1894 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1894 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001) |
1895 |
|
RDB$CHARACTER_SET_ID = 39 |
1896 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1896 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001) |
1897 |
|
RDB$CHARACTER_SET_ID = 40 |
1898 |
< |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1898 |
> |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001) |
1899 |
|
RDB$CHARACTER_SET_ID = 44 |
1900 |
< |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1900 |
> |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001) |
1901 |
|
RDB$CHARACTER_SET_ID = 45 |
1902 |
< |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1902 |
> |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001) |
1903 |
|
RDB$CHARACTER_SET_ID = 46 |
1904 |
< |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1904 |
> |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001) |
1905 |
|
RDB$CHARACTER_SET_ID = 47 |
1906 |
< |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1906 |
> |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001) |
1907 |
|
RDB$CHARACTER_SET_ID = 48 |
1908 |
< |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1908 |
> |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001) |
1909 |
|
RDB$CHARACTER_SET_ID = 49 |
1910 |
< |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1910 |
> |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001) |
1911 |
|
RDB$CHARACTER_SET_ID = 50 |
1912 |
< |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1912 |
> |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001) |
1913 |
|
RDB$CHARACTER_SET_ID = 51 |
1914 |
< |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1914 |
> |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001) |
1915 |
|
RDB$CHARACTER_SET_ID = 52 |
1916 |
< |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1916 |
> |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001) |
1917 |
|
RDB$CHARACTER_SET_ID = 53 |
1918 |
< |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1918 |
> |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001) |
1919 |
|
RDB$CHARACTER_SET_ID = 54 |
1920 |
< |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1920 |
> |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001) |
1921 |
|
RDB$CHARACTER_SET_ID = 55 |
1922 |
< |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1922 |
> |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001) |
1923 |
|
RDB$CHARACTER_SET_ID = 56 |
1924 |
< |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1924 |
> |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001) |
1925 |
|
RDB$CHARACTER_SET_ID = 57 |
1926 |
< |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1926 |
> |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001) |
1927 |
|
RDB$CHARACTER_SET_ID = 58 |
1928 |
< |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1928 |
> |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001) |
1929 |
|
RDB$CHARACTER_SET_ID = 59 |
1930 |
< |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1930 |
> |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001) |
1931 |
|
RDB$CHARACTER_SET_ID = 60 |
1932 |
< |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1932 |
> |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001) |
1933 |
|
RDB$CHARACTER_SET_ID = 63 |
1934 |
< |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1934 |
> |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001) |
1935 |
|
RDB$CHARACTER_SET_ID = 64 |
1936 |
< |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1936 |
> |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001) |
1937 |
|
RDB$CHARACTER_SET_ID = 65 |
1938 |
< |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1938 |
> |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001) |
1939 |
|
RDB$CHARACTER_SET_ID = 66 |
1940 |
< |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1940 |
> |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001) |
1941 |
|
RDB$CHARACTER_SET_ID = 67 |
1942 |
< |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1942 |
> |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001) |
1943 |
|
RDB$CHARACTER_SET_ID = 68 |
1944 |
< |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1944 |
> |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001) |
1945 |
|
RDB$CHARACTER_SET_ID = 69 |
1946 |
|
|
1947 |
|
Metadata |
2021 |
|
Charset id = 0 |
2022 |
|
Not Null |
2023 |
|
Size = 4 |
2024 |
+ |
Value = 0 |
2025 |
|
|
2026 |
|
SQLType =SQL_VARYING |
2027 |
|
sub type = 0 |
2050 |
|
ROWID = 1 |
2051 |
|
FIXEDPOINT = 20.28 |
2052 |
|
FLOATINGPOINT = 3.14 |
2053 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2053 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2054 |
|
BLOBDATA = NULL |
2055 |
|
|
2056 |
|
SQL Params |
2069 |
|
Charset id = 0 |
2070 |
|
Not Null |
2071 |
|
Size = 4 |
2072 |
+ |
Value = 0 |
2073 |
|
|
2074 |
|
ROWID = 1 |
2075 |
|
FIXEDPOINT = 20.28 |
2076 |
|
FLOATINGPOINT = 3.14 |
2077 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2077 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2078 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
2079 |
|
|
2080 |
|
To be or not to be-that is the question: |
2122 |
|
Charset id = 0 |
2123 |
|
Not Null |
2124 |
|
Size = 4 |
2125 |
+ |
Value = 0 |
2126 |
|
|
2127 |
|
SQLType =SQL_VARYING |
2128 |
|
sub type = 0 |
2151 |
|
ROWID = 1 |
2152 |
|
FIXEDPOINT = 20.28 |
2153 |
|
FLOATINGPOINT = 3.14 |
2154 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2154 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2155 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
2156 |
|
|
2157 |
|
To be or not to be-that is the question: |
2193 |
|
ROWID = 2 |
2194 |
|
FIXEDPOINT = NULL |
2195 |
|
FLOATINGPOINT = NULL |
2196 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2196 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2197 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
2198 |
|
|
2199 |
|
To be or not to be-that is the question: |
2295 |
|
|
2296 |
|
|
2297 |
|
|
2298 |
+ |
------------------------------------------------------ |
2299 |
|
Running Test 7: Create and read back an Array |
2300 |
|
Metadata |
2301 |
|
SQLType =SQL_LONG |
2367 |
|
Dimensions = 1 |
2368 |
|
Bounds: (0:16) |
2369 |
|
|
2370 |
+ |
SQLType =SQL_ARRAY |
2371 |
+ |
sub type = 0 |
2372 |
+ |
Table = TESTDATA |
2373 |
+ |
Owner = SYSDBA |
2374 |
+ |
Column Name = MYARRAY2 |
2375 |
+ |
Alias Name = MYARRAY2 |
2376 |
+ |
Field Name = MYARRAY2 |
2377 |
+ |
Scale = 0 |
2378 |
+ |
Charset id = 0 |
2379 |
+ |
Nullable |
2380 |
+ |
Size = 8 |
2381 |
+ |
Array Meta Data: |
2382 |
+ |
SQLType =SQL_TIMESTAMP |
2383 |
+ |
Scale = 0 |
2384 |
+ |
Charset id = 0 |
2385 |
+ |
Size = 8 |
2386 |
+ |
Table = TESTDATA |
2387 |
+ |
Column = MYARRAY2 |
2388 |
+ |
Dimensions = 1 |
2389 |
+ |
Bounds: (0:16) |
2390 |
+ |
|
2391 |
+ |
SQLType =SQL_ARRAY |
2392 |
+ |
sub type = 0 |
2393 |
+ |
Table = TESTDATA |
2394 |
+ |
Owner = SYSDBA |
2395 |
+ |
Column Name = MYARRAY3 |
2396 |
+ |
Alias Name = MYARRAY3 |
2397 |
+ |
Field Name = MYARRAY3 |
2398 |
+ |
Scale = 0 |
2399 |
+ |
Charset id = 0 |
2400 |
+ |
Nullable |
2401 |
+ |
Size = 8 |
2402 |
+ |
Array Meta Data: |
2403 |
+ |
SQLType =SQL_INT64 |
2404 |
+ |
Scale = -2 |
2405 |
+ |
Charset id = 0 |
2406 |
+ |
Size = 8 |
2407 |
+ |
Table = TESTDATA |
2408 |
+ |
Column = MYARRAY3 |
2409 |
+ |
Dimensions = 1 |
2410 |
+ |
Bounds: (0:16) |
2411 |
+ |
|
2412 |
|
SQL Params |
2413 |
|
SQLType =SQL_LONG |
2414 |
|
sub type = 0 |
2417 |
|
Charset id = 0 |
2418 |
|
Not Null |
2419 |
|
Size = 4 |
2420 |
+ |
Value = 0 |
2421 |
|
|
2422 |
|
SQLType =SQL_VARYING |
2423 |
|
sub type = 0 |
2448 |
|
Param Name = DATED |
2449 |
|
Param Name = NOTES |
2450 |
|
ROWID = 1 |
2451 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2452 |
< |
DATED = 1/4/2016 09:30:00.100 |
2453 |
< |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
2451 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2452 |
> |
DATED = 2016/04/01 09:30:00.1000 |
2453 |
> |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) |
2454 |
|
MYARRAY = NULL |
2455 |
+ |
MYARRAY2 = NULL |
2456 |
+ |
MYARRAY3 = NULL |
2457 |
|
|
2458 |
|
SQL Params |
2459 |
|
SQLType =SQL_ARRAY |
2464 |
|
Nullable |
2465 |
|
Size = 8 |
2466 |
|
|
2467 |
+ |
SQL Params |
2468 |
+ |
SQLType =SQL_ARRAY |
2469 |
+ |
sub type = 0 |
2470 |
+ |
Field Name = MYARRAY2 |
2471 |
+ |
Scale = 0 |
2472 |
+ |
Charset id = 0 |
2473 |
+ |
Nullable |
2474 |
+ |
Size = 8 |
2475 |
+ |
|
2476 |
+ |
SQL Params |
2477 |
+ |
SQLType =SQL_ARRAY |
2478 |
+ |
sub type = 0 |
2479 |
+ |
Field Name = MYARRAY3 |
2480 |
+ |
Scale = 0 |
2481 |
+ |
Charset id = 0 |
2482 |
+ |
Nullable |
2483 |
+ |
Size = 8 |
2484 |
+ |
|
2485 |
+ |
Metadata |
2486 |
+ |
SQLType =SQL_LONG |
2487 |
+ |
sub type = 0 |
2488 |
+ |
Table = TESTDATA |
2489 |
+ |
Owner = SYSDBA |
2490 |
+ |
Column Name = ROWID |
2491 |
+ |
Alias Name = ROWID |
2492 |
+ |
Field Name = ROWID |
2493 |
+ |
Scale = 0 |
2494 |
+ |
Charset id = 0 |
2495 |
+ |
Not Null |
2496 |
+ |
Size = 4 |
2497 |
+ |
|
2498 |
+ |
SQLType =SQL_VARYING |
2499 |
+ |
sub type = 0 |
2500 |
+ |
Table = TESTDATA |
2501 |
+ |
Owner = SYSDBA |
2502 |
+ |
Column Name = TITLE |
2503 |
+ |
Alias Name = TITLE |
2504 |
+ |
Field Name = TITLE |
2505 |
+ |
Scale = 0 |
2506 |
+ |
Charset id = 4 |
2507 |
+ |
Nullable |
2508 |
+ |
Size = 128 |
2509 |
+ |
|
2510 |
+ |
SQLType =SQL_TIMESTAMP |
2511 |
+ |
sub type = 0 |
2512 |
+ |
Table = TESTDATA |
2513 |
+ |
Owner = SYSDBA |
2514 |
+ |
Column Name = DATED |
2515 |
+ |
Alias Name = DATED |
2516 |
+ |
Field Name = DATED |
2517 |
+ |
Scale = 0 |
2518 |
+ |
Charset id = 0 |
2519 |
+ |
Nullable |
2520 |
+ |
Size = 8 |
2521 |
+ |
|
2522 |
+ |
SQLType =SQL_VARYING |
2523 |
+ |
sub type = 0 |
2524 |
+ |
Table = TESTDATA |
2525 |
+ |
Owner = SYSDBA |
2526 |
+ |
Column Name = NOTES |
2527 |
+ |
Alias Name = NOTES |
2528 |
+ |
Field Name = NOTES |
2529 |
+ |
Scale = 0 |
2530 |
+ |
Charset id = 4 |
2531 |
+ |
Nullable |
2532 |
+ |
Size = 256 |
2533 |
+ |
|
2534 |
+ |
SQLType =SQL_ARRAY |
2535 |
+ |
sub type = 0 |
2536 |
+ |
Table = TESTDATA |
2537 |
+ |
Owner = SYSDBA |
2538 |
+ |
Column Name = MYARRAY |
2539 |
+ |
Alias Name = MYARRAY |
2540 |
+ |
Field Name = MYARRAY |
2541 |
+ |
Scale = 0 |
2542 |
+ |
Charset id = 0 |
2543 |
+ |
Nullable |
2544 |
+ |
Size = 8 |
2545 |
+ |
Array Meta Data: |
2546 |
+ |
SQLType =SQL_LONG |
2547 |
+ |
Scale = 0 |
2548 |
+ |
Charset id = 0 |
2549 |
+ |
Size = 4 |
2550 |
+ |
Table = TESTDATA |
2551 |
+ |
Column = MYARRAY |
2552 |
+ |
Dimensions = 1 |
2553 |
+ |
Bounds: (0:16) |
2554 |
+ |
|
2555 |
+ |
SQLType =SQL_ARRAY |
2556 |
+ |
sub type = 0 |
2557 |
+ |
Table = TESTDATA |
2558 |
+ |
Owner = SYSDBA |
2559 |
+ |
Column Name = MYARRAY2 |
2560 |
+ |
Alias Name = MYARRAY2 |
2561 |
+ |
Field Name = MYARRAY2 |
2562 |
+ |
Scale = 0 |
2563 |
+ |
Charset id = 0 |
2564 |
+ |
Nullable |
2565 |
+ |
Size = 8 |
2566 |
+ |
Array Meta Data: |
2567 |
+ |
SQLType =SQL_TIMESTAMP |
2568 |
+ |
Scale = 0 |
2569 |
+ |
Charset id = 0 |
2570 |
+ |
Size = 8 |
2571 |
+ |
Table = TESTDATA |
2572 |
+ |
Column = MYARRAY2 |
2573 |
+ |
Dimensions = 1 |
2574 |
+ |
Bounds: (0:16) |
2575 |
+ |
|
2576 |
+ |
SQLType =SQL_ARRAY |
2577 |
+ |
sub type = 0 |
2578 |
+ |
Table = TESTDATA |
2579 |
+ |
Owner = SYSDBA |
2580 |
+ |
Column Name = MYARRAY3 |
2581 |
+ |
Alias Name = MYARRAY3 |
2582 |
+ |
Field Name = MYARRAY3 |
2583 |
+ |
Scale = 0 |
2584 |
+ |
Charset id = 0 |
2585 |
+ |
Nullable |
2586 |
+ |
Size = 8 |
2587 |
+ |
Array Meta Data: |
2588 |
+ |
SQLType =SQL_INT64 |
2589 |
+ |
Scale = -2 |
2590 |
+ |
Charset id = 0 |
2591 |
+ |
Size = 8 |
2592 |
+ |
Table = TESTDATA |
2593 |
+ |
Column = MYARRAY3 |
2594 |
+ |
Dimensions = 1 |
2595 |
+ |
Bounds: (0:16) |
2596 |
+ |
|
2597 |
|
ROWID = 1 |
2598 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2599 |
< |
DATED = 1/4/2016 09:30:00.100 |
2600 |
< |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
2601 |
< |
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) |
2598 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2599 |
> |
DATED = 2016/04/01 09:30:00.1000 |
2600 |
> |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) |
2601 |
> |
MYARRAY = Array: (0: 100) (1: 99) (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84) |
2602 |
> |
|
2603 |
> |
MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) |
2604 |
> |
|
2605 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79) |
2606 |
> |
|
2607 |
|
|
2608 |
|
Shrink to 2:10 |
2609 |
|
Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) |
2610 |
+ |
|
2611 |
|
Write updated reduced slice |
2612 |
|
Show update array |
2613 |
|
ROWID = 1 |
2614 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2615 |
< |
DATED = 1/4/2016 09:30:00.100 |
2616 |
< |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
2617 |
< |
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) |
2614 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2615 |
> |
DATED = 2016/04/01 09:30:00.1000 |
2616 |
> |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) |
2617 |
> |
MYARRAY = Array: (0: 100) (1: 99) (2: 1000) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84) |
2618 |
> |
|
2619 |
> |
MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) |
2620 |
> |
|
2621 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79) |
2622 |
|
|
2623 |
|
|
2624 |
|
|
2625 |
+ |
|
2626 |
+ |
------------------------------------------------------ |
2627 |
|
Running Test 8: Create and read back an Array with 2 dimensions |
2628 |
|
Metadata |
2629 |
|
SQLType =SQL_LONG |
2679 |
|
Charset id = 0 |
2680 |
|
Not Null |
2681 |
|
Size = 4 |
2682 |
+ |
Value = 0 |
2683 |
|
|
2684 |
|
SQLType =SQL_VARYING |
2685 |
|
sub type = 0 |
2690 |
|
Size = 128 |
2691 |
|
|
2692 |
|
ROWID = 1 |
2693 |
< |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8) |
2693 |
> |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001) |
2694 |
|
MYARRAY = NULL |
2695 |
|
|
2696 |
|
ROWID = 1 |
2697 |
< |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8) |
2698 |
< |
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) |
2697 |
> |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001) |
2698 |
> |
MYARRAY = Array: (0,-1: A50) (0,0: A51) (0,1: A52) (0,2: A53) (0,3: A54) (0,4: A55) (0,5: A56) (0,6: A57) (0,7: A58) (1,-1: A59) (1,0: A60) (1,1: A61) (1,2: A62) (1,3: A63) (1,4: A64) (1,5: A65) (1,6: A66) (1,7: A67) (2,-1: A68) (2,0: A69) (2,1: A70) (2,2: A71) (2,3: A72) (2,4: A73) (2,5: A74) (2,6: A75) (2,7: A76) (3,-1: A77) (3,0: A78) (3,1: A79) (3,2: A80) (3,3: A81) (3,4: A82) (3,5: A83) (3,6: A84) (3,7: A85) (4,-1: A86) (4,0: A87) (4,1: A88) (4,2: A89) (4,3: A90) (4,4: A91) (4,5: A92) (4,6: A93) (4,7: A94) (5,-1: A95) (5,0: A96) (5,1: A97) (5,2: A98) (5,3: A99) (5,4: A100) (5,5: A101) (5,6: A102) (5,7: A103) (6,-1: A104) (6,0: A105) (6,1: A106) (6,2: A107) (6,3: A108) (6,4: A109) (6,5: A110) (6,6: A111) (6,7: A112) (7,-1: A113) (7,0: A114) (7,1: A115) (7,2: A116) (7,3: A117) (7,4: A118) (7,5: A119) (7,6: A120) (7,7: A121) (8,-1: A122) (8,0: A123) (8,1: A124) (8,2: A125) (8,3: A126) (8,4: A127) (8,5: A128) (8,6: A129) (8,7: A130) (9,-1: A131) (9,0: A132) (9,1: A133) (9,2: A134) (9,3: A135) (9,4: A136) (9,5: A137) (9,6: A138) (9,7: A139) (10,-1: A140) (10,0: A141) (10,1: A142) (10,2: A143) (10,3: A144) (10,4: A145) (10,5: A146) (10,6: A147) (10,7: A148) (11,-1: A149) (11,0: A150) (11,1: A151) (11,2: A152) (11,3: A153) (11,4: A154) (11,5: A155) (11,6: A156) (11,7: A157) (12,-1: A158) (12,0: A159) (12,1: A160) (12,2: A161) (12,3: A162) (12,4: A163) (12,5: A164) (12,6: A165) (12,7: A166) (13,-1: A167) (13,0: A168) (13,1: A169) (13,2: A170) (13,3: A171) (13,4: A172) (13,5: A173) (13,6: A174) (13,7: A175) (14,-1: A176) (14,0: A177) (14,1: A178) (14,2: A179) (14,3: A180) (14,4: A181) (14,5: A182) (14,6: A183) (14,7: A184) (15,-1: A185) (15,0: A186) (15,1: A187) (15,2: A188) (15,3: A189) (15,4: A190) (15,5: A191) (15,6: A192) (15,7: A193) (16,-1: A194) (16,0: A195) (16,1: A196) (16,2: A197) (16,3: A198) (16,4: A199) (16,5: A200) (16,6: A201) (16,7: A202) |
2699 |
> |
|
2700 |
|
|
2701 |
|
|
2702 |
|
|
2703 |
+ |
------------------------------------------------------ |
2704 |
|
Running Test 9: Database Information tests |
2705 |
|
Database ID = 4 FB = /opt/firebird2.5.9/examples/empbuild/employee.fdb SN = zeus |
2706 |
|
Pages =272 |
2717 |
|
Unknown Response 3 |
2718 |
|
Server Memory = 841392 |
2719 |
|
Forced Writes = 1 |
2720 |
< |
Max Memory = 879352 |
2720 |
> |
Max Memory = 879240 |
2721 |
|
Num Buffers = 75 |
2722 |
|
Sweep Interval = 20000 |
2723 |
|
Logged in Users: SYSDBA, |
2763 |
|
Page Size = 4096 |
2764 |
|
|
2765 |
|
|
2766 |
+ |
------------------------------------------------------ |
2767 |
|
Running Test 10: Event Handling |
2768 |
|
Call Async Wait |
2769 |
|
Async Wait Called |
2787 |
|
Event Counts: TESTEVENT, Count = 2 |
2788 |
|
|
2789 |
|
|
2790 |
+ |
------------------------------------------------------ |
2791 |
|
Running Test 11: Services API |
2792 |
+ |
SPB: Item Count = 2 |
2793 |
+ |
user_name = SYSDBA |
2794 |
+ |
password = masterkey |
2795 |
+ |
|
2796 |
|
Service Manager Version = 2 |
2797 |
|
Server Version = LI-V2.5.9.27139 Firebird 2.5 |
2798 |
|
Implementation = Firebird/linux AMD64 |
2814 |
|
Group ID = 0 |
2815 |
|
|
2816 |
|
|
2817 |
< |
Licence Info: |
2368 |
< |
feature is not supported |
2817 |
> |
Licence Info: feature is not supported |
2818 |
|
-feature is not supported |
2819 |
|
|
2820 |
< |
Licence Mask Info: |
2372 |
< |
feature is not supported |
2820 |
> |
Licence Mask Info: feature is not supported |
2821 |
|
|
2822 |
|
Capabilities = 260 |
2823 |
|
|
2847 |
|
Database Dropped |
2848 |
|
|
2849 |
|
|
2850 |
+ |
------------------------------------------------------ |
2851 |
|
Running Test 12: Character Sets |
2852 |
|
SQL Params |
2853 |
|
SQLType =SQL_LONG |
2857 |
|
Charset id = 0 |
2858 |
|
Not Null |
2859 |
|
Size = 4 |
2860 |
+ |
Value = 0 |
2861 |
|
|
2862 |
|
SQLType =SQL_VARYING |
2863 |
|
sub type = 0 |
2907 |
|
Nullable |
2908 |
|
Size = 16 |
2909 |
|
|
2910 |
+ |
Show Param Values |
2911 |
+ |
SQL Params |
2912 |
+ |
SQLType =SQL_LONG |
2913 |
+ |
sub type = 0 |
2914 |
+ |
Field Name = ROWID |
2915 |
+ |
Scale = 0 |
2916 |
+ |
Charset id = 0 |
2917 |
+ |
Not Null |
2918 |
+ |
Size = 4 |
2919 |
+ |
Value = 1 |
2920 |
+ |
|
2921 |
+ |
SQLType =SQL_TEXT |
2922 |
+ |
sub type = 0 |
2923 |
+ |
Field Name = TITLE |
2924 |
+ |
Scale = 0 |
2925 |
+ |
Charset id = 4 |
2926 |
+ |
Nullable |
2927 |
+ |
Size = 128 |
2928 |
+ |
Value = Blob Test ©€ |
2929 |
+ |
|
2930 |
+ |
SQLType =SQL_TEXT |
2931 |
+ |
sub type = 0 |
2932 |
+ |
Field Name = NOTES |
2933 |
+ |
Scale = 0 |
2934 |
+ |
Charset id = 4 |
2935 |
+ |
Nullable |
2936 |
+ |
Size = 256 |
2937 |
+ |
Value = Écoute moi |
2938 |
+ |
|
2939 |
+ |
SQLType =SQL_TEXT |
2940 |
+ |
sub type = 0 |
2941 |
+ |
Field Name = BLOBDATA |
2942 |
+ |
Scale = 0 |
2943 |
+ |
Charset id = 1 |
2944 |
+ |
Nullable |
2945 |
+ |
Size = 8 |
2946 |
+ |
Value = Some German Special Characters like Ă–Ă„ĂœĂ¶Ă¤Ă¼ĂŸ |
2947 |
+ |
|
2948 |
+ |
SQLType =SQL_BLOB |
2949 |
+ |
sub type = 1 |
2950 |
+ |
Field Name = BLOBDATA2 |
2951 |
+ |
Scale = 0 |
2952 |
+ |
Charset id = 4 |
2953 |
+ |
Nullable |
2954 |
+ |
Size = 8 |
2955 |
+ |
Value = Some German Special Characters like Ă–Ă„ĂœĂ¶Ă¤Ă¼ĂŸ |
2956 |
+ |
|
2957 |
+ |
SQLType =SQL_TEXT |
2958 |
+ |
sub type = 0 |
2959 |
+ |
Field Name = INCLEAR |
2960 |
+ |
Scale = 0 |
2961 |
+ |
Charset id = 1 |
2962 |
+ |
Nullable |
2963 |
+ |
Size = 16 |
2964 |
+ |
Value = &Test |
2965 |
|
|
2966 |
+ |
|
2967 |
+ |
SQLType =SQL_TEXT |
2968 |
+ |
sub type = 0 |
2969 |
+ |
Field Name = FIXEDWIDTH |
2970 |
+ |
Scale = 0 |
2971 |
+ |
Charset id = 4 |
2972 |
+ |
Nullable |
2973 |
+ |
Size = 16 |
2974 |
+ |
Value = É |
2975 |
+ |
|
2976 |
|
Connection Character Set UTF8 |
2977 |
|
ROWID = 1 |
2978 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2979 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
2978 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
2979 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
2980 |
|
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) |
2981 |
|
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) |
2982 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
2983 |
< |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001 Byte Length = 5) |
2982 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
2983 |
> |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001) |
2984 |
|
|
2985 |
|
Connection Character Set NONE |
2986 |
|
ROWID = 1 |
2987 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2988 |
< |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591 Byte Length = 10) |
2987 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
2988 |
> |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591) |
2989 |
|
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) |
2990 |
|
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) |
2991 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
2992 |
< |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001 Byte Length = 5) |
2991 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
2992 |
> |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001) |
2993 |
|
|
2994 |
|
Connection Character Set WIN1252 |
2995 |
|
ROWID = 1 |
2996 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252 Byte Length = 12) |
2997 |
< |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252 Byte Length = 10) |
2996 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252) |
2997 |
> |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252) |
2998 |
|
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) |
2999 |
|
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) |
3000 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3001 |
< |
FIXEDWIDTH = C9 (Charset Id = 53 Codepage = 1252 Byte Length = 4) |
3000 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3001 |
> |
FIXEDWIDTH = C9 (Charset Id = 53 Codepage = 1252) |
3002 |
|
|
3003 |
|
|
3004 |
|
|
3005 |
+ |
------------------------------------------------------ |
3006 |
|
Running Test 13: Transaction over two databases |
3007 |
|
Init Database 1 |
3008 |
|
ROWID = 1 |
3009 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
3010 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3009 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
3010 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3011 |
|
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) |
3012 |
|
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) |
3013 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3013 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3014 |
|
|
3015 |
|
Init Database 2 |
3016 |
|
ROWID = 1 |
3017 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
3018 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3017 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
3018 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3019 |
|
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) |
3020 |
|
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) |
3021 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3021 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3022 |
|
|
3023 |
|
ROWID = 1 |
3024 |
< |
TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3025 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3024 |
> |
TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001) |
3025 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3026 |
|
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) |
3027 |
|
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) |
3028 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3028 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3029 |
|
|
3030 |
|
ROWID = 1 |
3031 |
< |
TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3032 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3031 |
> |
TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001) |
3032 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3033 |
|
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) |
3034 |
|
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) |
3035 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3035 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3036 |
|
|
3037 |
|
|
3038 |
|
|
3039 |
+ |
------------------------------------------------------ |
3040 |
|
Running Test 14: Non select procedures |
3041 |
|
Default Character set Name = UTF8 |
3042 |
|
Metadata |
3064 |
|
Size = 128 |
3065 |
|
|
3066 |
|
ROWID = 1 |
3067 |
< |
TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7) |
3067 |
> |
TITLE = Testing (Charset Id = 4 Codepage = 65001) |
3068 |
|
|
3069 |
|
Repeat with a different execute transaction |
3070 |
|
|
3071 |
|
ROWID = 1 |
3072 |
< |
TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7) |
3072 |
> |
TITLE = Testing (Charset Id = 4 Codepage = 65001) |
3073 |
|
|
3074 |
|
Repeat with a original transaction |
3075 |
|
|
3076 |
|
ROWID = 1 |
3077 |
< |
TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7) |
3077 |
> |
TITLE = Testing (Charset Id = 4 Codepage = 65001) |
3078 |
|
|
3079 |
|
|
3080 |
+ |
------------------------------------------------------ |
3081 |
|
Running Test 15: Blob Handling and BPBs |
3082 |
|
|
3083 |
|
Testdata |
3084 |
|
|
3085 |
|
ROWID = 1 |
3086 |
< |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3086 |
> |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001) |
3087 |
|
BLOBDATA = (blob), Length = 92514 |
3088 |
|
|
3089 |
+ |
ROWID = 2 |
3090 |
+ |
TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001) |
3091 |
+ |
BLOBDATA = (blob), Length = 13 |
3092 |
+ |
0 9 A C9 63 6F 75 74 65 20 6D 6F 69 |
3093 |
|
|
3094 |
|
Testdata 2 |
3095 |
|
|
3096 |
|
ROWID = 1 |
3097 |
< |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3097 |
> |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001) |
3098 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
3099 |
|
|
3100 |
|
Écoute moi |
3101 |
|
|
3102 |
|
|
3103 |
|
|
3104 |
+ |
------------------------------------------------------ |
3105 |
|
Running Test 16: Error handling |
3106 |
|
Invalid Database Name Test |
3107 |
< |
Error Handled: |
2585 |
< |
I/O error during "open" operation for file "Malformed Name" |
3107 |
> |
Error Handled: I/O error during "open" operation for file "Malformed Name" |
3108 |
|
-Error while trying to open file |
3109 |
|
-No such file or directory |
3110 |
|
Invalid User Name Test |
3111 |
< |
Error Handled: |
2590 |
< |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3111 |
> |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3112 |
|
Invalid password Test |
3113 |
< |
Error Handled: |
2593 |
< |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3113 |
> |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3114 |
|
Invalid Prepare SQL Test |
3115 |
< |
Error Handled: |
2596 |
< |
Dynamic SQL Error |
3115 |
> |
Error Handled: Dynamic SQL Error |
3116 |
|
-SQL error code = -206 |
3117 |
|
-Column unknown |
3118 |
|
-UNKNOWN_DATE |
3119 |
|
-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
3120 |
|
Invalid Open Cursor SQL Test |
3121 |
< |
Error Handled: |
2603 |
< |
Dynamic SQL Error |
3121 |
> |
Error Handled: Dynamic SQL Error |
3122 |
|
-SQL error code = -206 |
3123 |
|
-Column unknown |
3124 |
|
-X |
3130 |
|
Case sensitive Param SQL Test |
3131 |
|
Error Handled: Field "EMP_NO" not found |
3132 |
|
Invalid Server Name Test |
3133 |
< |
Error Handled: |
2616 |
< |
Unable to complete network request to host "unknown". |
3133 |
> |
Error Handled: Unable to complete network request to host "unknown". |
3134 |
|
-Failed to locate host machine |
3135 |
|
Invalid User Name Test |
3136 |
< |
Error Handled: |
2620 |
< |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3136 |
> |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3137 |
|
Invalid password Test |
3138 |
< |
Error Handled: |
3139 |
< |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3138 |
> |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3139 |
> |
|
3140 |
> |
|
3141 |
> |
------------------------------------------------------ |
3142 |
> |
Running Test 17: Date/Time tests and Firebird 4 extensions |
3143 |
> |
FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5" |
3144 |
> |
Has Local TZ DB = FALSE |
3145 |
> |
|
3146 |
> |
Testdata |
3147 |
> |
|
3148 |
> |
Metadata |
3149 |
> |
SQLType =SQL_LONG |
3150 |
> |
sub type = 0 |
3151 |
> |
Table = TESTDATA |
3152 |
> |
Owner = SYSDBA |
3153 |
> |
Column Name = ROWID |
3154 |
> |
Alias Name = ROWID |
3155 |
> |
Field Name = ROWID |
3156 |
> |
Scale = 0 |
3157 |
> |
Charset id = 0 |
3158 |
> |
Not Null |
3159 |
> |
Size = 4 |
3160 |
> |
|
3161 |
> |
SQLType =SQL_TYPE_DATE |
3162 |
> |
sub type = 0 |
3163 |
> |
Table = TESTDATA |
3164 |
> |
Owner = SYSDBA |
3165 |
> |
Column Name = DATECOL |
3166 |
> |
Alias Name = DATECOL |
3167 |
> |
Field Name = DATECOL |
3168 |
> |
Scale = 0 |
3169 |
> |
Charset id = 0 |
3170 |
> |
Nullable |
3171 |
> |
Size = 4 |
3172 |
> |
|
3173 |
> |
SQLType =SQL_TYPE_TIME |
3174 |
> |
sub type = 0 |
3175 |
> |
Table = TESTDATA |
3176 |
> |
Owner = SYSDBA |
3177 |
> |
Column Name = TIMECOL |
3178 |
> |
Alias Name = TIMECOL |
3179 |
> |
Field Name = TIMECOL |
3180 |
> |
Scale = 0 |
3181 |
> |
Charset id = 0 |
3182 |
> |
Nullable |
3183 |
> |
Size = 4 |
3184 |
> |
|
3185 |
> |
SQLType =SQL_TIMESTAMP |
3186 |
> |
sub type = 0 |
3187 |
> |
Table = TESTDATA |
3188 |
> |
Owner = SYSDBA |
3189 |
> |
Column Name = TIMESTAMPCOL |
3190 |
> |
Alias Name = TIMESTAMPCOL |
3191 |
> |
Field Name = TIMESTAMPCOL |
3192 |
> |
Scale = 0 |
3193 |
> |
Charset id = 0 |
3194 |
> |
Nullable |
3195 |
> |
Size = 8 |
3196 |
> |
|
3197 |
> |
ROWID = 1 |
3198 |
> |
DATECOL = 2019/04/01 |
3199 |
> |
TIMECOL = 11:31:05.0001 |
3200 |
> |
TIMESTAMPCOL = 2016/02/29 22:02:35.0001 |
3201 |
> |
ROWID = 2 |
3202 |
> |
DATECOL = 1939/09/03 |
3203 |
> |
TIMECOL = 15:40:00.0002 |
3204 |
> |
TIMESTAMPCOL = 1918/11/11 11:11:00.0000 |
3205 |
> |
ROWID = 3 |
3206 |
> |
DATECOL = 1066/10/14 |
3207 |
> |
TIMECOL = 23:59:59.9994 |
3208 |
> |
TIMESTAMPCOL = 1918/11/11 11:11:00.0000 |
3209 |
> |
ROWID = 4 |
3210 |
> |
DATECOL = 1815/06/18 |
3211 |
> |
TIMECOL = 00:01:40.1115 |
3212 |
> |
TIMESTAMPCOL = 1945/05/08 22:10:00.0010 |
3213 |
> |
|
3214 |
> |
|
3215 |
> |
Testdata - second pass |
3216 |
> |
|
3217 |
> |
1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35 |
3218 |
> |
2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00 |
3219 |
> |
3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00 |
3220 |
> |
4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00 |
3221 |
> |
Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1 |
3222 |
> |
Skipping Firebird 4 and later test part |
3223 |
> |
|
3224 |
> |
|
3225 |
> |
------------------------------------------------------ |
3226 |
> |
Running Test 18: Firebird 4 Decfloat extensions |
3227 |
> |
FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5" |
3228 |
> |
Skipping test for Firebird 4 and later |
3229 |
> |
|
3230 |
> |
|
3231 |
> |
------------------------------------------------------ |
3232 |
> |
Running Test 19: Batch Update and Insert Queries |
3233 |
> |
Opening localhost:employee |
3234 |
> |
Skipping test for Firebird 4 and later |
3235 |
> |
|
3236 |
> |
|
3237 |
> |
------------------------------------------------------ |
3238 |
> |
Running Test 20: Stress Test IBatch interface |
3239 |
> |
FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5" |
3240 |
> |
Skipping test for Firebird 4 and later |
3241 |
|
|
3242 |
|
|
3243 |
+ |
------------------------------------------------------ |
3244 |
|
Test Suite Ends |