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 350 by tony, Wed Oct 20 14:58:56 2021 UTC

# Line 292 | Line 292 | Not Null
292   Size = 2
293   Value = 0
294  
295 + Results for Cursor: Test Cursor
296   EMP_NO = 8
297   FIRST_NAME = Leslie
298   LAST_NAME = Johnson
# Line 519 | Line 520 | Not Null
520   Size = 2
521   Value = 0
522  
523 + Results for Cursor: Test Cursor
524   EMP_NO = 8
525   FIRST_NAME = Leslie
526   LAST_NAME = Johnson
# Line 531 | Line 533 | JOB_COUNTRY = USA
533   SALARY = 64,635.00
534   FULL_NAME = Johnson, Leslie
535  
536 + Scollable Cursors
537 + Do Fetch Next:
538 + EMP_NO = 2
539 + FIRST_NAME = Robert
540 + LAST_NAME = Nelson
541 + PHONE_EXT = 250
542 + HIRE_DATE = 1988/12/28 00:00:00.0000
543 + DEPT_NO = 600
544 + JOB_CODE = VP
545 + JOB_GRADE = 2
546 + JOB_COUNTRY = USA
547 + SALARY = 105,900.00
548 + FULL_NAME = Nelson, Robert
549 + Do Fetch Last:
550 + EMP_NO = 145
551 + FIRST_NAME = Mark
552 + LAST_NAME = Guckenheimer
553 + PHONE_EXT = 221
554 + HIRE_DATE = 1994/05/02 00:00:00.0000
555 + DEPT_NO = 622
556 + JOB_CODE = Eng
557 + JOB_GRADE = 5
558 + JOB_COUNTRY = USA
559 + SALARY = 32,000.00
560 + FULL_NAME = Guckenheimer, Mark
561 + Do Fetch Prior:
562 + EMP_NO = 144
563 + FIRST_NAME = John
564 + LAST_NAME = Montgomery
565 + PHONE_EXT = 820
566 + HIRE_DATE = 1994/03/30 00:00:00.0000
567 + DEPT_NO = 672
568 + JOB_CODE = Eng
569 + JOB_GRADE = 5
570 + JOB_COUNTRY = USA
571 + SALARY = 35,000.00
572 + FULL_NAME = Montgomery, John
573 + Do Fetch First:
574 + EMP_NO = 2
575 + FIRST_NAME = Robert
576 + LAST_NAME = Nelson
577 + PHONE_EXT = 250
578 + HIRE_DATE = 1988/12/28 00:00:00.0000
579 + DEPT_NO = 600
580 + JOB_CODE = VP
581 + JOB_GRADE = 2
582 + JOB_COUNTRY = USA
583 + SALARY = 105,900.00
584 + FULL_NAME = Nelson, Robert
585 + Do Fetch Abs 8 :
586 + EMP_NO = 14
587 + FIRST_NAME = Stewart
588 + LAST_NAME = Hall
589 + PHONE_EXT = 227
590 + HIRE_DATE = 1990/06/04 00:00:00.0000
591 + DEPT_NO = 900
592 + JOB_CODE = Finan
593 + JOB_GRADE = 3
594 + JOB_COUNTRY = USA
595 + SALARY = 69,482.63
596 + FULL_NAME = Hall, Stewart
597 + Do Fetch Relative -2 :
598 + EMP_NO = 11
599 + FIRST_NAME = K. J.
600 + LAST_NAME = Weston
601 + PHONE_EXT = 34
602 + HIRE_DATE = 1990/01/17 00:00:00.0000
603 + DEPT_NO = 130
604 + JOB_CODE = SRep
605 + JOB_GRADE = 4
606 + JOB_COUNTRY = USA
607 + SALARY = 86,292.94
608 + FULL_NAME = Weston, K. J.
609 + Do Fetch beyond EOF :
610 + Fetch returned false
611  
612  
613   ------------------------------------------------------
# Line 568 | Line 645 | JOB_COUNTRY = USA
645   SALARY = 64,635.00
646   FULL_NAME = Johnson, Leslie
647  
648 < Current memory = 19,693,312
648 > Current memory = 19,694,032
649   Delta memory = 4,480
650 < Max memory = 19,755,424
650 > Max memory = 19,755,888
651   Elapsed time= 0.001 sec
652   Cpu = 0.000 sec
653   Buffers = 2048
# Line 734 | Line 811 | DEPT_NO = 600
811   JOB_CODE = Eng
812   JOB_GRADE = 4
813   JOB_COUNTRY = England
814 < SALARY = 40,000.58
814 > SALARY = 40,000.59
815   FULL_NAME = Major, Major
816  
817   Now Delete the rows
# Line 2722 | Line 2799 | Database is Read/Write
2799   Database Created: 09/1/2020 13:13:45
2800   Pages Used = 297
2801   Pages Free = 10
2802 < Server Memory = 19195664
2802 > Server Memory = 19196128
2803   Forced Writes  = 1
2804 < Max Memory  = 19316176
2804 > Max Memory  = 19316896
2805   Num Buffers  = 2048
2806   Sweep Interval  = 20000
2807   Logged in Users: SYSDBA,
# Line 3318 | Line 3395 | Charset id = 0
3395   Nullable
3396   Size = 8
3397  
3398 + Expected Error - Dynamic SQL Error
3399 + -SQL error code = -303
3400 + -conversion error from string "1,000"
3401 + Expected Error - Dynamic SQL Error
3402 + -SQL error code = -303
3403 + -conversion error from string "10.0.0"
3404   ROWID = 1
3405   ITYPE = 101
3406   I64TYPE = 9223372036854775807
3407   CURRTYPE = 10,000.12340000
3408   DTYPE = 9,999.12345678
3409 < FIXEDPOINT = 1,234,567,890.12345600
3409 > FIXEDPOINT = 1,234,567,890.12345700
3410   ROWID = 2
3411   ITYPE = -32457
3412   I64TYPE = -9223372036854775808
3413   CURRTYPE = 1,000,001.12000000
3414   DTYPE = 1.7E308
3415 < FIXEDPOINT = -1,234,567,890.12345600
3415 > FIXEDPOINT = -1,234,567,890.12345700
3416   ROWID = 3
3417   ITYPE = 0
3418   I64TYPE = 0
3419   CURRTYPE = .00000000
3420   DTYPE = .00000000
3421   FIXEDPOINT = .00000000
3422 + ROWID = 4
3423 + ITYPE = 1
3424 + I64TYPE = 10
3425 + CURRTYPE = .02300000
3426 + DTYPE = .00000000
3427 + FIXEDPOINT = 233.45600000
3428  
3429  
3430  

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines