1 |
|
Firebird API Test Suite |
2 |
< |
Copyright MWA Software 2016 |
2 |
> |
Copyright MWA Software 2016-2021 |
3 |
|
|
4 |
|
Starting Tests |
5 |
|
Client API Version = 3.0 |
6 |
+ |
Firebird Environment Variable = /opt/firebird3.0.5 |
7 |
+ |
Firebird Bin Directory = /opt/firebird3.0.5/bin |
8 |
+ |
Firebird Conf Directory = /opt/firebird3.0.5/ |
9 |
+ |
Firebird Client Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
10 |
|
Running Test 1: Create and Drop a Database |
11 |
|
Creating a Database with empty parameters |
12 |
< |
Create Database fails (as expected): |
9 |
< |
I/O error during "open O_CREAT" operation for file "" |
12 |
> |
Create Database fails (as expected): I/O error during "open O_CREAT" operation for file "" |
13 |
|
-Error while trying to create file |
14 |
|
-No such file or directory |
15 |
|
Creating a Database using an SQL Statement |
16 |
< |
Database ID = 2 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
16 |
> |
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
17 |
|
SQL Dialect = 3 |
18 |
< |
DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb |
18 |
> |
DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb |
19 |
|
DB Charset ID = 0 |
20 |
|
DB SQL Dialect = 3 |
21 |
< |
DB Remote Protocol = |
21 |
> |
DB Remote Protocol = TCPv4 |
22 |
|
DB ODS Major Version = 12 |
23 |
|
DB ODS Minor Version = 0 |
24 |
< |
User Authentication Method = User name in DPB |
24 |
> |
User Authentication Method = Srp |
25 |
|
Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
26 |
|
DB Client Implementation Version = 3.0 |
27 |
< |
DPB |
28 |
< |
Count = 3 |
29 |
< |
28 = SYSDBA |
30 |
< |
29 = masterkey |
31 |
< |
65 = 3 |
27 |
> |
DPB: Item Count = 3 |
28 |
> |
isc_dpb_user_name = SYSDBA |
29 |
> |
isc_dpb_password = masterkey |
30 |
> |
isc_dpb_set_db_sql_dialect = 3 |
31 |
> |
|
32 |
> |
Firebird Server Version Info |
33 |
> |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0" |
34 |
> |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C" |
35 |
> |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C" |
36 |
> |
on disk structure version 12.0 |
37 |
|
|
38 |
|
Dropping Database |
39 |
|
Creating a Database with a DPD |
40 |
< |
DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb |
40 |
> |
DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb |
41 |
|
DB Charset ID = 4 |
42 |
|
DB SQL Dialect = 3 |
43 |
< |
DB Remote Protocol = |
43 |
> |
DB Remote Protocol = TCPv4 |
44 |
|
DB ODS Major Version = 12 |
45 |
|
DB ODS Minor Version = 0 |
46 |
< |
User Authentication Method = User name in DPB |
46 |
> |
User Authentication Method = Srp |
47 |
|
Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
48 |
|
DB Client Implementation Version = 3.0 |
49 |
|
Dropping Database |
50 |
< |
DPB |
51 |
< |
Count = 4 |
52 |
< |
28 = SYSDBA |
53 |
< |
29 = masterkey |
54 |
< |
48 = UTF8 |
47 |
< |
65 = 3 |
50 |
> |
DPB: Item Count = 4 |
51 |
> |
isc_dpb_user_name = SYSDBA |
52 |
> |
isc_dpb_password = masterkey |
53 |
> |
isc_dpb_lc_ctype = UTF8 |
54 |
> |
isc_dpb_set_db_sql_dialect = 3 |
55 |
|
|
56 |
|
Creating a Database with a DPD |
57 |
< |
Database ID = 2 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
57 |
> |
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
58 |
|
ODS major = 12 |
59 |
|
ODS minor = 0 |
60 |
< |
DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb |
60 |
> |
DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb |
61 |
|
DB Charset ID = 4 |
62 |
|
DB SQL Dialect = 3 |
63 |
< |
DB Remote Protocol = |
63 |
> |
DB Remote Protocol = TCPv4 |
64 |
|
DB ODS Major Version = 12 |
65 |
|
DB ODS Minor Version = 0 |
66 |
< |
User Authentication Method = User name in DPB |
66 |
> |
User Authentication Method = Srp |
67 |
|
Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
68 |
|
DB Client Implementation Version = 3.0 |
69 |
|
RDB$DESCRIPTION = |
74 |
|
Dropping Database |
75 |
|
|
76 |
|
|
77 |
+ |
------------------------------------------------------ |
78 |
|
Running Test 2: Open the employee database and run a query |
79 |
|
Opening inet://localhost/employee |
80 |
|
Database Open, SQL Dialect = 3 |
81 |
+ |
TPB: Item Count = 3 |
82 |
+ |
isc_tpb_read |
83 |
+ |
isc_tpb_nowait |
84 |
+ |
isc_tpb_concurrency |
85 |
+ |
|
86 |
+ |
Metadata |
87 |
+ |
SQLType =SQL_SHORT |
88 |
+ |
sub type = 0 |
89 |
+ |
Table = EMPLOYEE |
90 |
+ |
Owner = SYSDBA |
91 |
+ |
Column Name = EMP_NO |
92 |
+ |
Alias Name = EMP_NO |
93 |
+ |
Field Name = EMP_NO |
94 |
+ |
Scale = 0 |
95 |
+ |
Charset id = 0 |
96 |
+ |
Not Null |
97 |
+ |
Size = 2 |
98 |
+ |
|
99 |
+ |
SQLType =SQL_VARYING |
100 |
+ |
sub type = 0 |
101 |
+ |
Table = EMPLOYEE |
102 |
+ |
Owner = SYSDBA |
103 |
+ |
Column Name = FIRST_NAME |
104 |
+ |
Alias Name = FIRST_NAME |
105 |
+ |
Field Name = FIRST_NAME |
106 |
+ |
Scale = 0 |
107 |
+ |
Charset id = 0 |
108 |
+ |
Not Null |
109 |
+ |
Size = 15 |
110 |
+ |
|
111 |
+ |
SQLType =SQL_VARYING |
112 |
+ |
sub type = 0 |
113 |
+ |
Table = EMPLOYEE |
114 |
+ |
Owner = SYSDBA |
115 |
+ |
Column Name = LAST_NAME |
116 |
+ |
Alias Name = LAST_NAME |
117 |
+ |
Field Name = LAST_NAME |
118 |
+ |
Scale = 0 |
119 |
+ |
Charset id = 0 |
120 |
+ |
Not Null |
121 |
+ |
Size = 20 |
122 |
+ |
|
123 |
+ |
SQLType =SQL_VARYING |
124 |
+ |
sub type = 0 |
125 |
+ |
Table = EMPLOYEE |
126 |
+ |
Owner = SYSDBA |
127 |
+ |
Column Name = PHONE_EXT |
128 |
+ |
Alias Name = PHONE_EXT |
129 |
+ |
Field Name = PHONE_EXT |
130 |
+ |
Scale = 0 |
131 |
+ |
Charset id = 0 |
132 |
+ |
Nullable |
133 |
+ |
Size = 4 |
134 |
+ |
|
135 |
+ |
SQLType =SQL_TIMESTAMP |
136 |
+ |
sub type = 0 |
137 |
+ |
Table = EMPLOYEE |
138 |
+ |
Owner = SYSDBA |
139 |
+ |
Column Name = HIRE_DATE |
140 |
+ |
Alias Name = HIRE_DATE |
141 |
+ |
Field Name = HIRE_DATE |
142 |
+ |
Scale = 0 |
143 |
+ |
Charset id = 0 |
144 |
+ |
Not Null |
145 |
+ |
Size = 8 |
146 |
+ |
|
147 |
+ |
SQLType =SQL_TEXT |
148 |
+ |
sub type = 0 |
149 |
+ |
Table = EMPLOYEE |
150 |
+ |
Owner = SYSDBA |
151 |
+ |
Column Name = DEPT_NO |
152 |
+ |
Alias Name = DEPT_NO |
153 |
+ |
Field Name = DEPT_NO |
154 |
+ |
Scale = 0 |
155 |
+ |
Charset id = 0 |
156 |
+ |
Not Null |
157 |
+ |
Size = 3 |
158 |
+ |
|
159 |
+ |
SQLType =SQL_VARYING |
160 |
+ |
sub type = 0 |
161 |
+ |
Table = EMPLOYEE |
162 |
+ |
Owner = SYSDBA |
163 |
+ |
Column Name = JOB_CODE |
164 |
+ |
Alias Name = JOB_CODE |
165 |
+ |
Field Name = JOB_CODE |
166 |
+ |
Scale = 0 |
167 |
+ |
Charset id = 0 |
168 |
+ |
Not Null |
169 |
+ |
Size = 5 |
170 |
+ |
|
171 |
+ |
SQLType =SQL_SHORT |
172 |
+ |
sub type = 0 |
173 |
+ |
Table = EMPLOYEE |
174 |
+ |
Owner = SYSDBA |
175 |
+ |
Column Name = JOB_GRADE |
176 |
+ |
Alias Name = JOB_GRADE |
177 |
+ |
Field Name = JOB_GRADE |
178 |
+ |
Scale = 0 |
179 |
+ |
Charset id = 0 |
180 |
+ |
Not Null |
181 |
+ |
Size = 2 |
182 |
+ |
|
183 |
+ |
SQLType =SQL_VARYING |
184 |
+ |
sub type = 0 |
185 |
+ |
Table = EMPLOYEE |
186 |
+ |
Owner = SYSDBA |
187 |
+ |
Column Name = JOB_COUNTRY |
188 |
+ |
Alias Name = JOB_COUNTRY |
189 |
+ |
Field Name = JOB_COUNTRY |
190 |
+ |
Scale = 0 |
191 |
+ |
Charset id = 0 |
192 |
+ |
Not Null |
193 |
+ |
Size = 15 |
194 |
+ |
|
195 |
+ |
SQLType =SQL_INT64 |
196 |
+ |
sub type = 0 |
197 |
+ |
Table = EMPLOYEE |
198 |
+ |
Owner = SYSDBA |
199 |
+ |
Column Name = SALARY |
200 |
+ |
Alias Name = SALARY |
201 |
+ |
Field Name = SALARY |
202 |
+ |
Scale = -2 |
203 |
+ |
Charset id = 0 |
204 |
+ |
Not Null |
205 |
+ |
Size = 8 |
206 |
+ |
|
207 |
+ |
SQLType =SQL_VARYING |
208 |
+ |
sub type = 0 |
209 |
+ |
Table = EMPLOYEE |
210 |
+ |
Owner = SYSDBA |
211 |
+ |
Column Name = FULL_NAME |
212 |
+ |
Alias Name = FULL_NAME |
213 |
+ |
Field Name = FULL_NAME |
214 |
+ |
Scale = 0 |
215 |
+ |
Charset id = 0 |
216 |
+ |
Nullable |
217 |
+ |
Size = 37 |
218 |
+ |
|
219 |
+ |
Plan = |
220 |
+ |
Select Expression |
221 |
+ |
-> First N Records |
222 |
+ |
-> Table "EMPLOYEE" Full Scan |
223 |
+ |
-- SQL style inline comment |
224 |
+ |
/* this is a comment */ Select First 3 * from EMPLOYEE |
225 |
+ |
|
226 |
+ |
EMP_NO = 2 |
227 |
+ |
FIRST_NAME = Robert |
228 |
+ |
LAST_NAME = Nelson |
229 |
+ |
PHONE_EXT = 250 |
230 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
231 |
+ |
DEPT_NO = 600 |
232 |
+ |
JOB_CODE = VP |
233 |
+ |
JOB_GRADE = 2 |
234 |
+ |
JOB_COUNTRY = USA |
235 |
+ |
SALARY = 105,900.00 |
236 |
+ |
FULL_NAME = Nelson, Robert |
237 |
+ |
EMP_NO = 4 |
238 |
+ |
FIRST_NAME = Bruce |
239 |
+ |
LAST_NAME = Young |
240 |
+ |
PHONE_EXT = 233 |
241 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
242 |
+ |
DEPT_NO = 621 |
243 |
+ |
JOB_CODE = Eng |
244 |
+ |
JOB_GRADE = 2 |
245 |
+ |
JOB_COUNTRY = USA |
246 |
+ |
SALARY = 97,500.00 |
247 |
+ |
FULL_NAME = Young, Bruce |
248 |
+ |
EMP_NO = 5 |
249 |
+ |
FIRST_NAME = Kim |
250 |
+ |
LAST_NAME = Lambert |
251 |
+ |
PHONE_EXT = 22 |
252 |
+ |
HIRE_DATE = 1989/02/06 00:00:00.0000 |
253 |
+ |
DEPT_NO = 130 |
254 |
+ |
JOB_CODE = Eng |
255 |
+ |
JOB_GRADE = 2 |
256 |
+ |
JOB_COUNTRY = USA |
257 |
+ |
SALARY = 102,750.00 |
258 |
+ |
FULL_NAME = Lambert, Kim |
259 |
+ |
|
260 |
+ |
Select * from EMPLOYEE Where EMP_NO = ? |
261 |
+ |
SQL Params |
262 |
+ |
SQLType =SQL_SHORT |
263 |
+ |
sub type = 0 |
264 |
+ |
Field Name = |
265 |
+ |
Scale = 0 |
266 |
+ |
Charset id = 0 |
267 |
+ |
Not Null |
268 |
+ |
Size = 2 |
269 |
+ |
Value = 0 |
270 |
+ |
|
271 |
+ |
EMP_NO = 8 |
272 |
+ |
FIRST_NAME = Leslie |
273 |
+ |
LAST_NAME = Johnson |
274 |
+ |
PHONE_EXT = 410 |
275 |
+ |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
276 |
+ |
DEPT_NO = 180 |
277 |
+ |
JOB_CODE = Mktg |
278 |
+ |
JOB_GRADE = 3 |
279 |
+ |
JOB_COUNTRY = USA |
280 |
+ |
SALARY = 64,635.00 |
281 |
+ |
FULL_NAME = Johnson, Leslie |
282 |
+ |
|
283 |
+ |
With param names |
284 |
+ |
Select * from EMPLOYEE Where EMP_NO = :EMP_NO |
285 |
+ |
SQL Params |
286 |
+ |
SQLType =SQL_SHORT |
287 |
+ |
sub type = 0 |
288 |
+ |
Field Name = EMP_NO |
289 |
+ |
Scale = 0 |
290 |
+ |
Charset id = 0 |
291 |
+ |
Not Null |
292 |
+ |
Size = 2 |
293 |
+ |
Value = 0 |
294 |
+ |
|
295 |
+ |
EMP_NO = 8 |
296 |
+ |
FIRST_NAME = Leslie |
297 |
+ |
LAST_NAME = Johnson |
298 |
+ |
PHONE_EXT = 410 |
299 |
+ |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
300 |
+ |
DEPT_NO = 180 |
301 |
+ |
JOB_CODE = Mktg |
302 |
+ |
JOB_GRADE = 3 |
303 |
+ |
JOB_COUNTRY = USA |
304 |
+ |
SALARY = 64,635.00 |
305 |
+ |
FULL_NAME = Johnson, Leslie |
306 |
+ |
|
307 |
+ |
Now open the employee database as a local database |
308 |
+ |
TPB: Item Count = 3 |
309 |
+ |
isc_tpb_read |
310 |
+ |
isc_tpb_nowait |
311 |
+ |
isc_tpb_concurrency |
312 |
+ |
|
313 |
|
Metadata |
314 |
|
SQLType =SQL_SHORT |
315 |
|
sub type = 0 |
454 |
|
FIRST_NAME = Robert |
455 |
|
LAST_NAME = Nelson |
456 |
|
PHONE_EXT = 250 |
457 |
< |
HIRE_DATE = 28/12/1988 00:00:00.000 |
457 |
> |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
458 |
|
DEPT_NO = 600 |
459 |
|
JOB_CODE = VP |
460 |
|
JOB_GRADE = 2 |
465 |
|
FIRST_NAME = Bruce |
466 |
|
LAST_NAME = Young |
467 |
|
PHONE_EXT = 233 |
468 |
< |
HIRE_DATE = 28/12/1988 00:00:00.000 |
468 |
> |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
469 |
|
DEPT_NO = 621 |
470 |
|
JOB_CODE = Eng |
471 |
|
JOB_GRADE = 2 |
476 |
|
FIRST_NAME = Kim |
477 |
|
LAST_NAME = Lambert |
478 |
|
PHONE_EXT = 22 |
479 |
< |
HIRE_DATE = 6/2/1989 00:00:00.000 |
479 |
> |
HIRE_DATE = 1989/02/06 00:00:00.0000 |
480 |
|
DEPT_NO = 130 |
481 |
|
JOB_CODE = Eng |
482 |
|
JOB_GRADE = 2 |
493 |
|
Charset id = 0 |
494 |
|
Not Null |
495 |
|
Size = 2 |
496 |
+ |
Value = 0 |
497 |
|
|
498 |
|
EMP_NO = 8 |
499 |
|
FIRST_NAME = Leslie |
500 |
|
LAST_NAME = Johnson |
501 |
|
PHONE_EXT = 410 |
502 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
502 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
503 |
|
DEPT_NO = 180 |
504 |
|
JOB_CODE = Mktg |
505 |
|
JOB_GRADE = 3 |
517 |
|
Charset id = 0 |
518 |
|
Not Null |
519 |
|
Size = 2 |
520 |
+ |
Value = 0 |
521 |
|
|
522 |
|
EMP_NO = 8 |
523 |
|
FIRST_NAME = Leslie |
524 |
|
LAST_NAME = Johnson |
525 |
|
PHONE_EXT = 410 |
526 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
526 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
527 |
|
DEPT_NO = 180 |
528 |
|
JOB_CODE = Mktg |
529 |
|
JOB_GRADE = 3 |
533 |
|
|
534 |
|
|
535 |
|
|
536 |
+ |
------------------------------------------------------ |
537 |
|
Running Test 3: ad hoc queries |
538 |
|
Opening inet://localhost/employee |
539 |
|
Database Open |
547 |
|
"Yanowski" Employee Count = 1 |
548 |
|
|
549 |
|
|
550 |
+ |
------------------------------------------------------ |
551 |
|
Running Test 4: Update, Insert and Delete Queries |
552 |
|
Opening inet://localhost/employee |
553 |
|
Database Open |
560 |
|
FIRST_NAME = Leslie |
561 |
|
LAST_NAME = Johnson |
562 |
|
PHONE_EXT = 410 |
563 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
563 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
564 |
|
DEPT_NO = 180 |
565 |
|
JOB_CODE = Mktg |
566 |
|
JOB_GRADE = 3 |
568 |
|
SALARY = 64,635.00 |
569 |
|
FULL_NAME = Johnson, Leslie |
570 |
|
|
571 |
< |
Current memory = 19693296 |
572 |
< |
Delta memory = 4480 |
573 |
< |
Max memory = 19755408 |
571 |
> |
Current memory = 19,693,312 |
572 |
> |
Delta memory = 4,480 |
573 |
> |
Max memory = 19,755,424 |
574 |
|
Elapsed time= 0.001 sec |
575 |
|
Cpu = 0.000 sec |
576 |
|
Buffers = 2048 |
716 |
|
FIRST_NAME = John |
717 |
|
LAST_NAME = Doe |
718 |
|
PHONE_EXT = |
719 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
719 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
720 |
|
DEPT_NO = 600 |
721 |
|
JOB_CODE = Eng |
722 |
|
JOB_GRADE = 4 |
729 |
|
FIRST_NAME = Major |
730 |
|
LAST_NAME = Major |
731 |
|
PHONE_EXT = |
732 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
732 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
733 |
|
DEPT_NO = 600 |
734 |
|
JOB_CODE = Eng |
735 |
|
JOB_GRADE = 4 |
746 |
|
FIRST_NAME = Jane |
747 |
|
LAST_NAME = Doe |
748 |
|
PHONE_EXT = NULL |
749 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
749 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
750 |
|
DEPT_NO = 600 |
751 |
|
JOB_CODE = Eng |
752 |
|
JOB_GRADE = 4 |
763 |
|
FIRST_NAME = Jayne's |
764 |
|
LAST_NAME = Doe |
765 |
|
PHONE_EXT = NULL |
766 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
766 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
767 |
|
DEPT_NO = 600 |
768 |
|
JOB_CODE = Eng |
769 |
|
JOB_GRADE = 4 |
777 |
|
FIRST_NAME = Leslie |
778 |
|
LAST_NAME = Johnson |
779 |
|
PHONE_EXT = 410 |
780 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
780 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
781 |
|
DEPT_NO = 180 |
782 |
|
JOB_CODE = Mktg |
783 |
|
JOB_GRADE = 3 |
791 |
|
FIRST_NAME = Leslie |
792 |
|
LAST_NAME = Johnson |
793 |
|
PHONE_EXT = 410 |
794 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
794 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
795 |
|
DEPT_NO = 180 |
796 |
|
JOB_CODE = Mktg |
797 |
|
JOB_GRADE = 3 |
803 |
|
FIRST_NAME = Phil |
804 |
|
LAST_NAME = Forest |
805 |
|
PHONE_EXT = 229 |
806 |
< |
HIRE_DATE = 17/4/1989 00:00:00.000 |
806 |
> |
HIRE_DATE = 1989/04/17 00:00:00.0000 |
807 |
|
DEPT_NO = 622 |
808 |
|
JOB_CODE = Mngr |
809 |
|
JOB_GRADE = 3 |
817 |
|
FIRST_NAME = Leslie |
818 |
|
LAST_NAME = Johnson |
819 |
|
PHONE_EXT = 410 |
820 |
< |
HIRE_DATE = 31/1/2015 00:00:00.000 |
820 |
> |
HIRE_DATE = 2015/01/31 00:00:00.0000 |
821 |
|
DEPT_NO = 180 |
822 |
|
JOB_CODE = Mktg |
823 |
|
JOB_GRADE = 3 |
827 |
|
|
828 |
|
|
829 |
|
|
830 |
+ |
------------------------------------------------------ |
831 |
|
Running Test 5: Update Returning and Activity Check |
832 |
|
Opening inet://localhost/employee |
833 |
|
Database Open |
839 |
|
FIRST_NAME = Leslie |
840 |
|
LAST_NAME = Johnson |
841 |
|
PHONE_EXT = 410 |
842 |
< |
HIRE_DATE = 31/1/2016 00:00:00.000 |
842 |
> |
HIRE_DATE = 2016/01/31 00:00:00.0000 |
843 |
|
DEPT_NO = 180 |
844 |
|
JOB_CODE = Mktg |
845 |
|
JOB_GRADE = 3 |
861 |
|
Transaction inactive |
862 |
|
|
863 |
|
|
864 |
+ |
------------------------------------------------------ |
865 |
|
Running Test 6: Blob Handling |
866 |
|
Metadata |
867 |
|
SQLType =SQL_TEXT |
888 |
|
Nullable |
889 |
|
Size = 2 |
890 |
|
|
891 |
< |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
891 |
> |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001) |
892 |
|
RDB$CHARACTER_SET_ID = 0 |
893 |
< |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
893 |
> |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001) |
894 |
|
RDB$CHARACTER_SET_ID = 1 |
895 |
< |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
895 |
> |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001) |
896 |
|
RDB$CHARACTER_SET_ID = 2 |
897 |
< |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
897 |
> |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001) |
898 |
|
RDB$CHARACTER_SET_ID = 3 |
899 |
< |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
899 |
> |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001) |
900 |
|
RDB$CHARACTER_SET_ID = 4 |
901 |
< |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
901 |
> |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001) |
902 |
|
RDB$CHARACTER_SET_ID = 5 |
903 |
< |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
903 |
> |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001) |
904 |
|
RDB$CHARACTER_SET_ID = 6 |
905 |
< |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
905 |
> |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001) |
906 |
|
RDB$CHARACTER_SET_ID = 9 |
907 |
< |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
907 |
> |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001) |
908 |
|
RDB$CHARACTER_SET_ID = 10 |
909 |
< |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
909 |
> |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001) |
910 |
|
RDB$CHARACTER_SET_ID = 11 |
911 |
< |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
911 |
> |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001) |
912 |
|
RDB$CHARACTER_SET_ID = 12 |
913 |
< |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
913 |
> |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001) |
914 |
|
RDB$CHARACTER_SET_ID = 13 |
915 |
< |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
915 |
> |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001) |
916 |
|
RDB$CHARACTER_SET_ID = 14 |
917 |
< |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
917 |
> |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001) |
918 |
|
RDB$CHARACTER_SET_ID = 15 |
919 |
< |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
919 |
> |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001) |
920 |
|
RDB$CHARACTER_SET_ID = 16 |
921 |
< |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
921 |
> |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001) |
922 |
|
RDB$CHARACTER_SET_ID = 17 |
923 |
< |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
923 |
> |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001) |
924 |
|
RDB$CHARACTER_SET_ID = 18 |
925 |
< |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
925 |
> |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001) |
926 |
|
RDB$CHARACTER_SET_ID = 19 |
927 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
927 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001) |
928 |
|
RDB$CHARACTER_SET_ID = 21 |
929 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
929 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001) |
930 |
|
RDB$CHARACTER_SET_ID = 22 |
931 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
931 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001) |
932 |
|
RDB$CHARACTER_SET_ID = 23 |
933 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
933 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001) |
934 |
|
RDB$CHARACTER_SET_ID = 34 |
935 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
935 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001) |
936 |
|
RDB$CHARACTER_SET_ID = 35 |
937 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
937 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001) |
938 |
|
RDB$CHARACTER_SET_ID = 36 |
939 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
939 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001) |
940 |
|
RDB$CHARACTER_SET_ID = 37 |
941 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
941 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001) |
942 |
|
RDB$CHARACTER_SET_ID = 38 |
943 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
943 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001) |
944 |
|
RDB$CHARACTER_SET_ID = 39 |
945 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
945 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001) |
946 |
|
RDB$CHARACTER_SET_ID = 40 |
947 |
< |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
947 |
> |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001) |
948 |
|
RDB$CHARACTER_SET_ID = 44 |
949 |
< |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
949 |
> |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001) |
950 |
|
RDB$CHARACTER_SET_ID = 45 |
951 |
< |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
951 |
> |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001) |
952 |
|
RDB$CHARACTER_SET_ID = 46 |
953 |
< |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
953 |
> |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001) |
954 |
|
RDB$CHARACTER_SET_ID = 47 |
955 |
< |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
955 |
> |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001) |
956 |
|
RDB$CHARACTER_SET_ID = 48 |
957 |
< |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
957 |
> |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001) |
958 |
|
RDB$CHARACTER_SET_ID = 49 |
959 |
< |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
959 |
> |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001) |
960 |
|
RDB$CHARACTER_SET_ID = 50 |
961 |
< |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
961 |
> |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001) |
962 |
|
RDB$CHARACTER_SET_ID = 51 |
963 |
< |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
963 |
> |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001) |
964 |
|
RDB$CHARACTER_SET_ID = 52 |
965 |
< |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
965 |
> |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001) |
966 |
|
RDB$CHARACTER_SET_ID = 53 |
967 |
< |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
967 |
> |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001) |
968 |
|
RDB$CHARACTER_SET_ID = 54 |
969 |
< |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
969 |
> |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001) |
970 |
|
RDB$CHARACTER_SET_ID = 55 |
971 |
< |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
971 |
> |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001) |
972 |
|
RDB$CHARACTER_SET_ID = 56 |
973 |
< |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
973 |
> |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001) |
974 |
|
RDB$CHARACTER_SET_ID = 57 |
975 |
< |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
975 |
> |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001) |
976 |
|
RDB$CHARACTER_SET_ID = 58 |
977 |
< |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
977 |
> |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001) |
978 |
|
RDB$CHARACTER_SET_ID = 59 |
979 |
< |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
979 |
> |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001) |
980 |
|
RDB$CHARACTER_SET_ID = 60 |
981 |
< |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
981 |
> |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001) |
982 |
|
RDB$CHARACTER_SET_ID = 63 |
983 |
< |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
983 |
> |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001) |
984 |
|
RDB$CHARACTER_SET_ID = 64 |
985 |
< |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
985 |
> |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001) |
986 |
|
RDB$CHARACTER_SET_ID = 65 |
987 |
< |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
987 |
> |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001) |
988 |
|
RDB$CHARACTER_SET_ID = 66 |
989 |
< |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
989 |
> |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001) |
990 |
|
RDB$CHARACTER_SET_ID = 67 |
991 |
< |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
991 |
> |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001) |
992 |
|
RDB$CHARACTER_SET_ID = 68 |
993 |
< |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
993 |
> |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001) |
994 |
|
RDB$CHARACTER_SET_ID = 69 |
995 |
|
|
996 |
|
Metadata |
1070 |
|
Charset id = 0 |
1071 |
|
Not Null |
1072 |
|
Size = 4 |
1073 |
+ |
Value = 0 |
1074 |
|
|
1075 |
|
SQLType =SQL_VARYING |
1076 |
|
sub type = 0 |
1099 |
|
ROWID = 1 |
1100 |
|
FIXEDPOINT = 20.28 |
1101 |
|
FLOATINGPOINT = 3.14 |
1102 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1102 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1103 |
|
BLOBDATA = NULL |
1104 |
|
|
1105 |
|
SQL Params |
1118 |
|
Charset id = 0 |
1119 |
|
Not Null |
1120 |
|
Size = 4 |
1121 |
+ |
Value = 0 |
1122 |
|
|
1123 |
|
ROWID = 1 |
1124 |
|
FIXEDPOINT = 20.28 |
1125 |
|
FLOATINGPOINT = 3.14 |
1126 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1126 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1127 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
1128 |
|
|
1129 |
|
To be or not to be-that is the question: |
1171 |
|
Charset id = 0 |
1172 |
|
Not Null |
1173 |
|
Size = 4 |
1174 |
+ |
Value = 0 |
1175 |
|
|
1176 |
|
SQLType =SQL_VARYING |
1177 |
|
sub type = 0 |
1200 |
|
ROWID = 1 |
1201 |
|
FIXEDPOINT = 20.28 |
1202 |
|
FLOATINGPOINT = 3.14 |
1203 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1203 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1204 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
1205 |
|
|
1206 |
|
To be or not to be-that is the question: |
1242 |
|
ROWID = 2 |
1243 |
|
FIXEDPOINT = NULL |
1244 |
|
FLOATINGPOINT = NULL |
1245 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1245 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1246 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
1247 |
|
|
1248 |
|
To be or not to be-that is the question: |
1367 |
|
Nullable |
1368 |
|
Size = 2 |
1369 |
|
|
1370 |
< |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1370 |
> |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252) |
1371 |
|
RDB$CHARACTER_SET_ID = 0 |
1372 |
< |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1372 |
> |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252) |
1373 |
|
RDB$CHARACTER_SET_ID = 1 |
1374 |
< |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1374 |
> |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252) |
1375 |
|
RDB$CHARACTER_SET_ID = 2 |
1376 |
< |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1376 |
> |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252) |
1377 |
|
RDB$CHARACTER_SET_ID = 3 |
1378 |
< |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1378 |
> |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252) |
1379 |
|
RDB$CHARACTER_SET_ID = 4 |
1380 |
< |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1380 |
> |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252) |
1381 |
|
RDB$CHARACTER_SET_ID = 5 |
1382 |
< |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1382 |
> |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252) |
1383 |
|
RDB$CHARACTER_SET_ID = 6 |
1384 |
< |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1384 |
> |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252) |
1385 |
|
RDB$CHARACTER_SET_ID = 9 |
1386 |
< |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1386 |
> |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252) |
1387 |
|
RDB$CHARACTER_SET_ID = 10 |
1388 |
< |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1388 |
> |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252) |
1389 |
|
RDB$CHARACTER_SET_ID = 11 |
1390 |
< |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1390 |
> |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252) |
1391 |
|
RDB$CHARACTER_SET_ID = 12 |
1392 |
< |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1392 |
> |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252) |
1393 |
|
RDB$CHARACTER_SET_ID = 13 |
1394 |
< |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1394 |
> |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252) |
1395 |
|
RDB$CHARACTER_SET_ID = 14 |
1396 |
< |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1396 |
> |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252) |
1397 |
|
RDB$CHARACTER_SET_ID = 15 |
1398 |
< |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1398 |
> |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252) |
1399 |
|
RDB$CHARACTER_SET_ID = 16 |
1400 |
< |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1400 |
> |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252) |
1401 |
|
RDB$CHARACTER_SET_ID = 17 |
1402 |
< |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1402 |
> |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252) |
1403 |
|
RDB$CHARACTER_SET_ID = 18 |
1404 |
< |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1404 |
> |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252) |
1405 |
|
RDB$CHARACTER_SET_ID = 19 |
1406 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1406 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252) |
1407 |
|
RDB$CHARACTER_SET_ID = 21 |
1408 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1408 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252) |
1409 |
|
RDB$CHARACTER_SET_ID = 22 |
1410 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1410 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252) |
1411 |
|
RDB$CHARACTER_SET_ID = 23 |
1412 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1412 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252) |
1413 |
|
RDB$CHARACTER_SET_ID = 34 |
1414 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1414 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252) |
1415 |
|
RDB$CHARACTER_SET_ID = 35 |
1416 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1416 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252) |
1417 |
|
RDB$CHARACTER_SET_ID = 36 |
1418 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1418 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252) |
1419 |
|
RDB$CHARACTER_SET_ID = 37 |
1420 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1420 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252) |
1421 |
|
RDB$CHARACTER_SET_ID = 38 |
1422 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1422 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252) |
1423 |
|
RDB$CHARACTER_SET_ID = 39 |
1424 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1424 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252) |
1425 |
|
RDB$CHARACTER_SET_ID = 40 |
1426 |
< |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1426 |
> |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252) |
1427 |
|
RDB$CHARACTER_SET_ID = 44 |
1428 |
< |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1428 |
> |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252) |
1429 |
|
RDB$CHARACTER_SET_ID = 45 |
1430 |
< |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1430 |
> |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252) |
1431 |
|
RDB$CHARACTER_SET_ID = 46 |
1432 |
< |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1432 |
> |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252) |
1433 |
|
RDB$CHARACTER_SET_ID = 47 |
1434 |
< |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1434 |
> |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252) |
1435 |
|
RDB$CHARACTER_SET_ID = 48 |
1436 |
< |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1436 |
> |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252) |
1437 |
|
RDB$CHARACTER_SET_ID = 49 |
1438 |
< |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1438 |
> |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252) |
1439 |
|
RDB$CHARACTER_SET_ID = 50 |
1440 |
< |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1440 |
> |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252) |
1441 |
|
RDB$CHARACTER_SET_ID = 51 |
1442 |
< |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1442 |
> |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252) |
1443 |
|
RDB$CHARACTER_SET_ID = 52 |
1444 |
< |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1444 |
> |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252) |
1445 |
|
RDB$CHARACTER_SET_ID = 53 |
1446 |
< |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1446 |
> |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252) |
1447 |
|
RDB$CHARACTER_SET_ID = 54 |
1448 |
< |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1448 |
> |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252) |
1449 |
|
RDB$CHARACTER_SET_ID = 55 |
1450 |
< |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1450 |
> |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252) |
1451 |
|
RDB$CHARACTER_SET_ID = 56 |
1452 |
< |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1452 |
> |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252) |
1453 |
|
RDB$CHARACTER_SET_ID = 57 |
1454 |
< |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1454 |
> |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252) |
1455 |
|
RDB$CHARACTER_SET_ID = 58 |
1456 |
< |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1456 |
> |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252) |
1457 |
|
RDB$CHARACTER_SET_ID = 59 |
1458 |
< |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1458 |
> |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252) |
1459 |
|
RDB$CHARACTER_SET_ID = 60 |
1460 |
< |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1460 |
> |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252) |
1461 |
|
RDB$CHARACTER_SET_ID = 63 |
1462 |
< |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1462 |
> |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252) |
1463 |
|
RDB$CHARACTER_SET_ID = 64 |
1464 |
< |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1464 |
> |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252) |
1465 |
|
RDB$CHARACTER_SET_ID = 65 |
1466 |
< |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1466 |
> |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252) |
1467 |
|
RDB$CHARACTER_SET_ID = 66 |
1468 |
< |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1468 |
> |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252) |
1469 |
|
RDB$CHARACTER_SET_ID = 67 |
1470 |
< |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1470 |
> |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252) |
1471 |
|
RDB$CHARACTER_SET_ID = 68 |
1472 |
< |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1472 |
> |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252) |
1473 |
|
RDB$CHARACTER_SET_ID = 69 |
1474 |
|
|
1475 |
|
Metadata |
1549 |
|
Charset id = 0 |
1550 |
|
Not Null |
1551 |
|
Size = 4 |
1552 |
+ |
Value = 0 |
1553 |
|
|
1554 |
|
SQLType =SQL_VARYING |
1555 |
|
sub type = 0 |
1578 |
|
ROWID = 1 |
1579 |
|
FIXEDPOINT = 20.28 |
1580 |
|
FLOATINGPOINT = 3.14 |
1581 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1581 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1582 |
|
BLOBDATA = NULL |
1583 |
|
|
1584 |
|
SQL Params |
1597 |
|
Charset id = 0 |
1598 |
|
Not Null |
1599 |
|
Size = 4 |
1600 |
+ |
Value = 0 |
1601 |
|
|
1602 |
|
ROWID = 1 |
1603 |
|
FIXEDPOINT = 20.28 |
1604 |
|
FLOATINGPOINT = 3.14 |
1605 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1605 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1606 |
|
BLOBDATA (Charset Id = 53 Codepage = 1252) |
1607 |
|
|
1608 |
|
To be or not to be-that is the question: |
1650 |
|
Charset id = 0 |
1651 |
|
Not Null |
1652 |
|
Size = 4 |
1653 |
+ |
Value = 0 |
1654 |
|
|
1655 |
|
SQLType =SQL_VARYING |
1656 |
|
sub type = 0 |
1679 |
|
ROWID = 1 |
1680 |
|
FIXEDPOINT = 20.28 |
1681 |
|
FLOATINGPOINT = 3.14 |
1682 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1682 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1683 |
|
BLOBDATA (Charset Id = 53 Codepage = 1252) |
1684 |
|
|
1685 |
|
To be or not to be-that is the question: |
1721 |
|
ROWID = 2 |
1722 |
|
FIXEDPOINT = NULL |
1723 |
|
FLOATINGPOINT = NULL |
1724 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1724 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1725 |
|
BLOBDATA (Charset Id = 53 Codepage = 1252) |
1726 |
|
|
1727 |
|
To be or not to be-that is the question: |
1846 |
|
Nullable |
1847 |
|
Size = 2 |
1848 |
|
|
1849 |
< |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1849 |
> |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001) |
1850 |
|
RDB$CHARACTER_SET_ID = 0 |
1851 |
< |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1851 |
> |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001) |
1852 |
|
RDB$CHARACTER_SET_ID = 1 |
1853 |
< |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1853 |
> |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001) |
1854 |
|
RDB$CHARACTER_SET_ID = 2 |
1855 |
< |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1855 |
> |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001) |
1856 |
|
RDB$CHARACTER_SET_ID = 3 |
1857 |
< |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1857 |
> |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001) |
1858 |
|
RDB$CHARACTER_SET_ID = 4 |
1859 |
< |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1859 |
> |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001) |
1860 |
|
RDB$CHARACTER_SET_ID = 5 |
1861 |
< |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1861 |
> |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001) |
1862 |
|
RDB$CHARACTER_SET_ID = 6 |
1863 |
< |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1863 |
> |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001) |
1864 |
|
RDB$CHARACTER_SET_ID = 9 |
1865 |
< |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1865 |
> |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001) |
1866 |
|
RDB$CHARACTER_SET_ID = 10 |
1867 |
< |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1867 |
> |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001) |
1868 |
|
RDB$CHARACTER_SET_ID = 11 |
1869 |
< |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1869 |
> |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001) |
1870 |
|
RDB$CHARACTER_SET_ID = 12 |
1871 |
< |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1871 |
> |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001) |
1872 |
|
RDB$CHARACTER_SET_ID = 13 |
1873 |
< |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1873 |
> |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001) |
1874 |
|
RDB$CHARACTER_SET_ID = 14 |
1875 |
< |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1875 |
> |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001) |
1876 |
|
RDB$CHARACTER_SET_ID = 15 |
1877 |
< |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1877 |
> |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001) |
1878 |
|
RDB$CHARACTER_SET_ID = 16 |
1879 |
< |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1879 |
> |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001) |
1880 |
|
RDB$CHARACTER_SET_ID = 17 |
1881 |
< |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1881 |
> |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001) |
1882 |
|
RDB$CHARACTER_SET_ID = 18 |
1883 |
< |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1883 |
> |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001) |
1884 |
|
RDB$CHARACTER_SET_ID = 19 |
1885 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1885 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001) |
1886 |
|
RDB$CHARACTER_SET_ID = 21 |
1887 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1887 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001) |
1888 |
|
RDB$CHARACTER_SET_ID = 22 |
1889 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1889 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001) |
1890 |
|
RDB$CHARACTER_SET_ID = 23 |
1891 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1891 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001) |
1892 |
|
RDB$CHARACTER_SET_ID = 34 |
1893 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1893 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001) |
1894 |
|
RDB$CHARACTER_SET_ID = 35 |
1895 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1895 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001) |
1896 |
|
RDB$CHARACTER_SET_ID = 36 |
1897 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1897 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001) |
1898 |
|
RDB$CHARACTER_SET_ID = 37 |
1899 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1899 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001) |
1900 |
|
RDB$CHARACTER_SET_ID = 38 |
1901 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1901 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001) |
1902 |
|
RDB$CHARACTER_SET_ID = 39 |
1903 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1903 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001) |
1904 |
|
RDB$CHARACTER_SET_ID = 40 |
1905 |
< |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1905 |
> |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001) |
1906 |
|
RDB$CHARACTER_SET_ID = 44 |
1907 |
< |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1907 |
> |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001) |
1908 |
|
RDB$CHARACTER_SET_ID = 45 |
1909 |
< |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1909 |
> |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001) |
1910 |
|
RDB$CHARACTER_SET_ID = 46 |
1911 |
< |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1911 |
> |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001) |
1912 |
|
RDB$CHARACTER_SET_ID = 47 |
1913 |
< |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1913 |
> |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001) |
1914 |
|
RDB$CHARACTER_SET_ID = 48 |
1915 |
< |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1915 |
> |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001) |
1916 |
|
RDB$CHARACTER_SET_ID = 49 |
1917 |
< |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1917 |
> |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001) |
1918 |
|
RDB$CHARACTER_SET_ID = 50 |
1919 |
< |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1919 |
> |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001) |
1920 |
|
RDB$CHARACTER_SET_ID = 51 |
1921 |
< |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1921 |
> |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001) |
1922 |
|
RDB$CHARACTER_SET_ID = 52 |
1923 |
< |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1923 |
> |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001) |
1924 |
|
RDB$CHARACTER_SET_ID = 53 |
1925 |
< |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1925 |
> |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001) |
1926 |
|
RDB$CHARACTER_SET_ID = 54 |
1927 |
< |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1927 |
> |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001) |
1928 |
|
RDB$CHARACTER_SET_ID = 55 |
1929 |
< |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1929 |
> |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001) |
1930 |
|
RDB$CHARACTER_SET_ID = 56 |
1931 |
< |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1931 |
> |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001) |
1932 |
|
RDB$CHARACTER_SET_ID = 57 |
1933 |
< |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1933 |
> |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001) |
1934 |
|
RDB$CHARACTER_SET_ID = 58 |
1935 |
< |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1935 |
> |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001) |
1936 |
|
RDB$CHARACTER_SET_ID = 59 |
1937 |
< |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1937 |
> |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001) |
1938 |
|
RDB$CHARACTER_SET_ID = 60 |
1939 |
< |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1939 |
> |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001) |
1940 |
|
RDB$CHARACTER_SET_ID = 63 |
1941 |
< |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1941 |
> |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001) |
1942 |
|
RDB$CHARACTER_SET_ID = 64 |
1943 |
< |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1943 |
> |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001) |
1944 |
|
RDB$CHARACTER_SET_ID = 65 |
1945 |
< |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1945 |
> |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001) |
1946 |
|
RDB$CHARACTER_SET_ID = 66 |
1947 |
< |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1947 |
> |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001) |
1948 |
|
RDB$CHARACTER_SET_ID = 67 |
1949 |
< |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1949 |
> |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001) |
1950 |
|
RDB$CHARACTER_SET_ID = 68 |
1951 |
< |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1951 |
> |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001) |
1952 |
|
RDB$CHARACTER_SET_ID = 69 |
1953 |
|
|
1954 |
|
Metadata |
2028 |
|
Charset id = 0 |
2029 |
|
Not Null |
2030 |
|
Size = 4 |
2031 |
+ |
Value = 0 |
2032 |
|
|
2033 |
|
SQLType =SQL_VARYING |
2034 |
|
sub type = 0 |
2057 |
|
ROWID = 1 |
2058 |
|
FIXEDPOINT = 20.28 |
2059 |
|
FLOATINGPOINT = 3.14 |
2060 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2060 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2061 |
|
BLOBDATA = NULL |
2062 |
|
|
2063 |
|
SQL Params |
2076 |
|
Charset id = 0 |
2077 |
|
Not Null |
2078 |
|
Size = 4 |
2079 |
+ |
Value = 0 |
2080 |
|
|
2081 |
|
ROWID = 1 |
2082 |
|
FIXEDPOINT = 20.28 |
2083 |
|
FLOATINGPOINT = 3.14 |
2084 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2084 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2085 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
2086 |
|
|
2087 |
|
To be or not to be-that is the question: |
2129 |
|
Charset id = 0 |
2130 |
|
Not Null |
2131 |
|
Size = 4 |
2132 |
+ |
Value = 0 |
2133 |
|
|
2134 |
|
SQLType =SQL_VARYING |
2135 |
|
sub type = 0 |
2158 |
|
ROWID = 1 |
2159 |
|
FIXEDPOINT = 20.28 |
2160 |
|
FLOATINGPOINT = 3.14 |
2161 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2161 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2162 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
2163 |
|
|
2164 |
|
To be or not to be-that is the question: |
2200 |
|
ROWID = 2 |
2201 |
|
FIXEDPOINT = NULL |
2202 |
|
FLOATINGPOINT = NULL |
2203 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2203 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2204 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
2205 |
|
|
2206 |
|
To be or not to be-that is the question: |
2302 |
|
|
2303 |
|
|
2304 |
|
|
2305 |
+ |
------------------------------------------------------ |
2306 |
|
Running Test 7: Create and read back an Array |
2307 |
|
Metadata |
2308 |
|
SQLType =SQL_LONG |
2374 |
|
Dimensions = 1 |
2375 |
|
Bounds: (0:16) |
2376 |
|
|
2377 |
+ |
SQLType =SQL_ARRAY |
2378 |
+ |
sub type = 0 |
2379 |
+ |
Table = TESTDATA |
2380 |
+ |
Owner = SYSDBA |
2381 |
+ |
Column Name = MYARRAY2 |
2382 |
+ |
Alias Name = MYARRAY2 |
2383 |
+ |
Field Name = MYARRAY2 |
2384 |
+ |
Scale = 0 |
2385 |
+ |
Charset id = 0 |
2386 |
+ |
Nullable |
2387 |
+ |
Size = 8 |
2388 |
+ |
Array Meta Data: |
2389 |
+ |
SQLType =SQL_TIMESTAMP |
2390 |
+ |
Scale = 0 |
2391 |
+ |
Charset id = 0 |
2392 |
+ |
Size = 8 |
2393 |
+ |
Table = TESTDATA |
2394 |
+ |
Column = MYARRAY2 |
2395 |
+ |
Dimensions = 1 |
2396 |
+ |
Bounds: (0:16) |
2397 |
+ |
|
2398 |
+ |
SQLType =SQL_ARRAY |
2399 |
+ |
sub type = 0 |
2400 |
+ |
Table = TESTDATA |
2401 |
+ |
Owner = SYSDBA |
2402 |
+ |
Column Name = MYARRAY3 |
2403 |
+ |
Alias Name = MYARRAY3 |
2404 |
+ |
Field Name = MYARRAY3 |
2405 |
+ |
Scale = 0 |
2406 |
+ |
Charset id = 0 |
2407 |
+ |
Nullable |
2408 |
+ |
Size = 8 |
2409 |
+ |
Array Meta Data: |
2410 |
+ |
SQLType =SQL_INT64 |
2411 |
+ |
Scale = -2 |
2412 |
+ |
Charset id = 0 |
2413 |
+ |
Size = 8 |
2414 |
+ |
Table = TESTDATA |
2415 |
+ |
Column = MYARRAY3 |
2416 |
+ |
Dimensions = 1 |
2417 |
+ |
Bounds: (0:16) |
2418 |
+ |
|
2419 |
|
SQL Params |
2420 |
|
SQLType =SQL_LONG |
2421 |
|
sub type = 0 |
2424 |
|
Charset id = 0 |
2425 |
|
Not Null |
2426 |
|
Size = 4 |
2427 |
+ |
Value = 0 |
2428 |
|
|
2429 |
|
SQLType =SQL_VARYING |
2430 |
|
sub type = 0 |
2455 |
|
Param Name = DATED |
2456 |
|
Param Name = NOTES |
2457 |
|
ROWID = 1 |
2458 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2459 |
< |
DATED = 1/4/2016 09:30:00.100 |
2460 |
< |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
2458 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2459 |
> |
DATED = 2016/04/01 09:30:00.1000 |
2460 |
> |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) |
2461 |
|
MYARRAY = NULL |
2462 |
+ |
MYARRAY2 = NULL |
2463 |
+ |
MYARRAY3 = NULL |
2464 |
|
|
2465 |
|
SQL Params |
2466 |
|
SQLType =SQL_ARRAY |
2471 |
|
Nullable |
2472 |
|
Size = 8 |
2473 |
|
|
2474 |
+ |
SQL Params |
2475 |
+ |
SQLType =SQL_ARRAY |
2476 |
+ |
sub type = 0 |
2477 |
+ |
Field Name = MYARRAY2 |
2478 |
+ |
Scale = 0 |
2479 |
+ |
Charset id = 0 |
2480 |
+ |
Nullable |
2481 |
+ |
Size = 8 |
2482 |
+ |
|
2483 |
+ |
SQL Params |
2484 |
+ |
SQLType =SQL_ARRAY |
2485 |
+ |
sub type = 0 |
2486 |
+ |
Field Name = MYARRAY3 |
2487 |
+ |
Scale = 0 |
2488 |
+ |
Charset id = 0 |
2489 |
+ |
Nullable |
2490 |
+ |
Size = 8 |
2491 |
+ |
|
2492 |
+ |
Metadata |
2493 |
+ |
SQLType =SQL_LONG |
2494 |
+ |
sub type = 0 |
2495 |
+ |
Table = TESTDATA |
2496 |
+ |
Owner = SYSDBA |
2497 |
+ |
Column Name = ROWID |
2498 |
+ |
Alias Name = ROWID |
2499 |
+ |
Field Name = ROWID |
2500 |
+ |
Scale = 0 |
2501 |
+ |
Charset id = 0 |
2502 |
+ |
Not Null |
2503 |
+ |
Size = 4 |
2504 |
+ |
|
2505 |
+ |
SQLType =SQL_VARYING |
2506 |
+ |
sub type = 0 |
2507 |
+ |
Table = TESTDATA |
2508 |
+ |
Owner = SYSDBA |
2509 |
+ |
Column Name = TITLE |
2510 |
+ |
Alias Name = TITLE |
2511 |
+ |
Field Name = TITLE |
2512 |
+ |
Scale = 0 |
2513 |
+ |
Charset id = 4 |
2514 |
+ |
Nullable |
2515 |
+ |
Size = 128 |
2516 |
+ |
|
2517 |
+ |
SQLType =SQL_TIMESTAMP |
2518 |
+ |
sub type = 0 |
2519 |
+ |
Table = TESTDATA |
2520 |
+ |
Owner = SYSDBA |
2521 |
+ |
Column Name = DATED |
2522 |
+ |
Alias Name = DATED |
2523 |
+ |
Field Name = DATED |
2524 |
+ |
Scale = 0 |
2525 |
+ |
Charset id = 0 |
2526 |
+ |
Nullable |
2527 |
+ |
Size = 8 |
2528 |
+ |
|
2529 |
+ |
SQLType =SQL_VARYING |
2530 |
+ |
sub type = 0 |
2531 |
+ |
Table = TESTDATA |
2532 |
+ |
Owner = SYSDBA |
2533 |
+ |
Column Name = NOTES |
2534 |
+ |
Alias Name = NOTES |
2535 |
+ |
Field Name = NOTES |
2536 |
+ |
Scale = 0 |
2537 |
+ |
Charset id = 4 |
2538 |
+ |
Nullable |
2539 |
+ |
Size = 256 |
2540 |
+ |
|
2541 |
+ |
SQLType =SQL_ARRAY |
2542 |
+ |
sub type = 0 |
2543 |
+ |
Table = TESTDATA |
2544 |
+ |
Owner = SYSDBA |
2545 |
+ |
Column Name = MYARRAY |
2546 |
+ |
Alias Name = MYARRAY |
2547 |
+ |
Field Name = MYARRAY |
2548 |
+ |
Scale = 0 |
2549 |
+ |
Charset id = 0 |
2550 |
+ |
Nullable |
2551 |
+ |
Size = 8 |
2552 |
+ |
Array Meta Data: |
2553 |
+ |
SQLType =SQL_LONG |
2554 |
+ |
Scale = 0 |
2555 |
+ |
Charset id = 0 |
2556 |
+ |
Size = 4 |
2557 |
+ |
Table = TESTDATA |
2558 |
+ |
Column = MYARRAY |
2559 |
+ |
Dimensions = 1 |
2560 |
+ |
Bounds: (0:16) |
2561 |
+ |
|
2562 |
+ |
SQLType =SQL_ARRAY |
2563 |
+ |
sub type = 0 |
2564 |
+ |
Table = TESTDATA |
2565 |
+ |
Owner = SYSDBA |
2566 |
+ |
Column Name = MYARRAY2 |
2567 |
+ |
Alias Name = MYARRAY2 |
2568 |
+ |
Field Name = MYARRAY2 |
2569 |
+ |
Scale = 0 |
2570 |
+ |
Charset id = 0 |
2571 |
+ |
Nullable |
2572 |
+ |
Size = 8 |
2573 |
+ |
Array Meta Data: |
2574 |
+ |
SQLType =SQL_TIMESTAMP |
2575 |
+ |
Scale = 0 |
2576 |
+ |
Charset id = 0 |
2577 |
+ |
Size = 8 |
2578 |
+ |
Table = TESTDATA |
2579 |
+ |
Column = MYARRAY2 |
2580 |
+ |
Dimensions = 1 |
2581 |
+ |
Bounds: (0:16) |
2582 |
+ |
|
2583 |
+ |
SQLType =SQL_ARRAY |
2584 |
+ |
sub type = 0 |
2585 |
+ |
Table = TESTDATA |
2586 |
+ |
Owner = SYSDBA |
2587 |
+ |
Column Name = MYARRAY3 |
2588 |
+ |
Alias Name = MYARRAY3 |
2589 |
+ |
Field Name = MYARRAY3 |
2590 |
+ |
Scale = 0 |
2591 |
+ |
Charset id = 0 |
2592 |
+ |
Nullable |
2593 |
+ |
Size = 8 |
2594 |
+ |
Array Meta Data: |
2595 |
+ |
SQLType =SQL_INT64 |
2596 |
+ |
Scale = -2 |
2597 |
+ |
Charset id = 0 |
2598 |
+ |
Size = 8 |
2599 |
+ |
Table = TESTDATA |
2600 |
+ |
Column = MYARRAY3 |
2601 |
+ |
Dimensions = 1 |
2602 |
+ |
Bounds: (0:16) |
2603 |
+ |
|
2604 |
|
ROWID = 1 |
2605 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2606 |
< |
DATED = 1/4/2016 09:30:00.100 |
2607 |
< |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
2608 |
< |
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) |
2605 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2606 |
> |
DATED = 2016/04/01 09:30:00.1000 |
2607 |
> |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) |
2608 |
> |
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) |
2609 |
> |
|
2610 |
> |
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) |
2611 |
> |
|
2612 |
> |
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) |
2613 |
> |
|
2614 |
|
|
2615 |
|
Shrink to 2:10 |
2616 |
|
Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) |
2617 |
+ |
|
2618 |
|
Write updated reduced slice |
2619 |
|
Show update array |
2620 |
|
ROWID = 1 |
2621 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2622 |
< |
DATED = 1/4/2016 09:30:00.100 |
2623 |
< |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
2624 |
< |
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) |
2621 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2622 |
> |
DATED = 2016/04/01 09:30:00.1000 |
2623 |
> |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) |
2624 |
> |
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) |
2625 |
> |
|
2626 |
> |
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) |
2627 |
> |
|
2628 |
> |
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) |
2629 |
> |
|
2630 |
|
|
2631 |
|
|
2632 |
|
|
2633 |
+ |
------------------------------------------------------ |
2634 |
|
Running Test 8: Create and read back an Array with 2 dimensions |
2635 |
|
Metadata |
2636 |
|
SQLType =SQL_LONG |
2686 |
|
Charset id = 0 |
2687 |
|
Not Null |
2688 |
|
Size = 4 |
2689 |
+ |
Value = 0 |
2690 |
|
|
2691 |
|
SQLType =SQL_VARYING |
2692 |
|
sub type = 0 |
2697 |
|
Size = 128 |
2698 |
|
|
2699 |
|
ROWID = 1 |
2700 |
< |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8) |
2700 |
> |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001) |
2701 |
|
MYARRAY = NULL |
2702 |
|
|
2703 |
|
ROWID = 1 |
2704 |
< |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8) |
2705 |
< |
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) |
2704 |
> |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001) |
2705 |
> |
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) |
2706 |
|
|
2707 |
|
|
2708 |
|
|
2709 |
+ |
|
2710 |
+ |
------------------------------------------------------ |
2711 |
|
Running Test 9: Database Information tests |
2712 |
|
Database ID = 4 FB = /opt/firebird3.0.5/examples/empbuild/employee.fdb SN = zeus |
2713 |
|
Pages =307 |
2719 |
|
Page Size = 8192 |
2720 |
|
Version = 1: LI-V6.3.5.33220 Firebird 3.0 |
2721 |
|
Database is Read/Write |
2722 |
< |
Database Created: 9/1/2020 13:13:45 |
2722 |
> |
Database Created: 09/1/2020 13:13:45 |
2723 |
|
Pages Used = 297 |
2724 |
|
Pages Free = 10 |
2725 |
< |
Server Memory = 19195648 |
2725 |
> |
Server Memory = 19195664 |
2726 |
|
Forced Writes = 1 |
2727 |
< |
Max Memory = 19316160 |
2727 |
> |
Max Memory = 19316176 |
2728 |
|
Num Buffers = 2048 |
2729 |
|
Sweep Interval = 20000 |
2730 |
|
Logged in Users: SYSDBA, |
2770 |
|
Page Size = 8192 |
2771 |
|
|
2772 |
|
|
2773 |
+ |
------------------------------------------------------ |
2774 |
|
Running Test 10: Event Handling |
2775 |
|
Call Async Wait |
2776 |
|
Async Wait Called |
2797 |
|
Event Counts: TESTEVENT, Count = 1 |
2798 |
|
|
2799 |
|
|
2800 |
+ |
------------------------------------------------------ |
2801 |
|
Running Test 11: Services API |
2802 |
+ |
SPB: Item Count = 2 |
2803 |
+ |
user_name = SYSDBA |
2804 |
+ |
password = masterkey |
2805 |
+ |
|
2806 |
|
Service Manager Version = 2 |
2807 |
|
Server Version = LI-V3.0.5.33220 Firebird 3.0 |
2808 |
|
Implementation = Firebird/Linux/AMD/Intel/x64 |
2824 |
|
Group ID = 0 |
2825 |
|
|
2826 |
|
|
2827 |
< |
Licence Info: |
2376 |
< |
feature is not supported |
2827 |
> |
Licence Info: feature is not supported |
2828 |
|
-feature is not supported |
2829 |
|
|
2830 |
< |
Licence Mask Info: |
2380 |
< |
feature is not supported |
2830 |
> |
Licence Mask Info: feature is not supported |
2831 |
|
|
2832 |
|
Capabilities = 6 |
2833 |
|
|
2857 |
|
Database Dropped |
2858 |
|
|
2859 |
|
|
2860 |
+ |
------------------------------------------------------ |
2861 |
|
Running Test 12: Character Sets |
2862 |
|
SQL Params |
2863 |
|
SQLType =SQL_LONG |
2867 |
|
Charset id = 0 |
2868 |
|
Not Null |
2869 |
|
Size = 4 |
2870 |
+ |
Value = 0 |
2871 |
|
|
2872 |
|
SQLType =SQL_VARYING |
2873 |
|
sub type = 0 |
2917 |
|
Nullable |
2918 |
|
Size = 16 |
2919 |
|
|
2920 |
+ |
Show Param Values |
2921 |
+ |
SQL Params |
2922 |
+ |
SQLType =SQL_LONG |
2923 |
+ |
sub type = 0 |
2924 |
+ |
Field Name = ROWID |
2925 |
+ |
Scale = 0 |
2926 |
+ |
Charset id = 0 |
2927 |
+ |
Not Null |
2928 |
+ |
Size = 4 |
2929 |
+ |
Value = 1 |
2930 |
+ |
|
2931 |
+ |
SQLType =SQL_VARYING |
2932 |
+ |
sub type = 0 |
2933 |
+ |
Field Name = TITLE |
2934 |
+ |
Scale = 0 |
2935 |
+ |
Charset id = 4 |
2936 |
+ |
Nullable |
2937 |
+ |
Size = 128 |
2938 |
+ |
Value = Blob Test ©€ |
2939 |
+ |
|
2940 |
+ |
SQLType =SQL_VARYING |
2941 |
+ |
sub type = 0 |
2942 |
+ |
Field Name = NOTES |
2943 |
+ |
Scale = 0 |
2944 |
+ |
Charset id = 4 |
2945 |
+ |
Nullable |
2946 |
+ |
Size = 256 |
2947 |
+ |
Value = Écoute moi |
2948 |
+ |
|
2949 |
+ |
SQLType =SQL_VARYING |
2950 |
+ |
sub type = 1 |
2951 |
+ |
Field Name = BLOBDATA |
2952 |
+ |
Scale = 0 |
2953 |
+ |
Charset id = 4 |
2954 |
+ |
Nullable |
2955 |
+ |
Size = 8192 |
2956 |
+ |
Value = Some German Special Characters like Ă–Ă„ĂœĂ¶Ă¤Ă¼ĂŸ |
2957 |
+ |
|
2958 |
+ |
SQLType =SQL_BLOB |
2959 |
+ |
sub type = 1 |
2960 |
+ |
Field Name = BLOBDATA2 |
2961 |
+ |
Scale = 0 |
2962 |
+ |
Charset id = 4 |
2963 |
+ |
Nullable |
2964 |
+ |
Size = 8 |
2965 |
+ |
Value = Some German Special Characters like Ă–Ă„ĂœĂ¶Ă¤Ă¼ĂŸ |
2966 |
+ |
|
2967 |
+ |
SQLType =SQL_VARYING |
2968 |
+ |
sub type = 0 |
2969 |
+ |
Field Name = INCLEAR |
2970 |
+ |
Scale = 0 |
2971 |
+ |
Charset id = 1 |
2972 |
+ |
Nullable |
2973 |
+ |
Size = 16 |
2974 |
+ |
Value = &Test |
2975 |
|
|
2976 |
+ |
|
2977 |
+ |
SQLType =SQL_VARYING |
2978 |
+ |
sub type = 0 |
2979 |
+ |
Field Name = FIXEDWIDTH |
2980 |
+ |
Scale = 0 |
2981 |
+ |
Charset id = 4 |
2982 |
+ |
Nullable |
2983 |
+ |
Size = 16 |
2984 |
+ |
Value = É |
2985 |
+ |
|
2986 |
|
Connection Character Set UTF8 |
2987 |
|
ROWID = 1 |
2988 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2989 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
2988 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
2989 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
2990 |
|
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) |
2991 |
|
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) |
2992 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
2993 |
< |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001 Byte Length = 5) |
2992 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
2993 |
> |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001) |
2994 |
|
|
2995 |
|
Connection Character Set NONE |
2996 |
|
ROWID = 1 |
2997 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2998 |
< |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591 Byte Length = 10) |
2997 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
2998 |
> |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591) |
2999 |
|
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) |
3000 |
|
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) |
3001 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3002 |
< |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001 Byte Length = 5) |
3001 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3002 |
> |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001) |
3003 |
|
|
3004 |
|
Connection Character Set WIN1252 |
3005 |
|
ROWID = 1 |
3006 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252 Byte Length = 12) |
3007 |
< |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252 Byte Length = 10) |
3006 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252) |
3007 |
> |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252) |
3008 |
|
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) |
3009 |
|
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) |
3010 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3011 |
< |
FIXEDWIDTH = C9 (Charset Id = 53 Codepage = 1252 Byte Length = 4) |
3010 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3011 |
> |
FIXEDWIDTH = C9 (Charset Id = 53 Codepage = 1252) |
3012 |
|
|
3013 |
|
|
3014 |
|
|
3015 |
+ |
------------------------------------------------------ |
3016 |
|
Running Test 13: Transaction over two databases |
3017 |
|
Init Database 1 |
3018 |
|
ROWID = 1 |
3019 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
3020 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3019 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
3020 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3021 |
|
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) |
3022 |
|
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) |
3023 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3023 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3024 |
|
|
3025 |
|
Init Database 2 |
3026 |
|
ROWID = 1 |
3027 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
3028 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3027 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
3028 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3029 |
|
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) |
3030 |
|
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) |
3031 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3031 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3032 |
|
|
3033 |
|
ROWID = 1 |
3034 |
< |
TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3035 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3034 |
> |
TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001) |
3035 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3036 |
|
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) |
3037 |
|
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) |
3038 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3038 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3039 |
|
|
3040 |
|
ROWID = 1 |
3041 |
< |
TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3042 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3041 |
> |
TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001) |
3042 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3043 |
|
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) |
3044 |
|
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) |
3045 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3045 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3046 |
|
|
3047 |
|
|
3048 |
|
|
3049 |
+ |
------------------------------------------------------ |
3050 |
|
Running Test 14: Non select procedures |
3051 |
|
Default Character set Name = UTF8 |
3052 |
|
Metadata |
3074 |
|
Size = 128 |
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 |
|
Repeat with a different execute transaction |
3080 |
|
|
3081 |
|
ROWID = 1 |
3082 |
< |
TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7) |
3082 |
> |
TITLE = Testing (Charset Id = 4 Codepage = 65001) |
3083 |
|
|
3084 |
|
Repeat with a original transaction |
3085 |
|
|
3086 |
|
ROWID = 1 |
3087 |
< |
TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7) |
3087 |
> |
TITLE = Testing (Charset Id = 4 Codepage = 65001) |
3088 |
|
|
3089 |
|
|
3090 |
+ |
------------------------------------------------------ |
3091 |
|
Running Test 15: Blob Handling and BPBs |
3092 |
|
|
3093 |
|
Testdata |
3094 |
|
|
3095 |
|
ROWID = 1 |
3096 |
< |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3096 |
> |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001) |
3097 |
|
BLOBDATA = (blob), Length = 92514 |
3098 |
|
|
3099 |
+ |
ROWID = 2 |
3100 |
+ |
TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001) |
3101 |
+ |
BLOBDATA = (blob), Length = 13 |
3102 |
+ |
0 9 A C9 63 6F 75 74 65 20 6D 6F 69 |
3103 |
|
|
3104 |
|
Testdata 2 |
3105 |
|
|
3106 |
|
ROWID = 1 |
3107 |
< |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3107 |
> |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001) |
3108 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
3109 |
|
|
3110 |
|
Écoute moi |
3111 |
|
|
3112 |
|
|
3113 |
|
|
3114 |
+ |
------------------------------------------------------ |
3115 |
|
Running Test 16: Error handling |
3116 |
|
Invalid Database Name Test |
3117 |
< |
Error Handled: |
2593 |
< |
I/O error during "open" operation for file "Malformed Name" |
3117 |
> |
Error Handled: I/O error during "open" operation for file "Malformed Name" |
3118 |
|
-Error while trying to open file |
3119 |
|
-No such file or directory |
3120 |
|
Invalid User Name Test |
3121 |
< |
Error Handled: |
2598 |
< |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3121 |
> |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3122 |
|
Invalid password Test |
3123 |
< |
Error Handled: |
2601 |
< |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3123 |
> |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3124 |
|
Invalid Prepare SQL Test |
3125 |
< |
Error Handled: |
2604 |
< |
Dynamic SQL Error |
3125 |
> |
Error Handled: Dynamic SQL Error |
3126 |
|
-SQL error code = -206 |
3127 |
|
-Column unknown |
3128 |
|
-UNKNOWN_DATE |
3129 |
|
-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
3130 |
|
Invalid Open Cursor SQL Test |
3131 |
< |
Error Handled: |
2611 |
< |
Dynamic SQL Error |
3131 |
> |
Error Handled: Dynamic SQL Error |
3132 |
|
-SQL error code = -206 |
3133 |
|
-Column unknown |
3134 |
|
-X |
3139 |
|
Error Handled: Field "EMP_NO" not found |
3140 |
|
Case sensitive Param SQL Test |
3141 |
|
Error Handled: Field "EMP_NO" not found |
3142 |
+ |
Stale Reference Check |
3143 |
+ |
First test correct usage |
3144 |
+ |
COUNTER = 42 |
3145 |
+ |
|
3146 |
+ |
New Transaction before param set |
3147 |
+ |
Error Handled: This interface is no longer up-to-date |
3148 |
+ |
New Transaction before Open Cursor |
3149 |
+ |
Error Handled: This interface is no longer up-to-date |
3150 |
+ |
Stop Stale Reference Checks |
3151 |
+ |
New Transaction before param set |
3152 |
+ |
COUNTER = 42 |
3153 |
+ |
|
3154 |
+ |
New Transaction before Open Cursor |
3155 |
+ |
COUNTER = 42 |
3156 |
+ |
|
3157 |
|
Invalid Server Name Test |
3158 |
< |
Error Handled: |
2624 |
< |
Unable to complete network request to host "unknown". |
3158 |
> |
Error Handled: Unable to complete network request to host "unknown". |
3159 |
|
-Failed to locate host machine. |
3160 |
|
-The specified name was not found in the hosts file or Domain Name Services |
3161 |
|
Invalid User Name Test |
3162 |
< |
Error Handled: |
2629 |
< |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3162 |
> |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3163 |
|
Invalid password Test |
3164 |
< |
Error Handled: |
3165 |
< |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3164 |
> |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3165 |
> |
|
3166 |
> |
|
3167 |
> |
------------------------------------------------------ |
3168 |
> |
Running Test 17: Date/Time tests and Firebird 4 extensions |
3169 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0" |
3170 |
> |
Has Local TZ DB = FALSE |
3171 |
> |
|
3172 |
> |
Testdata |
3173 |
> |
|
3174 |
> |
Metadata |
3175 |
> |
SQLType =SQL_LONG |
3176 |
> |
sub type = 0 |
3177 |
> |
Table = TESTDATA |
3178 |
> |
Owner = SYSDBA |
3179 |
> |
Column Name = ROWID |
3180 |
> |
Alias Name = ROWID |
3181 |
> |
Field Name = ROWID |
3182 |
> |
Scale = 0 |
3183 |
> |
Charset id = 0 |
3184 |
> |
Not Null |
3185 |
> |
Size = 4 |
3186 |
> |
|
3187 |
> |
SQLType =SQL_TYPE_DATE |
3188 |
> |
sub type = 0 |
3189 |
> |
Table = TESTDATA |
3190 |
> |
Owner = SYSDBA |
3191 |
> |
Column Name = DATECOL |
3192 |
> |
Alias Name = DATECOL |
3193 |
> |
Field Name = DATECOL |
3194 |
> |
Scale = 0 |
3195 |
> |
Charset id = 0 |
3196 |
> |
Nullable |
3197 |
> |
Size = 4 |
3198 |
> |
|
3199 |
> |
SQLType =SQL_TYPE_TIME |
3200 |
> |
sub type = 0 |
3201 |
> |
Table = TESTDATA |
3202 |
> |
Owner = SYSDBA |
3203 |
> |
Column Name = TIMECOL |
3204 |
> |
Alias Name = TIMECOL |
3205 |
> |
Field Name = TIMECOL |
3206 |
> |
Scale = 0 |
3207 |
> |
Charset id = 0 |
3208 |
> |
Nullable |
3209 |
> |
Size = 4 |
3210 |
> |
|
3211 |
> |
SQLType =SQL_TIMESTAMP |
3212 |
> |
sub type = 0 |
3213 |
> |
Table = TESTDATA |
3214 |
> |
Owner = SYSDBA |
3215 |
> |
Column Name = TIMESTAMPCOL |
3216 |
> |
Alias Name = TIMESTAMPCOL |
3217 |
> |
Field Name = TIMESTAMPCOL |
3218 |
> |
Scale = 0 |
3219 |
> |
Charset id = 0 |
3220 |
> |
Nullable |
3221 |
> |
Size = 8 |
3222 |
> |
|
3223 |
> |
ROWID = 1 |
3224 |
> |
DATECOL = 2019/04/01 |
3225 |
> |
TIMECOL = 11:31:05.0001 |
3226 |
> |
TIMESTAMPCOL = 2016/02/29 22:02:35.0001 |
3227 |
> |
ROWID = 2 |
3228 |
> |
DATECOL = 1939/09/03 |
3229 |
> |
TIMECOL = 15:40:00.0002 |
3230 |
> |
TIMESTAMPCOL = 1918/11/11 11:11:00.0000 |
3231 |
> |
ROWID = 3 |
3232 |
> |
DATECOL = 1066/10/14 |
3233 |
> |
TIMECOL = 23:59:59.9994 |
3234 |
> |
TIMESTAMPCOL = 1918/11/11 11:11:00.0000 |
3235 |
> |
ROWID = 4 |
3236 |
> |
DATECOL = 1815/06/18 |
3237 |
> |
TIMECOL = 00:01:40.1115 |
3238 |
> |
TIMESTAMPCOL = 1945/05/08 22:10:00.0010 |
3239 |
> |
|
3240 |
> |
|
3241 |
> |
Testdata - second pass |
3242 |
> |
|
3243 |
> |
1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35 |
3244 |
> |
2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00 |
3245 |
> |
3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00 |
3246 |
> |
4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00 |
3247 |
> |
Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1 |
3248 |
> |
Skipping Firebird 4 and later test part |
3249 |
> |
|
3250 |
> |
|
3251 |
> |
------------------------------------------------------ |
3252 |
> |
Running Test 18: Firebird 4 Decfloat extensions |
3253 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0" |
3254 |
> |
Skipping test for Firebird 4 and later |
3255 |
> |
|
3256 |
> |
|
3257 |
> |
------------------------------------------------------ |
3258 |
> |
Running Test 19: Batch Update and Insert Queries |
3259 |
> |
Opening inet://localhost/employee |
3260 |
> |
Skipping test for Firebird 4 and later |
3261 |
> |
|
3262 |
> |
|
3263 |
> |
------------------------------------------------------ |
3264 |
> |
Running Test 20: Stress Test IBatch interface |
3265 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0" |
3266 |
> |
Skipping test for Firebird 4 and later |
3267 |
|
|
3268 |
|
|
3269 |
+ |
------------------------------------------------------ |
3270 |
|
Test Suite Ends |