3 |
|
|
4 |
|
Starting Tests |
5 |
|
Client API Version = 4.0 |
6 |
< |
Firebird Environment Variable = /opt/firebird4rc1 |
7 |
< |
Firebird Bin Directory = /opt/firebird4rc1/bin |
8 |
< |
Firebird Conf Directory = /opt/firebird4rc1/ |
9 |
< |
Firebird Client Library Path = /opt/firebird4rc1/lib/libfbclient.so |
6 |
> |
Firebird Environment Variable = /opt/firebird4.0.0 |
7 |
> |
Firebird Bin Directory = /opt/firebird4.0.0/bin |
8 |
> |
Firebird Conf Directory = /opt/firebird4.0.0/ |
9 |
> |
Firebird Client Library Path = /opt/firebird4.0.0/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): I/O error during "open O_CREAT" operation for file "" |
22 |
|
DB ODS Major Version = 13 |
23 |
|
DB ODS Minor Version = 0 |
24 |
|
User Authentication Method = Srp256 |
25 |
< |
Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so |
25 |
> |
Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
26 |
|
DB Client Implementation Version = 4.0 |
27 |
|
DPB: Item Count = 3 |
28 |
|
isc_dpb_user_name = SYSDBA |
30 |
|
isc_dpb_set_db_sql_dialect = 3 |
31 |
|
|
32 |
|
Firebird Server Version Info |
33 |
< |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1" |
34 |
< |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:C" |
35 |
< |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:C" |
33 |
> |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
34 |
> |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C" |
35 |
> |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C" |
36 |
|
on disk structure version 13.0 |
37 |
|
|
38 |
|
Dropping Database |
44 |
|
DB ODS Major Version = 13 |
45 |
|
DB ODS Minor Version = 0 |
46 |
|
User Authentication Method = Srp256 |
47 |
< |
Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so |
47 |
> |
Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
48 |
|
DB Client Implementation Version = 4.0 |
49 |
|
Dropping Database |
50 |
|
DPB: Item Count = 4 |
64 |
|
DB ODS Major Version = 13 |
65 |
|
DB ODS Minor Version = 0 |
66 |
|
User Authentication Method = Srp256 |
67 |
< |
Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so |
67 |
> |
Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
68 |
|
DB Client Implementation Version = 4.0 |
69 |
|
RDB$DESCRIPTION = |
70 |
|
RDB$RELATION_ID = 128 |
71 |
< |
RDB$SECURITY_CLASS = SQL$384 |
71 |
> |
RDB$SECURITY_CLASS = SQL$385 |
72 |
|
RDB$CHARACTER_SET_NAME = UTF8 |
73 |
|
RDB$LINGER = |
74 |
|
RDB$SQL_SECURITY = |
77 |
|
|
78 |
|
------------------------------------------------------ |
79 |
|
Running Test 2: Open the employee database and run a query |
80 |
+ |
Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
81 |
|
Opening inet://localhost/employee |
82 |
|
Database Open, SQL Dialect = 3 |
83 |
|
TPB: Item Count = 3 |
268 |
|
Charset id = 0 |
269 |
|
Not Null |
270 |
|
Size = 2 |
271 |
+ |
Value = 0 |
272 |
|
|
273 |
|
EMP_NO = 8 |
274 |
|
FIRST_NAME = Leslie |
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 |
496 |
|
Charset id = 0 |
497 |
|
Not Null |
498 |
|
Size = 2 |
499 |
+ |
Value = 0 |
500 |
|
|
501 |
|
EMP_NO = 8 |
502 |
|
FIRST_NAME = Leslie |
520 |
|
Charset id = 0 |
521 |
|
Not Null |
522 |
|
Size = 2 |
523 |
+ |
Value = 0 |
524 |
|
|
525 |
+ |
Results for Cursor: Test Cursor |
526 |
|
EMP_NO = 8 |
527 |
|
FIRST_NAME = Leslie |
528 |
|
LAST_NAME = Johnson |
535 |
|
SALARY = 64,635.00 |
536 |
|
FULL_NAME = Johnson, Leslie |
537 |
|
|
538 |
+ |
Scollable Cursors |
539 |
+ |
DB Connect String = employee |
540 |
+ |
DB Charset ID = 4 |
541 |
+ |
DB SQL Dialect = 3 |
542 |
+ |
DB Remote Protocol = |
543 |
+ |
DB ODS Major Version = 13 |
544 |
+ |
DB ODS Minor Version = 0 |
545 |
+ |
User Authentication Method = User name in DPB |
546 |
+ |
Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
547 |
+ |
DB Client Implementation Version = 4.0 |
548 |
+ |
Do Fetch Next: |
549 |
+ |
EMP_NO = 2 |
550 |
+ |
FIRST_NAME = Robert |
551 |
+ |
LAST_NAME = Nelson |
552 |
+ |
PHONE_EXT = 250 |
553 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
554 |
+ |
DEPT_NO = 600 |
555 |
+ |
JOB_CODE = VP |
556 |
+ |
JOB_GRADE = 2 |
557 |
+ |
JOB_COUNTRY = USA |
558 |
+ |
SALARY = 105,900.00 |
559 |
+ |
FULL_NAME = Nelson, Robert |
560 |
+ |
Do Fetch Last: |
561 |
+ |
EMP_NO = 145 |
562 |
+ |
FIRST_NAME = Mark |
563 |
+ |
LAST_NAME = Guckenheimer |
564 |
+ |
PHONE_EXT = 221 |
565 |
+ |
HIRE_DATE = 1994/05/02 00:00:00.0000 |
566 |
+ |
DEPT_NO = 622 |
567 |
+ |
JOB_CODE = Eng |
568 |
+ |
JOB_GRADE = 5 |
569 |
+ |
JOB_COUNTRY = USA |
570 |
+ |
SALARY = 32,000.00 |
571 |
+ |
FULL_NAME = Guckenheimer, Mark |
572 |
+ |
Do Fetch Prior: |
573 |
+ |
EMP_NO = 144 |
574 |
+ |
FIRST_NAME = John |
575 |
+ |
LAST_NAME = Montgomery |
576 |
+ |
PHONE_EXT = 820 |
577 |
+ |
HIRE_DATE = 1994/03/30 00:00:00.0000 |
578 |
+ |
DEPT_NO = 672 |
579 |
+ |
JOB_CODE = Eng |
580 |
+ |
JOB_GRADE = 5 |
581 |
+ |
JOB_COUNTRY = USA |
582 |
+ |
SALARY = 35,000.00 |
583 |
+ |
FULL_NAME = Montgomery, John |
584 |
+ |
Do Fetch First: |
585 |
+ |
EMP_NO = 2 |
586 |
+ |
FIRST_NAME = Robert |
587 |
+ |
LAST_NAME = Nelson |
588 |
+ |
PHONE_EXT = 250 |
589 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
590 |
+ |
DEPT_NO = 600 |
591 |
+ |
JOB_CODE = VP |
592 |
+ |
JOB_GRADE = 2 |
593 |
+ |
JOB_COUNTRY = USA |
594 |
+ |
SALARY = 105,900.00 |
595 |
+ |
FULL_NAME = Nelson, Robert |
596 |
+ |
Do Fetch Abs 8 : |
597 |
+ |
EMP_NO = 14 |
598 |
+ |
FIRST_NAME = Stewart |
599 |
+ |
LAST_NAME = Hall |
600 |
+ |
PHONE_EXT = 227 |
601 |
+ |
HIRE_DATE = 1990/06/04 00:00:00.0000 |
602 |
+ |
DEPT_NO = 900 |
603 |
+ |
JOB_CODE = Finan |
604 |
+ |
JOB_GRADE = 3 |
605 |
+ |
JOB_COUNTRY = USA |
606 |
+ |
SALARY = 69,482.63 |
607 |
+ |
FULL_NAME = Hall, Stewart |
608 |
+ |
Do Fetch Relative -2 : |
609 |
+ |
EMP_NO = 11 |
610 |
+ |
FIRST_NAME = K. J. |
611 |
+ |
LAST_NAME = Weston |
612 |
+ |
PHONE_EXT = 34 |
613 |
+ |
HIRE_DATE = 1990/01/17 00:00:00.0000 |
614 |
+ |
DEPT_NO = 130 |
615 |
+ |
JOB_CODE = SRep |
616 |
+ |
JOB_GRADE = 4 |
617 |
+ |
JOB_COUNTRY = USA |
618 |
+ |
SALARY = 86,292.94 |
619 |
+ |
FULL_NAME = Weston, K. J. |
620 |
+ |
Do Fetch beyond EOF : |
621 |
+ |
Fetch returned false |
622 |
|
|
623 |
|
|
624 |
|
------------------------------------------------------ |
639 |
|
Running Test 4: Update, Insert and Delete Queries |
640 |
|
Opening inet://localhost/employee |
641 |
|
Database Open |
642 |
< |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1" |
643 |
< |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ" |
644 |
< |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ" |
642 |
> |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
643 |
> |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
644 |
> |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
645 |
|
on disk structure version 13.0 |
646 |
|
Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0 |
647 |
|
EMP_NO = 8 |
656 |
|
SALARY = 64,635.00 |
657 |
|
FULL_NAME = Johnson, Leslie |
658 |
|
|
659 |
< |
Current memory = 19,747,376 |
659 |
> |
Current memory = 19,764,272 |
660 |
|
Delta memory = 4,464 |
661 |
< |
Max memory = 19,793,248 |
661 |
> |
Max memory = 19,809,888 |
662 |
|
Elapsed time= 0.002 sec |
663 |
|
Cpu = 0.000 sec |
664 |
|
Buffers = 2048 |
1158 |
|
Charset id = 0 |
1159 |
|
Not Null |
1160 |
|
Size = 4 |
1161 |
+ |
Value = 0 |
1162 |
|
|
1163 |
|
SQLType =SQL_VARYING |
1164 |
|
sub type = 0 |
1206 |
|
Charset id = 0 |
1207 |
|
Not Null |
1208 |
|
Size = 4 |
1209 |
+ |
Value = 0 |
1210 |
|
|
1211 |
|
ROWID = 1 |
1212 |
|
FIXEDPOINT = 20.28 |
1259 |
|
Charset id = 0 |
1260 |
|
Not Null |
1261 |
|
Size = 4 |
1262 |
+ |
Value = 0 |
1263 |
|
|
1264 |
|
SQLType =SQL_VARYING |
1265 |
|
sub type = 0 |
1637 |
|
Charset id = 0 |
1638 |
|
Not Null |
1639 |
|
Size = 4 |
1640 |
+ |
Value = 0 |
1641 |
|
|
1642 |
|
SQLType =SQL_VARYING |
1643 |
|
sub type = 0 |
1685 |
|
Charset id = 0 |
1686 |
|
Not Null |
1687 |
|
Size = 4 |
1688 |
+ |
Value = 0 |
1689 |
|
|
1690 |
|
ROWID = 1 |
1691 |
|
FIXEDPOINT = 20.28 |
1738 |
|
Charset id = 0 |
1739 |
|
Not Null |
1740 |
|
Size = 4 |
1741 |
+ |
Value = 0 |
1742 |
|
|
1743 |
|
SQLType =SQL_VARYING |
1744 |
|
sub type = 0 |
2116 |
|
Charset id = 0 |
2117 |
|
Not Null |
2118 |
|
Size = 4 |
2119 |
+ |
Value = 0 |
2120 |
|
|
2121 |
|
SQLType =SQL_VARYING |
2122 |
|
sub type = 0 |
2164 |
|
Charset id = 0 |
2165 |
|
Not Null |
2166 |
|
Size = 4 |
2167 |
+ |
Value = 0 |
2168 |
|
|
2169 |
|
ROWID = 1 |
2170 |
|
FIXEDPOINT = 20.28 |
2217 |
|
Charset id = 0 |
2218 |
|
Not Null |
2219 |
|
Size = 4 |
2220 |
+ |
Value = 0 |
2221 |
|
|
2222 |
|
SQLType =SQL_VARYING |
2223 |
|
sub type = 0 |
2512 |
|
Charset id = 0 |
2513 |
|
Not Null |
2514 |
|
Size = 4 |
2515 |
+ |
Value = 0 |
2516 |
|
|
2517 |
|
SQLType =SQL_VARYING |
2518 |
|
sub type = 0 |
2697 |
|
|
2698 |
|
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) |
2699 |
|
|
2700 |
< |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79) |
2700 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.45) (16: 4269) |
2701 |
|
|
2702 |
|
|
2703 |
|
Shrink to 2:10 |
2713 |
|
|
2714 |
|
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) |
2715 |
|
|
2716 |
< |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79) |
2716 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.45) (16: 4269) |
2717 |
|
|
2718 |
|
|
2719 |
|
|
2774 |
|
Charset id = 0 |
2775 |
|
Not Null |
2776 |
|
Size = 4 |
2777 |
+ |
Value = 0 |
2778 |
|
|
2779 |
|
SQLType =SQL_VARYING |
2780 |
|
sub type = 0 |
2797 |
|
|
2798 |
|
------------------------------------------------------ |
2799 |
|
Running Test 9: Database Information tests |
2800 |
< |
Database ID = 4 FB = /opt/firebird4rc1/examples/empbuild/employee.fdb SN = zeus |
2801 |
< |
Pages =346 |
2800 |
> |
Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus |
2801 |
> |
Pages =1075 |
2802 |
|
Base Level = 13,4,0,3, |
2803 |
|
Implementation = 11,7,0,3,66,1,66, |
2804 |
|
Reserved = 0 |
2805 |
|
ODS minor = 0 |
2806 |
|
ODS major = 13 |
2807 |
|
Page Size = 8192 |
2808 |
< |
Version = 1: LI-V6.3.0.2353 Firebird 4.0 Release Candidate 1 |
2808 |
> |
Version = 1: LI-V6.3.0.2496 Firebird 4.0 |
2809 |
|
Database is Read/Write |
2810 |
< |
Database Created: 01/2/2021 14:57:08 |
2810 |
> |
Database Created: 29/5/2021 16:47:30 |
2811 |
|
Pages Used = 310 |
2812 |
< |
Pages Free = 36 |
2813 |
< |
Server Memory = 19466032 |
2812 |
> |
Pages Free = 765 |
2813 |
> |
Server Memory = 19482272 |
2814 |
|
Forced Writes = 1 |
2815 |
< |
Max Memory = 19612048 |
2815 |
> |
Max Memory = 19628544 |
2816 |
|
Num Buffers = 2048 |
2817 |
|
Sweep Interval = 20000 |
2818 |
|
Logged in Users: SYSDBA, |
2819 |
|
Active Transaction Count = 0 |
2820 |
< |
Fetches = 1634 |
2820 |
> |
Fetches = 1641 |
2821 |
|
Writes = 8 |
2822 |
< |
Reads = 91 |
2822 |
> |
Reads = 92 |
2823 |
|
Page Writes = 4 |
2824 |
|
Record Version Removals Operation Counts |
2825 |
|
|
2843 |
|
Table ID = 12 |
2844 |
|
Count = 24 |
2845 |
|
Table ID = 18 |
2846 |
< |
Count = 805 |
2846 |
> |
Count = 811 |
2847 |
|
Table ID = 20 |
2848 |
|
Count = 5 |
2849 |
|
Table ID = 28 |
2898 |
|
password = masterkey |
2899 |
|
|
2900 |
|
Service Manager Version = 2 |
2901 |
< |
Server Version = LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1 |
2901 |
> |
Server Version = LI-V4.0.0.2496 Firebird 4.0 |
2902 |
|
Implementation = Firebird/Linux/AMD/Intel/x64 |
2903 |
|
|
2904 |
|
Lock Directory = /tmp/firebird/ |
2905 |
< |
Message File = /opt/firebird4rc1/ |
2906 |
< |
Security File = /opt/firebird4rc1/security4.fdb |
2905 |
> |
Message File = /opt/firebird4.0.0/ |
2906 |
> |
Security File = /opt/firebird4.0.0/security4.fdb |
2907 |
|
|
2908 |
|
DB Attachments |
2909 |
|
No. of Attachments = 0 |
2961 |
|
Charset id = 0 |
2962 |
|
Not Null |
2963 |
|
Size = 4 |
2964 |
+ |
Value = 0 |
2965 |
|
|
2966 |
|
SQLType =SQL_VARYING |
2967 |
|
sub type = 0 |
3011 |
|
Nullable |
3012 |
|
Size = 16 |
3013 |
|
|
3014 |
+ |
Show Param Values |
3015 |
+ |
SQL Params |
3016 |
+ |
SQLType =SQL_LONG |
3017 |
+ |
sub type = 0 |
3018 |
+ |
Field Name = ROWID |
3019 |
+ |
Scale = 0 |
3020 |
+ |
Charset id = 0 |
3021 |
+ |
Not Null |
3022 |
+ |
Size = 4 |
3023 |
+ |
Value = 1 |
3024 |
+ |
|
3025 |
+ |
SQLType =SQL_VARYING |
3026 |
+ |
sub type = 0 |
3027 |
+ |
Field Name = TITLE |
3028 |
+ |
Scale = 0 |
3029 |
+ |
Charset id = 4 |
3030 |
+ |
Nullable |
3031 |
+ |
Size = 128 |
3032 |
+ |
Value = Blob Test ©€ |
3033 |
+ |
|
3034 |
+ |
SQLType =SQL_VARYING |
3035 |
+ |
sub type = 0 |
3036 |
+ |
Field Name = NOTES |
3037 |
+ |
Scale = 0 |
3038 |
+ |
Charset id = 4 |
3039 |
+ |
Nullable |
3040 |
+ |
Size = 256 |
3041 |
+ |
Value = Écoute moi |
3042 |
+ |
|
3043 |
+ |
SQLType =SQL_VARYING |
3044 |
+ |
sub type = 1 |
3045 |
+ |
Field Name = BLOBDATA |
3046 |
+ |
Scale = 0 |
3047 |
+ |
Charset id = 4 |
3048 |
+ |
Nullable |
3049 |
+ |
Size = 8192 |
3050 |
+ |
Value = Some German Special Characters like ÖÄÜöäüß |
3051 |
+ |
|
3052 |
+ |
SQLType =SQL_BLOB |
3053 |
+ |
sub type = 1 |
3054 |
+ |
Field Name = BLOBDATA2 |
3055 |
+ |
Scale = 0 |
3056 |
+ |
Charset id = 4 |
3057 |
+ |
Nullable |
3058 |
+ |
Size = 8 |
3059 |
+ |
Value = Some German Special Characters like ÖÄÜöäüß |
3060 |
+ |
|
3061 |
+ |
SQLType =SQL_VARYING |
3062 |
+ |
sub type = 0 |
3063 |
+ |
Field Name = INCLEAR |
3064 |
+ |
Scale = 0 |
3065 |
+ |
Charset id = 1 |
3066 |
+ |
Nullable |
3067 |
+ |
Size = 16 |
3068 |
+ |
Value = &Test |
3069 |
|
|
3070 |
+ |
|
3071 |
+ |
SQLType =SQL_VARYING |
3072 |
+ |
sub type = 0 |
3073 |
+ |
Field Name = FIXEDWIDTH |
3074 |
+ |
Scale = 0 |
3075 |
+ |
Charset id = 4 |
3076 |
+ |
Nullable |
3077 |
+ |
Size = 16 |
3078 |
+ |
Value = É |
3079 |
+ |
|
3080 |
|
Connection Character Set UTF8 |
3081 |
|
ROWID = 1 |
3082 |
|
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
3190 |
|
TITLE = Blob Test (Charset Id = 4 Codepage = 65001) |
3191 |
|
BLOBDATA = (blob), Length = 92514 |
3192 |
|
|
3193 |
+ |
ROWID = 2 |
3194 |
+ |
TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001) |
3195 |
+ |
BLOBDATA = (blob), Length = 13 |
3196 |
+ |
0 9 A C9 63 6F 75 74 65 20 6D 6F 69 |
3197 |
|
|
3198 |
|
Testdata 2 |
3199 |
|
|
3233 |
|
Error Handled: Field "EMP_NO" not found |
3234 |
|
Case sensitive Param SQL Test |
3235 |
|
Error Handled: Field "EMP_NO" not found |
3236 |
+ |
Stale Reference Check |
3237 |
+ |
First test correct usage |
3238 |
+ |
COUNTER = 42 |
3239 |
+ |
|
3240 |
+ |
New Transaction before param set |
3241 |
+ |
Error Handled: This interface is no longer up-to-date |
3242 |
+ |
New Transaction before Open Cursor |
3243 |
+ |
Error Handled: This interface is no longer up-to-date |
3244 |
+ |
Stop Stale Reference Checks |
3245 |
+ |
New Transaction before param set |
3246 |
+ |
COUNTER = 42 |
3247 |
+ |
|
3248 |
+ |
New Transaction before Open Cursor |
3249 |
+ |
COUNTER = 42 |
3250 |
+ |
|
3251 |
|
Invalid Server Name Test |
3252 |
|
Error Handled: Unable to complete network request to host "unknown". |
3253 |
|
-Failed to locate host machine. |
3260 |
|
|
3261 |
|
------------------------------------------------------ |
3262 |
|
Running Test 17: Date/Time tests and Firebird 4 extensions |
3263 |
< |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1" |
3263 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
3264 |
|
Has Local TZ DB = TRUE |
3265 |
|
|
3266 |
|
Testdata |
4022 |
|
|
4023 |
|
------------------------------------------------------ |
4024 |
|
Running Test 18: Firebird 4 Decfloat extensions |
4025 |
< |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1" |
4025 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
4026 |
|
|
4027 |
|
FB4 Testdata_DECFloat |
4028 |
|
|
4124 |
|
Special = 0 |
4125 |
|
Places = 0 |
4126 |
|
Digits = 12 34 56 78 91 23 45 67 89 |
4127 |
+ |
|
4128 |
|
RowID = 2 |
4129 |
|
Float16 = -64000000000.01 |
4130 |
|
Precision = 13 |
4145 |
|
Places = 6 |
4146 |
|
Digits = 12 34 56 12 34 56 12 34 56 |
4147 |
|
BigInteger = Null |
4148 |
+ |
|
4149 |
|
RowID = 3 |
4150 |
|
Float16 = 64100000000.011 |
4151 |
|
Precision = 14 |
4172 |
|
Places = 4 |
4173 |
|
Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35 |
4174 |
|
BigInteger = Null |
4175 |
+ |
|
4176 |
|
RowID = 4 |
4177 |
|
Float16 = 0 |
4178 |
|
Precision = 0 |
4199 |
|
Places = 0 |
4200 |
|
Digits = |
4201 |
|
BigInteger = Null |
4202 |
+ |
|
4203 |
|
Metadata |
4204 |
|
SQLType =SQL_LONG |
4205 |
|
sub type = 0 |
4287 |
|
|
4288 |
|
|
4289 |
|
|
4290 |
+ |
------------------------------------------------------ |
4291 |
+ |
Running Test 19: Batch Update and Insert Queries |
4292 |
+ |
Opening inet://localhost/employee |
4293 |
+ |
Database Open |
4294 |
+ |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
4295 |
+ |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
4296 |
+ |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
4297 |
+ |
on disk structure version 13.0 |
4298 |
+ |
Rows before update |
4299 |
+ |
EMP_NO = 2 |
4300 |
+ |
FIRST_NAME = Robert |
4301 |
+ |
LAST_NAME = Nelson |
4302 |
+ |
PHONE_EXT = 250 |
4303 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
4304 |
+ |
DEPT_NO = 600 |
4305 |
+ |
JOB_CODE = VP |
4306 |
+ |
JOB_GRADE = 2 |
4307 |
+ |
JOB_COUNTRY = USA |
4308 |
+ |
SALARY = 105,900.00 |
4309 |
+ |
FULL_NAME = Nelson, Robert |
4310 |
+ |
EMP_NO = 8 |
4311 |
+ |
FIRST_NAME = Leslie |
4312 |
+ |
LAST_NAME = Johnson |
4313 |
+ |
PHONE_EXT = 410 |
4314 |
+ |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
4315 |
+ |
DEPT_NO = 180 |
4316 |
+ |
JOB_CODE = Mktg |
4317 |
+ |
JOB_GRADE = 3 |
4318 |
+ |
JOB_COUNTRY = USA |
4319 |
+ |
SALARY = 64,635.00 |
4320 |
+ |
FULL_NAME = Johnson, Leslie |
4321 |
+ |
|
4322 |
+ |
Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0 |
4323 |
+ |
Batch Completion Info |
4324 |
+ |
Total rows processed = 2 |
4325 |
+ |
Updated Records = 2 |
4326 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4327 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4328 |
+ |
Rows after update |
4329 |
+ |
EMP_NO = 2 |
4330 |
+ |
FIRST_NAME = Robert |
4331 |
+ |
LAST_NAME = Nelson |
4332 |
+ |
PHONE_EXT = 250 |
4333 |
+ |
HIRE_DATE = 2018/05/28 00:00:00.0000 |
4334 |
+ |
DEPT_NO = 600 |
4335 |
+ |
JOB_CODE = VP |
4336 |
+ |
JOB_GRADE = 2 |
4337 |
+ |
JOB_COUNTRY = USA |
4338 |
+ |
SALARY = 105,900.00 |
4339 |
+ |
FULL_NAME = Nelson, Robert |
4340 |
+ |
EMP_NO = 8 |
4341 |
+ |
FIRST_NAME = Leslie |
4342 |
+ |
LAST_NAME = Johnson |
4343 |
+ |
PHONE_EXT = 410 |
4344 |
+ |
HIRE_DATE = 2016/01/31 00:00:00.0000 |
4345 |
+ |
DEPT_NO = 180 |
4346 |
+ |
JOB_CODE = Mktg |
4347 |
+ |
JOB_GRADE = 3 |
4348 |
+ |
JOB_COUNTRY = USA |
4349 |
+ |
SALARY = 64,635.00 |
4350 |
+ |
FULL_NAME = Johnson, Leslie |
4351 |
+ |
|
4352 |
+ |
|
4353 |
+ |
Repeat but with a last dummy row that is ignored |
4354 |
+ |
Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0 |
4355 |
+ |
Batch Completion Info |
4356 |
+ |
Total rows processed = 2 |
4357 |
+ |
Updated Records = 2 |
4358 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4359 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4360 |
+ |
Rows after update |
4361 |
+ |
EMP_NO = 2 |
4362 |
+ |
FIRST_NAME = Robert |
4363 |
+ |
LAST_NAME = Nelson |
4364 |
+ |
PHONE_EXT = 250 |
4365 |
+ |
HIRE_DATE = 2018/05/28 00:00:00.0000 |
4366 |
+ |
DEPT_NO = 600 |
4367 |
+ |
JOB_CODE = VP |
4368 |
+ |
JOB_GRADE = 2 |
4369 |
+ |
JOB_COUNTRY = USA |
4370 |
+ |
SALARY = 105,900.00 |
4371 |
+ |
FULL_NAME = Nelson, Robert |
4372 |
+ |
EMP_NO = 8 |
4373 |
+ |
FIRST_NAME = Leslie |
4374 |
+ |
LAST_NAME = Johnson |
4375 |
+ |
PHONE_EXT = 410 |
4376 |
+ |
HIRE_DATE = 2016/01/31 00:00:00.0000 |
4377 |
+ |
DEPT_NO = 180 |
4378 |
+ |
JOB_CODE = Mktg |
4379 |
+ |
JOB_GRADE = 3 |
4380 |
+ |
JOB_COUNTRY = USA |
4381 |
+ |
SALARY = 64,635.00 |
4382 |
+ |
FULL_NAME = Johnson, Leslie |
4383 |
+ |
|
4384 |
+ |
|
4385 |
+ |
Insert rows |
4386 |
+ |
Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0 |
4387 |
+ |
Batch Completion Info |
4388 |
+ |
Total rows processed = 3 |
4389 |
+ |
Updated Records = 3 |
4390 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4391 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4392 |
+ |
Row 3 State = bcNoMoreErrors Msg = |
4393 |
+ |
Rows after insert |
4394 |
+ |
EMP_NO = 150 |
4395 |
+ |
FIRST_NAME = John |
4396 |
+ |
LAST_NAME = Doe |
4397 |
+ |
PHONE_EXT = |
4398 |
+ |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
4399 |
+ |
DEPT_NO = 600 |
4400 |
+ |
JOB_CODE = Eng |
4401 |
+ |
JOB_GRADE = 4 |
4402 |
+ |
JOB_COUNTRY = England |
4403 |
+ |
SALARY = 41,000.89 |
4404 |
+ |
FULL_NAME = Doe, John |
4405 |
+ |
EMP_NO = 151 |
4406 |
+ |
FIRST_NAME = Jane |
4407 |
+ |
LAST_NAME = Doe |
4408 |
+ |
PHONE_EXT = |
4409 |
+ |
HIRE_DATE = 2015/04/02 00:00:00.0000 |
4410 |
+ |
DEPT_NO = 600 |
4411 |
+ |
JOB_CODE = Eng |
4412 |
+ |
JOB_GRADE = 4 |
4413 |
+ |
JOB_COUNTRY = England |
4414 |
+ |
SALARY = 42,000.89 |
4415 |
+ |
FULL_NAME = Doe, Jane |
4416 |
+ |
EMP_NO = 152 |
4417 |
+ |
FIRST_NAME = John |
4418 |
+ |
LAST_NAME = SmithAndJonesFamily1 |
4419 |
+ |
PHONE_EXT = |
4420 |
+ |
HIRE_DATE = 2015/04/03 00:00:00.0000 |
4421 |
+ |
DEPT_NO = 600 |
4422 |
+ |
JOB_CODE = Eng |
4423 |
+ |
JOB_GRADE = 4 |
4424 |
+ |
JOB_COUNTRY = England |
4425 |
+ |
SALARY = 41,000.99 |
4426 |
+ |
FULL_NAME = SmithAndJonesFamily1, John |
4427 |
+ |
|
4428 |
+ |
|
4429 |
+ |
Insert rows - and then cancel |
4430 |
+ |
Cancel Batch - note - next step will fail with a duplicate key if cancel fails |
4431 |
+ |
|
4432 |
+ |
Insert rows - ignore last row |
4433 |
+ |
Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0 |
4434 |
+ |
Batch Completion Info |
4435 |
+ |
Total rows processed = 2 |
4436 |
+ |
Updated Records = 2 |
4437 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4438 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4439 |
+ |
Rows after insert |
4440 |
+ |
EMP_NO = 150 |
4441 |
+ |
FIRST_NAME = John |
4442 |
+ |
LAST_NAME = Doe |
4443 |
+ |
PHONE_EXT = |
4444 |
+ |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
4445 |
+ |
DEPT_NO = 600 |
4446 |
+ |
JOB_CODE = Eng |
4447 |
+ |
JOB_GRADE = 4 |
4448 |
+ |
JOB_COUNTRY = England |
4449 |
+ |
SALARY = 41,000.89 |
4450 |
+ |
FULL_NAME = Doe, John |
4451 |
+ |
EMP_NO = 151 |
4452 |
+ |
FIRST_NAME = Jane |
4453 |
+ |
LAST_NAME = Doe |
4454 |
+ |
PHONE_EXT = |
4455 |
+ |
HIRE_DATE = 2015/04/02 00:00:00.0000 |
4456 |
+ |
DEPT_NO = 600 |
4457 |
+ |
JOB_CODE = Eng |
4458 |
+ |
JOB_GRADE = 4 |
4459 |
+ |
JOB_COUNTRY = England |
4460 |
+ |
SALARY = 42,000.89 |
4461 |
+ |
FULL_NAME = Doe, Jane |
4462 |
+ |
|
4463 |
+ |
Insert with inline blob |
4464 |
+ |
Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0 |
4465 |
+ |
Batch Completion Info |
4466 |
+ |
Total rows processed = 2 |
4467 |
+ |
Updated Records = 2 |
4468 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4469 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4470 |
+ |
Rows after insert |
4471 |
+ |
JOB_CODE = ABC |
4472 |
+ |
JOB_GRADE = 3 |
4473 |
+ |
JOB_COUNTRY = England |
4474 |
+ |
JOB_TITLE = Chief Tester |
4475 |
+ |
MIN_SALARY = 21,000.00 |
4476 |
+ |
MAX_SALARY = 24,000.99 |
4477 |
+ |
JOB_REQUIREMENT (Charset Id = 0 Codepage = 0) |
4478 |
+ |
|
4479 |
+ |
The quick brown fox jumped over the lazy dog |
4480 |
+ |
LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: ) |
4481 |
+ |
|
4482 |
+ |
JOB_CODE = DEF |
4483 |
+ |
JOB_GRADE = 3 |
4484 |
+ |
JOB_COUNTRY = England |
4485 |
+ |
JOB_TITLE = Deputy Tester |
4486 |
+ |
MIN_SALARY = 21,000.00 |
4487 |
+ |
MAX_SALARY = 24,000.99 |
4488 |
+ |
JOB_REQUIREMENT (Charset Id = 0 Codepage = 0) |
4489 |
+ |
|
4490 |
+ |
The quick brown fox jumped over the running dog |
4491 |
+ |
LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: ) |
4492 |
+ |
|
4493 |
+ |
|
4494 |
+ |
|
4495 |
+ |
Insert with explicit blob |
4496 |
+ |
Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0 |
4497 |
+ |
Batch Completion Info |
4498 |
+ |
Total rows processed = 2 |
4499 |
+ |
Updated Records = 2 |
4500 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4501 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4502 |
+ |
Rows after insert |
4503 |
+ |
JOB_CODE = ABC |
4504 |
+ |
JOB_GRADE = 3 |
4505 |
+ |
JOB_COUNTRY = England |
4506 |
+ |
JOB_TITLE = Chief Tester |
4507 |
+ |
MIN_SALARY = 21,000.00 |
4508 |
+ |
MAX_SALARY = 24,000.99 |
4509 |
+ |
JOB_REQUIREMENT (Charset Id = 0 Codepage = 0) |
4510 |
+ |
|
4511 |
+ |
The quick brown fox jumped over the lazy dog |
4512 |
+ |
LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: ) |
4513 |
+ |
|
4514 |
+ |
JOB_CODE = DEF |
4515 |
+ |
JOB_GRADE = 3 |
4516 |
+ |
JOB_COUNTRY = England |
4517 |
+ |
JOB_TITLE = Deputy Tester |
4518 |
+ |
MIN_SALARY = 21,000.00 |
4519 |
+ |
MAX_SALARY = 24,000.99 |
4520 |
+ |
JOB_REQUIREMENT (Charset Id = 0 Codepage = 0) |
4521 |
+ |
|
4522 |
+ |
The quick brown fox jumped over the running dog |
4523 |
+ |
LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: ) |
4524 |
+ |
|
4525 |
+ |
|
4526 |
+ |
Test Error Handling |
4527 |
+ |
Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING |
4528 |
+ |
Test Error Handling - Update returning should fail |
4529 |
+ |
Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched |
4530 |
+ |
Error handling when Insert rows - duplicate key |
4531 |
+ |
Error reported when inserting: Error Processing update/insert batch on row number 2 - violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE" |
4532 |
+ |
-Problematic key value is ("EMP_NO" = 150) |
4533 |
+ |
Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 |
4534 |
+ |
Batch Completion Info |
4535 |
+ |
Total rows processed = 2 |
4536 |
+ |
Updated Records = 1 |
4537 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4538 |
+ |
Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE" |
4539 |
+ |
-Problematic key value is ("EMP_NO" = 150) |
4540 |
+ |
|
4541 |
+ |
|
4542 |
+ |
------------------------------------------------------ |
4543 |
+ |
Running Test 20: Stress Test IBatch interface |
4544 |
+ |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
4545 |
+ |
10000 rows added |
4546 |
+ |
20000 rows added |
4547 |
+ |
30000 rows added |
4548 |
+ |
40000 rows added |
4549 |
+ |
50000 rows added |
4550 |
+ |
Batch Execute |
4551 |
+ |
Intermediate Apply Batch on row 50001 |
4552 |
+ |
Batch Completion Info |
4553 |
+ |
Total rows processed = 50000 |
4554 |
+ |
Updated Rows = 50000 |
4555 |
+ |
Row 50000 State = bcNoMoreErrors Msg = |
4556 |
+ |
60000 rows added |
4557 |
+ |
70000 rows added |
4558 |
+ |
80000 rows added |
4559 |
+ |
90000 rows added |
4560 |
+ |
100000 rows added |
4561 |
+ |
Batch Execute |
4562 |
+ |
Batch Completion Info |
4563 |
+ |
Total rows processed = 50000 |
4564 |
+ |
Updated Rows = 50000 |
4565 |
+ |
Row 50000 State = bcNoMoreErrors Msg = |
4566 |
+ |
Rows in Dataset = 100000 |
4567 |
+ |
Message Hash = 2014887b8ad27fbb20893a22d6e39f26 |
4568 |
+ |
Message Hash = 2014887b8ad27fbb20893a22d6e39f26 |
4569 |
+ |
Test Completed Successfully |
4570 |
+ |
|
4571 |
+ |
|
4572 |
+ |
------------------------------------------------------ |
4573 |
+ |
Running Test 21: Exercise setting and getting of numeric data types |
4574 |
+ |
1234.567 parsed to 1234567 scale = -3 |
4575 |
+ |
As Float = 1.2345670000000000E+003 |
4576 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
4577 |
+ |
As Float = -7.6543209999999999E+002 |
4578 |
+ |
0.1 parsed to 1 scale = -1 |
4579 |
+ |
As Float = 1.0000000000000001E-001 |
4580 |
+ |
0.01 parsed to 1 scale = -2 |
4581 |
+ |
As Float = 1.0000000000000000E-002 |
4582 |
+ |
+123 parsed to 123 scale = 0 |
4583 |
+ |
As Float = 1.2300000000000000E+002 |
4584 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
4585 |
+ |
As Float = 1.2345600000000001E+308 |
4586 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
4587 |
+ |
As Float = -1.2000000000000000E-002 |
4588 |
+ |
10. parsed to 10 scale = 0 |
4589 |
+ |
As Float = 1.0000000000000000E+001 |
4590 |
+ |
.12 parsed to 12 scale = -2 |
4591 |
+ |
As Float = 1.2000000000000000E-001 |
4592 |
+ |
0.12 parsed to 12 scale = -2 |
4593 |
+ |
As Float = 1.2000000000000000E-001 |
4594 |
+ |
Parsing of 1.2E1.2 failed |
4595 |
+ |
Parsing of 1,000 failed |
4596 |
+ |
Parsing of 1e1e1 failed |
4597 |
+ |
Parsing of 1.2+3 failed |
4598 |
+ |
SQL Params |
4599 |
+ |
SQLType =SQL_LONG |
4600 |
+ |
sub type = 0 |
4601 |
+ |
Field Name = |
4602 |
+ |
Scale = 0 |
4603 |
+ |
Charset id = 0 |
4604 |
+ |
Not Null |
4605 |
+ |
Size = 4 |
4606 |
+ |
Value = 0 |
4607 |
+ |
|
4608 |
+ |
SQLType =SQL_LONG |
4609 |
+ |
sub type = 0 |
4610 |
+ |
Field Name = |
4611 |
+ |
Scale = 0 |
4612 |
+ |
Charset id = 0 |
4613 |
+ |
Nullable |
4614 |
+ |
Size = 4 |
4615 |
+ |
|
4616 |
+ |
SQLType =SQL_INT64 |
4617 |
+ |
sub type = 0 |
4618 |
+ |
Field Name = |
4619 |
+ |
Scale = 0 |
4620 |
+ |
Charset id = 0 |
4621 |
+ |
Nullable |
4622 |
+ |
Size = 8 |
4623 |
+ |
|
4624 |
+ |
SQLType =SQL_INT64 |
4625 |
+ |
sub type = 0 |
4626 |
+ |
Field Name = |
4627 |
+ |
Scale = -4 |
4628 |
+ |
Charset id = 0 |
4629 |
+ |
Nullable |
4630 |
+ |
Size = 8 |
4631 |
+ |
|
4632 |
+ |
SQLType =SQL_DOUBLE |
4633 |
+ |
sub type = 0 |
4634 |
+ |
Field Name = |
4635 |
+ |
Scale = 0 |
4636 |
+ |
Charset id = 0 |
4637 |
+ |
Nullable |
4638 |
+ |
Size = 8 |
4639 |
+ |
|
4640 |
+ |
SQLType =SQL_INT64 |
4641 |
+ |
sub type = 0 |
4642 |
+ |
Field Name = |
4643 |
+ |
Scale = -6 |
4644 |
+ |
Charset id = 0 |
4645 |
+ |
Nullable |
4646 |
+ |
Size = 8 |
4647 |
+ |
|
4648 |
+ |
Expected Error - SQLCODE: -303 |
4649 |
+ |
Engine Code: 335544569 Incompatible column/host variable data type |
4650 |
+ |
Dynamic SQL Error |
4651 |
+ |
-SQL error code = -303 |
4652 |
+ |
-conversion error from string "1,000" |
4653 |
+ |
Expected Error - SQLCODE: -303 |
4654 |
+ |
Engine Code: 335544569 Incompatible column/host variable data type |
4655 |
+ |
Dynamic SQL Error |
4656 |
+ |
-SQL error code = -303 |
4657 |
+ |
-conversion error from string "10.0.0" |
4658 |
+ |
ROWID = 1 |
4659 |
+ |
ITYPE = 101 |
4660 |
+ |
I64TYPE = 9223372036854775807 |
4661 |
+ |
CURRTYPE = 10,000.12340000 |
4662 |
+ |
DTYPE = 9,999.12345678 |
4663 |
+ |
FIXEDPOINT = 1,234,567,890.12345700 |
4664 |
+ |
ROWID = 2 |
4665 |
+ |
ITYPE = -32457 |
4666 |
+ |
I64TYPE = -9223372036854775808 |
4667 |
+ |
CURRTYPE = 1,000,001.12000000 |
4668 |
+ |
DTYPE = 1.7E308 |
4669 |
+ |
FIXEDPOINT = -1,234,567,890.12345700 |
4670 |
+ |
ROWID = 3 |
4671 |
+ |
ITYPE = 0 |
4672 |
+ |
I64TYPE = 0 |
4673 |
+ |
CURRTYPE = .00000000 |
4674 |
+ |
DTYPE = .00000000 |
4675 |
+ |
FIXEDPOINT = .00000000 |
4676 |
+ |
ROWID = 4 |
4677 |
+ |
ITYPE = 1 |
4678 |
+ |
I64TYPE = 10 |
4679 |
+ |
CURRTYPE = .02300000 |
4680 |
+ |
DTYPE = .00110000 |
4681 |
+ |
FIXEDPOINT = 233.45600000 |
4682 |
+ |
|
4683 |
+ |
|
4684 |
+ |
|
4685 |
|
------------------------------------------------------ |
4686 |
|
Test Suite Ends |