76 |
|
|
77 |
|
------------------------------------------------------ |
78 |
|
Running Test 2: Open the employee database and run a query |
79 |
+ |
Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
80 |
|
Opening inet://localhost/employee |
81 |
|
Database Open, SQL Dialect = 3 |
82 |
|
TPB: Item Count = 3 |
535 |
|
FULL_NAME = Johnson, Leslie |
536 |
|
|
537 |
|
Scollable Cursors |
538 |
+ |
DB Connect String = employee |
539 |
+ |
DB Charset ID = 4 |
540 |
+ |
DB SQL Dialect = 3 |
541 |
+ |
DB Remote Protocol = |
542 |
+ |
DB ODS Major Version = 12 |
543 |
+ |
DB ODS Minor Version = 0 |
544 |
+ |
User Authentication Method = User name in DPB |
545 |
+ |
Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
546 |
+ |
DB Client Implementation Version = 3.0 |
547 |
|
Do Fetch Next: |
548 |
|
EMP_NO = 2 |
549 |
|
FIRST_NAME = Robert |
658 |
|
Current memory = 19,694,032 |
659 |
|
Delta memory = 4,480 |
660 |
|
Max memory = 19,755,888 |
661 |
< |
Elapsed time= 0.001 sec |
661 |
> |
Elapsed time= 0.002 sec |
662 |
|
Cpu = 0.000 sec |
663 |
|
Buffers = 2048 |
664 |
|
Reads = 0 |
2696 |
|
|
2697 |
|
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) |
2698 |
|
|
2699 |
< |
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) |
2699 |
> |
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) |
2700 |
|
|
2701 |
|
|
2702 |
|
Shrink to 2:10 |
2712 |
|
|
2713 |
|
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) |
2714 |
|
|
2715 |
< |
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) |
2715 |
> |
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) |
2716 |
|
|
2717 |
|
|
2718 |
|
|
3355 |
|
|
3356 |
|
------------------------------------------------------ |
3357 |
|
Running Test 21: Exercise setting and getting of numeric data types |
3358 |
+ |
1234.567 parsed to 1234567 scale = -3 |
3359 |
+ |
As Float = 1.2345670000000000E+003 |
3360 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
3361 |
+ |
As Float = -7.6543209999999999E+002 |
3362 |
+ |
0.1 parsed to 1 scale = -1 |
3363 |
+ |
As Float = 1.0000000000000001E-001 |
3364 |
+ |
0.01 parsed to 1 scale = -2 |
3365 |
+ |
As Float = 1.0000000000000000E-002 |
3366 |
+ |
+123 parsed to 123 scale = 0 |
3367 |
+ |
As Float = 1.2300000000000000E+002 |
3368 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
3369 |
+ |
As Float = 1.2345600000000001E+308 |
3370 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
3371 |
+ |
As Float = -1.2000000000000000E-002 |
3372 |
+ |
10. parsed to 10 scale = 0 |
3373 |
+ |
As Float = 1.0000000000000000E+001 |
3374 |
+ |
.12 parsed to 12 scale = -2 |
3375 |
+ |
As Float = 1.2000000000000000E-001 |
3376 |
+ |
0.12 parsed to 12 scale = -2 |
3377 |
+ |
As Float = 1.2000000000000000E-001 |
3378 |
+ |
Parsing of 1.2E1.2 failed |
3379 |
+ |
Parsing of 1,000 failed |
3380 |
+ |
Parsing of 1e1e1 failed |
3381 |
+ |
Parsing of 1.2+3 failed |
3382 |
|
SQL Params |
3383 |
|
SQLType =SQL_LONG |
3384 |
|
sub type = 0 |
3457 |
|
ITYPE = 1 |
3458 |
|
I64TYPE = 10 |
3459 |
|
CURRTYPE = .02300000 |
3460 |
< |
DTYPE = .00000000 |
3460 |
> |
DTYPE = .00110000 |
3461 |
|
FIXEDPOINT = 233.45600000 |
3462 |
|
|
3463 |
|
|