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

Comparing:
ibx/trunk/fbintf/testsuite/FB2reference.log (file contents), Revision 356 by tony, Sun Oct 24 14:00:52 2021 UTC vs.
ibx/branches/udr/testsuite/FB2reference.log (file contents), Revision 381 by tony, Sat Jan 15 00:06:22 2022 UTC

# Line 7 | Line 7 | Firebird Environment Variable = /opt/fir
7   Firebird Client Library Path = /opt/firebird2.5.9/lib/libfbembed.so
8   Running Test 1: Create and Drop a Database
9   Creating a Database with empty parameters
10 < Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
11 < -Error while trying to create file
12 < -No such file or directory
10 > Create Database fails (as expected): Engine Code: 335544344 I/O error during "open O_CREAT" operation for file ""
11   Creating a Database using an SQL Statement
12   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
13   SQL Dialect = 3
# Line 55 | Line 53 | Creating a Database with a DPD
53   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
54   ODS major = 11
55   ODS minor = 2
56 + Attachment ID = 2
57   DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
58   DB Charset ID = 4
59   DB SQL Dialect = 3
# Line 73 | Line 72 | Dropping Database
72  
73   ------------------------------------------------------
74   Running Test 2: Open the employee database and run a query
75 < Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
75 > Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login
76   Opening localhost:employee
77   Database Open, SQL Dialect = 3
78   TPB: Item Count = 3
# Line 534 | Line 533 | Running Test 3: ad hoc queries
533   Opening localhost:employee
534   Database Open
535   Employee Count = 42
536 + Transaction ID = 6359
537 + Transaction is Read/Write
538 + Transaction ID = 6359
539 + Oldest Interesting = 6318
540 + Oldest Action = 6358
541 + Oldest Snapshot = 6358
542 + Oldest Interesting = 0
543   Employee Count = 41
544   Employee Count = 42
545   Employee Count = 41
# Line 564 | Line 570 | JOB_COUNTRY = USA
570   SALARY = 64,635.00
571   FULL_NAME = Johnson, Leslie
572  
573 < Current memory = 948,496
573 > Current memory = 937,536
574   Delta memory = 1,288
575 < Max memory = 992,448
576 < Elapsed time= 0.001 sec
575 > Max memory = 965,600
576 > Elapsed time= 0.000 sec
577   Cpu = 0.000 sec
578   Buffers = 75
579   Reads = 0
# Line 2605 | Line 2611 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2611  
2612   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)
2613  
2614 < 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)
2614 > 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)
2615  
2616  
2617   Shrink to 2:10
# Line 2621 | Line 2627 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2627  
2628   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)
2629  
2630 < 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)
2630 > 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)
2631  
2632  
2633  
# Line 2718 | Line 2724 | Database is Read/Write
2724   Database Created: 17/6/2019 19:37:08
2725   Unknown Response 3
2726   Unknown Response 3
2727 < Server Memory = 841392
2727 > Server Memory = 721912
2728   Forced Writes  = 1
2729 < Max Memory  = 879288
2729 > Max Memory  = 737792
2730   Num Buffers  = 75
2731   Sweep Interval  = 20000
2732   Logged in Users: SYSDBA,
2733   Active Transaction Count = 0
2734 < Fetches  = 1040
2735 < Writes  = 6
2736 < Reads  = 84
2737 < Page Writes  = 6
2734 > Fetches  = 520
2735 > Writes  = 4
2736 > Reads  = 58
2737 > Page Writes  = 4
2738   Record Version Removals Operation Counts
2739  
2740   Deletes Operation Counts
# Line 2740 | Line 2746 | Insert Count Operation Counts
2746   Purge Count Countites Operation Counts
2747  
2748   Indexed Reads Count Operation Counts
2743 Table ID = 2
2744 Count = 14
2745 Table ID = 5
2746 Count = 28
2749   Table ID = 6
2750 < Count = 58
2750 > Count = 11
2751   Table ID = 11
2752 < Count = 3
2752 > Count = 1
2753   Table ID = 12
2754 < Count = 36
2754 > Count = 24
2755   Table ID = 28
2756 < Count = 9
2756 > Count = 4
2757   Table ID = 29
2758 < Count = 7
2758 > Count = 4
2759  
2760   Sequential Table Scans Operation Counts
2761   Table ID = 0
# Line 2817 | Line 2819 | User ID = 0
2819   Group ID = 0
2820  
2821  
2822 < Licence Info: feature is not supported
2821 < -feature is not supported
2822 > Licence Info: Engine Code: 335544378 feature is not supported
2823  
2824 < Licence Mask Info: feature is not supported
2824 > Licence Mask Info: Engine Code: 335544378 feature is not supported
2825  
2826   Capabilities = 260
2827  
# Line 3107 | Line 3108 | Écoute moi
3108   ------------------------------------------------------
3109   Running Test 16: Error handling
3110   Invalid Database Name Test
3111 < Error Handled: I/O error during "open" operation for file "Malformed Name"
3112 < -Error while trying to open file
3113 < -No such file or directory
3111 > Error Handled: SQLCODE: -902
3112 > Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3113 > I/O error during "open" operation for file "Malformed Name"
3114   Invalid User Name Test
3115 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3115 > Error Handled: SQLCODE: -902
3116 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3117 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3118   Invalid password Test
3119 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3119 > Error Handled: SQLCODE: -902
3120 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3121 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3122   Invalid Prepare SQL Test
3123 < Error Handled: Dynamic SQL Error
3124 < -SQL error code = -206
3125 < -Column unknown
3121 < -UNKNOWN_DATE
3122 < -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3123 > Error Handled: SQLCODE: -206
3124 > Engine Code: 335544569 Column does not belong to referenced table
3125 > Dynamic SQL Error When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3126   Invalid Open Cursor SQL Test
3127 < Error Handled: Dynamic SQL Error
3128 < -SQL error code = -206
3129 < -Column unknown
3127 < -X
3128 < -At line 1, column 8 When Executing: Select X,count(*) As Counter from EMPLOYEE
3127 > Error Handled: SQLCODE: -206
3128 > Engine Code: 335544569 Column does not belong to referenced table
3129 > Dynamic SQL Error When Executing: Select X,count(*) As Counter from EMPLOYEE
3130   Transaction not started Test
3131   Error Handled: Transaction is not active
3132   Invalid Param SQL Type Test
# Line 3148 | Line 3149 | New Transaction before Open Cursor
3149   COUNTER = 42
3150  
3151   Invalid Server Name Test
3152 < Error Handled: Unable to complete network request to host "unknown".
3153 < -Failed to locate host machine
3152 > Error Handled: SQLCODE: -902
3153 > Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3154 > Unable to complete network request to host "unknown"
3155   Invalid User Name Test
3156 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3156 > Error Handled: SQLCODE: -902
3157 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3158 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3159   Invalid password Test
3160 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3160 > Error Handled: SQLCODE: -902
3161 > Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3162 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3163  
3164  
3165   ------------------------------------------------------
# Line 3284 | Line 3290 | Parsing of 1.2E1.2 failed
3290   Parsing of 1,000 failed
3291   Parsing of 1e1e1 failed
3292   Parsing of 1.2+3 failed
3293 + Validating Numeric Interface - IFBNumeric
3294 + Value from Currency = 9999.1235
3295 + Raw Value = 99991235 Scale = -4
3296 + Value from Currency(rescaled) = 9999.12
3297 + Raw Value = 999912 Scale = -2
3298 + Value from Double = 9999.12345678
3299 + Raw Value = 999912345678 Scale = -8
3300 + Value from Integer = 9223372036854775807
3301 + Raw Value = 9223372036854775807 Scale = 0
3302 + Value from string = 9223372036854775807
3303 + Raw Value = 9223372036854775807 Scale = 0
3304 + Value from string = 9999.12345678
3305 + Raw Value = 999912345678 Scale = -8
3306 + Value from string = -0.12
3307 + Raw Value = -12 Scale = -3
3308 + Value from BCD = 9999.12345678
3309 + Raw Value = 999912345678 Scale = -8
3310 + Value from Raw Data = 9999123.456780
3311 + Raw Value = 9999123456780 Scale = -6
3312 + Numeric Operations
3313 + Add 2.23 + 24.12345 = 26.35345
3314 + Add Double 2.23 + 24.12645 = 26.35645
3315 + Add integer 2.23 + 2412345 = 2412347.23
3316 + Subtract 2.23 - 24.12345 = -21.89345
3317 + Subtract Double 24.12645 - 2.23 = -21.89645
3318 + Subtract integer 24123.45 - 223 = -23900.45
3319 + Multiply 2.23 * 24.12345 = 53.7952935
3320 + Multiply Double 24.12645 * 2.23 = 53.8019835
3321 + Multiply integer 241.2345 * 223 = 53795.2935
3322 + Divide 24.12345 / 2.23 = 10.81769
3323 + Divide Double 2.23 / 24.12645 = 0.09
3324 + Divide integer 241.2345 / 223 = 1.0818
3325 + Compare 2.23, -24.12345 = 1
3326 + Compare integer 2.23, 3 = -1
3327 + Compare Double 2.23, 2.23 = 0
3328 + Negate 24.12345 = -24.12345
3329   SQL Params
3330   SQLType =SQL_LONG
3331   sub type = 0
# Line 3334 | Line 3376 | Charset id = 0
3376   Nullable
3377   Size = 8
3378  
3379 < Expected Error - Dynamic SQL Error
3380 < -SQL error code = -303
3381 < -conversion error from string "1,000"
3382 < Expected Error - Dynamic SQL Error
3383 < -SQL error code = -303
3384 < -conversion error from string "10.0.0"
3379 > Expected Error - SQLCODE: -303
3380 > Engine Code: 335544569 Incompatible column/host variable data type
3381 > Dynamic SQL Error
3382 > Expected Error - SQLCODE: -303
3383 > Engine Code: 335544569 Incompatible column/host variable data type
3384 > Dynamic SQL Error
3385 > Test Numeric Type
3386   ROWID = 1
3387   ITYPE = 101
3388   I64TYPE = 9223372036854775807
# Line 3364 | Line 3407 | I64TYPE = 10
3407   CURRTYPE = .02300000
3408   DTYPE = .00110000
3409   FIXEDPOINT = 233.45600000
3410 + ROWID = 7
3411 + ITYPE = 1
3412 + I64TYPE = 1234567
3413 + CURRTYPE = .02300000
3414 + DTYPE = .00110000
3415 + FIXEDPOINT = 1,234.25000000
3416 +
3417 +
3418 +
3419 + ------------------------------------------------------
3420 + Running Test 22: Journalling
3421 + Start Journaling. Session ID = 0
3422 + 1234.567 parsed to 1234567 scale = -3
3423 + As Float =  1.2345670000000000E+003
3424 + -765.4321 parsed to -7654321 scale = -4
3425 + As Float = -7.6543209999999999E+002
3426 + 0.1 parsed to 1 scale = -1
3427 + As Float =  1.0000000000000001E-001
3428 + 0.01 parsed to 1 scale = -2
3429 + As Float =  1.0000000000000000E-002
3430 + +123 parsed to 123 scale = 0
3431 + As Float =  1.2300000000000000E+002
3432 + 1.23456E308 parsed to 123456 scale = 303
3433 + As Float =  1.2345600000000001E+308
3434 + -1.2e-02 parsed to -12 scale = -3
3435 + As Float = -1.2000000000000000E-002
3436 + 10. parsed to 10 scale = 0
3437 + As Float =  1.0000000000000000E+001
3438 + .12 parsed to 12 scale = -2
3439 + As Float =  1.2000000000000000E-001
3440 + 0.12 parsed to 12 scale = -2
3441 + As Float =  1.2000000000000000E-001
3442 + Parsing of 1.2E1.2 failed
3443 + Parsing of 1,000 failed
3444 + Parsing of 1e1e1 failed
3445 + Parsing of 1.2+3 failed
3446 + SQL Params
3447 + SQLType =SQL_LONG
3448 + sub type = 0
3449 + Field Name =
3450 + Scale = 0
3451 + Charset id = 0
3452 + Not Null
3453 + Size = 4
3454 + Value = 0
3455 +
3456 + SQLType =SQL_LONG
3457 + sub type = 0
3458 + Field Name =
3459 + Scale = 0
3460 + Charset id = 0
3461 + Nullable
3462 + Size = 4
3463 +
3464 + SQLType =SQL_INT64
3465 + sub type = 0
3466 + Field Name =
3467 + Scale = 0
3468 + Charset id = 0
3469 + Nullable
3470 + Size = 8
3471 +
3472 + SQLType =SQL_INT64
3473 + sub type = 0
3474 + Field Name =
3475 + Scale = -4
3476 + Charset id = 0
3477 + Nullable
3478 + Size = 8
3479 +
3480 + SQLType =SQL_DOUBLE
3481 + sub type = 0
3482 + Field Name =
3483 + Scale = 0
3484 + Charset id = 0
3485 + Nullable
3486 + Size = 8
3487 +
3488 + SQLType =SQL_INT64
3489 + sub type = 0
3490 + Field Name =
3491 + Scale = -6
3492 + Charset id = 0
3493 + Nullable
3494 + Size = 8
3495 +
3496 +
3497 + Text Tests
3498 + SQL Params
3499 + SQLType =SQL_LONG
3500 + sub type = 0
3501 + Field Name =
3502 + Scale = 0
3503 + Charset id = 0
3504 + Not Null
3505 + Size = 4
3506 + Value = 0
3507 +
3508 + SQLType =SQL_VARYING
3509 + sub type = 0
3510 + Field Name =
3511 + Scale = 0
3512 + Charset id = 4
3513 + Nullable
3514 + Size = 1024
3515 +
3516 + SQLType =SQL_BLOB
3517 + sub type = 1
3518 + Field Name =
3519 + Scale = 0
3520 + Charset id = 4
3521 + Nullable
3522 + Size = 8
3523 +
3524 +
3525 + Binary Blob Tests
3526 +
3527 + Array Test
3528 + SQL Params
3529 + SQLType =SQL_LONG
3530 + sub type = 0
3531 + Field Name =
3532 + Scale = 0
3533 + Charset id = 0
3534 + Not Null
3535 + Size = 4
3536 + Value = 0
3537 +
3538 + SQLType =SQL_ARRAY
3539 + sub type = 0
3540 + Field Name =
3541 + Scale = 0
3542 + Charset id = 0
3543 + Nullable
3544 + Size = 8
3545 +
3546 + ROWID = 1
3547 + ITYPE = 101
3548 + I64TYPE = 9223372036854775807
3549 + CURRTYPE = 10,000.12340000
3550 + DTYPE = 9,999.12345678
3551 + FIXEDPOINT = 1,234,567,890.12345700
3552 + STR = NULL
3553 + TEXTBLOB = NULL
3554 + OTHERBLOB = NULL
3555 + MYARRAY = NULL
3556 + ROWID = 2
3557 + ITYPE = -32457
3558 + I64TYPE = -9223372036854775808
3559 + CURRTYPE = 1,000,001.12000000
3560 + DTYPE = 1.7E308
3561 + FIXEDPOINT = -1,234,567,890.12345700
3562 + STR = NULL
3563 + TEXTBLOB = NULL
3564 + OTHERBLOB = NULL
3565 + MYARRAY = NULL
3566 + ROWID = 4
3567 + ITYPE = 1
3568 + I64TYPE = 10
3569 + CURRTYPE = .02300000
3570 + DTYPE = .00110000
3571 + FIXEDPOINT = 233.45600000
3572 + STR = NULL
3573 + TEXTBLOB = NULL
3574 + OTHERBLOB = NULL
3575 + MYARRAY = NULL
3576 +
3577 + Journal Table
3578 + IBX$SESSIONID = 1
3579 + IBX$TRANSACTIONID = 7
3580 + IBX$OLDTRANSACTIONID = NULL
3581 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3582 + IBX$CREATED = 2022/01/14 23:03:42.7720
3583 + IBX$SESSIONID = 1
3584 + IBX$TRANSACTIONID = 9
3585 + IBX$OLDTRANSACTIONID = 8
3586 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3587 + IBX$CREATED = 2022/01/14 23:03:43.1080
3588 +
3589 + Journal Entries
3590 + Journal Entry = jeTransStart(Transaction Start)
3591 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3592 + Attachment ID = 2
3593 + Session ID = 1
3594 + Transaction ID = 7
3595 + Transaction Name = "Transaction_29_1"
3596 + TPB: Item Count = 3
3597 +  isc_tpb_write
3598 +  isc_tpb_nowait
3599 +  isc_tpb_concurrency
3600 +
3601 + Default Completion = TACommit
3602 +
3603 + Journal Entry = jeQuery(Query)
3604 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3605 + Attachment ID = 2
3606 + Session ID = 1
3607 + Transaction ID = 7
3608 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3609 +
3610 + Journal Entry = jeQuery(Query)
3611 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3612 + Attachment ID = 2
3613 + Session ID = 1
3614 + Transaction ID = 7
3615 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3616 +
3617 + Journal Entry = jeTransCommitRet(Commit Retaining)
3618 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3619 + Attachment ID = 2
3620 + Session ID = 1
3621 + Transaction ID = 8
3622 + Old TransactionID = 7
3623 +
3624 + Journal Entry = jeQuery(Query)
3625 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3626 + Attachment ID = 2
3627 + Session ID = 1
3628 + Transaction ID = 8
3629 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3630 +
3631 + Journal Entry = jeTransRollbackRet(Rollback Retaining)
3632 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3633 + Attachment ID = 2
3634 + Session ID = 1
3635 + Transaction ID = 9
3636 + Old TransactionID = 8
3637 +
3638 + Journal Entry = jeQuery(Query)
3639 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3640 + Attachment ID = 2
3641 + Session ID = 1
3642 + Transaction ID = 9
3643 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3644 +
3645 + Journal Entry = jeTransStart(Transaction Start)
3646 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3647 + Attachment ID = 2
3648 + Session ID = 1
3649 + Transaction ID = 10
3650 + Transaction Name = "Transaction_29_2"
3651 + TPB: Item Count = 3
3652 +  isc_tpb_write
3653 +  isc_tpb_nowait
3654 +  isc_tpb_concurrency
3655 +
3656 + Default Completion = TARollback
3657 +
3658 + Journal Entry = jeTransCommit(Commit)
3659 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3660 + Attachment ID = 2
3661 + Session ID = 1
3662 + Transaction ID = 9
3663 +
3664 + Journal Entry = jeQuery(Query)
3665 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3666 + Attachment ID = 2
3667 + Session ID = 1
3668 + Transaction ID = 10
3669 + 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:
3670 + Whether ''tis nobler in the mind to suffer
3671 + The slings and arrows of outrageous fortune,
3672 + Or to take arms against a sea of troubles,
3673 + And, by opposing, end them. To die, to sleep-
3674 + No more-and by a sleep to say we end
3675 + The heartache and the thousand natural shocks
3676 + That flesh is heir to-''tis a consummation
3677 + Devoutly to be wished. To die, to sleep-
3678 + To sleep, perchance to dream. Aye, there''s the rub,
3679 + For in that sleep of death what dreams may come,
3680 + When we have shuffled off this mortal coil,
3681 + Must give us pause. There''s the respect
3682 + That makes calamity of so long life.
3683 + For who would bear the whips and scorns of time,
3684 + Th'' oppressor''s wrong, the proud man''s contumely,
3685 + The pangs of despised love, the law’s delay,
3686 + The insolence of office, and the spurns
3687 + That patient merit of the unworthy takes,
3688 + When he himself might his quietus make
3689 + With a bare bodkin? Who would fardels bear,
3690 + To grunt and sweat under a weary life,
3691 + But that the dread of something after death,
3692 + The undiscovered country from whose bourn
3693 + No traveler returns, puzzles the will
3694 + And makes us rather bear those ills we have
3695 + Than fly to others that we know not of?
3696 + Thus conscience does make cowards of us all,
3697 + And thus the native hue of resolution
3698 + Is sicklied o''er with the pale cast of thought,
3699 + And enterprises of great pitch and moment,
3700 + With this regard their currents turn awry,
3701 + And lose the name of action.-Soft you now,
3702 + The fair Ophelia.-Nymph, in thy orisons
3703 + Be all my sins remembered
3704 + ')
3705 +
3706 + Journal Entry = jeQuery(Query)
3707 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3708 + Attachment ID = 2
3709 + Session ID = 1
3710 + Transaction ID = 10
3711 + Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3712 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3713 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
3714 + 01000000010000001A01050001000000DA000000
3715 + </blob>
3716 + )
3717 +
3718 + Journal Entry = jeQuery(Query)
3719 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3720 + Attachment ID = 2
3721 + Session ID = 1
3722 + Transaction ID = 10
3723 + 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">
3724 + <elt ix="0">100</elt>
3725 + <elt ix="1">99</elt>
3726 + <elt ix="2">98</elt>
3727 + <elt ix="3">97</elt>
3728 + <elt ix="4">96</elt>
3729 + <elt ix="5">95</elt>
3730 + <elt ix="6">94</elt>
3731 + <elt ix="7">93</elt>
3732 + <elt ix="8">92</elt>
3733 + <elt ix="9">91</elt>
3734 + <elt ix="10">90</elt>
3735 + <elt ix="11">89</elt>
3736 + <elt ix="12">88</elt>
3737 + <elt ix="13">87</elt>
3738 + <elt ix="14">86</elt>
3739 + <elt ix="15">85</elt>
3740 + <elt ix="16">84</elt>
3741 + </array>
3742 + )
3743 +
3744 + Journal Entry = jeTransRollback(Rollback)
3745 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3746 + Attachment ID = 2
3747 + Session ID = 1
3748 + Transaction ID = 10
3749  
3750  
3751  

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines