9 |
|
Firebird Client Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
10 |
|
Running Test 1: Create and Drop a Database |
11 |
|
Creating a Database with empty parameters |
12 |
< |
Create Database fails (as expected): 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 |
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 |
80 |
> |
Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
81 |
|
Opening inet://localhost/employee |
82 |
|
Database Open, SQL Dialect = 3 |
83 |
|
TPB: Item Count = 3 |
330 |
|
SALARY = 105,900.00 |
331 |
|
FULL_NAME = Nelson, Robert |
332 |
|
Do Fetch Last: |
333 |
< |
Remote Scrollable cursors test fails feature is not supported |
333 |
> |
Remote Scrollable cursors test fails Engine Code: 335544378 feature is not supported |
334 |
|
Now open the employee database as a local database |
335 |
|
TPB: Item Count = 3 |
336 |
|
isc_tpb_read |
650 |
|
Opening inet://localhost/employee |
651 |
|
Database Open |
652 |
|
Employee Count = 42 |
653 |
< |
Transaction ID = 5005 |
653 |
> |
Transaction ID = 6142 |
654 |
|
Transaction is Read/Write |
655 |
|
Transaction Database Path = inet://localhost/employee |
656 |
< |
Transaction ID = 5005 |
657 |
< |
Oldest Interesting = 5003 |
658 |
< |
Oldest Action = 5004 |
659 |
< |
Oldest Snapshot = 5004 |
656 |
> |
Transaction ID = 6142 |
657 |
> |
Oldest Interesting = 6140 |
658 |
> |
Oldest Action = 6141 |
659 |
> |
Oldest Snapshot = 6141 |
660 |
|
Oldest Interesting = 0 |
661 |
|
Employee Count = 41 |
662 |
|
Employee Count = 42 |
688 |
|
SALARY = 64,635.00 |
689 |
|
FULL_NAME = Johnson, Leslie |
690 |
|
|
691 |
< |
Current memory = 19,694,032 |
691 |
> |
Current memory = 19,689,792 |
692 |
|
Delta memory = 4,480 |
693 |
< |
Max memory = 19,755,888 |
694 |
< |
Elapsed time= 0.002 sec |
695 |
< |
Cpu = 0.010 sec |
693 |
> |
Max memory = 19,751,184 |
694 |
> |
Elapsed time= 0.001 sec |
695 |
> |
Cpu = 0.000 sec |
696 |
|
Buffers = 2048 |
697 |
|
Reads = 0 |
698 |
|
Writes = 0 |
2729 |
|
|
2730 |
|
MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) |
2731 |
|
|
2732 |
< |
MYARRAY3 = Array: (0: 0) (1: 1.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) |
2732 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269) |
2733 |
|
|
2734 |
|
|
2735 |
|
Shrink to 2:10 |
2745 |
|
|
2746 |
|
MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) |
2747 |
|
|
2748 |
< |
MYARRAY3 = Array: (0: 0) (1: 1.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) |
2748 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269) |
2749 |
|
|
2750 |
|
|
2751 |
|
|
2842 |
|
Database Created: 09/1/2020 13:13:45 |
2843 |
|
Pages Used = 297 |
2844 |
|
Pages Free = 10 |
2845 |
< |
Server Memory = 19196128 |
2845 |
> |
Server Memory = 18985136 |
2846 |
|
Forced Writes = 1 |
2847 |
< |
Max Memory = 19316896 |
2847 |
> |
Max Memory = 19022320 |
2848 |
|
Num Buffers = 2048 |
2849 |
|
Sweep Interval = 20000 |
2850 |
|
Logged in Users: SYSDBA, |
2851 |
|
Active Transaction Count = 0 |
2852 |
< |
Fetches = 452 |
2853 |
< |
Writes = 8 |
2854 |
< |
Reads = 57 |
2855 |
< |
Page Writes = 4 |
2852 |
> |
Fetches = 407 |
2853 |
> |
Writes = 6 |
2854 |
> |
Reads = 55 |
2855 |
> |
Page Writes = 3 |
2856 |
|
Record Version Removals Operation Counts |
2857 |
|
|
2858 |
|
Deletes Operation Counts |
2867 |
|
Table ID = 4 |
2868 |
|
Count = 28 |
2869 |
|
Table ID = 6 |
2870 |
< |
Count = 15 |
2870 |
> |
Count = 5 |
2871 |
|
Table ID = 9 |
2872 |
< |
Count = 3 |
2872 |
> |
Count = 1 |
2873 |
|
Table ID = 11 |
2874 |
|
Count = 1 |
2875 |
|
Table ID = 12 |
2897 |
|
Event Signalled |
2898 |
|
First Event - usually ignored |
2899 |
|
Signal Event |
2900 |
+ |
Event Signalled |
2901 |
|
Event Counts: TESTEVENT, Count = 1 |
2902 |
|
Two more events |
2903 |
|
Call Async Wait |
2904 |
|
Async Wait Called |
2905 |
|
Event Signalled |
2905 |
– |
Event Signalled |
2906 |
|
Deferred Events Caught |
2907 |
|
Event Counts: TESTEVENT, Count = 2 |
2908 |
|
Signal Event |
2914 |
|
Time Out - Cancel Worked! |
2915 |
|
Sync wait |
2916 |
|
Event Signalled |
2917 |
< |
Event Counts: TESTEVENT, Count = 1 |
2917 |
> |
Event Counts: TESTEVENT, Count = 0 |
2918 |
|
|
2919 |
|
|
2920 |
|
------------------------------------------------------ |
2944 |
|
Group ID = 0 |
2945 |
|
|
2946 |
|
|
2947 |
< |
Licence Info: feature is not supported |
2947 |
> |
Licence Info: Engine Code: 335544378 feature is not supported |
2948 |
|
-feature is not supported |
2949 |
|
|
2950 |
< |
Licence Mask Info: feature is not supported |
2950 |
> |
Licence Mask Info: Engine Code: 335544378 feature is not supported |
2951 |
|
|
2952 |
|
Capabilities = 6 |
2953 |
|
|
3234 |
|
------------------------------------------------------ |
3235 |
|
Running Test 16: Error handling |
3236 |
|
Invalid Database Name Test |
3237 |
< |
Error Handled: I/O error during "open" operation for file "Malformed Name" |
3237 |
> |
Error Handled: SQLCODE: -902 |
3238 |
> |
Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3239 |
> |
I/O error during "open" operation for file "Malformed Name" |
3240 |
|
-Error while trying to open file |
3241 |
|
-No such file or directory |
3242 |
|
Invalid User Name Test |
3243 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3243 |
> |
Error Handled: SQLCODE: -902 |
3244 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3245 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3246 |
|
Invalid password Test |
3247 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3247 |
> |
Error Handled: SQLCODE: -902 |
3248 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3249 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3250 |
|
Invalid Prepare SQL Test |
3251 |
< |
Error Handled: Dynamic SQL Error |
3251 |
> |
Error Handled: SQLCODE: -206 |
3252 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3253 |
> |
Dynamic SQL Error |
3254 |
|
-SQL error code = -206 |
3255 |
|
-Column unknown |
3256 |
|
-UNKNOWN_DATE |
3257 |
|
-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
3258 |
|
Invalid Open Cursor SQL Test |
3259 |
< |
Error Handled: Dynamic SQL Error |
3259 |
> |
Error Handled: SQLCODE: -206 |
3260 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3261 |
> |
Dynamic SQL Error |
3262 |
|
-SQL error code = -206 |
3263 |
|
-Column unknown |
3264 |
|
-X |
3285 |
|
COUNTER = 42 |
3286 |
|
|
3287 |
|
Invalid Server Name Test |
3288 |
< |
Error Handled: Unable to complete network request to host "unknown". |
3288 |
> |
Error Handled: SQLCODE: -902 |
3289 |
> |
Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3290 |
> |
Unable to complete network request to host "unknown". |
3291 |
|
-Failed to locate host machine. |
3292 |
|
-The specified name was not found in the hosts file or Domain Name Services |
3293 |
|
Invalid User Name Test |
3294 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3294 |
> |
Error Handled: SQLCODE: -902 |
3295 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3296 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3297 |
|
Invalid password Test |
3298 |
< |
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3298 |
> |
Error Handled: SQLCODE: -902 |
3299 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3300 |
> |
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3301 |
|
|
3302 |
|
|
3303 |
|
------------------------------------------------------ |
3428 |
|
Parsing of 1,000 failed |
3429 |
|
Parsing of 1e1e1 failed |
3430 |
|
Parsing of 1.2+3 failed |
3431 |
+ |
Validating Numeric Interface - IFBNumeric |
3432 |
+ |
Value from Currency = 9999.1235 |
3433 |
+ |
Raw Value = 99991235 Scale = -4 |
3434 |
+ |
Value from Currency(rescaled) = 9999.12 |
3435 |
+ |
Raw Value = 999912 Scale = -2 |
3436 |
+ |
Value from Double = 9999.12345678 |
3437 |
+ |
Raw Value = 999912345678 Scale = -8 |
3438 |
+ |
Value from Integer = 9223372036854775807 |
3439 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
3440 |
+ |
Value from string = 9223372036854775807 |
3441 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
3442 |
+ |
Value from string = 9999.12345678 |
3443 |
+ |
Raw Value = 999912345678 Scale = -8 |
3444 |
+ |
Value from string = -0.12 |
3445 |
+ |
Raw Value = -12 Scale = -3 |
3446 |
+ |
Value from BCD = 9999.12345678 |
3447 |
+ |
Raw Value = 999912345678 Scale = -8 |
3448 |
+ |
Value from Raw Data = 9999123.456780 |
3449 |
+ |
Raw Value = 9999123456780 Scale = -6 |
3450 |
+ |
Numeric Operations |
3451 |
+ |
Add 2.23 + 24.12345 = 26.35345 |
3452 |
+ |
Add Double 2.23 + 24.12645 = 26.35645 |
3453 |
+ |
Add integer 2.23 + 2412345 = 2412347.23 |
3454 |
+ |
Subtract 2.23 - 24.12345 = -21.89345 |
3455 |
+ |
Subtract Double 24.12645 - 2.23 = -21.89645 |
3456 |
+ |
Subtract integer 24123.45 - 223 = -23900.45 |
3457 |
+ |
Multiply 2.23 * 24.12345 = 53.7952935 |
3458 |
+ |
Multiply Double 24.12645 * 2.23 = 53.8019835 |
3459 |
+ |
Multiply integer 241.2345 * 223 = 53795.2935 |
3460 |
+ |
Divide 24.12345 / 2.23 = 10.81769 |
3461 |
+ |
Divide Double 2.23 / 24.12645 = 0.09 |
3462 |
+ |
Divide integer 241.2345 / 223 = 1.0818 |
3463 |
+ |
Compare 2.23, -24.12345 = 1 |
3464 |
+ |
Compare integer 2.23, 3 = -1 |
3465 |
+ |
Compare Double 2.23, 2.23 = 0 |
3466 |
+ |
Negate 24.12345 = -24.12345 |
3467 |
|
SQL Params |
3468 |
|
SQLType =SQL_LONG |
3469 |
|
sub type = 0 |
3514 |
|
Nullable |
3515 |
|
Size = 8 |
3516 |
|
|
3517 |
< |
Expected Error - Dynamic SQL Error |
3517 |
> |
Expected Error - SQLCODE: -303 |
3518 |
> |
Engine Code: 335544569 Incompatible column/host variable data type |
3519 |
> |
Dynamic SQL Error |
3520 |
|
-SQL error code = -303 |
3521 |
|
-conversion error from string "1,000" |
3522 |
< |
Expected Error - Dynamic SQL Error |
3522 |
> |
Expected Error - SQLCODE: -303 |
3523 |
> |
Engine Code: 335544569 Incompatible column/host variable data type |
3524 |
> |
Dynamic SQL Error |
3525 |
|
-SQL error code = -303 |
3526 |
|
-conversion error from string "10.0.0" |
3527 |
+ |
Test Numeric Type |
3528 |
|
ROWID = 1 |
3529 |
|
ITYPE = 101 |
3530 |
|
I64TYPE = 9223372036854775807 |
3549 |
|
CURRTYPE = .02300000 |
3550 |
|
DTYPE = .00110000 |
3551 |
|
FIXEDPOINT = 233.45600000 |
3552 |
+ |
ROWID = 7 |
3553 |
+ |
ITYPE = 1 |
3554 |
+ |
I64TYPE = 1234567 |
3555 |
+ |
CURRTYPE = .02300000 |
3556 |
+ |
DTYPE = .00110000 |
3557 |
+ |
FIXEDPOINT = 1,234.25000000 |
3558 |
|
|
3559 |
|
|
3560 |
|
|
3561 |
|
------------------------------------------------------ |
3562 |
|
Running Test 22: Journalling |
3563 |
< |
Start Journaling. Session ID = 1 |
3563 |
> |
Start Journaling. Session ID = 0 |
3564 |
|
1234.567 parsed to 1234567 scale = -3 |
3565 |
|
As Float = 1.2345670000000000E+003 |
3566 |
|
-765.4321 parsed to -7654321 scale = -4 |
3718 |
|
|
3719 |
|
Journal Table |
3720 |
|
IBX$SESSIONID = 1 |
3721 |
< |
IBX$TRANSACTIONID = 9 |
3721 |
> |
IBX$TRANSACTIONID = 8 |
3722 |
|
IBX$OLDTRANSACTIONID = NULL |
3723 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3724 |
< |
IBX$CREATED = 2021/12/07 09:58:40.6960 |
3724 |
> |
IBX$CREATED = 2022/01/14 23:02:04.2320 |
3725 |
|
IBX$SESSIONID = 1 |
3726 |
< |
IBX$TRANSACTIONID = 11 |
3727 |
< |
IBX$OLDTRANSACTIONID = 10 |
3726 |
> |
IBX$TRANSACTIONID = 10 |
3727 |
> |
IBX$OLDTRANSACTIONID = 9 |
3728 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3729 |
< |
IBX$CREATED = 2021/12/07 09:58:41.0190 |
3729 |
> |
IBX$CREATED = 2022/01/14 23:02:04.6690 |
3730 |
|
|
3731 |
|
Journal Entries |
3732 |
|
Journal Entry = jeTransStart(Transaction Start) |
3733 |
< |
Timestamp = 2021/12/07 09:58:40.7300 |
3733 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3734 |
> |
Attachment ID = 6 |
3735 |
|
Session ID = 1 |
3736 |
< |
Transaction ID = 9 |
3736 |
> |
Transaction ID = 8 |
3737 |
|
Transaction Name = "Transaction_29_1" |
3738 |
|
TPB: Item Count = 3 |
3739 |
|
isc_tpb_write |
3743 |
|
Default Completion = TACommit |
3744 |
|
|
3745 |
|
Journal Entry = jeQuery(Query) |
3746 |
< |
Timestamp = 2021/12/07 09:58:40.7970 |
3746 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3747 |
> |
Attachment ID = 6 |
3748 |
|
Session ID = 1 |
3749 |
< |
Transaction ID = 9 |
3749 |
> |
Transaction ID = 8 |
3750 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346) |
3751 |
|
|
3752 |
|
Journal Entry = jeQuery(Query) |
3753 |
< |
Timestamp = 2021/12/07 09:58:40.8130 |
3753 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3754 |
> |
Attachment ID = 6 |
3755 |
|
Session ID = 1 |
3756 |
< |
Transaction ID = 9 |
3756 |
> |
Transaction ID = 8 |
3757 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346) |
3758 |
|
|
3759 |
|
Journal Entry = jeTransCommitRet(Commit Retaining) |
3760 |
< |
Timestamp = 2021/12/07 09:58:40.8900 |
3760 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3761 |
> |
Attachment ID = 6 |
3762 |
|
Session ID = 1 |
3763 |
< |
Transaction ID = 10 |
3764 |
< |
Old TransactionID = 9 |
3763 |
> |
Transaction ID = 9 |
3764 |
> |
Old TransactionID = 8 |
3765 |
|
|
3766 |
|
Journal Entry = jeQuery(Query) |
3767 |
< |
Timestamp = 2021/12/07 09:58:40.9150 |
3767 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3768 |
> |
Attachment ID = 6 |
3769 |
|
Session ID = 1 |
3770 |
< |
Transaction ID = 10 |
3770 |
> |
Transaction ID = 9 |
3771 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) |
3772 |
|
|
3773 |
|
Journal Entry = jeTransRollbackRet(Rollback Retaining) |
3774 |
< |
Timestamp = 2021/12/07 09:58:41.0150 |
3774 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3775 |
> |
Attachment ID = 6 |
3776 |
|
Session ID = 1 |
3777 |
< |
Transaction ID = 11 |
3778 |
< |
Old TransactionID = 10 |
3777 |
> |
Transaction ID = 10 |
3778 |
> |
Old TransactionID = 9 |
3779 |
|
|
3780 |
|
Journal Entry = jeQuery(Query) |
3781 |
< |
Timestamp = 2021/12/07 09:58:41.0390 |
3781 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3782 |
> |
Attachment ID = 6 |
3783 |
|
Session ID = 1 |
3784 |
< |
Transaction ID = 11 |
3784 |
> |
Transaction ID = 10 |
3785 |
|
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456) |
3786 |
|
|
3787 |
|
Journal Entry = jeTransStart(Transaction Start) |
3788 |
< |
Timestamp = 2021/12/07 09:58:41.0610 |
3788 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3789 |
> |
Attachment ID = 6 |
3790 |
|
Session ID = 1 |
3791 |
< |
Transaction ID = 12 |
3791 |
> |
Transaction ID = 11 |
3792 |
|
Transaction Name = "Transaction_29_2" |
3793 |
|
TPB: Item Count = 3 |
3794 |
|
isc_tpb_write |
3798 |
|
Default Completion = TARollback |
3799 |
|
|
3800 |
|
Journal Entry = jeTransCommit(Commit) |
3801 |
< |
Timestamp = 2021/12/07 09:58:41.1310 |
3801 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3802 |
> |
Attachment ID = 6 |
3803 |
|
Session ID = 1 |
3804 |
< |
Transaction ID = 11 |
3804 |
> |
Transaction ID = 10 |
3805 |
|
|
3806 |
|
Journal Entry = jeQuery(Query) |
3807 |
< |
Timestamp = 2021/12/07 09:58:41.1910 |
3807 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3808 |
> |
Attachment ID = 6 |
3809 |
|
Session ID = 1 |
3810 |
< |
Transaction ID = 12 |
3810 |
> |
Transaction ID = 11 |
3811 |
|
Query = Insert into TestData(RowID, Str, TextBlob) Values(5,'It''s the quick brown fox jumps over the lazy dog','To be or not to be-that is the question: |
3812 |
|
Whether ''tis nobler in the mind to suffer |
3813 |
|
The slings and arrows of outrageous fortune, |
3846 |
|
') |
3847 |
|
|
3848 |
|
Journal Entry = jeQuery(Query) |
3849 |
< |
Timestamp = 2021/12/07 09:58:41.2100 |
3849 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3850 |
> |
Attachment ID = 6 |
3851 |
|
Session ID = 1 |
3852 |
< |
Transaction ID = 12 |
3852 |
> |
Transaction ID = 11 |
3853 |
|
Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0"> |
3854 |
|
FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00 |
3855 |
|
0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300 |
3858 |
|
) |
3859 |
|
|
3860 |
|
Journal Entry = jeQuery(Query) |
3861 |
< |
Timestamp = 2021/12/07 09:58:41.2330 |
3861 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3862 |
> |
Attachment ID = 6 |
3863 |
|
Session ID = 1 |
3864 |
< |
Transaction ID = 12 |
3864 |
> |
Transaction ID = 11 |
3865 |
|
Query = Insert into TestData(RowID,MyArray) Values (7,<array dim = "1" sqltype = "496" length = "4" relation_name = "TESTDATA" column_name = "MYARRAY" scale = "0" bounds="0:16"> |
3866 |
|
<elt ix="0">100</elt> |
3867 |
|
<elt ix="1">99</elt> |
3884 |
|
) |
3885 |
|
|
3886 |
|
Journal Entry = jeTransRollback(Rollback) |
3887 |
< |
Timestamp = 2021/12/07 09:58:41.3650 |
3887 |
> |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3888 |
> |
Attachment ID = 6 |
3889 |
|
Session ID = 1 |
3890 |
< |
Transaction ID = 12 |
3890 |
> |
Transaction ID = 11 |
3891 |
|
|
3892 |
|
|
3893 |
|
|