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

Comparing:
ibx/trunk/fbintf/testsuite/FB3reference.log (file contents), Revision 349 by tony, Mon Oct 18 08:39:40 2021 UTC vs.
ibx/branches/udr/testsuite/FB3reference.log (file contents), Revision 370 by tony, Wed Jan 5 14:59:15 2022 UTC

# Line 57 | Line 57 | Creating a Database with a DPD
57   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
58   ODS major = 12
59   ODS minor = 0
60 + Attachment ID = 6
61   DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
62   DB Charset ID = 4
63   DB SQL Dialect = 3
# Line 76 | Line 77 | Dropping Database
77  
78   ------------------------------------------------------
79   Running Test 2: Open the employee database and run a query
80 + Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
81   Opening inet://localhost/employee
82   Database Open, SQL Dialect = 3
83   TPB: Item Count = 3
# Line 292 | Line 294 | Not Null
294   Size = 2
295   Value = 0
296  
297 + Results for Cursor: Test Cursor
298   EMP_NO = 8
299   FIRST_NAME = Leslie
300   LAST_NAME = Johnson
# Line 304 | Line 307 | JOB_COUNTRY = USA
307   SALARY = 64,635.00
308   FULL_NAME = Johnson, Leslie
309  
310 + Scollable Cursors
311 + DB Connect String = inet://localhost/employee
312 + DB Charset ID = 4
313 + DB SQL Dialect = 3
314 + DB Remote Protocol = TCPv4
315 + DB ODS Major Version = 12
316 + DB ODS Minor Version = 0
317 + User Authentication Method = Srp
318 + Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
319 + DB Client Implementation Version = 3.0
320 + Do Fetch Next:
321 + EMP_NO = 2
322 + FIRST_NAME = Robert
323 + LAST_NAME = Nelson
324 + PHONE_EXT = 250
325 + HIRE_DATE = 1988/12/28 00:00:00.0000
326 + DEPT_NO = 600
327 + JOB_CODE = VP
328 + JOB_GRADE = 2
329 + JOB_COUNTRY = USA
330 + SALARY = 105,900.00
331 + FULL_NAME = Nelson, Robert
332 + Do Fetch Last:
333 + Remote Scrollable cursors test fails feature is not supported
334   Now open the employee database as a local database
335   TPB: Item Count = 3
336    isc_tpb_read
# Line 519 | Line 546 | Not Null
546   Size = 2
547   Value = 0
548  
549 + Results for Cursor: Test Cursor
550   EMP_NO = 8
551   FIRST_NAME = Leslie
552   LAST_NAME = Johnson
# Line 531 | Line 559 | JOB_COUNTRY = USA
559   SALARY = 64,635.00
560   FULL_NAME = Johnson, Leslie
561  
562 + Scollable Cursors
563 + DB Connect String = employee
564 + DB Charset ID = 4
565 + DB SQL Dialect = 3
566 + DB Remote Protocol =
567 + DB ODS Major Version = 12
568 + DB ODS Minor Version = 0
569 + User Authentication Method = User name in DPB
570 + Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
571 + DB Client Implementation Version = 3.0
572 + Do Fetch Next:
573 + EMP_NO = 2
574 + FIRST_NAME = Robert
575 + LAST_NAME = Nelson
576 + PHONE_EXT = 250
577 + HIRE_DATE = 1988/12/28 00:00:00.0000
578 + DEPT_NO = 600
579 + JOB_CODE = VP
580 + JOB_GRADE = 2
581 + JOB_COUNTRY = USA
582 + SALARY = 105,900.00
583 + FULL_NAME = Nelson, Robert
584 + Do Fetch Last:
585 + EMP_NO = 145
586 + FIRST_NAME = Mark
587 + LAST_NAME = Guckenheimer
588 + PHONE_EXT = 221
589 + HIRE_DATE = 1994/05/02 00:00:00.0000
590 + DEPT_NO = 622
591 + JOB_CODE = Eng
592 + JOB_GRADE = 5
593 + JOB_COUNTRY = USA
594 + SALARY = 32,000.00
595 + FULL_NAME = Guckenheimer, Mark
596 + Do Fetch Prior:
597 + EMP_NO = 144
598 + FIRST_NAME = John
599 + LAST_NAME = Montgomery
600 + PHONE_EXT = 820
601 + HIRE_DATE = 1994/03/30 00:00:00.0000
602 + DEPT_NO = 672
603 + JOB_CODE = Eng
604 + JOB_GRADE = 5
605 + JOB_COUNTRY = USA
606 + SALARY = 35,000.00
607 + FULL_NAME = Montgomery, John
608 + Do Fetch First:
609 + EMP_NO = 2
610 + FIRST_NAME = Robert
611 + LAST_NAME = Nelson
612 + PHONE_EXT = 250
613 + HIRE_DATE = 1988/12/28 00:00:00.0000
614 + DEPT_NO = 600
615 + JOB_CODE = VP
616 + JOB_GRADE = 2
617 + JOB_COUNTRY = USA
618 + SALARY = 105,900.00
619 + FULL_NAME = Nelson, Robert
620 + Do Fetch Abs 8 :
621 + EMP_NO = 14
622 + FIRST_NAME = Stewart
623 + LAST_NAME = Hall
624 + PHONE_EXT = 227
625 + HIRE_DATE = 1990/06/04 00:00:00.0000
626 + DEPT_NO = 900
627 + JOB_CODE = Finan
628 + JOB_GRADE = 3
629 + JOB_COUNTRY = USA
630 + SALARY = 69,482.63
631 + FULL_NAME = Hall, Stewart
632 + Do Fetch Relative -2 :
633 + EMP_NO = 11
634 + FIRST_NAME = K. J.
635 + LAST_NAME = Weston
636 + PHONE_EXT = 34
637 + HIRE_DATE = 1990/01/17 00:00:00.0000
638 + DEPT_NO = 130
639 + JOB_CODE = SRep
640 + JOB_GRADE = 4
641 + JOB_COUNTRY = USA
642 + SALARY = 86,292.94
643 + FULL_NAME = Weston, K. J.
644 + Do Fetch beyond EOF :
645 + Fetch returned false
646  
647  
648   ------------------------------------------------------
# Line 538 | Line 650 | Running Test 3: ad hoc queries
650   Opening inet://localhost/employee
651   Database Open
652   Employee Count = 42
653 + Transaction ID = 5005
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
660 + Oldest Interesting = 0
661   Employee Count = 41
662   Employee Count = 42
663   Employee Count = 41
# Line 568 | Line 688 | JOB_COUNTRY = USA
688   SALARY = 64,635.00
689   FULL_NAME = Johnson, Leslie
690  
691 < Current memory = 19,693,312
691 > Current memory = 19,694,032
692   Delta memory = 4,480
693 < Max memory = 19,755,424
694 < Elapsed time= 0.001 sec
695 < Cpu = 0.000 sec
693 > Max memory = 19,755,888
694 > Elapsed time= 0.002 sec
695 > Cpu = 0.010 sec
696   Buffers = 2048
697   Reads = 0
698   Writes = 0
# Line 734 | Line 854 | DEPT_NO = 600
854   JOB_CODE = Eng
855   JOB_GRADE = 4
856   JOB_COUNTRY = England
857 < SALARY = 40,000.58
857 > SALARY = 40,000.59
858   FULL_NAME = Major, Major
859  
860   Now Delete the rows
# Line 2609 | Line 2729 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
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: 14.69) (15: 15.75) (16: 16.79)
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)
2733  
2734  
2735   Shrink to 2:10
# Line 2625 | Line 2745 | MYARRAY = Array: (0: 100) (1: 99) (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: 14.69) (15: 15.75) (16: 16.79)
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)
2749  
2750  
2751  
# Line 2722 | Line 2842 | Database is Read/Write
2842   Database Created: 09/1/2020 13:13:45
2843   Pages Used = 297
2844   Pages Free = 10
2845 < Server Memory = 19195664
2845 > Server Memory = 19196128
2846   Forced Writes  = 1
2847 < Max Memory  = 19316176
2847 > Max Memory  = 19316896
2848   Num Buffers  = 2048
2849   Sweep Interval  = 20000
2850   Logged in Users: SYSDBA,
# Line 3268 | Line 3388 | Skipping test for Firebird 4 and later
3388  
3389   ------------------------------------------------------
3390   Running Test 21: Exercise setting and getting of numeric data types
3391 + 1234.567 parsed to 1234567 scale = -3
3392 + As Float =  1.2345670000000000E+003
3393 + -765.4321 parsed to -7654321 scale = -4
3394 + As Float = -7.6543209999999999E+002
3395 + 0.1 parsed to 1 scale = -1
3396 + As Float =  1.0000000000000001E-001
3397 + 0.01 parsed to 1 scale = -2
3398 + As Float =  1.0000000000000000E-002
3399 + +123 parsed to 123 scale = 0
3400 + As Float =  1.2300000000000000E+002
3401 + 1.23456E308 parsed to 123456 scale = 303
3402 + As Float =  1.2345600000000001E+308
3403 + -1.2e-02 parsed to -12 scale = -3
3404 + As Float = -1.2000000000000000E-002
3405 + 10. parsed to 10 scale = 0
3406 + As Float =  1.0000000000000000E+001
3407 + .12 parsed to 12 scale = -2
3408 + As Float =  1.2000000000000000E-001
3409 + 0.12 parsed to 12 scale = -2
3410 + As Float =  1.2000000000000000E-001
3411 + Parsing of 1.2E1.2 failed
3412 + Parsing of 1,000 failed
3413 + Parsing of 1e1e1 failed
3414 + Parsing of 1.2+3 failed
3415   SQL Params
3416   SQLType =SQL_LONG
3417   sub type = 0
# Line 3318 | Line 3462 | Charset id = 0
3462   Nullable
3463   Size = 8
3464  
3465 + Expected Error - Dynamic SQL Error
3466 + -SQL error code = -303
3467 + -conversion error from string "1,000"
3468 + Expected Error - Dynamic SQL Error
3469 + -SQL error code = -303
3470 + -conversion error from string "10.0.0"
3471   ROWID = 1
3472   ITYPE = 101
3473   I64TYPE = 9223372036854775807
3474   CURRTYPE = 10,000.12340000
3475   DTYPE = 9,999.12345678
3476 < FIXEDPOINT = 1,234,567,890.12345600
3476 > FIXEDPOINT = 1,234,567,890.12345700
3477   ROWID = 2
3478   ITYPE = -32457
3479   I64TYPE = -9223372036854775808
3480   CURRTYPE = 1,000,001.12000000
3481   DTYPE = 1.7E308
3482 < FIXEDPOINT = -1,234,567,890.12345600
3482 > FIXEDPOINT = -1,234,567,890.12345700
3483   ROWID = 3
3484   ITYPE = 0
3485   I64TYPE = 0
3486   CURRTYPE = .00000000
3487   DTYPE = .00000000
3488   FIXEDPOINT = .00000000
3489 + ROWID = 4
3490 + ITYPE = 1
3491 + I64TYPE = 10
3492 + CURRTYPE = .02300000
3493 + DTYPE = .00110000
3494 + FIXEDPOINT = 233.45600000
3495 +
3496 +
3497 +
3498 + ------------------------------------------------------
3499 + Running Test 22: Journalling
3500 + Start Journaling. Session ID = 1
3501 + 1234.567 parsed to 1234567 scale = -3
3502 + As Float =  1.2345670000000000E+003
3503 + -765.4321 parsed to -7654321 scale = -4
3504 + As Float = -7.6543209999999999E+002
3505 + 0.1 parsed to 1 scale = -1
3506 + As Float =  1.0000000000000001E-001
3507 + 0.01 parsed to 1 scale = -2
3508 + As Float =  1.0000000000000000E-002
3509 + +123 parsed to 123 scale = 0
3510 + As Float =  1.2300000000000000E+002
3511 + 1.23456E308 parsed to 123456 scale = 303
3512 + As Float =  1.2345600000000001E+308
3513 + -1.2e-02 parsed to -12 scale = -3
3514 + As Float = -1.2000000000000000E-002
3515 + 10. parsed to 10 scale = 0
3516 + As Float =  1.0000000000000000E+001
3517 + .12 parsed to 12 scale = -2
3518 + As Float =  1.2000000000000000E-001
3519 + 0.12 parsed to 12 scale = -2
3520 + As Float =  1.2000000000000000E-001
3521 + Parsing of 1.2E1.2 failed
3522 + Parsing of 1,000 failed
3523 + Parsing of 1e1e1 failed
3524 + Parsing of 1.2+3 failed
3525 + SQL Params
3526 + SQLType =SQL_LONG
3527 + sub type = 0
3528 + Field Name =
3529 + Scale = 0
3530 + Charset id = 0
3531 + Not Null
3532 + Size = 4
3533 + Value = 0
3534 +
3535 + SQLType =SQL_LONG
3536 + sub type = 0
3537 + Field Name =
3538 + Scale = 0
3539 + Charset id = 0
3540 + Nullable
3541 + Size = 4
3542 +
3543 + SQLType =SQL_INT64
3544 + sub type = 0
3545 + Field Name =
3546 + Scale = 0
3547 + Charset id = 0
3548 + Nullable
3549 + Size = 8
3550 +
3551 + SQLType =SQL_INT64
3552 + sub type = 0
3553 + Field Name =
3554 + Scale = -4
3555 + Charset id = 0
3556 + Nullable
3557 + Size = 8
3558 +
3559 + SQLType =SQL_DOUBLE
3560 + sub type = 0
3561 + Field Name =
3562 + Scale = 0
3563 + Charset id = 0
3564 + Nullable
3565 + Size = 8
3566 +
3567 + SQLType =SQL_INT64
3568 + sub type = 0
3569 + Field Name =
3570 + Scale = -6
3571 + Charset id = 0
3572 + Nullable
3573 + Size = 8
3574 +
3575 +
3576 + Text Tests
3577 + SQL Params
3578 + SQLType =SQL_LONG
3579 + sub type = 0
3580 + Field Name =
3581 + Scale = 0
3582 + Charset id = 0
3583 + Not Null
3584 + Size = 4
3585 + Value = 0
3586 +
3587 + SQLType =SQL_VARYING
3588 + sub type = 0
3589 + Field Name =
3590 + Scale = 0
3591 + Charset id = 4
3592 + Nullable
3593 + Size = 1024
3594 +
3595 + SQLType =SQL_BLOB
3596 + sub type = 1
3597 + Field Name =
3598 + Scale = 0
3599 + Charset id = 4
3600 + Nullable
3601 + Size = 8
3602 +
3603 +
3604 + Binary Blob Tests
3605 +
3606 + Array Test
3607 + SQL Params
3608 + SQLType =SQL_LONG
3609 + sub type = 0
3610 + Field Name =
3611 + Scale = 0
3612 + Charset id = 0
3613 + Not Null
3614 + Size = 4
3615 + Value = 0
3616 +
3617 + SQLType =SQL_ARRAY
3618 + sub type = 0
3619 + Field Name =
3620 + Scale = 0
3621 + Charset id = 0
3622 + Nullable
3623 + Size = 8
3624 +
3625 + ROWID = 1
3626 + ITYPE = 101
3627 + I64TYPE = 9223372036854775807
3628 + CURRTYPE = 10,000.12340000
3629 + DTYPE = 9,999.12345678
3630 + FIXEDPOINT = 1,234,567,890.12345700
3631 + STR = NULL
3632 + TEXTBLOB = NULL
3633 + OTHERBLOB = NULL
3634 + MYARRAY = NULL
3635 + ROWID = 2
3636 + ITYPE = -32457
3637 + I64TYPE = -9223372036854775808
3638 + CURRTYPE = 1,000,001.12000000
3639 + DTYPE = 1.7E308
3640 + FIXEDPOINT = -1,234,567,890.12345700
3641 + STR = NULL
3642 + TEXTBLOB = NULL
3643 + OTHERBLOB = NULL
3644 + MYARRAY = NULL
3645 + ROWID = 4
3646 + ITYPE = 1
3647 + I64TYPE = 10
3648 + CURRTYPE = .02300000
3649 + DTYPE = .00110000
3650 + FIXEDPOINT = 233.45600000
3651 + STR = NULL
3652 + TEXTBLOB = NULL
3653 + OTHERBLOB = NULL
3654 + MYARRAY = NULL
3655 +
3656 + Journal Table
3657 + IBX$SESSIONID = 1
3658 + IBX$TRANSACTIONID = 9
3659 + IBX$OLDTRANSACTIONID = NULL
3660 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3661 + IBX$CREATED = 2021/12/07 09:58:40.6960
3662 + IBX$SESSIONID = 1
3663 + IBX$TRANSACTIONID = 11
3664 + IBX$OLDTRANSACTIONID = 10
3665 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3666 + IBX$CREATED = 2021/12/07 09:58:41.0190
3667 +
3668 + Journal Entries
3669 + Journal Entry = jeTransStart(Transaction Start)
3670 + Timestamp = 2021/12/07 09:58:40.7300
3671 + Session ID = 1
3672 + Transaction ID = 9
3673 + Transaction Name = "Transaction_29_1"
3674 + TPB: Item Count = 3
3675 +  isc_tpb_write
3676 +  isc_tpb_nowait
3677 +  isc_tpb_concurrency
3678 +
3679 + Default Completion = TACommit
3680 +
3681 + Journal Entry = jeQuery(Query)
3682 + Timestamp = 2021/12/07 09:58:40.7970
3683 + Session ID = 1
3684 + Transaction ID = 9
3685 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3686 +
3687 + Journal Entry = jeQuery(Query)
3688 + Timestamp = 2021/12/07 09:58:40.8130
3689 + Session ID = 1
3690 + Transaction ID = 9
3691 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3692 +
3693 + Journal Entry = jeTransCommitRet(Commit Retaining)
3694 + Timestamp = 2021/12/07 09:58:40.8900
3695 + Session ID = 1
3696 + Transaction ID = 10
3697 + Old TransactionID = 9
3698 +
3699 + Journal Entry = jeQuery(Query)
3700 + Timestamp = 2021/12/07 09:58:40.9150
3701 + Session ID = 1
3702 + Transaction ID = 10
3703 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3704 +
3705 + Journal Entry = jeTransRollbackRet(Rollback Retaining)
3706 + Timestamp = 2021/12/07 09:58:41.0150
3707 + Session ID = 1
3708 + Transaction ID = 11
3709 + Old TransactionID = 10
3710 +
3711 + Journal Entry = jeQuery(Query)
3712 + Timestamp = 2021/12/07 09:58:41.0390
3713 + Session ID = 1
3714 + Transaction ID = 11
3715 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3716 +
3717 + Journal Entry = jeTransStart(Transaction Start)
3718 + Timestamp = 2021/12/07 09:58:41.0610
3719 + Session ID = 1
3720 + Transaction ID = 12
3721 + Transaction Name = "Transaction_29_2"
3722 + TPB: Item Count = 3
3723 +  isc_tpb_write
3724 +  isc_tpb_nowait
3725 +  isc_tpb_concurrency
3726 +
3727 + Default Completion = TARollback
3728 +
3729 + Journal Entry = jeTransCommit(Commit)
3730 + Timestamp = 2021/12/07 09:58:41.1310
3731 + Session ID = 1
3732 + Transaction ID = 11
3733 +
3734 + Journal Entry = jeQuery(Query)
3735 + Timestamp = 2021/12/07 09:58:41.1910
3736 + Session ID = 1
3737 + Transaction ID = 12
3738 + 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:
3739 + Whether ''tis nobler in the mind to suffer
3740 + The slings and arrows of outrageous fortune,
3741 + Or to take arms against a sea of troubles,
3742 + And, by opposing, end them. To die, to sleep-
3743 + No more-and by a sleep to say we end
3744 + The heartache and the thousand natural shocks
3745 + That flesh is heir to-''tis a consummation
3746 + Devoutly to be wished. To die, to sleep-
3747 + To sleep, perchance to dream. Aye, there''s the rub,
3748 + For in that sleep of death what dreams may come,
3749 + When we have shuffled off this mortal coil,
3750 + Must give us pause. There''s the respect
3751 + That makes calamity of so long life.
3752 + For who would bear the whips and scorns of time,
3753 + Th'' oppressor''s wrong, the proud man''s contumely,
3754 + The pangs of despised love, the law’s delay,
3755 + The insolence of office, and the spurns
3756 + That patient merit of the unworthy takes,
3757 + When he himself might his quietus make
3758 + With a bare bodkin? Who would fardels bear,
3759 + To grunt and sweat under a weary life,
3760 + But that the dread of something after death,
3761 + The undiscovered country from whose bourn
3762 + No traveler returns, puzzles the will
3763 + And makes us rather bear those ills we have
3764 + Than fly to others that we know not of?
3765 + Thus conscience does make cowards of us all,
3766 + And thus the native hue of resolution
3767 + Is sicklied o''er with the pale cast of thought,
3768 + And enterprises of great pitch and moment,
3769 + With this regard their currents turn awry,
3770 + And lose the name of action.-Soft you now,
3771 + The fair Ophelia.-Nymph, in thy orisons
3772 + Be all my sins remembered
3773 + ')
3774 +
3775 + Journal Entry = jeQuery(Query)
3776 + Timestamp = 2021/12/07 09:58:41.2100
3777 + Session ID = 1
3778 + Transaction ID = 12
3779 + Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3780 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3781 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
3782 + 01000000010000001A01050001000000DA000000
3783 + </blob>
3784 + )
3785 +
3786 + Journal Entry = jeQuery(Query)
3787 + Timestamp = 2021/12/07 09:58:41.2330
3788 + Session ID = 1
3789 + Transaction ID = 12
3790 + 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">
3791 + <elt ix="0">100</elt>
3792 + <elt ix="1">99</elt>
3793 + <elt ix="2">98</elt>
3794 + <elt ix="3">97</elt>
3795 + <elt ix="4">96</elt>
3796 + <elt ix="5">95</elt>
3797 + <elt ix="6">94</elt>
3798 + <elt ix="7">93</elt>
3799 + <elt ix="8">92</elt>
3800 + <elt ix="9">91</elt>
3801 + <elt ix="10">90</elt>
3802 + <elt ix="11">89</elt>
3803 + <elt ix="12">88</elt>
3804 + <elt ix="13">87</elt>
3805 + <elt ix="14">86</elt>
3806 + <elt ix="15">85</elt>
3807 + <elt ix="16">84</elt>
3808 + </array>
3809 + )
3810 +
3811 + Journal Entry = jeTransRollback(Rollback)
3812 + Timestamp = 2021/12/07 09:58:41.3650
3813 + Session ID = 1
3814 + Transaction ID = 12
3815  
3816  
3817  

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines