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

Comparing:
ibx/trunk/fbintf/testsuite/FB2reference.log (file contents), Revision 333 by tony, Fri Feb 26 16:34:26 2021 UTC vs.
ibx/branches/journaling/fbintf/testsuite/FB2reference.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 = 2.5
6 + Firebird Environment Variable = /opt/firebird2.5.9
7 + Firebird Client Library Path = /opt/firebird2.5.9/lib/libfbembed.so
8   Running Test 1: Create and Drop a Database
9   Creating a Database with empty parameters
10 < Create Database fails (as expected):
11 < unavailable database
10 > Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
11 > -Error while trying to create file
12 > -No such file or directory
13   Creating a Database using an SQL Statement
14   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
15   SQL Dialect = 3
16 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
16 > DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
17   DB Charset ID = 0
18   DB SQL Dialect = 3
19   DB Remote Protocol = TCPv4
20   DB ODS Major Version = 11
21   DB ODS Minor Version = 2
22   User Authentication Method = Legacy_Auth
23 < Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
23 > Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so
24   DB Client Implementation Version = 2.5
25 < DPB
26 < Count = 3
27 < 28 = SYSDBA
28 < 29 = masterkey
29 < 65 = 3
25 > DPB: Item Count = 3
26 >  isc_dpb_user_name = SYSDBA
27 >  isc_dpb_password = masterkey
28 >  isc_dpb_set_db_sql_dialect = 3
29 >
30 > Firebird Server Version Info
31 > Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
32 > Firebird/linux AMD64 (remote server), version "LI-V2.5.9.27139 Firebird 2.5/tcp (zeus)/P12"
33 > Firebird/linux AMD64 (remote interface), version "LI-V2.5.9.27139 Firebird 2.5/tcp (zeus)/P12"
34 > on disk structure version 11.2
35  
36   Dropping Database
37   Creating a Database with a DPD
38 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
38 > DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
39   DB Charset ID = 4
40   DB SQL Dialect = 3
41   DB Remote Protocol = TCPv4
42   DB ODS Major Version = 11
43   DB ODS Minor Version = 2
44   User Authentication Method = Legacy_Auth
45 < Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
45 > Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so
46   DB Client Implementation Version = 2.5
47   Dropping Database
48 < DPB
49 < Count = 4
50 < 28 = SYSDBA
51 < 29 = masterkey
52 < 48 = UTF8
45 < 65 = 3
48 > DPB: Item Count = 4
49 >  isc_dpb_user_name = SYSDBA
50 >  isc_dpb_password = masterkey
51 >  isc_dpb_lc_ctype = UTF8
52 >  isc_dpb_set_db_sql_dialect = 3
53  
54   Creating a Database with a DPD
55   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
56   ODS major = 11
57   ODS minor = 2
58 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
58 > Attachment ID = 2
59 > DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
60   DB Charset ID = 4
61   DB SQL Dialect = 3
62   DB Remote Protocol = TCPv4
63   DB ODS Major Version = 11
64   DB ODS Minor Version = 2
65   User Authentication Method = Legacy_Auth
66 < Firebird Library Path = /opt/firebird2.5.9/lib/libfbclient.so
66 > Firebird Library Path = /opt/firebird2.5.9/lib/libfbembed.so
67   DB Client Implementation Version = 2.5
68   RDB$DESCRIPTION =
69   RDB$RELATION_ID = 128
# Line 64 | Line 72 | RDB$CHARACTER_SET_NAME = UTF8
72   Dropping Database
73  
74  
75 + ------------------------------------------------------
76   Running Test 2: Open the employee database and run a query
77 + Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
78   Opening localhost:employee
79   Database Open, SQL Dialect = 3
80 + TPB: Item Count = 3
81 +  isc_tpb_read
82 +  isc_tpb_nowait
83 +  isc_tpb_concurrency
84 +
85   Metadata
86   SQLType =SQL_SHORT
87   sub type = 0
# Line 209 | Line 224 | EMP_NO = 2
224   FIRST_NAME = Robert
225   LAST_NAME = Nelson
226   PHONE_EXT = 250
227 < HIRE_DATE = 28/12/1988 00:00:00.000
227 > HIRE_DATE = 1988/12/28 00:00:00.0000
228   DEPT_NO = 600
229   JOB_CODE = VP
230   JOB_GRADE = 2
# Line 220 | Line 235 | EMP_NO = 4
235   FIRST_NAME = Bruce
236   LAST_NAME = Young
237   PHONE_EXT = 233
238 < HIRE_DATE = 28/12/1988 00:00:00.000
238 > HIRE_DATE = 1988/12/28 00:00:00.0000
239   DEPT_NO = 621
240   JOB_CODE = Eng
241   JOB_GRADE = 2
# Line 231 | Line 246 | EMP_NO = 5
246   FIRST_NAME = Kim
247   LAST_NAME = Lambert
248   PHONE_EXT = 22
249 < HIRE_DATE = 6/2/1989 00:00:00.000
249 > HIRE_DATE = 1989/02/06 00:00:00.0000
250   DEPT_NO = 130
251   JOB_CODE = Eng
252   JOB_GRADE = 2
# Line 248 | Line 263 | Scale = 0
263   Charset id = 0
264   Not Null
265   Size = 2
266 + Value = 0
267  
268   EMP_NO = 8
269   FIRST_NAME = Leslie
270   LAST_NAME = Johnson
271   PHONE_EXT = 410
272 < HIRE_DATE = 5/4/1989 00:00:00.000
272 > HIRE_DATE = 1989/04/05 00:00:00.0000
273   DEPT_NO = 180
274   JOB_CODE = Mktg
275   JOB_GRADE = 3
# Line 271 | Line 287 | Scale = 0
287   Charset id = 0
288   Not Null
289   Size = 2
290 + Value = 0
291  
292 + Results for Cursor: Test Cursor
293   EMP_NO = 8
294   FIRST_NAME = Leslie
295   LAST_NAME = Johnson
296   PHONE_EXT = 410
297 < HIRE_DATE = 5/4/1989 00:00:00.000
297 > HIRE_DATE = 1989/04/05 00:00:00.0000
298   DEPT_NO = 180
299   JOB_CODE = Mktg
300   JOB_GRADE = 3
# Line 284 | Line 302 | JOB_COUNTRY = USA
302   SALARY = 64,635.00
303   FULL_NAME = Johnson, Leslie
304  
305 + Now open the employee database as a local database
306 + TPB: Item Count = 3
307 +  isc_tpb_read
308 +  isc_tpb_nowait
309 +  isc_tpb_concurrency
310  
311 + Metadata
312 + SQLType =SQL_SHORT
313 + sub type = 0
314 + Table = EMPLOYEE
315 + Owner = SYSDBA
316 + Column Name = EMP_NO
317 + Alias Name = EMP_NO
318 + Field Name = EMP_NO
319 + Scale = 0
320 + Charset id = 0
321 + Not Null
322 + Size = 2
323  
324 + SQLType =SQL_VARYING
325 + sub type = 0
326 + Table = EMPLOYEE
327 + Owner = SYSDBA
328 + Column Name = FIRST_NAME
329 + Alias Name = FIRST_NAME
330 + Field Name = FIRST_NAME
331 + Scale = 0
332 + Charset id = 0
333 + Not Null
334 + Size = 15
335 +
336 + SQLType =SQL_VARYING
337 + sub type = 0
338 + Table = EMPLOYEE
339 + Owner = SYSDBA
340 + Column Name = LAST_NAME
341 + Alias Name = LAST_NAME
342 + Field Name = LAST_NAME
343 + Scale = 0
344 + Charset id = 0
345 + Not Null
346 + Size = 20
347 +
348 + SQLType =SQL_VARYING
349 + sub type = 0
350 + Table = EMPLOYEE
351 + Owner = SYSDBA
352 + Column Name = PHONE_EXT
353 + Alias Name = PHONE_EXT
354 + Field Name = PHONE_EXT
355 + Scale = 0
356 + Charset id = 0
357 + Nullable
358 + Size = 4
359 +
360 + SQLType =SQL_TIMESTAMP
361 + sub type = 0
362 + Table = EMPLOYEE
363 + Owner = SYSDBA
364 + Column Name = HIRE_DATE
365 + Alias Name = HIRE_DATE
366 + Field Name = HIRE_DATE
367 + Scale = 0
368 + Charset id = 0
369 + Not Null
370 + Size = 8
371 +
372 + SQLType =SQL_TEXT
373 + sub type = 0
374 + Table = EMPLOYEE
375 + Owner = SYSDBA
376 + Column Name = DEPT_NO
377 + Alias Name = DEPT_NO
378 + Field Name = DEPT_NO
379 + Scale = 0
380 + Charset id = 0
381 + Not Null
382 + Size = 3
383 +
384 + SQLType =SQL_VARYING
385 + sub type = 0
386 + Table = EMPLOYEE
387 + Owner = SYSDBA
388 + Column Name = JOB_CODE
389 + Alias Name = JOB_CODE
390 + Field Name = JOB_CODE
391 + Scale = 0
392 + Charset id = 0
393 + Not Null
394 + Size = 5
395 +
396 + SQLType =SQL_SHORT
397 + sub type = 0
398 + Table = EMPLOYEE
399 + Owner = SYSDBA
400 + Column Name = JOB_GRADE
401 + Alias Name = JOB_GRADE
402 + Field Name = JOB_GRADE
403 + Scale = 0
404 + Charset id = 0
405 + Not Null
406 + Size = 2
407 +
408 + SQLType =SQL_VARYING
409 + sub type = 0
410 + Table = EMPLOYEE
411 + Owner = SYSDBA
412 + Column Name = JOB_COUNTRY
413 + Alias Name = JOB_COUNTRY
414 + Field Name = JOB_COUNTRY
415 + Scale = 0
416 + Charset id = 0
417 + Not Null
418 + Size = 15
419 +
420 + SQLType =SQL_INT64
421 + sub type = 0
422 + Table = EMPLOYEE
423 + Owner = SYSDBA
424 + Column Name = SALARY
425 + Alias Name = SALARY
426 + Field Name = SALARY
427 + Scale = -2
428 + Charset id = 0
429 + Not Null
430 + Size = 8
431 +
432 + SQLType =SQL_VARYING
433 + sub type = 0
434 + Table = EMPLOYEE
435 + Owner = SYSDBA
436 + Column Name = FULL_NAME
437 + Alias Name = FULL_NAME
438 + Field Name = FULL_NAME
439 + Scale = 0
440 + Charset id = 0
441 + Nullable
442 + Size = 37
443 +
444 + Plan =
445 + PLAN (EMPLOYEE NATURAL)
446 + -- SQL style inline comment
447 + /* this is a comment */ Select First 3 * from EMPLOYEE
448 +
449 + EMP_NO = 2
450 + FIRST_NAME = Robert
451 + LAST_NAME = Nelson
452 + PHONE_EXT = 250
453 + HIRE_DATE = 1988/12/28 00:00:00.0000
454 + DEPT_NO = 600
455 + JOB_CODE = VP
456 + JOB_GRADE = 2
457 + JOB_COUNTRY = USA
458 + SALARY = 105,900.00
459 + FULL_NAME = Nelson, Robert
460 + EMP_NO = 4
461 + FIRST_NAME = Bruce
462 + LAST_NAME = Young
463 + PHONE_EXT = 233
464 + HIRE_DATE = 1988/12/28 00:00:00.0000
465 + DEPT_NO = 621
466 + JOB_CODE = Eng
467 + JOB_GRADE = 2
468 + JOB_COUNTRY = USA
469 + SALARY = 97,500.00
470 + FULL_NAME = Young, Bruce
471 + EMP_NO = 5
472 + FIRST_NAME = Kim
473 + LAST_NAME = Lambert
474 + PHONE_EXT = 22
475 + HIRE_DATE = 1989/02/06 00:00:00.0000
476 + DEPT_NO = 130
477 + JOB_CODE = Eng
478 + JOB_GRADE = 2
479 + JOB_COUNTRY = USA
480 + SALARY = 102,750.00
481 + FULL_NAME = Lambert, Kim
482 +
483 + Select * from EMPLOYEE Where EMP_NO = ?
484 + SQL Params
485 + SQLType =SQL_SHORT
486 + sub type = 0
487 + Field Name =
488 + Scale = 0
489 + Charset id = 0
490 + Not Null
491 + Size = 2
492 + Value = 0
493 +
494 + EMP_NO = 8
495 + FIRST_NAME = Leslie
496 + LAST_NAME = Johnson
497 + PHONE_EXT = 410
498 + HIRE_DATE = 1989/04/05 00:00:00.0000
499 + DEPT_NO = 180
500 + JOB_CODE = Mktg
501 + JOB_GRADE = 3
502 + JOB_COUNTRY = USA
503 + SALARY = 64,635.00
504 + FULL_NAME = Johnson, Leslie
505 +
506 + With param names
507 + Select * from EMPLOYEE Where EMP_NO = :EMP_NO
508 + SQL Params
509 + SQLType =SQL_SHORT
510 + sub type = 0
511 + Field Name = EMP_NO
512 + Scale = 0
513 + Charset id = 0
514 + Not Null
515 + Size = 2
516 + Value = 0
517 +
518 + Results for Cursor: Test Cursor
519 + EMP_NO = 8
520 + FIRST_NAME = Leslie
521 + LAST_NAME = Johnson
522 + PHONE_EXT = 410
523 + HIRE_DATE = 1989/04/05 00:00:00.0000
524 + DEPT_NO = 180
525 + JOB_CODE = Mktg
526 + JOB_GRADE = 3
527 + JOB_COUNTRY = USA
528 + SALARY = 64,635.00
529 + FULL_NAME = Johnson, Leslie
530 +
531 +
532 +
533 + ------------------------------------------------------
534   Running Test 3: ad hoc queries
535   Opening localhost:employee
536   Database Open
537   Employee Count = 42
538 + Transaction ID = 5277
539 + Transaction is Read/Write
540 + Transaction ID = 5277
541 + Oldest Interesting = 5275
542 + Oldest Action = 5276
543 + Oldest Snapshot = 5276
544 + Oldest Interesting = 0
545   Employee Count = 41
546   Employee Count = 42
547   Employee Count = 41
# Line 299 | Line 551 | Constrained Employee Count = 3
551   "Yanowski" Employee Count = 1
552  
553  
554 + ------------------------------------------------------
555   Running Test 4: Update, Insert and Delete Queries
556   Opening localhost:employee
557   Database Open
# Line 311 | Line 564 | EMP_NO = 8
564   FIRST_NAME = Leslie
565   LAST_NAME = Johnson
566   PHONE_EXT = 410
567 < HIRE_DATE = 5/4/1989 00:00:00.000
567 > HIRE_DATE = 1989/04/05 00:00:00.0000
568   DEPT_NO = 180
569   JOB_CODE = Mktg
570   JOB_GRADE = 3
# Line 319 | Line 572 | JOB_COUNTRY = USA
572   SALARY = 64,635.00
573   FULL_NAME = Johnson, Leslie
574  
575 < Current memory = 948664
576 < Delta memory = 1400
577 < Max memory = 992600
575 > Current memory = 948,496
576 > Delta memory = 1,288
577 > Max memory = 992,448
578   Elapsed time= 0.002 sec
579   Cpu = 0.000 sec
580   Buffers = 75
# Line 467 | Line 720 | EMP_NO = 150
720   FIRST_NAME = John
721   LAST_NAME = Doe
722   PHONE_EXT =
723 < HIRE_DATE = 1/4/2015 00:00:00.000
723 > HIRE_DATE = 2015/04/01 00:00:00.0000
724   DEPT_NO = 600
725   JOB_CODE = Eng
726   JOB_GRADE = 4
# Line 480 | Line 733 | EMP_NO = 151
733   FIRST_NAME = Major
734   LAST_NAME = Major
735   PHONE_EXT =
736 < HIRE_DATE = 1/4/2015 00:00:00.000
736 > HIRE_DATE = 2015/04/01 00:00:00.0000
737   DEPT_NO = 600
738   JOB_CODE = Eng
739   JOB_GRADE = 4
# Line 497 | Line 750 | EMP_NO = 150
750   FIRST_NAME = Jane
751   LAST_NAME = Doe
752   PHONE_EXT = NULL
753 < HIRE_DATE = 1/4/2015 00:00:00.000
753 > HIRE_DATE = 2015/04/01 00:00:00.0000
754   DEPT_NO = 600
755   JOB_CODE = Eng
756   JOB_GRADE = 4
# Line 514 | Line 767 | EMP_NO = 150
767   FIRST_NAME = Jayne's
768   LAST_NAME = Doe
769   PHONE_EXT = NULL
770 < HIRE_DATE = 1/4/2015 00:00:00.000
770 > HIRE_DATE = 2015/04/01 00:00:00.0000
771   DEPT_NO = 600
772   JOB_CODE = Eng
773   JOB_GRADE = 4
# Line 528 | Line 781 | EMP_NO = 8
781   FIRST_NAME = Leslie
782   LAST_NAME = Johnson
783   PHONE_EXT = 410
784 < HIRE_DATE = 5/4/1989 00:00:00.000
784 > HIRE_DATE = 1989/04/05 00:00:00.0000
785   DEPT_NO = 180
786   JOB_CODE = Mktg
787   JOB_GRADE = 3
# Line 542 | Line 795 | EMP_NO = 8
795   FIRST_NAME = Leslie
796   LAST_NAME = Johnson
797   PHONE_EXT = 410
798 < HIRE_DATE = 5/4/1989 00:00:00.000
798 > HIRE_DATE = 1989/04/05 00:00:00.0000
799   DEPT_NO = 180
800   JOB_CODE = Mktg
801   JOB_GRADE = 3
# Line 554 | Line 807 | EMP_NO = 9
807   FIRST_NAME = Phil
808   LAST_NAME = Forest
809   PHONE_EXT = 229
810 < HIRE_DATE = 17/4/1989 00:00:00.000
810 > HIRE_DATE = 1989/04/17 00:00:00.0000
811   DEPT_NO = 622
812   JOB_CODE = Mngr
813   JOB_GRADE = 3
# Line 568 | Line 821 | EMP_NO = 8
821   FIRST_NAME = Leslie
822   LAST_NAME = Johnson
823   PHONE_EXT = 410
824 < HIRE_DATE = 31/1/2015 00:00:00.000
824 > HIRE_DATE = 2015/01/31 00:00:00.0000
825   DEPT_NO = 180
826   JOB_CODE = Mktg
827   JOB_GRADE = 3
# Line 578 | Line 831 | FULL_NAME = Johnson, Leslie
831  
832  
833  
834 + ------------------------------------------------------
835   Running Test 5: Update Returning and Activity Check
836   Opening localhost:employee
837   Database Open
# Line 589 | Line 843 | EMP_NO = 8
843   FIRST_NAME = Leslie
844   LAST_NAME = Johnson
845   PHONE_EXT = 410
846 < HIRE_DATE = 31/1/2016 00:00:00.000
846 > HIRE_DATE = 2016/01/31 00:00:00.0000
847   DEPT_NO = 180
848   JOB_CODE = Mktg
849   JOB_GRADE = 3
# Line 611 | Line 865 | Transaction Active
865   Transaction inactive
866  
867  
868 + ------------------------------------------------------
869   Running Test 6: Blob Handling
870   Metadata
871   SQLType =SQL_TEXT
# Line 637 | Line 892 | Charset id = 0
892   Nullable
893   Size = 2
894  
895 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31)
895 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
896   RDB$CHARACTER_SET_ID = 0
897 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
897 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
898   RDB$CHARACTER_SET_ID = 1
899 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31)
899 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
900   RDB$CHARACTER_SET_ID = 2
901 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
901 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
902   RDB$CHARACTER_SET_ID = 3
903 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
903 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
904   RDB$CHARACTER_SET_ID = 4
905 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
905 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
906   RDB$CHARACTER_SET_ID = 5
907 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
907 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
908   RDB$CHARACTER_SET_ID = 6
909 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
909 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
910   RDB$CHARACTER_SET_ID = 9
911 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
911 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
912   RDB$CHARACTER_SET_ID = 10
913 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
913 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
914   RDB$CHARACTER_SET_ID = 11
915 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
915 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
916   RDB$CHARACTER_SET_ID = 12
917 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
917 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
918   RDB$CHARACTER_SET_ID = 13
919 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
919 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
920   RDB$CHARACTER_SET_ID = 14
921 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
921 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
922   RDB$CHARACTER_SET_ID = 15
923 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
923 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
924   RDB$CHARACTER_SET_ID = 16
925 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
925 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
926   RDB$CHARACTER_SET_ID = 17
927 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
927 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
928   RDB$CHARACTER_SET_ID = 18
929 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31)
929 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
930   RDB$CHARACTER_SET_ID = 19
931 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
931 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
932   RDB$CHARACTER_SET_ID = 21
933 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
933 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
934   RDB$CHARACTER_SET_ID = 22
935 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
935 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
936   RDB$CHARACTER_SET_ID = 23
937 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
937 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
938   RDB$CHARACTER_SET_ID = 34
939 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
939 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
940   RDB$CHARACTER_SET_ID = 35
941 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
941 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
942   RDB$CHARACTER_SET_ID = 36
943 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
943 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
944   RDB$CHARACTER_SET_ID = 37
945 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
945 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
946   RDB$CHARACTER_SET_ID = 38
947 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
947 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
948   RDB$CHARACTER_SET_ID = 39
949 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
949 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
950   RDB$CHARACTER_SET_ID = 40
951 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
951 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
952   RDB$CHARACTER_SET_ID = 44
953 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
953 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
954   RDB$CHARACTER_SET_ID = 45
955 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
955 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
956   RDB$CHARACTER_SET_ID = 46
957 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
957 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
958   RDB$CHARACTER_SET_ID = 47
959 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
959 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
960   RDB$CHARACTER_SET_ID = 48
961 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
961 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
962   RDB$CHARACTER_SET_ID = 49
963 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31)
963 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
964   RDB$CHARACTER_SET_ID = 50
965 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
965 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
966   RDB$CHARACTER_SET_ID = 51
967 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
967 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
968   RDB$CHARACTER_SET_ID = 52
969 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
969 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
970   RDB$CHARACTER_SET_ID = 53
971 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
971 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
972   RDB$CHARACTER_SET_ID = 54
973 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
973 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
974   RDB$CHARACTER_SET_ID = 55
975 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
975 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
976   RDB$CHARACTER_SET_ID = 56
977 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
977 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
978   RDB$CHARACTER_SET_ID = 57
979 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
979 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
980   RDB$CHARACTER_SET_ID = 58
981 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
981 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
982   RDB$CHARACTER_SET_ID = 59
983 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
983 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
984   RDB$CHARACTER_SET_ID = 60
985 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31)
985 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
986   RDB$CHARACTER_SET_ID = 63
987 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31)
987 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
988   RDB$CHARACTER_SET_ID = 64
989 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
989 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
990   RDB$CHARACTER_SET_ID = 65
991 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
991 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
992   RDB$CHARACTER_SET_ID = 66
993 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31)
993 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
994   RDB$CHARACTER_SET_ID = 67
995 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31)
995 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
996   RDB$CHARACTER_SET_ID = 68
997 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
997 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
998   RDB$CHARACTER_SET_ID = 69
999  
1000   Metadata
# Line 819 | Line 1074 | Scale = 0
1074   Charset id = 0
1075   Not Null
1076   Size = 4
1077 + Value = 0
1078  
1079   SQLType =SQL_VARYING
1080   sub type = 0
# Line 847 | Line 1103 | Size = 8
1103   ROWID = 1
1104   FIXEDPOINT = 20.28
1105   FLOATINGPOINT = 3.14
1106 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1106 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1107   BLOBDATA = NULL
1108  
1109   SQL Params
# Line 866 | Line 1122 | Scale = 0
1122   Charset id = 0
1123   Not Null
1124   Size = 4
1125 + Value = 0
1126  
1127   ROWID = 1
1128   FIXEDPOINT = 20.28
1129   FLOATINGPOINT = 3.14
1130 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1130 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1131   BLOBDATA (Charset Id = 4 Codepage = 65001)
1132  
1133   To be or not to be-that is the question:
# Line 918 | Line 1175 | Scale = 0
1175   Charset id = 0
1176   Not Null
1177   Size = 4
1178 + Value = 0
1179  
1180   SQLType =SQL_VARYING
1181   sub type = 0
# Line 946 | Line 1204 | Size = 8
1204   ROWID = 1
1205   FIXEDPOINT = 20.28
1206   FLOATINGPOINT = 3.14
1207 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1207 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1208   BLOBDATA (Charset Id = 4 Codepage = 65001)
1209  
1210   To be or not to be-that is the question:
# Line 988 | Line 1246 | Be all my sins remembered
1246   ROWID = 2
1247   FIXEDPOINT = NULL
1248   FLOATINGPOINT = NULL
1249 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1249 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1250   BLOBDATA (Charset Id = 4 Codepage = 65001)
1251  
1252   To be or not to be-that is the question:
# Line 1113 | Line 1371 | Charset id = 0
1371   Nullable
1372   Size = 2
1373  
1374 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1374 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1375   RDB$CHARACTER_SET_ID = 0
1376 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1376 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1377   RDB$CHARACTER_SET_ID = 1
1378 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1378 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1379   RDB$CHARACTER_SET_ID = 2
1380 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1380 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1381   RDB$CHARACTER_SET_ID = 3
1382 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1382 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1383   RDB$CHARACTER_SET_ID = 4
1384 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1384 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1385   RDB$CHARACTER_SET_ID = 5
1386 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1386 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1387   RDB$CHARACTER_SET_ID = 6
1388 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1388 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1389   RDB$CHARACTER_SET_ID = 9
1390 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1390 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1391   RDB$CHARACTER_SET_ID = 10
1392 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1392 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1393   RDB$CHARACTER_SET_ID = 11
1394 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1394 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1395   RDB$CHARACTER_SET_ID = 12
1396 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1396 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1397   RDB$CHARACTER_SET_ID = 13
1398 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1398 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1399   RDB$CHARACTER_SET_ID = 14
1400 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1400 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1401   RDB$CHARACTER_SET_ID = 15
1402 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1402 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1403   RDB$CHARACTER_SET_ID = 16
1404 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1404 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1405   RDB$CHARACTER_SET_ID = 17
1406 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1406 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1407   RDB$CHARACTER_SET_ID = 18
1408 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1408 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1409   RDB$CHARACTER_SET_ID = 19
1410 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1410 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1411   RDB$CHARACTER_SET_ID = 21
1412 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1412 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1413   RDB$CHARACTER_SET_ID = 22
1414 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1414 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1415   RDB$CHARACTER_SET_ID = 23
1416 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1416 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1417   RDB$CHARACTER_SET_ID = 34
1418 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1418 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1419   RDB$CHARACTER_SET_ID = 35
1420 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1420 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1421   RDB$CHARACTER_SET_ID = 36
1422 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1422 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1423   RDB$CHARACTER_SET_ID = 37
1424 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1424 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1425   RDB$CHARACTER_SET_ID = 38
1426 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1426 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1427   RDB$CHARACTER_SET_ID = 39
1428 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1428 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1429   RDB$CHARACTER_SET_ID = 40
1430 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1430 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1431   RDB$CHARACTER_SET_ID = 44
1432 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1432 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1433   RDB$CHARACTER_SET_ID = 45
1434 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1434 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1435   RDB$CHARACTER_SET_ID = 46
1436 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1436 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1437   RDB$CHARACTER_SET_ID = 47
1438 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1438 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1439   RDB$CHARACTER_SET_ID = 48
1440 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1440 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1441   RDB$CHARACTER_SET_ID = 49
1442 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1442 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1443   RDB$CHARACTER_SET_ID = 50
1444 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1444 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1445   RDB$CHARACTER_SET_ID = 51
1446 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1446 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1447   RDB$CHARACTER_SET_ID = 52
1448 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1448 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1449   RDB$CHARACTER_SET_ID = 53
1450 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1450 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1451   RDB$CHARACTER_SET_ID = 54
1452 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1452 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1453   RDB$CHARACTER_SET_ID = 55
1454 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1454 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1455   RDB$CHARACTER_SET_ID = 56
1456 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1456 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1457   RDB$CHARACTER_SET_ID = 57
1458 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1458 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1459   RDB$CHARACTER_SET_ID = 58
1460 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1460 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1461   RDB$CHARACTER_SET_ID = 59
1462 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1462 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1463   RDB$CHARACTER_SET_ID = 60
1464 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1464 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1465   RDB$CHARACTER_SET_ID = 63
1466 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1466 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1467   RDB$CHARACTER_SET_ID = 64
1468 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1468 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1469   RDB$CHARACTER_SET_ID = 65
1470 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1470 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1471   RDB$CHARACTER_SET_ID = 66
1472 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1472 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1473   RDB$CHARACTER_SET_ID = 67
1474 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1474 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1475   RDB$CHARACTER_SET_ID = 68
1476 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1476 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1477   RDB$CHARACTER_SET_ID = 69
1478  
1479   Metadata
# Line 1295 | Line 1553 | Scale = 0
1553   Charset id = 0
1554   Not Null
1555   Size = 4
1556 + Value = 0
1557  
1558   SQLType =SQL_VARYING
1559   sub type = 0
# Line 1323 | Line 1582 | Size = 8
1582   ROWID = 1
1583   FIXEDPOINT = 20.28
1584   FLOATINGPOINT = 3.14
1585 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1585 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1586   BLOBDATA = NULL
1587  
1588   SQL Params
# Line 1342 | Line 1601 | Scale = 0
1601   Charset id = 0
1602   Not Null
1603   Size = 4
1604 + Value = 0
1605  
1606   ROWID = 1
1607   FIXEDPOINT = 20.28
1608   FLOATINGPOINT = 3.14
1609 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1609 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1610   BLOBDATA (Charset Id = 53 Codepage = 1252)
1611  
1612   To be or not to be-that is the question:
# Line 1394 | Line 1654 | Scale = 0
1654   Charset id = 0
1655   Not Null
1656   Size = 4
1657 + Value = 0
1658  
1659   SQLType =SQL_VARYING
1660   sub type = 0
# Line 1422 | Line 1683 | Size = 8
1683   ROWID = 1
1684   FIXEDPOINT = 20.28
1685   FLOATINGPOINT = 3.14
1686 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1686 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1687   BLOBDATA (Charset Id = 53 Codepage = 1252)
1688  
1689   To be or not to be-that is the question:
# Line 1464 | Line 1725 | Be all my sins remembered
1725   ROWID = 2
1726   FIXEDPOINT = NULL
1727   FLOATINGPOINT = NULL
1728 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1728 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1729   BLOBDATA (Charset Id = 53 Codepage = 1252)
1730  
1731   To be or not to be-that is the question:
# Line 1589 | Line 1850 | Charset id = 0
1850   Nullable
1851   Size = 2
1852  
1853 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1853 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1854   RDB$CHARACTER_SET_ID = 0
1855 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1855 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1856   RDB$CHARACTER_SET_ID = 1
1857 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1857 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1858   RDB$CHARACTER_SET_ID = 2
1859 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1859 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1860   RDB$CHARACTER_SET_ID = 3
1861 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1861 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1862   RDB$CHARACTER_SET_ID = 4
1863 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1863 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1864   RDB$CHARACTER_SET_ID = 5
1865 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1865 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1866   RDB$CHARACTER_SET_ID = 6
1867 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1867 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1868   RDB$CHARACTER_SET_ID = 9
1869 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1869 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1870   RDB$CHARACTER_SET_ID = 10
1871 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1871 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1872   RDB$CHARACTER_SET_ID = 11
1873 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1873 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1874   RDB$CHARACTER_SET_ID = 12
1875 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1875 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1876   RDB$CHARACTER_SET_ID = 13
1877 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1877 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1878   RDB$CHARACTER_SET_ID = 14
1879 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1879 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1880   RDB$CHARACTER_SET_ID = 15
1881 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1881 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1882   RDB$CHARACTER_SET_ID = 16
1883 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1883 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
1884   RDB$CHARACTER_SET_ID = 17
1885 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1885 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
1886   RDB$CHARACTER_SET_ID = 18
1887 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1887 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
1888   RDB$CHARACTER_SET_ID = 19
1889 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1889 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
1890   RDB$CHARACTER_SET_ID = 21
1891 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1891 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
1892   RDB$CHARACTER_SET_ID = 22
1893 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1893 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
1894   RDB$CHARACTER_SET_ID = 23
1895 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1895 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
1896   RDB$CHARACTER_SET_ID = 34
1897 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1897 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
1898   RDB$CHARACTER_SET_ID = 35
1899 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1899 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
1900   RDB$CHARACTER_SET_ID = 36
1901 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1901 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
1902   RDB$CHARACTER_SET_ID = 37
1903 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1903 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
1904   RDB$CHARACTER_SET_ID = 38
1905 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1905 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
1906   RDB$CHARACTER_SET_ID = 39
1907 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1907 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
1908   RDB$CHARACTER_SET_ID = 40
1909 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1909 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
1910   RDB$CHARACTER_SET_ID = 44
1911 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1911 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
1912   RDB$CHARACTER_SET_ID = 45
1913 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1913 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
1914   RDB$CHARACTER_SET_ID = 46
1915 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1915 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
1916   RDB$CHARACTER_SET_ID = 47
1917 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1917 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
1918   RDB$CHARACTER_SET_ID = 48
1919 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1919 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
1920   RDB$CHARACTER_SET_ID = 49
1921 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1921 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
1922   RDB$CHARACTER_SET_ID = 50
1923 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1923 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
1924   RDB$CHARACTER_SET_ID = 51
1925 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1925 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
1926   RDB$CHARACTER_SET_ID = 52
1927 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1927 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
1928   RDB$CHARACTER_SET_ID = 53
1929 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1929 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
1930   RDB$CHARACTER_SET_ID = 54
1931 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1931 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
1932   RDB$CHARACTER_SET_ID = 55
1933 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1933 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
1934   RDB$CHARACTER_SET_ID = 56
1935 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1935 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
1936   RDB$CHARACTER_SET_ID = 57
1937 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1937 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
1938   RDB$CHARACTER_SET_ID = 58
1939 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1939 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
1940   RDB$CHARACTER_SET_ID = 59
1941 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1941 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
1942   RDB$CHARACTER_SET_ID = 60
1943 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1943 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
1944   RDB$CHARACTER_SET_ID = 63
1945 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1945 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
1946   RDB$CHARACTER_SET_ID = 64
1947 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1947 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
1948   RDB$CHARACTER_SET_ID = 65
1949 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1949 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
1950   RDB$CHARACTER_SET_ID = 66
1951 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1951 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
1952   RDB$CHARACTER_SET_ID = 67
1953 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1953 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
1954   RDB$CHARACTER_SET_ID = 68
1955 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1955 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
1956   RDB$CHARACTER_SET_ID = 69
1957  
1958   Metadata
# Line 1771 | Line 2032 | Scale = 0
2032   Charset id = 0
2033   Not Null
2034   Size = 4
2035 + Value = 0
2036  
2037   SQLType =SQL_VARYING
2038   sub type = 0
# Line 1799 | Line 2061 | Size = 8
2061   ROWID = 1
2062   FIXEDPOINT = 20.28
2063   FLOATINGPOINT = 3.14
2064 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2064 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2065   BLOBDATA = NULL
2066  
2067   SQL Params
# Line 1818 | Line 2080 | Scale = 0
2080   Charset id = 0
2081   Not Null
2082   Size = 4
2083 + Value = 0
2084  
2085   ROWID = 1
2086   FIXEDPOINT = 20.28
2087   FLOATINGPOINT = 3.14
2088 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2088 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2089   BLOBDATA (Charset Id = 4 Codepage = 65001)
2090  
2091   To be or not to be-that is the question:
# Line 1870 | Line 2133 | Scale = 0
2133   Charset id = 0
2134   Not Null
2135   Size = 4
2136 + Value = 0
2137  
2138   SQLType =SQL_VARYING
2139   sub type = 0
# Line 1898 | Line 2162 | Size = 8
2162   ROWID = 1
2163   FIXEDPOINT = 20.28
2164   FLOATINGPOINT = 3.14
2165 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2165 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2166   BLOBDATA (Charset Id = 4 Codepage = 65001)
2167  
2168   To be or not to be-that is the question:
# Line 1940 | Line 2204 | Be all my sins remembered
2204   ROWID = 2
2205   FIXEDPOINT = NULL
2206   FLOATINGPOINT = NULL
2207 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2207 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2208   BLOBDATA (Charset Id = 4 Codepage = 65001)
2209  
2210   To be or not to be-that is the question:
# Line 2042 | Line 2306 | Be all my sins remembered
2306  
2307  
2308  
2309 + ------------------------------------------------------
2310   Running Test 7: Create and read back an Array
2311   Metadata
2312   SQLType =SQL_LONG
# Line 2113 | Line 2378 | Column = MYARRAY
2378   Dimensions = 1
2379   Bounds: (0:16)
2380  
2381 + SQLType =SQL_ARRAY
2382 + sub type = 0
2383 + Table = TESTDATA
2384 + Owner = SYSDBA
2385 + Column Name = MYARRAY2
2386 + Alias Name = MYARRAY2
2387 + Field Name = MYARRAY2
2388 + Scale = 0
2389 + Charset id = 0
2390 + Nullable
2391 + Size = 8
2392 + Array Meta Data:
2393 + SQLType =SQL_TIMESTAMP
2394 + Scale = 0
2395 + Charset id = 0
2396 + Size = 8
2397 + Table = TESTDATA
2398 + Column = MYARRAY2
2399 + Dimensions = 1
2400 + Bounds: (0:16)
2401 +
2402 + SQLType =SQL_ARRAY
2403 + sub type = 0
2404 + Table = TESTDATA
2405 + Owner = SYSDBA
2406 + Column Name = MYARRAY3
2407 + Alias Name = MYARRAY3
2408 + Field Name = MYARRAY3
2409 + Scale = 0
2410 + Charset id = 0
2411 + Nullable
2412 + Size = 8
2413 + Array Meta Data:
2414 + SQLType =SQL_INT64
2415 + Scale = -2
2416 + Charset id = 0
2417 + Size = 8
2418 + Table = TESTDATA
2419 + Column = MYARRAY3
2420 + Dimensions = 1
2421 + Bounds: (0:16)
2422 +
2423   SQL Params
2424   SQLType =SQL_LONG
2425   sub type = 0
# Line 2121 | Line 2428 | Scale = 0
2428   Charset id = 0
2429   Not Null
2430   Size = 4
2431 + Value = 0
2432  
2433   SQLType =SQL_VARYING
2434   sub type = 0
# Line 2151 | Line 2459 | Param Name = TITLE
2459   Param Name = DATED
2460   Param Name = NOTES
2461   ROWID = 1
2462 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2463 < DATED = 1/4/2016 09:30:00.100
2464 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2462 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2463 > DATED = 2016/04/01 09:30:00.1000
2464 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2465   MYARRAY = NULL
2466 + MYARRAY2 = NULL
2467 + MYARRAY3 = NULL
2468  
2469   SQL Params
2470   SQLType =SQL_ARRAY
# Line 2165 | Line 2475 | Charset id = 0
2475   Nullable
2476   Size = 8
2477  
2478 + SQL Params
2479 + SQLType =SQL_ARRAY
2480 + sub type = 0
2481 + Field Name = MYARRAY2
2482 + Scale = 0
2483 + Charset id = 0
2484 + Nullable
2485 + Size = 8
2486 +
2487 + SQL Params
2488 + SQLType =SQL_ARRAY
2489 + sub type = 0
2490 + Field Name = MYARRAY3
2491 + Scale = 0
2492 + Charset id = 0
2493 + Nullable
2494 + Size = 8
2495 +
2496 + Metadata
2497 + SQLType =SQL_LONG
2498 + sub type = 0
2499 + Table = TESTDATA
2500 + Owner = SYSDBA
2501 + Column Name = ROWID
2502 + Alias Name = ROWID
2503 + Field Name = ROWID
2504 + Scale = 0
2505 + Charset id = 0
2506 + Not Null
2507 + Size = 4
2508 +
2509 + SQLType =SQL_VARYING
2510 + sub type = 0
2511 + Table = TESTDATA
2512 + Owner = SYSDBA
2513 + Column Name = TITLE
2514 + Alias Name = TITLE
2515 + Field Name = TITLE
2516 + Scale = 0
2517 + Charset id = 4
2518 + Nullable
2519 + Size = 128
2520 +
2521 + SQLType =SQL_TIMESTAMP
2522 + sub type = 0
2523 + Table = TESTDATA
2524 + Owner = SYSDBA
2525 + Column Name = DATED
2526 + Alias Name = DATED
2527 + Field Name = DATED
2528 + Scale = 0
2529 + Charset id = 0
2530 + Nullable
2531 + Size = 8
2532 +
2533 + SQLType =SQL_VARYING
2534 + sub type = 0
2535 + Table = TESTDATA
2536 + Owner = SYSDBA
2537 + Column Name = NOTES
2538 + Alias Name = NOTES
2539 + Field Name = NOTES
2540 + Scale = 0
2541 + Charset id = 4
2542 + Nullable
2543 + Size = 256
2544 +
2545 + SQLType =SQL_ARRAY
2546 + sub type = 0
2547 + Table = TESTDATA
2548 + Owner = SYSDBA
2549 + Column Name = MYARRAY
2550 + Alias Name = MYARRAY
2551 + Field Name = MYARRAY
2552 + Scale = 0
2553 + Charset id = 0
2554 + Nullable
2555 + Size = 8
2556 + Array Meta Data:
2557 + SQLType =SQL_LONG
2558 + Scale = 0
2559 + Charset id = 0
2560 + Size = 4
2561 + Table = TESTDATA
2562 + Column = MYARRAY
2563 + Dimensions = 1
2564 + Bounds: (0:16)
2565 +
2566 + SQLType =SQL_ARRAY
2567 + sub type = 0
2568 + Table = TESTDATA
2569 + Owner = SYSDBA
2570 + Column Name = MYARRAY2
2571 + Alias Name = MYARRAY2
2572 + Field Name = MYARRAY2
2573 + Scale = 0
2574 + Charset id = 0
2575 + Nullable
2576 + Size = 8
2577 + Array Meta Data:
2578 + SQLType =SQL_TIMESTAMP
2579 + Scale = 0
2580 + Charset id = 0
2581 + Size = 8
2582 + Table = TESTDATA
2583 + Column = MYARRAY2
2584 + Dimensions = 1
2585 + Bounds: (0:16)
2586 +
2587 + SQLType =SQL_ARRAY
2588 + sub type = 0
2589 + Table = TESTDATA
2590 + Owner = SYSDBA
2591 + Column Name = MYARRAY3
2592 + Alias Name = MYARRAY3
2593 + Field Name = MYARRAY3
2594 + Scale = 0
2595 + Charset id = 0
2596 + Nullable
2597 + Size = 8
2598 + Array Meta Data:
2599 + SQLType =SQL_INT64
2600 + Scale = -2
2601 + Charset id = 0
2602 + Size = 8
2603 + Table = TESTDATA
2604 + Column = MYARRAY3
2605 + Dimensions = 1
2606 + Bounds: (0:16)
2607 +
2608   ROWID = 1
2609 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2610 < DATED = 1/4/2016 09:30:00.100
2611 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2612 < Array: (0: 100) (1: 99) (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84)
2609 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2610 > DATED = 2016/04/01 09:30:00.1000
2611 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2612 > 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)
2613 >
2614 > 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)
2615 >
2616 > 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)
2617 >
2618  
2619   Shrink to 2:10
2620   Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2621 +
2622   Write updated reduced slice
2623   Show update array
2624   ROWID = 1
2625 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2626 < DATED = 1/4/2016 09:30:00.100
2627 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2628 < Array: (0: 100) (1: 99) (2: 1000) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84)
2625 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2626 > DATED = 2016/04/01 09:30:00.1000
2627 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2628 > 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)
2629  
2630 + 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)
2631  
2632 + 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)
2633  
2634 +
2635 +
2636 +
2637 + ------------------------------------------------------
2638   Running Test 8: Create and read back an Array with 2 dimensions
2639   Metadata
2640   SQLType =SQL_LONG
# Line 2238 | Line 2690 | Scale = 0
2690   Charset id = 0
2691   Not Null
2692   Size = 4
2693 + Value = 0
2694  
2695   SQLType =SQL_VARYING
2696   sub type = 0
# Line 2248 | Line 2701 | Nullable
2701   Size = 128
2702  
2703   ROWID = 1
2704 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2704 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2705   MYARRAY = NULL
2706  
2707   ROWID = 1
2708 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2709 < 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)
2708 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2709 > 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)
2710  
2711  
2712  
2713 +
2714 + ------------------------------------------------------
2715   Running Test 9: Database Information tests
2716   Database ID = 4 FB = /opt/firebird2.5.9/examples/empbuild/employee.fdb SN = zeus
2717   Pages =272
# Line 2273 | Line 2728 | Unknown Response 3
2728   Unknown Response 3
2729   Server Memory = 841392
2730   Forced Writes  = 1
2731 < Max Memory  = 879352
2731 > Max Memory  = 879288
2732   Num Buffers  = 75
2733   Sweep Interval  = 20000
2734   Logged in Users: SYSDBA,
# Line 2319 | Line 2774 | Update Count Operation Counts
2774   Page Size = 4096
2775  
2776  
2777 + ------------------------------------------------------
2778   Running Test 10: Event Handling
2779   Call Async Wait
2780   Async Wait Called
# Line 2342 | Line 2798 | Event Signalled
2798   Event Counts: TESTEVENT, Count = 2
2799  
2800  
2801 + ------------------------------------------------------
2802   Running Test 11: Services API
2803 + SPB: Item Count = 2
2804 +  user_name = SYSDBA
2805 +  password = masterkey
2806 +
2807   Service Manager Version = 2
2808   Server Version = LI-V2.5.9.27139 Firebird 2.5
2809   Implementation = Firebird/linux AMD64
# Line 2364 | Line 2825 | User ID = 0
2825   Group ID = 0
2826  
2827  
2828 < Licence Info:
2368 < feature is not supported
2828 > Licence Info: feature is not supported
2829   -feature is not supported
2830  
2831 < Licence Mask Info:
2372 < feature is not supported
2831 > Licence Mask Info: feature is not supported
2832  
2833   Capabilities = 260
2834  
# Line 2399 | Line 2858 | Database OK
2858   Database Dropped
2859  
2860  
2861 + ------------------------------------------------------
2862   Running Test 12: Character Sets
2863   SQL Params
2864   SQLType =SQL_LONG
# Line 2408 | Line 2868 | Scale = 0
2868   Charset id = 0
2869   Not Null
2870   Size = 4
2871 + Value = 0
2872  
2873   SQLType =SQL_VARYING
2874   sub type = 0
# Line 2457 | Line 2918 | Charset id = 4
2918   Nullable
2919   Size = 16
2920  
2921 + Show Param Values
2922 + SQL Params
2923 + SQLType =SQL_LONG
2924 + sub type = 0
2925 + Field Name = ROWID
2926 + Scale = 0
2927 + Charset id = 0
2928 + Not Null
2929 + Size = 4
2930 + Value = 1
2931 +
2932 + SQLType =SQL_TEXT
2933 + sub type = 0
2934 + Field Name = TITLE
2935 + Scale = 0
2936 + Charset id = 4
2937 + Nullable
2938 + Size = 128
2939 + Value = Blob Test ©€
2940 +
2941 + SQLType =SQL_TEXT
2942 + sub type = 0
2943 + Field Name = NOTES
2944 + Scale = 0
2945 + Charset id = 4
2946 + Nullable
2947 + Size = 256
2948 + Value = Écoute moi
2949 +
2950 + SQLType =SQL_TEXT
2951 + sub type = 0
2952 + Field Name = BLOBDATA
2953 + Scale = 0
2954 + Charset id = 1
2955 + Nullable
2956 + Size = 8
2957 + Value = Some German Special Characters like ÖÄÜöäüß
2958 +
2959 + SQLType =SQL_BLOB
2960 + sub type = 1
2961 + Field Name = BLOBDATA2
2962 + Scale = 0
2963 + Charset id = 4
2964 + Nullable
2965 + Size = 8
2966 + Value = Some German Special Characters like ÖÄÜöäüß
2967 +
2968 + SQLType =SQL_TEXT
2969 + sub type = 0
2970 + Field Name = INCLEAR
2971 + Scale = 0
2972 + Charset id = 1
2973 + Nullable
2974 + Size = 16
2975 + Value = &Test
2976  
2977 +
2978 + SQLType =SQL_TEXT
2979 + sub type = 0
2980 + Field Name = FIXEDWIDTH
2981 + Scale = 0
2982 + Charset id = 4
2983 + Nullable
2984 + Size = 16
2985 + Value = É
2986 +
2987   Connection Character Set UTF8
2988   ROWID = 1
2989 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2990 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2989 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
2990 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
2991   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)
2992   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)
2993 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
2994 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
2993 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
2994 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
2995  
2996   Connection Character Set NONE
2997   ROWID = 1
2998 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2999 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591 Byte Length = 10)
2998 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
2999 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591)
3000   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)
3001   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)
3002 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3003 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
3002 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3003 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
3004  
3005   Connection Character Set WIN1252
3006   ROWID = 1
3007 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252 Byte Length = 12)
3008 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252 Byte Length = 10)
3007 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252)
3008 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252)
3009   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)
3010   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)
3011 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3012 < FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252 Byte Length = 4)
3011 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3012 > FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252)
3013  
3014  
3015  
3016 + ------------------------------------------------------
3017   Running Test 13: Transaction over two databases
3018   Init Database 1
3019   ROWID = 1
3020 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3021 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3020 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3021 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3022   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)
3023   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)
3024 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3024 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3025  
3026   Init Database 2
3027   ROWID = 1
3028 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3029 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3028 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3029 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3030   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)
3031   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)
3032 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3032 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3033  
3034   ROWID = 1
3035 < TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3036 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3035 > TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001)
3036 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3037   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)
3038   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)
3039 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3039 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3040  
3041   ROWID = 1
3042 < TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3043 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3042 > TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001)
3043 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3044   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)
3045   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)
3046 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3046 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3047  
3048  
3049  
3050 + ------------------------------------------------------
3051   Running Test 14: Non select procedures
3052   Default Character set Name = UTF8
3053   Metadata
# Line 2547 | Line 3075 | Nullable
3075   Size = 128
3076  
3077   ROWID = 1
3078 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3078 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3079  
3080   Repeat with a different execute transaction
3081  
3082   ROWID = 1
3083 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3083 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3084  
3085   Repeat with a original transaction
3086  
3087   ROWID = 1
3088 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3088 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3089  
3090  
3091 + ------------------------------------------------------
3092   Running Test 15: Blob Handling and BPBs
3093  
3094   Testdata
3095  
3096   ROWID = 1
3097 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3097 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3098   BLOBDATA = (blob), Length = 92514
3099  
3100 + ROWID = 2
3101 + TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3102 + BLOBDATA = (blob), Length = 13
3103 + 0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3104  
3105   Testdata 2
3106  
3107   ROWID = 1
3108 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3108 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3109   BLOBDATA (Charset Id = 4 Codepage = 65001)
3110  
3111   Écoute moi
3112  
3113  
3114  
3115 + ------------------------------------------------------
3116   Running Test 16: Error handling
3117   Invalid Database Name Test
3118 < Error Handled:
2585 < I/O error during "open" operation for file "Malformed Name"
3118 > Error Handled: I/O error during "open" operation for file "Malformed Name"
3119   -Error while trying to open file
3120   -No such file or directory
3121   Invalid User Name Test
3122 < Error Handled:
2590 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3122 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3123   Invalid password Test
3124 < Error Handled:
2593 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3124 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3125   Invalid Prepare SQL Test
3126 < Error Handled:
2596 < Dynamic SQL Error
3126 > Error Handled: Dynamic SQL Error
3127   -SQL error code = -206
3128   -Column unknown
3129   -UNKNOWN_DATE
3130   -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3131   Invalid Open Cursor SQL Test
3132 < Error Handled:
2603 < Dynamic SQL Error
3132 > Error Handled: Dynamic SQL Error
3133   -SQL error code = -206
3134   -Column unknown
3135   -X
# Line 2611 | Line 3140 | Invalid Param SQL Type Test
3140   Error Handled: Field "EMP_NO" not found
3141   Case sensitive Param SQL  Test
3142   Error Handled: Field "EMP_NO" not found
3143 + Stale Reference Check
3144 + First test correct usage
3145 + COUNTER = 42
3146 +
3147 + New Transaction before param set
3148 + Error Handled: This interface is no longer up-to-date
3149 + New Transaction before Open Cursor
3150 + Error Handled: This interface is no longer up-to-date
3151 + Stop Stale Reference Checks
3152 + New Transaction before param set
3153 + COUNTER = 42
3154 +
3155 + New Transaction before Open Cursor
3156 + COUNTER = 42
3157 +
3158   Invalid Server Name Test
3159 < Error Handled:
2616 < Unable to complete network request to host "unknown".
3159 > Error Handled: Unable to complete network request to host "unknown".
3160   -Failed to locate host machine
3161   Invalid User Name Test
3162 < Error Handled:
2620 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3162 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3163   Invalid password Test
3164 < Error Handled:
3165 < Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3164 > Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3165 >
3166 >
3167 > ------------------------------------------------------
3168 > Running Test 17: Date/Time tests and Firebird 4 extensions
3169 > FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3170 > Has Local TZ DB = FALSE
3171 >
3172 > Testdata
3173 >
3174 > Metadata
3175 > SQLType =SQL_LONG
3176 > sub type = 0
3177 > Table = TESTDATA
3178 > Owner = SYSDBA
3179 > Column Name = ROWID
3180 > Alias Name = ROWID
3181 > Field Name = ROWID
3182 > Scale = 0
3183 > Charset id = 0
3184 > Not Null
3185 > Size = 4
3186 >
3187 > SQLType =SQL_TYPE_DATE
3188 > sub type = 0
3189 > Table = TESTDATA
3190 > Owner = SYSDBA
3191 > Column Name = DATECOL
3192 > Alias Name = DATECOL
3193 > Field Name = DATECOL
3194 > Scale = 0
3195 > Charset id = 0
3196 > Nullable
3197 > Size = 4
3198 >
3199 > SQLType =SQL_TYPE_TIME
3200 > sub type = 0
3201 > Table = TESTDATA
3202 > Owner = SYSDBA
3203 > Column Name = TIMECOL
3204 > Alias Name = TIMECOL
3205 > Field Name = TIMECOL
3206 > Scale = 0
3207 > Charset id = 0
3208 > Nullable
3209 > Size = 4
3210 >
3211 > SQLType =SQL_TIMESTAMP
3212 > sub type = 0
3213 > Table = TESTDATA
3214 > Owner = SYSDBA
3215 > Column Name = TIMESTAMPCOL
3216 > Alias Name = TIMESTAMPCOL
3217 > Field Name = TIMESTAMPCOL
3218 > Scale = 0
3219 > Charset id = 0
3220 > Nullable
3221 > Size = 8
3222 >
3223 > ROWID = 1
3224 > DATECOL = 2019/04/01
3225 > TIMECOL = 11:31:05.0001
3226 > TIMESTAMPCOL = 2016/02/29 22:02:35.0001
3227 > ROWID = 2
3228 > DATECOL = 1939/09/03
3229 > TIMECOL = 15:40:00.0002
3230 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3231 > ROWID = 3
3232 > DATECOL = 1066/10/14
3233 > TIMECOL = 23:59:59.9994
3234 > TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3235 > ROWID = 4
3236 > DATECOL = 1815/06/18
3237 > TIMECOL = 00:01:40.1115
3238 > TIMESTAMPCOL = 1945/05/08 22:10:00.0010
3239 >
3240 >
3241 > Testdata - second pass
3242 >
3243 > 1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
3244 > 2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3245 > 3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
3246 > 4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
3247 > Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1
3248 > Skipping Firebird 4 and later test part
3249 >
3250 >
3251 > ------------------------------------------------------
3252 > Running Test 18: Firebird 4 Decfloat extensions
3253 > FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3254 > Skipping test for Firebird 4 and later
3255 >
3256 >
3257 > ------------------------------------------------------
3258 > Running Test 19: Batch Update and Insert Queries
3259 > Opening localhost:employee
3260 > Skipping test for Firebird 4 and later
3261 >
3262 >
3263 > ------------------------------------------------------
3264 > Running Test 20: Stress Test IBatch interface
3265 > FBVersion = Firebird/linux AMD64 (access method), version "LI-V2.5.9.27139 Firebird 2.5"
3266 > Skipping test for Firebird 4 and later
3267 >
3268 >
3269 > ------------------------------------------------------
3270 > Running Test 21: Exercise setting and getting of numeric data types
3271 > 1234.567 parsed to 1234567 scale = -3
3272 > As Float =  1.2345670000000000E+003
3273 > -765.4321 parsed to -7654321 scale = -4
3274 > As Float = -7.6543209999999999E+002
3275 > 0.1 parsed to 1 scale = -1
3276 > As Float =  1.0000000000000001E-001
3277 > 0.01 parsed to 1 scale = -2
3278 > As Float =  1.0000000000000000E-002
3279 > +123 parsed to 123 scale = 0
3280 > As Float =  1.2300000000000000E+002
3281 > 1.23456E308 parsed to 123456 scale = 303
3282 > As Float =  1.2345600000000001E+308
3283 > -1.2e-02 parsed to -12 scale = -3
3284 > As Float = -1.2000000000000000E-002
3285 > 10. parsed to 10 scale = 0
3286 > As Float =  1.0000000000000000E+001
3287 > .12 parsed to 12 scale = -2
3288 > As Float =  1.2000000000000000E-001
3289 > 0.12 parsed to 12 scale = -2
3290 > As Float =  1.2000000000000000E-001
3291 > Parsing of 1.2E1.2 failed
3292 > Parsing of 1,000 failed
3293 > Parsing of 1e1e1 failed
3294 > Parsing of 1.2+3 failed
3295 > SQL Params
3296 > SQLType =SQL_LONG
3297 > sub type = 0
3298 > Field Name =
3299 > Scale = 0
3300 > Charset id = 0
3301 > Not Null
3302 > Size = 4
3303 > Value = 0
3304 >
3305 > SQLType =SQL_LONG
3306 > sub type = 0
3307 > Field Name =
3308 > Scale = 0
3309 > Charset id = 0
3310 > Nullable
3311 > Size = 4
3312 >
3313 > SQLType =SQL_INT64
3314 > sub type = 0
3315 > Field Name =
3316 > Scale = 0
3317 > Charset id = 0
3318 > Nullable
3319 > Size = 8
3320 >
3321 > SQLType =SQL_INT64
3322 > sub type = 0
3323 > Field Name =
3324 > Scale = -4
3325 > Charset id = 0
3326 > Nullable
3327 > Size = 8
3328 >
3329 > SQLType =SQL_DOUBLE
3330 > sub type = 0
3331 > Field Name =
3332 > Scale = 0
3333 > Charset id = 0
3334 > Nullable
3335 > Size = 8
3336 >
3337 > SQLType =SQL_INT64
3338 > sub type = 0
3339 > Field Name =
3340 > Scale = -6
3341 > Charset id = 0
3342 > Nullable
3343 > Size = 8
3344 >
3345 > Expected Error - Dynamic SQL Error
3346 > -SQL error code = -303
3347 > -conversion error from string "1,000"
3348 > Expected Error - Dynamic SQL Error
3349 > -SQL error code = -303
3350 > -conversion error from string "10.0.0"
3351 > ROWID = 1
3352 > ITYPE = 101
3353 > I64TYPE = 9223372036854775807
3354 > CURRTYPE = 10,000.12340000
3355 > DTYPE = 9,999.12345678
3356 > FIXEDPOINT = 1,234,567,890.12345700
3357 > ROWID = 2
3358 > ITYPE = -32457
3359 > I64TYPE = -9223372036854775808
3360 > CURRTYPE = 1,000,001.12000000
3361 > DTYPE = 1.7E308
3362 > FIXEDPOINT = -1,234,567,890.12345700
3363 > ROWID = 3
3364 > ITYPE = 0
3365 > I64TYPE = 0
3366 > CURRTYPE = .00000000
3367 > DTYPE = .00000000
3368 > FIXEDPOINT = .00000000
3369 > ROWID = 4
3370 > ITYPE = 1
3371 > I64TYPE = 10
3372 > CURRTYPE = .02300000
3373 > DTYPE = .00110000
3374 > FIXEDPOINT = 233.45600000
3375 >
3376 >
3377 >
3378 > ------------------------------------------------------
3379 > Running Test 22: Journalling
3380 > Start Journaling. Session ID = 1
3381 > 1234.567 parsed to 1234567 scale = -3
3382 > As Float =  1.2345670000000000E+003
3383 > -765.4321 parsed to -7654321 scale = -4
3384 > As Float = -7.6543209999999999E+002
3385 > 0.1 parsed to 1 scale = -1
3386 > As Float =  1.0000000000000001E-001
3387 > 0.01 parsed to 1 scale = -2
3388 > As Float =  1.0000000000000000E-002
3389 > +123 parsed to 123 scale = 0
3390 > As Float =  1.2300000000000000E+002
3391 > 1.23456E308 parsed to 123456 scale = 303
3392 > As Float =  1.2345600000000001E+308
3393 > -1.2e-02 parsed to -12 scale = -3
3394 > As Float = -1.2000000000000000E-002
3395 > 10. parsed to 10 scale = 0
3396 > As Float =  1.0000000000000000E+001
3397 > .12 parsed to 12 scale = -2
3398 > As Float =  1.2000000000000000E-001
3399 > 0.12 parsed to 12 scale = -2
3400 > As Float =  1.2000000000000000E-001
3401 > Parsing of 1.2E1.2 failed
3402 > Parsing of 1,000 failed
3403 > Parsing of 1e1e1 failed
3404 > Parsing of 1.2+3 failed
3405 > SQL Params
3406 > SQLType =SQL_LONG
3407 > sub type = 0
3408 > Field Name =
3409 > Scale = 0
3410 > Charset id = 0
3411 > Not Null
3412 > Size = 4
3413 > Value = 0
3414 >
3415 > SQLType =SQL_LONG
3416 > sub type = 0
3417 > Field Name =
3418 > Scale = 0
3419 > Charset id = 0
3420 > Nullable
3421 > Size = 4
3422 >
3423 > SQLType =SQL_INT64
3424 > sub type = 0
3425 > Field Name =
3426 > Scale = 0
3427 > Charset id = 0
3428 > Nullable
3429 > Size = 8
3430 >
3431 > SQLType =SQL_INT64
3432 > sub type = 0
3433 > Field Name =
3434 > Scale = -4
3435 > Charset id = 0
3436 > Nullable
3437 > Size = 8
3438 >
3439 > SQLType =SQL_DOUBLE
3440 > sub type = 0
3441 > Field Name =
3442 > Scale = 0
3443 > Charset id = 0
3444 > Nullable
3445 > Size = 8
3446 >
3447 > SQLType =SQL_INT64
3448 > sub type = 0
3449 > Field Name =
3450 > Scale = -6
3451 > Charset id = 0
3452 > Nullable
3453 > Size = 8
3454 >
3455 >
3456 > Text Tests
3457 > SQL Params
3458 > SQLType =SQL_LONG
3459 > sub type = 0
3460 > Field Name =
3461 > Scale = 0
3462 > Charset id = 0
3463 > Not Null
3464 > Size = 4
3465 > Value = 0
3466 >
3467 > SQLType =SQL_VARYING
3468 > sub type = 0
3469 > Field Name =
3470 > Scale = 0
3471 > Charset id = 4
3472 > Nullable
3473 > Size = 1024
3474 >
3475 > SQLType =SQL_BLOB
3476 > sub type = 1
3477 > Field Name =
3478 > Scale = 0
3479 > Charset id = 4
3480 > Nullable
3481 > Size = 8
3482 >
3483 >
3484 > Binary Blob Tests
3485 >
3486 > Array Test
3487 > SQL Params
3488 > SQLType =SQL_LONG
3489 > sub type = 0
3490 > Field Name =
3491 > Scale = 0
3492 > Charset id = 0
3493 > Not Null
3494 > Size = 4
3495 > Value = 0
3496 >
3497 > SQLType =SQL_ARRAY
3498 > sub type = 0
3499 > Field Name =
3500 > Scale = 0
3501 > Charset id = 0
3502 > Nullable
3503 > Size = 8
3504 >
3505 > ROWID = 1
3506 > ITYPE = 101
3507 > I64TYPE = 9223372036854775807
3508 > CURRTYPE = 10,000.12340000
3509 > DTYPE = 9,999.12345678
3510 > FIXEDPOINT = 1,234,567,890.12345700
3511 > STR = NULL
3512 > TEXTBLOB = NULL
3513 > OTHERBLOB = NULL
3514 > MYARRAY = NULL
3515 > ROWID = 2
3516 > ITYPE = -32457
3517 > I64TYPE = -9223372036854775808
3518 > CURRTYPE = 1,000,001.12000000
3519 > DTYPE = 1.7E308
3520 > FIXEDPOINT = -1,234,567,890.12345700
3521 > STR = NULL
3522 > TEXTBLOB = NULL
3523 > OTHERBLOB = NULL
3524 > MYARRAY = NULL
3525 > ROWID = 4
3526 > ITYPE = 1
3527 > I64TYPE = 10
3528 > CURRTYPE = .02300000
3529 > DTYPE = .00110000
3530 > FIXEDPOINT = 233.45600000
3531 > STR = NULL
3532 > TEXTBLOB = NULL
3533 > OTHERBLOB = NULL
3534 > MYARRAY = NULL
3535 >
3536 > Journal Table
3537 > IBX$SESSIONID = 1
3538 > IBX$TRANSACTIONID = 8
3539 > IBX$OLDTRANSACTIONID = NULL
3540 > IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3541 > IBX$CREATED = 2021/12/07 09:57:12.8450
3542 > IBX$SESSIONID = 1
3543 > IBX$TRANSACTIONID = 10
3544 > IBX$OLDTRANSACTIONID = 9
3545 > IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3546 > IBX$CREATED = 2021/12/07 09:57:13.1650
3547 >
3548 > Journal Entries
3549 > Journal Entry = jeTransStart(Transaction Start)
3550 > Timestamp = 2021/12/07 09:57:12.8740
3551 > Session ID = 1
3552 > Transaction ID = 8
3553 > Transaction Name = "Transaction_29_1"
3554 > TPB: Item Count = 3
3555 >  isc_tpb_write
3556 >  isc_tpb_nowait
3557 >  isc_tpb_concurrency
3558 >
3559 > Default Completion = TACommit
3560 >
3561 > Journal Entry = jeQuery(Query)
3562 > Timestamp = 2021/12/07 09:57:12.9610
3563 > Session ID = 1
3564 > Transaction ID = 8
3565 > Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3566 >
3567 > Journal Entry = jeQuery(Query)
3568 > Timestamp = 2021/12/07 09:57:12.9820
3569 > Session ID = 1
3570 > Transaction ID = 8
3571 > Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3572 >
3573 > Journal Entry = jeTransCommitRet(Commit Retaining)
3574 > Timestamp = 2021/12/07 09:57:13.0450
3575 > Session ID = 1
3576 > Transaction ID = 9
3577 > Old TransactionID = 8
3578 >
3579 > Journal Entry = jeQuery(Query)
3580 > Timestamp = 2021/12/07 09:57:13.0670
3581 > Session ID = 1
3582 > Transaction ID = 9
3583 > Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3584 >
3585 > Journal Entry = jeTransRollbackRet(Rollback Retaining)
3586 > Timestamp = 2021/12/07 09:57:13.1620
3587 > Session ID = 1
3588 > Transaction ID = 10
3589 > Old TransactionID = 9
3590 >
3591 > Journal Entry = jeQuery(Query)
3592 > Timestamp = 2021/12/07 09:57:13.1830
3593 > Session ID = 1
3594 > Transaction ID = 10
3595 > Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3596 >
3597 > Journal Entry = jeTransStart(Transaction Start)
3598 > Timestamp = 2021/12/07 09:57:13.1940
3599 > Session ID = 1
3600 > Transaction ID = 11
3601 > Transaction Name = "Transaction_29_2"
3602 > TPB: Item Count = 3
3603 >  isc_tpb_write
3604 >  isc_tpb_nowait
3605 >  isc_tpb_concurrency
3606 >
3607 > Default Completion = TARollback
3608 >
3609 > Journal Entry = jeTransCommit(Commit)
3610 > Timestamp = 2021/12/07 09:57:13.2360
3611 > Session ID = 1
3612 > Transaction ID = 10
3613 >
3614 > Journal Entry = jeQuery(Query)
3615 > Timestamp = 2021/12/07 09:57:13.2590
3616 > Session ID = 1
3617 > Transaction ID = 11
3618 > 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:
3619 > Whether ''tis nobler in the mind to suffer
3620 > The slings and arrows of outrageous fortune,
3621 > Or to take arms against a sea of troubles,
3622 > And, by opposing, end them. To die, to sleep-
3623 > No more-and by a sleep to say we end
3624 > The heartache and the thousand natural shocks
3625 > That flesh is heir to-''tis a consummation
3626 > Devoutly to be wished. To die, to sleep-
3627 > To sleep, perchance to dream. Aye, there''s the rub,
3628 > For in that sleep of death what dreams may come,
3629 > When we have shuffled off this mortal coil,
3630 > Must give us pause. There''s the respect
3631 > That makes calamity of so long life.
3632 > For who would bear the whips and scorns of time,
3633 > Th'' oppressor''s wrong, the proud man''s contumely,
3634 > The pangs of despised love, the law’s delay,
3635 > The insolence of office, and the spurns
3636 > That patient merit of the unworthy takes,
3637 > When he himself might his quietus make
3638 > With a bare bodkin? Who would fardels bear,
3639 > To grunt and sweat under a weary life,
3640 > But that the dread of something after death,
3641 > The undiscovered country from whose bourn
3642 > No traveler returns, puzzles the will
3643 > And makes us rather bear those ills we have
3644 > Than fly to others that we know not of?
3645 > Thus conscience does make cowards of us all,
3646 > And thus the native hue of resolution
3647 > Is sicklied o''er with the pale cast of thought,
3648 > And enterprises of great pitch and moment,
3649 > With this regard their currents turn awry,
3650 > And lose the name of action.-Soft you now,
3651 > The fair Ophelia.-Nymph, in thy orisons
3652 > Be all my sins remembered
3653 > ')
3654 >
3655 > Journal Entry = jeQuery(Query)
3656 > Timestamp = 2021/12/07 09:57:13.2780
3657 > Session ID = 1
3658 > Transaction ID = 11
3659 > Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3660 > FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3661 > 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
3662 > 01000000010000001A01050001000000DA000000
3663 > </blob>
3664 > )
3665 >
3666 > Journal Entry = jeQuery(Query)
3667 > Timestamp = 2021/12/07 09:57:13.3010
3668 > Session ID = 1
3669 > Transaction ID = 11
3670 > 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">
3671 > <elt ix="0">100</elt>
3672 > <elt ix="1">99</elt>
3673 > <elt ix="2">98</elt>
3674 > <elt ix="3">97</elt>
3675 > <elt ix="4">96</elt>
3676 > <elt ix="5">95</elt>
3677 > <elt ix="6">94</elt>
3678 > <elt ix="7">93</elt>
3679 > <elt ix="8">92</elt>
3680 > <elt ix="9">91</elt>
3681 > <elt ix="10">90</elt>
3682 > <elt ix="11">89</elt>
3683 > <elt ix="12">88</elt>
3684 > <elt ix="13">87</elt>
3685 > <elt ix="14">86</elt>
3686 > <elt ix="15">85</elt>
3687 > <elt ix="16">84</elt>
3688 > </array>
3689 > )
3690 >
3691 > Journal Entry = jeTransRollback(Rollback)
3692 > Timestamp = 2021/12/07 09:57:13.3610
3693 > Session ID = 1
3694 > Transaction ID = 11
3695 >
3696  
3697  
3698 + ------------------------------------------------------
3699   Test Suite Ends

Diff Legend

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