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

Comparing:
ibx/trunk/fbintf/testsuite/FB3reference.log (file contents), Revision 333 by tony, Fri Feb 26 16:34:26 2021 UTC vs.
ibx/branches/udr/testsuite/FB3reference.log (file contents), Revision 381 by tony, Sat Jan 15 00:06:22 2022 UTC

# Line 1 | Line 1
1   Firebird API Test Suite
2 < Copyright MWA Software 2016
2 > Copyright MWA Software 2016-2021
3  
4   Starting Tests
5   Client API Version = 3.0
6 + Firebird Environment Variable = /opt/firebird3.0.5
7 + Firebird Bin Directory = /opt/firebird3.0.5/bin
8 + Firebird Conf Directory = /opt/firebird3.0.5/
9 + Firebird Client Library Path = /opt/firebird3.0.5/lib/libfbclient.so
10   Running Test 1: Create and Drop a Database
11   Creating a Database with empty parameters
12 < Create Database fails (as expected):
9 < I/O error during "open O_CREAT" operation for file ""
12 > Create Database fails (as expected): Engine Code: 335544344 I/O error during "open O_CREAT" operation for file ""
13   -Error while trying to create file
14   -No such file or directory
15   Creating a Database using an SQL Statement
16 < Database ID = 2 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
16 > Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
17   SQL Dialect = 3
18 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
18 > DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
19   DB Charset ID = 0
20   DB SQL Dialect = 3
21 < DB Remote Protocol =
21 > DB Remote Protocol = TCPv4
22   DB ODS Major Version = 12
23   DB ODS Minor Version = 0
24 < User Authentication Method = User name in DPB
24 > User Authentication Method = Srp
25   Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
26   DB Client Implementation Version = 3.0
27 < DPB
28 < Count = 3
29 < 28 = SYSDBA
30 < 29 = masterkey
31 < 65 = 3
27 > DPB: Item Count = 3
28 >  isc_dpb_user_name = SYSDBA
29 >  isc_dpb_password = masterkey
30 >  isc_dpb_set_db_sql_dialect = 3
31 >
32 > Firebird Server Version Info
33 > Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
34 > Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C"
35 > Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C"
36 > on disk structure version 12.0
37  
38   Dropping Database
39   Creating a Database with a DPD
40 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
40 > DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
41   DB Charset ID = 4
42   DB SQL Dialect = 3
43 < DB Remote Protocol =
43 > DB Remote Protocol = TCPv4
44   DB ODS Major Version = 12
45   DB ODS Minor Version = 0
46 < User Authentication Method = User name in DPB
46 > User Authentication Method = Srp
47   Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
48   DB Client Implementation Version = 3.0
49   Dropping Database
50 < DPB
51 < Count = 4
52 < 28 = SYSDBA
53 < 29 = masterkey
54 < 48 = UTF8
47 < 65 = 3
50 > DPB: Item Count = 4
51 >  isc_dpb_user_name = SYSDBA
52 >  isc_dpb_password = masterkey
53 >  isc_dpb_lc_ctype = UTF8
54 >  isc_dpb_set_db_sql_dialect = 3
55  
56   Creating a Database with a DPD
57 < Database ID = 2 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
57 > Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
58   ODS major = 12
59   ODS minor = 0
60 < DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb
60 > Attachment ID = 6
61 > DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
62   DB Charset ID = 4
63   DB SQL Dialect = 3
64 < DB Remote Protocol =
64 > DB Remote Protocol = TCPv4
65   DB ODS Major Version = 12
66   DB ODS Minor Version = 0
67 < User Authentication Method = User name in DPB
67 > User Authentication Method = Srp
68   Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
69   DB Client Implementation Version = 3.0
70   RDB$DESCRIPTION =
# Line 67 | Line 75 | RDB$LINGER =
75   Dropping Database
76  
77  
78 + ------------------------------------------------------
79   Running Test 2: Open the employee database and run a query
80 + Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login
81   Opening inet://localhost/employee
82   Database Open, SQL Dialect = 3
83 + TPB: Item Count = 3
84 +  isc_tpb_read
85 +  isc_tpb_nowait
86 +  isc_tpb_concurrency
87 +
88   Metadata
89   SQLType =SQL_SHORT
90   sub type = 0
# Line 214 | Line 229 | EMP_NO = 2
229   FIRST_NAME = Robert
230   LAST_NAME = Nelson
231   PHONE_EXT = 250
232 < HIRE_DATE = 28/12/1988 00:00:00.000
232 > HIRE_DATE = 1988/12/28 00:00:00.0000
233   DEPT_NO = 600
234   JOB_CODE = VP
235   JOB_GRADE = 2
# Line 225 | Line 240 | EMP_NO = 4
240   FIRST_NAME = Bruce
241   LAST_NAME = Young
242   PHONE_EXT = 233
243 < HIRE_DATE = 28/12/1988 00:00:00.000
243 > HIRE_DATE = 1988/12/28 00:00:00.0000
244   DEPT_NO = 621
245   JOB_CODE = Eng
246   JOB_GRADE = 2
# Line 236 | Line 251 | EMP_NO = 5
251   FIRST_NAME = Kim
252   LAST_NAME = Lambert
253   PHONE_EXT = 22
254 < HIRE_DATE = 6/2/1989 00:00:00.000
254 > HIRE_DATE = 1989/02/06 00:00:00.0000
255   DEPT_NO = 130
256   JOB_CODE = Eng
257   JOB_GRADE = 2
# Line 253 | Line 268 | Scale = 0
268   Charset id = 0
269   Not Null
270   Size = 2
271 + Value = 0
272  
273   EMP_NO = 8
274   FIRST_NAME = Leslie
275   LAST_NAME = Johnson
276   PHONE_EXT = 410
277 < HIRE_DATE = 5/4/1989 00:00:00.000
277 > HIRE_DATE = 1989/04/05 00:00:00.0000
278   DEPT_NO = 180
279   JOB_CODE = Mktg
280   JOB_GRADE = 3
# Line 276 | Line 292 | Scale = 0
292   Charset id = 0
293   Not Null
294   Size = 2
295 + Value = 0
296  
297 + Results for Cursor: Test Cursor
298   EMP_NO = 8
299   FIRST_NAME = Leslie
300   LAST_NAME = Johnson
301   PHONE_EXT = 410
302 < HIRE_DATE = 5/4/1989 00:00:00.000
302 > HIRE_DATE = 1989/04/05 00:00:00.0000
303   DEPT_NO = 180
304   JOB_CODE = Mktg
305   JOB_GRADE = 3
# Line 289 | Line 307 | JOB_COUNTRY = USA
307   SALARY = 64,635.00
308   FULL_NAME = Johnson, Leslie
309  
310 + Scollable Cursors
311 + DB Connect String = inet://localhost/employee
312 + DB Charset ID = 4
313 + DB SQL Dialect = 3
314 + DB Remote Protocol = TCPv4
315 + DB ODS Major Version = 12
316 + DB ODS Minor Version = 0
317 + User Authentication Method = Srp
318 + Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
319 + DB Client Implementation Version = 3.0
320 + Do Fetch Next:
321 + EMP_NO = 2
322 + FIRST_NAME = Robert
323 + LAST_NAME = Nelson
324 + PHONE_EXT = 250
325 + HIRE_DATE = 1988/12/28 00:00:00.0000
326 + DEPT_NO = 600
327 + JOB_CODE = VP
328 + JOB_GRADE = 2
329 + JOB_COUNTRY = USA
330 + SALARY = 105,900.00
331 + FULL_NAME = Nelson, Robert
332 + Do Fetch Last:
333 + Remote Scrollable cursors test fails Engine Code: 335544378 feature is not supported
334 + Now open the employee database as a local database
335 + TPB: Item Count = 3
336 +  isc_tpb_read
337 +  isc_tpb_nowait
338 +  isc_tpb_concurrency
339  
340 + Metadata
341 + SQLType =SQL_SHORT
342 + sub type = 0
343 + Table = EMPLOYEE
344 + Owner = SYSDBA
345 + Column Name = EMP_NO
346 + Alias Name = EMP_NO
347 + Field Name = EMP_NO
348 + Scale = 0
349 + Charset id = 0
350 + Not Null
351 + Size = 2
352  
353 + SQLType =SQL_VARYING
354 + sub type = 0
355 + Table = EMPLOYEE
356 + Owner = SYSDBA
357 + Column Name = FIRST_NAME
358 + Alias Name = FIRST_NAME
359 + Field Name = FIRST_NAME
360 + Scale = 0
361 + Charset id = 0
362 + Not Null
363 + Size = 15
364 +
365 + SQLType =SQL_VARYING
366 + sub type = 0
367 + Table = EMPLOYEE
368 + Owner = SYSDBA
369 + Column Name = LAST_NAME
370 + Alias Name = LAST_NAME
371 + Field Name = LAST_NAME
372 + Scale = 0
373 + Charset id = 0
374 + Not Null
375 + Size = 20
376 +
377 + SQLType =SQL_VARYING
378 + sub type = 0
379 + Table = EMPLOYEE
380 + Owner = SYSDBA
381 + Column Name = PHONE_EXT
382 + Alias Name = PHONE_EXT
383 + Field Name = PHONE_EXT
384 + Scale = 0
385 + Charset id = 0
386 + Nullable
387 + Size = 4
388 +
389 + SQLType =SQL_TIMESTAMP
390 + sub type = 0
391 + Table = EMPLOYEE
392 + Owner = SYSDBA
393 + Column Name = HIRE_DATE
394 + Alias Name = HIRE_DATE
395 + Field Name = HIRE_DATE
396 + Scale = 0
397 + Charset id = 0
398 + Not Null
399 + Size = 8
400 +
401 + SQLType =SQL_TEXT
402 + sub type = 0
403 + Table = EMPLOYEE
404 + Owner = SYSDBA
405 + Column Name = DEPT_NO
406 + Alias Name = DEPT_NO
407 + Field Name = DEPT_NO
408 + Scale = 0
409 + Charset id = 0
410 + Not Null
411 + Size = 3
412 +
413 + SQLType =SQL_VARYING
414 + sub type = 0
415 + Table = EMPLOYEE
416 + Owner = SYSDBA
417 + Column Name = JOB_CODE
418 + Alias Name = JOB_CODE
419 + Field Name = JOB_CODE
420 + Scale = 0
421 + Charset id = 0
422 + Not Null
423 + Size = 5
424 +
425 + SQLType =SQL_SHORT
426 + sub type = 0
427 + Table = EMPLOYEE
428 + Owner = SYSDBA
429 + Column Name = JOB_GRADE
430 + Alias Name = JOB_GRADE
431 + Field Name = JOB_GRADE
432 + Scale = 0
433 + Charset id = 0
434 + Not Null
435 + Size = 2
436 +
437 + SQLType =SQL_VARYING
438 + sub type = 0
439 + Table = EMPLOYEE
440 + Owner = SYSDBA
441 + Column Name = JOB_COUNTRY
442 + Alias Name = JOB_COUNTRY
443 + Field Name = JOB_COUNTRY
444 + Scale = 0
445 + Charset id = 0
446 + Not Null
447 + Size = 15
448 +
449 + SQLType =SQL_INT64
450 + sub type = 0
451 + Table = EMPLOYEE
452 + Owner = SYSDBA
453 + Column Name = SALARY
454 + Alias Name = SALARY
455 + Field Name = SALARY
456 + Scale = -2
457 + Charset id = 0
458 + Not Null
459 + Size = 8
460 +
461 + SQLType =SQL_VARYING
462 + sub type = 0
463 + Table = EMPLOYEE
464 + Owner = SYSDBA
465 + Column Name = FULL_NAME
466 + Alias Name = FULL_NAME
467 + Field Name = FULL_NAME
468 + Scale = 0
469 + Charset id = 0
470 + Nullable
471 + Size = 37
472 +
473 + Plan =
474 + Select Expression
475 +    -> First N Records
476 +        -> Table "EMPLOYEE" Full Scan
477 + -- SQL style inline comment
478 + /* this is a comment */ Select First 3 * from EMPLOYEE
479 +
480 + EMP_NO = 2
481 + FIRST_NAME = Robert
482 + LAST_NAME = Nelson
483 + PHONE_EXT = 250
484 + HIRE_DATE = 1988/12/28 00:00:00.0000
485 + DEPT_NO = 600
486 + JOB_CODE = VP
487 + JOB_GRADE = 2
488 + JOB_COUNTRY = USA
489 + SALARY = 105,900.00
490 + FULL_NAME = Nelson, Robert
491 + EMP_NO = 4
492 + FIRST_NAME = Bruce
493 + LAST_NAME = Young
494 + PHONE_EXT = 233
495 + HIRE_DATE = 1988/12/28 00:00:00.0000
496 + DEPT_NO = 621
497 + JOB_CODE = Eng
498 + JOB_GRADE = 2
499 + JOB_COUNTRY = USA
500 + SALARY = 97,500.00
501 + FULL_NAME = Young, Bruce
502 + EMP_NO = 5
503 + FIRST_NAME = Kim
504 + LAST_NAME = Lambert
505 + PHONE_EXT = 22
506 + HIRE_DATE = 1989/02/06 00:00:00.0000
507 + DEPT_NO = 130
508 + JOB_CODE = Eng
509 + JOB_GRADE = 2
510 + JOB_COUNTRY = USA
511 + SALARY = 102,750.00
512 + FULL_NAME = Lambert, Kim
513 +
514 + Select * from EMPLOYEE Where EMP_NO = ?
515 + SQL Params
516 + SQLType =SQL_SHORT
517 + sub type = 0
518 + Field Name =
519 + Scale = 0
520 + Charset id = 0
521 + Not Null
522 + Size = 2
523 + Value = 0
524 +
525 + EMP_NO = 8
526 + FIRST_NAME = Leslie
527 + LAST_NAME = Johnson
528 + PHONE_EXT = 410
529 + HIRE_DATE = 1989/04/05 00:00:00.0000
530 + DEPT_NO = 180
531 + JOB_CODE = Mktg
532 + JOB_GRADE = 3
533 + JOB_COUNTRY = USA
534 + SALARY = 64,635.00
535 + FULL_NAME = Johnson, Leslie
536 +
537 + With param names
538 + Select * from EMPLOYEE Where EMP_NO = :EMP_NO
539 + SQL Params
540 + SQLType =SQL_SHORT
541 + sub type = 0
542 + Field Name = EMP_NO
543 + Scale = 0
544 + Charset id = 0
545 + Not Null
546 + Size = 2
547 + Value = 0
548 +
549 + Results for Cursor: Test Cursor
550 + EMP_NO = 8
551 + FIRST_NAME = Leslie
552 + LAST_NAME = Johnson
553 + PHONE_EXT = 410
554 + HIRE_DATE = 1989/04/05 00:00:00.0000
555 + DEPT_NO = 180
556 + JOB_CODE = Mktg
557 + JOB_GRADE = 3
558 + JOB_COUNTRY = USA
559 + SALARY = 64,635.00
560 + FULL_NAME = Johnson, Leslie
561 +
562 + Scollable Cursors
563 + DB Connect String = employee
564 + DB Charset ID = 4
565 + DB SQL Dialect = 3
566 + DB Remote Protocol =
567 + DB ODS Major Version = 12
568 + DB ODS Minor Version = 0
569 + User Authentication Method = User name in DPB
570 + Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
571 + DB Client Implementation Version = 3.0
572 + Do Fetch Next:
573 + EMP_NO = 2
574 + FIRST_NAME = Robert
575 + LAST_NAME = Nelson
576 + PHONE_EXT = 250
577 + HIRE_DATE = 1988/12/28 00:00:00.0000
578 + DEPT_NO = 600
579 + JOB_CODE = VP
580 + JOB_GRADE = 2
581 + JOB_COUNTRY = USA
582 + SALARY = 105,900.00
583 + FULL_NAME = Nelson, Robert
584 + Do Fetch Last:
585 + EMP_NO = 145
586 + FIRST_NAME = Mark
587 + LAST_NAME = Guckenheimer
588 + PHONE_EXT = 221
589 + HIRE_DATE = 1994/05/02 00:00:00.0000
590 + DEPT_NO = 622
591 + JOB_CODE = Eng
592 + JOB_GRADE = 5
593 + JOB_COUNTRY = USA
594 + SALARY = 32,000.00
595 + FULL_NAME = Guckenheimer, Mark
596 + Do Fetch Prior:
597 + EMP_NO = 144
598 + FIRST_NAME = John
599 + LAST_NAME = Montgomery
600 + PHONE_EXT = 820
601 + HIRE_DATE = 1994/03/30 00:00:00.0000
602 + DEPT_NO = 672
603 + JOB_CODE = Eng
604 + JOB_GRADE = 5
605 + JOB_COUNTRY = USA
606 + SALARY = 35,000.00
607 + FULL_NAME = Montgomery, John
608 + Do Fetch First:
609 + EMP_NO = 2
610 + FIRST_NAME = Robert
611 + LAST_NAME = Nelson
612 + PHONE_EXT = 250
613 + HIRE_DATE = 1988/12/28 00:00:00.0000
614 + DEPT_NO = 600
615 + JOB_CODE = VP
616 + JOB_GRADE = 2
617 + JOB_COUNTRY = USA
618 + SALARY = 105,900.00
619 + FULL_NAME = Nelson, Robert
620 + Do Fetch Abs 8 :
621 + EMP_NO = 14
622 + FIRST_NAME = Stewart
623 + LAST_NAME = Hall
624 + PHONE_EXT = 227
625 + HIRE_DATE = 1990/06/04 00:00:00.0000
626 + DEPT_NO = 900
627 + JOB_CODE = Finan
628 + JOB_GRADE = 3
629 + JOB_COUNTRY = USA
630 + SALARY = 69,482.63
631 + FULL_NAME = Hall, Stewart
632 + Do Fetch Relative -2 :
633 + EMP_NO = 11
634 + FIRST_NAME = K. J.
635 + LAST_NAME = Weston
636 + PHONE_EXT = 34
637 + HIRE_DATE = 1990/01/17 00:00:00.0000
638 + DEPT_NO = 130
639 + JOB_CODE = SRep
640 + JOB_GRADE = 4
641 + JOB_COUNTRY = USA
642 + SALARY = 86,292.94
643 + FULL_NAME = Weston, K. J.
644 + Do Fetch beyond EOF :
645 + Fetch returned false
646 +
647 +
648 + ------------------------------------------------------
649   Running Test 3: ad hoc queries
650   Opening inet://localhost/employee
651   Database Open
652   Employee Count = 42
653 + Transaction ID = 6142
654 + Transaction is Read/Write
655 + Transaction Database Path = inet://localhost/employee
656 + Transaction ID = 6142
657 + Oldest Interesting = 6140
658 + Oldest Action = 6141
659 + Oldest Snapshot = 6141
660 + Oldest Interesting = 0
661   Employee Count = 41
662   Employee Count = 42
663   Employee Count = 41
# Line 304 | Line 667 | Constrained Employee Count = 3
667   "Yanowski" Employee Count = 1
668  
669  
670 + ------------------------------------------------------
671   Running Test 4: Update, Insert and Delete Queries
672   Opening inet://localhost/employee
673   Database Open
# Line 316 | Line 680 | EMP_NO = 8
680   FIRST_NAME = Leslie
681   LAST_NAME = Johnson
682   PHONE_EXT = 410
683 < HIRE_DATE = 5/4/1989 00:00:00.000
683 > HIRE_DATE = 1989/04/05 00:00:00.0000
684   DEPT_NO = 180
685   JOB_CODE = Mktg
686   JOB_GRADE = 3
# Line 324 | Line 688 | JOB_COUNTRY = USA
688   SALARY = 64,635.00
689   FULL_NAME = Johnson, Leslie
690  
691 < Current memory = 19693296
692 < Delta memory = 4480
693 < Max memory = 19755408
691 > Current memory = 19,689,792
692 > Delta memory = 4,480
693 > Max memory = 19,751,184
694   Elapsed time= 0.001 sec
695   Cpu = 0.000 sec
696   Buffers = 2048
# Line 472 | Line 836 | EMP_NO = 150
836   FIRST_NAME = John
837   LAST_NAME = Doe
838   PHONE_EXT =
839 < HIRE_DATE = 1/4/2015 00:00:00.000
839 > HIRE_DATE = 2015/04/01 00:00:00.0000
840   DEPT_NO = 600
841   JOB_CODE = Eng
842   JOB_GRADE = 4
# Line 485 | Line 849 | EMP_NO = 151
849   FIRST_NAME = Major
850   LAST_NAME = Major
851   PHONE_EXT =
852 < HIRE_DATE = 1/4/2015 00:00:00.000
852 > HIRE_DATE = 2015/04/01 00:00:00.0000
853   DEPT_NO = 600
854   JOB_CODE = Eng
855   JOB_GRADE = 4
# Line 502 | Line 866 | EMP_NO = 150
866   FIRST_NAME = Jane
867   LAST_NAME = Doe
868   PHONE_EXT = NULL
869 < HIRE_DATE = 1/4/2015 00:00:00.000
869 > HIRE_DATE = 2015/04/01 00:00:00.0000
870   DEPT_NO = 600
871   JOB_CODE = Eng
872   JOB_GRADE = 4
# Line 519 | Line 883 | EMP_NO = 150
883   FIRST_NAME = Jayne's
884   LAST_NAME = Doe
885   PHONE_EXT = NULL
886 < HIRE_DATE = 1/4/2015 00:00:00.000
886 > HIRE_DATE = 2015/04/01 00:00:00.0000
887   DEPT_NO = 600
888   JOB_CODE = Eng
889   JOB_GRADE = 4
# Line 533 | Line 897 | EMP_NO = 8
897   FIRST_NAME = Leslie
898   LAST_NAME = Johnson
899   PHONE_EXT = 410
900 < HIRE_DATE = 5/4/1989 00:00:00.000
900 > HIRE_DATE = 1989/04/05 00:00:00.0000
901   DEPT_NO = 180
902   JOB_CODE = Mktg
903   JOB_GRADE = 3
# Line 547 | Line 911 | EMP_NO = 8
911   FIRST_NAME = Leslie
912   LAST_NAME = Johnson
913   PHONE_EXT = 410
914 < HIRE_DATE = 5/4/1989 00:00:00.000
914 > HIRE_DATE = 1989/04/05 00:00:00.0000
915   DEPT_NO = 180
916   JOB_CODE = Mktg
917   JOB_GRADE = 3
# Line 559 | Line 923 | EMP_NO = 9
923   FIRST_NAME = Phil
924   LAST_NAME = Forest
925   PHONE_EXT = 229
926 < HIRE_DATE = 17/4/1989 00:00:00.000
926 > HIRE_DATE = 1989/04/17 00:00:00.0000
927   DEPT_NO = 622
928   JOB_CODE = Mngr
929   JOB_GRADE = 3
# Line 573 | Line 937 | EMP_NO = 8
937   FIRST_NAME = Leslie
938   LAST_NAME = Johnson
939   PHONE_EXT = 410
940 < HIRE_DATE = 31/1/2015 00:00:00.000
940 > HIRE_DATE = 2015/01/31 00:00:00.0000
941   DEPT_NO = 180
942   JOB_CODE = Mktg
943   JOB_GRADE = 3
# Line 583 | Line 947 | FULL_NAME = Johnson, Leslie
947  
948  
949  
950 + ------------------------------------------------------
951   Running Test 5: Update Returning and Activity Check
952   Opening inet://localhost/employee
953   Database Open
# Line 594 | Line 959 | EMP_NO = 8
959   FIRST_NAME = Leslie
960   LAST_NAME = Johnson
961   PHONE_EXT = 410
962 < HIRE_DATE = 31/1/2016 00:00:00.000
962 > HIRE_DATE = 2016/01/31 00:00:00.0000
963   DEPT_NO = 180
964   JOB_CODE = Mktg
965   JOB_GRADE = 3
# Line 616 | Line 981 | Transaction Active
981   Transaction inactive
982  
983  
984 + ------------------------------------------------------
985   Running Test 6: Blob Handling
986   Metadata
987   SQLType =SQL_TEXT
# Line 642 | Line 1008 | Charset id = 0
1008   Nullable
1009   Size = 2
1010  
1011 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1011 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001)
1012   RDB$CHARACTER_SET_ID = 0
1013 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1013 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001)
1014   RDB$CHARACTER_SET_ID = 1
1015 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1015 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001)
1016   RDB$CHARACTER_SET_ID = 2
1017 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1017 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001)
1018   RDB$CHARACTER_SET_ID = 3
1019 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1019 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001)
1020   RDB$CHARACTER_SET_ID = 4
1021 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1021 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001)
1022   RDB$CHARACTER_SET_ID = 5
1023 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1023 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001)
1024   RDB$CHARACTER_SET_ID = 6
1025 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1025 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001)
1026   RDB$CHARACTER_SET_ID = 9
1027 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1027 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001)
1028   RDB$CHARACTER_SET_ID = 10
1029 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1029 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001)
1030   RDB$CHARACTER_SET_ID = 11
1031 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1031 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001)
1032   RDB$CHARACTER_SET_ID = 12
1033 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1033 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001)
1034   RDB$CHARACTER_SET_ID = 13
1035 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1035 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001)
1036   RDB$CHARACTER_SET_ID = 14
1037 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1037 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001)
1038   RDB$CHARACTER_SET_ID = 15
1039 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1039 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001)
1040   RDB$CHARACTER_SET_ID = 16
1041 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1041 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001)
1042   RDB$CHARACTER_SET_ID = 17
1043 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1043 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001)
1044   RDB$CHARACTER_SET_ID = 18
1045 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1045 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001)
1046   RDB$CHARACTER_SET_ID = 19
1047 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1047 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001)
1048   RDB$CHARACTER_SET_ID = 21
1049 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1049 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001)
1050   RDB$CHARACTER_SET_ID = 22
1051 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1051 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001)
1052   RDB$CHARACTER_SET_ID = 23
1053 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1053 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001)
1054   RDB$CHARACTER_SET_ID = 34
1055 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1055 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001)
1056   RDB$CHARACTER_SET_ID = 35
1057 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1057 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001)
1058   RDB$CHARACTER_SET_ID = 36
1059 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1059 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001)
1060   RDB$CHARACTER_SET_ID = 37
1061 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1061 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001)
1062   RDB$CHARACTER_SET_ID = 38
1063 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1063 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001)
1064   RDB$CHARACTER_SET_ID = 39
1065 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1065 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001)
1066   RDB$CHARACTER_SET_ID = 40
1067 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1067 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001)
1068   RDB$CHARACTER_SET_ID = 44
1069 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1069 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001)
1070   RDB$CHARACTER_SET_ID = 45
1071 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1071 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001)
1072   RDB$CHARACTER_SET_ID = 46
1073 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1073 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001)
1074   RDB$CHARACTER_SET_ID = 47
1075 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1075 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001)
1076   RDB$CHARACTER_SET_ID = 48
1077 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1077 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001)
1078   RDB$CHARACTER_SET_ID = 49
1079 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1079 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001)
1080   RDB$CHARACTER_SET_ID = 50
1081 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1081 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001)
1082   RDB$CHARACTER_SET_ID = 51
1083 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1083 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001)
1084   RDB$CHARACTER_SET_ID = 52
1085 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1085 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001)
1086   RDB$CHARACTER_SET_ID = 53
1087 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1087 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001)
1088   RDB$CHARACTER_SET_ID = 54
1089 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1089 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001)
1090   RDB$CHARACTER_SET_ID = 55
1091 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1091 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001)
1092   RDB$CHARACTER_SET_ID = 56
1093 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1093 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001)
1094   RDB$CHARACTER_SET_ID = 57
1095 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1095 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001)
1096   RDB$CHARACTER_SET_ID = 58
1097 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1097 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001)
1098   RDB$CHARACTER_SET_ID = 59
1099 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1099 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001)
1100   RDB$CHARACTER_SET_ID = 60
1101 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1101 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001)
1102   RDB$CHARACTER_SET_ID = 63
1103 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1103 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001)
1104   RDB$CHARACTER_SET_ID = 64
1105 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1105 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001)
1106   RDB$CHARACTER_SET_ID = 65
1107 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1107 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001)
1108   RDB$CHARACTER_SET_ID = 66
1109 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1109 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001)
1110   RDB$CHARACTER_SET_ID = 67
1111 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1111 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001)
1112   RDB$CHARACTER_SET_ID = 68
1113 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31)
1113 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001)
1114   RDB$CHARACTER_SET_ID = 69
1115  
1116   Metadata
# Line 824 | Line 1190 | Scale = 0
1190   Charset id = 0
1191   Not Null
1192   Size = 4
1193 + Value = 0
1194  
1195   SQLType =SQL_VARYING
1196   sub type = 0
# Line 852 | Line 1219 | Size = 8
1219   ROWID = 1
1220   FIXEDPOINT = 20.28
1221   FLOATINGPOINT = 3.14
1222 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1222 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1223   BLOBDATA = NULL
1224  
1225   SQL Params
# Line 871 | Line 1238 | Scale = 0
1238   Charset id = 0
1239   Not Null
1240   Size = 4
1241 + Value = 0
1242  
1243   ROWID = 1
1244   FIXEDPOINT = 20.28
1245   FLOATINGPOINT = 3.14
1246 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1246 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1247   BLOBDATA (Charset Id = 4 Codepage = 65001)
1248  
1249   To be or not to be-that is the question:
# Line 923 | Line 1291 | Scale = 0
1291   Charset id = 0
1292   Not Null
1293   Size = 4
1294 + Value = 0
1295  
1296   SQLType =SQL_VARYING
1297   sub type = 0
# Line 951 | Line 1320 | Size = 8
1320   ROWID = 1
1321   FIXEDPOINT = 20.28
1322   FLOATINGPOINT = 3.14
1323 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1323 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1324   BLOBDATA (Charset Id = 4 Codepage = 65001)
1325  
1326   To be or not to be-that is the question:
# Line 993 | Line 1362 | Be all my sins remembered
1362   ROWID = 2
1363   FIXEDPOINT = NULL
1364   FLOATINGPOINT = NULL
1365 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
1365 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
1366   BLOBDATA (Charset Id = 4 Codepage = 65001)
1367  
1368   To be or not to be-that is the question:
# Line 1118 | Line 1487 | Charset id = 0
1487   Nullable
1488   Size = 2
1489  
1490 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1490 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252)
1491   RDB$CHARACTER_SET_ID = 0
1492 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1492 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252)
1493   RDB$CHARACTER_SET_ID = 1
1494 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1494 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252)
1495   RDB$CHARACTER_SET_ID = 2
1496 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1496 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252)
1497   RDB$CHARACTER_SET_ID = 3
1498 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1498 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252)
1499   RDB$CHARACTER_SET_ID = 4
1500 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1500 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252)
1501   RDB$CHARACTER_SET_ID = 5
1502 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1502 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252)
1503   RDB$CHARACTER_SET_ID = 6
1504 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1504 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252)
1505   RDB$CHARACTER_SET_ID = 9
1506 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1506 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252)
1507   RDB$CHARACTER_SET_ID = 10
1508 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1508 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252)
1509   RDB$CHARACTER_SET_ID = 11
1510 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1510 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252)
1511   RDB$CHARACTER_SET_ID = 12
1512 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1512 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252)
1513   RDB$CHARACTER_SET_ID = 13
1514 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1514 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252)
1515   RDB$CHARACTER_SET_ID = 14
1516 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1516 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252)
1517   RDB$CHARACTER_SET_ID = 15
1518 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1518 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252)
1519   RDB$CHARACTER_SET_ID = 16
1520 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1520 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252)
1521   RDB$CHARACTER_SET_ID = 17
1522 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1522 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252)
1523   RDB$CHARACTER_SET_ID = 18
1524 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1524 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252)
1525   RDB$CHARACTER_SET_ID = 19
1526 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1526 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252)
1527   RDB$CHARACTER_SET_ID = 21
1528 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1528 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252)
1529   RDB$CHARACTER_SET_ID = 22
1530 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1530 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252)
1531   RDB$CHARACTER_SET_ID = 23
1532 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1532 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252)
1533   RDB$CHARACTER_SET_ID = 34
1534 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1534 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252)
1535   RDB$CHARACTER_SET_ID = 35
1536 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1536 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252)
1537   RDB$CHARACTER_SET_ID = 36
1538 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1538 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252)
1539   RDB$CHARACTER_SET_ID = 37
1540 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1540 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252)
1541   RDB$CHARACTER_SET_ID = 38
1542 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1542 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252)
1543   RDB$CHARACTER_SET_ID = 39
1544 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1544 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252)
1545   RDB$CHARACTER_SET_ID = 40
1546 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1546 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252)
1547   RDB$CHARACTER_SET_ID = 44
1548 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1548 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252)
1549   RDB$CHARACTER_SET_ID = 45
1550 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1550 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252)
1551   RDB$CHARACTER_SET_ID = 46
1552 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1552 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252)
1553   RDB$CHARACTER_SET_ID = 47
1554 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1554 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252)
1555   RDB$CHARACTER_SET_ID = 48
1556 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1556 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252)
1557   RDB$CHARACTER_SET_ID = 49
1558 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1558 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252)
1559   RDB$CHARACTER_SET_ID = 50
1560 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1560 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252)
1561   RDB$CHARACTER_SET_ID = 51
1562 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1562 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252)
1563   RDB$CHARACTER_SET_ID = 52
1564 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1564 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252)
1565   RDB$CHARACTER_SET_ID = 53
1566 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1566 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252)
1567   RDB$CHARACTER_SET_ID = 54
1568 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1568 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252)
1569   RDB$CHARACTER_SET_ID = 55
1570 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1570 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252)
1571   RDB$CHARACTER_SET_ID = 56
1572 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1572 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252)
1573   RDB$CHARACTER_SET_ID = 57
1574 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1574 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252)
1575   RDB$CHARACTER_SET_ID = 58
1576 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1576 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252)
1577   RDB$CHARACTER_SET_ID = 59
1578 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1578 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252)
1579   RDB$CHARACTER_SET_ID = 60
1580 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1580 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252)
1581   RDB$CHARACTER_SET_ID = 63
1582 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1582 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252)
1583   RDB$CHARACTER_SET_ID = 64
1584 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1584 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252)
1585   RDB$CHARACTER_SET_ID = 65
1586 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1586 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252)
1587   RDB$CHARACTER_SET_ID = 66
1588 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1588 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252)
1589   RDB$CHARACTER_SET_ID = 67
1590 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1590 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252)
1591   RDB$CHARACTER_SET_ID = 68
1592 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31)
1592 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252)
1593   RDB$CHARACTER_SET_ID = 69
1594  
1595   Metadata
# Line 1300 | Line 1669 | Scale = 0
1669   Charset id = 0
1670   Not Null
1671   Size = 4
1672 + Value = 0
1673  
1674   SQLType =SQL_VARYING
1675   sub type = 0
# Line 1328 | Line 1698 | Size = 8
1698   ROWID = 1
1699   FIXEDPOINT = 20.28
1700   FLOATINGPOINT = 3.14
1701 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1701 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1702   BLOBDATA = NULL
1703  
1704   SQL Params
# Line 1347 | Line 1717 | Scale = 0
1717   Charset id = 0
1718   Not Null
1719   Size = 4
1720 + Value = 0
1721  
1722   ROWID = 1
1723   FIXEDPOINT = 20.28
1724   FLOATINGPOINT = 3.14
1725 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1725 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1726   BLOBDATA (Charset Id = 53 Codepage = 1252)
1727  
1728   To be or not to be-that is the question:
# Line 1399 | Line 1770 | Scale = 0
1770   Charset id = 0
1771   Not Null
1772   Size = 4
1773 + Value = 0
1774  
1775   SQLType =SQL_VARYING
1776   sub type = 0
# Line 1427 | Line 1799 | Size = 8
1799   ROWID = 1
1800   FIXEDPOINT = 20.28
1801   FLOATINGPOINT = 3.14
1802 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1802 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1803   BLOBDATA (Charset Id = 53 Codepage = 1252)
1804  
1805   To be or not to be-that is the question:
# Line 1469 | Line 1841 | Be all my sins remembered
1841   ROWID = 2
1842   FIXEDPOINT = NULL
1843   FLOATINGPOINT = NULL
1844 < TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15)
1844 > TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252)
1845   BLOBDATA (Charset Id = 53 Codepage = 1252)
1846  
1847   To be or not to be-that is the question:
# Line 1594 | Line 1966 | Charset id = 0
1966   Nullable
1967   Size = 2
1968  
1969 < RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1969 > RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001)
1970   RDB$CHARACTER_SET_ID = 0
1971 < RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1971 > RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001)
1972   RDB$CHARACTER_SET_ID = 1
1973 < RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1973 > RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001)
1974   RDB$CHARACTER_SET_ID = 2
1975 < RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1975 > RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001)
1976   RDB$CHARACTER_SET_ID = 3
1977 < RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1977 > RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001)
1978   RDB$CHARACTER_SET_ID = 4
1979 < RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1979 > RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001)
1980   RDB$CHARACTER_SET_ID = 5
1981 < RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1981 > RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001)
1982   RDB$CHARACTER_SET_ID = 6
1983 < RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1983 > RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001)
1984   RDB$CHARACTER_SET_ID = 9
1985 < RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1985 > RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001)
1986   RDB$CHARACTER_SET_ID = 10
1987 < RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1987 > RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001)
1988   RDB$CHARACTER_SET_ID = 11
1989 < RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1989 > RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001)
1990   RDB$CHARACTER_SET_ID = 12
1991 < RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1991 > RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001)
1992   RDB$CHARACTER_SET_ID = 13
1993 < RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1993 > RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001)
1994   RDB$CHARACTER_SET_ID = 14
1995 < RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1995 > RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001)
1996   RDB$CHARACTER_SET_ID = 15
1997 < RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1997 > RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001)
1998   RDB$CHARACTER_SET_ID = 16
1999 < RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
1999 > RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001)
2000   RDB$CHARACTER_SET_ID = 17
2001 < RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2001 > RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001)
2002   RDB$CHARACTER_SET_ID = 18
2003 < RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2003 > RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001)
2004   RDB$CHARACTER_SET_ID = 19
2005 < RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2005 > RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001)
2006   RDB$CHARACTER_SET_ID = 21
2007 < RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2007 > RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001)
2008   RDB$CHARACTER_SET_ID = 22
2009 < RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2009 > RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001)
2010   RDB$CHARACTER_SET_ID = 23
2011 < RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2011 > RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001)
2012   RDB$CHARACTER_SET_ID = 34
2013 < RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2013 > RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001)
2014   RDB$CHARACTER_SET_ID = 35
2015 < RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2015 > RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001)
2016   RDB$CHARACTER_SET_ID = 36
2017 < RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2017 > RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001)
2018   RDB$CHARACTER_SET_ID = 37
2019 < RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2019 > RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001)
2020   RDB$CHARACTER_SET_ID = 38
2021 < RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2021 > RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001)
2022   RDB$CHARACTER_SET_ID = 39
2023 < RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2023 > RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001)
2024   RDB$CHARACTER_SET_ID = 40
2025 < RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2025 > RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001)
2026   RDB$CHARACTER_SET_ID = 44
2027 < RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2027 > RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001)
2028   RDB$CHARACTER_SET_ID = 45
2029 < RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2029 > RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001)
2030   RDB$CHARACTER_SET_ID = 46
2031 < RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2031 > RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001)
2032   RDB$CHARACTER_SET_ID = 47
2033 < RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2033 > RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001)
2034   RDB$CHARACTER_SET_ID = 48
2035 < RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2035 > RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001)
2036   RDB$CHARACTER_SET_ID = 49
2037 < RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2037 > RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001)
2038   RDB$CHARACTER_SET_ID = 50
2039 < RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2039 > RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001)
2040   RDB$CHARACTER_SET_ID = 51
2041 < RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2041 > RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001)
2042   RDB$CHARACTER_SET_ID = 52
2043 < RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2043 > RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001)
2044   RDB$CHARACTER_SET_ID = 53
2045 < RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2045 > RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001)
2046   RDB$CHARACTER_SET_ID = 54
2047 < RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2047 > RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001)
2048   RDB$CHARACTER_SET_ID = 55
2049 < RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2049 > RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001)
2050   RDB$CHARACTER_SET_ID = 56
2051 < RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2051 > RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001)
2052   RDB$CHARACTER_SET_ID = 57
2053 < RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2053 > RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001)
2054   RDB$CHARACTER_SET_ID = 58
2055 < RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2055 > RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001)
2056   RDB$CHARACTER_SET_ID = 59
2057 < RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2057 > RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001)
2058   RDB$CHARACTER_SET_ID = 60
2059 < RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2059 > RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001)
2060   RDB$CHARACTER_SET_ID = 63
2061 < RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2061 > RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001)
2062   RDB$CHARACTER_SET_ID = 64
2063 < RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2063 > RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001)
2064   RDB$CHARACTER_SET_ID = 65
2065 < RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2065 > RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001)
2066   RDB$CHARACTER_SET_ID = 66
2067 < RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2067 > RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001)
2068   RDB$CHARACTER_SET_ID = 67
2069 < RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2069 > RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001)
2070   RDB$CHARACTER_SET_ID = 68
2071 < RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31)
2071 > RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001)
2072   RDB$CHARACTER_SET_ID = 69
2073  
2074   Metadata
# Line 1776 | Line 2148 | Scale = 0
2148   Charset id = 0
2149   Not Null
2150   Size = 4
2151 + Value = 0
2152  
2153   SQLType =SQL_VARYING
2154   sub type = 0
# Line 1804 | Line 2177 | Size = 8
2177   ROWID = 1
2178   FIXEDPOINT = 20.28
2179   FLOATINGPOINT = 3.14
2180 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2180 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2181   BLOBDATA = NULL
2182  
2183   SQL Params
# Line 1823 | Line 2196 | Scale = 0
2196   Charset id = 0
2197   Not Null
2198   Size = 4
2199 + Value = 0
2200  
2201   ROWID = 1
2202   FIXEDPOINT = 20.28
2203   FLOATINGPOINT = 3.14
2204 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2204 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2205   BLOBDATA (Charset Id = 4 Codepage = 65001)
2206  
2207   To be or not to be-that is the question:
# Line 1875 | Line 2249 | Scale = 0
2249   Charset id = 0
2250   Not Null
2251   Size = 4
2252 + Value = 0
2253  
2254   SQLType =SQL_VARYING
2255   sub type = 0
# Line 1903 | Line 2278 | Size = 8
2278   ROWID = 1
2279   FIXEDPOINT = 20.28
2280   FLOATINGPOINT = 3.14
2281 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2281 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2282   BLOBDATA (Charset Id = 4 Codepage = 65001)
2283  
2284   To be or not to be-that is the question:
# Line 1945 | Line 2320 | Be all my sins remembered
2320   ROWID = 2
2321   FIXEDPOINT = NULL
2322   FLOATINGPOINT = NULL
2323 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2323 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2324   BLOBDATA (Charset Id = 4 Codepage = 65001)
2325  
2326   To be or not to be-that is the question:
# Line 2047 | Line 2422 | Be all my sins remembered
2422  
2423  
2424  
2425 + ------------------------------------------------------
2426   Running Test 7: Create and read back an Array
2427   Metadata
2428   SQLType =SQL_LONG
# Line 2118 | Line 2494 | Column = MYARRAY
2494   Dimensions = 1
2495   Bounds: (0:16)
2496  
2497 + SQLType =SQL_ARRAY
2498 + sub type = 0
2499 + Table = TESTDATA
2500 + Owner = SYSDBA
2501 + Column Name = MYARRAY2
2502 + Alias Name = MYARRAY2
2503 + Field Name = MYARRAY2
2504 + Scale = 0
2505 + Charset id = 0
2506 + Nullable
2507 + Size = 8
2508 + Array Meta Data:
2509 + SQLType =SQL_TIMESTAMP
2510 + Scale = 0
2511 + Charset id = 0
2512 + Size = 8
2513 + Table = TESTDATA
2514 + Column = MYARRAY2
2515 + Dimensions = 1
2516 + Bounds: (0:16)
2517 +
2518 + SQLType =SQL_ARRAY
2519 + sub type = 0
2520 + Table = TESTDATA
2521 + Owner = SYSDBA
2522 + Column Name = MYARRAY3
2523 + Alias Name = MYARRAY3
2524 + Field Name = MYARRAY3
2525 + Scale = 0
2526 + Charset id = 0
2527 + Nullable
2528 + Size = 8
2529 + Array Meta Data:
2530 + SQLType =SQL_INT64
2531 + Scale = -2
2532 + Charset id = 0
2533 + Size = 8
2534 + Table = TESTDATA
2535 + Column = MYARRAY3
2536 + Dimensions = 1
2537 + Bounds: (0:16)
2538 +
2539   SQL Params
2540   SQLType =SQL_LONG
2541   sub type = 0
# Line 2126 | Line 2544 | Scale = 0
2544   Charset id = 0
2545   Not Null
2546   Size = 4
2547 + Value = 0
2548  
2549   SQLType =SQL_VARYING
2550   sub type = 0
# Line 2156 | Line 2575 | Param Name = TITLE
2575   Param Name = DATED
2576   Param Name = NOTES
2577   ROWID = 1
2578 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2579 < DATED = 1/4/2016 09:30:00.100
2580 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2578 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2579 > DATED = 2016/04/01 09:30:00.1000
2580 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2581   MYARRAY = NULL
2582 + MYARRAY2 = NULL
2583 + MYARRAY3 = NULL
2584  
2585   SQL Params
2586   SQLType =SQL_ARRAY
# Line 2170 | Line 2591 | Charset id = 0
2591   Nullable
2592   Size = 8
2593  
2594 + SQL Params
2595 + SQLType =SQL_ARRAY
2596 + sub type = 0
2597 + Field Name = MYARRAY2
2598 + Scale = 0
2599 + Charset id = 0
2600 + Nullable
2601 + Size = 8
2602 +
2603 + SQL Params
2604 + SQLType =SQL_ARRAY
2605 + sub type = 0
2606 + Field Name = MYARRAY3
2607 + Scale = 0
2608 + Charset id = 0
2609 + Nullable
2610 + Size = 8
2611 +
2612 + Metadata
2613 + SQLType =SQL_LONG
2614 + sub type = 0
2615 + Table = TESTDATA
2616 + Owner = SYSDBA
2617 + Column Name = ROWID
2618 + Alias Name = ROWID
2619 + Field Name = ROWID
2620 + Scale = 0
2621 + Charset id = 0
2622 + Not Null
2623 + Size = 4
2624 +
2625 + SQLType =SQL_VARYING
2626 + sub type = 0
2627 + Table = TESTDATA
2628 + Owner = SYSDBA
2629 + Column Name = TITLE
2630 + Alias Name = TITLE
2631 + Field Name = TITLE
2632 + Scale = 0
2633 + Charset id = 4
2634 + Nullable
2635 + Size = 128
2636 +
2637 + SQLType =SQL_TIMESTAMP
2638 + sub type = 0
2639 + Table = TESTDATA
2640 + Owner = SYSDBA
2641 + Column Name = DATED
2642 + Alias Name = DATED
2643 + Field Name = DATED
2644 + Scale = 0
2645 + Charset id = 0
2646 + Nullable
2647 + Size = 8
2648 +
2649 + SQLType =SQL_VARYING
2650 + sub type = 0
2651 + Table = TESTDATA
2652 + Owner = SYSDBA
2653 + Column Name = NOTES
2654 + Alias Name = NOTES
2655 + Field Name = NOTES
2656 + Scale = 0
2657 + Charset id = 4
2658 + Nullable
2659 + Size = 256
2660 +
2661 + SQLType =SQL_ARRAY
2662 + sub type = 0
2663 + Table = TESTDATA
2664 + Owner = SYSDBA
2665 + Column Name = MYARRAY
2666 + Alias Name = MYARRAY
2667 + Field Name = MYARRAY
2668 + Scale = 0
2669 + Charset id = 0
2670 + Nullable
2671 + Size = 8
2672 + Array Meta Data:
2673 + SQLType =SQL_LONG
2674 + Scale = 0
2675 + Charset id = 0
2676 + Size = 4
2677 + Table = TESTDATA
2678 + Column = MYARRAY
2679 + Dimensions = 1
2680 + Bounds: (0:16)
2681 +
2682 + SQLType =SQL_ARRAY
2683 + sub type = 0
2684 + Table = TESTDATA
2685 + Owner = SYSDBA
2686 + Column Name = MYARRAY2
2687 + Alias Name = MYARRAY2
2688 + Field Name = MYARRAY2
2689 + Scale = 0
2690 + Charset id = 0
2691 + Nullable
2692 + Size = 8
2693 + Array Meta Data:
2694 + SQLType =SQL_TIMESTAMP
2695 + Scale = 0
2696 + Charset id = 0
2697 + Size = 8
2698 + Table = TESTDATA
2699 + Column = MYARRAY2
2700 + Dimensions = 1
2701 + Bounds: (0:16)
2702 +
2703 + SQLType =SQL_ARRAY
2704 + sub type = 0
2705 + Table = TESTDATA
2706 + Owner = SYSDBA
2707 + Column Name = MYARRAY3
2708 + Alias Name = MYARRAY3
2709 + Field Name = MYARRAY3
2710 + Scale = 0
2711 + Charset id = 0
2712 + Nullable
2713 + Size = 8
2714 + Array Meta Data:
2715 + SQLType =SQL_INT64
2716 + Scale = -2
2717 + Charset id = 0
2718 + Size = 8
2719 + Table = TESTDATA
2720 + Column = MYARRAY3
2721 + Dimensions = 1
2722 + Bounds: (0:16)
2723 +
2724   ROWID = 1
2725 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2726 < DATED = 1/4/2016 09:30:00.100
2727 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2728 < Array: (0: 100) (1: 99) (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84)
2725 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2726 > DATED = 2016/04/01 09:30:00.1000
2727 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2728 > MYARRAY = Array: (0: 100) (1: 99) (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84)
2729 >
2730 > MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00)
2731 >
2732 > MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269)
2733 >
2734  
2735   Shrink to 2:10
2736   Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90)
2737 +
2738   Write updated reduced slice
2739   Show update array
2740   ROWID = 1
2741 < TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15)
2742 < DATED = 1/4/2016 09:30:00.100
2743 < NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11)
2744 < Array: (0: 100) (1: 99) (2: 1000) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84)
2741 > TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001)
2742 > DATED = 2016/04/01 09:30:00.1000
2743 > NOTES = Écoute moi (Charset Id = 4 Codepage = 65001)
2744 > MYARRAY = Array: (0: 100) (1: 99) (2: 1000) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84)
2745  
2746 + MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00)
2747  
2748 + MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269)
2749  
2750 +
2751 +
2752 +
2753 + ------------------------------------------------------
2754   Running Test 8: Create and read back an Array with 2 dimensions
2755   Metadata
2756   SQLType =SQL_LONG
# Line 2243 | Line 2806 | Scale = 0
2806   Charset id = 0
2807   Not Null
2808   Size = 4
2809 + Value = 0
2810  
2811   SQLType =SQL_VARYING
2812   sub type = 0
# Line 2253 | Line 2817 | Nullable
2817   Size = 128
2818  
2819   ROWID = 1
2820 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2820 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2821   MYARRAY = NULL
2822  
2823   ROWID = 1
2824 < TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8)
2825 < Array: (0,-1: A50) (0,0: A51) (0,1: A52) (0,2: A53) (0,3: A54) (0,4: A55) (0,5: A56) (0,6: A57) (0,7: A58) (1,-1: A59) (1,0: A60) (1,1: A61) (1,2: A62) (1,3: A63) (1,4: A64) (1,5: A65) (1,6: A66) (1,7: A67) (2,-1: A68) (2,0: A69) (2,1: A70) (2,2: A71) (2,3: A72) (2,4: A73) (2,5: A74) (2,6: A75) (2,7: A76) (3,-1: A77) (3,0: A78) (3,1: A79) (3,2: A80) (3,3: A81) (3,4: A82) (3,5: A83) (3,6: A84) (3,7: A85) (4,-1: A86) (4,0: A87) (4,1: A88) (4,2: A89) (4,3: A90) (4,4: A91) (4,5: A92) (4,6: A93) (4,7: A94) (5,-1: A95) (5,0: A96) (5,1: A97) (5,2: A98) (5,3: A99) (5,4: A100) (5,5: A101) (5,6: A102) (5,7: A103) (6,-1: A104) (6,0: A105) (6,1: A106) (6,2: A107) (6,3: A108) (6,4: A109) (6,5: A110) (6,6: A111) (6,7: A112) (7,-1: A113) (7,0: A114) (7,1: A115) (7,2: A116) (7,3: A117) (7,4: A118) (7,5: A119) (7,6: A120) (7,7: A121) (8,-1: A122) (8,0: A123) (8,1: A124) (8,2: A125) (8,3: A126) (8,4: A127) (8,5: A128) (8,6: A129) (8,7: A130) (9,-1: A131) (9,0: A132) (9,1: A133) (9,2: A134) (9,3: A135) (9,4: A136) (9,5: A137) (9,6: A138) (9,7: A139) (10,-1: A140) (10,0: A141) (10,1: A142) (10,2: A143) (10,3: A144) (10,4: A145) (10,5: A146) (10,6: A147) (10,7: A148) (11,-1: A149) (11,0: A150) (11,1: A151) (11,2: A152) (11,3: A153) (11,4: A154) (11,5: A155) (11,6: A156) (11,7: A157) (12,-1: A158) (12,0: A159) (12,1: A160) (12,2: A161) (12,3: A162) (12,4: A163) (12,5: A164) (12,6: A165) (12,7: A166) (13,-1: A167) (13,0: A168) (13,1: A169) (13,2: A170) (13,3: A171) (13,4: A172) (13,5: A173) (13,6: A174) (13,7: A175) (14,-1: A176) (14,0: A177) (14,1: A178) (14,2: A179) (14,3: A180) (14,4: A181) (14,5: A182) (14,6: A183) (14,7: A184) (15,-1: A185) (15,0: A186) (15,1: A187) (15,2: A188) (15,3: A189) (15,4: A190) (15,5: A191) (15,6: A192) (15,7: A193) (16,-1: A194) (16,0: A195) (16,1: A196) (16,2: A197) (16,3: A198) (16,4: A199) (16,5: A200) (16,6: A201) (16,7: A202)
2824 > TITLE = 2D Array (Charset Id = 4 Codepage = 65001)
2825 > MYARRAY = Array: (0,-1: A50) (0,0: A51) (0,1: A52) (0,2: A53) (0,3: A54) (0,4: A55) (0,5: A56) (0,6: A57) (0,7: A58) (1,-1: A59) (1,0: A60) (1,1: A61) (1,2: A62) (1,3: A63) (1,4: A64) (1,5: A65) (1,6: A66) (1,7: A67) (2,-1: A68) (2,0: A69) (2,1: A70) (2,2: A71) (2,3: A72) (2,4: A73) (2,5: A74) (2,6: A75) (2,7: A76) (3,-1: A77) (3,0: A78) (3,1: A79) (3,2: A80) (3,3: A81) (3,4: A82) (3,5: A83) (3,6: A84) (3,7: A85) (4,-1: A86) (4,0: A87) (4,1: A88) (4,2: A89) (4,3: A90) (4,4: A91) (4,5: A92) (4,6: A93) (4,7: A94) (5,-1: A95) (5,0: A96) (5,1: A97) (5,2: A98) (5,3: A99) (5,4: A100) (5,5: A101) (5,6: A102) (5,7: A103) (6,-1: A104) (6,0: A105) (6,1: A106) (6,2: A107) (6,3: A108) (6,4: A109) (6,5: A110) (6,6: A111) (6,7: A112) (7,-1: A113) (7,0: A114) (7,1: A115) (7,2: A116) (7,3: A117) (7,4: A118) (7,5: A119) (7,6: A120) (7,7: A121) (8,-1: A122) (8,0: A123) (8,1: A124) (8,2: A125) (8,3: A126) (8,4: A127) (8,5: A128) (8,6: A129) (8,7: A130) (9,-1: A131) (9,0: A132) (9,1: A133) (9,2: A134) (9,3: A135) (9,4: A136) (9,5: A137) (9,6: A138) (9,7: A139) (10,-1: A140) (10,0: A141) (10,1: A142) (10,2: A143) (10,3: A144) (10,4: A145) (10,5: A146) (10,6: A147) (10,7: A148) (11,-1: A149) (11,0: A150) (11,1: A151) (11,2: A152) (11,3: A153) (11,4: A154) (11,5: A155) (11,6: A156) (11,7: A157) (12,-1: A158) (12,0: A159) (12,1: A160) (12,2: A161) (12,3: A162) (12,4: A163) (12,5: A164) (12,6: A165) (12,7: A166) (13,-1: A167) (13,0: A168) (13,1: A169) (13,2: A170) (13,3: A171) (13,4: A172) (13,5: A173) (13,6: A174) (13,7: A175) (14,-1: A176) (14,0: A177) (14,1: A178) (14,2: A179) (14,3: A180) (14,4: A181) (14,5: A182) (14,6: A183) (14,7: A184) (15,-1: A185) (15,0: A186) (15,1: A187) (15,2: A188) (15,3: A189) (15,4: A190) (15,5: A191) (15,6: A192) (15,7: A193) (16,-1: A194) (16,0: A195) (16,1: A196) (16,2: A197) (16,3: A198) (16,4: A199) (16,5: A200) (16,6: A201) (16,7: A202)
2826  
2827  
2828  
2829 +
2830 + ------------------------------------------------------
2831   Running Test 9: Database Information tests
2832   Database ID = 4 FB = /opt/firebird3.0.5/examples/empbuild/employee.fdb SN = zeus
2833   Pages =307
# Line 2273 | Line 2839 | ODS major = 12
2839   Page Size = 8192
2840   Version = 1: LI-V6.3.5.33220 Firebird 3.0
2841   Database is Read/Write
2842 < Database Created: 9/1/2020 13:13:45
2842 > Database Created: 09/1/2020 13:13:45
2843   Pages Used = 297
2844   Pages Free = 10
2845 < Server Memory = 19195648
2845 > Server Memory = 18985136
2846   Forced Writes  = 1
2847 < Max Memory  = 19316160
2847 > Max Memory  = 19022320
2848   Num Buffers  = 2048
2849   Sweep Interval  = 20000
2850   Logged in Users: SYSDBA,
2851   Active Transaction Count = 0
2852 < Fetches  = 452
2853 < Writes  = 8
2854 < Reads  = 57
2855 < Page Writes  = 4
2852 > Fetches  = 407
2853 > Writes  = 6
2854 > Reads  = 55
2855 > Page Writes  = 3
2856   Record Version Removals Operation Counts
2857  
2858   Deletes Operation Counts
# Line 2301 | Line 2867 | Indexed Reads Count Operation Counts
2867   Table ID = 4
2868   Count = 28
2869   Table ID = 6
2870 < Count = 15
2870 > Count = 5
2871   Table ID = 9
2872 < Count = 3
2872 > Count = 1
2873   Table ID = 11
2874   Count = 1
2875   Table ID = 12
# Line 2324 | Line 2890 | Update Count Operation Counts
2890   Page Size = 8192
2891  
2892  
2893 + ------------------------------------------------------
2894   Running Test 10: Event Handling
2895   Call Async Wait
2896   Async Wait Called
2897   Event Signalled
2898   First Event - usually ignored
2899   Signal Event
2900 + Event Signalled
2901   Event Counts: TESTEVENT, Count = 1
2902   Two more events
2903   Call Async Wait
2904   Async Wait Called
2905   Event Signalled
2338 – Event Signalled
2906   Deferred Events Caught
2907   Event Counts: TESTEVENT, Count = 2
2908   Signal Event
# Line 2347 | Line 2914 | Event Cancelled
2914   Time Out - Cancel Worked!
2915   Sync wait
2916   Event Signalled
2917 < Event Counts: TESTEVENT, Count = 1
2917 > Event Counts: TESTEVENT, Count = 0
2918  
2919  
2920 + ------------------------------------------------------
2921   Running Test 11: Services API
2922 + SPB: Item Count = 2
2923 +  user_name = SYSDBA
2924 +  password = masterkey
2925 +
2926   Service Manager Version = 2
2927   Server Version = LI-V3.0.5.33220 Firebird 3.0
2928   Implementation = Firebird/Linux/AMD/Intel/x64
# Line 2372 | Line 2944 | User ID = 0
2944   Group ID = 0
2945  
2946  
2947 < Licence Info:
2376 < feature is not supported
2947 > Licence Info: Engine Code: 335544378 feature is not supported
2948   -feature is not supported
2949  
2950 < Licence Mask Info:
2380 < feature is not supported
2950 > Licence Mask Info: Engine Code: 335544378 feature is not supported
2951  
2952   Capabilities = 6
2953  
# Line 2407 | Line 2977 | Database OK
2977   Database Dropped
2978  
2979  
2980 + ------------------------------------------------------
2981   Running Test 12: Character Sets
2982   SQL Params
2983   SQLType =SQL_LONG
# Line 2416 | Line 2987 | Scale = 0
2987   Charset id = 0
2988   Not Null
2989   Size = 4
2990 + Value = 0
2991  
2992   SQLType =SQL_VARYING
2993   sub type = 0
# Line 2465 | Line 3037 | Charset id = 4
3037   Nullable
3038   Size = 16
3039  
3040 + Show Param Values
3041 + SQL Params
3042 + SQLType =SQL_LONG
3043 + sub type = 0
3044 + Field Name = ROWID
3045 + Scale = 0
3046 + Charset id = 0
3047 + Not Null
3048 + Size = 4
3049 + Value = 1
3050 +
3051 + SQLType =SQL_VARYING
3052 + sub type = 0
3053 + Field Name = TITLE
3054 + Scale = 0
3055 + Charset id = 4
3056 + Nullable
3057 + Size = 128
3058 + Value = Blob Test ©€
3059 +
3060 + SQLType =SQL_VARYING
3061 + sub type = 0
3062 + Field Name = NOTES
3063 + Scale = 0
3064 + Charset id = 4
3065 + Nullable
3066 + Size = 256
3067 + Value = Écoute moi
3068 +
3069 + SQLType =SQL_VARYING
3070 + sub type = 1
3071 + Field Name = BLOBDATA
3072 + Scale = 0
3073 + Charset id = 4
3074 + Nullable
3075 + Size = 8192
3076 + Value = Some German Special Characters like ÖÄÜöäüß
3077 +
3078 + SQLType =SQL_BLOB
3079 + sub type = 1
3080 + Field Name = BLOBDATA2
3081 + Scale = 0
3082 + Charset id = 4
3083 + Nullable
3084 + Size = 8
3085 + Value = Some German Special Characters like ÖÄÜöäüß
3086 +
3087 + SQLType =SQL_VARYING
3088 + sub type = 0
3089 + Field Name = INCLEAR
3090 + Scale = 0
3091 + Charset id = 1
3092 + Nullable
3093 + Size = 16
3094 + Value = &Test
3095  
3096 +
3097 + SQLType =SQL_VARYING
3098 + sub type = 0
3099 + Field Name = FIXEDWIDTH
3100 + Scale = 0
3101 + Charset id = 4
3102 + Nullable
3103 + Size = 16
3104 + Value = É
3105 +
3106   Connection Character Set UTF8
3107   ROWID = 1
3108 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3109 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3108 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3109 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3110   BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
3111   BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
3112 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3113 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
3112 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3113 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
3114  
3115   Connection Character Set NONE
3116   ROWID = 1
3117 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3118 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591 Byte Length = 10)
3117 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3118 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 21 Codepage = 28591)
3119   BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF  (Charset Id = 53 Codepage = 1252)
3120   BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
3121 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3122 < FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001 Byte Length = 5)
3121 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3122 > FIXEDWIDTH = C3 89  (Charset Id = 4 Codepage = 65001)
3123  
3124   Connection Character Set WIN1252
3125   ROWID = 1
3126 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252 Byte Length = 12)
3127 < NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252 Byte Length = 10)
3126 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80  (Charset Id = 53 Codepage = 1252)
3127 > NOTES = C9 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 53 Codepage = 1252)
3128   BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF  (Charset Id = 53 Codepage = 1252)
3129   BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF  (Charset Id = 53 Codepage = 1252)
3130 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3131 < FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252 Byte Length = 4)
3130 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3131 > FIXEDWIDTH = C9  (Charset Id = 53 Codepage = 1252)
3132  
3133  
3134  
3135 + ------------------------------------------------------
3136   Running Test 13: Transaction over two databases
3137   Init Database 1
3138   ROWID = 1
3139 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3140 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3139 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3140 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3141   BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
3142   BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
3143 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3143 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3144  
3145   Init Database 2
3146   ROWID = 1
3147 < TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001 Byte Length = 15)
3148 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3147 > TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
3148 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3149   BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
3150   BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
3151 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3151 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3152  
3153   ROWID = 1
3154 < TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3155 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3154 > TITLE = 44 61 74 61 62 61 73 65 31  (Charset Id = 4 Codepage = 65001)
3155 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3156   BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
3157   BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
3158 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3158 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3159  
3160   ROWID = 1
3161 < TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3162 < NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001 Byte Length = 11)
3161 > TITLE = 44 61 74 61 62 61 73 65 32  (Charset Id = 4 Codepage = 65001)
3162 > NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69  (Charset Id = 4 Codepage = 65001)
3163   BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
3164   BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F  (Charset Id = 4 Codepage = 65001)
3165 < INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535 Byte Length = 7)
3165 > INCLEAR = 1 54 65 73 74 D C3  (Charset Id = 1 Codepage = 65535)
3166  
3167  
3168  
3169 + ------------------------------------------------------
3170   Running Test 14: Non select procedures
3171   Default Character set Name = UTF8
3172   Metadata
# Line 2555 | Line 3194 | Nullable
3194   Size = 128
3195  
3196   ROWID = 1
3197 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3197 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3198  
3199   Repeat with a different execute transaction
3200  
3201   ROWID = 1
3202 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3202 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3203  
3204   Repeat with a original transaction
3205  
3206   ROWID = 1
3207 < TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7)
3207 > TITLE = Testing (Charset Id = 4 Codepage = 65001)
3208  
3209  
3210 + ------------------------------------------------------
3211   Running Test 15: Blob Handling and BPBs
3212  
3213   Testdata
3214  
3215   ROWID = 1
3216 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3216 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3217   BLOBDATA = (blob), Length = 92514
3218  
3219 + ROWID = 2
3220 + TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3221 + BLOBDATA = (blob), Length = 13
3222 + 0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3223  
3224   Testdata 2
3225  
3226   ROWID = 1
3227 < TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9)
3227 > TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3228   BLOBDATA (Charset Id = 4 Codepage = 65001)
3229  
3230   Écoute moi
3231  
3232  
3233  
3234 + ------------------------------------------------------
3235   Running Test 16: Error handling
3236   Invalid Database Name Test
3237 < Error Handled:
3237 > Error Handled: SQLCODE: -902
3238 > Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3239   I/O error during "open" operation for file "Malformed Name"
3240   -Error while trying to open file
3241   -No such file or directory
3242   Invalid User Name Test
3243 < Error Handled:
3243 > Error Handled: SQLCODE: -902
3244 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3245   Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3246   Invalid password Test
3247 < Error Handled:
3247 > Error Handled: SQLCODE: -902
3248 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3249   Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3250   Invalid Prepare SQL Test
3251 < Error Handled:
3251 > Error Handled: SQLCODE: -206
3252 > Engine Code: 335544569 Column does not belong to referenced table
3253   Dynamic SQL Error
3254   -SQL error code = -206
3255   -Column unknown
3256   -UNKNOWN_DATE
3257   -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3258   Invalid Open Cursor SQL Test
3259 < Error Handled:
3259 > Error Handled: SQLCODE: -206
3260 > Engine Code: 335544569 Column does not belong to referenced table
3261   Dynamic SQL Error
3262   -SQL error code = -206
3263   -Column unknown
# Line 2619 | Line 3269 | Invalid Param SQL Type Test
3269   Error Handled: Field "EMP_NO" not found
3270   Case sensitive Param SQL  Test
3271   Error Handled: Field "EMP_NO" not found
3272 + Stale Reference Check
3273 + First test correct usage
3274 + COUNTER = 42
3275 +
3276 + New Transaction before param set
3277 + Error Handled: This interface is no longer up-to-date
3278 + New Transaction before Open Cursor
3279 + Error Handled: This interface is no longer up-to-date
3280 + Stop Stale Reference Checks
3281 + New Transaction before param set
3282 + COUNTER = 42
3283 +
3284 + New Transaction before Open Cursor
3285 + COUNTER = 42
3286 +
3287   Invalid Server Name Test
3288 < Error Handled:
3288 > Error Handled: SQLCODE: -902
3289 > Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3290   Unable to complete network request to host "unknown".
3291   -Failed to locate host machine.
3292   -The specified name was not found in the hosts file or Domain Name Services
3293   Invalid User Name Test
3294 < Error Handled:
3294 > Error Handled: SQLCODE: -902
3295 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3296   Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3297   Invalid password Test
3298 < Error Handled:
3298 > Error Handled: SQLCODE: -902
3299 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3300   Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3301  
3302  
3303 + ------------------------------------------------------
3304 + Running Test 17: Date/Time tests and Firebird 4 extensions
3305 + FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3306 + Has Local TZ DB = FALSE
3307 +
3308 + Testdata
3309 +
3310 + Metadata
3311 + SQLType =SQL_LONG
3312 + sub type = 0
3313 + Table = TESTDATA
3314 + Owner = SYSDBA
3315 + Column Name = ROWID
3316 + Alias Name = ROWID
3317 + Field Name = ROWID
3318 + Scale = 0
3319 + Charset id = 0
3320 + Not Null
3321 + Size = 4
3322 +
3323 + SQLType =SQL_TYPE_DATE
3324 + sub type = 0
3325 + Table = TESTDATA
3326 + Owner = SYSDBA
3327 + Column Name = DATECOL
3328 + Alias Name = DATECOL
3329 + Field Name = DATECOL
3330 + Scale = 0
3331 + Charset id = 0
3332 + Nullable
3333 + Size = 4
3334 +
3335 + SQLType =SQL_TYPE_TIME
3336 + sub type = 0
3337 + Table = TESTDATA
3338 + Owner = SYSDBA
3339 + Column Name = TIMECOL
3340 + Alias Name = TIMECOL
3341 + Field Name = TIMECOL
3342 + Scale = 0
3343 + Charset id = 0
3344 + Nullable
3345 + Size = 4
3346 +
3347 + SQLType =SQL_TIMESTAMP
3348 + sub type = 0
3349 + Table = TESTDATA
3350 + Owner = SYSDBA
3351 + Column Name = TIMESTAMPCOL
3352 + Alias Name = TIMESTAMPCOL
3353 + Field Name = TIMESTAMPCOL
3354 + Scale = 0
3355 + Charset id = 0
3356 + Nullable
3357 + Size = 8
3358 +
3359 + ROWID = 1
3360 + DATECOL = 2019/04/01
3361 + TIMECOL = 11:31:05.0001
3362 + TIMESTAMPCOL = 2016/02/29 22:02:35.0001
3363 + ROWID = 2
3364 + DATECOL = 1939/09/03
3365 + TIMECOL = 15:40:00.0002
3366 + TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3367 + ROWID = 3
3368 + DATECOL = 1066/10/14
3369 + TIMECOL = 23:59:59.9994
3370 + TIMESTAMPCOL = 1918/11/11 11:11:00.0000
3371 + ROWID = 4
3372 + DATECOL = 1815/06/18
3373 + TIMECOL = 00:01:40.1115
3374 + TIMESTAMPCOL = 1945/05/08 22:10:00.0010
3375 +
3376 +
3377 + Testdata - second pass
3378 +
3379 + 1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35
3380 + 2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00
3381 + 3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00
3382 + 4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00
3383 + Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1
3384 + Skipping Firebird 4 and later test part
3385 +
3386 +
3387 + ------------------------------------------------------
3388 + Running Test 18: Firebird 4 Decfloat extensions
3389 + FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3390 + Skipping test for Firebird 4 and later
3391 +
3392 +
3393 + ------------------------------------------------------
3394 + Running Test 19: Batch Update and Insert Queries
3395 + Opening inet://localhost/employee
3396 + Skipping test for Firebird 4 and later
3397 +
3398 +
3399 + ------------------------------------------------------
3400 + Running Test 20: Stress Test IBatch interface
3401 + FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0"
3402 + Skipping test for Firebird 4 and later
3403 +
3404 +
3405 + ------------------------------------------------------
3406 + Running Test 21: Exercise setting and getting of numeric data types
3407 + 1234.567 parsed to 1234567 scale = -3
3408 + As Float =  1.2345670000000000E+003
3409 + -765.4321 parsed to -7654321 scale = -4
3410 + As Float = -7.6543209999999999E+002
3411 + 0.1 parsed to 1 scale = -1
3412 + As Float =  1.0000000000000001E-001
3413 + 0.01 parsed to 1 scale = -2
3414 + As Float =  1.0000000000000000E-002
3415 + +123 parsed to 123 scale = 0
3416 + As Float =  1.2300000000000000E+002
3417 + 1.23456E308 parsed to 123456 scale = 303
3418 + As Float =  1.2345600000000001E+308
3419 + -1.2e-02 parsed to -12 scale = -3
3420 + As Float = -1.2000000000000000E-002
3421 + 10. parsed to 10 scale = 0
3422 + As Float =  1.0000000000000000E+001
3423 + .12 parsed to 12 scale = -2
3424 + As Float =  1.2000000000000000E-001
3425 + 0.12 parsed to 12 scale = -2
3426 + As Float =  1.2000000000000000E-001
3427 + Parsing of 1.2E1.2 failed
3428 + Parsing of 1,000 failed
3429 + Parsing of 1e1e1 failed
3430 + Parsing of 1.2+3 failed
3431 + Validating Numeric Interface - IFBNumeric
3432 + Value from Currency = 9999.1235
3433 + Raw Value = 99991235 Scale = -4
3434 + Value from Currency(rescaled) = 9999.12
3435 + Raw Value = 999912 Scale = -2
3436 + Value from Double = 9999.12345678
3437 + Raw Value = 999912345678 Scale = -8
3438 + Value from Integer = 9223372036854775807
3439 + Raw Value = 9223372036854775807 Scale = 0
3440 + Value from string = 9223372036854775807
3441 + Raw Value = 9223372036854775807 Scale = 0
3442 + Value from string = 9999.12345678
3443 + Raw Value = 999912345678 Scale = -8
3444 + Value from string = -0.12
3445 + Raw Value = -12 Scale = -3
3446 + Value from BCD = 9999.12345678
3447 + Raw Value = 999912345678 Scale = -8
3448 + Value from Raw Data = 9999123.456780
3449 + Raw Value = 9999123456780 Scale = -6
3450 + Numeric Operations
3451 + Add 2.23 + 24.12345 = 26.35345
3452 + Add Double 2.23 + 24.12645 = 26.35645
3453 + Add integer 2.23 + 2412345 = 2412347.23
3454 + Subtract 2.23 - 24.12345 = -21.89345
3455 + Subtract Double 24.12645 - 2.23 = -21.89645
3456 + Subtract integer 24123.45 - 223 = -23900.45
3457 + Multiply 2.23 * 24.12345 = 53.7952935
3458 + Multiply Double 24.12645 * 2.23 = 53.8019835
3459 + Multiply integer 241.2345 * 223 = 53795.2935
3460 + Divide 24.12345 / 2.23 = 10.81769
3461 + Divide Double 2.23 / 24.12645 = 0.09
3462 + Divide integer 241.2345 / 223 = 1.0818
3463 + Compare 2.23, -24.12345 = 1
3464 + Compare integer 2.23, 3 = -1
3465 + Compare Double 2.23, 2.23 = 0
3466 + Negate 24.12345 = -24.12345
3467 + SQL Params
3468 + SQLType =SQL_LONG
3469 + sub type = 0
3470 + Field Name =
3471 + Scale = 0
3472 + Charset id = 0
3473 + Not Null
3474 + Size = 4
3475 + Value = 0
3476 +
3477 + SQLType =SQL_LONG
3478 + sub type = 0
3479 + Field Name =
3480 + Scale = 0
3481 + Charset id = 0
3482 + Nullable
3483 + Size = 4
3484 +
3485 + SQLType =SQL_INT64
3486 + sub type = 0
3487 + Field Name =
3488 + Scale = 0
3489 + Charset id = 0
3490 + Nullable
3491 + Size = 8
3492 +
3493 + SQLType =SQL_INT64
3494 + sub type = 0
3495 + Field Name =
3496 + Scale = -4
3497 + Charset id = 0
3498 + Nullable
3499 + Size = 8
3500 +
3501 + SQLType =SQL_DOUBLE
3502 + sub type = 0
3503 + Field Name =
3504 + Scale = 0
3505 + Charset id = 0
3506 + Nullable
3507 + Size = 8
3508 +
3509 + SQLType =SQL_INT64
3510 + sub type = 0
3511 + Field Name =
3512 + Scale = -6
3513 + Charset id = 0
3514 + Nullable
3515 + Size = 8
3516 +
3517 + Expected Error - SQLCODE: -303
3518 + Engine Code: 335544569 Incompatible column/host variable data type
3519 + Dynamic SQL Error
3520 + -SQL error code = -303
3521 + -conversion error from string "1,000"
3522 + Expected Error - SQLCODE: -303
3523 + Engine Code: 335544569 Incompatible column/host variable data type
3524 + Dynamic SQL Error
3525 + -SQL error code = -303
3526 + -conversion error from string "10.0.0"
3527 + Test Numeric Type
3528 + ROWID = 1
3529 + ITYPE = 101
3530 + I64TYPE = 9223372036854775807
3531 + CURRTYPE = 10,000.12340000
3532 + DTYPE = 9,999.12345678
3533 + FIXEDPOINT = 1,234,567,890.12345700
3534 + ROWID = 2
3535 + ITYPE = -32457
3536 + I64TYPE = -9223372036854775808
3537 + CURRTYPE = 1,000,001.12000000
3538 + DTYPE = 1.7E308
3539 + FIXEDPOINT = -1,234,567,890.12345700
3540 + ROWID = 3
3541 + ITYPE = 0
3542 + I64TYPE = 0
3543 + CURRTYPE = .00000000
3544 + DTYPE = .00000000
3545 + FIXEDPOINT = .00000000
3546 + ROWID = 4
3547 + ITYPE = 1
3548 + I64TYPE = 10
3549 + CURRTYPE = .02300000
3550 + DTYPE = .00110000
3551 + FIXEDPOINT = 233.45600000
3552 + ROWID = 7
3553 + ITYPE = 1
3554 + I64TYPE = 1234567
3555 + CURRTYPE = .02300000
3556 + DTYPE = .00110000
3557 + FIXEDPOINT = 1,234.25000000
3558 +
3559 +
3560 +
3561 + ------------------------------------------------------
3562 + Running Test 22: Journalling
3563 + Start Journaling. Session ID = 0
3564 + 1234.567 parsed to 1234567 scale = -3
3565 + As Float =  1.2345670000000000E+003
3566 + -765.4321 parsed to -7654321 scale = -4
3567 + As Float = -7.6543209999999999E+002
3568 + 0.1 parsed to 1 scale = -1
3569 + As Float =  1.0000000000000001E-001
3570 + 0.01 parsed to 1 scale = -2
3571 + As Float =  1.0000000000000000E-002
3572 + +123 parsed to 123 scale = 0
3573 + As Float =  1.2300000000000000E+002
3574 + 1.23456E308 parsed to 123456 scale = 303
3575 + As Float =  1.2345600000000001E+308
3576 + -1.2e-02 parsed to -12 scale = -3
3577 + As Float = -1.2000000000000000E-002
3578 + 10. parsed to 10 scale = 0
3579 + As Float =  1.0000000000000000E+001
3580 + .12 parsed to 12 scale = -2
3581 + As Float =  1.2000000000000000E-001
3582 + 0.12 parsed to 12 scale = -2
3583 + As Float =  1.2000000000000000E-001
3584 + Parsing of 1.2E1.2 failed
3585 + Parsing of 1,000 failed
3586 + Parsing of 1e1e1 failed
3587 + Parsing of 1.2+3 failed
3588 + SQL Params
3589 + SQLType =SQL_LONG
3590 + sub type = 0
3591 + Field Name =
3592 + Scale = 0
3593 + Charset id = 0
3594 + Not Null
3595 + Size = 4
3596 + Value = 0
3597 +
3598 + SQLType =SQL_LONG
3599 + sub type = 0
3600 + Field Name =
3601 + Scale = 0
3602 + Charset id = 0
3603 + Nullable
3604 + Size = 4
3605 +
3606 + SQLType =SQL_INT64
3607 + sub type = 0
3608 + Field Name =
3609 + Scale = 0
3610 + Charset id = 0
3611 + Nullable
3612 + Size = 8
3613 +
3614 + SQLType =SQL_INT64
3615 + sub type = 0
3616 + Field Name =
3617 + Scale = -4
3618 + Charset id = 0
3619 + Nullable
3620 + Size = 8
3621 +
3622 + SQLType =SQL_DOUBLE
3623 + sub type = 0
3624 + Field Name =
3625 + Scale = 0
3626 + Charset id = 0
3627 + Nullable
3628 + Size = 8
3629 +
3630 + SQLType =SQL_INT64
3631 + sub type = 0
3632 + Field Name =
3633 + Scale = -6
3634 + Charset id = 0
3635 + Nullable
3636 + Size = 8
3637 +
3638 +
3639 + Text Tests
3640 + SQL Params
3641 + SQLType =SQL_LONG
3642 + sub type = 0
3643 + Field Name =
3644 + Scale = 0
3645 + Charset id = 0
3646 + Not Null
3647 + Size = 4
3648 + Value = 0
3649 +
3650 + SQLType =SQL_VARYING
3651 + sub type = 0
3652 + Field Name =
3653 + Scale = 0
3654 + Charset id = 4
3655 + Nullable
3656 + Size = 1024
3657 +
3658 + SQLType =SQL_BLOB
3659 + sub type = 1
3660 + Field Name =
3661 + Scale = 0
3662 + Charset id = 4
3663 + Nullable
3664 + Size = 8
3665 +
3666 +
3667 + Binary Blob Tests
3668 +
3669 + Array Test
3670 + SQL Params
3671 + SQLType =SQL_LONG
3672 + sub type = 0
3673 + Field Name =
3674 + Scale = 0
3675 + Charset id = 0
3676 + Not Null
3677 + Size = 4
3678 + Value = 0
3679 +
3680 + SQLType =SQL_ARRAY
3681 + sub type = 0
3682 + Field Name =
3683 + Scale = 0
3684 + Charset id = 0
3685 + Nullable
3686 + Size = 8
3687 +
3688 + ROWID = 1
3689 + ITYPE = 101
3690 + I64TYPE = 9223372036854775807
3691 + CURRTYPE = 10,000.12340000
3692 + DTYPE = 9,999.12345678
3693 + FIXEDPOINT = 1,234,567,890.12345700
3694 + STR = NULL
3695 + TEXTBLOB = NULL
3696 + OTHERBLOB = NULL
3697 + MYARRAY = NULL
3698 + ROWID = 2
3699 + ITYPE = -32457
3700 + I64TYPE = -9223372036854775808
3701 + CURRTYPE = 1,000,001.12000000
3702 + DTYPE = 1.7E308
3703 + FIXEDPOINT = -1,234,567,890.12345700
3704 + STR = NULL
3705 + TEXTBLOB = NULL
3706 + OTHERBLOB = NULL
3707 + MYARRAY = NULL
3708 + ROWID = 4
3709 + ITYPE = 1
3710 + I64TYPE = 10
3711 + CURRTYPE = .02300000
3712 + DTYPE = .00110000
3713 + FIXEDPOINT = 233.45600000
3714 + STR = NULL
3715 + TEXTBLOB = NULL
3716 + OTHERBLOB = NULL
3717 + MYARRAY = NULL
3718 +
3719 + Journal Table
3720 + IBX$SESSIONID = 1
3721 + IBX$TRANSACTIONID = 8
3722 + IBX$OLDTRANSACTIONID = NULL
3723 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3724 + IBX$CREATED = 2022/01/14 23:02:04.2320
3725 + IBX$SESSIONID = 1
3726 + IBX$TRANSACTIONID = 10
3727 + IBX$OLDTRANSACTIONID = 9
3728 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3729 + IBX$CREATED = 2022/01/14 23:02:04.6690
3730 +
3731 + Journal Entries
3732 + Journal Entry = jeTransStart(Transaction Start)
3733 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3734 + Attachment ID = 6
3735 + Session ID = 1
3736 + Transaction ID = 8
3737 + Transaction Name = "Transaction_29_1"
3738 + TPB: Item Count = 3
3739 +  isc_tpb_write
3740 +  isc_tpb_nowait
3741 +  isc_tpb_concurrency
3742 +
3743 + Default Completion = TACommit
3744 +
3745 + Journal Entry = jeQuery(Query)
3746 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3747 + Attachment ID = 6
3748 + Session ID = 1
3749 + Transaction ID = 8
3750 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3751 +
3752 + Journal Entry = jeQuery(Query)
3753 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3754 + Attachment ID = 6
3755 + Session ID = 1
3756 + Transaction ID = 8
3757 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3758 +
3759 + Journal Entry = jeTransCommitRet(Commit Retaining)
3760 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3761 + Attachment ID = 6
3762 + Session ID = 1
3763 + Transaction ID = 9
3764 + Old TransactionID = 8
3765 +
3766 + Journal Entry = jeQuery(Query)
3767 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3768 + Attachment ID = 6
3769 + Session ID = 1
3770 + Transaction ID = 9
3771 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3772 +
3773 + Journal Entry = jeTransRollbackRet(Rollback Retaining)
3774 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3775 + Attachment ID = 6
3776 + Session ID = 1
3777 + Transaction ID = 10
3778 + Old TransactionID = 9
3779 +
3780 + Journal Entry = jeQuery(Query)
3781 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3782 + Attachment ID = 6
3783 + Session ID = 1
3784 + Transaction ID = 10
3785 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3786 +
3787 + Journal Entry = jeTransStart(Transaction Start)
3788 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3789 + Attachment ID = 6
3790 + Session ID = 1
3791 + Transaction ID = 11
3792 + Transaction Name = "Transaction_29_2"
3793 + TPB: Item Count = 3
3794 +  isc_tpb_write
3795 +  isc_tpb_nowait
3796 +  isc_tpb_concurrency
3797 +
3798 + Default Completion = TARollback
3799 +
3800 + Journal Entry = jeTransCommit(Commit)
3801 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3802 + Attachment ID = 6
3803 + Session ID = 1
3804 + Transaction ID = 10
3805 +
3806 + Journal Entry = jeQuery(Query)
3807 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3808 + Attachment ID = 6
3809 + Session ID = 1
3810 + Transaction ID = 11
3811 + 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:
3812 + Whether ''tis nobler in the mind to suffer
3813 + The slings and arrows of outrageous fortune,
3814 + Or to take arms against a sea of troubles,
3815 + And, by opposing, end them. To die, to sleep-
3816 + No more-and by a sleep to say we end
3817 + The heartache and the thousand natural shocks
3818 + That flesh is heir to-''tis a consummation
3819 + Devoutly to be wished. To die, to sleep-
3820 + To sleep, perchance to dream. Aye, there''s the rub,
3821 + For in that sleep of death what dreams may come,
3822 + When we have shuffled off this mortal coil,
3823 + Must give us pause. There''s the respect
3824 + That makes calamity of so long life.
3825 + For who would bear the whips and scorns of time,
3826 + Th'' oppressor''s wrong, the proud man''s contumely,
3827 + The pangs of despised love, the law’s delay,
3828 + The insolence of office, and the spurns
3829 + That patient merit of the unworthy takes,
3830 + When he himself might his quietus make
3831 + With a bare bodkin? Who would fardels bear,
3832 + To grunt and sweat under a weary life,
3833 + But that the dread of something after death,
3834 + The undiscovered country from whose bourn
3835 + No traveler returns, puzzles the will
3836 + And makes us rather bear those ills we have
3837 + Than fly to others that we know not of?
3838 + Thus conscience does make cowards of us all,
3839 + And thus the native hue of resolution
3840 + Is sicklied o''er with the pale cast of thought,
3841 + And enterprises of great pitch and moment,
3842 + With this regard their currents turn awry,
3843 + And lose the name of action.-Soft you now,
3844 + The fair Ophelia.-Nymph, in thy orisons
3845 + Be all my sins remembered
3846 + ')
3847 +
3848 + Journal Entry = jeQuery(Query)
3849 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3850 + Attachment ID = 6
3851 + Session ID = 1
3852 + Transaction ID = 11
3853 + Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3854 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3855 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
3856 + 01000000010000001A01050001000000DA000000
3857 + </blob>
3858 + )
3859 +
3860 + Journal Entry = jeQuery(Query)
3861 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3862 + Attachment ID = 6
3863 + Session ID = 1
3864 + Transaction ID = 11
3865 + 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">
3866 + <elt ix="0">100</elt>
3867 + <elt ix="1">99</elt>
3868 + <elt ix="2">98</elt>
3869 + <elt ix="3">97</elt>
3870 + <elt ix="4">96</elt>
3871 + <elt ix="5">95</elt>
3872 + <elt ix="6">94</elt>
3873 + <elt ix="7">93</elt>
3874 + <elt ix="8">92</elt>
3875 + <elt ix="9">91</elt>
3876 + <elt ix="10">90</elt>
3877 + <elt ix="11">89</elt>
3878 + <elt ix="12">88</elt>
3879 + <elt ix="13">87</elt>
3880 + <elt ix="14">86</elt>
3881 + <elt ix="15">85</elt>
3882 + <elt ix="16">84</elt>
3883 + </array>
3884 + )
3885 +
3886 + Journal Entry = jeTransRollback(Rollback)
3887 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3888 + Attachment ID = 6
3889 + Session ID = 1
3890 + Transaction ID = 11
3891 +
3892 +
3893 +
3894 + ------------------------------------------------------
3895   Test Suite Ends

Diff Legend

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