| 3 |
|
|
| 4 |
|
Starting Tests |
| 5 |
|
Client API Version = 4.0 |
| 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 |
| 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/firebird4.0.0/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.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" |
| 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/firebird4.0.0/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/firebird4.0.0/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 |
| 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 |
| 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 |
| 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 |
| 651 |
|
Opening inet://localhost/employee |
| 652 |
|
Database Open |
| 653 |
|
Employee Count = 42 |
| 654 |
+ |
Transaction ID = 5281 |
| 655 |
+ |
Transaction is Read/Write |
| 656 |
+ |
Transaction Database Path = inet://localhost/employee |
| 657 |
+ |
Transaction ID = 5281 |
| 658 |
+ |
Oldest Interesting = 1895 |
| 659 |
+ |
Oldest Action = 5280 |
| 660 |
+ |
Oldest Snapshot = 5280 |
| 661 |
+ |
Oldest Snapshot Number = 1 |
| 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.2496 Firebird 4.0" |
| 679 |
< |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
| 680 |
< |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/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,767,952 |
| 695 |
> |
Current memory = 19,762,192 |
| 696 |
|
Delta memory = 4,464 |
| 697 |
< |
Max memory = 19,813,568 |
| 698 |
< |
Elapsed time= 0.000 sec |
| 697 |
> |
Max memory = 19,807,520 |
| 698 |
> |
Elapsed time= 0.002 sec |
| 699 |
|
Cpu = 0.000 sec |
| 700 |
|
Buffers = 2048 |
| 701 |
|
Reads = 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 |
|
|
| 2833 |
|
|
| 2834 |
|
------------------------------------------------------ |
| 2835 |
|
Running Test 9: Database Information tests |
| 2836 |
< |
Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus |
| 2837 |
< |
Pages =1075 |
| 2836 |
> |
Database ID = 4 FB = /opt/firebird4.0.1/examples/empbuild/employee.fdb SN = zeus |
| 2837 |
> |
Pages =413 |
| 2838 |
|
Base Level = 13,4,0,3, |
| 2839 |
|
Implementation = 11,7,0,3,66,1,66, |
| 2840 |
|
Reserved = 0 |
| 2841 |
|
ODS minor = 0 |
| 2842 |
|
ODS major = 13 |
| 2843 |
|
Page Size = 8192 |
| 2844 |
< |
Version = 1: LI-V6.3.0.2496 Firebird 4.0 |
| 2844 |
> |
Version = 1: LI-V6.3.1.2692 Firebird 4.0 |
| 2845 |
|
Database is Read/Write |
| 2846 |
< |
Database Created: 29/5/2021 16:47:30 |
| 2847 |
< |
Pages Used = 313 |
| 2848 |
< |
Pages Free = 762 |
| 2849 |
< |
Server Memory = 19484112 |
| 2846 |
> |
Database Created: 21/12/2021 10:52:59 |
| 2847 |
> |
Pages Used = 351 |
| 2848 |
> |
Pages Free = 62 |
| 2849 |
> |
Server Memory = 19476112 |
| 2850 |
|
Forced Writes = 1 |
| 2851 |
< |
Max Memory = 19630384 |
| 2851 |
> |
Max Memory = 19506944 |
| 2852 |
|
Num Buffers = 2048 |
| 2853 |
|
Sweep Interval = 20000 |
| 2854 |
|
Logged in Users: SYSDBA, |
| 2855 |
|
Active Transaction Count = 0 |
| 2856 |
< |
Fetches = 1648 |
| 2857 |
< |
Writes = 8 |
| 2858 |
< |
Reads = 92 |
| 2859 |
< |
Page Writes = 4 |
| 2856 |
> |
Fetches = 1683 |
| 2857 |
> |
Writes = 6 |
| 2858 |
> |
Reads = 97 |
| 2859 |
> |
Page Writes = 3 |
| 2860 |
|
Record Version Removals Operation Counts |
| 2861 |
|
|
| 2862 |
|
Deletes Operation Counts |
| 2871 |
|
Table ID = 4 |
| 2872 |
|
Count = 63 |
| 2873 |
|
Table ID = 6 |
| 2874 |
< |
Count = 23 |
| 2874 |
> |
Count = 13 |
| 2875 |
|
Table ID = 9 |
| 2876 |
< |
Count = 3 |
| 2876 |
> |
Count = 1 |
| 2877 |
|
Table ID = 11 |
| 2878 |
|
Count = 2 |
| 2879 |
|
Table ID = 12 |
| 2880 |
|
Count = 24 |
| 2881 |
|
Table ID = 18 |
| 2882 |
< |
Count = 816 |
| 2882 |
> |
Count = 940 |
| 2883 |
|
Table ID = 20 |
| 2884 |
|
Count = 5 |
| 2885 |
|
Table ID = 28 |
| 2891 |
|
|
| 2892 |
|
Sequential Table Scans Operation Counts |
| 2893 |
|
Table ID = 0 |
| 2894 |
< |
Count = 100 |
| 2894 |
> |
Count = 98 |
| 2895 |
|
Table ID = 1 |
| 2896 |
< |
Count = 24 |
| 2896 |
> |
Count = 14 |
| 2897 |
|
|
| 2898 |
|
Update Count Operation Counts |
| 2899 |
|
|
| 2934 |
|
password = masterkey |
| 2935 |
|
|
| 2936 |
|
Service Manager Version = 2 |
| 2937 |
< |
Server Version = LI-V4.0.0.2496 Firebird 4.0 |
| 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/firebird4.0.0/ |
| 2942 |
< |
Security File = /opt/firebird4.0.0/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 |
|
|
| 2971 |
|
|
| 2972 |
|
|
| 2973 |
|
|
| 2974 |
+ |
|
| 2975 |
|
Local Backup Complete |
| 2976 |
|
|
| 2977 |
|
Local Restore |
| 3245 |
|
------------------------------------------------------ |
| 3246 |
|
Running Test 16: Error handling |
| 3247 |
|
Invalid Database Name Test |
| 3248 |
< |
Error Handled: I/O error during "open" operation for file "Malformed Name" |
| 3248 |
> |
Error Handled: SQLCODE: -902 |
| 3249 |
> |
Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3250 |
> |
I/O error during "open" operation for file "Malformed Name" |
| 3251 |
|
-Error while trying to open file |
| 3252 |
|
-No such file or directory |
| 3253 |
|
Invalid User Name Test |
| 3254 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3254 |
> |
Error Handled: SQLCODE: -902 |
| 3255 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3256 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3257 |
|
Invalid password Test |
| 3258 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3258 |
> |
Error Handled: SQLCODE: -902 |
| 3259 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3260 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3261 |
|
Invalid Prepare SQL Test |
| 3262 |
< |
Error Handled: Dynamic SQL Error |
| 3262 |
> |
Error Handled: SQLCODE: -206 |
| 3263 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
| 3264 |
> |
Dynamic SQL Error |
| 3265 |
|
-SQL error code = -206 |
| 3266 |
|
-Column unknown |
| 3267 |
|
-UNKNOWN_DATE |
| 3268 |
|
-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
| 3269 |
|
Invalid Open Cursor SQL Test |
| 3270 |
< |
Error Handled: Dynamic SQL Error |
| 3270 |
> |
Error Handled: SQLCODE: -206 |
| 3271 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
| 3272 |
> |
Dynamic SQL Error |
| 3273 |
|
-SQL error code = -206 |
| 3274 |
|
-Column unknown |
| 3275 |
|
-X |
| 3296 |
|
COUNTER = 42 |
| 3297 |
|
|
| 3298 |
|
Invalid Server Name Test |
| 3299 |
< |
Error Handled: Unable to complete network request to host "unknown". |
| 3299 |
> |
Error Handled: SQLCODE: -902 |
| 3300 |
> |
Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3301 |
> |
Unable to complete network request to host "unknown". |
| 3302 |
|
-Failed to locate host machine. |
| 3303 |
|
-The specified name was not found in the hosts file or Domain Name Services |
| 3304 |
|
Invalid User Name Test |
| 3305 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3305 |
> |
Error Handled: SQLCODE: -902 |
| 3306 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3307 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3308 |
|
Invalid password Test |
| 3309 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3309 |
> |
Error Handled: SQLCODE: -902 |
| 3310 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
| 3311 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 3312 |
|
|
| 3313 |
|
|
| 3314 |
|
------------------------------------------------------ |
| 3315 |
|
Running Test 17: Date/Time tests and Firebird 4 extensions |
| 3316 |
< |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
| 3316 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
| 3317 |
|
Has Local TZ DB = TRUE |
| 3318 |
|
|
| 3319 |
|
Testdata |
| 4075 |
|
|
| 4076 |
|
------------------------------------------------------ |
| 4077 |
|
Running Test 18: Firebird 4 Decfloat extensions |
| 4078 |
< |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
| 4078 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
| 4079 |
|
|
| 4080 |
|
FB4 Testdata_DECFloat |
| 4081 |
|
|
| 4344 |
|
Running Test 19: Batch Update and Insert Queries |
| 4345 |
|
Opening inet://localhost/employee |
| 4346 |
|
Database Open |
| 4347 |
< |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
| 4348 |
< |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
| 4349 |
< |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ" |
| 4347 |
> |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
| 4348 |
> |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" |
| 4349 |
> |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ" |
| 4350 |
|
on disk structure version 13.0 |
| 4351 |
|
Rows before update |
| 4352 |
|
EMP_NO = 2 |
| 4577 |
|
|
| 4578 |
|
|
| 4579 |
|
Test Error Handling |
| 4580 |
< |
Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING |
| 4580 |
> |
Error reported (as expected) when changing param type: Param[0] "": Unable to change from a SQL_TIMESTAMP to a string type |
| 4581 |
|
Test Error Handling - Update returning should fail |
| 4582 |
|
Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched |
| 4583 |
|
Error handling when Insert rows - duplicate key |
| 4584 |
< |
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" |
| 4584 |
> |
Error reported when inserting: Error Processing update/insert batch on row number 2 - SQLCODE: -803 |
| 4585 |
> |
Engine Code: 335544665 Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values |
| 4586 |
> |
violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE" |
| 4587 |
|
-Problematic key value is ("EMP_NO" = 150) |
| 4588 |
|
Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 |
| 4589 |
|
Batch Completion Info |
| 4596 |
|
|
| 4597 |
|
------------------------------------------------------ |
| 4598 |
|
Running Test 20: Stress Test IBatch interface |
| 4599 |
< |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0" |
| 4599 |
> |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0" |
| 4600 |
|
10000 rows added |
| 4601 |
|
20000 rows added |
| 4602 |
|
30000 rows added |
| 4626 |
|
|
| 4627 |
|
------------------------------------------------------ |
| 4628 |
|
Running Test 21: Exercise setting and getting of numeric data types |
| 4629 |
+ |
1234.567 parsed to 1234567 scale = -3 |
| 4630 |
+ |
As Float = 1.2345670000000000E+003 |
| 4631 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
| 4632 |
+ |
As Float = -7.6543209999999999E+002 |
| 4633 |
+ |
0.1 parsed to 1 scale = -1 |
| 4634 |
+ |
As Float = 1.0000000000000001E-001 |
| 4635 |
+ |
0.01 parsed to 1 scale = -2 |
| 4636 |
+ |
As Float = 1.0000000000000000E-002 |
| 4637 |
+ |
+123 parsed to 123 scale = 0 |
| 4638 |
+ |
As Float = 1.2300000000000000E+002 |
| 4639 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
| 4640 |
+ |
As Float = 1.2345600000000001E+308 |
| 4641 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
| 4642 |
+ |
As Float = -1.2000000000000000E-002 |
| 4643 |
+ |
10. parsed to 10 scale = 0 |
| 4644 |
+ |
As Float = 1.0000000000000000E+001 |
| 4645 |
+ |
.12 parsed to 12 scale = -2 |
| 4646 |
+ |
As Float = 1.2000000000000000E-001 |
| 4647 |
+ |
0.12 parsed to 12 scale = -2 |
| 4648 |
+ |
As Float = 1.2000000000000000E-001 |
| 4649 |
+ |
Parsing of 1.2E1.2 failed |
| 4650 |
+ |
Parsing of 1,000 failed |
| 4651 |
+ |
Parsing of 1e1e1 failed |
| 4652 |
+ |
Parsing of 1.2+3 failed |
| 4653 |
+ |
Validating Numeric Interface - IFBNumeric |
| 4654 |
+ |
Value from Currency = 9999.1235 |
| 4655 |
+ |
Raw Value = 99991235 Scale = -4 |
| 4656 |
+ |
Value from Currency(rescaled) = 9999.12 |
| 4657 |
+ |
Raw Value = 999912 Scale = -2 |
| 4658 |
+ |
Value from Double = 9999.12345678 |
| 4659 |
+ |
Raw Value = 999912345678 Scale = -8 |
| 4660 |
+ |
Value from Integer = 9223372036854775807 |
| 4661 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
| 4662 |
+ |
Value from string = 9223372036854775807 |
| 4663 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
| 4664 |
+ |
Value from string = 9999.12345678 |
| 4665 |
+ |
Raw Value = 999912345678 Scale = -8 |
| 4666 |
+ |
Value from string = -0.12 |
| 4667 |
+ |
Raw Value = -12 Scale = -3 |
| 4668 |
+ |
Value from BCD = 9999.12345678 |
| 4669 |
+ |
Raw Value = 999912345678 Scale = -8 |
| 4670 |
+ |
Value from Raw Data = 9999123.456780 |
| 4671 |
+ |
Raw Value = 9999123456780 Scale = -6 |
| 4672 |
|
SQL Params |
| 4673 |
|
SQLType =SQL_LONG |
| 4674 |
|
sub type = 0 |
| 4729 |
|
Dynamic SQL Error |
| 4730 |
|
-SQL error code = -303 |
| 4731 |
|
-conversion error from string "10.0.0" |
| 4732 |
+ |
Test Numeric Type |
| 4733 |
|
ROWID = 1 |
| 4734 |
|
ITYPE = 101 |
| 4735 |
|
I64TYPE = 9223372036854775807 |
| 4752 |
|
ITYPE = 1 |
| 4753 |
|
I64TYPE = 10 |
| 4754 |
|
CURRTYPE = .02300000 |
| 4755 |
< |
DTYPE = .00000000 |
| 4755 |
> |
DTYPE = .00110000 |
| 4756 |
|
FIXEDPOINT = 233.45600000 |
| 4757 |
+ |
ROWID = 7 |
| 4758 |
+ |
ITYPE = 1 |
| 4759 |
+ |
I64TYPE = 1234567 |
| 4760 |
+ |
CURRTYPE = .02300000 |
| 4761 |
+ |
DTYPE = .00110000 |
| 4762 |
+ |
FIXEDPOINT = 1,234.25000000 |
| 4763 |
+ |
|
| 4764 |
+ |
|
| 4765 |
+ |
|
| 4766 |
+ |
------------------------------------------------------ |
| 4767 |
+ |
Running Test 22: Journalling |
| 4768 |
+ |
Start Journaling. Session ID = 0 |
| 4769 |
+ |
1234.567 parsed to 1234567 scale = -3 |
| 4770 |
+ |
As Float = 1.2345670000000000E+003 |
| 4771 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
| 4772 |
+ |
As Float = -7.6543209999999999E+002 |
| 4773 |
+ |
0.1 parsed to 1 scale = -1 |
| 4774 |
+ |
As Float = 1.0000000000000001E-001 |
| 4775 |
+ |
0.01 parsed to 1 scale = -2 |
| 4776 |
+ |
As Float = 1.0000000000000000E-002 |
| 4777 |
+ |
+123 parsed to 123 scale = 0 |
| 4778 |
+ |
As Float = 1.2300000000000000E+002 |
| 4779 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
| 4780 |
+ |
As Float = 1.2345600000000001E+308 |
| 4781 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
| 4782 |
+ |
As Float = -1.2000000000000000E-002 |
| 4783 |
+ |
10. parsed to 10 scale = 0 |
| 4784 |
+ |
As Float = 1.0000000000000000E+001 |
| 4785 |
+ |
.12 parsed to 12 scale = -2 |
| 4786 |
+ |
As Float = 1.2000000000000000E-001 |
| 4787 |
+ |
0.12 parsed to 12 scale = -2 |
| 4788 |
+ |
As Float = 1.2000000000000000E-001 |
| 4789 |
+ |
Parsing of 1.2E1.2 failed |
| 4790 |
+ |
Parsing of 1,000 failed |
| 4791 |
+ |
Parsing of 1e1e1 failed |
| 4792 |
+ |
Parsing of 1.2+3 failed |
| 4793 |
+ |
SQL Params |
| 4794 |
+ |
SQLType =SQL_LONG |
| 4795 |
+ |
sub type = 0 |
| 4796 |
+ |
Field Name = |
| 4797 |
+ |
Scale = 0 |
| 4798 |
+ |
Charset id = 0 |
| 4799 |
+ |
Not Null |
| 4800 |
+ |
Size = 4 |
| 4801 |
+ |
Value = 0 |
| 4802 |
+ |
|
| 4803 |
+ |
SQLType =SQL_LONG |
| 4804 |
+ |
sub type = 0 |
| 4805 |
+ |
Field Name = |
| 4806 |
+ |
Scale = 0 |
| 4807 |
+ |
Charset id = 0 |
| 4808 |
+ |
Nullable |
| 4809 |
+ |
Size = 4 |
| 4810 |
+ |
|
| 4811 |
+ |
SQLType =SQL_INT64 |
| 4812 |
+ |
sub type = 0 |
| 4813 |
+ |
Field Name = |
| 4814 |
+ |
Scale = 0 |
| 4815 |
+ |
Charset id = 0 |
| 4816 |
+ |
Nullable |
| 4817 |
+ |
Size = 8 |
| 4818 |
+ |
|
| 4819 |
+ |
SQLType =SQL_INT64 |
| 4820 |
+ |
sub type = 0 |
| 4821 |
+ |
Field Name = |
| 4822 |
+ |
Scale = -4 |
| 4823 |
+ |
Charset id = 0 |
| 4824 |
+ |
Nullable |
| 4825 |
+ |
Size = 8 |
| 4826 |
+ |
|
| 4827 |
+ |
SQLType =SQL_DOUBLE |
| 4828 |
+ |
sub type = 0 |
| 4829 |
+ |
Field Name = |
| 4830 |
+ |
Scale = 0 |
| 4831 |
+ |
Charset id = 0 |
| 4832 |
+ |
Nullable |
| 4833 |
+ |
Size = 8 |
| 4834 |
+ |
|
| 4835 |
+ |
SQLType =SQL_INT64 |
| 4836 |
+ |
sub type = 0 |
| 4837 |
+ |
Field Name = |
| 4838 |
+ |
Scale = -6 |
| 4839 |
+ |
Charset id = 0 |
| 4840 |
+ |
Nullable |
| 4841 |
+ |
Size = 8 |
| 4842 |
+ |
|
| 4843 |
+ |
|
| 4844 |
+ |
Text Tests |
| 4845 |
+ |
SQL Params |
| 4846 |
+ |
SQLType =SQL_LONG |
| 4847 |
+ |
sub type = 0 |
| 4848 |
+ |
Field Name = |
| 4849 |
+ |
Scale = 0 |
| 4850 |
+ |
Charset id = 0 |
| 4851 |
+ |
Not Null |
| 4852 |
+ |
Size = 4 |
| 4853 |
+ |
Value = 0 |
| 4854 |
+ |
|
| 4855 |
+ |
SQLType =SQL_VARYING |
| 4856 |
+ |
sub type = 0 |
| 4857 |
+ |
Field Name = |
| 4858 |
+ |
Scale = 0 |
| 4859 |
+ |
Charset id = 4 |
| 4860 |
+ |
Nullable |
| 4861 |
+ |
Size = 1024 |
| 4862 |
+ |
|
| 4863 |
+ |
SQLType =SQL_BLOB |
| 4864 |
+ |
sub type = 1 |
| 4865 |
+ |
Field Name = |
| 4866 |
+ |
Scale = 0 |
| 4867 |
+ |
Charset id = 4 |
| 4868 |
+ |
Nullable |
| 4869 |
+ |
Size = 8 |
| 4870 |
+ |
|
| 4871 |
+ |
|
| 4872 |
+ |
Binary Blob Tests |
| 4873 |
+ |
|
| 4874 |
+ |
Array Test |
| 4875 |
+ |
SQL Params |
| 4876 |
+ |
SQLType =SQL_LONG |
| 4877 |
+ |
sub type = 0 |
| 4878 |
+ |
Field Name = |
| 4879 |
+ |
Scale = 0 |
| 4880 |
+ |
Charset id = 0 |
| 4881 |
+ |
Not Null |
| 4882 |
+ |
Size = 4 |
| 4883 |
+ |
Value = 0 |
| 4884 |
+ |
|
| 4885 |
+ |
SQLType =SQL_ARRAY |
| 4886 |
+ |
sub type = 0 |
| 4887 |
+ |
Field Name = |
| 4888 |
+ |
Scale = 0 |
| 4889 |
+ |
Charset id = 0 |
| 4890 |
+ |
Nullable |
| 4891 |
+ |
Size = 8 |
| 4892 |
+ |
|
| 4893 |
+ |
ROWID = 1 |
| 4894 |
+ |
ITYPE = 101 |
| 4895 |
+ |
I64TYPE = 9223372036854775807 |
| 4896 |
+ |
CURRTYPE = 10,000.12340000 |
| 4897 |
+ |
DTYPE = 9,999.12345678 |
| 4898 |
+ |
FIXEDPOINT = 1,234,567,890.12345700 |
| 4899 |
+ |
STR = NULL |
| 4900 |
+ |
TEXTBLOB = NULL |
| 4901 |
+ |
OTHERBLOB = NULL |
| 4902 |
+ |
MYARRAY = NULL |
| 4903 |
+ |
ROWID = 2 |
| 4904 |
+ |
ITYPE = -32457 |
| 4905 |
+ |
I64TYPE = -9223372036854775808 |
| 4906 |
+ |
CURRTYPE = 1,000,001.12000000 |
| 4907 |
+ |
DTYPE = 1.7E308 |
| 4908 |
+ |
FIXEDPOINT = -1,234,567,890.12345700 |
| 4909 |
+ |
STR = NULL |
| 4910 |
+ |
TEXTBLOB = NULL |
| 4911 |
+ |
OTHERBLOB = NULL |
| 4912 |
+ |
MYARRAY = NULL |
| 4913 |
+ |
ROWID = 4 |
| 4914 |
+ |
ITYPE = 1 |
| 4915 |
+ |
I64TYPE = 10 |
| 4916 |
+ |
CURRTYPE = .02300000 |
| 4917 |
+ |
DTYPE = .00110000 |
| 4918 |
+ |
FIXEDPOINT = 233.45600000 |
| 4919 |
+ |
STR = NULL |
| 4920 |
+ |
TEXTBLOB = NULL |
| 4921 |
+ |
OTHERBLOB = NULL |
| 4922 |
+ |
MYARRAY = NULL |
| 4923 |
+ |
|
| 4924 |
+ |
Journal Table |
| 4925 |
+ |
IBX$SESSIONID = 1 |
| 4926 |
+ |
IBX$TRANSACTIONID = 8 |
| 4927 |
+ |
IBX$OLDTRANSACTIONID = NULL |
| 4928 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
| 4929 |
+ |
IBX$CREATED = 2022/01/09 15:24:09.1790 |
| 4930 |
+ |
IBX$SESSIONID = 1 |
| 4931 |
+ |
IBX$TRANSACTIONID = 10 |
| 4932 |
+ |
IBX$OLDTRANSACTIONID = 9 |
| 4933 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
| 4934 |
+ |
IBX$CREATED = 2022/01/09 15:24:09.5040 |
| 4935 |
+ |
|
| 4936 |
+ |
Journal Entries |
| 4937 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
| 4938 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 4939 |
+ |
Attachment ID = 4 |
| 4940 |
+ |
Session ID = 1 |
| 4941 |
+ |
Transaction ID = 8 |
| 4942 |
+ |
Transaction Name = "Transaction_29_1" |
| 4943 |
+ |
TPB: Item Count = 3 |
| 4944 |
+ |
isc_tpb_write |
| 4945 |
+ |
isc_tpb_nowait |
| 4946 |
+ |
isc_tpb_concurrency |
| 4947 |
+ |
|
| 4948 |
+ |
Default Completion = TACommit |
| 4949 |
+ |
|
| 4950 |
+ |
Journal Entry = jeQuery(Query) |
| 4951 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 4952 |
+ |
Attachment ID = 4 |
| 4953 |
+ |
Session ID = 1 |
| 4954 |
+ |
Transaction ID = 8 |
| 4955 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346) |
| 4956 |
+ |
|
| 4957 |
+ |
Journal Entry = jeQuery(Query) |
| 4958 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 4959 |
+ |
Attachment ID = 4 |
| 4960 |
+ |
Session ID = 1 |
| 4961 |
+ |
Transaction ID = 8 |
| 4962 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346) |
| 4963 |
+ |
|
| 4964 |
+ |
Journal Entry = jeTransCommitRet(Commit Retaining) |
| 4965 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 4966 |
+ |
Attachment ID = 4 |
| 4967 |
+ |
Session ID = 1 |
| 4968 |
+ |
Transaction ID = 9 |
| 4969 |
+ |
Old TransactionID = 8 |
| 4970 |
+ |
|
| 4971 |
+ |
Journal Entry = jeQuery(Query) |
| 4972 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 4973 |
+ |
Attachment ID = 4 |
| 4974 |
+ |
Session ID = 1 |
| 4975 |
+ |
Transaction ID = 9 |
| 4976 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) |
| 4977 |
+ |
|
| 4978 |
+ |
Journal Entry = jeTransRollbackRet(Rollback Retaining) |
| 4979 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 4980 |
+ |
Attachment ID = 4 |
| 4981 |
+ |
Session ID = 1 |
| 4982 |
+ |
Transaction ID = 10 |
| 4983 |
+ |
Old TransactionID = 9 |
| 4984 |
+ |
|
| 4985 |
+ |
Journal Entry = jeQuery(Query) |
| 4986 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 4987 |
+ |
Attachment ID = 4 |
| 4988 |
+ |
Session ID = 1 |
| 4989 |
+ |
Transaction ID = 10 |
| 4990 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456) |
| 4991 |
+ |
|
| 4992 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
| 4993 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 4994 |
+ |
Attachment ID = 4 |
| 4995 |
+ |
Session ID = 1 |
| 4996 |
+ |
Transaction ID = 11 |
| 4997 |
+ |
Transaction Name = "Transaction_29_2" |
| 4998 |
+ |
TPB: Item Count = 3 |
| 4999 |
+ |
isc_tpb_write |
| 5000 |
+ |
isc_tpb_nowait |
| 5001 |
+ |
isc_tpb_concurrency |
| 5002 |
+ |
|
| 5003 |
+ |
Default Completion = TARollback |
| 5004 |
+ |
|
| 5005 |
+ |
Journal Entry = jeTransCommit(Commit) |
| 5006 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 5007 |
+ |
Attachment ID = 4 |
| 5008 |
+ |
Session ID = 1 |
| 5009 |
+ |
Transaction ID = 10 |
| 5010 |
+ |
|
| 5011 |
+ |
Journal Entry = jeQuery(Query) |
| 5012 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 5013 |
+ |
Attachment ID = 4 |
| 5014 |
+ |
Session ID = 1 |
| 5015 |
+ |
Transaction ID = 11 |
| 5016 |
+ |
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: |
| 5017 |
+ |
Whether ''tis nobler in the mind to suffer |
| 5018 |
+ |
The slings and arrows of outrageous fortune, |
| 5019 |
+ |
Or to take arms against a sea of troubles, |
| 5020 |
+ |
And, by opposing, end them. To die, to sleep- |
| 5021 |
+ |
No more-and by a sleep to say we end |
| 5022 |
+ |
The heartache and the thousand natural shocks |
| 5023 |
+ |
That flesh is heir to-''tis a consummation |
| 5024 |
+ |
Devoutly to be wished. To die, to sleep- |
| 5025 |
+ |
To sleep, perchance to dream. Aye, there''s the rub, |
| 5026 |
+ |
For in that sleep of death what dreams may come, |
| 5027 |
+ |
When we have shuffled off this mortal coil, |
| 5028 |
+ |
Must give us pause. There''s the respect |
| 5029 |
+ |
That makes calamity of so long life. |
| 5030 |
+ |
For who would bear the whips and scorns of time, |
| 5031 |
+ |
Th'' oppressor''s wrong, the proud man''s contumely, |
| 5032 |
+ |
The pangs of despised love, the law’s delay, |
| 5033 |
+ |
The insolence of office, and the spurns |
| 5034 |
+ |
That patient merit of the unworthy takes, |
| 5035 |
+ |
When he himself might his quietus make |
| 5036 |
+ |
With a bare bodkin? Who would fardels bear, |
| 5037 |
+ |
To grunt and sweat under a weary life, |
| 5038 |
+ |
But that the dread of something after death, |
| 5039 |
+ |
The undiscovered country from whose bourn |
| 5040 |
+ |
No traveler returns, puzzles the will |
| 5041 |
+ |
And makes us rather bear those ills we have |
| 5042 |
+ |
Than fly to others that we know not of? |
| 5043 |
+ |
Thus conscience does make cowards of us all, |
| 5044 |
+ |
And thus the native hue of resolution |
| 5045 |
+ |
Is sicklied o''er with the pale cast of thought, |
| 5046 |
+ |
And enterprises of great pitch and moment, |
| 5047 |
+ |
With this regard their currents turn awry, |
| 5048 |
+ |
And lose the name of action.-Soft you now, |
| 5049 |
+ |
The fair Ophelia.-Nymph, in thy orisons |
| 5050 |
+ |
Be all my sins remembered |
| 5051 |
+ |
') |
| 5052 |
+ |
|
| 5053 |
+ |
Journal Entry = jeQuery(Query) |
| 5054 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 5055 |
+ |
Attachment ID = 4 |
| 5056 |
+ |
Session ID = 1 |
| 5057 |
+ |
Transaction ID = 11 |
| 5058 |
+ |
Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0"> |
| 5059 |
+ |
FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00 |
| 5060 |
+ |
0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300 |
| 5061 |
+ |
01000000010000001A01050001000000DA000000 |
| 5062 |
+ |
</blob> |
| 5063 |
+ |
) |
| 5064 |
+ |
|
| 5065 |
+ |
Journal Entry = jeQuery(Query) |
| 5066 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 5067 |
+ |
Attachment ID = 4 |
| 5068 |
+ |
Session ID = 1 |
| 5069 |
+ |
Transaction ID = 11 |
| 5070 |
+ |
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"> |
| 5071 |
+ |
<elt ix="0">100</elt> |
| 5072 |
+ |
<elt ix="1">99</elt> |
| 5073 |
+ |
<elt ix="2">98</elt> |
| 5074 |
+ |
<elt ix="3">97</elt> |
| 5075 |
+ |
<elt ix="4">96</elt> |
| 5076 |
+ |
<elt ix="5">95</elt> |
| 5077 |
+ |
<elt ix="6">94</elt> |
| 5078 |
+ |
<elt ix="7">93</elt> |
| 5079 |
+ |
<elt ix="8">92</elt> |
| 5080 |
+ |
<elt ix="9">91</elt> |
| 5081 |
+ |
<elt ix="10">90</elt> |
| 5082 |
+ |
<elt ix="11">89</elt> |
| 5083 |
+ |
<elt ix="12">88</elt> |
| 5084 |
+ |
<elt ix="13">87</elt> |
| 5085 |
+ |
<elt ix="14">86</elt> |
| 5086 |
+ |
<elt ix="15">85</elt> |
| 5087 |
+ |
<elt ix="16">84</elt> |
| 5088 |
+ |
</array> |
| 5089 |
+ |
) |
| 5090 |
+ |
|
| 5091 |
+ |
Journal Entry = jeTransRollback(Rollback) |
| 5092 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
| 5093 |
+ |
Attachment ID = 4 |
| 5094 |
+ |
Session ID = 1 |
| 5095 |
+ |
Transaction ID = 11 |
| 5096 |
|
|
| 5097 |
|
|
| 5098 |
|
|
