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

Comparing ibx/trunk/fbintf/testsuite/FB2reference.log (file contents):
Revision 347 by tony, Mon Sep 20 22:08:20 2021 UTC vs.
Revision 356 by tony, Sun Oct 24 14:00:52 2021 UTC

# Line 73 | Line 73 | Dropping Database
73  
74   ------------------------------------------------------
75   Running Test 2: Open the employee database and run a query
76 + Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
77   Opening localhost:employee
78   Database Open, SQL Dialect = 3
79   TPB: Item Count = 3
# Line 287 | Line 288 | Not Null
288   Size = 2
289   Value = 0
290  
291 + Results for Cursor: Test Cursor
292   EMP_NO = 8
293   FIRST_NAME = Leslie
294   LAST_NAME = Johnson
# Line 512 | Line 514 | Not Null
514   Size = 2
515   Value = 0
516  
517 + Results for Cursor: Test Cursor
518   EMP_NO = 8
519   FIRST_NAME = Leslie
520   LAST_NAME = Johnson
# Line 562 | Line 565 | SALARY = 64,635.00
565   FULL_NAME = Johnson, Leslie
566  
567   Current memory = 948,496
568 < Delta memory = 1,400
568 > Delta memory = 1,288
569   Max memory = 992,448
570 < Elapsed time= 0.002 sec
571 < Cpu = 0.001 sec
570 > Elapsed time= 0.001 sec
571 > Cpu = 0.000 sec
572   Buffers = 75
573   Reads = 0
574   Writes = 0
# Line 2602 | Line 2605 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2605  
2606   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)
2607  
2608 < 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)
2608 > 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)
2609  
2610  
2611   Shrink to 2:10
# Line 2618 | Line 2621 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2621  
2622   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)
2623  
2624 < 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)
2624 > 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)
2625  
2626  
2627  
# Line 2717 | Line 2720 | Unknown Response 3
2720   Unknown Response 3
2721   Server Memory = 841392
2722   Forced Writes  = 1
2723 < Max Memory  = 879176
2723 > Max Memory  = 879288
2724   Num Buffers  = 75
2725   Sweep Interval  = 20000
2726   Logged in Users: SYSDBA,
# Line 3256 | Line 3259 | Skipping test for Firebird 4 and later
3259  
3260  
3261   ------------------------------------------------------
3262 + Running Test 21: Exercise setting and getting of numeric data types
3263 + 1234.567 parsed to 1234567 scale = -3
3264 + As Float =  1.2345670000000000E+003
3265 + -765.4321 parsed to -7654321 scale = -4
3266 + As Float = -7.6543209999999999E+002
3267 + 0.1 parsed to 1 scale = -1
3268 + As Float =  1.0000000000000001E-001
3269 + 0.01 parsed to 1 scale = -2
3270 + As Float =  1.0000000000000000E-002
3271 + +123 parsed to 123 scale = 0
3272 + As Float =  1.2300000000000000E+002
3273 + 1.23456E308 parsed to 123456 scale = 303
3274 + As Float =  1.2345600000000001E+308
3275 + -1.2e-02 parsed to -12 scale = -3
3276 + As Float = -1.2000000000000000E-002
3277 + 10. parsed to 10 scale = 0
3278 + As Float =  1.0000000000000000E+001
3279 + .12 parsed to 12 scale = -2
3280 + As Float =  1.2000000000000000E-001
3281 + 0.12 parsed to 12 scale = -2
3282 + As Float =  1.2000000000000000E-001
3283 + Parsing of 1.2E1.2 failed
3284 + Parsing of 1,000 failed
3285 + Parsing of 1e1e1 failed
3286 + Parsing of 1.2+3 failed
3287 + SQL Params
3288 + SQLType =SQL_LONG
3289 + sub type = 0
3290 + Field Name =
3291 + Scale = 0
3292 + Charset id = 0
3293 + Not Null
3294 + Size = 4
3295 + Value = 0
3296 +
3297 + SQLType =SQL_LONG
3298 + sub type = 0
3299 + Field Name =
3300 + Scale = 0
3301 + Charset id = 0
3302 + Nullable
3303 + Size = 4
3304 +
3305 + SQLType =SQL_INT64
3306 + sub type = 0
3307 + Field Name =
3308 + Scale = 0
3309 + Charset id = 0
3310 + Nullable
3311 + Size = 8
3312 +
3313 + SQLType =SQL_INT64
3314 + sub type = 0
3315 + Field Name =
3316 + Scale = -4
3317 + Charset id = 0
3318 + Nullable
3319 + Size = 8
3320 +
3321 + SQLType =SQL_DOUBLE
3322 + sub type = 0
3323 + Field Name =
3324 + Scale = 0
3325 + Charset id = 0
3326 + Nullable
3327 + Size = 8
3328 +
3329 + SQLType =SQL_INT64
3330 + sub type = 0
3331 + Field Name =
3332 + Scale = -6
3333 + Charset id = 0
3334 + Nullable
3335 + Size = 8
3336 +
3337 + Expected Error - Dynamic SQL Error
3338 + -SQL error code = -303
3339 + -conversion error from string "1,000"
3340 + Expected Error - Dynamic SQL Error
3341 + -SQL error code = -303
3342 + -conversion error from string "10.0.0"
3343 + ROWID = 1
3344 + ITYPE = 101
3345 + I64TYPE = 9223372036854775807
3346 + CURRTYPE = 10,000.12340000
3347 + DTYPE = 9,999.12345678
3348 + FIXEDPOINT = 1,234,567,890.12345700
3349 + ROWID = 2
3350 + ITYPE = -32457
3351 + I64TYPE = -9223372036854775808
3352 + CURRTYPE = 1,000,001.12000000
3353 + DTYPE = 1.7E308
3354 + FIXEDPOINT = -1,234,567,890.12345700
3355 + ROWID = 3
3356 + ITYPE = 0
3357 + I64TYPE = 0
3358 + CURRTYPE = .00000000
3359 + DTYPE = .00000000
3360 + FIXEDPOINT = .00000000
3361 + ROWID = 4
3362 + ITYPE = 1
3363 + I64TYPE = 10
3364 + CURRTYPE = .02300000
3365 + DTYPE = .00110000
3366 + FIXEDPOINT = 233.45600000
3367 +
3368 +
3369 +
3370 + ------------------------------------------------------
3371   Test Suite Ends

Diff Legend

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