| 18 |
|
DB ODS Major Version = 12 |
| 19 |
|
DB ODS Minor Version = 0 |
| 20 |
|
User Authentication Method = Srp |
| 21 |
+ |
Firebird Library Path = /usr/lib/libfbclient.so |
| 22 |
+ |
DB Client Implementation Version = 3.768 |
| 23 |
|
DPB |
| 24 |
|
Count = 3 |
| 25 |
|
28 = SYSDBA |
| 35 |
|
DB ODS Major Version = 12 |
| 36 |
|
DB ODS Minor Version = 0 |
| 37 |
|
User Authentication Method = Srp |
| 38 |
+ |
Firebird Library Path = /usr/lib/libfbclient.so |
| 39 |
+ |
DB Client Implementation Version = 3.768 |
| 40 |
|
Dropping Database |
| 41 |
|
DPB |
| 42 |
|
Count = 4 |
| 56 |
|
DB ODS Major Version = 12 |
| 57 |
|
DB ODS Minor Version = 0 |
| 58 |
|
User Authentication Method = Srp |
| 59 |
+ |
Firebird Library Path = /usr/lib/libfbclient.so |
| 60 |
+ |
DB Client Implementation Version = 3.768 |
| 61 |
|
RDB$DESCRIPTION = |
| 62 |
|
RDB$RELATION_ID = 128 |
| 63 |
|
RDB$SECURITY_CLASS = SQL$363 |
| 318 |
|
SALARY = 64,635.00 |
| 319 |
|
FULL_NAME = Johnson, Leslie |
| 320 |
|
|
| 321 |
< |
Current memory = 1.960269600000000000E+0007 |
| 322 |
< |
Delta memory = 2.616000000000000000E+0003 |
| 323 |
< |
Max memory = 1.966627200000000000E+0007 |
| 321 |
> |
Current memory = 19604216 |
| 322 |
> |
Delta memory = 4280 |
| 323 |
> |
Max memory = 19666136 |
| 324 |
|
Elapsed time= 0.000 sec |
| 325 |
|
Cpu = 0.000 sec |
| 326 |
< |
Buffers = 2.048000000000000000E+0003 |
| 327 |
< |
Reads = 0.000000000000000000E+0000 |
| 328 |
< |
Writes = 0.000000000000000000E+0000 |
| 329 |
< |
Fetches = 2.000000000000000000E+0000 |
| 326 |
> |
Buffers = 2048 |
| 327 |
> |
Reads = 0 |
| 328 |
> |
Writes = 0 |
| 329 |
> |
Fetches = 4 |
| 330 |
|
Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 |
| 331 |
|
Relation Name = EMPLOYEE |
| 332 |
|
Metadata |
| 559 |
|
SALARY = 75,060.00 |
| 560 |
|
FULL_NAME = Forest, Phil |
| 561 |
|
|
| 562 |
+ |
Test using Execute Block |
| 563 |
+ |
Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0 |
| 564 |
+ |
EMP_NO = 8 |
| 565 |
+ |
FIRST_NAME = Leslie |
| 566 |
+ |
LAST_NAME = Johnson |
| 567 |
+ |
PHONE_EXT = 410 |
| 568 |
+ |
HIRE_DATE = 31/1/2015 00:00:00.000 |
| 569 |
+ |
DEPT_NO = 180 |
| 570 |
+ |
JOB_CODE = Mktg |
| 571 |
+ |
JOB_GRADE = 3 |
| 572 |
+ |
JOB_COUNTRY = USA |
| 573 |
+ |
SALARY = 64,635.00 |
| 574 |
+ |
FULL_NAME = Johnson, Leslie |
| 575 |
+ |
|
| 576 |
|
|
| 577 |
|
|
| 578 |
|
Running Test 5: Update Returning and Activity Check |
| 2268 |
|
Database Created: 27/9/2016 12:08:46 |
| 2269 |
|
Pages Used = 297 |
| 2270 |
|
Pages Free = 10 |
| 2271 |
< |
Server Memory = 19122232 |
| 2271 |
> |
Server Memory = 19122464 |
| 2272 |
|
Forced Writes = 1 |
| 2273 |
< |
Max Memory = 19235672 |
| 2273 |
> |
Max Memory = 19242808 |
| 2274 |
|
Num Buffers = 2048 |
| 2275 |
|
Sweep Interval = 20000 |
| 2276 |
|
Logged in Users: SYSDBA, |
| 2277 |
|
Active Transaction Count = 0 |
| 2278 |
< |
Fetches = 546 |
| 2278 |
> |
Fetches = 552 |
| 2279 |
|
Writes = 8 |
| 2280 |
|
Reads = 54 |
| 2281 |
|
Page Writes = 5 |
| 2295 |
|
Table ID = 6 |
| 2296 |
|
Count = 15 |
| 2297 |
|
Table ID = 9 |
| 2298 |
< |
Count = 2 |
| 2298 |
> |
Count = 3 |
| 2299 |
|
Table ID = 11 |
| 2300 |
|
Count = 1 |
| 2301 |
|
Table ID = 12 |
| 2322 |
|
Event Signalled |
| 2323 |
|
First Event - usually ignored |
| 2324 |
|
Signal Event |
| 2305 |
– |
Event Signalled |
| 2325 |
|
Event Counts: TESTEVENT, Count = 1 |
| 2326 |
|
Two more events |
| 2327 |
|
Call Async Wait |
| 2328 |
|
Async Wait Called |
| 2329 |
|
Event Signalled |
| 2330 |
+ |
Event Signalled |
| 2331 |
|
Deferred Events Caught |
| 2332 |
|
Event Counts: TESTEVENT, Count = 2 |
| 2333 |
|
Signal Event |
| 2314 |
– |
Event Signalled |
| 2334 |
|
Event Counts: TESTEVENT, Count = 1 |
| 2335 |
|
Async Wait: Test Cancel |
| 2336 |
+ |
Event Signalled |
| 2337 |
|
Async Wait Called |
| 2338 |
|
Event Cancelled |
| 2339 |
|
Time Out - Cancel Worked! |
| 2362 |
|
Last Name = |
| 2363 |
|
User ID = 0 |
| 2364 |
|
Group ID = 0 |
| 2365 |
+ |
User Name = ALICE |
| 2366 |
+ |
First Name = |
| 2367 |
+ |
Middle Name = |
| 2368 |
+ |
Last Name = |
| 2369 |
+ |
User ID = 0 |
| 2370 |
+ |
Group ID = 0 |
| 2371 |
|
|
| 2372 |
|
|
| 2373 |
|
Licence Info: feature is not supported |
| 2599 |
|
Error Handled: Field "EMP_NO" not found |
| 2600 |
|
Invalid Server Name Test |
| 2601 |
|
Error Handled: Unable to complete network request to host "unknown". |
| 2602 |
< |
Failed to locate host machine. |
| 2577 |
< |
The specified name was not found in the hosts file or Domain Name Services |
| 2602 |
> |
Failed to establish a connection |
| 2603 |
|
Invalid User Name Test |
| 2604 |
|
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 2605 |
|
Invalid password Test |
