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 345 by tony, Mon Aug 23 14:22:29 2021 UTC vs.
ibx/branches/journaling/fbintf/testsuite/FB2reference.log (file contents), 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 73 | Line 74 | Dropping Database
74  
75   ------------------------------------------------------
76   Running Test 2: Open the employee database and run a query
77 + Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
78   Opening localhost:employee
79   Database Open, SQL Dialect = 3
80   TPB: Item Count = 3
# Line 287 | Line 289 | Not Null
289   Size = 2
290   Value = 0
291  
292 + Results for Cursor: Test Cursor
293   EMP_NO = 8
294   FIRST_NAME = Leslie
295   LAST_NAME = Johnson
# Line 512 | Line 515 | Not Null
515   Size = 2
516   Value = 0
517  
518 + Results for Cursor: Test Cursor
519   EMP_NO = 8
520   FIRST_NAME = Leslie
521   LAST_NAME = Johnson
# Line 531 | 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 561 | Line 572 | JOB_COUNTRY = USA
572   SALARY = 64,635.00
573   FULL_NAME = Johnson, Leslie
574  
575 < Current memory = 948,560
576 < Delta memory = 1,400
577 < Max memory = 992,504
575 > Current memory = 948,496
576 > Delta memory = 1,288
577 > Max memory = 992,448
578   Elapsed time= 0.002 sec
579   Cpu = 0.000 sec
580   Buffers = 75
# Line 2602 | Line 2613 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2613  
2614   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)
2615  
2616 < 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)
2616 > 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)
2617  
2618  
2619   Shrink to 2:10
# Line 2618 | Line 2629 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2629  
2630   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)
2631  
2632 < 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)
2632 > 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)
2633  
2634  
2635  
# Line 2717 | Line 2728 | Unknown Response 3
2728   Unknown Response 3
2729   Server Memory = 841392
2730   Forced Writes  = 1
2731 < Max Memory  = 879240
2731 > Max Memory  = 879288
2732   Num Buffers  = 75
2733   Sweep Interval  = 20000
2734   Logged in Users: SYSDBA,
# Line 3129 | Line 3140 | Invalid Param SQL Type Test
3140   Error Handled: Field "EMP_NO" not found
3141   Case sensitive Param SQL  Test
3142   Error Handled: Field "EMP_NO" not found
3143 + Stale Reference Check
3144 + First test correct usage
3145 + COUNTER = 42
3146 +
3147 + New Transaction before param set
3148 + Error Handled: This interface is no longer up-to-date
3149 + New Transaction before Open Cursor
3150 + Error Handled: This interface is no longer up-to-date
3151 + Stop Stale Reference Checks
3152 + New Transaction before param set
3153 + COUNTER = 42
3154 +
3155 + New Transaction before Open Cursor
3156 + COUNTER = 42
3157 +
3158   Invalid Server Name Test
3159   Error Handled: Unable to complete network request to host "unknown".
3160   -Failed to locate host machine
# Line 3241 | Line 3267 | Skipping test for Firebird 4 and later
3267  
3268  
3269   ------------------------------------------------------
3270 + Running Test 21: Exercise setting and getting of numeric data types
3271 + 1234.567 parsed to 1234567 scale = -3
3272 + As Float =  1.2345670000000000E+003
3273 + -765.4321 parsed to -7654321 scale = -4
3274 + As Float = -7.6543209999999999E+002
3275 + 0.1 parsed to 1 scale = -1
3276 + As Float =  1.0000000000000001E-001
3277 + 0.01 parsed to 1 scale = -2
3278 + As Float =  1.0000000000000000E-002
3279 + +123 parsed to 123 scale = 0
3280 + As Float =  1.2300000000000000E+002
3281 + 1.23456E308 parsed to 123456 scale = 303
3282 + As Float =  1.2345600000000001E+308
3283 + -1.2e-02 parsed to -12 scale = -3
3284 + As Float = -1.2000000000000000E-002
3285 + 10. parsed to 10 scale = 0
3286 + As Float =  1.0000000000000000E+001
3287 + .12 parsed to 12 scale = -2
3288 + As Float =  1.2000000000000000E-001
3289 + 0.12 parsed to 12 scale = -2
3290 + As Float =  1.2000000000000000E-001
3291 + Parsing of 1.2E1.2 failed
3292 + Parsing of 1,000 failed
3293 + Parsing of 1e1e1 failed
3294 + Parsing of 1.2+3 failed
3295 + SQL Params
3296 + SQLType =SQL_LONG
3297 + sub type = 0
3298 + Field Name =
3299 + Scale = 0
3300 + Charset id = 0
3301 + Not Null
3302 + Size = 4
3303 + Value = 0
3304 +
3305 + SQLType =SQL_LONG
3306 + sub type = 0
3307 + Field Name =
3308 + Scale = 0
3309 + Charset id = 0
3310 + Nullable
3311 + Size = 4
3312 +
3313 + SQLType =SQL_INT64
3314 + sub type = 0
3315 + Field Name =
3316 + Scale = 0
3317 + Charset id = 0
3318 + Nullable
3319 + Size = 8
3320 +
3321 + SQLType =SQL_INT64
3322 + sub type = 0
3323 + Field Name =
3324 + Scale = -4
3325 + Charset id = 0
3326 + Nullable
3327 + Size = 8
3328 +
3329 + SQLType =SQL_DOUBLE
3330 + sub type = 0
3331 + Field Name =
3332 + Scale = 0
3333 + Charset id = 0
3334 + Nullable
3335 + Size = 8
3336 +
3337 + SQLType =SQL_INT64
3338 + sub type = 0
3339 + Field Name =
3340 + Scale = -6
3341 + Charset id = 0
3342 + Nullable
3343 + Size = 8
3344 +
3345 + Expected Error - Dynamic SQL Error
3346 + -SQL error code = -303
3347 + -conversion error from string "1,000"
3348 + Expected Error - Dynamic SQL Error
3349 + -SQL error code = -303
3350 + -conversion error from string "10.0.0"
3351 + ROWID = 1
3352 + ITYPE = 101
3353 + I64TYPE = 9223372036854775807
3354 + CURRTYPE = 10,000.12340000
3355 + DTYPE = 9,999.12345678
3356 + FIXEDPOINT = 1,234,567,890.12345700
3357 + ROWID = 2
3358 + ITYPE = -32457
3359 + I64TYPE = -9223372036854775808
3360 + CURRTYPE = 1,000,001.12000000
3361 + DTYPE = 1.7E308
3362 + FIXEDPOINT = -1,234,567,890.12345700
3363 + ROWID = 3
3364 + ITYPE = 0
3365 + I64TYPE = 0
3366 + CURRTYPE = .00000000
3367 + DTYPE = .00000000
3368 + FIXEDPOINT = .00000000
3369 + ROWID = 4
3370 + ITYPE = 1
3371 + I64TYPE = 10
3372 + CURRTYPE = .02300000
3373 + DTYPE = .00110000
3374 + 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