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.1 |
7 |
> |
Firebird Bin Directory = /opt/firebird4.0.1/bin |
8 |
> |
Firebird Conf Directory = /opt/firebird4.0.1/ |
9 |
> |
Firebird Client Library Path = /opt/firebird4.0.1/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 "" |
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 |
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.1/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.1.2692 Firebird 4.0" |
34 |
> |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:C" |
35 |
> |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17: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.1/lib/libfbclient.so |
48 |
|
DB Client Implementation Version = 4.0 |
49 |
|
Dropping Database |
50 |
|
DPB: Item Count = 4 |
57 |
|
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
58 |
|
ODS major = 13 |
59 |
|
ODS minor = 0 |
60 |
+ |
Attachment ID = 4 |
61 |
|
DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb |
62 |
|
DB Charset ID = 4 |
63 |
|
DB SQL Dialect = 3 |
65 |
|
DB ODS Major Version = 13 |
66 |
|
DB ODS Minor Version = 0 |
67 |
|
User Authentication Method = Srp256 |
68 |
< |
Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so |
68 |
> |
Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so |
69 |
|
DB Client Implementation Version = 4.0 |
70 |
|
RDB$DESCRIPTION = |
71 |
|
RDB$RELATION_ID = 128 |
72 |
< |
RDB$SECURITY_CLASS = SQL$384 |
72 |
> |
RDB$SECURITY_CLASS = SQL$385 |
73 |
|
RDB$CHARACTER_SET_NAME = UTF8 |
74 |
|
RDB$LINGER = |
75 |
|
RDB$SQL_SECURITY = |
78 |
|
|
79 |
|
------------------------------------------------------ |
80 |
|
Running Test 2: Open the employee database and run a query |
81 |
+ |
Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
82 |
|
Opening inet://localhost/employee |
83 |
|
Database Open, SQL Dialect = 3 |
84 |
|
TPB: Item Count = 3 |
269 |
|
Charset id = 0 |
270 |
|
Not Null |
271 |
|
Size = 2 |
272 |
+ |
Value = 0 |
273 |
|
|
274 |
|
EMP_NO = 8 |
275 |
|
FIRST_NAME = Leslie |
293 |
|
Charset id = 0 |
294 |
|
Not Null |
295 |
|
Size = 2 |
296 |
+ |
Value = 0 |
297 |
|
|
298 |
+ |
Results for Cursor: Test Cursor |
299 |
|
EMP_NO = 8 |
300 |
|
FIRST_NAME = Leslie |
301 |
|
LAST_NAME = Johnson |
308 |
|
SALARY = 64,635.00 |
309 |
|
FULL_NAME = Johnson, Leslie |
310 |
|
|
311 |
+ |
Scollable Cursors |
312 |
+ |
DB Connect String = inet://localhost/employee |
313 |
+ |
DB Charset ID = 4 |
314 |
+ |
DB SQL Dialect = 3 |
315 |
+ |
DB Remote Protocol = TCPv4 |
316 |
+ |
DB ODS Major Version = 13 |
317 |
+ |
DB ODS Minor Version = 0 |
318 |
+ |
User Authentication Method = Srp256 |
319 |
+ |
Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so |
320 |
+ |
DB Client Implementation Version = 4.0 |
321 |
+ |
Do Fetch Next: |
322 |
+ |
EMP_NO = 2 |
323 |
+ |
FIRST_NAME = Robert |
324 |
+ |
LAST_NAME = Nelson |
325 |
+ |
PHONE_EXT = 250 |
326 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
327 |
+ |
DEPT_NO = 600 |
328 |
+ |
JOB_CODE = VP |
329 |
+ |
JOB_GRADE = 2 |
330 |
+ |
JOB_COUNTRY = USA |
331 |
+ |
SALARY = 105,900.00 |
332 |
+ |
FULL_NAME = Nelson, Robert |
333 |
+ |
Do Fetch Last: |
334 |
+ |
Remote Scrollable cursors test fails Engine Code: 335544378 feature is not supported |
335 |
|
Now open the employee database as a local database |
336 |
|
TPB: Item Count = 3 |
337 |
|
isc_tpb_read |
521 |
|
Charset id = 0 |
522 |
|
Not Null |
523 |
|
Size = 2 |
524 |
+ |
Value = 0 |
525 |
|
|
526 |
|
EMP_NO = 8 |
527 |
|
FIRST_NAME = Leslie |
545 |
|
Charset id = 0 |
546 |
|
Not Null |
547 |
|
Size = 2 |
548 |
+ |
Value = 0 |
549 |
|
|
550 |
+ |
Results for Cursor: Test Cursor |
551 |
|
EMP_NO = 8 |
552 |
|
FIRST_NAME = Leslie |
553 |
|
LAST_NAME = Johnson |
560 |
|
SALARY = 64,635.00 |
561 |
|
FULL_NAME = Johnson, Leslie |
562 |
|
|
563 |
+ |
Scollable Cursors |
564 |
+ |
DB Connect String = employee |
565 |
+ |
DB Charset ID = 4 |
566 |
+ |
DB SQL Dialect = 3 |
567 |
+ |
DB Remote Protocol = |
568 |
+ |
DB ODS Major Version = 13 |
569 |
+ |
DB ODS Minor Version = 0 |
570 |
+ |
User Authentication Method = User name in DPB |
571 |
+ |
Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so |
572 |
+ |
DB Client Implementation Version = 4.0 |
573 |
+ |
Do Fetch Next: |
574 |
+ |
EMP_NO = 2 |
575 |
+ |
FIRST_NAME = Robert |
576 |
+ |
LAST_NAME = Nelson |
577 |
+ |
PHONE_EXT = 250 |
578 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
579 |
+ |
DEPT_NO = 600 |
580 |
+ |
JOB_CODE = VP |
581 |
+ |
JOB_GRADE = 2 |
582 |
+ |
JOB_COUNTRY = USA |
583 |
+ |
SALARY = 105,900.00 |
584 |
+ |
FULL_NAME = Nelson, Robert |
585 |
+ |
Do Fetch Last: |
586 |
+ |
EMP_NO = 145 |
587 |
+ |
FIRST_NAME = Mark |
588 |
+ |
LAST_NAME = Guckenheimer |
589 |
+ |
PHONE_EXT = 221 |
590 |
+ |
HIRE_DATE = 1994/05/02 00:00:00.0000 |
591 |
+ |
DEPT_NO = 622 |
592 |
+ |
JOB_CODE = Eng |
593 |
+ |
JOB_GRADE = 5 |
594 |
+ |
JOB_COUNTRY = USA |
595 |
+ |
SALARY = 32,000.00 |
596 |
+ |
FULL_NAME = Guckenheimer, Mark |
597 |
+ |
Do Fetch Prior: |
598 |
+ |
EMP_NO = 144 |
599 |
+ |
FIRST_NAME = John |
600 |
+ |
LAST_NAME = Montgomery |
601 |
+ |
PHONE_EXT = 820 |
602 |
+ |
HIRE_DATE = 1994/03/30 00:00:00.0000 |
603 |
+ |
DEPT_NO = 672 |
604 |
+ |
JOB_CODE = Eng |
605 |
+ |
JOB_GRADE = 5 |
606 |
+ |
JOB_COUNTRY = USA |
607 |
+ |
SALARY = 35,000.00 |
608 |
+ |
FULL_NAME = Montgomery, John |
609 |
+ |
Do Fetch First: |
610 |
+ |
EMP_NO = 2 |
611 |
+ |
FIRST_NAME = Robert |
612 |
+ |
LAST_NAME = Nelson |
613 |
+ |
PHONE_EXT = 250 |
614 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
615 |
+ |
DEPT_NO = 600 |
616 |
+ |
JOB_CODE = VP |
617 |
+ |
JOB_GRADE = 2 |
618 |
+ |
JOB_COUNTRY = USA |
619 |
+ |
SALARY = 105,900.00 |
620 |
+ |
FULL_NAME = Nelson, Robert |
621 |
+ |
Do Fetch Abs 8 : |
622 |
+ |
EMP_NO = 14 |
623 |
+ |
FIRST_NAME = Stewart |
624 |
+ |
LAST_NAME = Hall |
625 |
+ |
PHONE_EXT = 227 |
626 |
+ |
HIRE_DATE = 1990/06/04 00:00:00.0000 |
627 |
+ |
DEPT_NO = 900 |
628 |
+ |
JOB_CODE = Finan |
629 |
+ |
JOB_GRADE = 3 |
630 |
+ |
JOB_COUNTRY = USA |
631 |
+ |
SALARY = 69,482.63 |
632 |
+ |
FULL_NAME = Hall, Stewart |
633 |
+ |
Do Fetch Relative -2 : |
634 |
+ |
EMP_NO = 11 |
635 |
+ |
FIRST_NAME = K. J. |
636 |
+ |
LAST_NAME = Weston |
637 |
+ |
PHONE_EXT = 34 |
638 |
+ |
HIRE_DATE = 1990/01/17 00:00:00.0000 |
639 |
+ |
DEPT_NO = 130 |
640 |
+ |
JOB_CODE = SRep |
641 |
+ |
JOB_GRADE = 4 |
642 |
+ |
JOB_COUNTRY = USA |
643 |
+ |
SALARY = 86,292.94 |
644 |
+ |
FULL_NAME = Weston, K. J. |
645 |
+ |
Do Fetch beyond EOF : |
646 |
+ |
Fetch returned false |
647 |
|
|
648 |
|
|
649 |
|
------------------------------------------------------ |
651 |
|
Opening inet://localhost/employee |
652 |
|
Database Open |
653 |
|
Employee Count = 42 |
654 |
+ |
Transaction ID = 173 |
655 |
+ |
Transaction is Read/Write |
656 |
+ |
Transaction Database Path = inet://localhost/employee |
657 |
+ |
Transaction ID = 173 |
658 |
+ |
Oldest Interesting = 171 |
659 |
+ |
Oldest Action = 172 |
660 |
+ |
Oldest Snapshot = 172 |
661 |
+ |
Oldest Snapshot Number = 2 |
662 |
+ |
Lock Timeout = 0 |
663 |
+ |
Transaction Access = isc_info_tra_readwrite |
664 |
+ |
Isolation Type = isc_info_tra_concurrency |
665 |
|
Employee Count = 41 |
666 |
|
Employee Count = 42 |
667 |
|
Employee Count = 41 |
675 |
|
Running Test 4: Update, Insert and Delete Queries |
676 |
|
Opening inet://localhost/employee |
677 |
|
Database Open |
678 |
< |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1" |
679 |
< |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ" |
680 |
< |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ" |
678 |
> |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
679 |
> |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" |
680 |
> |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" |
681 |
|
on disk structure version 13.0 |
682 |
|
Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0 |
683 |
|
EMP_NO = 8 |
692 |
|
SALARY = 64,635.00 |
693 |
|
FULL_NAME = Johnson, Leslie |
694 |
|
|
695 |
< |
Current memory = 19,747,376 |
695 |
> |
Current memory = 19,767,936 |
696 |
|
Delta memory = 4,464 |
697 |
< |
Max memory = 19,793,248 |
697 |
> |
Max memory = 19,813,552 |
698 |
|
Elapsed time= 0.002 sec |
699 |
|
Cpu = 0.000 sec |
700 |
|
Buffers = 2048 |
1194 |
|
Charset id = 0 |
1195 |
|
Not Null |
1196 |
|
Size = 4 |
1197 |
+ |
Value = 0 |
1198 |
|
|
1199 |
|
SQLType =SQL_VARYING |
1200 |
|
sub type = 0 |
1242 |
|
Charset id = 0 |
1243 |
|
Not Null |
1244 |
|
Size = 4 |
1245 |
+ |
Value = 0 |
1246 |
|
|
1247 |
|
ROWID = 1 |
1248 |
|
FIXEDPOINT = 20.28 |
1295 |
|
Charset id = 0 |
1296 |
|
Not Null |
1297 |
|
Size = 4 |
1298 |
+ |
Value = 0 |
1299 |
|
|
1300 |
|
SQLType =SQL_VARYING |
1301 |
|
sub type = 0 |
1673 |
|
Charset id = 0 |
1674 |
|
Not Null |
1675 |
|
Size = 4 |
1676 |
+ |
Value = 0 |
1677 |
|
|
1678 |
|
SQLType =SQL_VARYING |
1679 |
|
sub type = 0 |
1721 |
|
Charset id = 0 |
1722 |
|
Not Null |
1723 |
|
Size = 4 |
1724 |
+ |
Value = 0 |
1725 |
|
|
1726 |
|
ROWID = 1 |
1727 |
|
FIXEDPOINT = 20.28 |
1774 |
|
Charset id = 0 |
1775 |
|
Not Null |
1776 |
|
Size = 4 |
1777 |
+ |
Value = 0 |
1778 |
|
|
1779 |
|
SQLType =SQL_VARYING |
1780 |
|
sub type = 0 |
2152 |
|
Charset id = 0 |
2153 |
|
Not Null |
2154 |
|
Size = 4 |
2155 |
+ |
Value = 0 |
2156 |
|
|
2157 |
|
SQLType =SQL_VARYING |
2158 |
|
sub type = 0 |
2200 |
|
Charset id = 0 |
2201 |
|
Not Null |
2202 |
|
Size = 4 |
2203 |
+ |
Value = 0 |
2204 |
|
|
2205 |
|
ROWID = 1 |
2206 |
|
FIXEDPOINT = 20.28 |
2253 |
|
Charset id = 0 |
2254 |
|
Not Null |
2255 |
|
Size = 4 |
2256 |
+ |
Value = 0 |
2257 |
|
|
2258 |
|
SQLType =SQL_VARYING |
2259 |
|
sub type = 0 |
2548 |
|
Charset id = 0 |
2549 |
|
Not Null |
2550 |
|
Size = 4 |
2551 |
+ |
Value = 0 |
2552 |
|
|
2553 |
|
SQLType =SQL_VARYING |
2554 |
|
sub type = 0 |
2733 |
|
|
2734 |
|
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) |
2735 |
|
|
2736 |
< |
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) |
2736 |
> |
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.46) (16: 4269) |
2737 |
|
|
2738 |
|
|
2739 |
|
Shrink to 2:10 |
2749 |
|
|
2750 |
|
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) |
2751 |
|
|
2752 |
< |
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) |
2752 |
> |
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.46) (16: 4269) |
2753 |
|
|
2754 |
|
|
2755 |
|
|
2810 |
|
Charset id = 0 |
2811 |
|
Not Null |
2812 |
|
Size = 4 |
2813 |
+ |
Value = 0 |
2814 |
|
|
2815 |
|
SQLType =SQL_VARYING |
2816 |
|
sub type = 0 |
2833 |
|
|
2834 |
|
------------------------------------------------------ |
2835 |
|
Running Test 9: Database Information tests |
2836 |
< |
Database ID = 4 FB = /opt/firebird4rc1/examples/empbuild/employee.fdb SN = zeus |
2836 |
> |
Database ID = 4 FB = /opt/firebird4.0.1/examples/empbuild/employee.fdb SN = zeus |
2837 |
|
Pages =346 |
2838 |
|
Base Level = 13,4,0,3, |
2839 |
|
Implementation = 11,7,0,3,66,1,66, |
2841 |
|
ODS minor = 0 |
2842 |
|
ODS major = 13 |
2843 |
|
Page Size = 8192 |
2844 |
< |
Version = 1: LI-V6.3.0.2353 Firebird 4.0 Release Candidate 1 |
2844 |
> |
Version = 1: LI-V6.3.1.2692 Firebird 4.0 |
2845 |
|
Database is Read/Write |
2846 |
< |
Database Created: 01/2/2021 14:57:08 |
2846 |
> |
Database Created: 21/12/2021 10:52:59 |
2847 |
|
Pages Used = 310 |
2848 |
|
Pages Free = 36 |
2849 |
< |
Server Memory = 19466032 |
2849 |
> |
Server Memory = 19482432 |
2850 |
|
Forced Writes = 1 |
2851 |
< |
Max Memory = 19612048 |
2851 |
> |
Max Memory = 19629552 |
2852 |
|
Num Buffers = 2048 |
2853 |
|
Sweep Interval = 20000 |
2854 |
|
Logged in Users: SYSDBA, |
2934 |
|
password = masterkey |
2935 |
|
|
2936 |
|
Service Manager Version = 2 |
2937 |
< |
Server Version = LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1 |
2937 |
> |
Server Version = LI-V4.0.1.2692 Firebird 4.0 |
2938 |
|
Implementation = Firebird/Linux/AMD/Intel/x64 |
2939 |
|
|
2940 |
|
Lock Directory = /tmp/firebird/ |
2941 |
< |
Message File = /opt/firebird4rc1/ |
2942 |
< |
Security File = /opt/firebird4rc1/security4.fdb |
2941 |
> |
Message File = /opt/firebird4.0.1/ |
2942 |
> |
Security File = /opt/firebird4.0.1/security4.fdb |
2943 |
|
|
2944 |
|
DB Attachments |
2945 |
|
No. of Attachments = 0 |
2954 |
|
Group ID = 0 |
2955 |
|
|
2956 |
|
|
2957 |
< |
Licence Info: feature is not supported |
2957 |
> |
Licence Info: Engine Code: 335544378 feature is not supported |
2958 |
|
-feature is not supported |
2959 |
|
|
2960 |
< |
Licence Mask Info: feature is not supported |
2960 |
> |
Licence Mask Info: Engine Code: 335544378 feature is not supported |
2961 |
|
|
2962 |
|
Capabilities = 6 |
2963 |
|
|
2997 |
|
Charset id = 0 |
2998 |
|
Not Null |
2999 |
|
Size = 4 |
3000 |
+ |
Value = 0 |
3001 |
|
|
3002 |
|
SQLType =SQL_VARYING |
3003 |
|
sub type = 0 |
3047 |
|
Nullable |
3048 |
|
Size = 16 |
3049 |
|
|
3050 |
+ |
Show Param Values |
3051 |
+ |
SQL Params |
3052 |
+ |
SQLType =SQL_LONG |
3053 |
+ |
sub type = 0 |
3054 |
+ |
Field Name = ROWID |
3055 |
+ |
Scale = 0 |
3056 |
+ |
Charset id = 0 |
3057 |
+ |
Not Null |
3058 |
+ |
Size = 4 |
3059 |
+ |
Value = 1 |
3060 |
+ |
|
3061 |
+ |
SQLType =SQL_VARYING |
3062 |
+ |
sub type = 0 |
3063 |
+ |
Field Name = TITLE |
3064 |
+ |
Scale = 0 |
3065 |
+ |
Charset id = 4 |
3066 |
+ |
Nullable |
3067 |
+ |
Size = 128 |
3068 |
+ |
Value = Blob Test ©€ |
3069 |
+ |
|
3070 |
+ |
SQLType =SQL_VARYING |
3071 |
+ |
sub type = 0 |
3072 |
+ |
Field Name = NOTES |
3073 |
+ |
Scale = 0 |
3074 |
+ |
Charset id = 4 |
3075 |
+ |
Nullable |
3076 |
+ |
Size = 256 |
3077 |
+ |
Value = Écoute moi |
3078 |
+ |
|
3079 |
+ |
SQLType =SQL_VARYING |
3080 |
+ |
sub type = 1 |
3081 |
+ |
Field Name = BLOBDATA |
3082 |
+ |
Scale = 0 |
3083 |
+ |
Charset id = 4 |
3084 |
+ |
Nullable |
3085 |
+ |
Size = 8192 |
3086 |
+ |
Value = Some German Special Characters like ÖÄÜöäüß |
3087 |
+ |
|
3088 |
+ |
SQLType =SQL_BLOB |
3089 |
+ |
sub type = 1 |
3090 |
+ |
Field Name = BLOBDATA2 |
3091 |
+ |
Scale = 0 |
3092 |
+ |
Charset id = 4 |
3093 |
+ |
Nullable |
3094 |
+ |
Size = 8 |
3095 |
+ |
Value = Some German Special Characters like ÖÄÜöäüß |
3096 |
+ |
|
3097 |
+ |
SQLType =SQL_VARYING |
3098 |
+ |
sub type = 0 |
3099 |
+ |
Field Name = INCLEAR |
3100 |
+ |
Scale = 0 |
3101 |
+ |
Charset id = 1 |
3102 |
+ |
Nullable |
3103 |
+ |
Size = 16 |
3104 |
+ |
Value = &Test |
3105 |
|
|
3106 |
+ |
|
3107 |
+ |
SQLType =SQL_VARYING |
3108 |
+ |
sub type = 0 |
3109 |
+ |
Field Name = FIXEDWIDTH |
3110 |
+ |
Scale = 0 |
3111 |
+ |
Charset id = 4 |
3112 |
+ |
Nullable |
3113 |
+ |
Size = 16 |
3114 |
+ |
Value = É |
3115 |
+ |
|
3116 |
|
Connection Character Set UTF8 |
3117 |
|
ROWID = 1 |
3118 |
|
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
3226 |
|
TITLE = Blob Test (Charset Id = 4 Codepage = 65001) |
3227 |
|
BLOBDATA = (blob), Length = 92514 |
3228 |
|
|
3229 |
+ |
ROWID = 2 |
3230 |
+ |
TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001) |
3231 |
+ |
BLOBDATA = (blob), Length = 13 |
3232 |
+ |
0 9 A C9 63 6F 75 74 65 20 6D 6F 69 |
3233 |
|
|
3234 |
|
Testdata 2 |
3235 |
|
|
3244 |
|
------------------------------------------------------ |
3245 |
|
Running Test 16: Error handling |
3246 |
|
Invalid Database Name Test |
3247 |
< |
Error Handled: I/O error during "open" operation for file "Malformed Name" |
3247 |
> |
Error Handled: SQLCODE: -902 |
3248 |
> |
Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3249 |
> |
I/O error during "open" operation for file "Malformed Name" |
3250 |
|
-Error while trying to open file |
3251 |
|
-No such file or directory |
3252 |
|
Invalid User Name Test |
3253 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3253 |
> |
Error Handled: SQLCODE: -902 |
3254 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3255 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3256 |
|
Invalid password Test |
3257 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3257 |
> |
Error Handled: SQLCODE: -902 |
3258 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3259 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3260 |
|
Invalid Prepare SQL Test |
3261 |
< |
Error Handled: Dynamic SQL Error |
3261 |
> |
Error Handled: SQLCODE: -206 |
3262 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3263 |
> |
Dynamic SQL Error |
3264 |
|
-SQL error code = -206 |
3265 |
|
-Column unknown |
3266 |
|
-UNKNOWN_DATE |
3267 |
|
-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
3268 |
|
Invalid Open Cursor SQL Test |
3269 |
< |
Error Handled: Dynamic SQL Error |
3269 |
> |
Error Handled: SQLCODE: -206 |
3270 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3271 |
> |
Dynamic SQL Error |
3272 |
|
-SQL error code = -206 |
3273 |
|
-Column unknown |
3274 |
|
-X |
3279 |
|
Error Handled: Field "EMP_NO" not found |
3280 |
|
Case sensitive Param SQL Test |
3281 |
|
Error Handled: Field "EMP_NO" not found |
3282 |
+ |
Stale Reference Check |
3283 |
+ |
First test correct usage |
3284 |
+ |
COUNTER = 42 |
3285 |
+ |
|
3286 |
+ |
New Transaction before param set |
3287 |
+ |
Error Handled: This interface is no longer up-to-date |
3288 |
+ |
New Transaction before Open Cursor |
3289 |
+ |
Error Handled: This interface is no longer up-to-date |
3290 |
+ |
Stop Stale Reference Checks |
3291 |
+ |
New Transaction before param set |
3292 |
+ |
COUNTER = 42 |
3293 |
+ |
|
3294 |
+ |
New Transaction before Open Cursor |
3295 |
+ |
COUNTER = 42 |
3296 |
+ |
|
3297 |
|
Invalid Server Name Test |
3298 |
< |
Error Handled: Unable to complete network request to host "unknown". |
3298 |
> |
Error Handled: SQLCODE: -902 |
3299 |
> |
Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3300 |
> |
Unable to complete network request to host "unknown". |
3301 |
|
-Failed to locate host machine. |
3302 |
|
-The specified name was not found in the hosts file or Domain Name Services |
3303 |
|
Invalid User Name Test |
3304 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3304 |
> |
Error Handled: SQLCODE: -902 |
3305 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3306 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3307 |
|
Invalid password Test |
3308 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3308 |
> |
Error Handled: SQLCODE: -902 |
3309 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3310 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3311 |
|
|
3312 |
|
|
3313 |
|
------------------------------------------------------ |
3314 |
|
Running Test 17: Date/Time tests and Firebird 4 extensions |
3315 |
< |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1" |
3315 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
3316 |
|
Has Local TZ DB = TRUE |
3317 |
|
|
3318 |
|
Testdata |
4074 |
|
|
4075 |
|
------------------------------------------------------ |
4076 |
|
Running Test 18: Firebird 4 Decfloat extensions |
4077 |
< |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1" |
4077 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
4078 |
|
|
4079 |
|
FB4 Testdata_DECFloat |
4080 |
|
|
4176 |
|
Special = 0 |
4177 |
|
Places = 0 |
4178 |
|
Digits = 12 34 56 78 91 23 45 67 89 |
4179 |
+ |
|
4180 |
|
RowID = 2 |
4181 |
|
Float16 = -64000000000.01 |
4182 |
|
Precision = 13 |
4197 |
|
Places = 6 |
4198 |
|
Digits = 12 34 56 12 34 56 12 34 56 |
4199 |
|
BigInteger = Null |
4200 |
+ |
|
4201 |
|
RowID = 3 |
4202 |
|
Float16 = 64100000000.011 |
4203 |
|
Precision = 14 |
4224 |
|
Places = 4 |
4225 |
|
Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35 |
4226 |
|
BigInteger = Null |
4227 |
+ |
|
4228 |
|
RowID = 4 |
4229 |
|
Float16 = 0 |
4230 |
|
Precision = 0 |
4251 |
|
Places = 0 |
4252 |
|
Digits = |
4253 |
|
BigInteger = Null |
4254 |
+ |
|
4255 |
|
Metadata |
4256 |
|
SQLType =SQL_LONG |
4257 |
|
sub type = 0 |
4339 |
|
|
4340 |
|
|
4341 |
|
|
4342 |
+ |
------------------------------------------------------ |
4343 |
+ |
Running Test 19: Batch Update and Insert Queries |
4344 |
+ |
Opening inet://localhost/employee |
4345 |
+ |
Database Open |
4346 |
+ |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
4347 |
+ |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" |
4348 |
+ |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" |
4349 |
+ |
on disk structure version 13.0 |
4350 |
+ |
Rows before update |
4351 |
+ |
EMP_NO = 2 |
4352 |
+ |
FIRST_NAME = Robert |
4353 |
+ |
LAST_NAME = Nelson |
4354 |
+ |
PHONE_EXT = 250 |
4355 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
4356 |
+ |
DEPT_NO = 600 |
4357 |
+ |
JOB_CODE = VP |
4358 |
+ |
JOB_GRADE = 2 |
4359 |
+ |
JOB_COUNTRY = USA |
4360 |
+ |
SALARY = 105,900.00 |
4361 |
+ |
FULL_NAME = Nelson, Robert |
4362 |
+ |
EMP_NO = 8 |
4363 |
+ |
FIRST_NAME = Leslie |
4364 |
+ |
LAST_NAME = Johnson |
4365 |
+ |
PHONE_EXT = 410 |
4366 |
+ |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
4367 |
+ |
DEPT_NO = 180 |
4368 |
+ |
JOB_CODE = Mktg |
4369 |
+ |
JOB_GRADE = 3 |
4370 |
+ |
JOB_COUNTRY = USA |
4371 |
+ |
SALARY = 64,635.00 |
4372 |
+ |
FULL_NAME = Johnson, Leslie |
4373 |
+ |
|
4374 |
+ |
Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0 |
4375 |
+ |
Batch Completion Info |
4376 |
+ |
Total rows processed = 2 |
4377 |
+ |
Updated Records = 2 |
4378 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4379 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4380 |
+ |
Rows after update |
4381 |
+ |
EMP_NO = 2 |
4382 |
+ |
FIRST_NAME = Robert |
4383 |
+ |
LAST_NAME = Nelson |
4384 |
+ |
PHONE_EXT = 250 |
4385 |
+ |
HIRE_DATE = 2018/05/28 00:00:00.0000 |
4386 |
+ |
DEPT_NO = 600 |
4387 |
+ |
JOB_CODE = VP |
4388 |
+ |
JOB_GRADE = 2 |
4389 |
+ |
JOB_COUNTRY = USA |
4390 |
+ |
SALARY = 105,900.00 |
4391 |
+ |
FULL_NAME = Nelson, Robert |
4392 |
+ |
EMP_NO = 8 |
4393 |
+ |
FIRST_NAME = Leslie |
4394 |
+ |
LAST_NAME = Johnson |
4395 |
+ |
PHONE_EXT = 410 |
4396 |
+ |
HIRE_DATE = 2016/01/31 00:00:00.0000 |
4397 |
+ |
DEPT_NO = 180 |
4398 |
+ |
JOB_CODE = Mktg |
4399 |
+ |
JOB_GRADE = 3 |
4400 |
+ |
JOB_COUNTRY = USA |
4401 |
+ |
SALARY = 64,635.00 |
4402 |
+ |
FULL_NAME = Johnson, Leslie |
4403 |
+ |
|
4404 |
+ |
|
4405 |
+ |
Repeat but with a last dummy row that is ignored |
4406 |
+ |
Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0 |
4407 |
+ |
Batch Completion Info |
4408 |
+ |
Total rows processed = 2 |
4409 |
+ |
Updated Records = 2 |
4410 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4411 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4412 |
+ |
Rows after update |
4413 |
+ |
EMP_NO = 2 |
4414 |
+ |
FIRST_NAME = Robert |
4415 |
+ |
LAST_NAME = Nelson |
4416 |
+ |
PHONE_EXT = 250 |
4417 |
+ |
HIRE_DATE = 2018/05/28 00:00:00.0000 |
4418 |
+ |
DEPT_NO = 600 |
4419 |
+ |
JOB_CODE = VP |
4420 |
+ |
JOB_GRADE = 2 |
4421 |
+ |
JOB_COUNTRY = USA |
4422 |
+ |
SALARY = 105,900.00 |
4423 |
+ |
FULL_NAME = Nelson, Robert |
4424 |
+ |
EMP_NO = 8 |
4425 |
+ |
FIRST_NAME = Leslie |
4426 |
+ |
LAST_NAME = Johnson |
4427 |
+ |
PHONE_EXT = 410 |
4428 |
+ |
HIRE_DATE = 2016/01/31 00:00:00.0000 |
4429 |
+ |
DEPT_NO = 180 |
4430 |
+ |
JOB_CODE = Mktg |
4431 |
+ |
JOB_GRADE = 3 |
4432 |
+ |
JOB_COUNTRY = USA |
4433 |
+ |
SALARY = 64,635.00 |
4434 |
+ |
FULL_NAME = Johnson, Leslie |
4435 |
+ |
|
4436 |
+ |
|
4437 |
+ |
Insert rows |
4438 |
+ |
Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0 |
4439 |
+ |
Batch Completion Info |
4440 |
+ |
Total rows processed = 3 |
4441 |
+ |
Updated Records = 3 |
4442 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4443 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4444 |
+ |
Row 3 State = bcNoMoreErrors Msg = |
4445 |
+ |
Rows after insert |
4446 |
+ |
EMP_NO = 150 |
4447 |
+ |
FIRST_NAME = John |
4448 |
+ |
LAST_NAME = Doe |
4449 |
+ |
PHONE_EXT = |
4450 |
+ |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
4451 |
+ |
DEPT_NO = 600 |
4452 |
+ |
JOB_CODE = Eng |
4453 |
+ |
JOB_GRADE = 4 |
4454 |
+ |
JOB_COUNTRY = England |
4455 |
+ |
SALARY = 41,000.89 |
4456 |
+ |
FULL_NAME = Doe, John |
4457 |
+ |
EMP_NO = 151 |
4458 |
+ |
FIRST_NAME = Jane |
4459 |
+ |
LAST_NAME = Doe |
4460 |
+ |
PHONE_EXT = |
4461 |
+ |
HIRE_DATE = 2015/04/02 00:00:00.0000 |
4462 |
+ |
DEPT_NO = 600 |
4463 |
+ |
JOB_CODE = Eng |
4464 |
+ |
JOB_GRADE = 4 |
4465 |
+ |
JOB_COUNTRY = England |
4466 |
+ |
SALARY = 42,000.89 |
4467 |
+ |
FULL_NAME = Doe, Jane |
4468 |
+ |
EMP_NO = 152 |
4469 |
+ |
FIRST_NAME = John |
4470 |
+ |
LAST_NAME = SmithAndJonesFamily1 |
4471 |
+ |
PHONE_EXT = |
4472 |
+ |
HIRE_DATE = 2015/04/03 00:00:00.0000 |
4473 |
+ |
DEPT_NO = 600 |
4474 |
+ |
JOB_CODE = Eng |
4475 |
+ |
JOB_GRADE = 4 |
4476 |
+ |
JOB_COUNTRY = England |
4477 |
+ |
SALARY = 41,000.99 |
4478 |
+ |
FULL_NAME = SmithAndJonesFamily1, John |
4479 |
+ |
|
4480 |
+ |
|
4481 |
+ |
Insert rows - and then cancel |
4482 |
+ |
Cancel Batch - note - next step will fail with a duplicate key if cancel fails |
4483 |
+ |
|
4484 |
+ |
Insert rows - ignore last row |
4485 |
+ |
Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0 |
4486 |
+ |
Batch Completion Info |
4487 |
+ |
Total rows processed = 2 |
4488 |
+ |
Updated Records = 2 |
4489 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4490 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4491 |
+ |
Rows after insert |
4492 |
+ |
EMP_NO = 150 |
4493 |
+ |
FIRST_NAME = John |
4494 |
+ |
LAST_NAME = Doe |
4495 |
+ |
PHONE_EXT = |
4496 |
+ |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
4497 |
+ |
DEPT_NO = 600 |
4498 |
+ |
JOB_CODE = Eng |
4499 |
+ |
JOB_GRADE = 4 |
4500 |
+ |
JOB_COUNTRY = England |
4501 |
+ |
SALARY = 41,000.89 |
4502 |
+ |
FULL_NAME = Doe, John |
4503 |
+ |
EMP_NO = 151 |
4504 |
+ |
FIRST_NAME = Jane |
4505 |
+ |
LAST_NAME = Doe |
4506 |
+ |
PHONE_EXT = |
4507 |
+ |
HIRE_DATE = 2015/04/02 00:00:00.0000 |
4508 |
+ |
DEPT_NO = 600 |
4509 |
+ |
JOB_CODE = Eng |
4510 |
+ |
JOB_GRADE = 4 |
4511 |
+ |
JOB_COUNTRY = England |
4512 |
+ |
SALARY = 42,000.89 |
4513 |
+ |
FULL_NAME = Doe, Jane |
4514 |
+ |
|
4515 |
+ |
Insert with inline blob |
4516 |
+ |
Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0 |
4517 |
+ |
Batch Completion Info |
4518 |
+ |
Total rows processed = 2 |
4519 |
+ |
Updated Records = 2 |
4520 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4521 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4522 |
+ |
Rows after insert |
4523 |
+ |
JOB_CODE = ABC |
4524 |
+ |
JOB_GRADE = 3 |
4525 |
+ |
JOB_COUNTRY = England |
4526 |
+ |
JOB_TITLE = Chief Tester |
4527 |
+ |
MIN_SALARY = 21,000.00 |
4528 |
+ |
MAX_SALARY = 24,000.99 |
4529 |
+ |
JOB_REQUIREMENT (Charset Id = 0 Codepage = 0) |
4530 |
+ |
|
4531 |
+ |
The quick brown fox jumped over the lazy dog |
4532 |
+ |
LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: ) |
4533 |
+ |
|
4534 |
+ |
JOB_CODE = DEF |
4535 |
+ |
JOB_GRADE = 3 |
4536 |
+ |
JOB_COUNTRY = England |
4537 |
+ |
JOB_TITLE = Deputy Tester |
4538 |
+ |
MIN_SALARY = 21,000.00 |
4539 |
+ |
MAX_SALARY = 24,000.99 |
4540 |
+ |
JOB_REQUIREMENT (Charset Id = 0 Codepage = 0) |
4541 |
+ |
|
4542 |
+ |
The quick brown fox jumped over the running dog |
4543 |
+ |
LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: ) |
4544 |
+ |
|
4545 |
+ |
|
4546 |
+ |
|
4547 |
+ |
Insert with explicit blob |
4548 |
+ |
Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0 |
4549 |
+ |
Batch Completion Info |
4550 |
+ |
Total rows processed = 2 |
4551 |
+ |
Updated Records = 2 |
4552 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4553 |
+ |
Row 2 State = bcNoMoreErrors Msg = |
4554 |
+ |
Rows after insert |
4555 |
+ |
JOB_CODE = ABC |
4556 |
+ |
JOB_GRADE = 3 |
4557 |
+ |
JOB_COUNTRY = England |
4558 |
+ |
JOB_TITLE = Chief Tester |
4559 |
+ |
MIN_SALARY = 21,000.00 |
4560 |
+ |
MAX_SALARY = 24,000.99 |
4561 |
+ |
JOB_REQUIREMENT (Charset Id = 0 Codepage = 0) |
4562 |
+ |
|
4563 |
+ |
The quick brown fox jumped over the lazy dog |
4564 |
+ |
LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: ) |
4565 |
+ |
|
4566 |
+ |
JOB_CODE = DEF |
4567 |
+ |
JOB_GRADE = 3 |
4568 |
+ |
JOB_COUNTRY = England |
4569 |
+ |
JOB_TITLE = Deputy Tester |
4570 |
+ |
MIN_SALARY = 21,000.00 |
4571 |
+ |
MAX_SALARY = 24,000.99 |
4572 |
+ |
JOB_REQUIREMENT (Charset Id = 0 Codepage = 0) |
4573 |
+ |
|
4574 |
+ |
The quick brown fox jumped over the running dog |
4575 |
+ |
LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: ) |
4576 |
+ |
|
4577 |
+ |
|
4578 |
+ |
Test Error Handling |
4579 |
+ |
Error reported (as expected) when changing param type: Param[0] "": Unable to change from a SQL_TIMESTAMP to a string type |
4580 |
+ |
Test Error Handling - Update returning should fail |
4581 |
+ |
Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched |
4582 |
+ |
Error handling when Insert rows - duplicate key |
4583 |
+ |
Error reported when inserting: Error Processing update/insert batch on row number 2 - SQLCODE: -803 |
4584 |
+ |
Engine Code: 335544665 Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values |
4585 |
+ |
violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE" |
4586 |
+ |
-Problematic key value is ("EMP_NO" = 150) |
4587 |
+ |
Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 |
4588 |
+ |
Batch Completion Info |
4589 |
+ |
Total rows processed = 2 |
4590 |
+ |
Updated Records = 1 |
4591 |
+ |
Row 1 State = bcNoMoreErrors Msg = |
4592 |
+ |
Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE" |
4593 |
+ |
-Problematic key value is ("EMP_NO" = 150) |
4594 |
+ |
|
4595 |
+ |
|
4596 |
+ |
------------------------------------------------------ |
4597 |
+ |
Running Test 20: Stress Test IBatch interface |
4598 |
+ |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
4599 |
+ |
10000 rows added |
4600 |
+ |
20000 rows added |
4601 |
+ |
30000 rows added |
4602 |
+ |
40000 rows added |
4603 |
+ |
50000 rows added |
4604 |
+ |
Batch Execute |
4605 |
+ |
Intermediate Apply Batch on row 50001 |
4606 |
+ |
Batch Completion Info |
4607 |
+ |
Total rows processed = 50000 |
4608 |
+ |
Updated Rows = 50000 |
4609 |
+ |
Row 50000 State = bcNoMoreErrors Msg = |
4610 |
+ |
60000 rows added |
4611 |
+ |
70000 rows added |
4612 |
+ |
80000 rows added |
4613 |
+ |
90000 rows added |
4614 |
+ |
100000 rows added |
4615 |
+ |
Batch Execute |
4616 |
+ |
Batch Completion Info |
4617 |
+ |
Total rows processed = 50000 |
4618 |
+ |
Updated Rows = 50000 |
4619 |
+ |
Row 50000 State = bcNoMoreErrors Msg = |
4620 |
+ |
Rows in Dataset = 100000 |
4621 |
+ |
Message Hash = 2014887b8ad27fbb20893a22d6e39f26 |
4622 |
+ |
Message Hash = 2014887b8ad27fbb20893a22d6e39f26 |
4623 |
+ |
Test Completed Successfully |
4624 |
+ |
|
4625 |
+ |
|
4626 |
+ |
------------------------------------------------------ |
4627 |
+ |
Running Test 21: Exercise setting and getting of numeric data types |
4628 |
+ |
1234.567 parsed to 1234567 scale = -3 |
4629 |
+ |
As Float = 1.2345670000000000E+003 |
4630 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
4631 |
+ |
As Float = -7.6543209999999999E+002 |
4632 |
+ |
0.1 parsed to 1 scale = -1 |
4633 |
+ |
As Float = 1.0000000000000001E-001 |
4634 |
+ |
0.01 parsed to 1 scale = -2 |
4635 |
+ |
As Float = 1.0000000000000000E-002 |
4636 |
+ |
+123 parsed to 123 scale = 0 |
4637 |
+ |
As Float = 1.2300000000000000E+002 |
4638 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
4639 |
+ |
As Float = 1.2345600000000001E+308 |
4640 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
4641 |
+ |
As Float = -1.2000000000000000E-002 |
4642 |
+ |
10. parsed to 10 scale = 0 |
4643 |
+ |
As Float = 1.0000000000000000E+001 |
4644 |
+ |
.12 parsed to 12 scale = -2 |
4645 |
+ |
As Float = 1.2000000000000000E-001 |
4646 |
+ |
0.12 parsed to 12 scale = -2 |
4647 |
+ |
As Float = 1.2000000000000000E-001 |
4648 |
+ |
Parsing of 1.2E1.2 failed |
4649 |
+ |
Parsing of 1,000 failed |
4650 |
+ |
Parsing of 1e1e1 failed |
4651 |
+ |
Parsing of 1.2+3 failed |
4652 |
+ |
Validating Numeric Interface - IFBNumeric |
4653 |
+ |
Value from Currency = 9999.1235 |
4654 |
+ |
Raw Value = 99991235 Scale = -4 |
4655 |
+ |
Value from Currency(rescaled) = 9999.12 |
4656 |
+ |
Raw Value = 999912 Scale = -2 |
4657 |
+ |
Value from Double = 9999.12345678 |
4658 |
+ |
Raw Value = 999912345678 Scale = -8 |
4659 |
+ |
Value from Integer = 9223372036854775807 |
4660 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
4661 |
+ |
Value from string = 9223372036854775807 |
4662 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
4663 |
+ |
Value from string = 9999.12345678 |
4664 |
+ |
Raw Value = 999912345678 Scale = -8 |
4665 |
+ |
Value from string = -0.12 |
4666 |
+ |
Raw Value = -12 Scale = -3 |
4667 |
+ |
Value from BCD = 9999.12345678 |
4668 |
+ |
Raw Value = 999912345678 Scale = -8 |
4669 |
+ |
Value from Raw Data = 9999123.456780 |
4670 |
+ |
Raw Value = 9999123456780 Scale = -6 |
4671 |
+ |
SQL Params |
4672 |
+ |
SQLType =SQL_LONG |
4673 |
+ |
sub type = 0 |
4674 |
+ |
Field Name = |
4675 |
+ |
Scale = 0 |
4676 |
+ |
Charset id = 0 |
4677 |
+ |
Not Null |
4678 |
+ |
Size = 4 |
4679 |
+ |
Value = 0 |
4680 |
+ |
|
4681 |
+ |
SQLType =SQL_LONG |
4682 |
+ |
sub type = 0 |
4683 |
+ |
Field Name = |
4684 |
+ |
Scale = 0 |
4685 |
+ |
Charset id = 0 |
4686 |
+ |
Nullable |
4687 |
+ |
Size = 4 |
4688 |
+ |
|
4689 |
+ |
SQLType =SQL_INT64 |
4690 |
+ |
sub type = 0 |
4691 |
+ |
Field Name = |
4692 |
+ |
Scale = 0 |
4693 |
+ |
Charset id = 0 |
4694 |
+ |
Nullable |
4695 |
+ |
Size = 8 |
4696 |
+ |
|
4697 |
+ |
SQLType =SQL_INT64 |
4698 |
+ |
sub type = 0 |
4699 |
+ |
Field Name = |
4700 |
+ |
Scale = -4 |
4701 |
+ |
Charset id = 0 |
4702 |
+ |
Nullable |
4703 |
+ |
Size = 8 |
4704 |
+ |
|
4705 |
+ |
SQLType =SQL_DOUBLE |
4706 |
+ |
sub type = 0 |
4707 |
+ |
Field Name = |
4708 |
+ |
Scale = 0 |
4709 |
+ |
Charset id = 0 |
4710 |
+ |
Nullable |
4711 |
+ |
Size = 8 |
4712 |
+ |
|
4713 |
+ |
SQLType =SQL_INT64 |
4714 |
+ |
sub type = 0 |
4715 |
+ |
Field Name = |
4716 |
+ |
Scale = -6 |
4717 |
+ |
Charset id = 0 |
4718 |
+ |
Nullable |
4719 |
+ |
Size = 8 |
4720 |
+ |
|
4721 |
+ |
Expected Error - SQLCODE: -303 |
4722 |
+ |
Engine Code: 335544569 Incompatible column/host variable data type |
4723 |
+ |
Dynamic SQL Error |
4724 |
+ |
-SQL error code = -303 |
4725 |
+ |
-conversion error from string "1,000" |
4726 |
+ |
Expected Error - SQLCODE: -303 |
4727 |
+ |
Engine Code: 335544569 Incompatible column/host variable data type |
4728 |
+ |
Dynamic SQL Error |
4729 |
+ |
-SQL error code = -303 |
4730 |
+ |
-conversion error from string "10.0.0" |
4731 |
+ |
Test Numeric Type |
4732 |
+ |
ROWID = 1 |
4733 |
+ |
ITYPE = 101 |
4734 |
+ |
I64TYPE = 9223372036854775807 |
4735 |
+ |
CURRTYPE = 10,000.12340000 |
4736 |
+ |
DTYPE = 9,999.12345678 |
4737 |
+ |
FIXEDPOINT = 1,234,567,890.12345700 |
4738 |
+ |
ROWID = 2 |
4739 |
+ |
ITYPE = -32457 |
4740 |
+ |
I64TYPE = -9223372036854775808 |
4741 |
+ |
CURRTYPE = 1,000,001.12000000 |
4742 |
+ |
DTYPE = 1.7E308 |
4743 |
+ |
FIXEDPOINT = -1,234,567,890.12345700 |
4744 |
+ |
ROWID = 3 |
4745 |
+ |
ITYPE = 0 |
4746 |
+ |
I64TYPE = 0 |
4747 |
+ |
CURRTYPE = .00000000 |
4748 |
+ |
DTYPE = .00000000 |
4749 |
+ |
FIXEDPOINT = .00000000 |
4750 |
+ |
ROWID = 4 |
4751 |
+ |
ITYPE = 1 |
4752 |
+ |
I64TYPE = 10 |
4753 |
+ |
CURRTYPE = .02300000 |
4754 |
+ |
DTYPE = .00110000 |
4755 |
+ |
FIXEDPOINT = 233.45600000 |
4756 |
+ |
ROWID = 7 |
4757 |
+ |
ITYPE = 1 |
4758 |
+ |
I64TYPE = 1234567 |
4759 |
+ |
CURRTYPE = .02300000 |
4760 |
+ |
DTYPE = .00110000 |
4761 |
+ |
FIXEDPOINT = 1,234.25000000 |
4762 |
+ |
|
4763 |
+ |
|
4764 |
+ |
|
4765 |
+ |
------------------------------------------------------ |
4766 |
+ |
Running Test 22: Journalling |
4767 |
+ |
Start Journaling. Session ID = 0 |
4768 |
+ |
1234.567 parsed to 1234567 scale = -3 |
4769 |
+ |
As Float = 1.2345670000000000E+003 |
4770 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
4771 |
+ |
As Float = -7.6543209999999999E+002 |
4772 |
+ |
0.1 parsed to 1 scale = -1 |
4773 |
+ |
As Float = 1.0000000000000001E-001 |
4774 |
+ |
0.01 parsed to 1 scale = -2 |
4775 |
+ |
As Float = 1.0000000000000000E-002 |
4776 |
+ |
+123 parsed to 123 scale = 0 |
4777 |
+ |
As Float = 1.2300000000000000E+002 |
4778 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
4779 |
+ |
As Float = 1.2345600000000001E+308 |
4780 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
4781 |
+ |
As Float = -1.2000000000000000E-002 |
4782 |
+ |
10. parsed to 10 scale = 0 |
4783 |
+ |
As Float = 1.0000000000000000E+001 |
4784 |
+ |
.12 parsed to 12 scale = -2 |
4785 |
+ |
As Float = 1.2000000000000000E-001 |
4786 |
+ |
0.12 parsed to 12 scale = -2 |
4787 |
+ |
As Float = 1.2000000000000000E-001 |
4788 |
+ |
Parsing of 1.2E1.2 failed |
4789 |
+ |
Parsing of 1,000 failed |
4790 |
+ |
Parsing of 1e1e1 failed |
4791 |
+ |
Parsing of 1.2+3 failed |
4792 |
+ |
SQL Params |
4793 |
+ |
SQLType =SQL_LONG |
4794 |
+ |
sub type = 0 |
4795 |
+ |
Field Name = |
4796 |
+ |
Scale = 0 |
4797 |
+ |
Charset id = 0 |
4798 |
+ |
Not Null |
4799 |
+ |
Size = 4 |
4800 |
+ |
Value = 0 |
4801 |
+ |
|
4802 |
+ |
SQLType =SQL_LONG |
4803 |
+ |
sub type = 0 |
4804 |
+ |
Field Name = |
4805 |
+ |
Scale = 0 |
4806 |
+ |
Charset id = 0 |
4807 |
+ |
Nullable |
4808 |
+ |
Size = 4 |
4809 |
+ |
|
4810 |
+ |
SQLType =SQL_INT64 |
4811 |
+ |
sub type = 0 |
4812 |
+ |
Field Name = |
4813 |
+ |
Scale = 0 |
4814 |
+ |
Charset id = 0 |
4815 |
+ |
Nullable |
4816 |
+ |
Size = 8 |
4817 |
+ |
|
4818 |
+ |
SQLType =SQL_INT64 |
4819 |
+ |
sub type = 0 |
4820 |
+ |
Field Name = |
4821 |
+ |
Scale = -4 |
4822 |
+ |
Charset id = 0 |
4823 |
+ |
Nullable |
4824 |
+ |
Size = 8 |
4825 |
+ |
|
4826 |
+ |
SQLType =SQL_DOUBLE |
4827 |
+ |
sub type = 0 |
4828 |
+ |
Field Name = |
4829 |
+ |
Scale = 0 |
4830 |
+ |
Charset id = 0 |
4831 |
+ |
Nullable |
4832 |
+ |
Size = 8 |
4833 |
+ |
|
4834 |
+ |
SQLType =SQL_INT64 |
4835 |
+ |
sub type = 0 |
4836 |
+ |
Field Name = |
4837 |
+ |
Scale = -6 |
4838 |
+ |
Charset id = 0 |
4839 |
+ |
Nullable |
4840 |
+ |
Size = 8 |
4841 |
+ |
|
4842 |
+ |
|
4843 |
+ |
Text Tests |
4844 |
+ |
SQL Params |
4845 |
+ |
SQLType =SQL_LONG |
4846 |
+ |
sub type = 0 |
4847 |
+ |
Field Name = |
4848 |
+ |
Scale = 0 |
4849 |
+ |
Charset id = 0 |
4850 |
+ |
Not Null |
4851 |
+ |
Size = 4 |
4852 |
+ |
Value = 0 |
4853 |
+ |
|
4854 |
+ |
SQLType =SQL_VARYING |
4855 |
+ |
sub type = 0 |
4856 |
+ |
Field Name = |
4857 |
+ |
Scale = 0 |
4858 |
+ |
Charset id = 4 |
4859 |
+ |
Nullable |
4860 |
+ |
Size = 1024 |
4861 |
+ |
|
4862 |
+ |
SQLType =SQL_BLOB |
4863 |
+ |
sub type = 1 |
4864 |
+ |
Field Name = |
4865 |
+ |
Scale = 0 |
4866 |
+ |
Charset id = 4 |
4867 |
+ |
Nullable |
4868 |
+ |
Size = 8 |
4869 |
+ |
|
4870 |
+ |
|
4871 |
+ |
Binary Blob Tests |
4872 |
+ |
|
4873 |
+ |
Array Test |
4874 |
+ |
SQL Params |
4875 |
+ |
SQLType =SQL_LONG |
4876 |
+ |
sub type = 0 |
4877 |
+ |
Field Name = |
4878 |
+ |
Scale = 0 |
4879 |
+ |
Charset id = 0 |
4880 |
+ |
Not Null |
4881 |
+ |
Size = 4 |
4882 |
+ |
Value = 0 |
4883 |
+ |
|
4884 |
+ |
SQLType =SQL_ARRAY |
4885 |
+ |
sub type = 0 |
4886 |
+ |
Field Name = |
4887 |
+ |
Scale = 0 |
4888 |
+ |
Charset id = 0 |
4889 |
+ |
Nullable |
4890 |
+ |
Size = 8 |
4891 |
+ |
|
4892 |
+ |
ROWID = 1 |
4893 |
+ |
ITYPE = 101 |
4894 |
+ |
I64TYPE = 9223372036854775807 |
4895 |
+ |
CURRTYPE = 10,000.12340000 |
4896 |
+ |
DTYPE = 9,999.12345678 |
4897 |
+ |
FIXEDPOINT = 1,234,567,890.12345700 |
4898 |
+ |
STR = NULL |
4899 |
+ |
TEXTBLOB = NULL |
4900 |
+ |
OTHERBLOB = NULL |
4901 |
+ |
MYARRAY = NULL |
4902 |
+ |
ROWID = 2 |
4903 |
+ |
ITYPE = -32457 |
4904 |
+ |
I64TYPE = -9223372036854775808 |
4905 |
+ |
CURRTYPE = 1,000,001.12000000 |
4906 |
+ |
DTYPE = 1.7E308 |
4907 |
+ |
FIXEDPOINT = -1,234,567,890.12345700 |
4908 |
+ |
STR = NULL |
4909 |
+ |
TEXTBLOB = NULL |
4910 |
+ |
OTHERBLOB = NULL |
4911 |
+ |
MYARRAY = NULL |
4912 |
+ |
ROWID = 4 |
4913 |
+ |
ITYPE = 1 |
4914 |
+ |
I64TYPE = 10 |
4915 |
+ |
CURRTYPE = .02300000 |
4916 |
+ |
DTYPE = .00110000 |
4917 |
+ |
FIXEDPOINT = 233.45600000 |
4918 |
+ |
STR = NULL |
4919 |
+ |
TEXTBLOB = NULL |
4920 |
+ |
OTHERBLOB = NULL |
4921 |
+ |
MYARRAY = NULL |
4922 |
+ |
|
4923 |
+ |
Journal Table |
4924 |
+ |
IBX$SESSIONID = 1 |
4925 |
+ |
IBX$TRANSACTIONID = 9 |
4926 |
+ |
IBX$OLDTRANSACTIONID = NULL |
4927 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
4928 |
+ |
IBX$CREATED = 2022/01/02 14:16:56.6410 |
4929 |
+ |
IBX$SESSIONID = 1 |
4930 |
+ |
IBX$TRANSACTIONID = 11 |
4931 |
+ |
IBX$OLDTRANSACTIONID = 10 |
4932 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
4933 |
+ |
IBX$CREATED = 2022/01/02 14:16:56.9850 |
4934 |
+ |
|
4935 |
+ |
Journal Entries |
4936 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
4937 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4938 |
+ |
Attachment ID = 4 |
4939 |
+ |
Session ID = 1 |
4940 |
+ |
Transaction ID = 9 |
4941 |
+ |
Transaction Name = "Transaction_29_1" |
4942 |
+ |
TPB: Item Count = 3 |
4943 |
+ |
isc_tpb_write |
4944 |
+ |
isc_tpb_nowait |
4945 |
+ |
isc_tpb_concurrency |
4946 |
+ |
|
4947 |
+ |
Default Completion = TACommit |
4948 |
+ |
|
4949 |
+ |
Journal Entry = jeQuery(Query) |
4950 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4951 |
+ |
Attachment ID = 4 |
4952 |
+ |
Session ID = 1 |
4953 |
+ |
Transaction ID = 9 |
4954 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346) |
4955 |
+ |
|
4956 |
+ |
Journal Entry = jeQuery(Query) |
4957 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4958 |
+ |
Attachment ID = 4 |
4959 |
+ |
Session ID = 1 |
4960 |
+ |
Transaction ID = 9 |
4961 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346) |
4962 |
+ |
|
4963 |
+ |
Journal Entry = jeTransCommitRet(Commit Retaining) |
4964 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4965 |
+ |
Attachment ID = 4 |
4966 |
+ |
Session ID = 1 |
4967 |
+ |
Transaction ID = 10 |
4968 |
+ |
Old TransactionID = 9 |
4969 |
+ |
|
4970 |
+ |
Journal Entry = jeQuery(Query) |
4971 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4972 |
+ |
Attachment ID = 4 |
4973 |
+ |
Session ID = 1 |
4974 |
+ |
Transaction ID = 10 |
4975 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) |
4976 |
+ |
|
4977 |
+ |
Journal Entry = jeTransRollbackRet(Rollback Retaining) |
4978 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4979 |
+ |
Attachment ID = 4 |
4980 |
+ |
Session ID = 1 |
4981 |
+ |
Transaction ID = 11 |
4982 |
+ |
Old TransactionID = 10 |
4983 |
+ |
|
4984 |
+ |
Journal Entry = jeQuery(Query) |
4985 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4986 |
+ |
Attachment ID = 4 |
4987 |
+ |
Session ID = 1 |
4988 |
+ |
Transaction ID = 11 |
4989 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456) |
4990 |
+ |
|
4991 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
4992 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
4993 |
+ |
Attachment ID = 4 |
4994 |
+ |
Session ID = 1 |
4995 |
+ |
Transaction ID = 12 |
4996 |
+ |
Transaction Name = "Transaction_29_2" |
4997 |
+ |
TPB: Item Count = 3 |
4998 |
+ |
isc_tpb_write |
4999 |
+ |
isc_tpb_nowait |
5000 |
+ |
isc_tpb_concurrency |
5001 |
+ |
|
5002 |
+ |
Default Completion = TARollback |
5003 |
+ |
|
5004 |
+ |
Journal Entry = jeTransCommit(Commit) |
5005 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5006 |
+ |
Attachment ID = 4 |
5007 |
+ |
Session ID = 1 |
5008 |
+ |
Transaction ID = 11 |
5009 |
+ |
|
5010 |
+ |
Journal Entry = jeQuery(Query) |
5011 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5012 |
+ |
Attachment ID = 4 |
5013 |
+ |
Session ID = 1 |
5014 |
+ |
Transaction ID = 12 |
5015 |
+ |
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: |
5016 |
+ |
Whether ''tis nobler in the mind to suffer |
5017 |
+ |
The slings and arrows of outrageous fortune, |
5018 |
+ |
Or to take arms against a sea of troubles, |
5019 |
+ |
And, by opposing, end them. To die, to sleep- |
5020 |
+ |
No more-and by a sleep to say we end |
5021 |
+ |
The heartache and the thousand natural shocks |
5022 |
+ |
That flesh is heir to-''tis a consummation |
5023 |
+ |
Devoutly to be wished. To die, to sleep- |
5024 |
+ |
To sleep, perchance to dream. Aye, there''s the rub, |
5025 |
+ |
For in that sleep of death what dreams may come, |
5026 |
+ |
When we have shuffled off this mortal coil, |
5027 |
+ |
Must give us pause. There''s the respect |
5028 |
+ |
That makes calamity of so long life. |
5029 |
+ |
For who would bear the whips and scorns of time, |
5030 |
+ |
Th'' oppressor''s wrong, the proud man''s contumely, |
5031 |
+ |
The pangs of despised love, the law’s delay, |
5032 |
+ |
The insolence of office, and the spurns |
5033 |
+ |
That patient merit of the unworthy takes, |
5034 |
+ |
When he himself might his quietus make |
5035 |
+ |
With a bare bodkin? Who would fardels bear, |
5036 |
+ |
To grunt and sweat under a weary life, |
5037 |
+ |
But that the dread of something after death, |
5038 |
+ |
The undiscovered country from whose bourn |
5039 |
+ |
No traveler returns, puzzles the will |
5040 |
+ |
And makes us rather bear those ills we have |
5041 |
+ |
Than fly to others that we know not of? |
5042 |
+ |
Thus conscience does make cowards of us all, |
5043 |
+ |
And thus the native hue of resolution |
5044 |
+ |
Is sicklied o''er with the pale cast of thought, |
5045 |
+ |
And enterprises of great pitch and moment, |
5046 |
+ |
With this regard their currents turn awry, |
5047 |
+ |
And lose the name of action.-Soft you now, |
5048 |
+ |
The fair Ophelia.-Nymph, in thy orisons |
5049 |
+ |
Be all my sins remembered |
5050 |
+ |
') |
5051 |
+ |
|
5052 |
+ |
Journal Entry = jeQuery(Query) |
5053 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5054 |
+ |
Attachment ID = 4 |
5055 |
+ |
Session ID = 1 |
5056 |
+ |
Transaction ID = 12 |
5057 |
+ |
Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0"> |
5058 |
+ |
FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00 |
5059 |
+ |
0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300 |
5060 |
+ |
01000000010000001A01050001000000DA000000 |
5061 |
+ |
</blob> |
5062 |
+ |
) |
5063 |
+ |
|
5064 |
+ |
Journal Entry = jeQuery(Query) |
5065 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5066 |
+ |
Attachment ID = 4 |
5067 |
+ |
Session ID = 1 |
5068 |
+ |
Transaction ID = 12 |
5069 |
+ |
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"> |
5070 |
+ |
<elt ix="0">100</elt> |
5071 |
+ |
<elt ix="1">99</elt> |
5072 |
+ |
<elt ix="2">98</elt> |
5073 |
+ |
<elt ix="3">97</elt> |
5074 |
+ |
<elt ix="4">96</elt> |
5075 |
+ |
<elt ix="5">95</elt> |
5076 |
+ |
<elt ix="6">94</elt> |
5077 |
+ |
<elt ix="7">93</elt> |
5078 |
+ |
<elt ix="8">92</elt> |
5079 |
+ |
<elt ix="9">91</elt> |
5080 |
+ |
<elt ix="10">90</elt> |
5081 |
+ |
<elt ix="11">89</elt> |
5082 |
+ |
<elt ix="12">88</elt> |
5083 |
+ |
<elt ix="13">87</elt> |
5084 |
+ |
<elt ix="14">86</elt> |
5085 |
+ |
<elt ix="15">85</elt> |
5086 |
+ |
<elt ix="16">84</elt> |
5087 |
+ |
</array> |
5088 |
+ |
) |
5089 |
+ |
|
5090 |
+ |
Journal Entry = jeTransRollback(Rollback) |
5091 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
5092 |
+ |
Attachment ID = 4 |
5093 |
+ |
Session ID = 1 |
5094 |
+ |
Transaction ID = 12 |
5095 |
+ |
|
5096 |
+ |
|
5097 |
+ |
|
5098 |
|
------------------------------------------------------ |
5099 |
|
Test Suite Ends |