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 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 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 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 3139 | Line 3216 | Invalid Param SQL Type Test
3216   Error Handled: Field "EMP_NO" not found
3217   Case sensitive Param SQL  Test
3218   Error Handled: Field "EMP_NO" not found
3219 + Stale Reference Check
3220 + First test correct usage
3221 + COUNTER = 42
3222 +
3223 + New Transaction before param set
3224 + Error Handled: This interface is no longer up-to-date
3225 + New Transaction before Open Cursor
3226 + Error Handled: This interface is no longer up-to-date
3227 + Stop Stale Reference Checks
3228 + New Transaction before param set
3229 + COUNTER = 42
3230 +
3231 + New Transaction before Open Cursor
3232 + COUNTER = 42
3233 +
3234   Invalid Server Name Test
3235   Error Handled: Unable to complete network request to host "unknown".
3236   -Failed to locate host machine.
# Line 3252 | Line 3344 | Skipping test for Firebird 4 and later
3344  
3345  
3346   ------------------------------------------------------
3347 + Running Test 21: Exercise setting and getting of numeric data types
3348 + SQL Params
3349 + SQLType =SQL_LONG
3350 + sub type = 0
3351 + Field Name =
3352 + Scale = 0
3353 + Charset id = 0
3354 + Not Null
3355 + Size = 4
3356 + Value = 0
3357 +
3358 + SQLType =SQL_LONG
3359 + sub type = 0
3360 + Field Name =
3361 + Scale = 0
3362 + Charset id = 0
3363 + Nullable
3364 + Size = 4
3365 +
3366 + SQLType =SQL_INT64
3367 + sub type = 0
3368 + Field Name =
3369 + Scale = 0
3370 + Charset id = 0
3371 + Nullable
3372 + Size = 8
3373 +
3374 + SQLType =SQL_INT64
3375 + sub type = 0
3376 + Field Name =
3377 + Scale = -4
3378 + Charset id = 0
3379 + Nullable
3380 + Size = 8
3381 +
3382 + SQLType =SQL_DOUBLE
3383 + sub type = 0
3384 + Field Name =
3385 + Scale = 0
3386 + Charset id = 0
3387 + Nullable
3388 + Size = 8
3389 +
3390 + SQLType =SQL_INT64
3391 + sub type = 0
3392 + Field Name =
3393 + Scale = -6
3394 + 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.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.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 +
3431 + ------------------------------------------------------
3432   Test Suite Ends

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines