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

Comparing ibx/trunk/fbintf/testsuite/FB4reference.log (file contents):
Revision 345 by tony, Mon Aug 23 14:22:29 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 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 3146 | Line 3223 | Invalid Param SQL Type Test
3223   Error Handled: Field "EMP_NO" not found
3224   Case sensitive Param SQL  Test
3225   Error Handled: Field "EMP_NO" not found
3226 + Stale Reference Check
3227 + First test correct usage
3228 + COUNTER = 42
3229 +
3230 + New Transaction before param set
3231 + Error Handled: This interface is no longer up-to-date
3232 + New Transaction before Open Cursor
3233 + Error Handled: This interface is no longer up-to-date
3234 + Stop Stale Reference Checks
3235 + New Transaction before param set
3236 + COUNTER = 42
3237 +
3238 + New Transaction before Open Cursor
3239 + COUNTER = 42
3240 +
3241   Invalid Server Name Test
3242   Error Handled: Unable to complete network request to host "unknown".
3243   -Failed to locate host machine.
# Line 4468 | Line 4560 | Test Completed Successfully
4560  
4561  
4562   ------------------------------------------------------
4563 + Running Test 21: Exercise setting and getting of numeric data types
4564 + SQL Params
4565 + SQLType =SQL_LONG
4566 + sub type = 0
4567 + Field Name =
4568 + Scale = 0
4569 + Charset id = 0
4570 + Not Null
4571 + Size = 4
4572 + Value = 0
4573 +
4574 + SQLType =SQL_LONG
4575 + sub type = 0
4576 + Field Name =
4577 + Scale = 0
4578 + Charset id = 0
4579 + Nullable
4580 + Size = 4
4581 +
4582 + SQLType =SQL_INT64
4583 + sub type = 0
4584 + Field Name =
4585 + Scale = 0
4586 + Charset id = 0
4587 + Nullable
4588 + Size = 8
4589 +
4590 + SQLType =SQL_INT64
4591 + sub type = 0
4592 + Field Name =
4593 + Scale = -4
4594 + Charset id = 0
4595 + Nullable
4596 + Size = 8
4597 +
4598 + SQLType =SQL_DOUBLE
4599 + sub type = 0
4600 + Field Name =
4601 + Scale = 0
4602 + Charset id = 0
4603 + Nullable
4604 + Size = 8
4605 +
4606 + SQLType =SQL_INT64
4607 + sub type = 0
4608 + Field Name =
4609 + Scale = -6
4610 + 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.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.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 +
4651 + ------------------------------------------------------
4652   Test Suite Ends

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines