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/branches/journaling/fbintf/testsuite/FB2reference.log (file contents):
Revision 362 by tony, Tue Dec 7 13:27:39 2021 UTC vs.
Revision 363 by tony, Tue Dec 7 13:30:05 2021 UTC

# Line 55 | Line 55 | Creating a Database with a DPD
55   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
56   ODS major = 11
57   ODS minor = 2
58 + Attachment ID = 2
59   DB Connect String = localhost:/tmp/fbintf-testsuite/testsuite1.fdb
60   DB Charset ID = 4
61   DB SQL Dialect = 3
# Line 534 | Line 535 | Running Test 3: ad hoc queries
535   Opening localhost:employee
536   Database Open
537   Employee Count = 42
538 + Transaction ID = 5277
539 + Transaction is Read/Write
540 + Transaction ID = 5277
541 + Oldest Interesting = 5275
542 + Oldest Action = 5276
543 + Oldest Snapshot = 5276
544 + Oldest Interesting = 0
545   Employee Count = 41
546   Employee Count = 42
547   Employee Count = 41
# Line 567 | Line 575 | FULL_NAME = Johnson, Leslie
575   Current memory = 948,496
576   Delta memory = 1,288
577   Max memory = 992,448
578 < Elapsed time= 0.001 sec
578 > Elapsed time= 0.002 sec
579   Cpu = 0.000 sec
580   Buffers = 75
581   Reads = 0
# Line 3367 | Line 3375 | FIXEDPOINT = 233.45600000
3375  
3376  
3377  
3378 + ------------------------------------------------------
3379 + Running Test 22: Journalling
3380 + Start Journaling. Session ID = 1
3381 + 1234.567 parsed to 1234567 scale = -3
3382 + As Float =  1.2345670000000000E+003
3383 + -765.4321 parsed to -7654321 scale = -4
3384 + As Float = -7.6543209999999999E+002
3385 + 0.1 parsed to 1 scale = -1
3386 + As Float =  1.0000000000000001E-001
3387 + 0.01 parsed to 1 scale = -2
3388 + As Float =  1.0000000000000000E-002
3389 + +123 parsed to 123 scale = 0
3390 + As Float =  1.2300000000000000E+002
3391 + 1.23456E308 parsed to 123456 scale = 303
3392 + As Float =  1.2345600000000001E+308
3393 + -1.2e-02 parsed to -12 scale = -3
3394 + As Float = -1.2000000000000000E-002
3395 + 10. parsed to 10 scale = 0
3396 + As Float =  1.0000000000000000E+001
3397 + .12 parsed to 12 scale = -2
3398 + As Float =  1.2000000000000000E-001
3399 + 0.12 parsed to 12 scale = -2
3400 + As Float =  1.2000000000000000E-001
3401 + Parsing of 1.2E1.2 failed
3402 + Parsing of 1,000 failed
3403 + Parsing of 1e1e1 failed
3404 + Parsing of 1.2+3 failed
3405 + SQL Params
3406 + SQLType =SQL_LONG
3407 + sub type = 0
3408 + Field Name =
3409 + Scale = 0
3410 + Charset id = 0
3411 + Not Null
3412 + Size = 4
3413 + Value = 0
3414 +
3415 + SQLType =SQL_LONG
3416 + sub type = 0
3417 + Field Name =
3418 + Scale = 0
3419 + Charset id = 0
3420 + Nullable
3421 + Size = 4
3422 +
3423 + SQLType =SQL_INT64
3424 + sub type = 0
3425 + Field Name =
3426 + Scale = 0
3427 + Charset id = 0
3428 + Nullable
3429 + Size = 8
3430 +
3431 + SQLType =SQL_INT64
3432 + sub type = 0
3433 + Field Name =
3434 + Scale = -4
3435 + Charset id = 0
3436 + Nullable
3437 + Size = 8
3438 +
3439 + SQLType =SQL_DOUBLE
3440 + sub type = 0
3441 + Field Name =
3442 + Scale = 0
3443 + Charset id = 0
3444 + Nullable
3445 + Size = 8
3446 +
3447 + SQLType =SQL_INT64
3448 + sub type = 0
3449 + Field Name =
3450 + Scale = -6
3451 + Charset id = 0
3452 + Nullable
3453 + Size = 8
3454 +
3455 +
3456 + Text Tests
3457 + SQL Params
3458 + SQLType =SQL_LONG
3459 + sub type = 0
3460 + Field Name =
3461 + Scale = 0
3462 + Charset id = 0
3463 + Not Null
3464 + Size = 4
3465 + Value = 0
3466 +
3467 + SQLType =SQL_VARYING
3468 + sub type = 0
3469 + Field Name =
3470 + Scale = 0
3471 + Charset id = 4
3472 + Nullable
3473 + Size = 1024
3474 +
3475 + SQLType =SQL_BLOB
3476 + sub type = 1
3477 + Field Name =
3478 + Scale = 0
3479 + Charset id = 4
3480 + Nullable
3481 + Size = 8
3482 +
3483 +
3484 + Binary Blob Tests
3485 +
3486 + Array Test
3487 + SQL Params
3488 + SQLType =SQL_LONG
3489 + sub type = 0
3490 + Field Name =
3491 + Scale = 0
3492 + Charset id = 0
3493 + Not Null
3494 + Size = 4
3495 + Value = 0
3496 +
3497 + SQLType =SQL_ARRAY
3498 + sub type = 0
3499 + Field Name =
3500 + Scale = 0
3501 + Charset id = 0
3502 + Nullable
3503 + Size = 8
3504 +
3505 + ROWID = 1
3506 + ITYPE = 101
3507 + I64TYPE = 9223372036854775807
3508 + CURRTYPE = 10,000.12340000
3509 + DTYPE = 9,999.12345678
3510 + FIXEDPOINT = 1,234,567,890.12345700
3511 + STR = NULL
3512 + TEXTBLOB = NULL
3513 + OTHERBLOB = NULL
3514 + MYARRAY = NULL
3515 + ROWID = 2
3516 + ITYPE = -32457
3517 + I64TYPE = -9223372036854775808
3518 + CURRTYPE = 1,000,001.12000000
3519 + DTYPE = 1.7E308
3520 + FIXEDPOINT = -1,234,567,890.12345700
3521 + STR = NULL
3522 + TEXTBLOB = NULL
3523 + OTHERBLOB = NULL
3524 + MYARRAY = NULL
3525 + ROWID = 4
3526 + ITYPE = 1
3527 + I64TYPE = 10
3528 + CURRTYPE = .02300000
3529 + DTYPE = .00110000
3530 + FIXEDPOINT = 233.45600000
3531 + STR = NULL
3532 + TEXTBLOB = NULL
3533 + OTHERBLOB = NULL
3534 + MYARRAY = NULL
3535 +
3536 + Journal Table
3537 + IBX$SESSIONID = 1
3538 + IBX$TRANSACTIONID = 8
3539 + IBX$OLDTRANSACTIONID = NULL
3540 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3541 + IBX$CREATED = 2021/12/07 09:57:12.8450
3542 + IBX$SESSIONID = 1
3543 + IBX$TRANSACTIONID = 10
3544 + IBX$OLDTRANSACTIONID = 9
3545 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3546 + IBX$CREATED = 2021/12/07 09:57:13.1650
3547 +
3548 + Journal Entries
3549 + Journal Entry = jeTransStart(Transaction Start)
3550 + Timestamp = 2021/12/07 09:57:12.8740
3551 + Session ID = 1
3552 + Transaction ID = 8
3553 + Transaction Name = "Transaction_29_1"
3554 + TPB: Item Count = 3
3555 +  isc_tpb_write
3556 +  isc_tpb_nowait
3557 +  isc_tpb_concurrency
3558 +
3559 + Default Completion = TACommit
3560 +
3561 + Journal Entry = jeQuery(Query)
3562 + Timestamp = 2021/12/07 09:57:12.9610
3563 + Session ID = 1
3564 + Transaction ID = 8
3565 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3566 +
3567 + Journal Entry = jeQuery(Query)
3568 + Timestamp = 2021/12/07 09:57:12.9820
3569 + Session ID = 1
3570 + Transaction ID = 8
3571 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3572 +
3573 + Journal Entry = jeTransCommitRet(Commit Retaining)
3574 + Timestamp = 2021/12/07 09:57:13.0450
3575 + Session ID = 1
3576 + Transaction ID = 9
3577 + Old TransactionID = 8
3578 +
3579 + Journal Entry = jeQuery(Query)
3580 + Timestamp = 2021/12/07 09:57:13.0670
3581 + Session ID = 1
3582 + Transaction ID = 9
3583 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3584 +
3585 + Journal Entry = jeTransRollbackRet(Rollback Retaining)
3586 + Timestamp = 2021/12/07 09:57:13.1620
3587 + Session ID = 1
3588 + Transaction ID = 10
3589 + Old TransactionID = 9
3590 +
3591 + Journal Entry = jeQuery(Query)
3592 + Timestamp = 2021/12/07 09:57:13.1830
3593 + Session ID = 1
3594 + Transaction ID = 10
3595 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3596 +
3597 + Journal Entry = jeTransStart(Transaction Start)
3598 + Timestamp = 2021/12/07 09:57:13.1940
3599 + Session ID = 1
3600 + Transaction ID = 11
3601 + Transaction Name = "Transaction_29_2"
3602 + TPB: Item Count = 3
3603 +  isc_tpb_write
3604 +  isc_tpb_nowait
3605 +  isc_tpb_concurrency
3606 +
3607 + Default Completion = TARollback
3608 +
3609 + Journal Entry = jeTransCommit(Commit)
3610 + Timestamp = 2021/12/07 09:57:13.2360
3611 + Session ID = 1
3612 + Transaction ID = 10
3613 +
3614 + Journal Entry = jeQuery(Query)
3615 + Timestamp = 2021/12/07 09:57:13.2590
3616 + Session ID = 1
3617 + Transaction ID = 11
3618 + 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:
3619 + Whether ''tis nobler in the mind to suffer
3620 + The slings and arrows of outrageous fortune,
3621 + Or to take arms against a sea of troubles,
3622 + And, by opposing, end them. To die, to sleep-
3623 + No more-and by a sleep to say we end
3624 + The heartache and the thousand natural shocks
3625 + That flesh is heir to-''tis a consummation
3626 + Devoutly to be wished. To die, to sleep-
3627 + To sleep, perchance to dream. Aye, there''s the rub,
3628 + For in that sleep of death what dreams may come,
3629 + When we have shuffled off this mortal coil,
3630 + Must give us pause. There''s the respect
3631 + That makes calamity of so long life.
3632 + For who would bear the whips and scorns of time,
3633 + Th'' oppressor''s wrong, the proud man''s contumely,
3634 + The pangs of despised love, the law’s delay,
3635 + The insolence of office, and the spurns
3636 + That patient merit of the unworthy takes,
3637 + When he himself might his quietus make
3638 + With a bare bodkin? Who would fardels bear,
3639 + To grunt and sweat under a weary life,
3640 + But that the dread of something after death,
3641 + The undiscovered country from whose bourn
3642 + No traveler returns, puzzles the will
3643 + And makes us rather bear those ills we have
3644 + Than fly to others that we know not of?
3645 + Thus conscience does make cowards of us all,
3646 + And thus the native hue of resolution
3647 + Is sicklied o''er with the pale cast of thought,
3648 + And enterprises of great pitch and moment,
3649 + With this regard their currents turn awry,
3650 + And lose the name of action.-Soft you now,
3651 + The fair Ophelia.-Nymph, in thy orisons
3652 + Be all my sins remembered
3653 + ')
3654 +
3655 + Journal Entry = jeQuery(Query)
3656 + Timestamp = 2021/12/07 09:57:13.2780
3657 + Session ID = 1
3658 + Transaction ID = 11
3659 + Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3660 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3661 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
3662 + 01000000010000001A01050001000000DA000000
3663 + </blob>
3664 + )
3665 +
3666 + Journal Entry = jeQuery(Query)
3667 + Timestamp = 2021/12/07 09:57:13.3010
3668 + Session ID = 1
3669 + Transaction ID = 11
3670 + 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">
3671 + <elt ix="0">100</elt>
3672 + <elt ix="1">99</elt>
3673 + <elt ix="2">98</elt>
3674 + <elt ix="3">97</elt>
3675 + <elt ix="4">96</elt>
3676 + <elt ix="5">95</elt>
3677 + <elt ix="6">94</elt>
3678 + <elt ix="7">93</elt>
3679 + <elt ix="8">92</elt>
3680 + <elt ix="9">91</elt>
3681 + <elt ix="10">90</elt>
3682 + <elt ix="11">89</elt>
3683 + <elt ix="12">88</elt>
3684 + <elt ix="13">87</elt>
3685 + <elt ix="14">86</elt>
3686 + <elt ix="15">85</elt>
3687 + <elt ix="16">84</elt>
3688 + </array>
3689 + )
3690 +
3691 + Journal Entry = jeTransRollback(Rollback)
3692 + Timestamp = 2021/12/07 09:57:13.3610
3693 + Session ID = 1
3694 + Transaction ID = 11
3695 +
3696 +
3697 +
3698   ------------------------------------------------------
3699   Test Suite Ends

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines