ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/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.
Revision 356 by tony, Sun Oct 24 14:00:52 2021 UTC

# Line 76 | Line 76 | Dropping Database
76  
77   ------------------------------------------------------
78   Running Test 2: Open the employee database and run a query
79 + Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
80   Opening inet://localhost/employee
81   Database Open, SQL Dialect = 3
82   TPB: Item Count = 3
# Line 292 | Line 293 | Not Null
293   Size = 2
294   Value = 0
295  
296 + Results for Cursor: Test Cursor
297   EMP_NO = 8
298   FIRST_NAME = Leslie
299   LAST_NAME = Johnson
# Line 519 | Line 521 | Not Null
521   Size = 2
522   Value = 0
523  
524 + Results for Cursor: Test Cursor
525   EMP_NO = 8
526   FIRST_NAME = Leslie
527   LAST_NAME = Johnson
# Line 531 | Line 534 | JOB_COUNTRY = USA
534   SALARY = 64,635.00
535   FULL_NAME = Johnson, Leslie
536  
537 + Scollable Cursors
538 + DB Connect String = employee
539 + DB Charset ID = 4
540 + DB SQL Dialect = 3
541 + DB Remote Protocol =
542 + DB ODS Major Version = 12
543 + DB ODS Minor Version = 0
544 + User Authentication Method = User name in DPB
545 + Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
546 + DB Client Implementation Version = 3.0
547 + Do Fetch Next:
548 + EMP_NO = 2
549 + FIRST_NAME = Robert
550 + LAST_NAME = Nelson
551 + PHONE_EXT = 250
552 + HIRE_DATE = 1988/12/28 00:00:00.0000
553 + DEPT_NO = 600
554 + JOB_CODE = VP
555 + JOB_GRADE = 2
556 + JOB_COUNTRY = USA
557 + SALARY = 105,900.00
558 + FULL_NAME = Nelson, Robert
559 + Do Fetch Last:
560 + EMP_NO = 145
561 + FIRST_NAME = Mark
562 + LAST_NAME = Guckenheimer
563 + PHONE_EXT = 221
564 + HIRE_DATE = 1994/05/02 00:00:00.0000
565 + DEPT_NO = 622
566 + JOB_CODE = Eng
567 + JOB_GRADE = 5
568 + JOB_COUNTRY = USA
569 + SALARY = 32,000.00
570 + FULL_NAME = Guckenheimer, Mark
571 + Do Fetch Prior:
572 + EMP_NO = 144
573 + FIRST_NAME = John
574 + LAST_NAME = Montgomery
575 + PHONE_EXT = 820
576 + HIRE_DATE = 1994/03/30 00:00:00.0000
577 + DEPT_NO = 672
578 + JOB_CODE = Eng
579 + JOB_GRADE = 5
580 + JOB_COUNTRY = USA
581 + SALARY = 35,000.00
582 + FULL_NAME = Montgomery, John
583 + Do Fetch First:
584 + EMP_NO = 2
585 + FIRST_NAME = Robert
586 + LAST_NAME = Nelson
587 + PHONE_EXT = 250
588 + HIRE_DATE = 1988/12/28 00:00:00.0000
589 + DEPT_NO = 600
590 + JOB_CODE = VP
591 + JOB_GRADE = 2
592 + JOB_COUNTRY = USA
593 + SALARY = 105,900.00
594 + FULL_NAME = Nelson, Robert
595 + Do Fetch Abs 8 :
596 + EMP_NO = 14
597 + FIRST_NAME = Stewart
598 + LAST_NAME = Hall
599 + PHONE_EXT = 227
600 + HIRE_DATE = 1990/06/04 00:00:00.0000
601 + DEPT_NO = 900
602 + JOB_CODE = Finan
603 + JOB_GRADE = 3
604 + JOB_COUNTRY = USA
605 + SALARY = 69,482.63
606 + FULL_NAME = Hall, Stewart
607 + Do Fetch Relative -2 :
608 + EMP_NO = 11
609 + FIRST_NAME = K. J.
610 + LAST_NAME = Weston
611 + PHONE_EXT = 34
612 + HIRE_DATE = 1990/01/17 00:00:00.0000
613 + DEPT_NO = 130
614 + JOB_CODE = SRep
615 + JOB_GRADE = 4
616 + JOB_COUNTRY = USA
617 + SALARY = 86,292.94
618 + FULL_NAME = Weston, K. J.
619 + Do Fetch beyond EOF :
620 + Fetch returned false
621  
622  
623   ------------------------------------------------------
# Line 568 | Line 655 | JOB_COUNTRY = USA
655   SALARY = 64,635.00
656   FULL_NAME = Johnson, Leslie
657  
658 < Current memory = 19,693,312
658 > Current memory = 19,694,032
659   Delta memory = 4,480
660 < Max memory = 19,755,424
661 < Elapsed time= 0.001 sec
660 > Max memory = 19,755,888
661 > Elapsed time= 0.002 sec
662   Cpu = 0.000 sec
663   Buffers = 2048
664   Reads = 0
# Line 734 | Line 821 | DEPT_NO = 600
821   JOB_CODE = Eng
822   JOB_GRADE = 4
823   JOB_COUNTRY = England
824 < SALARY = 40,000.58
824 > SALARY = 40,000.59
825   FULL_NAME = Major, Major
826  
827   Now Delete the rows
# Line 2609 | Line 2696 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2696  
2697   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)
2698  
2699 < 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)
2699 > 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)
2700  
2701  
2702   Shrink to 2:10
# Line 2625 | Line 2712 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2712  
2713   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)
2714  
2715 < 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)
2715 > 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)
2716  
2717  
2718  
# Line 2722 | Line 2809 | Database is Read/Write
2809   Database Created: 09/1/2020 13:13:45
2810   Pages Used = 297
2811   Pages Free = 10
2812 < Server Memory = 19195664
2812 > Server Memory = 19196128
2813   Forced Writes  = 1
2814 < Max Memory  = 19316176
2814 > Max Memory  = 19316896
2815   Num Buffers  = 2048
2816   Sweep Interval  = 20000
2817   Logged in Users: SYSDBA,
# Line 3268 | Line 3355 | Skipping test for Firebird 4 and later
3355  
3356   ------------------------------------------------------
3357   Running Test 21: Exercise setting and getting of numeric data types
3358 + 1234.567 parsed to 1234567 scale = -3
3359 + As Float =  1.2345670000000000E+003
3360 + -765.4321 parsed to -7654321 scale = -4
3361 + As Float = -7.6543209999999999E+002
3362 + 0.1 parsed to 1 scale = -1
3363 + As Float =  1.0000000000000001E-001
3364 + 0.01 parsed to 1 scale = -2
3365 + As Float =  1.0000000000000000E-002
3366 + +123 parsed to 123 scale = 0
3367 + As Float =  1.2300000000000000E+002
3368 + 1.23456E308 parsed to 123456 scale = 303
3369 + As Float =  1.2345600000000001E+308
3370 + -1.2e-02 parsed to -12 scale = -3
3371 + As Float = -1.2000000000000000E-002
3372 + 10. parsed to 10 scale = 0
3373 + As Float =  1.0000000000000000E+001
3374 + .12 parsed to 12 scale = -2
3375 + As Float =  1.2000000000000000E-001
3376 + 0.12 parsed to 12 scale = -2
3377 + As Float =  1.2000000000000000E-001
3378 + Parsing of 1.2E1.2 failed
3379 + Parsing of 1,000 failed
3380 + Parsing of 1e1e1 failed
3381 + Parsing of 1.2+3 failed
3382   SQL Params
3383   SQLType =SQL_LONG
3384   sub type = 0
# Line 3318 | Line 3429 | Charset id = 0
3429   Nullable
3430   Size = 8
3431  
3432 + Expected Error - Dynamic SQL Error
3433 + -SQL error code = -303
3434 + -conversion error from string "1,000"
3435 + Expected Error - Dynamic SQL Error
3436 + -SQL error code = -303
3437 + -conversion error from string "10.0.0"
3438   ROWID = 1
3439   ITYPE = 101
3440   I64TYPE = 9223372036854775807
3441   CURRTYPE = 10,000.12340000
3442   DTYPE = 9,999.12345678
3443 < FIXEDPOINT = 1,234,567,890.12345600
3443 > FIXEDPOINT = 1,234,567,890.12345700
3444   ROWID = 2
3445   ITYPE = -32457
3446   I64TYPE = -9223372036854775808
3447   CURRTYPE = 1,000,001.12000000
3448   DTYPE = 1.7E308
3449 < FIXEDPOINT = -1,234,567,890.12345600
3449 > FIXEDPOINT = -1,234,567,890.12345700
3450   ROWID = 3
3451   ITYPE = 0
3452   I64TYPE = 0
3453   CURRTYPE = .00000000
3454   DTYPE = .00000000
3455   FIXEDPOINT = .00000000
3456 + ROWID = 4
3457 + ITYPE = 1
3458 + I64TYPE = 10
3459 + CURRTYPE = .02300000
3460 + DTYPE = .00110000
3461 + FIXEDPOINT = 233.45600000
3462  
3463  
3464  

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines