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

Comparing ibx/trunk/fbintf/testsuite/FB4reference.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 293 | 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 520 | 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 532 | Line 534 | JOB_COUNTRY = USA
534   SALARY = 64,635.00
535   FULL_NAME = Johnson, Leslie
536  
537 + Scollable Cursors
538 + Do Fetch Next:
539 + EMP_NO = 2
540 + FIRST_NAME = Robert
541 + LAST_NAME = Nelson
542 + PHONE_EXT = 250
543 + HIRE_DATE = 1988/12/28 00:00:00.0000
544 + DEPT_NO = 600
545 + JOB_CODE = VP
546 + JOB_GRADE = 2
547 + JOB_COUNTRY = USA
548 + SALARY = 105,900.00
549 + FULL_NAME = Nelson, Robert
550 + Do Fetch Last:
551 + EMP_NO = 145
552 + FIRST_NAME = Mark
553 + LAST_NAME = Guckenheimer
554 + PHONE_EXT = 221
555 + HIRE_DATE = 1994/05/02 00:00:00.0000
556 + DEPT_NO = 622
557 + JOB_CODE = Eng
558 + JOB_GRADE = 5
559 + JOB_COUNTRY = USA
560 + SALARY = 32,000.00
561 + FULL_NAME = Guckenheimer, Mark
562 + Do Fetch Prior:
563 + EMP_NO = 144
564 + FIRST_NAME = John
565 + LAST_NAME = Montgomery
566 + PHONE_EXT = 820
567 + HIRE_DATE = 1994/03/30 00:00:00.0000
568 + DEPT_NO = 672
569 + JOB_CODE = Eng
570 + JOB_GRADE = 5
571 + JOB_COUNTRY = USA
572 + SALARY = 35,000.00
573 + FULL_NAME = Montgomery, John
574 + Do Fetch First:
575 + EMP_NO = 2
576 + FIRST_NAME = Robert
577 + LAST_NAME = Nelson
578 + PHONE_EXT = 250
579 + HIRE_DATE = 1988/12/28 00:00:00.0000
580 + DEPT_NO = 600
581 + JOB_CODE = VP
582 + JOB_GRADE = 2
583 + JOB_COUNTRY = USA
584 + SALARY = 105,900.00
585 + FULL_NAME = Nelson, Robert
586 + Do Fetch Abs 8 :
587 + EMP_NO = 14
588 + FIRST_NAME = Stewart
589 + LAST_NAME = Hall
590 + PHONE_EXT = 227
591 + HIRE_DATE = 1990/06/04 00:00:00.0000
592 + DEPT_NO = 900
593 + JOB_CODE = Finan
594 + JOB_GRADE = 3
595 + JOB_COUNTRY = USA
596 + SALARY = 69,482.63
597 + FULL_NAME = Hall, Stewart
598 + Do Fetch Relative -2 :
599 + EMP_NO = 11
600 + FIRST_NAME = K. J.
601 + LAST_NAME = Weston
602 + PHONE_EXT = 34
603 + HIRE_DATE = 1990/01/17 00:00:00.0000
604 + DEPT_NO = 130
605 + JOB_CODE = SRep
606 + JOB_GRADE = 4
607 + JOB_COUNTRY = USA
608 + SALARY = 86,292.94
609 + FULL_NAME = Weston, K. J.
610 + Do Fetch beyond EOF :
611 + Fetch returned false
612  
613  
614   ------------------------------------------------------
# Line 569 | Line 646 | JOB_COUNTRY = USA
646   SALARY = 64,635.00
647   FULL_NAME = Johnson, Leslie
648  
649 < Current memory = 19,767,232
649 > Current memory = 19,767,952
650   Delta memory = 4,464
651 < Max memory = 19,813,104
652 < Elapsed time= 0.001 sec
651 > Max memory = 19,813,568
652 > Elapsed time= 0.000 sec
653   Cpu = 0.000 sec
654   Buffers = 2048
655   Reads = 0
# Line 735 | Line 812 | DEPT_NO = 600
812   JOB_CODE = Eng
813   JOB_GRADE = 4
814   JOB_COUNTRY = England
815 < SALARY = 40,000.58
815 > SALARY = 40,000.59
816   FULL_NAME = Major, Major
817  
818   Now Delete the rows
# Line 2723 | Line 2800 | Database is Read/Write
2800   Database Created: 29/5/2021 16:47:30
2801   Pages Used = 313
2802   Pages Free = 762
2803 < Server Memory = 19483648
2803 > Server Memory = 19484112
2804   Forced Writes  = 1
2805 < Max Memory  = 19629664
2805 > Max Memory  = 19630384
2806   Num Buffers  = 2048
2807   Sweep Interval  = 20000
2808   Logged in Users: SYSDBA,
# Line 4534 | Line 4611 | Charset id = 0
4611   Nullable
4612   Size = 8
4613  
4614 + Expected Error - SQLCODE: -303
4615 + Engine Code: 335544569 Incompatible column/host variable data type
4616 + Dynamic SQL Error
4617 + -SQL error code = -303
4618 + -conversion error from string "1,000"
4619 + Expected Error - SQLCODE: -303
4620 + Engine Code: 335544569 Incompatible column/host variable data type
4621 + Dynamic SQL Error
4622 + -SQL error code = -303
4623 + -conversion error from string "10.0.0"
4624   ROWID = 1
4625   ITYPE = 101
4626   I64TYPE = 9223372036854775807
4627   CURRTYPE = 10,000.12340000
4628   DTYPE = 9,999.12345678
4629 < FIXEDPOINT = 1,234,567,890.12345600
4629 > FIXEDPOINT = 1,234,567,890.12345700
4630   ROWID = 2
4631   ITYPE = -32457
4632   I64TYPE = -9223372036854775808
4633   CURRTYPE = 1,000,001.12000000
4634   DTYPE = 1.7E308
4635 < FIXEDPOINT = -1,234,567,890.12345600
4635 > FIXEDPOINT = -1,234,567,890.12345700
4636   ROWID = 3
4637   ITYPE = 0
4638   I64TYPE = 0
4639   CURRTYPE = .00000000
4640   DTYPE = .00000000
4641   FIXEDPOINT = .00000000
4642 + ROWID = 4
4643 + ITYPE = 1
4644 + I64TYPE = 10
4645 + CURRTYPE = .02300000
4646 + DTYPE = .00000000
4647 + FIXEDPOINT = 233.45600000
4648  
4649  
4650  

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines