1 |
|
Firebird API Test Suite |
2 |
< |
Copyright MWA Software 2016 |
2 |
> |
Copyright MWA Software 2016-2021 |
3 |
|
|
4 |
|
Starting Tests |
5 |
|
Client API Version = 3.0 |
6 |
+ |
Firebird Environment Variable = /opt/firebird3.0.5 |
7 |
+ |
Firebird Bin Directory = /opt/firebird3.0.5/bin |
8 |
+ |
Firebird Conf Directory = /opt/firebird3.0.5/ |
9 |
+ |
Firebird Client Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
10 |
|
Running Test 1: Create and Drop a Database |
11 |
|
Creating a Database with empty parameters |
12 |
< |
Create Database fails (as expected): |
9 |
< |
I/O error during "open O_CREAT" operation for file "" |
12 |
> |
Create Database fails (as expected): Engine Code: 335544344 I/O error during "open O_CREAT" operation for file "" |
13 |
|
-Error while trying to create file |
14 |
|
-No such file or directory |
15 |
|
Creating a Database using an SQL Statement |
16 |
< |
Database ID = 2 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
16 |
> |
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
17 |
|
SQL Dialect = 3 |
18 |
< |
DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb |
18 |
> |
DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb |
19 |
|
DB Charset ID = 0 |
20 |
|
DB SQL Dialect = 3 |
21 |
< |
DB Remote Protocol = |
21 |
> |
DB Remote Protocol = TCPv4 |
22 |
|
DB ODS Major Version = 12 |
23 |
|
DB ODS Minor Version = 0 |
24 |
< |
User Authentication Method = User name in DPB |
24 |
> |
User Authentication Method = Srp |
25 |
|
Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
26 |
|
DB Client Implementation Version = 3.0 |
27 |
< |
DPB |
28 |
< |
Count = 3 |
29 |
< |
28 = SYSDBA |
30 |
< |
29 = masterkey |
31 |
< |
65 = 3 |
27 |
> |
DPB: Item Count = 3 |
28 |
> |
isc_dpb_user_name = SYSDBA |
29 |
> |
isc_dpb_password = masterkey |
30 |
> |
isc_dpb_set_db_sql_dialect = 3 |
31 |
> |
|
32 |
> |
Firebird Server Version Info |
33 |
> |
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0" |
34 |
> |
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C" |
35 |
> |
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.5.33220 Firebird 3.0/tcp (zeus)/P15:C" |
36 |
> |
on disk structure version 12.0 |
37 |
|
|
38 |
|
Dropping Database |
39 |
|
Creating a Database with a DPD |
40 |
< |
DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb |
40 |
> |
DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb |
41 |
|
DB Charset ID = 4 |
42 |
|
DB SQL Dialect = 3 |
43 |
< |
DB Remote Protocol = |
43 |
> |
DB Remote Protocol = TCPv4 |
44 |
|
DB ODS Major Version = 12 |
45 |
|
DB ODS Minor Version = 0 |
46 |
< |
User Authentication Method = User name in DPB |
46 |
> |
User Authentication Method = Srp |
47 |
|
Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
48 |
|
DB Client Implementation Version = 3.0 |
49 |
|
Dropping Database |
50 |
< |
DPB |
51 |
< |
Count = 4 |
52 |
< |
28 = SYSDBA |
53 |
< |
29 = masterkey |
54 |
< |
48 = UTF8 |
47 |
< |
65 = 3 |
50 |
> |
DPB: Item Count = 4 |
51 |
> |
isc_dpb_user_name = SYSDBA |
52 |
> |
isc_dpb_password = masterkey |
53 |
> |
isc_dpb_lc_ctype = UTF8 |
54 |
> |
isc_dpb_set_db_sql_dialect = 3 |
55 |
|
|
56 |
|
Creating a Database with a DPD |
57 |
< |
Database ID = 2 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
57 |
> |
Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus |
58 |
|
ODS major = 12 |
59 |
|
ODS minor = 0 |
60 |
< |
DB Connect String = /tmp/fbintf-testsuite/testsuite1.fdb |
60 |
> |
Attachment ID = 6 |
61 |
> |
DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb |
62 |
|
DB Charset ID = 4 |
63 |
|
DB SQL Dialect = 3 |
64 |
< |
DB Remote Protocol = |
64 |
> |
DB Remote Protocol = TCPv4 |
65 |
|
DB ODS Major Version = 12 |
66 |
|
DB ODS Minor Version = 0 |
67 |
< |
User Authentication Method = User name in DPB |
67 |
> |
User Authentication Method = Srp |
68 |
|
Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
69 |
|
DB Client Implementation Version = 3.0 |
70 |
|
RDB$DESCRIPTION = |
75 |
|
Dropping Database |
76 |
|
|
77 |
|
|
78 |
+ |
------------------------------------------------------ |
79 |
|
Running Test 2: Open the employee database and run a query |
80 |
+ |
Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
81 |
|
Opening inet://localhost/employee |
82 |
|
Database Open, SQL Dialect = 3 |
83 |
+ |
TPB: Item Count = 3 |
84 |
+ |
isc_tpb_read |
85 |
+ |
isc_tpb_nowait |
86 |
+ |
isc_tpb_concurrency |
87 |
+ |
|
88 |
|
Metadata |
89 |
|
SQLType =SQL_SHORT |
90 |
|
sub type = 0 |
229 |
|
FIRST_NAME = Robert |
230 |
|
LAST_NAME = Nelson |
231 |
|
PHONE_EXT = 250 |
232 |
< |
HIRE_DATE = 28/12/1988 00:00:00.000 |
232 |
> |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
233 |
|
DEPT_NO = 600 |
234 |
|
JOB_CODE = VP |
235 |
|
JOB_GRADE = 2 |
240 |
|
FIRST_NAME = Bruce |
241 |
|
LAST_NAME = Young |
242 |
|
PHONE_EXT = 233 |
243 |
< |
HIRE_DATE = 28/12/1988 00:00:00.000 |
243 |
> |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
244 |
|
DEPT_NO = 621 |
245 |
|
JOB_CODE = Eng |
246 |
|
JOB_GRADE = 2 |
251 |
|
FIRST_NAME = Kim |
252 |
|
LAST_NAME = Lambert |
253 |
|
PHONE_EXT = 22 |
254 |
< |
HIRE_DATE = 6/2/1989 00:00:00.000 |
254 |
> |
HIRE_DATE = 1989/02/06 00:00:00.0000 |
255 |
|
DEPT_NO = 130 |
256 |
|
JOB_CODE = Eng |
257 |
|
JOB_GRADE = 2 |
268 |
|
Charset id = 0 |
269 |
|
Not Null |
270 |
|
Size = 2 |
271 |
+ |
Value = 0 |
272 |
|
|
273 |
|
EMP_NO = 8 |
274 |
|
FIRST_NAME = Leslie |
275 |
|
LAST_NAME = Johnson |
276 |
|
PHONE_EXT = 410 |
277 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
277 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
278 |
|
DEPT_NO = 180 |
279 |
|
JOB_CODE = Mktg |
280 |
|
JOB_GRADE = 3 |
292 |
|
Charset id = 0 |
293 |
|
Not Null |
294 |
|
Size = 2 |
295 |
+ |
Value = 0 |
296 |
|
|
297 |
+ |
Results for Cursor: Test Cursor |
298 |
|
EMP_NO = 8 |
299 |
|
FIRST_NAME = Leslie |
300 |
|
LAST_NAME = Johnson |
301 |
|
PHONE_EXT = 410 |
302 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
302 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
303 |
|
DEPT_NO = 180 |
304 |
|
JOB_CODE = Mktg |
305 |
|
JOB_GRADE = 3 |
307 |
|
SALARY = 64,635.00 |
308 |
|
FULL_NAME = Johnson, Leslie |
309 |
|
|
310 |
+ |
Scollable Cursors |
311 |
+ |
DB Connect String = inet://localhost/employee |
312 |
+ |
DB Charset ID = 4 |
313 |
+ |
DB SQL Dialect = 3 |
314 |
+ |
DB Remote Protocol = TCPv4 |
315 |
+ |
DB ODS Major Version = 12 |
316 |
+ |
DB ODS Minor Version = 0 |
317 |
+ |
User Authentication Method = Srp |
318 |
+ |
Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
319 |
+ |
DB Client Implementation Version = 3.0 |
320 |
+ |
Do Fetch Next: |
321 |
+ |
EMP_NO = 2 |
322 |
+ |
FIRST_NAME = Robert |
323 |
+ |
LAST_NAME = Nelson |
324 |
+ |
PHONE_EXT = 250 |
325 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
326 |
+ |
DEPT_NO = 600 |
327 |
+ |
JOB_CODE = VP |
328 |
+ |
JOB_GRADE = 2 |
329 |
+ |
JOB_COUNTRY = USA |
330 |
+ |
SALARY = 105,900.00 |
331 |
+ |
FULL_NAME = Nelson, Robert |
332 |
+ |
Do Fetch Last: |
333 |
+ |
Remote Scrollable cursors test fails Engine Code: 335544378 feature is not supported |
334 |
+ |
Now open the employee database as a local database |
335 |
+ |
TPB: Item Count = 3 |
336 |
+ |
isc_tpb_read |
337 |
+ |
isc_tpb_nowait |
338 |
+ |
isc_tpb_concurrency |
339 |
+ |
|
340 |
+ |
Metadata |
341 |
+ |
SQLType =SQL_SHORT |
342 |
+ |
sub type = 0 |
343 |
+ |
Table = EMPLOYEE |
344 |
+ |
Owner = SYSDBA |
345 |
+ |
Column Name = EMP_NO |
346 |
+ |
Alias Name = EMP_NO |
347 |
+ |
Field Name = EMP_NO |
348 |
+ |
Scale = 0 |
349 |
+ |
Charset id = 0 |
350 |
+ |
Not Null |
351 |
+ |
Size = 2 |
352 |
+ |
|
353 |
+ |
SQLType =SQL_VARYING |
354 |
+ |
sub type = 0 |
355 |
+ |
Table = EMPLOYEE |
356 |
+ |
Owner = SYSDBA |
357 |
+ |
Column Name = FIRST_NAME |
358 |
+ |
Alias Name = FIRST_NAME |
359 |
+ |
Field Name = FIRST_NAME |
360 |
+ |
Scale = 0 |
361 |
+ |
Charset id = 0 |
362 |
+ |
Not Null |
363 |
+ |
Size = 15 |
364 |
+ |
|
365 |
+ |
SQLType =SQL_VARYING |
366 |
+ |
sub type = 0 |
367 |
+ |
Table = EMPLOYEE |
368 |
+ |
Owner = SYSDBA |
369 |
+ |
Column Name = LAST_NAME |
370 |
+ |
Alias Name = LAST_NAME |
371 |
+ |
Field Name = LAST_NAME |
372 |
+ |
Scale = 0 |
373 |
+ |
Charset id = 0 |
374 |
+ |
Not Null |
375 |
+ |
Size = 20 |
376 |
+ |
|
377 |
+ |
SQLType =SQL_VARYING |
378 |
+ |
sub type = 0 |
379 |
+ |
Table = EMPLOYEE |
380 |
+ |
Owner = SYSDBA |
381 |
+ |
Column Name = PHONE_EXT |
382 |
+ |
Alias Name = PHONE_EXT |
383 |
+ |
Field Name = PHONE_EXT |
384 |
+ |
Scale = 0 |
385 |
+ |
Charset id = 0 |
386 |
+ |
Nullable |
387 |
+ |
Size = 4 |
388 |
+ |
|
389 |
+ |
SQLType =SQL_TIMESTAMP |
390 |
+ |
sub type = 0 |
391 |
+ |
Table = EMPLOYEE |
392 |
+ |
Owner = SYSDBA |
393 |
+ |
Column Name = HIRE_DATE |
394 |
+ |
Alias Name = HIRE_DATE |
395 |
+ |
Field Name = HIRE_DATE |
396 |
+ |
Scale = 0 |
397 |
+ |
Charset id = 0 |
398 |
+ |
Not Null |
399 |
+ |
Size = 8 |
400 |
+ |
|
401 |
+ |
SQLType =SQL_TEXT |
402 |
+ |
sub type = 0 |
403 |
+ |
Table = EMPLOYEE |
404 |
+ |
Owner = SYSDBA |
405 |
+ |
Column Name = DEPT_NO |
406 |
+ |
Alias Name = DEPT_NO |
407 |
+ |
Field Name = DEPT_NO |
408 |
+ |
Scale = 0 |
409 |
+ |
Charset id = 0 |
410 |
+ |
Not Null |
411 |
+ |
Size = 3 |
412 |
+ |
|
413 |
+ |
SQLType =SQL_VARYING |
414 |
+ |
sub type = 0 |
415 |
+ |
Table = EMPLOYEE |
416 |
+ |
Owner = SYSDBA |
417 |
+ |
Column Name = JOB_CODE |
418 |
+ |
Alias Name = JOB_CODE |
419 |
+ |
Field Name = JOB_CODE |
420 |
+ |
Scale = 0 |
421 |
+ |
Charset id = 0 |
422 |
+ |
Not Null |
423 |
+ |
Size = 5 |
424 |
+ |
|
425 |
+ |
SQLType =SQL_SHORT |
426 |
+ |
sub type = 0 |
427 |
+ |
Table = EMPLOYEE |
428 |
+ |
Owner = SYSDBA |
429 |
+ |
Column Name = JOB_GRADE |
430 |
+ |
Alias Name = JOB_GRADE |
431 |
+ |
Field Name = JOB_GRADE |
432 |
+ |
Scale = 0 |
433 |
+ |
Charset id = 0 |
434 |
+ |
Not Null |
435 |
+ |
Size = 2 |
436 |
+ |
|
437 |
+ |
SQLType =SQL_VARYING |
438 |
+ |
sub type = 0 |
439 |
+ |
Table = EMPLOYEE |
440 |
+ |
Owner = SYSDBA |
441 |
+ |
Column Name = JOB_COUNTRY |
442 |
+ |
Alias Name = JOB_COUNTRY |
443 |
+ |
Field Name = JOB_COUNTRY |
444 |
+ |
Scale = 0 |
445 |
+ |
Charset id = 0 |
446 |
+ |
Not Null |
447 |
+ |
Size = 15 |
448 |
+ |
|
449 |
+ |
SQLType =SQL_INT64 |
450 |
+ |
sub type = 0 |
451 |
+ |
Table = EMPLOYEE |
452 |
+ |
Owner = SYSDBA |
453 |
+ |
Column Name = SALARY |
454 |
+ |
Alias Name = SALARY |
455 |
+ |
Field Name = SALARY |
456 |
+ |
Scale = -2 |
457 |
+ |
Charset id = 0 |
458 |
+ |
Not Null |
459 |
+ |
Size = 8 |
460 |
+ |
|
461 |
+ |
SQLType =SQL_VARYING |
462 |
+ |
sub type = 0 |
463 |
+ |
Table = EMPLOYEE |
464 |
+ |
Owner = SYSDBA |
465 |
+ |
Column Name = FULL_NAME |
466 |
+ |
Alias Name = FULL_NAME |
467 |
+ |
Field Name = FULL_NAME |
468 |
+ |
Scale = 0 |
469 |
+ |
Charset id = 0 |
470 |
+ |
Nullable |
471 |
+ |
Size = 37 |
472 |
|
|
473 |
+ |
Plan = |
474 |
+ |
Select Expression |
475 |
+ |
-> First N Records |
476 |
+ |
-> Table "EMPLOYEE" Full Scan |
477 |
+ |
-- SQL style inline comment |
478 |
+ |
/* this is a comment */ Select First 3 * from EMPLOYEE |
479 |
|
|
480 |
+ |
EMP_NO = 2 |
481 |
+ |
FIRST_NAME = Robert |
482 |
+ |
LAST_NAME = Nelson |
483 |
+ |
PHONE_EXT = 250 |
484 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
485 |
+ |
DEPT_NO = 600 |
486 |
+ |
JOB_CODE = VP |
487 |
+ |
JOB_GRADE = 2 |
488 |
+ |
JOB_COUNTRY = USA |
489 |
+ |
SALARY = 105,900.00 |
490 |
+ |
FULL_NAME = Nelson, Robert |
491 |
+ |
EMP_NO = 4 |
492 |
+ |
FIRST_NAME = Bruce |
493 |
+ |
LAST_NAME = Young |
494 |
+ |
PHONE_EXT = 233 |
495 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
496 |
+ |
DEPT_NO = 621 |
497 |
+ |
JOB_CODE = Eng |
498 |
+ |
JOB_GRADE = 2 |
499 |
+ |
JOB_COUNTRY = USA |
500 |
+ |
SALARY = 97,500.00 |
501 |
+ |
FULL_NAME = Young, Bruce |
502 |
+ |
EMP_NO = 5 |
503 |
+ |
FIRST_NAME = Kim |
504 |
+ |
LAST_NAME = Lambert |
505 |
+ |
PHONE_EXT = 22 |
506 |
+ |
HIRE_DATE = 1989/02/06 00:00:00.0000 |
507 |
+ |
DEPT_NO = 130 |
508 |
+ |
JOB_CODE = Eng |
509 |
+ |
JOB_GRADE = 2 |
510 |
+ |
JOB_COUNTRY = USA |
511 |
+ |
SALARY = 102,750.00 |
512 |
+ |
FULL_NAME = Lambert, Kim |
513 |
+ |
|
514 |
+ |
Select * from EMPLOYEE Where EMP_NO = ? |
515 |
+ |
SQL Params |
516 |
+ |
SQLType =SQL_SHORT |
517 |
+ |
sub type = 0 |
518 |
+ |
Field Name = |
519 |
+ |
Scale = 0 |
520 |
+ |
Charset id = 0 |
521 |
+ |
Not Null |
522 |
+ |
Size = 2 |
523 |
+ |
Value = 0 |
524 |
+ |
|
525 |
+ |
EMP_NO = 8 |
526 |
+ |
FIRST_NAME = Leslie |
527 |
+ |
LAST_NAME = Johnson |
528 |
+ |
PHONE_EXT = 410 |
529 |
+ |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
530 |
+ |
DEPT_NO = 180 |
531 |
+ |
JOB_CODE = Mktg |
532 |
+ |
JOB_GRADE = 3 |
533 |
+ |
JOB_COUNTRY = USA |
534 |
+ |
SALARY = 64,635.00 |
535 |
+ |
FULL_NAME = Johnson, Leslie |
536 |
+ |
|
537 |
+ |
With param names |
538 |
+ |
Select * from EMPLOYEE Where EMP_NO = :EMP_NO |
539 |
+ |
SQL Params |
540 |
+ |
SQLType =SQL_SHORT |
541 |
+ |
sub type = 0 |
542 |
+ |
Field Name = EMP_NO |
543 |
+ |
Scale = 0 |
544 |
+ |
Charset id = 0 |
545 |
+ |
Not Null |
546 |
+ |
Size = 2 |
547 |
+ |
Value = 0 |
548 |
+ |
|
549 |
+ |
Results for Cursor: Test Cursor |
550 |
+ |
EMP_NO = 8 |
551 |
+ |
FIRST_NAME = Leslie |
552 |
+ |
LAST_NAME = Johnson |
553 |
+ |
PHONE_EXT = 410 |
554 |
+ |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
555 |
+ |
DEPT_NO = 180 |
556 |
+ |
JOB_CODE = Mktg |
557 |
+ |
JOB_GRADE = 3 |
558 |
+ |
JOB_COUNTRY = USA |
559 |
+ |
SALARY = 64,635.00 |
560 |
+ |
FULL_NAME = Johnson, Leslie |
561 |
+ |
|
562 |
+ |
Scollable Cursors |
563 |
+ |
DB Connect String = employee |
564 |
+ |
DB Charset ID = 4 |
565 |
+ |
DB SQL Dialect = 3 |
566 |
+ |
DB Remote Protocol = |
567 |
+ |
DB ODS Major Version = 12 |
568 |
+ |
DB ODS Minor Version = 0 |
569 |
+ |
User Authentication Method = User name in DPB |
570 |
+ |
Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so |
571 |
+ |
DB Client Implementation Version = 3.0 |
572 |
+ |
Do Fetch Next: |
573 |
+ |
EMP_NO = 2 |
574 |
+ |
FIRST_NAME = Robert |
575 |
+ |
LAST_NAME = Nelson |
576 |
+ |
PHONE_EXT = 250 |
577 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
578 |
+ |
DEPT_NO = 600 |
579 |
+ |
JOB_CODE = VP |
580 |
+ |
JOB_GRADE = 2 |
581 |
+ |
JOB_COUNTRY = USA |
582 |
+ |
SALARY = 105,900.00 |
583 |
+ |
FULL_NAME = Nelson, Robert |
584 |
+ |
Do Fetch Last: |
585 |
+ |
EMP_NO = 145 |
586 |
+ |
FIRST_NAME = Mark |
587 |
+ |
LAST_NAME = Guckenheimer |
588 |
+ |
PHONE_EXT = 221 |
589 |
+ |
HIRE_DATE = 1994/05/02 00:00:00.0000 |
590 |
+ |
DEPT_NO = 622 |
591 |
+ |
JOB_CODE = Eng |
592 |
+ |
JOB_GRADE = 5 |
593 |
+ |
JOB_COUNTRY = USA |
594 |
+ |
SALARY = 32,000.00 |
595 |
+ |
FULL_NAME = Guckenheimer, Mark |
596 |
+ |
Do Fetch Prior: |
597 |
+ |
EMP_NO = 144 |
598 |
+ |
FIRST_NAME = John |
599 |
+ |
LAST_NAME = Montgomery |
600 |
+ |
PHONE_EXT = 820 |
601 |
+ |
HIRE_DATE = 1994/03/30 00:00:00.0000 |
602 |
+ |
DEPT_NO = 672 |
603 |
+ |
JOB_CODE = Eng |
604 |
+ |
JOB_GRADE = 5 |
605 |
+ |
JOB_COUNTRY = USA |
606 |
+ |
SALARY = 35,000.00 |
607 |
+ |
FULL_NAME = Montgomery, John |
608 |
+ |
Do Fetch First: |
609 |
+ |
EMP_NO = 2 |
610 |
+ |
FIRST_NAME = Robert |
611 |
+ |
LAST_NAME = Nelson |
612 |
+ |
PHONE_EXT = 250 |
613 |
+ |
HIRE_DATE = 1988/12/28 00:00:00.0000 |
614 |
+ |
DEPT_NO = 600 |
615 |
+ |
JOB_CODE = VP |
616 |
+ |
JOB_GRADE = 2 |
617 |
+ |
JOB_COUNTRY = USA |
618 |
+ |
SALARY = 105,900.00 |
619 |
+ |
FULL_NAME = Nelson, Robert |
620 |
+ |
Do Fetch Abs 8 : |
621 |
+ |
EMP_NO = 14 |
622 |
+ |
FIRST_NAME = Stewart |
623 |
+ |
LAST_NAME = Hall |
624 |
+ |
PHONE_EXT = 227 |
625 |
+ |
HIRE_DATE = 1990/06/04 00:00:00.0000 |
626 |
+ |
DEPT_NO = 900 |
627 |
+ |
JOB_CODE = Finan |
628 |
+ |
JOB_GRADE = 3 |
629 |
+ |
JOB_COUNTRY = USA |
630 |
+ |
SALARY = 69,482.63 |
631 |
+ |
FULL_NAME = Hall, Stewart |
632 |
+ |
Do Fetch Relative -2 : |
633 |
+ |
EMP_NO = 11 |
634 |
+ |
FIRST_NAME = K. J. |
635 |
+ |
LAST_NAME = Weston |
636 |
+ |
PHONE_EXT = 34 |
637 |
+ |
HIRE_DATE = 1990/01/17 00:00:00.0000 |
638 |
+ |
DEPT_NO = 130 |
639 |
+ |
JOB_CODE = SRep |
640 |
+ |
JOB_GRADE = 4 |
641 |
+ |
JOB_COUNTRY = USA |
642 |
+ |
SALARY = 86,292.94 |
643 |
+ |
FULL_NAME = Weston, K. J. |
644 |
+ |
Do Fetch beyond EOF : |
645 |
+ |
Fetch returned false |
646 |
+ |
|
647 |
+ |
|
648 |
+ |
------------------------------------------------------ |
649 |
|
Running Test 3: ad hoc queries |
650 |
|
Opening inet://localhost/employee |
651 |
|
Database Open |
652 |
|
Employee Count = 42 |
653 |
+ |
Transaction ID = 5588 |
654 |
+ |
Transaction is Read/Write |
655 |
+ |
Transaction Database Path = inet://localhost/employee |
656 |
+ |
Transaction ID = 5588 |
657 |
+ |
Oldest Interesting = 5586 |
658 |
+ |
Oldest Action = 5587 |
659 |
+ |
Oldest Snapshot = 5587 |
660 |
+ |
Oldest Interesting = 0 |
661 |
|
Employee Count = 41 |
662 |
|
Employee Count = 42 |
663 |
|
Employee Count = 41 |
667 |
|
"Yanowski" Employee Count = 1 |
668 |
|
|
669 |
|
|
670 |
+ |
------------------------------------------------------ |
671 |
|
Running Test 4: Update, Insert and Delete Queries |
672 |
|
Opening inet://localhost/employee |
673 |
|
Database Open |
680 |
|
FIRST_NAME = Leslie |
681 |
|
LAST_NAME = Johnson |
682 |
|
PHONE_EXT = 410 |
683 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
683 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
684 |
|
DEPT_NO = 180 |
685 |
|
JOB_CODE = Mktg |
686 |
|
JOB_GRADE = 3 |
688 |
|
SALARY = 64,635.00 |
689 |
|
FULL_NAME = Johnson, Leslie |
690 |
|
|
691 |
< |
Current memory = 19693296 |
692 |
< |
Delta memory = 4480 |
693 |
< |
Max memory = 19755408 |
694 |
< |
Elapsed time= 0.001 sec |
691 |
> |
Current memory = 19,694,032 |
692 |
> |
Delta memory = 4,480 |
693 |
> |
Max memory = 19,755,888 |
694 |
> |
Elapsed time= 0.002 sec |
695 |
|
Cpu = 0.000 sec |
696 |
|
Buffers = 2048 |
697 |
|
Reads = 0 |
836 |
|
FIRST_NAME = John |
837 |
|
LAST_NAME = Doe |
838 |
|
PHONE_EXT = |
839 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
839 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
840 |
|
DEPT_NO = 600 |
841 |
|
JOB_CODE = Eng |
842 |
|
JOB_GRADE = 4 |
849 |
|
FIRST_NAME = Major |
850 |
|
LAST_NAME = Major |
851 |
|
PHONE_EXT = |
852 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
852 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
853 |
|
DEPT_NO = 600 |
854 |
|
JOB_CODE = Eng |
855 |
|
JOB_GRADE = 4 |
866 |
|
FIRST_NAME = Jane |
867 |
|
LAST_NAME = Doe |
868 |
|
PHONE_EXT = NULL |
869 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
869 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
870 |
|
DEPT_NO = 600 |
871 |
|
JOB_CODE = Eng |
872 |
|
JOB_GRADE = 4 |
883 |
|
FIRST_NAME = Jayne's |
884 |
|
LAST_NAME = Doe |
885 |
|
PHONE_EXT = NULL |
886 |
< |
HIRE_DATE = 1/4/2015 00:00:00.000 |
886 |
> |
HIRE_DATE = 2015/04/01 00:00:00.0000 |
887 |
|
DEPT_NO = 600 |
888 |
|
JOB_CODE = Eng |
889 |
|
JOB_GRADE = 4 |
897 |
|
FIRST_NAME = Leslie |
898 |
|
LAST_NAME = Johnson |
899 |
|
PHONE_EXT = 410 |
900 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
900 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
901 |
|
DEPT_NO = 180 |
902 |
|
JOB_CODE = Mktg |
903 |
|
JOB_GRADE = 3 |
911 |
|
FIRST_NAME = Leslie |
912 |
|
LAST_NAME = Johnson |
913 |
|
PHONE_EXT = 410 |
914 |
< |
HIRE_DATE = 5/4/1989 00:00:00.000 |
914 |
> |
HIRE_DATE = 1989/04/05 00:00:00.0000 |
915 |
|
DEPT_NO = 180 |
916 |
|
JOB_CODE = Mktg |
917 |
|
JOB_GRADE = 3 |
923 |
|
FIRST_NAME = Phil |
924 |
|
LAST_NAME = Forest |
925 |
|
PHONE_EXT = 229 |
926 |
< |
HIRE_DATE = 17/4/1989 00:00:00.000 |
926 |
> |
HIRE_DATE = 1989/04/17 00:00:00.0000 |
927 |
|
DEPT_NO = 622 |
928 |
|
JOB_CODE = Mngr |
929 |
|
JOB_GRADE = 3 |
937 |
|
FIRST_NAME = Leslie |
938 |
|
LAST_NAME = Johnson |
939 |
|
PHONE_EXT = 410 |
940 |
< |
HIRE_DATE = 31/1/2015 00:00:00.000 |
940 |
> |
HIRE_DATE = 2015/01/31 00:00:00.0000 |
941 |
|
DEPT_NO = 180 |
942 |
|
JOB_CODE = Mktg |
943 |
|
JOB_GRADE = 3 |
947 |
|
|
948 |
|
|
949 |
|
|
950 |
+ |
------------------------------------------------------ |
951 |
|
Running Test 5: Update Returning and Activity Check |
952 |
|
Opening inet://localhost/employee |
953 |
|
Database Open |
959 |
|
FIRST_NAME = Leslie |
960 |
|
LAST_NAME = Johnson |
961 |
|
PHONE_EXT = 410 |
962 |
< |
HIRE_DATE = 31/1/2016 00:00:00.000 |
962 |
> |
HIRE_DATE = 2016/01/31 00:00:00.0000 |
963 |
|
DEPT_NO = 180 |
964 |
|
JOB_CODE = Mktg |
965 |
|
JOB_GRADE = 3 |
981 |
|
Transaction inactive |
982 |
|
|
983 |
|
|
984 |
+ |
------------------------------------------------------ |
985 |
|
Running Test 6: Blob Handling |
986 |
|
Metadata |
987 |
|
SQLType =SQL_TEXT |
1008 |
|
Nullable |
1009 |
|
Size = 2 |
1010 |
|
|
1011 |
< |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1011 |
> |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 4 Codepage = 65001) |
1012 |
|
RDB$CHARACTER_SET_ID = 0 |
1013 |
< |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1013 |
> |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 4 Codepage = 65001) |
1014 |
|
RDB$CHARACTER_SET_ID = 1 |
1015 |
< |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1015 |
> |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 4 Codepage = 65001) |
1016 |
|
RDB$CHARACTER_SET_ID = 2 |
1017 |
< |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1017 |
> |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 4 Codepage = 65001) |
1018 |
|
RDB$CHARACTER_SET_ID = 3 |
1019 |
< |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1019 |
> |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 4 Codepage = 65001) |
1020 |
|
RDB$CHARACTER_SET_ID = 4 |
1021 |
< |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1021 |
> |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 4 Codepage = 65001) |
1022 |
|
RDB$CHARACTER_SET_ID = 5 |
1023 |
< |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1023 |
> |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 4 Codepage = 65001) |
1024 |
|
RDB$CHARACTER_SET_ID = 6 |
1025 |
< |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1025 |
> |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 4 Codepage = 65001) |
1026 |
|
RDB$CHARACTER_SET_ID = 9 |
1027 |
< |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1027 |
> |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 4 Codepage = 65001) |
1028 |
|
RDB$CHARACTER_SET_ID = 10 |
1029 |
< |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1029 |
> |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 4 Codepage = 65001) |
1030 |
|
RDB$CHARACTER_SET_ID = 11 |
1031 |
< |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1031 |
> |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 4 Codepage = 65001) |
1032 |
|
RDB$CHARACTER_SET_ID = 12 |
1033 |
< |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1033 |
> |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 4 Codepage = 65001) |
1034 |
|
RDB$CHARACTER_SET_ID = 13 |
1035 |
< |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1035 |
> |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 4 Codepage = 65001) |
1036 |
|
RDB$CHARACTER_SET_ID = 14 |
1037 |
< |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1037 |
> |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 4 Codepage = 65001) |
1038 |
|
RDB$CHARACTER_SET_ID = 15 |
1039 |
< |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1039 |
> |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 4 Codepage = 65001) |
1040 |
|
RDB$CHARACTER_SET_ID = 16 |
1041 |
< |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1041 |
> |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 4 Codepage = 65001) |
1042 |
|
RDB$CHARACTER_SET_ID = 17 |
1043 |
< |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1043 |
> |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 4 Codepage = 65001) |
1044 |
|
RDB$CHARACTER_SET_ID = 18 |
1045 |
< |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1045 |
> |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 4 Codepage = 65001) |
1046 |
|
RDB$CHARACTER_SET_ID = 19 |
1047 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1047 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 4 Codepage = 65001) |
1048 |
|
RDB$CHARACTER_SET_ID = 21 |
1049 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1049 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 4 Codepage = 65001) |
1050 |
|
RDB$CHARACTER_SET_ID = 22 |
1051 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1051 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 4 Codepage = 65001) |
1052 |
|
RDB$CHARACTER_SET_ID = 23 |
1053 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1053 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 4 Codepage = 65001) |
1054 |
|
RDB$CHARACTER_SET_ID = 34 |
1055 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1055 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 4 Codepage = 65001) |
1056 |
|
RDB$CHARACTER_SET_ID = 35 |
1057 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1057 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 4 Codepage = 65001) |
1058 |
|
RDB$CHARACTER_SET_ID = 36 |
1059 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1059 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 4 Codepage = 65001) |
1060 |
|
RDB$CHARACTER_SET_ID = 37 |
1061 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1061 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 4 Codepage = 65001) |
1062 |
|
RDB$CHARACTER_SET_ID = 38 |
1063 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1063 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 4 Codepage = 65001) |
1064 |
|
RDB$CHARACTER_SET_ID = 39 |
1065 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1065 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 4 Codepage = 65001) |
1066 |
|
RDB$CHARACTER_SET_ID = 40 |
1067 |
< |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1067 |
> |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 4 Codepage = 65001) |
1068 |
|
RDB$CHARACTER_SET_ID = 44 |
1069 |
< |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1069 |
> |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 4 Codepage = 65001) |
1070 |
|
RDB$CHARACTER_SET_ID = 45 |
1071 |
< |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1071 |
> |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 4 Codepage = 65001) |
1072 |
|
RDB$CHARACTER_SET_ID = 46 |
1073 |
< |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1073 |
> |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 4 Codepage = 65001) |
1074 |
|
RDB$CHARACTER_SET_ID = 47 |
1075 |
< |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1075 |
> |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 4 Codepage = 65001) |
1076 |
|
RDB$CHARACTER_SET_ID = 48 |
1077 |
< |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1077 |
> |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 4 Codepage = 65001) |
1078 |
|
RDB$CHARACTER_SET_ID = 49 |
1079 |
< |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1079 |
> |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 4 Codepage = 65001) |
1080 |
|
RDB$CHARACTER_SET_ID = 50 |
1081 |
< |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1081 |
> |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 4 Codepage = 65001) |
1082 |
|
RDB$CHARACTER_SET_ID = 51 |
1083 |
< |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1083 |
> |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 4 Codepage = 65001) |
1084 |
|
RDB$CHARACTER_SET_ID = 52 |
1085 |
< |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1085 |
> |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 4 Codepage = 65001) |
1086 |
|
RDB$CHARACTER_SET_ID = 53 |
1087 |
< |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1087 |
> |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 4 Codepage = 65001) |
1088 |
|
RDB$CHARACTER_SET_ID = 54 |
1089 |
< |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1089 |
> |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 4 Codepage = 65001) |
1090 |
|
RDB$CHARACTER_SET_ID = 55 |
1091 |
< |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1091 |
> |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 4 Codepage = 65001) |
1092 |
|
RDB$CHARACTER_SET_ID = 56 |
1093 |
< |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1093 |
> |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 4 Codepage = 65001) |
1094 |
|
RDB$CHARACTER_SET_ID = 57 |
1095 |
< |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1095 |
> |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 4 Codepage = 65001) |
1096 |
|
RDB$CHARACTER_SET_ID = 58 |
1097 |
< |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1097 |
> |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 4 Codepage = 65001) |
1098 |
|
RDB$CHARACTER_SET_ID = 59 |
1099 |
< |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1099 |
> |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 4 Codepage = 65001) |
1100 |
|
RDB$CHARACTER_SET_ID = 60 |
1101 |
< |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1101 |
> |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 4 Codepage = 65001) |
1102 |
|
RDB$CHARACTER_SET_ID = 63 |
1103 |
< |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1103 |
> |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 4 Codepage = 65001) |
1104 |
|
RDB$CHARACTER_SET_ID = 64 |
1105 |
< |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1105 |
> |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 4 Codepage = 65001) |
1106 |
|
RDB$CHARACTER_SET_ID = 65 |
1107 |
< |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1107 |
> |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 4 Codepage = 65001) |
1108 |
|
RDB$CHARACTER_SET_ID = 66 |
1109 |
< |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1109 |
> |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 4 Codepage = 65001) |
1110 |
|
RDB$CHARACTER_SET_ID = 67 |
1111 |
< |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1111 |
> |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 4 Codepage = 65001) |
1112 |
|
RDB$CHARACTER_SET_ID = 68 |
1113 |
< |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001 Byte Length = 31) |
1113 |
> |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 4 Codepage = 65001) |
1114 |
|
RDB$CHARACTER_SET_ID = 69 |
1115 |
|
|
1116 |
|
Metadata |
1190 |
|
Charset id = 0 |
1191 |
|
Not Null |
1192 |
|
Size = 4 |
1193 |
+ |
Value = 0 |
1194 |
|
|
1195 |
|
SQLType =SQL_VARYING |
1196 |
|
sub type = 0 |
1219 |
|
ROWID = 1 |
1220 |
|
FIXEDPOINT = 20.28 |
1221 |
|
FLOATINGPOINT = 3.14 |
1222 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1222 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1223 |
|
BLOBDATA = NULL |
1224 |
|
|
1225 |
|
SQL Params |
1238 |
|
Charset id = 0 |
1239 |
|
Not Null |
1240 |
|
Size = 4 |
1241 |
+ |
Value = 0 |
1242 |
|
|
1243 |
|
ROWID = 1 |
1244 |
|
FIXEDPOINT = 20.28 |
1245 |
|
FLOATINGPOINT = 3.14 |
1246 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1246 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1247 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
1248 |
|
|
1249 |
|
To be or not to be-that is the question: |
1291 |
|
Charset id = 0 |
1292 |
|
Not Null |
1293 |
|
Size = 4 |
1294 |
+ |
Value = 0 |
1295 |
|
|
1296 |
|
SQLType =SQL_VARYING |
1297 |
|
sub type = 0 |
1320 |
|
ROWID = 1 |
1321 |
|
FIXEDPOINT = 20.28 |
1322 |
|
FLOATINGPOINT = 3.14 |
1323 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1323 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1324 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
1325 |
|
|
1326 |
|
To be or not to be-that is the question: |
1362 |
|
ROWID = 2 |
1363 |
|
FIXEDPOINT = NULL |
1364 |
|
FLOATINGPOINT = NULL |
1365 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
1365 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
1366 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
1367 |
|
|
1368 |
|
To be or not to be-that is the question: |
1487 |
|
Nullable |
1488 |
|
Size = 2 |
1489 |
|
|
1490 |
< |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1490 |
> |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 53 Codepage = 1252) |
1491 |
|
RDB$CHARACTER_SET_ID = 0 |
1492 |
< |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1492 |
> |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 53 Codepage = 1252) |
1493 |
|
RDB$CHARACTER_SET_ID = 1 |
1494 |
< |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1494 |
> |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 53 Codepage = 1252) |
1495 |
|
RDB$CHARACTER_SET_ID = 2 |
1496 |
< |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1496 |
> |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 53 Codepage = 1252) |
1497 |
|
RDB$CHARACTER_SET_ID = 3 |
1498 |
< |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1498 |
> |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 53 Codepage = 1252) |
1499 |
|
RDB$CHARACTER_SET_ID = 4 |
1500 |
< |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1500 |
> |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 53 Codepage = 1252) |
1501 |
|
RDB$CHARACTER_SET_ID = 5 |
1502 |
< |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1502 |
> |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 53 Codepage = 1252) |
1503 |
|
RDB$CHARACTER_SET_ID = 6 |
1504 |
< |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1504 |
> |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 53 Codepage = 1252) |
1505 |
|
RDB$CHARACTER_SET_ID = 9 |
1506 |
< |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1506 |
> |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 53 Codepage = 1252) |
1507 |
|
RDB$CHARACTER_SET_ID = 10 |
1508 |
< |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1508 |
> |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 53 Codepage = 1252) |
1509 |
|
RDB$CHARACTER_SET_ID = 11 |
1510 |
< |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1510 |
> |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 53 Codepage = 1252) |
1511 |
|
RDB$CHARACTER_SET_ID = 12 |
1512 |
< |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1512 |
> |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 53 Codepage = 1252) |
1513 |
|
RDB$CHARACTER_SET_ID = 13 |
1514 |
< |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1514 |
> |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 53 Codepage = 1252) |
1515 |
|
RDB$CHARACTER_SET_ID = 14 |
1516 |
< |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1516 |
> |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 53 Codepage = 1252) |
1517 |
|
RDB$CHARACTER_SET_ID = 15 |
1518 |
< |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1518 |
> |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 53 Codepage = 1252) |
1519 |
|
RDB$CHARACTER_SET_ID = 16 |
1520 |
< |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1520 |
> |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 53 Codepage = 1252) |
1521 |
|
RDB$CHARACTER_SET_ID = 17 |
1522 |
< |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1522 |
> |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 53 Codepage = 1252) |
1523 |
|
RDB$CHARACTER_SET_ID = 18 |
1524 |
< |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1524 |
> |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 53 Codepage = 1252) |
1525 |
|
RDB$CHARACTER_SET_ID = 19 |
1526 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1526 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 53 Codepage = 1252) |
1527 |
|
RDB$CHARACTER_SET_ID = 21 |
1528 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1528 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 53 Codepage = 1252) |
1529 |
|
RDB$CHARACTER_SET_ID = 22 |
1530 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1530 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 53 Codepage = 1252) |
1531 |
|
RDB$CHARACTER_SET_ID = 23 |
1532 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1532 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 53 Codepage = 1252) |
1533 |
|
RDB$CHARACTER_SET_ID = 34 |
1534 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1534 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 53 Codepage = 1252) |
1535 |
|
RDB$CHARACTER_SET_ID = 35 |
1536 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1536 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 53 Codepage = 1252) |
1537 |
|
RDB$CHARACTER_SET_ID = 36 |
1538 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1538 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 53 Codepage = 1252) |
1539 |
|
RDB$CHARACTER_SET_ID = 37 |
1540 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1540 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 53 Codepage = 1252) |
1541 |
|
RDB$CHARACTER_SET_ID = 38 |
1542 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1542 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 53 Codepage = 1252) |
1543 |
|
RDB$CHARACTER_SET_ID = 39 |
1544 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1544 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 53 Codepage = 1252) |
1545 |
|
RDB$CHARACTER_SET_ID = 40 |
1546 |
< |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1546 |
> |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 53 Codepage = 1252) |
1547 |
|
RDB$CHARACTER_SET_ID = 44 |
1548 |
< |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1548 |
> |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 53 Codepage = 1252) |
1549 |
|
RDB$CHARACTER_SET_ID = 45 |
1550 |
< |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1550 |
> |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 53 Codepage = 1252) |
1551 |
|
RDB$CHARACTER_SET_ID = 46 |
1552 |
< |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1552 |
> |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 53 Codepage = 1252) |
1553 |
|
RDB$CHARACTER_SET_ID = 47 |
1554 |
< |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1554 |
> |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 53 Codepage = 1252) |
1555 |
|
RDB$CHARACTER_SET_ID = 48 |
1556 |
< |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1556 |
> |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 53 Codepage = 1252) |
1557 |
|
RDB$CHARACTER_SET_ID = 49 |
1558 |
< |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1558 |
> |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 53 Codepage = 1252) |
1559 |
|
RDB$CHARACTER_SET_ID = 50 |
1560 |
< |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1560 |
> |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 53 Codepage = 1252) |
1561 |
|
RDB$CHARACTER_SET_ID = 51 |
1562 |
< |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1562 |
> |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 53 Codepage = 1252) |
1563 |
|
RDB$CHARACTER_SET_ID = 52 |
1564 |
< |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1564 |
> |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 53 Codepage = 1252) |
1565 |
|
RDB$CHARACTER_SET_ID = 53 |
1566 |
< |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1566 |
> |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 53 Codepage = 1252) |
1567 |
|
RDB$CHARACTER_SET_ID = 54 |
1568 |
< |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1568 |
> |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 53 Codepage = 1252) |
1569 |
|
RDB$CHARACTER_SET_ID = 55 |
1570 |
< |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1570 |
> |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 53 Codepage = 1252) |
1571 |
|
RDB$CHARACTER_SET_ID = 56 |
1572 |
< |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1572 |
> |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 53 Codepage = 1252) |
1573 |
|
RDB$CHARACTER_SET_ID = 57 |
1574 |
< |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1574 |
> |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 53 Codepage = 1252) |
1575 |
|
RDB$CHARACTER_SET_ID = 58 |
1576 |
< |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1576 |
> |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 53 Codepage = 1252) |
1577 |
|
RDB$CHARACTER_SET_ID = 59 |
1578 |
< |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1578 |
> |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 53 Codepage = 1252) |
1579 |
|
RDB$CHARACTER_SET_ID = 60 |
1580 |
< |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1580 |
> |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 53 Codepage = 1252) |
1581 |
|
RDB$CHARACTER_SET_ID = 63 |
1582 |
< |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1582 |
> |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 53 Codepage = 1252) |
1583 |
|
RDB$CHARACTER_SET_ID = 64 |
1584 |
< |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1584 |
> |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 53 Codepage = 1252) |
1585 |
|
RDB$CHARACTER_SET_ID = 65 |
1586 |
< |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1586 |
> |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 53 Codepage = 1252) |
1587 |
|
RDB$CHARACTER_SET_ID = 66 |
1588 |
< |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1588 |
> |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 53 Codepage = 1252) |
1589 |
|
RDB$CHARACTER_SET_ID = 67 |
1590 |
< |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1590 |
> |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 53 Codepage = 1252) |
1591 |
|
RDB$CHARACTER_SET_ID = 68 |
1592 |
< |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252 Byte Length = 31) |
1592 |
> |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 53 Codepage = 1252) |
1593 |
|
RDB$CHARACTER_SET_ID = 69 |
1594 |
|
|
1595 |
|
Metadata |
1669 |
|
Charset id = 0 |
1670 |
|
Not Null |
1671 |
|
Size = 4 |
1672 |
+ |
Value = 0 |
1673 |
|
|
1674 |
|
SQLType =SQL_VARYING |
1675 |
|
sub type = 0 |
1698 |
|
ROWID = 1 |
1699 |
|
FIXEDPOINT = 20.28 |
1700 |
|
FLOATINGPOINT = 3.14 |
1701 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1701 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1702 |
|
BLOBDATA = NULL |
1703 |
|
|
1704 |
|
SQL Params |
1717 |
|
Charset id = 0 |
1718 |
|
Not Null |
1719 |
|
Size = 4 |
1720 |
+ |
Value = 0 |
1721 |
|
|
1722 |
|
ROWID = 1 |
1723 |
|
FIXEDPOINT = 20.28 |
1724 |
|
FLOATINGPOINT = 3.14 |
1725 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1725 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1726 |
|
BLOBDATA (Charset Id = 53 Codepage = 1252) |
1727 |
|
|
1728 |
|
To be or not to be-that is the question: |
1770 |
|
Charset id = 0 |
1771 |
|
Not Null |
1772 |
|
Size = 4 |
1773 |
+ |
Value = 0 |
1774 |
|
|
1775 |
|
SQLType =SQL_VARYING |
1776 |
|
sub type = 0 |
1799 |
|
ROWID = 1 |
1800 |
|
FIXEDPOINT = 20.28 |
1801 |
|
FLOATINGPOINT = 3.14 |
1802 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1802 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1803 |
|
BLOBDATA (Charset Id = 53 Codepage = 1252) |
1804 |
|
|
1805 |
|
To be or not to be-that is the question: |
1841 |
|
ROWID = 2 |
1842 |
|
FIXEDPOINT = NULL |
1843 |
|
FLOATINGPOINT = NULL |
1844 |
< |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252 Byte Length = 15) |
1844 |
> |
TITLE = Blob Test ©€ (Charset Id = 53 Codepage = 1252) |
1845 |
|
BLOBDATA (Charset Id = 53 Codepage = 1252) |
1846 |
|
|
1847 |
|
To be or not to be-that is the question: |
1966 |
|
Nullable |
1967 |
|
Size = 2 |
1968 |
|
|
1969 |
< |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1969 |
> |
RDB$CHARACTER_SET_NAME = NONE (Charset Id = 3 Codepage = 65001) |
1970 |
|
RDB$CHARACTER_SET_ID = 0 |
1971 |
< |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1971 |
> |
RDB$CHARACTER_SET_NAME = OCTETS (Charset Id = 3 Codepage = 65001) |
1972 |
|
RDB$CHARACTER_SET_ID = 1 |
1973 |
< |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1973 |
> |
RDB$CHARACTER_SET_NAME = ASCII (Charset Id = 3 Codepage = 65001) |
1974 |
|
RDB$CHARACTER_SET_ID = 2 |
1975 |
< |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1975 |
> |
RDB$CHARACTER_SET_NAME = UNICODE_FSS (Charset Id = 3 Codepage = 65001) |
1976 |
|
RDB$CHARACTER_SET_ID = 3 |
1977 |
< |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1977 |
> |
RDB$CHARACTER_SET_NAME = UTF8 (Charset Id = 3 Codepage = 65001) |
1978 |
|
RDB$CHARACTER_SET_ID = 4 |
1979 |
< |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1979 |
> |
RDB$CHARACTER_SET_NAME = SJIS_0208 (Charset Id = 3 Codepage = 65001) |
1980 |
|
RDB$CHARACTER_SET_ID = 5 |
1981 |
< |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1981 |
> |
RDB$CHARACTER_SET_NAME = EUCJ_0208 (Charset Id = 3 Codepage = 65001) |
1982 |
|
RDB$CHARACTER_SET_ID = 6 |
1983 |
< |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1983 |
> |
RDB$CHARACTER_SET_NAME = DOS737 (Charset Id = 3 Codepage = 65001) |
1984 |
|
RDB$CHARACTER_SET_ID = 9 |
1985 |
< |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1985 |
> |
RDB$CHARACTER_SET_NAME = DOS437 (Charset Id = 3 Codepage = 65001) |
1986 |
|
RDB$CHARACTER_SET_ID = 10 |
1987 |
< |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1987 |
> |
RDB$CHARACTER_SET_NAME = DOS850 (Charset Id = 3 Codepage = 65001) |
1988 |
|
RDB$CHARACTER_SET_ID = 11 |
1989 |
< |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1989 |
> |
RDB$CHARACTER_SET_NAME = DOS865 (Charset Id = 3 Codepage = 65001) |
1990 |
|
RDB$CHARACTER_SET_ID = 12 |
1991 |
< |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1991 |
> |
RDB$CHARACTER_SET_NAME = DOS860 (Charset Id = 3 Codepage = 65001) |
1992 |
|
RDB$CHARACTER_SET_ID = 13 |
1993 |
< |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1993 |
> |
RDB$CHARACTER_SET_NAME = DOS863 (Charset Id = 3 Codepage = 65001) |
1994 |
|
RDB$CHARACTER_SET_ID = 14 |
1995 |
< |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1995 |
> |
RDB$CHARACTER_SET_NAME = DOS775 (Charset Id = 3 Codepage = 65001) |
1996 |
|
RDB$CHARACTER_SET_ID = 15 |
1997 |
< |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1997 |
> |
RDB$CHARACTER_SET_NAME = DOS858 (Charset Id = 3 Codepage = 65001) |
1998 |
|
RDB$CHARACTER_SET_ID = 16 |
1999 |
< |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
1999 |
> |
RDB$CHARACTER_SET_NAME = DOS862 (Charset Id = 3 Codepage = 65001) |
2000 |
|
RDB$CHARACTER_SET_ID = 17 |
2001 |
< |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2001 |
> |
RDB$CHARACTER_SET_NAME = DOS864 (Charset Id = 3 Codepage = 65001) |
2002 |
|
RDB$CHARACTER_SET_ID = 18 |
2003 |
< |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2003 |
> |
RDB$CHARACTER_SET_NAME = NEXT (Charset Id = 3 Codepage = 65001) |
2004 |
|
RDB$CHARACTER_SET_ID = 19 |
2005 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2005 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_1 (Charset Id = 3 Codepage = 65001) |
2006 |
|
RDB$CHARACTER_SET_ID = 21 |
2007 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2007 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_2 (Charset Id = 3 Codepage = 65001) |
2008 |
|
RDB$CHARACTER_SET_ID = 22 |
2009 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2009 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_3 (Charset Id = 3 Codepage = 65001) |
2010 |
|
RDB$CHARACTER_SET_ID = 23 |
2011 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2011 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_4 (Charset Id = 3 Codepage = 65001) |
2012 |
|
RDB$CHARACTER_SET_ID = 34 |
2013 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2013 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_5 (Charset Id = 3 Codepage = 65001) |
2014 |
|
RDB$CHARACTER_SET_ID = 35 |
2015 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2015 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_6 (Charset Id = 3 Codepage = 65001) |
2016 |
|
RDB$CHARACTER_SET_ID = 36 |
2017 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2017 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_7 (Charset Id = 3 Codepage = 65001) |
2018 |
|
RDB$CHARACTER_SET_ID = 37 |
2019 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2019 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_8 (Charset Id = 3 Codepage = 65001) |
2020 |
|
RDB$CHARACTER_SET_ID = 38 |
2021 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2021 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_9 (Charset Id = 3 Codepage = 65001) |
2022 |
|
RDB$CHARACTER_SET_ID = 39 |
2023 |
< |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2023 |
> |
RDB$CHARACTER_SET_NAME = ISO8859_13 (Charset Id = 3 Codepage = 65001) |
2024 |
|
RDB$CHARACTER_SET_ID = 40 |
2025 |
< |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2025 |
> |
RDB$CHARACTER_SET_NAME = KSC_5601 (Charset Id = 3 Codepage = 65001) |
2026 |
|
RDB$CHARACTER_SET_ID = 44 |
2027 |
< |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2027 |
> |
RDB$CHARACTER_SET_NAME = DOS852 (Charset Id = 3 Codepage = 65001) |
2028 |
|
RDB$CHARACTER_SET_ID = 45 |
2029 |
< |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2029 |
> |
RDB$CHARACTER_SET_NAME = DOS857 (Charset Id = 3 Codepage = 65001) |
2030 |
|
RDB$CHARACTER_SET_ID = 46 |
2031 |
< |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2031 |
> |
RDB$CHARACTER_SET_NAME = DOS861 (Charset Id = 3 Codepage = 65001) |
2032 |
|
RDB$CHARACTER_SET_ID = 47 |
2033 |
< |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2033 |
> |
RDB$CHARACTER_SET_NAME = DOS866 (Charset Id = 3 Codepage = 65001) |
2034 |
|
RDB$CHARACTER_SET_ID = 48 |
2035 |
< |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2035 |
> |
RDB$CHARACTER_SET_NAME = DOS869 (Charset Id = 3 Codepage = 65001) |
2036 |
|
RDB$CHARACTER_SET_ID = 49 |
2037 |
< |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2037 |
> |
RDB$CHARACTER_SET_NAME = CYRL (Charset Id = 3 Codepage = 65001) |
2038 |
|
RDB$CHARACTER_SET_ID = 50 |
2039 |
< |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2039 |
> |
RDB$CHARACTER_SET_NAME = WIN1250 (Charset Id = 3 Codepage = 65001) |
2040 |
|
RDB$CHARACTER_SET_ID = 51 |
2041 |
< |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2041 |
> |
RDB$CHARACTER_SET_NAME = WIN1251 (Charset Id = 3 Codepage = 65001) |
2042 |
|
RDB$CHARACTER_SET_ID = 52 |
2043 |
< |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2043 |
> |
RDB$CHARACTER_SET_NAME = WIN1252 (Charset Id = 3 Codepage = 65001) |
2044 |
|
RDB$CHARACTER_SET_ID = 53 |
2045 |
< |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2045 |
> |
RDB$CHARACTER_SET_NAME = WIN1253 (Charset Id = 3 Codepage = 65001) |
2046 |
|
RDB$CHARACTER_SET_ID = 54 |
2047 |
< |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2047 |
> |
RDB$CHARACTER_SET_NAME = WIN1254 (Charset Id = 3 Codepage = 65001) |
2048 |
|
RDB$CHARACTER_SET_ID = 55 |
2049 |
< |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2049 |
> |
RDB$CHARACTER_SET_NAME = BIG_5 (Charset Id = 3 Codepage = 65001) |
2050 |
|
RDB$CHARACTER_SET_ID = 56 |
2051 |
< |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2051 |
> |
RDB$CHARACTER_SET_NAME = GB_2312 (Charset Id = 3 Codepage = 65001) |
2052 |
|
RDB$CHARACTER_SET_ID = 57 |
2053 |
< |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2053 |
> |
RDB$CHARACTER_SET_NAME = WIN1255 (Charset Id = 3 Codepage = 65001) |
2054 |
|
RDB$CHARACTER_SET_ID = 58 |
2055 |
< |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2055 |
> |
RDB$CHARACTER_SET_NAME = WIN1256 (Charset Id = 3 Codepage = 65001) |
2056 |
|
RDB$CHARACTER_SET_ID = 59 |
2057 |
< |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2057 |
> |
RDB$CHARACTER_SET_NAME = WIN1257 (Charset Id = 3 Codepage = 65001) |
2058 |
|
RDB$CHARACTER_SET_ID = 60 |
2059 |
< |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2059 |
> |
RDB$CHARACTER_SET_NAME = KOI8R (Charset Id = 3 Codepage = 65001) |
2060 |
|
RDB$CHARACTER_SET_ID = 63 |
2061 |
< |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2061 |
> |
RDB$CHARACTER_SET_NAME = KOI8U (Charset Id = 3 Codepage = 65001) |
2062 |
|
RDB$CHARACTER_SET_ID = 64 |
2063 |
< |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2063 |
> |
RDB$CHARACTER_SET_NAME = WIN1258 (Charset Id = 3 Codepage = 65001) |
2064 |
|
RDB$CHARACTER_SET_ID = 65 |
2065 |
< |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2065 |
> |
RDB$CHARACTER_SET_NAME = TIS620 (Charset Id = 3 Codepage = 65001) |
2066 |
|
RDB$CHARACTER_SET_ID = 66 |
2067 |
< |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2067 |
> |
RDB$CHARACTER_SET_NAME = GBK (Charset Id = 3 Codepage = 65001) |
2068 |
|
RDB$CHARACTER_SET_ID = 67 |
2069 |
< |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2069 |
> |
RDB$CHARACTER_SET_NAME = CP943C (Charset Id = 3 Codepage = 65001) |
2070 |
|
RDB$CHARACTER_SET_ID = 68 |
2071 |
< |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001 Byte Length = 31) |
2071 |
> |
RDB$CHARACTER_SET_NAME = GB18030 (Charset Id = 3 Codepage = 65001) |
2072 |
|
RDB$CHARACTER_SET_ID = 69 |
2073 |
|
|
2074 |
|
Metadata |
2148 |
|
Charset id = 0 |
2149 |
|
Not Null |
2150 |
|
Size = 4 |
2151 |
+ |
Value = 0 |
2152 |
|
|
2153 |
|
SQLType =SQL_VARYING |
2154 |
|
sub type = 0 |
2177 |
|
ROWID = 1 |
2178 |
|
FIXEDPOINT = 20.28 |
2179 |
|
FLOATINGPOINT = 3.14 |
2180 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2180 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2181 |
|
BLOBDATA = NULL |
2182 |
|
|
2183 |
|
SQL Params |
2196 |
|
Charset id = 0 |
2197 |
|
Not Null |
2198 |
|
Size = 4 |
2199 |
+ |
Value = 0 |
2200 |
|
|
2201 |
|
ROWID = 1 |
2202 |
|
FIXEDPOINT = 20.28 |
2203 |
|
FLOATINGPOINT = 3.14 |
2204 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2204 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2205 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
2206 |
|
|
2207 |
|
To be or not to be-that is the question: |
2249 |
|
Charset id = 0 |
2250 |
|
Not Null |
2251 |
|
Size = 4 |
2252 |
+ |
Value = 0 |
2253 |
|
|
2254 |
|
SQLType =SQL_VARYING |
2255 |
|
sub type = 0 |
2278 |
|
ROWID = 1 |
2279 |
|
FIXEDPOINT = 20.28 |
2280 |
|
FLOATINGPOINT = 3.14 |
2281 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2281 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2282 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
2283 |
|
|
2284 |
|
To be or not to be-that is the question: |
2320 |
|
ROWID = 2 |
2321 |
|
FIXEDPOINT = NULL |
2322 |
|
FLOATINGPOINT = NULL |
2323 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2323 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2324 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
2325 |
|
|
2326 |
|
To be or not to be-that is the question: |
2422 |
|
|
2423 |
|
|
2424 |
|
|
2425 |
+ |
------------------------------------------------------ |
2426 |
|
Running Test 7: Create and read back an Array |
2427 |
|
Metadata |
2428 |
|
SQLType =SQL_LONG |
2494 |
|
Dimensions = 1 |
2495 |
|
Bounds: (0:16) |
2496 |
|
|
2497 |
+ |
SQLType =SQL_ARRAY |
2498 |
+ |
sub type = 0 |
2499 |
+ |
Table = TESTDATA |
2500 |
+ |
Owner = SYSDBA |
2501 |
+ |
Column Name = MYARRAY2 |
2502 |
+ |
Alias Name = MYARRAY2 |
2503 |
+ |
Field Name = MYARRAY2 |
2504 |
+ |
Scale = 0 |
2505 |
+ |
Charset id = 0 |
2506 |
+ |
Nullable |
2507 |
+ |
Size = 8 |
2508 |
+ |
Array Meta Data: |
2509 |
+ |
SQLType =SQL_TIMESTAMP |
2510 |
+ |
Scale = 0 |
2511 |
+ |
Charset id = 0 |
2512 |
+ |
Size = 8 |
2513 |
+ |
Table = TESTDATA |
2514 |
+ |
Column = MYARRAY2 |
2515 |
+ |
Dimensions = 1 |
2516 |
+ |
Bounds: (0:16) |
2517 |
+ |
|
2518 |
+ |
SQLType =SQL_ARRAY |
2519 |
+ |
sub type = 0 |
2520 |
+ |
Table = TESTDATA |
2521 |
+ |
Owner = SYSDBA |
2522 |
+ |
Column Name = MYARRAY3 |
2523 |
+ |
Alias Name = MYARRAY3 |
2524 |
+ |
Field Name = MYARRAY3 |
2525 |
+ |
Scale = 0 |
2526 |
+ |
Charset id = 0 |
2527 |
+ |
Nullable |
2528 |
+ |
Size = 8 |
2529 |
+ |
Array Meta Data: |
2530 |
+ |
SQLType =SQL_INT64 |
2531 |
+ |
Scale = -2 |
2532 |
+ |
Charset id = 0 |
2533 |
+ |
Size = 8 |
2534 |
+ |
Table = TESTDATA |
2535 |
+ |
Column = MYARRAY3 |
2536 |
+ |
Dimensions = 1 |
2537 |
+ |
Bounds: (0:16) |
2538 |
+ |
|
2539 |
|
SQL Params |
2540 |
|
SQLType =SQL_LONG |
2541 |
|
sub type = 0 |
2544 |
|
Charset id = 0 |
2545 |
|
Not Null |
2546 |
|
Size = 4 |
2547 |
+ |
Value = 0 |
2548 |
|
|
2549 |
|
SQLType =SQL_VARYING |
2550 |
|
sub type = 0 |
2575 |
|
Param Name = DATED |
2576 |
|
Param Name = NOTES |
2577 |
|
ROWID = 1 |
2578 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2579 |
< |
DATED = 1/4/2016 09:30:00.100 |
2580 |
< |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
2578 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2579 |
> |
DATED = 2016/04/01 09:30:00.1000 |
2580 |
> |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) |
2581 |
|
MYARRAY = NULL |
2582 |
+ |
MYARRAY2 = NULL |
2583 |
+ |
MYARRAY3 = NULL |
2584 |
|
|
2585 |
|
SQL Params |
2586 |
|
SQLType =SQL_ARRAY |
2591 |
|
Nullable |
2592 |
|
Size = 8 |
2593 |
|
|
2594 |
+ |
SQL Params |
2595 |
+ |
SQLType =SQL_ARRAY |
2596 |
+ |
sub type = 0 |
2597 |
+ |
Field Name = MYARRAY2 |
2598 |
+ |
Scale = 0 |
2599 |
+ |
Charset id = 0 |
2600 |
+ |
Nullable |
2601 |
+ |
Size = 8 |
2602 |
+ |
|
2603 |
+ |
SQL Params |
2604 |
+ |
SQLType =SQL_ARRAY |
2605 |
+ |
sub type = 0 |
2606 |
+ |
Field Name = MYARRAY3 |
2607 |
+ |
Scale = 0 |
2608 |
+ |
Charset id = 0 |
2609 |
+ |
Nullable |
2610 |
+ |
Size = 8 |
2611 |
+ |
|
2612 |
+ |
Metadata |
2613 |
+ |
SQLType =SQL_LONG |
2614 |
+ |
sub type = 0 |
2615 |
+ |
Table = TESTDATA |
2616 |
+ |
Owner = SYSDBA |
2617 |
+ |
Column Name = ROWID |
2618 |
+ |
Alias Name = ROWID |
2619 |
+ |
Field Name = ROWID |
2620 |
+ |
Scale = 0 |
2621 |
+ |
Charset id = 0 |
2622 |
+ |
Not Null |
2623 |
+ |
Size = 4 |
2624 |
+ |
|
2625 |
+ |
SQLType =SQL_VARYING |
2626 |
+ |
sub type = 0 |
2627 |
+ |
Table = TESTDATA |
2628 |
+ |
Owner = SYSDBA |
2629 |
+ |
Column Name = TITLE |
2630 |
+ |
Alias Name = TITLE |
2631 |
+ |
Field Name = TITLE |
2632 |
+ |
Scale = 0 |
2633 |
+ |
Charset id = 4 |
2634 |
+ |
Nullable |
2635 |
+ |
Size = 128 |
2636 |
+ |
|
2637 |
+ |
SQLType =SQL_TIMESTAMP |
2638 |
+ |
sub type = 0 |
2639 |
+ |
Table = TESTDATA |
2640 |
+ |
Owner = SYSDBA |
2641 |
+ |
Column Name = DATED |
2642 |
+ |
Alias Name = DATED |
2643 |
+ |
Field Name = DATED |
2644 |
+ |
Scale = 0 |
2645 |
+ |
Charset id = 0 |
2646 |
+ |
Nullable |
2647 |
+ |
Size = 8 |
2648 |
+ |
|
2649 |
+ |
SQLType =SQL_VARYING |
2650 |
+ |
sub type = 0 |
2651 |
+ |
Table = TESTDATA |
2652 |
+ |
Owner = SYSDBA |
2653 |
+ |
Column Name = NOTES |
2654 |
+ |
Alias Name = NOTES |
2655 |
+ |
Field Name = NOTES |
2656 |
+ |
Scale = 0 |
2657 |
+ |
Charset id = 4 |
2658 |
+ |
Nullable |
2659 |
+ |
Size = 256 |
2660 |
+ |
|
2661 |
+ |
SQLType =SQL_ARRAY |
2662 |
+ |
sub type = 0 |
2663 |
+ |
Table = TESTDATA |
2664 |
+ |
Owner = SYSDBA |
2665 |
+ |
Column Name = MYARRAY |
2666 |
+ |
Alias Name = MYARRAY |
2667 |
+ |
Field Name = MYARRAY |
2668 |
+ |
Scale = 0 |
2669 |
+ |
Charset id = 0 |
2670 |
+ |
Nullable |
2671 |
+ |
Size = 8 |
2672 |
+ |
Array Meta Data: |
2673 |
+ |
SQLType =SQL_LONG |
2674 |
+ |
Scale = 0 |
2675 |
+ |
Charset id = 0 |
2676 |
+ |
Size = 4 |
2677 |
+ |
Table = TESTDATA |
2678 |
+ |
Column = MYARRAY |
2679 |
+ |
Dimensions = 1 |
2680 |
+ |
Bounds: (0:16) |
2681 |
+ |
|
2682 |
+ |
SQLType =SQL_ARRAY |
2683 |
+ |
sub type = 0 |
2684 |
+ |
Table = TESTDATA |
2685 |
+ |
Owner = SYSDBA |
2686 |
+ |
Column Name = MYARRAY2 |
2687 |
+ |
Alias Name = MYARRAY2 |
2688 |
+ |
Field Name = MYARRAY2 |
2689 |
+ |
Scale = 0 |
2690 |
+ |
Charset id = 0 |
2691 |
+ |
Nullable |
2692 |
+ |
Size = 8 |
2693 |
+ |
Array Meta Data: |
2694 |
+ |
SQLType =SQL_TIMESTAMP |
2695 |
+ |
Scale = 0 |
2696 |
+ |
Charset id = 0 |
2697 |
+ |
Size = 8 |
2698 |
+ |
Table = TESTDATA |
2699 |
+ |
Column = MYARRAY2 |
2700 |
+ |
Dimensions = 1 |
2701 |
+ |
Bounds: (0:16) |
2702 |
+ |
|
2703 |
+ |
SQLType =SQL_ARRAY |
2704 |
+ |
sub type = 0 |
2705 |
+ |
Table = TESTDATA |
2706 |
+ |
Owner = SYSDBA |
2707 |
+ |
Column Name = MYARRAY3 |
2708 |
+ |
Alias Name = MYARRAY3 |
2709 |
+ |
Field Name = MYARRAY3 |
2710 |
+ |
Scale = 0 |
2711 |
+ |
Charset id = 0 |
2712 |
+ |
Nullable |
2713 |
+ |
Size = 8 |
2714 |
+ |
Array Meta Data: |
2715 |
+ |
SQLType =SQL_INT64 |
2716 |
+ |
Scale = -2 |
2717 |
+ |
Charset id = 0 |
2718 |
+ |
Size = 8 |
2719 |
+ |
Table = TESTDATA |
2720 |
+ |
Column = MYARRAY3 |
2721 |
+ |
Dimensions = 1 |
2722 |
+ |
Bounds: (0:16) |
2723 |
+ |
|
2724 |
|
ROWID = 1 |
2725 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2726 |
< |
DATED = 1/4/2016 09:30:00.100 |
2727 |
< |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
2728 |
< |
Array: (0: 100) (1: 99) (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84) |
2725 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2726 |
> |
DATED = 2016/04/01 09:30:00.1000 |
2727 |
> |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) |
2728 |
> |
MYARRAY = Array: (0: 100) (1: 99) (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84) |
2729 |
> |
|
2730 |
> |
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) |
2731 |
> |
|
2732 |
> |
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.46) (16: 4269) |
2733 |
> |
|
2734 |
|
|
2735 |
|
Shrink to 2:10 |
2736 |
|
Array: (2: 98) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) |
2737 |
+ |
|
2738 |
|
Write updated reduced slice |
2739 |
|
Show update array |
2740 |
|
ROWID = 1 |
2741 |
< |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
2742 |
< |
DATED = 1/4/2016 09:30:00.100 |
2743 |
< |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
2744 |
< |
Array: (0: 100) (1: 99) (2: 1000) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84) |
2741 |
> |
TITLE = Blob Test ©€ (Charset Id = 4 Codepage = 65001) |
2742 |
> |
DATED = 2016/04/01 09:30:00.1000 |
2743 |
> |
NOTES = Écoute moi (Charset Id = 4 Codepage = 65001) |
2744 |
> |
MYARRAY = Array: (0: 100) (1: 99) (2: 1000) (3: 97) (4: 96) (5: 95) (6: 94) (7: 93) (8: 92) (9: 91) (10: 90) (11: 89) (12: 88) (13: 87) (14: 86) (15: 85) (16: 84) |
2745 |
> |
|
2746 |
> |
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) |
2747 |
> |
|
2748 |
> |
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.46) (16: 4269) |
2749 |
> |
|
2750 |
|
|
2751 |
|
|
2752 |
|
|
2753 |
+ |
------------------------------------------------------ |
2754 |
|
Running Test 8: Create and read back an Array with 2 dimensions |
2755 |
|
Metadata |
2756 |
|
SQLType =SQL_LONG |
2806 |
|
Charset id = 0 |
2807 |
|
Not Null |
2808 |
|
Size = 4 |
2809 |
+ |
Value = 0 |
2810 |
|
|
2811 |
|
SQLType =SQL_VARYING |
2812 |
|
sub type = 0 |
2817 |
|
Size = 128 |
2818 |
|
|
2819 |
|
ROWID = 1 |
2820 |
< |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8) |
2820 |
> |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001) |
2821 |
|
MYARRAY = NULL |
2822 |
|
|
2823 |
|
ROWID = 1 |
2824 |
< |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001 Byte Length = 8) |
2825 |
< |
Array: (0,-1: A50) (0,0: A51) (0,1: A52) (0,2: A53) (0,3: A54) (0,4: A55) (0,5: A56) (0,6: A57) (0,7: A58) (1,-1: A59) (1,0: A60) (1,1: A61) (1,2: A62) (1,3: A63) (1,4: A64) (1,5: A65) (1,6: A66) (1,7: A67) (2,-1: A68) (2,0: A69) (2,1: A70) (2,2: A71) (2,3: A72) (2,4: A73) (2,5: A74) (2,6: A75) (2,7: A76) (3,-1: A77) (3,0: A78) (3,1: A79) (3,2: A80) (3,3: A81) (3,4: A82) (3,5: A83) (3,6: A84) (3,7: A85) (4,-1: A86) (4,0: A87) (4,1: A88) (4,2: A89) (4,3: A90) (4,4: A91) (4,5: A92) (4,6: A93) (4,7: A94) (5,-1: A95) (5,0: A96) (5,1: A97) (5,2: A98) (5,3: A99) (5,4: A100) (5,5: A101) (5,6: A102) (5,7: A103) (6,-1: A104) (6,0: A105) (6,1: A106) (6,2: A107) (6,3: A108) (6,4: A109) (6,5: A110) (6,6: A111) (6,7: A112) (7,-1: A113) (7,0: A114) (7,1: A115) (7,2: A116) (7,3: A117) (7,4: A118) (7,5: A119) (7,6: A120) (7,7: A121) (8,-1: A122) (8,0: A123) (8,1: A124) (8,2: A125) (8,3: A126) (8,4: A127) (8,5: A128) (8,6: A129) (8,7: A130) (9,-1: A131) (9,0: A132) (9,1: A133) (9,2: A134) (9,3: A135) (9,4: A136) (9,5: A137) (9,6: A138) (9,7: A139) (10,-1: A140) (10,0: A141) (10,1: A142) (10,2: A143) (10,3: A144) (10,4: A145) (10,5: A146) (10,6: A147) (10,7: A148) (11,-1: A149) (11,0: A150) (11,1: A151) (11,2: A152) (11,3: A153) (11,4: A154) (11,5: A155) (11,6: A156) (11,7: A157) (12,-1: A158) (12,0: A159) (12,1: A160) (12,2: A161) (12,3: A162) (12,4: A163) (12,5: A164) (12,6: A165) (12,7: A166) (13,-1: A167) (13,0: A168) (13,1: A169) (13,2: A170) (13,3: A171) (13,4: A172) (13,5: A173) (13,6: A174) (13,7: A175) (14,-1: A176) (14,0: A177) (14,1: A178) (14,2: A179) (14,3: A180) (14,4: A181) (14,5: A182) (14,6: A183) (14,7: A184) (15,-1: A185) (15,0: A186) (15,1: A187) (15,2: A188) (15,3: A189) (15,4: A190) (15,5: A191) (15,6: A192) (15,7: A193) (16,-1: A194) (16,0: A195) (16,1: A196) (16,2: A197) (16,3: A198) (16,4: A199) (16,5: A200) (16,6: A201) (16,7: A202) |
2824 |
> |
TITLE = 2D Array (Charset Id = 4 Codepage = 65001) |
2825 |
> |
MYARRAY = Array: (0,-1: A50) (0,0: A51) (0,1: A52) (0,2: A53) (0,3: A54) (0,4: A55) (0,5: A56) (0,6: A57) (0,7: A58) (1,-1: A59) (1,0: A60) (1,1: A61) (1,2: A62) (1,3: A63) (1,4: A64) (1,5: A65) (1,6: A66) (1,7: A67) (2,-1: A68) (2,0: A69) (2,1: A70) (2,2: A71) (2,3: A72) (2,4: A73) (2,5: A74) (2,6: A75) (2,7: A76) (3,-1: A77) (3,0: A78) (3,1: A79) (3,2: A80) (3,3: A81) (3,4: A82) (3,5: A83) (3,6: A84) (3,7: A85) (4,-1: A86) (4,0: A87) (4,1: A88) (4,2: A89) (4,3: A90) (4,4: A91) (4,5: A92) (4,6: A93) (4,7: A94) (5,-1: A95) (5,0: A96) (5,1: A97) (5,2: A98) (5,3: A99) (5,4: A100) (5,5: A101) (5,6: A102) (5,7: A103) (6,-1: A104) (6,0: A105) (6,1: A106) (6,2: A107) (6,3: A108) (6,4: A109) (6,5: A110) (6,6: A111) (6,7: A112) (7,-1: A113) (7,0: A114) (7,1: A115) (7,2: A116) (7,3: A117) (7,4: A118) (7,5: A119) (7,6: A120) (7,7: A121) (8,-1: A122) (8,0: A123) (8,1: A124) (8,2: A125) (8,3: A126) (8,4: A127) (8,5: A128) (8,6: A129) (8,7: A130) (9,-1: A131) (9,0: A132) (9,1: A133) (9,2: A134) (9,3: A135) (9,4: A136) (9,5: A137) (9,6: A138) (9,7: A139) (10,-1: A140) (10,0: A141) (10,1: A142) (10,2: A143) (10,3: A144) (10,4: A145) (10,5: A146) (10,6: A147) (10,7: A148) (11,-1: A149) (11,0: A150) (11,1: A151) (11,2: A152) (11,3: A153) (11,4: A154) (11,5: A155) (11,6: A156) (11,7: A157) (12,-1: A158) (12,0: A159) (12,1: A160) (12,2: A161) (12,3: A162) (12,4: A163) (12,5: A164) (12,6: A165) (12,7: A166) (13,-1: A167) (13,0: A168) (13,1: A169) (13,2: A170) (13,3: A171) (13,4: A172) (13,5: A173) (13,6: A174) (13,7: A175) (14,-1: A176) (14,0: A177) (14,1: A178) (14,2: A179) (14,3: A180) (14,4: A181) (14,5: A182) (14,6: A183) (14,7: A184) (15,-1: A185) (15,0: A186) (15,1: A187) (15,2: A188) (15,3: A189) (15,4: A190) (15,5: A191) (15,6: A192) (15,7: A193) (16,-1: A194) (16,0: A195) (16,1: A196) (16,2: A197) (16,3: A198) (16,4: A199) (16,5: A200) (16,6: A201) (16,7: A202) |
2826 |
|
|
2827 |
|
|
2828 |
|
|
2829 |
+ |
|
2830 |
+ |
------------------------------------------------------ |
2831 |
|
Running Test 9: Database Information tests |
2832 |
|
Database ID = 4 FB = /opt/firebird3.0.5/examples/empbuild/employee.fdb SN = zeus |
2833 |
|
Pages =307 |
2839 |
|
Page Size = 8192 |
2840 |
|
Version = 1: LI-V6.3.5.33220 Firebird 3.0 |
2841 |
|
Database is Read/Write |
2842 |
< |
Database Created: 9/1/2020 13:13:45 |
2842 |
> |
Database Created: 09/1/2020 13:13:45 |
2843 |
|
Pages Used = 297 |
2844 |
|
Pages Free = 10 |
2845 |
< |
Server Memory = 19195648 |
2845 |
> |
Server Memory = 19196128 |
2846 |
|
Forced Writes = 1 |
2847 |
< |
Max Memory = 19316160 |
2847 |
> |
Max Memory = 19316896 |
2848 |
|
Num Buffers = 2048 |
2849 |
|
Sweep Interval = 20000 |
2850 |
|
Logged in Users: SYSDBA, |
2890 |
|
Page Size = 8192 |
2891 |
|
|
2892 |
|
|
2893 |
+ |
------------------------------------------------------ |
2894 |
|
Running Test 10: Event Handling |
2895 |
|
Call Async Wait |
2896 |
|
Async Wait Called |
2917 |
|
Event Counts: TESTEVENT, Count = 1 |
2918 |
|
|
2919 |
|
|
2920 |
+ |
------------------------------------------------------ |
2921 |
|
Running Test 11: Services API |
2922 |
+ |
SPB: Item Count = 2 |
2923 |
+ |
user_name = SYSDBA |
2924 |
+ |
password = masterkey |
2925 |
+ |
|
2926 |
|
Service Manager Version = 2 |
2927 |
|
Server Version = LI-V3.0.5.33220 Firebird 3.0 |
2928 |
|
Implementation = Firebird/Linux/AMD/Intel/x64 |
2944 |
|
Group ID = 0 |
2945 |
|
|
2946 |
|
|
2947 |
< |
Licence Info: |
2376 |
< |
feature is not supported |
2947 |
> |
Licence Info: Engine Code: 335544378 feature is not supported |
2948 |
|
-feature is not supported |
2949 |
|
|
2950 |
< |
Licence Mask Info: |
2380 |
< |
feature is not supported |
2950 |
> |
Licence Mask Info: Engine Code: 335544378 feature is not supported |
2951 |
|
|
2952 |
|
Capabilities = 6 |
2953 |
|
|
2977 |
|
Database Dropped |
2978 |
|
|
2979 |
|
|
2980 |
+ |
------------------------------------------------------ |
2981 |
|
Running Test 12: Character Sets |
2982 |
|
SQL Params |
2983 |
|
SQLType =SQL_LONG |
2987 |
|
Charset id = 0 |
2988 |
|
Not Null |
2989 |
|
Size = 4 |
2990 |
+ |
Value = 0 |
2991 |
|
|
2992 |
|
SQLType =SQL_VARYING |
2993 |
|
sub type = 0 |
3037 |
|
Nullable |
3038 |
|
Size = 16 |
3039 |
|
|
3040 |
+ |
Show Param Values |
3041 |
+ |
SQL Params |
3042 |
+ |
SQLType =SQL_LONG |
3043 |
+ |
sub type = 0 |
3044 |
+ |
Field Name = ROWID |
3045 |
+ |
Scale = 0 |
3046 |
+ |
Charset id = 0 |
3047 |
+ |
Not Null |
3048 |
+ |
Size = 4 |
3049 |
+ |
Value = 1 |
3050 |
+ |
|
3051 |
+ |
SQLType =SQL_VARYING |
3052 |
+ |
sub type = 0 |
3053 |
+ |
Field Name = TITLE |
3054 |
+ |
Scale = 0 |
3055 |
+ |
Charset id = 4 |
3056 |
+ |
Nullable |
3057 |
+ |
Size = 128 |
3058 |
+ |
Value = Blob Test ©€ |
3059 |
+ |
|
3060 |
+ |
SQLType =SQL_VARYING |
3061 |
+ |
sub type = 0 |
3062 |
+ |
Field Name = NOTES |
3063 |
+ |
Scale = 0 |
3064 |
+ |
Charset id = 4 |
3065 |
+ |
Nullable |
3066 |
+ |
Size = 256 |
3067 |
+ |
Value = Écoute moi |
3068 |
+ |
|
3069 |
+ |
SQLType =SQL_VARYING |
3070 |
+ |
sub type = 1 |
3071 |
+ |
Field Name = BLOBDATA |
3072 |
+ |
Scale = 0 |
3073 |
+ |
Charset id = 4 |
3074 |
+ |
Nullable |
3075 |
+ |
Size = 8192 |
3076 |
+ |
Value = Some German Special Characters like ÖÄÜöäüß |
3077 |
+ |
|
3078 |
+ |
SQLType =SQL_BLOB |
3079 |
+ |
sub type = 1 |
3080 |
+ |
Field Name = BLOBDATA2 |
3081 |
+ |
Scale = 0 |
3082 |
+ |
Charset id = 4 |
3083 |
+ |
Nullable |
3084 |
+ |
Size = 8 |
3085 |
+ |
Value = Some German Special Characters like ÖÄÜöäüß |
3086 |
+ |
|
3087 |
+ |
SQLType =SQL_VARYING |
3088 |
+ |
sub type = 0 |
3089 |
+ |
Field Name = INCLEAR |
3090 |
+ |
Scale = 0 |
3091 |
+ |
Charset id = 1 |
3092 |
+ |
Nullable |
3093 |
+ |
Size = 16 |
3094 |
+ |
Value = &Test |
3095 |
|
|
3096 |
+ |
|
3097 |
+ |
SQLType =SQL_VARYING |
3098 |
+ |
sub type = 0 |
3099 |
+ |
Field Name = FIXEDWIDTH |
3100 |
+ |
Scale = 0 |
3101 |
+ |
Charset id = 4 |
3102 |
+ |
Nullable |
3103 |
+ |
Size = 16 |
3104 |
+ |
Value = É |
3105 |
+ |
|
3106 |
|
Connection Character Set UTF8 |
3107 |
|
ROWID = 1 |
3108 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
3109 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3108 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
3109 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3110 |
|
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) |
3111 |
|
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) |
3112 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3113 |
< |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001 Byte Length = 5) |
3112 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3113 |
> |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001) |
3114 |
|
|
3115 |
|
Connection Character Set NONE |
3116 |
|
ROWID = 1 |
3117 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
3118 |
< |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591 Byte Length = 10) |
3117 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
3118 |
> |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 21 Codepage = 28591) |
3119 |
|
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252) |
3120 |
|
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) |
3121 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3122 |
< |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001 Byte Length = 5) |
3121 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3122 |
> |
FIXEDWIDTH = C3 89 (Charset Id = 4 Codepage = 65001) |
3123 |
|
|
3124 |
|
Connection Character Set WIN1252 |
3125 |
|
ROWID = 1 |
3126 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252 Byte Length = 12) |
3127 |
< |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252 Byte Length = 10) |
3126 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 A9 80 (Charset Id = 53 Codepage = 1252) |
3127 |
> |
NOTES = C9 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 53 Codepage = 1252) |
3128 |
|
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252) |
3129 |
|
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 D6 C4 DC F6 E4 FC DF (Charset Id = 53 Codepage = 1252) |
3130 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3131 |
< |
FIXEDWIDTH = C9 (Charset Id = 53 Codepage = 1252 Byte Length = 4) |
3130 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3131 |
> |
FIXEDWIDTH = C9 (Charset Id = 53 Codepage = 1252) |
3132 |
|
|
3133 |
|
|
3134 |
|
|
3135 |
+ |
------------------------------------------------------ |
3136 |
|
Running Test 13: Transaction over two databases |
3137 |
|
Init Database 1 |
3138 |
|
ROWID = 1 |
3139 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
3140 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3139 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
3140 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3141 |
|
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) |
3142 |
|
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) |
3143 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3143 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3144 |
|
|
3145 |
|
Init Database 2 |
3146 |
|
ROWID = 1 |
3147 |
< |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001 Byte Length = 15) |
3148 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3147 |
> |
TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC (Charset Id = 4 Codepage = 65001) |
3148 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3149 |
|
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) |
3150 |
|
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) |
3151 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3151 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3152 |
|
|
3153 |
|
ROWID = 1 |
3154 |
< |
TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3155 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3154 |
> |
TITLE = 44 61 74 61 62 61 73 65 31 (Charset Id = 4 Codepage = 65001) |
3155 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3156 |
|
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) |
3157 |
|
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) |
3158 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3158 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3159 |
|
|
3160 |
|
ROWID = 1 |
3161 |
< |
TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3162 |
< |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001 Byte Length = 11) |
3161 |
> |
TITLE = 44 61 74 61 62 61 73 65 32 (Charset Id = 4 Codepage = 65001) |
3162 |
> |
NOTES = C3 89 63 6F 75 74 65 20 6D 6F 69 (Charset Id = 4 Codepage = 65001) |
3163 |
|
BLOBDATA = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) |
3164 |
|
BLOBDATA2 = 53 6F 6D 65 20 47 65 72 6D 61 6E 20 53 70 65 63 69 61 6C 20 43 68 61 72 61 63 74 65 72 73 20 6C 69 6B 65 20 C3 96 C3 84 C3 9C C3 B6 C3 A4 C3 BC C3 9F (Charset Id = 4 Codepage = 65001) |
3165 |
< |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535 Byte Length = 7) |
3165 |
> |
INCLEAR = 1 54 65 73 74 D C3 (Charset Id = 1 Codepage = 65535) |
3166 |
|
|
3167 |
|
|
3168 |
|
|
3169 |
+ |
------------------------------------------------------ |
3170 |
|
Running Test 14: Non select procedures |
3171 |
|
Default Character set Name = UTF8 |
3172 |
|
Metadata |
3194 |
|
Size = 128 |
3195 |
|
|
3196 |
|
ROWID = 1 |
3197 |
< |
TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7) |
3197 |
> |
TITLE = Testing (Charset Id = 4 Codepage = 65001) |
3198 |
|
|
3199 |
|
Repeat with a different execute transaction |
3200 |
|
|
3201 |
|
ROWID = 1 |
3202 |
< |
TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7) |
3202 |
> |
TITLE = Testing (Charset Id = 4 Codepage = 65001) |
3203 |
|
|
3204 |
|
Repeat with a original transaction |
3205 |
|
|
3206 |
|
ROWID = 1 |
3207 |
< |
TITLE = Testing (Charset Id = 4 Codepage = 65001 Byte Length = 7) |
3207 |
> |
TITLE = Testing (Charset Id = 4 Codepage = 65001) |
3208 |
|
|
3209 |
|
|
3210 |
+ |
------------------------------------------------------ |
3211 |
|
Running Test 15: Blob Handling and BPBs |
3212 |
|
|
3213 |
|
Testdata |
3214 |
|
|
3215 |
|
ROWID = 1 |
3216 |
< |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3216 |
> |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001) |
3217 |
|
BLOBDATA = (blob), Length = 92514 |
3218 |
|
|
3219 |
+ |
ROWID = 2 |
3220 |
+ |
TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001) |
3221 |
+ |
BLOBDATA = (blob), Length = 13 |
3222 |
+ |
0 9 A C9 63 6F 75 74 65 20 6D 6F 69 |
3223 |
|
|
3224 |
|
Testdata 2 |
3225 |
|
|
3226 |
|
ROWID = 1 |
3227 |
< |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001 Byte Length = 9) |
3227 |
> |
TITLE = Blob Test (Charset Id = 4 Codepage = 65001) |
3228 |
|
BLOBDATA (Charset Id = 4 Codepage = 65001) |
3229 |
|
|
3230 |
|
Écoute moi |
3231 |
|
|
3232 |
|
|
3233 |
|
|
3234 |
+ |
------------------------------------------------------ |
3235 |
|
Running Test 16: Error handling |
3236 |
|
Invalid Database Name Test |
3237 |
< |
Error Handled: |
3237 |
> |
Error Handled: SQLCODE: -902 |
3238 |
> |
Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3239 |
|
I/O error during "open" operation for file "Malformed Name" |
3240 |
|
-Error while trying to open file |
3241 |
|
-No such file or directory |
3242 |
|
Invalid User Name Test |
3243 |
< |
Error Handled: |
3243 |
> |
Error Handled: SQLCODE: -902 |
3244 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3245 |
|
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3246 |
|
Invalid password Test |
3247 |
< |
Error Handled: |
3247 |
> |
Error Handled: SQLCODE: -902 |
3248 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3249 |
|
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3250 |
|
Invalid Prepare SQL Test |
3251 |
< |
Error Handled: |
3251 |
> |
Error Handled: SQLCODE: -206 |
3252 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3253 |
|
Dynamic SQL Error |
3254 |
|
-SQL error code = -206 |
3255 |
|
-Column unknown |
3256 |
|
-UNKNOWN_DATE |
3257 |
|
-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ? |
3258 |
|
Invalid Open Cursor SQL Test |
3259 |
< |
Error Handled: |
3259 |
> |
Error Handled: SQLCODE: -206 |
3260 |
> |
Engine Code: 335544569 Column does not belong to referenced table |
3261 |
|
Dynamic SQL Error |
3262 |
|
-SQL error code = -206 |
3263 |
|
-Column unknown |
3269 |
|
Error Handled: Field "EMP_NO" not found |
3270 |
|
Case sensitive Param SQL Test |
3271 |
|
Error Handled: Field "EMP_NO" not found |
3272 |
+ |
Stale Reference Check |
3273 |
+ |
First test correct usage |
3274 |
+ |
COUNTER = 42 |
3275 |
+ |
|
3276 |
+ |
New Transaction before param set |
3277 |
+ |
Error Handled: This interface is no longer up-to-date |
3278 |
+ |
New Transaction before Open Cursor |
3279 |
+ |
Error Handled: This interface is no longer up-to-date |
3280 |
+ |
Stop Stale Reference Checks |
3281 |
+ |
New Transaction before param set |
3282 |
+ |
COUNTER = 42 |
3283 |
+ |
|
3284 |
+ |
New Transaction before Open Cursor |
3285 |
+ |
COUNTER = 42 |
3286 |
+ |
|
3287 |
|
Invalid Server Name Test |
3288 |
< |
Error Handled: |
3288 |
> |
Error Handled: SQLCODE: -902 |
3289 |
> |
Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3290 |
|
Unable to complete network request to host "unknown". |
3291 |
|
-Failed to locate host machine. |
3292 |
|
-The specified name was not found in the hosts file or Domain Name Services |
3293 |
|
Invalid User Name Test |
3294 |
< |
Error Handled: |
3294 |
> |
Error Handled: SQLCODE: -902 |
3295 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3296 |
|
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3297 |
|
Invalid password Test |
3298 |
< |
Error Handled: |
3298 |
> |
Error Handled: SQLCODE: -902 |
3299 |
> |
Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements |
3300 |
|
Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
3301 |
|
|
3302 |
|
|
3303 |
+ |
------------------------------------------------------ |
3304 |
+ |
Running Test 17: Date/Time tests and Firebird 4 extensions |
3305 |
+ |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0" |
3306 |
+ |
Has Local TZ DB = FALSE |
3307 |
+ |
|
3308 |
+ |
Testdata |
3309 |
+ |
|
3310 |
+ |
Metadata |
3311 |
+ |
SQLType =SQL_LONG |
3312 |
+ |
sub type = 0 |
3313 |
+ |
Table = TESTDATA |
3314 |
+ |
Owner = SYSDBA |
3315 |
+ |
Column Name = ROWID |
3316 |
+ |
Alias Name = ROWID |
3317 |
+ |
Field Name = ROWID |
3318 |
+ |
Scale = 0 |
3319 |
+ |
Charset id = 0 |
3320 |
+ |
Not Null |
3321 |
+ |
Size = 4 |
3322 |
+ |
|
3323 |
+ |
SQLType =SQL_TYPE_DATE |
3324 |
+ |
sub type = 0 |
3325 |
+ |
Table = TESTDATA |
3326 |
+ |
Owner = SYSDBA |
3327 |
+ |
Column Name = DATECOL |
3328 |
+ |
Alias Name = DATECOL |
3329 |
+ |
Field Name = DATECOL |
3330 |
+ |
Scale = 0 |
3331 |
+ |
Charset id = 0 |
3332 |
+ |
Nullable |
3333 |
+ |
Size = 4 |
3334 |
+ |
|
3335 |
+ |
SQLType =SQL_TYPE_TIME |
3336 |
+ |
sub type = 0 |
3337 |
+ |
Table = TESTDATA |
3338 |
+ |
Owner = SYSDBA |
3339 |
+ |
Column Name = TIMECOL |
3340 |
+ |
Alias Name = TIMECOL |
3341 |
+ |
Field Name = TIMECOL |
3342 |
+ |
Scale = 0 |
3343 |
+ |
Charset id = 0 |
3344 |
+ |
Nullable |
3345 |
+ |
Size = 4 |
3346 |
+ |
|
3347 |
+ |
SQLType =SQL_TIMESTAMP |
3348 |
+ |
sub type = 0 |
3349 |
+ |
Table = TESTDATA |
3350 |
+ |
Owner = SYSDBA |
3351 |
+ |
Column Name = TIMESTAMPCOL |
3352 |
+ |
Alias Name = TIMESTAMPCOL |
3353 |
+ |
Field Name = TIMESTAMPCOL |
3354 |
+ |
Scale = 0 |
3355 |
+ |
Charset id = 0 |
3356 |
+ |
Nullable |
3357 |
+ |
Size = 8 |
3358 |
+ |
|
3359 |
+ |
ROWID = 1 |
3360 |
+ |
DATECOL = 2019/04/01 |
3361 |
+ |
TIMECOL = 11:31:05.0001 |
3362 |
+ |
TIMESTAMPCOL = 2016/02/29 22:02:35.0001 |
3363 |
+ |
ROWID = 2 |
3364 |
+ |
DATECOL = 1939/09/03 |
3365 |
+ |
TIMECOL = 15:40:00.0002 |
3366 |
+ |
TIMESTAMPCOL = 1918/11/11 11:11:00.0000 |
3367 |
+ |
ROWID = 3 |
3368 |
+ |
DATECOL = 1066/10/14 |
3369 |
+ |
TIMECOL = 23:59:59.9994 |
3370 |
+ |
TIMESTAMPCOL = 1918/11/11 11:11:00.0000 |
3371 |
+ |
ROWID = 4 |
3372 |
+ |
DATECOL = 1815/06/18 |
3373 |
+ |
TIMECOL = 00:01:40.1115 |
3374 |
+ |
TIMESTAMPCOL = 1945/05/08 22:10:00.0010 |
3375 |
+ |
|
3376 |
+ |
|
3377 |
+ |
Testdata - second pass |
3378 |
+ |
|
3379 |
+ |
1, 01/4/2019, 11:31:05, 29/2/2016 22:02:35 |
3380 |
+ |
2, 03/9/1939, 15:40:00.000, 11/11/1918 11:11:00 |
3381 |
+ |
3, 14/10/1066, 23:59:59.999, 11/11/1918 11:11:00 |
3382 |
+ |
4, 18/6/1815, 00:01:40.112, 08/5/1945 22:10:00 |
3383 |
+ |
Sys Time = 1945, 5, 8, 2, 22, 10, 0, 1 |
3384 |
+ |
Skipping Firebird 4 and later test part |
3385 |
+ |
|
3386 |
+ |
|
3387 |
+ |
------------------------------------------------------ |
3388 |
+ |
Running Test 18: Firebird 4 Decfloat extensions |
3389 |
+ |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0" |
3390 |
+ |
Skipping test for Firebird 4 and later |
3391 |
+ |
|
3392 |
+ |
|
3393 |
+ |
------------------------------------------------------ |
3394 |
+ |
Running Test 19: Batch Update and Insert Queries |
3395 |
+ |
Opening inet://localhost/employee |
3396 |
+ |
Skipping test for Firebird 4 and later |
3397 |
+ |
|
3398 |
+ |
|
3399 |
+ |
------------------------------------------------------ |
3400 |
+ |
Running Test 20: Stress Test IBatch interface |
3401 |
+ |
FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33220 Firebird 3.0" |
3402 |
+ |
Skipping test for Firebird 4 and later |
3403 |
+ |
|
3404 |
+ |
|
3405 |
+ |
------------------------------------------------------ |
3406 |
+ |
Running Test 21: Exercise setting and getting of numeric data types |
3407 |
+ |
1234.567 parsed to 1234567 scale = -3 |
3408 |
+ |
As Float = 1.2345670000000000E+003 |
3409 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
3410 |
+ |
As Float = -7.6543209999999999E+002 |
3411 |
+ |
0.1 parsed to 1 scale = -1 |
3412 |
+ |
As Float = 1.0000000000000001E-001 |
3413 |
+ |
0.01 parsed to 1 scale = -2 |
3414 |
+ |
As Float = 1.0000000000000000E-002 |
3415 |
+ |
+123 parsed to 123 scale = 0 |
3416 |
+ |
As Float = 1.2300000000000000E+002 |
3417 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
3418 |
+ |
As Float = 1.2345600000000001E+308 |
3419 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
3420 |
+ |
As Float = -1.2000000000000000E-002 |
3421 |
+ |
10. parsed to 10 scale = 0 |
3422 |
+ |
As Float = 1.0000000000000000E+001 |
3423 |
+ |
.12 parsed to 12 scale = -2 |
3424 |
+ |
As Float = 1.2000000000000000E-001 |
3425 |
+ |
0.12 parsed to 12 scale = -2 |
3426 |
+ |
As Float = 1.2000000000000000E-001 |
3427 |
+ |
Parsing of 1.2E1.2 failed |
3428 |
+ |
Parsing of 1,000 failed |
3429 |
+ |
Parsing of 1e1e1 failed |
3430 |
+ |
Parsing of 1.2+3 failed |
3431 |
+ |
Validating Numeric Interface - IFBNumeric |
3432 |
+ |
Value from Currency = 9999.1235 |
3433 |
+ |
Raw Value = 99991235 Scale = -4 |
3434 |
+ |
Value from Currency(rescaled) = 9999.12 |
3435 |
+ |
Raw Value = 999912 Scale = -2 |
3436 |
+ |
Value from Double = 9999.12345678 |
3437 |
+ |
Raw Value = 999912345678 Scale = -8 |
3438 |
+ |
Value from Integer = 9223372036854775807 |
3439 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
3440 |
+ |
Value from string = 9223372036854775807 |
3441 |
+ |
Raw Value = 9223372036854775807 Scale = 0 |
3442 |
+ |
Value from string = 9999.12345678 |
3443 |
+ |
Raw Value = 999912345678 Scale = -8 |
3444 |
+ |
Value from string = -0.12 |
3445 |
+ |
Raw Value = -12 Scale = -3 |
3446 |
+ |
Value from BCD = 9999.12345678 |
3447 |
+ |
Raw Value = 999912345678 Scale = -8 |
3448 |
+ |
Value from Raw Data = 9999123.456780 |
3449 |
+ |
Raw Value = 9999123456780 Scale = -6 |
3450 |
+ |
SQL Params |
3451 |
+ |
SQLType =SQL_LONG |
3452 |
+ |
sub type = 0 |
3453 |
+ |
Field Name = |
3454 |
+ |
Scale = 0 |
3455 |
+ |
Charset id = 0 |
3456 |
+ |
Not Null |
3457 |
+ |
Size = 4 |
3458 |
+ |
Value = 0 |
3459 |
+ |
|
3460 |
+ |
SQLType =SQL_LONG |
3461 |
+ |
sub type = 0 |
3462 |
+ |
Field Name = |
3463 |
+ |
Scale = 0 |
3464 |
+ |
Charset id = 0 |
3465 |
+ |
Nullable |
3466 |
+ |
Size = 4 |
3467 |
+ |
|
3468 |
+ |
SQLType =SQL_INT64 |
3469 |
+ |
sub type = 0 |
3470 |
+ |
Field Name = |
3471 |
+ |
Scale = 0 |
3472 |
+ |
Charset id = 0 |
3473 |
+ |
Nullable |
3474 |
+ |
Size = 8 |
3475 |
+ |
|
3476 |
+ |
SQLType =SQL_INT64 |
3477 |
+ |
sub type = 0 |
3478 |
+ |
Field Name = |
3479 |
+ |
Scale = -4 |
3480 |
+ |
Charset id = 0 |
3481 |
+ |
Nullable |
3482 |
+ |
Size = 8 |
3483 |
+ |
|
3484 |
+ |
SQLType =SQL_DOUBLE |
3485 |
+ |
sub type = 0 |
3486 |
+ |
Field Name = |
3487 |
+ |
Scale = 0 |
3488 |
+ |
Charset id = 0 |
3489 |
+ |
Nullable |
3490 |
+ |
Size = 8 |
3491 |
+ |
|
3492 |
+ |
SQLType =SQL_INT64 |
3493 |
+ |
sub type = 0 |
3494 |
+ |
Field Name = |
3495 |
+ |
Scale = -6 |
3496 |
+ |
Charset id = 0 |
3497 |
+ |
Nullable |
3498 |
+ |
Size = 8 |
3499 |
+ |
|
3500 |
+ |
Expected Error - SQLCODE: -303 |
3501 |
+ |
Engine Code: 335544569 Incompatible column/host variable data type |
3502 |
+ |
Dynamic SQL Error |
3503 |
+ |
-SQL error code = -303 |
3504 |
+ |
-conversion error from string "1,000" |
3505 |
+ |
Expected Error - SQLCODE: -303 |
3506 |
+ |
Engine Code: 335544569 Incompatible column/host variable data type |
3507 |
+ |
Dynamic SQL Error |
3508 |
+ |
-SQL error code = -303 |
3509 |
+ |
-conversion error from string "10.0.0" |
3510 |
+ |
Test Numeric Type |
3511 |
+ |
ROWID = 1 |
3512 |
+ |
ITYPE = 101 |
3513 |
+ |
I64TYPE = 9223372036854775807 |
3514 |
+ |
CURRTYPE = 10,000.12340000 |
3515 |
+ |
DTYPE = 9,999.12345678 |
3516 |
+ |
FIXEDPOINT = 1,234,567,890.12345700 |
3517 |
+ |
ROWID = 2 |
3518 |
+ |
ITYPE = -32457 |
3519 |
+ |
I64TYPE = -9223372036854775808 |
3520 |
+ |
CURRTYPE = 1,000,001.12000000 |
3521 |
+ |
DTYPE = 1.7E308 |
3522 |
+ |
FIXEDPOINT = -1,234,567,890.12345700 |
3523 |
+ |
ROWID = 3 |
3524 |
+ |
ITYPE = 0 |
3525 |
+ |
I64TYPE = 0 |
3526 |
+ |
CURRTYPE = .00000000 |
3527 |
+ |
DTYPE = .00000000 |
3528 |
+ |
FIXEDPOINT = .00000000 |
3529 |
+ |
ROWID = 4 |
3530 |
+ |
ITYPE = 1 |
3531 |
+ |
I64TYPE = 10 |
3532 |
+ |
CURRTYPE = .02300000 |
3533 |
+ |
DTYPE = .00110000 |
3534 |
+ |
FIXEDPOINT = 233.45600000 |
3535 |
+ |
ROWID = 7 |
3536 |
+ |
ITYPE = 1 |
3537 |
+ |
I64TYPE = 1234567 |
3538 |
+ |
CURRTYPE = .02300000 |
3539 |
+ |
DTYPE = .00110000 |
3540 |
+ |
FIXEDPOINT = 1,234.25000000 |
3541 |
+ |
|
3542 |
+ |
|
3543 |
+ |
|
3544 |
+ |
------------------------------------------------------ |
3545 |
+ |
Running Test 22: Journalling |
3546 |
+ |
Start Journaling. Session ID = 0 |
3547 |
+ |
1234.567 parsed to 1234567 scale = -3 |
3548 |
+ |
As Float = 1.2345670000000000E+003 |
3549 |
+ |
-765.4321 parsed to -7654321 scale = -4 |
3550 |
+ |
As Float = -7.6543209999999999E+002 |
3551 |
+ |
0.1 parsed to 1 scale = -1 |
3552 |
+ |
As Float = 1.0000000000000001E-001 |
3553 |
+ |
0.01 parsed to 1 scale = -2 |
3554 |
+ |
As Float = 1.0000000000000000E-002 |
3555 |
+ |
+123 parsed to 123 scale = 0 |
3556 |
+ |
As Float = 1.2300000000000000E+002 |
3557 |
+ |
1.23456E308 parsed to 123456 scale = 303 |
3558 |
+ |
As Float = 1.2345600000000001E+308 |
3559 |
+ |
-1.2e-02 parsed to -12 scale = -3 |
3560 |
+ |
As Float = -1.2000000000000000E-002 |
3561 |
+ |
10. parsed to 10 scale = 0 |
3562 |
+ |
As Float = 1.0000000000000000E+001 |
3563 |
+ |
.12 parsed to 12 scale = -2 |
3564 |
+ |
As Float = 1.2000000000000000E-001 |
3565 |
+ |
0.12 parsed to 12 scale = -2 |
3566 |
+ |
As Float = 1.2000000000000000E-001 |
3567 |
+ |
Parsing of 1.2E1.2 failed |
3568 |
+ |
Parsing of 1,000 failed |
3569 |
+ |
Parsing of 1e1e1 failed |
3570 |
+ |
Parsing of 1.2+3 failed |
3571 |
+ |
SQL Params |
3572 |
+ |
SQLType =SQL_LONG |
3573 |
+ |
sub type = 0 |
3574 |
+ |
Field Name = |
3575 |
+ |
Scale = 0 |
3576 |
+ |
Charset id = 0 |
3577 |
+ |
Not Null |
3578 |
+ |
Size = 4 |
3579 |
+ |
Value = 0 |
3580 |
+ |
|
3581 |
+ |
SQLType =SQL_LONG |
3582 |
+ |
sub type = 0 |
3583 |
+ |
Field Name = |
3584 |
+ |
Scale = 0 |
3585 |
+ |
Charset id = 0 |
3586 |
+ |
Nullable |
3587 |
+ |
Size = 4 |
3588 |
+ |
|
3589 |
+ |
SQLType =SQL_INT64 |
3590 |
+ |
sub type = 0 |
3591 |
+ |
Field Name = |
3592 |
+ |
Scale = 0 |
3593 |
+ |
Charset id = 0 |
3594 |
+ |
Nullable |
3595 |
+ |
Size = 8 |
3596 |
+ |
|
3597 |
+ |
SQLType =SQL_INT64 |
3598 |
+ |
sub type = 0 |
3599 |
+ |
Field Name = |
3600 |
+ |
Scale = -4 |
3601 |
+ |
Charset id = 0 |
3602 |
+ |
Nullable |
3603 |
+ |
Size = 8 |
3604 |
+ |
|
3605 |
+ |
SQLType =SQL_DOUBLE |
3606 |
+ |
sub type = 0 |
3607 |
+ |
Field Name = |
3608 |
+ |
Scale = 0 |
3609 |
+ |
Charset id = 0 |
3610 |
+ |
Nullable |
3611 |
+ |
Size = 8 |
3612 |
+ |
|
3613 |
+ |
SQLType =SQL_INT64 |
3614 |
+ |
sub type = 0 |
3615 |
+ |
Field Name = |
3616 |
+ |
Scale = -6 |
3617 |
+ |
Charset id = 0 |
3618 |
+ |
Nullable |
3619 |
+ |
Size = 8 |
3620 |
+ |
|
3621 |
+ |
|
3622 |
+ |
Text Tests |
3623 |
+ |
SQL Params |
3624 |
+ |
SQLType =SQL_LONG |
3625 |
+ |
sub type = 0 |
3626 |
+ |
Field Name = |
3627 |
+ |
Scale = 0 |
3628 |
+ |
Charset id = 0 |
3629 |
+ |
Not Null |
3630 |
+ |
Size = 4 |
3631 |
+ |
Value = 0 |
3632 |
+ |
|
3633 |
+ |
SQLType =SQL_VARYING |
3634 |
+ |
sub type = 0 |
3635 |
+ |
Field Name = |
3636 |
+ |
Scale = 0 |
3637 |
+ |
Charset id = 4 |
3638 |
+ |
Nullable |
3639 |
+ |
Size = 1024 |
3640 |
+ |
|
3641 |
+ |
SQLType =SQL_BLOB |
3642 |
+ |
sub type = 1 |
3643 |
+ |
Field Name = |
3644 |
+ |
Scale = 0 |
3645 |
+ |
Charset id = 4 |
3646 |
+ |
Nullable |
3647 |
+ |
Size = 8 |
3648 |
+ |
|
3649 |
+ |
|
3650 |
+ |
Binary Blob Tests |
3651 |
+ |
|
3652 |
+ |
Array Test |
3653 |
+ |
SQL Params |
3654 |
+ |
SQLType =SQL_LONG |
3655 |
+ |
sub type = 0 |
3656 |
+ |
Field Name = |
3657 |
+ |
Scale = 0 |
3658 |
+ |
Charset id = 0 |
3659 |
+ |
Not Null |
3660 |
+ |
Size = 4 |
3661 |
+ |
Value = 0 |
3662 |
+ |
|
3663 |
+ |
SQLType =SQL_ARRAY |
3664 |
+ |
sub type = 0 |
3665 |
+ |
Field Name = |
3666 |
+ |
Scale = 0 |
3667 |
+ |
Charset id = 0 |
3668 |
+ |
Nullable |
3669 |
+ |
Size = 8 |
3670 |
+ |
|
3671 |
+ |
ROWID = 1 |
3672 |
+ |
ITYPE = 101 |
3673 |
+ |
I64TYPE = 9223372036854775807 |
3674 |
+ |
CURRTYPE = 10,000.12340000 |
3675 |
+ |
DTYPE = 9,999.12345678 |
3676 |
+ |
FIXEDPOINT = 1,234,567,890.12345700 |
3677 |
+ |
STR = NULL |
3678 |
+ |
TEXTBLOB = NULL |
3679 |
+ |
OTHERBLOB = NULL |
3680 |
+ |
MYARRAY = NULL |
3681 |
+ |
ROWID = 2 |
3682 |
+ |
ITYPE = -32457 |
3683 |
+ |
I64TYPE = -9223372036854775808 |
3684 |
+ |
CURRTYPE = 1,000,001.12000000 |
3685 |
+ |
DTYPE = 1.7E308 |
3686 |
+ |
FIXEDPOINT = -1,234,567,890.12345700 |
3687 |
+ |
STR = NULL |
3688 |
+ |
TEXTBLOB = NULL |
3689 |
+ |
OTHERBLOB = NULL |
3690 |
+ |
MYARRAY = NULL |
3691 |
+ |
ROWID = 4 |
3692 |
+ |
ITYPE = 1 |
3693 |
+ |
I64TYPE = 10 |
3694 |
+ |
CURRTYPE = .02300000 |
3695 |
+ |
DTYPE = .00110000 |
3696 |
+ |
FIXEDPOINT = 233.45600000 |
3697 |
+ |
STR = NULL |
3698 |
+ |
TEXTBLOB = NULL |
3699 |
+ |
OTHERBLOB = NULL |
3700 |
+ |
MYARRAY = NULL |
3701 |
+ |
|
3702 |
+ |
Journal Table |
3703 |
+ |
IBX$SESSIONID = 1 |
3704 |
+ |
IBX$TRANSACTIONID = 9 |
3705 |
+ |
IBX$OLDTRANSACTIONID = NULL |
3706 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3707 |
+ |
IBX$CREATED = 2022/01/02 13:51:28.9780 |
3708 |
+ |
IBX$SESSIONID = 1 |
3709 |
+ |
IBX$TRANSACTIONID = 11 |
3710 |
+ |
IBX$OLDTRANSACTIONID = 10 |
3711 |
+ |
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
3712 |
+ |
IBX$CREATED = 2022/01/02 13:51:29.3510 |
3713 |
+ |
|
3714 |
+ |
Journal Entries |
3715 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
3716 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3717 |
+ |
Attachment ID = 6 |
3718 |
+ |
Session ID = 1 |
3719 |
+ |
Transaction ID = 9 |
3720 |
+ |
Transaction Name = "Transaction_29_1" |
3721 |
+ |
TPB: Item Count = 3 |
3722 |
+ |
isc_tpb_write |
3723 |
+ |
isc_tpb_nowait |
3724 |
+ |
isc_tpb_concurrency |
3725 |
+ |
|
3726 |
+ |
Default Completion = TACommit |
3727 |
+ |
|
3728 |
+ |
Journal Entry = jeQuery(Query) |
3729 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3730 |
+ |
Attachment ID = 6 |
3731 |
+ |
Session ID = 1 |
3732 |
+ |
Transaction ID = 9 |
3733 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346) |
3734 |
+ |
|
3735 |
+ |
Journal Entry = jeQuery(Query) |
3736 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3737 |
+ |
Attachment ID = 6 |
3738 |
+ |
Session ID = 1 |
3739 |
+ |
Transaction ID = 9 |
3740 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346) |
3741 |
+ |
|
3742 |
+ |
Journal Entry = jeTransCommitRet(Commit Retaining) |
3743 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3744 |
+ |
Attachment ID = 6 |
3745 |
+ |
Session ID = 1 |
3746 |
+ |
Transaction ID = 10 |
3747 |
+ |
Old TransactionID = 9 |
3748 |
+ |
|
3749 |
+ |
Journal Entry = jeQuery(Query) |
3750 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3751 |
+ |
Attachment ID = 6 |
3752 |
+ |
Session ID = 1 |
3753 |
+ |
Transaction ID = 10 |
3754 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0) |
3755 |
+ |
|
3756 |
+ |
Journal Entry = jeTransRollbackRet(Rollback Retaining) |
3757 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3758 |
+ |
Attachment ID = 6 |
3759 |
+ |
Session ID = 1 |
3760 |
+ |
Transaction ID = 11 |
3761 |
+ |
Old TransactionID = 10 |
3762 |
+ |
|
3763 |
+ |
Journal Entry = jeQuery(Query) |
3764 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3765 |
+ |
Attachment ID = 6 |
3766 |
+ |
Session ID = 1 |
3767 |
+ |
Transaction ID = 11 |
3768 |
+ |
Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456) |
3769 |
+ |
|
3770 |
+ |
Journal Entry = jeTransStart(Transaction Start) |
3771 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3772 |
+ |
Attachment ID = 6 |
3773 |
+ |
Session ID = 1 |
3774 |
+ |
Transaction ID = 12 |
3775 |
+ |
Transaction Name = "Transaction_29_2" |
3776 |
+ |
TPB: Item Count = 3 |
3777 |
+ |
isc_tpb_write |
3778 |
+ |
isc_tpb_nowait |
3779 |
+ |
isc_tpb_concurrency |
3780 |
+ |
|
3781 |
+ |
Default Completion = TARollback |
3782 |
+ |
|
3783 |
+ |
Journal Entry = jeTransCommit(Commit) |
3784 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3785 |
+ |
Attachment ID = 6 |
3786 |
+ |
Session ID = 1 |
3787 |
+ |
Transaction ID = 11 |
3788 |
+ |
|
3789 |
+ |
Journal Entry = jeQuery(Query) |
3790 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3791 |
+ |
Attachment ID = 6 |
3792 |
+ |
Session ID = 1 |
3793 |
+ |
Transaction ID = 12 |
3794 |
+ |
Query = Insert into TestData(RowID, Str, TextBlob) Values(5,'It''s the quick brown fox jumps over the lazy dog','To be or not to be-that is the question: |
3795 |
+ |
Whether ''tis nobler in the mind to suffer |
3796 |
+ |
The slings and arrows of outrageous fortune, |
3797 |
+ |
Or to take arms against a sea of troubles, |
3798 |
+ |
And, by opposing, end them. To die, to sleep- |
3799 |
+ |
No more-and by a sleep to say we end |
3800 |
+ |
The heartache and the thousand natural shocks |
3801 |
+ |
That flesh is heir to-''tis a consummation |
3802 |
+ |
Devoutly to be wished. To die, to sleep- |
3803 |
+ |
To sleep, perchance to dream. Aye, there''s the rub, |
3804 |
+ |
For in that sleep of death what dreams may come, |
3805 |
+ |
When we have shuffled off this mortal coil, |
3806 |
+ |
Must give us pause. There''s the respect |
3807 |
+ |
That makes calamity of so long life. |
3808 |
+ |
For who would bear the whips and scorns of time, |
3809 |
+ |
Th'' oppressor''s wrong, the proud man''s contumely, |
3810 |
+ |
The pangs of despised love, the law’s delay, |
3811 |
+ |
The insolence of office, and the spurns |
3812 |
+ |
That patient merit of the unworthy takes, |
3813 |
+ |
When he himself might his quietus make |
3814 |
+ |
With a bare bodkin? Who would fardels bear, |
3815 |
+ |
To grunt and sweat under a weary life, |
3816 |
+ |
But that the dread of something after death, |
3817 |
+ |
The undiscovered country from whose bourn |
3818 |
+ |
No traveler returns, puzzles the will |
3819 |
+ |
And makes us rather bear those ills we have |
3820 |
+ |
Than fly to others that we know not of? |
3821 |
+ |
Thus conscience does make cowards of us all, |
3822 |
+ |
And thus the native hue of resolution |
3823 |
+ |
Is sicklied o''er with the pale cast of thought, |
3824 |
+ |
And enterprises of great pitch and moment, |
3825 |
+ |
With this regard their currents turn awry, |
3826 |
+ |
And lose the name of action.-Soft you now, |
3827 |
+ |
The fair Ophelia.-Nymph, in thy orisons |
3828 |
+ |
Be all my sins remembered |
3829 |
+ |
') |
3830 |
+ |
|
3831 |
+ |
Journal Entry = jeQuery(Query) |
3832 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3833 |
+ |
Attachment ID = 6 |
3834 |
+ |
Session ID = 1 |
3835 |
+ |
Transaction ID = 12 |
3836 |
+ |
Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0"> |
3837 |
+ |
FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00 |
3838 |
+ |
0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300 |
3839 |
+ |
01000000010000001A01050001000000DA000000 |
3840 |
+ |
</blob> |
3841 |
+ |
) |
3842 |
+ |
|
3843 |
+ |
Journal Entry = jeQuery(Query) |
3844 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3845 |
+ |
Attachment ID = 6 |
3846 |
+ |
Session ID = 1 |
3847 |
+ |
Transaction ID = 12 |
3848 |
+ |
Query = Insert into TestData(RowID,MyArray) Values (7,<array dim = "1" sqltype = "496" length = "4" relation_name = "TESTDATA" column_name = "MYARRAY" scale = "0" bounds="0:16"> |
3849 |
+ |
<elt ix="0">100</elt> |
3850 |
+ |
<elt ix="1">99</elt> |
3851 |
+ |
<elt ix="2">98</elt> |
3852 |
+ |
<elt ix="3">97</elt> |
3853 |
+ |
<elt ix="4">96</elt> |
3854 |
+ |
<elt ix="5">95</elt> |
3855 |
+ |
<elt ix="6">94</elt> |
3856 |
+ |
<elt ix="7">93</elt> |
3857 |
+ |
<elt ix="8">92</elt> |
3858 |
+ |
<elt ix="9">91</elt> |
3859 |
+ |
<elt ix="10">90</elt> |
3860 |
+ |
<elt ix="11">89</elt> |
3861 |
+ |
<elt ix="12">88</elt> |
3862 |
+ |
<elt ix="13">87</elt> |
3863 |
+ |
<elt ix="14">86</elt> |
3864 |
+ |
<elt ix="15">85</elt> |
3865 |
+ |
<elt ix="16">84</elt> |
3866 |
+ |
</array> |
3867 |
+ |
) |
3868 |
+ |
|
3869 |
+ |
Journal Entry = jeTransRollback(Rollback) |
3870 |
+ |
Timestamp = yyyy/mm/dd hh:mm:ss.zzzz |
3871 |
+ |
Attachment ID = 6 |
3872 |
+ |
Session ID = 1 |
3873 |
+ |
Transaction ID = 12 |
3874 |
+ |
|
3875 |
+ |
|
3876 |
+ |
|
3877 |
+ |
------------------------------------------------------ |
3878 |
|
Test Suite Ends |