ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/branches/udr/testsuite/FB3reference.log
(Generate patch)

Comparing:
ibx/trunk/fbintf/testsuite/FB3reference.log (file contents), Revision 333 by tony, Fri Feb 26 16:34:26 2021 UTC vs.
ibx/branches/journaling/fbintf/testsuite/FB3reference.log (file contents), Revision 363 by tony, Tue Dec 7 13:30:05 2021 UTC

# Line 1 | Line 1
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 > Attachment ID = 6
61 > DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
62   DB Charset ID = 4
63   DB SQL Dialect = 3
64 < DB Remote Protocol =
64 > DB Remote Protocol = TCPv4
65   DB ODS Major Version = 12
66   DB ODS Minor Version = 0
67 < User Authentication Method = User name in DPB
67 > User Authentication Method = Srp
68   Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
69   DB Client Implementation Version = 3.0
70   RDB$DESCRIPTION =
# Line 67 | Line 75 | RDB$LINGER =
75   Dropping Database
76  
77  
78 + ------------------------------------------------------
79   Running Test 2: Open the employee database and run a query
80 + Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
81   Opening inet://localhost/employee
82   Database Open, SQL Dialect = 3
83 + TPB: Item Count = 3
84 +  isc_tpb_read
85 +  isc_tpb_nowait
86 +  isc_tpb_concurrency
87 +
88 + Metadata
89 + SQLType =SQL_SHORT
90 + sub type = 0
91 + Table = EMPLOYEE
92 + Owner = SYSDBA
93 + Column Name = EMP_NO
94 + Alias Name = EMP_NO
95 + Field Name = EMP_NO
96 + Scale = 0
97 + Charset id = 0
98 + Not Null
99 + Size = 2
100 +
101 + SQLType =SQL_VARYING
102 + sub type = 0
103 + Table = EMPLOYEE
104 + Owner = SYSDBA
105 + Column Name = FIRST_NAME
106 + Alias Name = FIRST_NAME
107 + Field Name = FIRST_NAME
108 + Scale = 0
109 + Charset id = 0
110 + Not Null
111 + Size = 15
112 +
113 + SQLType =SQL_VARYING
114 + sub type = 0
115 + Table = EMPLOYEE
116 + Owner = SYSDBA
117 + Column Name = LAST_NAME
118 + Alias Name = LAST_NAME
119 + Field Name = LAST_NAME
120 + Scale = 0
121 + Charset id = 0
122 + Not Null
123 + Size = 20
124 +
125 + SQLType =SQL_VARYING
126 + sub type = 0
127 + Table = EMPLOYEE
128 + Owner = SYSDBA
129 + Column Name = PHONE_EXT
130 + Alias Name = PHONE_EXT
131 + Field Name = PHONE_EXT
132 + Scale = 0
133 + Charset id = 0
134 + Nullable
135 + Size = 4
136 +
137 + SQLType =SQL_TIMESTAMP
138 + sub type = 0
139 + Table = EMPLOYEE
140 + Owner = SYSDBA
141 + Column Name = HIRE_DATE
142 + Alias Name = HIRE_DATE
143 + Field Name = HIRE_DATE
144 + Scale = 0
145 + Charset id = 0
146 + Not Null
147 + Size = 8
148 +
149 + SQLType =SQL_TEXT
150 + sub type = 0
151 + Table = EMPLOYEE
152 + Owner = SYSDBA
153 + Column Name = DEPT_NO
154 + Alias Name = DEPT_NO
155 + Field Name = DEPT_NO
156 + Scale = 0
157 + Charset id = 0
158 + Not Null
159 + Size = 3
160 +
161 + SQLType =SQL_VARYING
162 + sub type = 0
163 + Table = EMPLOYEE
164 + Owner = SYSDBA
165 + Column Name = JOB_CODE
166 + Alias Name = JOB_CODE
167 + Field Name = JOB_CODE
168 + Scale = 0
169 + Charset id = 0
170 + Not Null
171 + Size = 5
172 +
173 + SQLType =SQL_SHORT
174 + sub type = 0
175 + Table = EMPLOYEE
176 + Owner = SYSDBA
177 + Column Name = JOB_GRADE
178 + Alias Name = JOB_GRADE
179 + Field Name = JOB_GRADE
180 + Scale = 0
181 + Charset id = 0
182 + Not Null
183 + Size = 2
184 +
185 + SQLType =SQL_VARYING
186 + sub type = 0
187 + Table = EMPLOYEE
188 + Owner = SYSDBA
189 + Column Name = JOB_COUNTRY
190 + Alias Name = JOB_COUNTRY
191 + Field Name = JOB_COUNTRY
192 + Scale = 0
193 + Charset id = 0
194 + Not Null
195 + Size = 15
196 +
197 + SQLType =SQL_INT64
198 + sub type = 0
199 + Table = EMPLOYEE
200 + Owner = SYSDBA
201 + Column Name = SALARY
202 + Alias Name = SALARY
203 + Field Name = SALARY
204 + Scale = -2
205 + Charset id = 0
206 + Not Null
207 + Size = 8
208 +
209 + SQLType =SQL_VARYING
210 + sub type = 0
211 + Table = EMPLOYEE
212 + Owner = SYSDBA
213 + Column Name = FULL_NAME
214 + Alias Name = FULL_NAME
215 + Field Name = FULL_NAME
216 + Scale = 0
217 + Charset id = 0
218 + Nullable
219 + Size = 37
220 +
221 + Plan =
222 + Select Expression
223 +    -> First N Records
224 +        -> Table "EMPLOYEE" Full Scan
225 + -- SQL style inline comment
226 + /* this is a comment */ Select First 3 * from EMPLOYEE
227 +
228 + EMP_NO = 2
229 + FIRST_NAME = Robert
230 + LAST_NAME = Nelson
231 + PHONE_EXT = 250
232 + HIRE_DATE = 1988/12/28 00:00:00.0000
233 + DEPT_NO = 600
234 + JOB_CODE = VP
235 + JOB_GRADE = 2
236 + JOB_COUNTRY = USA
237 + SALARY = 105,900.00
238 + FULL_NAME = Nelson, Robert
239 + EMP_NO = 4
240 + FIRST_NAME = Bruce
241 + LAST_NAME = Young
242 + PHONE_EXT = 233
243 + HIRE_DATE = 1988/12/28 00:00:00.0000
244 + DEPT_NO = 621
245 + JOB_CODE = Eng
246 + JOB_GRADE = 2
247 + JOB_COUNTRY = USA
248 + SALARY = 97,500.00
249 + FULL_NAME = Young, Bruce
250 + EMP_NO = 5
251 + FIRST_NAME = Kim
252 + LAST_NAME = Lambert
253 + PHONE_EXT = 22
254 + HIRE_DATE = 1989/02/06 00:00:00.0000
255 + DEPT_NO = 130
256 + JOB_CODE = Eng
257 + JOB_GRADE = 2
258 + JOB_COUNTRY = USA
259 + SALARY = 102,750.00
260 + FULL_NAME = Lambert, Kim
261 +
262 + Select * from EMPLOYEE Where EMP_NO = ?
263 + SQL Params
264 + SQLType =SQL_SHORT
265 + sub type = 0
266 + Field Name =
267 + Scale = 0
268 + Charset id = 0
269 + Not Null
270 + Size = 2
271 + Value = 0
272 +
273 + EMP_NO = 8
274 + FIRST_NAME = Leslie
275 + LAST_NAME = Johnson
276 + PHONE_EXT = 410
277 + HIRE_DATE = 1989/04/05 00:00:00.0000
278 + DEPT_NO = 180
279 + JOB_CODE = Mktg
280 + JOB_GRADE = 3
281 + JOB_COUNTRY = USA
282 + SALARY = 64,635.00
283 + FULL_NAME = Johnson, Leslie
284 +
285 + With param names
286 + Select * from EMPLOYEE Where EMP_NO = :EMP_NO
287 + SQL Params
288 + SQLType =SQL_SHORT
289 + sub type = 0
290 + Field Name = EMP_NO
291 + Scale = 0
292 + Charset id = 0
293 + Not Null
294 + Size = 2
295 + Value = 0
296 +
297 + Results for Cursor: Test Cursor
298 + EMP_NO = 8
299 + FIRST_NAME = Leslie
300 + LAST_NAME = Johnson
301 + PHONE_EXT = 410
302 + HIRE_DATE = 1989/04/05 00:00:00.0000
303 + DEPT_NO = 180
304 + JOB_CODE = Mktg
305 + JOB_GRADE = 3
306 + JOB_COUNTRY = USA
307 + SALARY = 64,635.00
308 + FULL_NAME = Johnson, Leslie
309 +
310 + Scollable Cursors
311 + DB Connect String = inet://localhost/employee
312 + DB Charset ID = 4
313 + DB SQL Dialect = 3
314 + DB Remote Protocol = TCPv4
315 + DB ODS Major Version = 12
316 + DB ODS Minor Version = 0
317 + User Authentication Method = Srp
318 + Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
319 + DB Client Implementation Version = 3.0
320 + Do Fetch Next:
321 + EMP_NO = 2
322 + FIRST_NAME = Robert
323 + LAST_NAME = Nelson
324 + PHONE_EXT = 250
325 + HIRE_DATE = 1988/12/28 00:00:00.0000
326 + DEPT_NO = 600
327 + JOB_CODE = VP
328 + JOB_GRADE = 2
329 + JOB_COUNTRY = USA
330 + SALARY = 105,900.00
331 + FULL_NAME = Nelson, Robert
332 + Do Fetch Last:
333 + Remote Scrollable cursors test fails feature is not supported
334 + Now open the employee database as a local database
335 + TPB: Item Count = 3
336 +  isc_tpb_read
337 +  isc_tpb_nowait
338 +  isc_tpb_concurrency
339 +
340   Metadata
341   SQLType =SQL_SHORT
342   sub type = 0
# Line 214 | Line 481 | EMP_NO = 2
481   FIRST_NAME = Robert
482   LAST_NAME = Nelson
483   PHONE_EXT = 250
484 < HIRE_DATE = 28/12/1988 00:00:00.000
484 > HIRE_DATE = 1988/12/28 00:00:00.0000
485   DEPT_NO = 600
486   JOB_CODE = VP
487   JOB_GRADE = 2
# Line 225 | Line 492 | EMP_NO = 4
492   FIRST_NAME = Bruce
493   LAST_NAME = Young
494   PHONE_EXT = 233
495 < HIRE_DATE = 28/12/1988 00:00:00.000
495 > HIRE_DATE = 1988/12/28 00:00:00.0000
496   DEPT_NO = 621
497   JOB_CODE = Eng
498   JOB_GRADE = 2
# Line 236 | Line 503 | EMP_NO = 5
503   FIRST_NAME = Kim
504   LAST_NAME = Lambert
505   PHONE_EXT = 22
506 < HIRE_DATE = 6/2/1989 00:00:00.000
506 > HIRE_DATE = 1989/02/06 00:00:00.0000
507   DEPT_NO = 130
508   JOB_CODE = Eng
509   JOB_GRADE = 2
# Line 253 | Line 520 | Scale = 0
520   Charset id = 0
521   Not Null
522   Size = 2
523 + Value = 0
524  
525   EMP_NO = 8
526   FIRST_NAME = Leslie
527   LAST_NAME = Johnson
528   PHONE_EXT = 410
529 < HIRE_DATE = 5/4/1989 00:00:00.000
529 > HIRE_DATE = 1989/04/05 00:00:00.0000
530   DEPT_NO = 180
531   JOB_CODE = Mktg
532   JOB_GRADE = 3
# Line 276 | Line 544 | Scale = 0
544   Charset id = 0
545   Not Null
546   Size = 2
547 + Value = 0
548  
549 + Results for Cursor: Test Cursor
550   EMP_NO = 8
551   FIRST_NAME = Leslie
552   LAST_NAME = Johnson
553   PHONE_EXT = 410
554 < HIRE_DATE = 5/4/1989 00:00:00.000
554 > HIRE_DATE = 1989/04/05 00:00:00.0000
555   DEPT_NO = 180
556   JOB_CODE = Mktg
557   JOB_GRADE = 3
# Line 289 | Line 559 | JOB_COUNTRY = USA
559   SALARY = 64,635.00
560   FULL_NAME = Johnson, Leslie
561  
562 + Scollable Cursors
563 + DB Connect String = employee
564 + DB Charset ID = 4
565 + DB SQL Dialect = 3
566 + DB Remote Protocol =
567 + DB ODS Major Version = 12
568 + DB ODS Minor Version = 0
569 + User Authentication Method = User name in DPB
570 + Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
571 + DB Client Implementation Version = 3.0
572 + Do Fetch Next:
573 + EMP_NO = 2
574 + FIRST_NAME = Robert
575 + LAST_NAME = Nelson
576 + PHONE_EXT = 250
577 + HIRE_DATE = 1988/12/28 00:00:00.0000
578 + DEPT_NO = 600
579 + JOB_CODE = VP
580 + JOB_GRADE = 2
581 + JOB_COUNTRY = USA
582 + SALARY = 105,900.00
583 + FULL_NAME = Nelson, Robert
584 + Do Fetch Last:
585 + EMP_NO = 145
586 + FIRST_NAME = Mark
587 + LAST_NAME = Guckenheimer
588 + PHONE_EXT = 221
589 + HIRE_DATE = 1994/05/02 00:00:00.0000
590 + DEPT_NO = 622
591 + JOB_CODE = Eng
592 + JOB_GRADE = 5
593 + JOB_COUNTRY = USA
594 + SALARY = 32,000.00
595 + FULL_NAME = Guckenheimer, Mark
596 + Do Fetch Prior:
597 + EMP_NO = 144
598 + FIRST_NAME = John
599 + LAST_NAME = Montgomery
600 + PHONE_EXT = 820
601 + HIRE_DATE = 1994/03/30 00:00:00.0000
602 + DEPT_NO = 672
603 + JOB_CODE = Eng
604 + JOB_GRADE = 5
605 + JOB_COUNTRY = USA
606 + SALARY = 35,000.00
607 + FULL_NAME = Montgomery, John
608 + Do Fetch First:
609 + EMP_NO = 2
610 + FIRST_NAME = Robert
611 + LAST_NAME = Nelson
612 + PHONE_EXT = 250
613 + HIRE_DATE = 1988/12/28 00:00:00.0000
614 + DEPT_NO = 600
615 + JOB_CODE = VP
616 + JOB_GRADE = 2
617 + JOB_COUNTRY = USA
618 + SALARY = 105,900.00
619 + FULL_NAME = Nelson, Robert
620 + Do Fetch Abs 8 :
621 + EMP_NO = 14
622 + FIRST_NAME = Stewart
623 + LAST_NAME = Hall
624 + PHONE_EXT = 227
625 + HIRE_DATE = 1990/06/04 00:00:00.0000
626 + DEPT_NO = 900
627 + JOB_CODE = Finan
628 + JOB_GRADE = 3
629 + JOB_COUNTRY = USA
630 + SALARY = 69,482.63
631 + FULL_NAME = Hall, Stewart
632 + Do Fetch Relative -2 :
633 + EMP_NO = 11
634 + FIRST_NAME = K. J.
635 + LAST_NAME = Weston
636 + PHONE_EXT = 34
637 + HIRE_DATE = 1990/01/17 00:00:00.0000
638 + DEPT_NO = 130
639 + JOB_CODE = SRep
640 + JOB_GRADE = 4
641 + JOB_COUNTRY = USA
642 + SALARY = 86,292.94
643 + FULL_NAME = Weston, K. J.
644 + Do Fetch beyond EOF :
645 + Fetch returned false
646  
647  
648 + ------------------------------------------------------
649   Running Test 3: ad hoc queries
650   Opening inet://localhost/employee
651   Database Open
652   Employee Count = 42
653 + Transaction ID = 5005
654 + Transaction is Read/Write
655 + Transaction Database Path = inet://localhost/employee
656 + Transaction ID = 5005
657 + Oldest Interesting = 5003
658 + Oldest Action = 5004
659 + Oldest Snapshot = 5004
660 + Oldest Interesting = 0
661   Employee Count = 41
662   Employee Count = 42
663   Employee Count = 41
# Line 304 | Line 667 | Constrained Employee Count = 3
667   "Yanowski" Employee Count = 1
668  
669  
670 + ------------------------------------------------------
671   Running Test 4: Update, Insert and Delete Queries
672   Opening inet://localhost/employee
673   Database Open
# Line 316 | Line 680 | EMP_NO = 8
680   FIRST_NAME = Leslie
681   LAST_NAME = Johnson
682   PHONE_EXT = 410
683 < HIRE_DATE = 5/4/1989 00:00:00.000
683 > HIRE_DATE = 1989/04/05 00:00:00.0000
684   DEPT_NO = 180
685   JOB_CODE = Mktg
686   JOB_GRADE = 3
# Line 324 | Line 688 | JOB_COUNTRY = USA
688   SALARY = 64,635.00
689   FULL_NAME = Johnson, Leslie
690  
691 < Current memory = 19693296
692 < Delta memory = 4480
693 < Max memory = 19755408
694 < Elapsed time= 0.001 sec
695 < Cpu = 0.000 sec
691 > Current memory = 19,694,032
692 > Delta memory = 4,480
693 > Max memory = 19,755,888
694 > Elapsed time= 0.002 sec
695 > Cpu = 0.010 sec
696   Buffers = 2048
697   Reads = 0
698   Writes = 0
# Line 472 | Line 836 | EMP_NO = 150
836   FIRST_NAME = John
837   LAST_NAME = Doe
838   PHONE_EXT =
839 < HIRE_DATE = 1/4/2015 00:00:00.000
839 > HIRE_DATE = 2015/04/01 00:00:00.0000
840   DEPT_NO = 600
841   JOB_CODE = Eng
842   JOB_GRADE = 4
# Line 485 | Line 849 | EMP_NO = 151
849   FIRST_NAME = Major
850   LAST_NAME = Major
851   PHONE_EXT =
852 < HIRE_DATE = 1/4/2015 00:00:00.000
852 > HIRE_DATE = 2015/04/01 00:00:00.0000
853   DEPT_NO = 600
854   JOB_CODE = Eng
855   JOB_GRADE = 4
# Line 502 | Line 866 | EMP_NO = 150
866   FIRST_NAME = Jane
867   LAST_NAME = Doe
868   PHONE_EXT = NULL
869 < HIRE_DATE = 1/4/2015 00:00:00.000
869 > HIRE_DATE = 2015/04/01 00:00:00.0000
870   DEPT_NO = 600
871   JOB_CODE = Eng
872   JOB_GRADE = 4
# Line 519 | Line 883 | EMP_NO = 150
883   FIRST_NAME = Jayne's
884   LAST_NAME = Doe
885   PHONE_EXT = NULL
886 < HIRE_DATE = 1/4/2015 00:00:00.000
886 > HIRE_DATE = 2015/04/01 00:00:00.0000
887   DEPT_NO = 600
888   JOB_CODE = Eng
889   JOB_GRADE = 4
# Line 533 | Line 897 | EMP_NO = 8
897   FIRST_NAME = Leslie
898   LAST_NAME = Johnson
899   PHONE_EXT = 410
900 < HIRE_DATE = 5/4/1989 00:00:00.000
900 > HIRE_DATE = 1989/04/05 00:00:00.0000
901   DEPT_NO = 180
902   JOB_CODE = Mktg
903   JOB_GRADE = 3
# Line 547 | Line 911 | EMP_NO = 8
911   FIRST_NAME = Leslie
912   LAST_NAME = Johnson
913   PHONE_EXT = 410
914 < HIRE_DATE = 5/4/1989 00:00:00.000
914 > HIRE_DATE = 1989/04/05 00:00:00.0000
915   DEPT_NO = 180
916   JOB_CODE = Mktg
917   JOB_GRADE = 3
# Line 559 | Line 923 | EMP_NO = 9
923   FIRST_NAME = Phil
924   LAST_NAME = Forest
925   PHONE_EXT = 229
926 < HIRE_DATE = 17/4/1989 00:00:00.000
926 > HIRE_DATE = 1989/04/17 00:00:00.0000
927   DEPT_NO = 622
928   JOB_CODE = Mngr
929   JOB_GRADE = 3
# Line 573 | Line 937 | EMP_NO = 8
937   FIRST_NAME = Leslie
938   LAST_NAME = Johnson
939   PHONE_EXT = 410
940 < HIRE_DATE = 31/1/2015 00:00:00.000
940 > HIRE_DATE = 2015/01/31 00:00:00.0000
941   DEPT_NO = 180
942   JOB_CODE = Mktg
943   JOB_GRADE = 3
# Line 583 | Line 947 | FULL_NAME = Johnson, Leslie
947  
948  
949  
950 + ------------------------------------------------------
951   Running Test 5: Update Returning and Activity Check
952   Opening inet://localhost/employee
953   Database Open
# Line 594 | Line 959 | EMP_NO = 8
959   FIRST_NAME = Leslie
960   LAST_NAME = Johnson
961   PHONE_EXT = 410
962 < HIRE_DATE = 31/1/2016 00:00:00.000
962 > HIRE_DATE = 2016/01/31 00:00:00.0000
963   DEPT_NO = 180
964   JOB_CODE = Mktg
965   JOB_GRADE = 3
# Line 616 | Line 981 | Transaction Active
981   Transaction inactive
982  
983  
984 + ------------------------------------------------------
985   Running Test 6: Blob Handling
986   Metadata
987   SQLType =SQL_TEXT
# Line 642 | Line 1008 | Charset id = 0
1008   Nullable
1009   Size = 2
1010  
1011 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1011 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
1012   RDB$CHARACTER_SET_ID = 0
1013 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1013 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
1014   RDB$CHARACTER_SET_ID = 1
1015 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1015 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
1016   RDB$CHARACTER_SET_ID = 2
1017 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1017 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
1018   RDB$CHARACTER_SET_ID = 3
1019 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1019 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
1020   RDB$CHARACTER_SET_ID = 4
1021 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1021 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
1022   RDB$CHARACTER_SET_ID = 5
1023 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1023 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
1024   RDB$CHARACTER_SET_ID = 6
1025 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1025 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
1026   RDB$CHARACTER_SET_ID = 9
1027 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1027 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
1028   RDB$CHARACTER_SET_ID = 10
1029 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1029 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
1030   RDB$CHARACTER_SET_ID = 11
1031 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1031 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
1032   RDB$CHARACTER_SET_ID = 12
1033 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1033 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
1034   RDB$CHARACTER_SET_ID = 13
1035 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1035 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
1036   RDB$CHARACTER_SET_ID = 14
1037 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1037 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
1038   RDB$CHARACTER_SET_ID = 15
1039 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1039 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
1040   RDB$CHARACTER_SET_ID = 16
1041 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1041 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
1042   RDB$CHARACTER_SET_ID = 17
1043 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1043 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
1044   RDB$CHARACTER_SET_ID = 18
1045 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1045 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
1046   RDB$CHARACTER_SET_ID = 19
1047 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1047 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
1048   RDB$CHARACTER_SET_ID = 21
1049 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1049 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
1050   RDB$CHARACTER_SET_ID = 22
1051 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1051 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
1052   RDB$CHARACTER_SET_ID = 23
1053 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1053 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
1054   RDB$CHARACTER_SET_ID = 34
1055 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1055 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
1056   RDB$CHARACTER_SET_ID = 35
1057 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1057 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
1058   RDB$CHARACTER_SET_ID = 36
1059 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1059 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
1060   RDB$CHARACTER_SET_ID = 37
1061 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1061 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
1062   RDB$CHARACTER_SET_ID = 38
1063 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1063 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
1064   RDB$CHARACTER_SET_ID = 39
1065 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1065 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
1066   RDB$CHARACTER_SET_ID = 40
1067 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1067 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
1068   RDB$CHARACTER_SET_ID = 44
1069 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1069 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
1070   RDB$CHARACTER_SET_ID = 45
1071 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1071 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
1072   RDB$CHARACTER_SET_ID = 46
1073 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1073 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
1074   RDB$CHARACTER_SET_ID = 47
1075 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1075 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
1076   RDB$CHARACTER_SET_ID = 48
1077 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1077 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
1078   RDB$CHARACTER_SET_ID = 49
1079 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1079 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
1080   RDB$CHARACTER_SET_ID = 50
1081 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1081 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
1082   RDB$CHARACTER_SET_ID = 51
1083 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1083 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
1084   RDB$CHARACTER_SET_ID = 52
1085 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1085 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
1086   RDB$CHARACTER_SET_ID = 53
1087 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1087 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
1088   RDB$CHARACTER_SET_ID = 54
1089 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1089 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
1090   RDB$CHARACTER_SET_ID = 55
1091 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1091 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
1092   RDB$CHARACTER_SET_ID = 56
1093 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1093 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
1094   RDB$CHARACTER_SET_ID = 57
1095 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1095 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
1096   RDB$CHARACTER_SET_ID = 58
1097 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1097 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
1098   RDB$CHARACTER_SET_ID = 59
1099 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1099 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
1100   RDB$CHARACTER_SET_ID = 60
1101 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1101 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
1102   RDB$CHARACTER_SET_ID = 63
1103 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1103 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
1104   RDB$CHARACTER_SET_ID = 64
1105 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1105 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
1106   RDB$CHARACTER_SET_ID = 65
1107 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1107 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
1108   RDB$CHARACTER_SET_ID = 66
1109 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1109 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
1110   RDB$CHARACTER_SET_ID = 67
1111 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1111 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
1112   RDB$CHARACTER_SET_ID = 68
1113 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1113 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
1114   RDB$CHARACTER_SET_ID = 69
1115  
1116   Metadata
# Line 824 | Line 1190 | Scale = 0
1190   Charset id = 0
1191   Not Null
1192   Size = 4
1193 + Value = 0
1194  
1195   SQLType =SQL_VARYING
1196   sub type = 0
# Line 852 | Line 1219 | Size = 8
1219   ROWID = 1
1220   FIXEDPOINT = 20.28
1221   FLOATINGPOINT = 3.14
1222 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1222 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1223   BLOBDATA = NULL
1224  
1225   SQL Params
# Line 871 | Line 1238 | Scale = 0
1238   Charset id = 0
1239   Not Null
1240   Size = 4
1241 + Value = 0
1242  
1243   ROWID = 1
1244   FIXEDPOINT = 20.28
1245   FLOATINGPOINT = 3.14
1246 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1246 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1247   BLOBDATA (Charset Id = 4 Codepage = 65001)
1248  
1249   To be or not to be-that is the question:
# Line 923 | Line 1291 | Scale = 0
1291   Charset id = 0
1292   Not Null
1293   Size = 4
1294 + Value = 0
1295  
1296   SQLType =SQL_VARYING
1297   sub type = 0
# Line 951 | Line 1320 | Size = 8
1320   ROWID = 1
1321   FIXEDPOINT = 20.28
1322   FLOATINGPOINT = 3.14
1323 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1323 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1324   BLOBDATA (Charset Id = 4 Codepage = 65001)
1325  
1326   To be or not to be-that is the question:
# Line 993 | Line 1362 | Be all my sins remembered
1362   ROWID = 2
1363   FIXEDPOINT = NULL
1364   FLOATINGPOINT = NULL
1365 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1365 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1366   BLOBDATA (Charset Id = 4 Codepage = 65001)
1367  
1368   To be or not to be-that is the question:
# Line 1118 | Line 1487 | Charset id = 0
1487   Nullable
1488   Size = 2
1489  
1490 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1490 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1491   RDB$CHARACTER_SET_ID = 0
1492 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1492 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1493   RDB$CHARACTER_SET_ID = 1
1494 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1494 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1495   RDB$CHARACTER_SET_ID = 2
1496 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1496 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1497   RDB$CHARACTER_SET_ID = 3
1498 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1498 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1499   RDB$CHARACTER_SET_ID = 4
1500 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1500 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1501   RDB$CHARACTER_SET_ID = 5
1502 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1502 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1503   RDB$CHARACTER_SET_ID = 6
1504 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1504 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1505   RDB$CHARACTER_SET_ID = 9
1506 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1506 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1507   RDB$CHARACTER_SET_ID = 10
1508 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1508 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1509   RDB$CHARACTER_SET_ID = 11
1510 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1510 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1511   RDB$CHARACTER_SET_ID = 12
1512 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1512 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1513   RDB$CHARACTER_SET_ID = 13
1514 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1514 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1515   RDB$CHARACTER_SET_ID = 14
1516 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1516 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1517   RDB$CHARACTER_SET_ID = 15
1518 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1518 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1519   RDB$CHARACTER_SET_ID = 16
1520 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1520 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1521   RDB$CHARACTER_SET_ID = 17
1522 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1522 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1523   RDB$CHARACTER_SET_ID = 18
1524 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1524 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1525   RDB$CHARACTER_SET_ID = 19
1526 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1526 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1527   RDB$CHARACTER_SET_ID = 21
1528 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1528 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1529   RDB$CHARACTER_SET_ID = 22
1530 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1530 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1531   RDB$CHARACTER_SET_ID = 23
1532 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1532 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1533   RDB$CHARACTER_SET_ID = 34
1534 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1534 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1535   RDB$CHARACTER_SET_ID = 35
1536 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1536 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1537   RDB$CHARACTER_SET_ID = 36
1538 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1538 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1539   RDB$CHARACTER_SET_ID = 37
1540 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1540 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1541   RDB$CHARACTER_SET_ID = 38
1542 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1542 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1543   RDB$CHARACTER_SET_ID = 39
1544 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1544 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1545   RDB$CHARACTER_SET_ID = 40
1546 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1546 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1547   RDB$CHARACTER_SET_ID = 44
1548 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1548 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1549   RDB$CHARACTER_SET_ID = 45
1550 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1550 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1551   RDB$CHARACTER_SET_ID = 46
1552 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1552 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1553   RDB$CHARACTER_SET_ID = 47
1554 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1554 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1555   RDB$CHARACTER_SET_ID = 48
1556 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1556 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1557   RDB$CHARACTER_SET_ID = 49
1558 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1558 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1559   RDB$CHARACTER_SET_ID = 50
1560 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1560 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1561   RDB$CHARACTER_SET_ID = 51
1562 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1562 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1563   RDB$CHARACTER_SET_ID = 52
1564 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1564 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1565   RDB$CHARACTER_SET_ID = 53
1566 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1566 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1567   RDB$CHARACTER_SET_ID = 54
1568 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1568 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1569   RDB$CHARACTER_SET_ID = 55
1570 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1570 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1571   RDB$CHARACTER_SET_ID = 56
1572 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1572 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1573   RDB$CHARACTER_SET_ID = 57
1574 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1574 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1575   RDB$CHARACTER_SET_ID = 58
1576 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1576 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1577   RDB$CHARACTER_SET_ID = 59
1578 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1578 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1579   RDB$CHARACTER_SET_ID = 60
1580 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1580 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1581   RDB$CHARACTER_SET_ID = 63
1582 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1582 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1583   RDB$CHARACTER_SET_ID = 64
1584 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1584 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1585   RDB$CHARACTER_SET_ID = 65
1586 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1586 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1587   RDB$CHARACTER_SET_ID = 66
1588 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1588 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1589   RDB$CHARACTER_SET_ID = 67
1590 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1590 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1591   RDB$CHARACTER_SET_ID = 68
1592 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1592 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1593   RDB$CHARACTER_SET_ID = 69
1594  
1595   Metadata
# Line 1300 | Line 1669 | Scale = 0
1669   Charset id = 0
1670   Not Null
1671   Size = 4
1672 + Value = 0
1673  
1674   SQLType =SQL_VARYING
1675   sub type = 0
# Line 1328 | Line 1698 | Size = 8
1698   ROWID = 1
1699   FIXEDPOINT = 20.28
1700   FLOATINGPOINT = 3.14
1701 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1701 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1702   BLOBDATA = NULL
1703  
1704   SQL Params
# Line 1347 | Line 1717 | Scale = 0
1717   Charset id = 0
1718   Not Null
1719   Size = 4
1720 + Value = 0
1721  
1722   ROWID = 1
1723   FIXEDPOINT = 20.28
1724   FLOATINGPOINT = 3.14
1725 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1725 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1726   BLOBDATA (Charset Id = 53 Codepage = 1252)
1727  
1728   To be or not to be-that is the question:
# Line 1399 | Line 1770 | Scale = 0
1770   Charset id = 0
1771   Not Null
1772   Size = 4
1773 + Value = 0
1774  
1775   SQLType =SQL_VARYING
1776   sub type = 0
# Line 1427 | Line 1799 | Size = 8
1799   ROWID = 1
1800   FIXEDPOINT = 20.28
1801   FLOATINGPOINT = 3.14
1802 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1802 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1803   BLOBDATA (Charset Id = 53 Codepage = 1252)
1804  
1805   To be or not to be-that is the question:
# Line 1469 | Line 1841 | Be all my sins remembered
1841   ROWID = 2
1842   FIXEDPOINT = NULL
1843   FLOATINGPOINT = NULL
1844 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1844 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1845   BLOBDATA (Charset Id = 53 Codepage = 1252)
1846  
1847   To be or not to be-that is the question:
# Line 1594 | Line 1966 | Charset id = 0
1966   Nullable
1967   Size = 2
1968  
1969 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1969 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1970   RDB$CHARACTER_SET_ID = 0
1971 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1971 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1972   RDB$CHARACTER_SET_ID = 1
1973 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1973 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1974   RDB$CHARACTER_SET_ID = 2
1975 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1975 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1976   RDB$CHARACTER_SET_ID = 3
1977 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1977 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1978   RDB$CHARACTER_SET_ID = 4
1979 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1979 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1980   RDB$CHARACTER_SET_ID = 5
1981 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1981 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1982   RDB$CHARACTER_SET_ID = 6
1983 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1983 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1984   RDB$CHARACTER_SET_ID = 9
1985 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1985 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1986   RDB$CHARACTER_SET_ID = 10
1987 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1987 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1988   RDB$CHARACTER_SET_ID = 11
1989 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1989 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1990   RDB$CHARACTER_SET_ID = 12
1991 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1991 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1992   RDB$CHARACTER_SET_ID = 13
1993 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1993 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1994   RDB$CHARACTER_SET_ID = 14
1995 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1995 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1996   RDB$CHARACTER_SET_ID = 15
1997 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1997 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1998   RDB$CHARACTER_SET_ID = 16
1999 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1999 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
2000   RDB$CHARACTER_SET_ID = 17
2001 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2001 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
2002   RDB$CHARACTER_SET_ID = 18
2003 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2003 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
2004   RDB$CHARACTER_SET_ID = 19
2005 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2005 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
2006   RDB$CHARACTER_SET_ID = 21
2007 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2007 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
2008   RDB$CHARACTER_SET_ID = 22
2009 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2009 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
2010   RDB$CHARACTER_SET_ID = 23
2011 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2011 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
2012   RDB$CHARACTER_SET_ID = 34
2013 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2013 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
2014   RDB$CHARACTER_SET_ID = 35
2015 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2015 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
2016   RDB$CHARACTER_SET_ID = 36
2017 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2017 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
2018   RDB$CHARACTER_SET_ID = 37
2019 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2019 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
2020   RDB$CHARACTER_SET_ID = 38
2021 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2021 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
2022   RDB$CHARACTER_SET_ID = 39
2023 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2023 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
2024   RDB$CHARACTER_SET_ID = 40
2025 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2025 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
2026   RDB$CHARACTER_SET_ID = 44
2027 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2027 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
2028   RDB$CHARACTER_SET_ID = 45
2029 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2029 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
2030   RDB$CHARACTER_SET_ID = 46
2031 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2031 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
2032   RDB$CHARACTER_SET_ID = 47
2033 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2033 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
2034   RDB$CHARACTER_SET_ID = 48
2035 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2035 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
2036   RDB$CHARACTER_SET_ID = 49
2037 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2037 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
2038   RDB$CHARACTER_SET_ID = 50
2039 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2039 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
2040   RDB$CHARACTER_SET_ID = 51
2041 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2041 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
2042   RDB$CHARACTER_SET_ID = 52
2043 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2043 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
2044   RDB$CHARACTER_SET_ID = 53
2045 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2045 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
2046   RDB$CHARACTER_SET_ID = 54
2047 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2047 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
2048   RDB$CHARACTER_SET_ID = 55
2049 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2049 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
2050   RDB$CHARACTER_SET_ID = 56
2051 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2051 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
2052   RDB$CHARACTER_SET_ID = 57
2053 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2053 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
2054   RDB$CHARACTER_SET_ID = 58
2055 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2055 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
2056   RDB$CHARACTER_SET_ID = 59
2057 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2057 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
2058   RDB$CHARACTER_SET_ID = 60
2059 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2059 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
2060   RDB$CHARACTER_SET_ID = 63
2061 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2061 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
2062   RDB$CHARACTER_SET_ID = 64
2063 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2063 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
2064   RDB$CHARACTER_SET_ID = 65
2065 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2065 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
2066   RDB$CHARACTER_SET_ID = 66
2067 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2067 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
2068   RDB$CHARACTER_SET_ID = 67
2069 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2069 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
2070   RDB$CHARACTER_SET_ID = 68
2071 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2071 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
2072   RDB$CHARACTER_SET_ID = 69
2073  
2074   Metadata
# Line 1776 | Line 2148 | Scale = 0
2148   Charset id = 0
2149   Not Null
2150   Size = 4
2151 + Value = 0
2152  
2153   SQLType =SQL_VARYING
2154   sub type = 0
# Line 1804 | Line 2177 | Size = 8
2177   ROWID = 1
2178   FIXEDPOINT = 20.28
2179   FLOATINGPOINT = 3.14
2180 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2180 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2181   BLOBDATA = NULL
2182  
2183   SQL Params
# Line 1823 | Line 2196 | Scale = 0
2196   Charset id = 0
2197   Not Null
2198   Size = 4
2199 + Value = 0
2200  
2201   ROWID = 1
2202   FIXEDPOINT = 20.28
2203   FLOATINGPOINT = 3.14
2204 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2204 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2205   BLOBDATA (Charset Id = 4 Codepage = 65001)
2206  
2207   To be or not to be-that is the question:
# Line 1875 | Line 2249 | Scale = 0
2249   Charset id = 0
2250   Not Null
2251   Size = 4
2252 + Value = 0
2253  
2254   SQLType =SQL_VARYING
2255   sub type = 0
# Line 1903 | Line 2278 | Size = 8
2278   ROWID = 1
2279   FIXEDPOINT = 20.28
2280   FLOATINGPOINT = 3.14
2281 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2281 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2282   BLOBDATA (Charset Id = 4 Codepage = 65001)
2283  
2284   To be or not to be-that is the question:
# Line 1945 | Line 2320 | Be all my sins remembered
2320   ROWID = 2
2321   FIXEDPOINT = NULL
2322   FLOATINGPOINT = NULL
2323 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2323 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2324   BLOBDATA (Charset Id = 4 Codepage = 65001)
2325  
2326   To be or not to be-that is the question:
# Line 2047 | Line 2422 | Be all my sins remembered
2422  
2423  
2424  
2425 + ------------------------------------------------------
2426   Running Test 7: Create and read back an Array
2427   Metadata
2428   SQLType =SQL_LONG
# Line 2118 | Line 2494 | Column = MYARRAY
2494   Dimensions = 1
2495   Bounds: (0:16)
2496  
2497 + SQLType =SQL_ARRAY
2498 + sub type = 0
2499 + Table = TESTDATA
2500 + Owner = SYSDBA
2501 + Column Name = MYARRAY2
2502 + Alias Name = MYARRAY2
2503 + Field Name = MYARRAY2
2504 + Scale = 0
2505 + Charset id = 0
2506 + Nullable
2507 + Size = 8
2508 + Array Meta Data:
2509 + SQLType =SQL_TIMESTAMP
2510 + Scale = 0
2511 + Charset id = 0
2512 + Size = 8
2513 + Table = TESTDATA
2514 + Column = MYARRAY2
2515 + Dimensions = 1
2516 + Bounds: (0:16)
2517 +
2518 + SQLType =SQL_ARRAY
2519 + sub type = 0
2520 + Table = TESTDATA
2521 + Owner = SYSDBA
2522 + Column Name = MYARRAY3
2523 + Alias Name = MYARRAY3
2524 + Field Name = MYARRAY3
2525 + Scale = 0
2526 + Charset id = 0
2527 + Nullable
2528 + Size = 8
2529 + Array Meta Data:
2530 + SQLType =SQL_INT64
2531 + Scale = -2
2532 + Charset id = 0
2533 + Size = 8
2534 + Table = TESTDATA
2535 + Column = MYARRAY3
2536 + Dimensions = 1
2537 + Bounds: (0:16)
2538 +
2539   SQL Params
2540   SQLType =SQL_LONG
2541   sub type = 0
# Line 2126 | Line 2544 | Scale = 0
2544   Charset id = 0
2545   Not Null
2546   Size = 4
2547 + Value = 0
2548  
2549   SQLType =SQL_VARYING
2550   sub type = 0
# Line 2156 | Line 2575 | Param Name = TITLE
2575   Param Name = DATED
2576   Param Name = NOTES
2577   ROWID = 1
2578 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2579 < DATED = 1/4/2016 09:30:00.100
2580 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2578 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2579 > DATED = 2016/04/01 09:30:00.1000
2580 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2581   MYARRAY = NULL
2582 + MYARRAY2 = NULL
2583 + MYARRAY3 = NULL
2584  
2585   SQL Params
2586   SQLType =SQL_ARRAY
# Line 2170 | Line 2591 | Charset id = 0
2591   Nullable
2592   Size = 8
2593  
2594 + SQL Params
2595 + SQLType =SQL_ARRAY
2596 + sub type = 0
2597 + Field Name = MYARRAY2
2598 + Scale = 0
2599 + Charset id = 0
2600 + Nullable
2601 + Size = 8
2602 +
2603 + SQL Params
2604 + SQLType =SQL_ARRAY
2605 + sub type = 0
2606 + Field Name = MYARRAY3
2607 + Scale = 0
2608 + Charset id = 0
2609 + Nullable
2610 + Size = 8
2611 +
2612 + Metadata
2613 + SQLType =SQL_LONG
2614 + sub type = 0
2615 + Table = TESTDATA
2616 + Owner = SYSDBA
2617 + Column Name = ROWID
2618 + Alias Name = ROWID
2619 + Field Name = ROWID
2620 + Scale = 0
2621 + Charset id = 0
2622 + Not Null
2623 + Size = 4
2624 +
2625 + SQLType =SQL_VARYING
2626 + sub type = 0
2627 + Table = TESTDATA
2628 + Owner = SYSDBA
2629 + Column Name = TITLE
2630 + Alias Name = TITLE
2631 + Field Name = TITLE
2632 + Scale = 0
2633 + Charset id = 4
2634 + Nullable
2635 + Size = 128
2636 +
2637 + SQLType =SQL_TIMESTAMP
2638 + sub type = 0
2639 + Table = TESTDATA
2640 + Owner = SYSDBA
2641 + Column Name = DATED
2642 + Alias Name = DATED
2643 + Field Name = DATED
2644 + Scale = 0
2645 + Charset id = 0
2646 + Nullable
2647 + Size = 8
2648 +
2649 + SQLType =SQL_VARYING
2650 + sub type = 0
2651 + Table = TESTDATA
2652 + Owner = SYSDBA
2653 + Column Name = NOTES
2654 + Alias Name = NOTES
2655 + Field Name = NOTES
2656 + Scale = 0
2657 + Charset id = 4
2658 + Nullable
2659 + Size = 256
2660 +
2661 + SQLType =SQL_ARRAY
2662 + sub type = 0
2663 + Table = TESTDATA
2664 + Owner = SYSDBA
2665 + Column Name = MYARRAY
2666 + Alias Name = MYARRAY
2667 + Field Name = MYARRAY
2668 + Scale = 0
2669 + Charset id = 0
2670 + Nullable
2671 + Size = 8
2672 + Array Meta Data:
2673 + SQLType =SQL_LONG
2674 + Scale = 0
2675 + Charset id = 0
2676 + Size = 4
2677 + Table = TESTDATA
2678 + Column = MYARRAY
2679 + Dimensions = 1
2680 + Bounds: (0:16)
2681 +
2682 + SQLType =SQL_ARRAY
2683 + sub type = 0
2684 + Table = TESTDATA
2685 + Owner = SYSDBA
2686 + Column Name = MYARRAY2
2687 + Alias Name = MYARRAY2
2688 + Field Name = MYARRAY2
2689 + Scale = 0
2690 + Charset id = 0
2691 + Nullable
2692 + Size = 8
2693 + Array Meta Data:
2694 + SQLType =SQL_TIMESTAMP
2695 + Scale = 0
2696 + Charset id = 0
2697 + Size = 8
2698 + Table = TESTDATA
2699 + Column = MYARRAY2
2700 + Dimensions = 1
2701 + Bounds: (0:16)
2702 +
2703 + SQLType =SQL_ARRAY
2704 + sub type = 0
2705 + Table = TESTDATA
2706 + Owner = SYSDBA
2707 + Column Name = MYARRAY3
2708 + Alias Name = MYARRAY3
2709 + Field Name = MYARRAY3
2710 + Scale = 0
2711 + Charset id = 0
2712 + Nullable
2713 + Size = 8
2714 + Array Meta Data:
2715 + SQLType =SQL_INT64
2716 + Scale = -2
2717 + Charset id = 0
2718 + Size = 8
2719 + Table = TESTDATA
2720 + Column = MYARRAY3
2721 + Dimensions = 1
2722 + Bounds: (0:16)
2723 +
2724   ROWID = 1
2725 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2726 < DATED = 1/4/2016 09:30:00.100
2727 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2728 < 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)
2725 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2726 > DATED = 2016/04/01 09:30:00.1000
2727 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2728 > 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)
2729 >
2730 > 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)
2731 >
2732 > 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: 0.42) (15: 42.45) (16: 4269)
2733 >
2734  
2735   Shrink to 2:10
2736   Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2737 +
2738   Write updated reduced slice
2739   Show update array
2740   ROWID = 1
2741 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2742 < DATED = 1/4/2016 09:30:00.100
2743 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2744 < 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)
2741 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2742 > DATED = 2016/04/01 09:30:00.1000
2743 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2744 > 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)
2745 >
2746 > 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)
2747 >
2748 > 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: 0.42) (15: 42.45) (16: 4269)
2749  
2750  
2751  
2752 +
2753 + ------------------------------------------------------
2754   Running Test 8: Create and read back an Array with 2 dimensions
2755   Metadata
2756   SQLType =SQL_LONG
# Line 2243 | Line 2806 | Scale = 0
2806   Charset id = 0
2807   Not Null
2808   Size = 4
2809 + Value = 0
2810  
2811   SQLType =SQL_VARYING
2812   sub type = 0
# Line 2253 | Line 2817 | Nullable
2817   Size = 128
2818  
2819   ROWID = 1
2820 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2820 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2821   MYARRAY = NULL
2822  
2823   ROWID = 1
2824 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2825 < 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)
2824 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2825 > 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)
2826 >
2827  
2828  
2829  
2830 + ------------------------------------------------------
2831   Running Test 9: Database Information tests
2832   Database ID = 4 FB = /opt/firebird3.0.5/examples/empbuild/employee.fdb SN = zeus
2833   Pages =307
# Line 2273 | Line 2839 | ODS major = 12
2839   Page Size = 8192
2840   Version = 1: LI-V6.3.5.33220 Firebird 3.0
2841   Database is Read/Write
2842 < Database Created: 9/1/2020 13:13:45
2842 > Database Created: 09/1/2020 13:13:45
2843   Pages Used = 297
2844   Pages Free = 10
2845 < Server Memory = 19195648
2845 > Server Memory = 19196128
2846   Forced Writes  = 1
2847 < Max Memory  = 19316160
2847 > Max Memory  = 19316896
2848   Num Buffers  = 2048
2849   Sweep Interval  = 20000
2850   Logged in Users: SYSDBA,
# Line 2324 | Line 2890 | Update Count Operation Counts
2890   Page Size = 8192
2891  
2892  
2893 + ------------------------------------------------------
2894   Running Test 10: Event Handling
2895   Call Async Wait
2896   Async Wait Called
# Line 2350 | Line 2917 | Event Signalled
2917   Event Counts: TESTEVENT, Count = 1
2918  
2919  
2920 + ------------------------------------------------------
2921   Running Test 11: Services API
2922 + SPB: Item Count = 2
2923 +  user_name = SYSDBA
2924 +  password = masterkey
2925 +
2926   Service Manager Version = 2
2927   Server Version = LI-V3.0.5.33220 Firebird 3.0
2928   Implementation = Firebird/Linux/AMD/Intel/x64
# Line 2372 | Line 2944 | User ID = 0
2944   Group ID = 0
2945  
2946  
2947 < Licence Info:
2376 < feature is not supported
2947 > Licence Info: feature is not supported
2948   -feature is not supported
2949  
2950 < Licence Mask Info:
2380 < feature is not supported
2950 > Licence Mask Info: feature is not supported
2951  
2952   Capabilities = 6
2953  
# Line 2407 | Line 2977 | Database OK
2977   Database Dropped
2978  
2979  
2980 + ------------------------------------------------------
2981   Running Test 12: Character Sets
2982   SQL Params
2983   SQLType =SQL_LONG
# Line 2416 | Line 2987 | Scale = 0
2987   Charset id = 0
2988   Not Null
2989   Size = 4
2990 + Value = 0
2991  
2992   SQLType =SQL_VARYING
2993   sub type = 0
# Line 2465 | Line 3037 | Charset id = 4
3037   Nullable
3038   Size = 16
3039  
3040 + Show Param Values
3041 + SQL Params
3042 + SQLType =SQL_LONG
3043 + sub type = 0
3044 + Field Name = ROWID
3045 + Scale = 0
3046 + Charset id = 0
3047 + Not Null
3048 + Size = 4
3049 + Value = 1
3050 +
3051 + SQLType =SQL_VARYING
3052 + sub type = 0
3053 + Field Name = TITLE
3054 + Scale = 0
3055 + Charset id = 4
3056 + Nullable
3057 + Size = 128
3058 + Value = Blob Test ©€
3059 +
3060 + SQLType =SQL_VARYING
3061 + sub type = 0
3062 + Field Name = NOTES
3063 + Scale = 0
3064 + Charset id = 4
3065 + Nullable
3066 + Size = 256
3067 + Value = Écoute moi
3068 +
3069 + SQLType =SQL_VARYING
3070 + sub type = 1
3071 + Field Name = BLOBDATA
3072 + Scale = 0
3073 + Charset id = 4
3074 + Nullable
3075 + Size = 8192
3076 + Value = Some German Special Characters like ÖÄÜöäüß
3077 +
3078 + SQLType =SQL_BLOB
3079 + sub type = 1
3080 + Field Name = BLOBDATA2
3081 + Scale = 0
3082 + Charset id = 4
3083 + Nullable
3084 + Size = 8
3085 + Value = Some German Special Characters like ÖÄÜöäüß
3086 +
3087 + SQLType =SQL_VARYING
3088 + sub type = 0
3089 + Field Name = INCLEAR
3090 + Scale = 0
3091 + Charset id = 1
3092 + Nullable
3093 + Size = 16
3094 + Value = &Test
3095  
3096 +
3097 + SQLType =SQL_VARYING
3098 + sub type = 0
3099 + Field Name = FIXEDWIDTH
3100 + Scale = 0
3101 + Charset id = 4
3102 + Nullable
3103 + Size = 16
3104 + Value = É
3105 +
3106   Connection Character Set UTF8
3107   ROWID = 1
3108 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3109 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3108 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3109 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3110   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)
3111   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)
3112 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3113 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
3112 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3113 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
3114  
3115   Connection Character Set NONE
3116   ROWID = 1
3117 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3118 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591 Byte Length = 10)
3117 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3118 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591)
3119   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)
3120   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)
3121 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3122 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
3121 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3122 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
3123  
3124   Connection Character Set WIN1252
3125   ROWID = 1
3126 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252 Byte Length = 12)
3127 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252 Byte Length = 10)
3126 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252)
3127 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252)
3128   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)
3129   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)
3130 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3131 < FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252 Byte Length = 4)
3130 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3131 > FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252)
3132  
3133  
3134  
3135 + ------------------------------------------------------
3136   Running Test 13: Transaction over two databases
3137   Init Database 1
3138   ROWID = 1
3139 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3140 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3139 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3140 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3141   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)
3142   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)
3143 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3143 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3144  
3145   Init Database 2
3146   ROWID = 1
3147 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3148 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3147 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3148 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3149   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)
3150   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)
3151 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3151 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3152  
3153   ROWID = 1
3154 < TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3155 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3154 > TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001)
3155 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3156   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)
3157   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)
3158 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3158 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3159  
3160   ROWID = 1
3161 < TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3162 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3161 > TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001)
3162 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3163   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)
3164   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)
3165 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3165 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3166  
3167  
3168  
3169 + ------------------------------------------------------
3170   Running Test 14: Non select procedures
3171   Default Character set Name = UTF8
3172   Metadata
# Line 2555 | Line 3194 | Nullable
3194   Size = 128
3195  
3196   ROWID = 1
3197 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3197 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3198  
3199   Repeat with a different execute transaction
3200  
3201   ROWID = 1
3202 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3202 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3203  
3204   Repeat with a original transaction
3205  
3206   ROWID = 1
3207 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3207 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3208  
3209  
3210 + ------------------------------------------------------
3211   Running Test 15: Blob Handling and BPBs
3212  
3213   Testdata
3214  
3215   ROWID = 1
3216 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3216 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3217   BLOBDATA = (blob), Length = 92514
3218  
3219 + ROWID = 2
3220 + TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3221 + BLOBDATA = (blob), Length = 13
3222 + 0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3223  
3224   Testdata 2
3225  
3226   ROWID = 1
3227 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3227 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3228   BLOBDATA (Charset Id = 4 Codepage = 65001)
3229  
3230   Écoute moi
3231  
3232  
3233  
3234 + ------------------------------------------------------
3235   Running Test 16: Error handling
3236   Invalid Database Name Test
3237 < Error Handled:
2593 < I/O error during "open" operation for file "Malformed Name"
3237 > Error Handled: I/O error during "open" operation for file "Malformed Name"
3238   -Error while trying to open file
3239   -No such file or directory
3240   Invalid User Name Test
3241 < Error Handled:
2598 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3241 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3242   Invalid password Test
3243 < Error Handled:
2601 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3243 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3244   Invalid Prepare SQL Test
3245 < Error Handled:
2604 < Dynamic SQL Error
3245 > Error Handled: Dynamic SQL Error
3246   -SQL error code = -206
3247   -Column unknown
3248   -UNKNOWN_DATE
3249   -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3250   Invalid Open Cursor SQL Test
3251 < Error Handled:
2611 < Dynamic SQL Error
3251 > Error Handled: Dynamic SQL Error
3252   -SQL error code = -206
3253   -Column unknown
3254   -X
# Line 2619 | Line 3259 | Invalid Param SQL Type Test
3259   Error Handled: Field "EMP_NO" not found
3260   Case sensitive Param SQL  Test
3261   Error Handled: Field "EMP_NO" not found
3262 + Stale Reference Check
3263 + First test correct usage
3264 + COUNTER = 42
3265 +
3266 + New Transaction before param set
3267 + Error Handled: This interface is no longer up-to-date
3268 + New Transaction before Open Cursor
3269 + Error Handled: This interface is no longer up-to-date
3270 + Stop Stale Reference Checks
3271 + New Transaction before param set
3272 + COUNTER = 42
3273 +
3274 + New Transaction before Open Cursor
3275 + COUNTER = 42
3276 +
3277   Invalid Server Name Test
3278 < Error Handled:
2624 < Unable to complete network request to host "unknown".
3278 > Error Handled: Unable to complete network request to host "unknown".
3279   -Failed to locate host machine.
3280   -The specified name was not found in the hosts file or Domain Name Services
3281   Invalid User Name Test
3282 < Error Handled:
2629 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3282 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3283   Invalid password Test
3284 < Error Handled:
3285 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3284 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3285 >
3286 >
3287 > ------------------------------------------------------
3288 > Running Test 17: Date/Time tests and Firebird 4 extensions
3289 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3290 > Has Local TZ DB = FALSE
3291 >
3292 > Testdata
3293 >
3294 > Metadata
3295 > SQLType =SQL_LONG
3296 > sub type = 0
3297 > Table = TESTDATA
3298 > Owner = SYSDBA
3299 > Column Name = ROWID
3300 > Alias Name = ROWID
3301 > Field Name = ROWID
3302 > Scale = 0
3303 > Charset id = 0
3304 > Not Null
3305 > Size = 4
3306 >
3307 > SQLType =SQL_TYPE_DATE
3308 > sub type = 0
3309 > Table = TESTDATA
3310 > Owner = SYSDBA
3311 > Column Name = DATECOL
3312 > Alias Name = DATECOL
3313 > Field Name = DATECOL
3314 > Scale = 0
3315 > Charset id = 0
3316 > Nullable
3317 > Size = 4
3318 >
3319 > SQLType =SQL_TYPE_TIME
3320 > sub type = 0
3321 > Table = TESTDATA
3322 > Owner = SYSDBA
3323 > Column Name = TIMECOL
3324 > Alias Name = TIMECOL
3325 > Field Name = TIMECOL
3326 > Scale = 0
3327 > Charset id = 0
3328 > Nullable
3329 > Size = 4
3330 >
3331 > SQLType =SQL_TIMESTAMP
3332 > sub type = 0
3333 > Table = TESTDATA
3334 > Owner = SYSDBA
3335 > Column Name = TIMESTAMPCOL
3336 > Alias Name = TIMESTAMPCOL
3337 > Field Name = TIMESTAMPCOL
3338 > Scale = 0
3339 > Charset id = 0
3340 > Nullable
3341 > Size = 8
3342 >
3343 > ROWID = 1
3344 > DATECOL = 2019/04/01
3345 > TIMECOL = 11:31:05.0001
3346 > TIMESTAMPCOL = 2016/02/29 22:02:35.0001
3347 > ROWID = 2
3348 > DATECOL = 1939/09/03
3349 > TIMECOL = 15:40:00.0002
3350 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3351 > ROWID = 3
3352 > DATECOL = 1066/10/14
3353 > TIMECOL = 23:59:59.9994
3354 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3355 > ROWID = 4
3356 > DATECOL = 1815/06/18
3357 > TIMECOL = 00:01:40.1115
3358 > TIMESTAMPCOL = 1945/05/08 22:10:00.0010
3359 >
3360 >
3361 > Testdata - second pass
3362 >
3363 > 1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
3364 > 2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3365 > 3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
3366 > 4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
3367 > Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1
3368 > Skipping Firebird 4 and later test part
3369 >
3370 >
3371 > ------------------------------------------------------
3372 > Running Test 18: Firebird 4 Decfloat extensions
3373 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3374 > Skipping test for Firebird 4 and later
3375 >
3376 >
3377 > ------------------------------------------------------
3378 > Running Test 19: Batch Update and Insert Queries
3379 > Opening inet://localhost/employee
3380 > Skipping test for Firebird 4 and later
3381 >
3382 >
3383 > ------------------------------------------------------
3384 > Running Test 20: Stress Test IBatch interface
3385 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3386 > Skipping test for Firebird 4 and later
3387 >
3388 >
3389 > ------------------------------------------------------
3390 > Running Test 21: Exercise setting and getting of numeric data types
3391 > 1234.567 parsed to 1234567 scale = -3
3392 > As Float =  1.2345670000000000E+003
3393 > -765.4321 parsed to -7654321 scale = -4
3394 > As Float = -7.6543209999999999E+002
3395 > 0.1 parsed to 1 scale = -1
3396 > As Float =  1.0000000000000001E-001
3397 > 0.01 parsed to 1 scale = -2
3398 > As Float =  1.0000000000000000E-002
3399 > +123 parsed to 123 scale = 0
3400 > As Float =  1.2300000000000000E+002
3401 > 1.23456E308 parsed to 123456 scale = 303
3402 > As Float =  1.2345600000000001E+308
3403 > -1.2e-02 parsed to -12 scale = -3
3404 > As Float = -1.2000000000000000E-002
3405 > 10. parsed to 10 scale = 0
3406 > As Float =  1.0000000000000000E+001
3407 > .12 parsed to 12 scale = -2
3408 > As Float =  1.2000000000000000E-001
3409 > 0.12 parsed to 12 scale = -2
3410 > As Float =  1.2000000000000000E-001
3411 > Parsing of 1.2E1.2 failed
3412 > Parsing of 1,000 failed
3413 > Parsing of 1e1e1 failed
3414 > Parsing of 1.2+3 failed
3415 > SQL Params
3416 > SQLType =SQL_LONG
3417 > sub type = 0
3418 > Field Name =
3419 > Scale = 0
3420 > Charset id = 0
3421 > Not Null
3422 > Size = 4
3423 > Value = 0
3424 >
3425 > SQLType =SQL_LONG
3426 > sub type = 0
3427 > Field Name =
3428 > Scale = 0
3429 > Charset id = 0
3430 > Nullable
3431 > Size = 4
3432 >
3433 > SQLType =SQL_INT64
3434 > sub type = 0
3435 > Field Name =
3436 > Scale = 0
3437 > Charset id = 0
3438 > Nullable
3439 > Size = 8
3440 >
3441 > SQLType =SQL_INT64
3442 > sub type = 0
3443 > Field Name =
3444 > Scale = -4
3445 > Charset id = 0
3446 > Nullable
3447 > Size = 8
3448 >
3449 > SQLType =SQL_DOUBLE
3450 > sub type = 0
3451 > Field Name =
3452 > Scale = 0
3453 > Charset id = 0
3454 > Nullable
3455 > Size = 8
3456 >
3457 > SQLType =SQL_INT64
3458 > sub type = 0
3459 > Field Name =
3460 > Scale = -6
3461 > Charset id = 0
3462 > Nullable
3463 > Size = 8
3464 >
3465 > Expected Error - Dynamic SQL Error
3466 > -SQL error code = -303
3467 > -conversion error from string "1,000"
3468 > Expected Error - Dynamic SQL Error
3469 > -SQL error code = -303
3470 > -conversion error from string "10.0.0"
3471 > ROWID = 1
3472 > ITYPE = 101
3473 > I64TYPE = 9223372036854775807
3474 > CURRTYPE = 10,000.12340000
3475 > DTYPE = 9,999.12345678
3476 > FIXEDPOINT = 1,234,567,890.12345700
3477 > ROWID = 2
3478 > ITYPE = -32457
3479 > I64TYPE = -9223372036854775808
3480 > CURRTYPE = 1,000,001.12000000
3481 > DTYPE = 1.7E308
3482 > FIXEDPOINT = -1,234,567,890.12345700
3483 > ROWID = 3
3484 > ITYPE = 0
3485 > I64TYPE = 0
3486 > CURRTYPE = .00000000
3487 > DTYPE = .00000000
3488 > FIXEDPOINT = .00000000
3489 > ROWID = 4
3490 > ITYPE = 1
3491 > I64TYPE = 10
3492 > CURRTYPE = .02300000
3493 > DTYPE = .00110000
3494 > FIXEDPOINT = 233.45600000
3495 >
3496 >
3497 >
3498 > ------------------------------------------------------
3499 > Running Test 22: Journalling
3500 > Start Journaling. Session ID = 1
3501 > 1234.567 parsed to 1234567 scale = -3
3502 > As Float =  1.2345670000000000E+003
3503 > -765.4321 parsed to -7654321 scale = -4
3504 > As Float = -7.6543209999999999E+002
3505 > 0.1 parsed to 1 scale = -1
3506 > As Float =  1.0000000000000001E-001
3507 > 0.01 parsed to 1 scale = -2
3508 > As Float =  1.0000000000000000E-002
3509 > +123 parsed to 123 scale = 0
3510 > As Float =  1.2300000000000000E+002
3511 > 1.23456E308 parsed to 123456 scale = 303
3512 > As Float =  1.2345600000000001E+308
3513 > -1.2e-02 parsed to -12 scale = -3
3514 > As Float = -1.2000000000000000E-002
3515 > 10. parsed to 10 scale = 0
3516 > As Float =  1.0000000000000000E+001
3517 > .12 parsed to 12 scale = -2
3518 > As Float =  1.2000000000000000E-001
3519 > 0.12 parsed to 12 scale = -2
3520 > As Float =  1.2000000000000000E-001
3521 > Parsing of 1.2E1.2 failed
3522 > Parsing of 1,000 failed
3523 > Parsing of 1e1e1 failed
3524 > Parsing of 1.2+3 failed
3525 > SQL Params
3526 > SQLType =SQL_LONG
3527 > sub type = 0
3528 > Field Name =
3529 > Scale = 0
3530 > Charset id = 0
3531 > Not Null
3532 > Size = 4
3533 > Value = 0
3534 >
3535 > SQLType =SQL_LONG
3536 > sub type = 0
3537 > Field Name =
3538 > Scale = 0
3539 > Charset id = 0
3540 > Nullable
3541 > Size = 4
3542 >
3543 > SQLType =SQL_INT64
3544 > sub type = 0
3545 > Field Name =
3546 > Scale = 0
3547 > Charset id = 0
3548 > Nullable
3549 > Size = 8
3550 >
3551 > SQLType =SQL_INT64
3552 > sub type = 0
3553 > Field Name =
3554 > Scale = -4
3555 > Charset id = 0
3556 > Nullable
3557 > Size = 8
3558 >
3559 > SQLType =SQL_DOUBLE
3560 > sub type = 0
3561 > Field Name =
3562 > Scale = 0
3563 > Charset id = 0
3564 > Nullable
3565 > Size = 8
3566 >
3567 > SQLType =SQL_INT64
3568 > sub type = 0
3569 > Field Name =
3570 > Scale = -6
3571 > Charset id = 0
3572 > Nullable
3573 > Size = 8
3574 >
3575 >
3576 > Text Tests
3577 > SQL Params
3578 > SQLType =SQL_LONG
3579 > sub type = 0
3580 > Field Name =
3581 > Scale = 0
3582 > Charset id = 0
3583 > Not Null
3584 > Size = 4
3585 > Value = 0
3586 >
3587 > SQLType =SQL_VARYING
3588 > sub type = 0
3589 > Field Name =
3590 > Scale = 0
3591 > Charset id = 4
3592 > Nullable
3593 > Size = 1024
3594 >
3595 > SQLType =SQL_BLOB
3596 > sub type = 1
3597 > Field Name =
3598 > Scale = 0
3599 > Charset id = 4
3600 > Nullable
3601 > Size = 8
3602 >
3603 >
3604 > Binary Blob Tests
3605 >
3606 > Array Test
3607 > SQL Params
3608 > SQLType =SQL_LONG
3609 > sub type = 0
3610 > Field Name =
3611 > Scale = 0
3612 > Charset id = 0
3613 > Not Null
3614 > Size = 4
3615 > Value = 0
3616 >
3617 > SQLType =SQL_ARRAY
3618 > sub type = 0
3619 > Field Name =
3620 > Scale = 0
3621 > Charset id = 0
3622 > Nullable
3623 > Size = 8
3624 >
3625 > ROWID = 1
3626 > ITYPE = 101
3627 > I64TYPE = 9223372036854775807
3628 > CURRTYPE = 10,000.12340000
3629 > DTYPE = 9,999.12345678
3630 > FIXEDPOINT = 1,234,567,890.12345700
3631 > STR = NULL
3632 > TEXTBLOB = NULL
3633 > OTHERBLOB = NULL
3634 > MYARRAY = NULL
3635 > ROWID = 2
3636 > ITYPE = -32457
3637 > I64TYPE = -9223372036854775808
3638 > CURRTYPE = 1,000,001.12000000
3639 > DTYPE = 1.7E308
3640 > FIXEDPOINT = -1,234,567,890.12345700
3641 > STR = NULL
3642 > TEXTBLOB = NULL
3643 > OTHERBLOB = NULL
3644 > MYARRAY = NULL
3645 > ROWID = 4
3646 > ITYPE = 1
3647 > I64TYPE = 10
3648 > CURRTYPE = .02300000
3649 > DTYPE = .00110000
3650 > FIXEDPOINT = 233.45600000
3651 > STR = NULL
3652 > TEXTBLOB = NULL
3653 > OTHERBLOB = NULL
3654 > MYARRAY = NULL
3655 >
3656 > Journal Table
3657 > IBX$SESSIONID = 1
3658 > IBX$TRANSACTIONID = 9
3659 > IBX$OLDTRANSACTIONID = NULL
3660 > IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3661 > IBX$CREATED = 2021/12/07 09:58:40.6960
3662 > IBX$SESSIONID = 1
3663 > IBX$TRANSACTIONID = 11
3664 > IBX$OLDTRANSACTIONID = 10
3665 > IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3666 > IBX$CREATED = 2021/12/07 09:58:41.0190
3667 >
3668 > Journal Entries
3669 > Journal Entry = jeTransStart(Transaction Start)
3670 > Timestamp = 2021/12/07 09:58:40.7300
3671 > Session ID = 1
3672 > Transaction ID = 9
3673 > Transaction Name = "Transaction_29_1"
3674 > TPB: Item Count = 3
3675 >  isc_tpb_write
3676 >  isc_tpb_nowait
3677 >  isc_tpb_concurrency
3678 >
3679 > Default Completion = TACommit
3680 >
3681 > Journal Entry = jeQuery(Query)
3682 > Timestamp = 2021/12/07 09:58:40.7970
3683 > Session ID = 1
3684 > Transaction ID = 9
3685 > Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3686 >
3687 > Journal Entry = jeQuery(Query)
3688 > Timestamp = 2021/12/07 09:58:40.8130
3689 > Session ID = 1
3690 > Transaction ID = 9
3691 > Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3692 >
3693 > Journal Entry = jeTransCommitRet(Commit Retaining)
3694 > Timestamp = 2021/12/07 09:58:40.8900
3695 > Session ID = 1
3696 > Transaction ID = 10
3697 > Old TransactionID = 9
3698 >
3699 > Journal Entry = jeQuery(Query)
3700 > Timestamp = 2021/12/07 09:58:40.9150
3701 > Session ID = 1
3702 > Transaction ID = 10
3703 > Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3704 >
3705 > Journal Entry = jeTransRollbackRet(Rollback Retaining)
3706 > Timestamp = 2021/12/07 09:58:41.0150
3707 > Session ID = 1
3708 > Transaction ID = 11
3709 > Old TransactionID = 10
3710 >
3711 > Journal Entry = jeQuery(Query)
3712 > Timestamp = 2021/12/07 09:58:41.0390
3713 > Session ID = 1
3714 > Transaction ID = 11
3715 > Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3716 >
3717 > Journal Entry = jeTransStart(Transaction Start)
3718 > Timestamp = 2021/12/07 09:58:41.0610
3719 > Session ID = 1
3720 > Transaction ID = 12
3721 > Transaction Name = "Transaction_29_2"
3722 > TPB: Item Count = 3
3723 >  isc_tpb_write
3724 >  isc_tpb_nowait
3725 >  isc_tpb_concurrency
3726 >
3727 > Default Completion = TARollback
3728 >
3729 > Journal Entry = jeTransCommit(Commit)
3730 > Timestamp = 2021/12/07 09:58:41.1310
3731 > Session ID = 1
3732 > Transaction ID = 11
3733 >
3734 > Journal Entry = jeQuery(Query)
3735 > Timestamp = 2021/12/07 09:58:41.1910
3736 > Session ID = 1
3737 > Transaction ID = 12
3738 > Query = Insert into TestData(RowID, Str, TextBlob) Values(5,'It''s the quick brown fox jumps over the lazy dog','To be or not to be-that is the question:
3739 > Whether ''tis nobler in the mind to suffer
3740 > The slings and arrows of outrageous fortune,
3741 > Or to take arms against a sea of troubles,
3742 > And, by opposing, end them. To die, to sleep-
3743 > No more-and by a sleep to say we end
3744 > The heartache and the thousand natural shocks
3745 > That flesh is heir to-''tis a consummation
3746 > Devoutly to be wished. To die, to sleep-
3747 > To sleep, perchance to dream. Aye, there''s the rub,
3748 > For in that sleep of death what dreams may come,
3749 > When we have shuffled off this mortal coil,
3750 > Must give us pause. There''s the respect
3751 > That makes calamity of so long life.
3752 > For who would bear the whips and scorns of time,
3753 > Th'' oppressor''s wrong, the proud man''s contumely,
3754 > The pangs of despised love, the law’s delay,
3755 > The insolence of office, and the spurns
3756 > That patient merit of the unworthy takes,
3757 > When he himself might his quietus make
3758 > With a bare bodkin? Who would fardels bear,
3759 > To grunt and sweat under a weary life,
3760 > But that the dread of something after death,
3761 > The undiscovered country from whose bourn
3762 > No traveler returns, puzzles the will
3763 > And makes us rather bear those ills we have
3764 > Than fly to others that we know not of?
3765 > Thus conscience does make cowards of us all,
3766 > And thus the native hue of resolution
3767 > Is sicklied o''er with the pale cast of thought,
3768 > And enterprises of great pitch and moment,
3769 > With this regard their currents turn awry,
3770 > And lose the name of action.-Soft you now,
3771 > The fair Ophelia.-Nymph, in thy orisons
3772 > Be all my sins remembered
3773 > ')
3774 >
3775 > Journal Entry = jeQuery(Query)
3776 > Timestamp = 2021/12/07 09:58:41.2100
3777 > Session ID = 1
3778 > Transaction ID = 12
3779 > Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3780 > FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3781 > 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
3782 > 01000000010000001A01050001000000DA000000
3783 > </blob>
3784 > )
3785 >
3786 > Journal Entry = jeQuery(Query)
3787 > Timestamp = 2021/12/07 09:58:41.2330
3788 > Session ID = 1
3789 > Transaction ID = 12
3790 > Query = Insert into TestData(RowID,MyArray) Values (7,<array dim = "1" sqltype = "496" length = "4" relation_name = "TESTDATA" column_name = "MYARRAY" scale = "0" bounds="0:16">
3791 > <elt ix="0">100</elt>
3792 > <elt ix="1">99</elt>
3793 > <elt ix="2">98</elt>
3794 > <elt ix="3">97</elt>
3795 > <elt ix="4">96</elt>
3796 > <elt ix="5">95</elt>
3797 > <elt ix="6">94</elt>
3798 > <elt ix="7">93</elt>
3799 > <elt ix="8">92</elt>
3800 > <elt ix="9">91</elt>
3801 > <elt ix="10">90</elt>
3802 > <elt ix="11">89</elt>
3803 > <elt ix="12">88</elt>
3804 > <elt ix="13">87</elt>
3805 > <elt ix="14">86</elt>
3806 > <elt ix="15">85</elt>
3807 > <elt ix="16">84</elt>
3808 > </array>
3809 > )
3810 >
3811 > Journal Entry = jeTransRollback(Rollback)
3812 > Timestamp = 2021/12/07 09:58:41.3650
3813 > Session ID = 1
3814 > Transaction ID = 12
3815 >
3816  
3817  
3818 + ------------------------------------------------------
3819   Test Suite Ends

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines