| 305 |
|
Running Test 4: Update, Insert and Delete Queries |
| 306 |
|
Opening localhost:employee |
| 307 |
|
Database Open |
| 308 |
+ |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.1.32609 Firebird 3.0" |
| 309 |
+ |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.1.32609 Firebird 3.0/tcp (mint18-FB3)/P14:CZ" |
| 310 |
+ |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.1.32609 Firebird 3.0/tcp (mint18-FB3)/P14:CZ" |
| 311 |
+ |
on disk structure version 12.0 |
| 312 |
|
Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0 |
| 313 |
|
EMP_NO = 8 |
| 314 |
|
FIRST_NAME = Leslie |
| 322 |
|
SALARY = 64,635.00 |
| 323 |
|
FULL_NAME = Johnson, Leslie |
| 324 |
|
|
| 325 |
< |
Current memory = 19604216 |
| 325 |
> |
Current memory = 19604200 |
| 326 |
|
Delta memory = 4280 |
| 327 |
< |
Max memory = 19666136 |
| 328 |
< |
Elapsed time= 0.000 sec |
| 327 |
> |
Max memory = 19666120 |
| 328 |
> |
Elapsed time= 0.001 sec |
| 329 |
|
Cpu = 0.000 sec |
| 330 |
|
Buffers = 2048 |
| 331 |
|
Reads = 0 |
| 509 |
|
FULL_NAME = Doe, Jane |
| 510 |
|
|
| 511 |
|
Employee Count = 43 |
| 512 |
+ |
Updating |
| 513 |
+ |
Select Count = 1 InsertCount = 0 UpdateCount = 0 DeleteCount = 0 |
| 514 |
|
Prepare Query again |
| 515 |
|
|
| 516 |
|
EMP_NO = 150 |
| 517 |
< |
FIRST_NAME = Jane |
| 517 |
> |
FIRST_NAME = Jayne's |
| 518 |
|
LAST_NAME = Doe |
| 519 |
|
PHONE_EXT = NULL |
| 520 |
|
HIRE_DATE = 1/4/2015 00:00:00.000 |
| 523 |
|
JOB_GRADE = 4 |
| 524 |
|
JOB_COUNTRY = England |
| 525 |
|
SALARY = 41,000.89 |
| 526 |
< |
FULL_NAME = Doe, Jane |
| 526 |
> |
FULL_NAME = Doe, Jayne's |
| 527 |
|
|
| 528 |
|
Prepare Query again with a different transaction |
| 529 |
|
|
| 2274 |
|
Database Created: 27/9/2016 12:08:46 |
| 2275 |
|
Pages Used = 297 |
| 2276 |
|
Pages Free = 10 |
| 2277 |
< |
Server Memory = 19122464 |
| 2277 |
> |
Server Memory = 19122448 |
| 2278 |
|
Forced Writes = 1 |
| 2279 |
< |
Max Memory = 19242808 |
| 2279 |
> |
Max Memory = 19242792 |
| 2280 |
|
Num Buffers = 2048 |
| 2281 |
|
Sweep Interval = 20000 |
| 2282 |
|
Logged in Users: SYSDBA, |
| 2603 |
|
Error Handled: Transaction is not active |
| 2604 |
|
Invalid Param SQL Type Test |
| 2605 |
|
Error Handled: Field "EMP_NO" not found |
| 2606 |
+ |
Case sensitive Param SQL Test |
| 2607 |
+ |
Error Handled: Field "EMP_NO" not found |
| 2608 |
|
Invalid Server Name Test |
| 2609 |
|
Error Handled: Unable to complete network request to host "unknown". |
| 2610 |
< |
Failed to establish a connection |
| 2610 |
> |
Failed to locate host machine. |
| 2611 |
> |
The specified name was not found in the hosts file or Domain Name Services |
| 2612 |
|
Invalid User Name Test |
| 2613 |
|
Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
| 2614 |
|
Invalid password Test |
