NN | Test name | mode |
6.0.0.1299
|
6.0.0.1295
|
6.0.0.1293
|
6.0.0.1292
|
6.0.0.1290
|
6.0.0.1286
|
6.0.0.1283
|
6.0.0.1282
|
6.0.0.1280
|
6.0.0.1278
|
6.0.0.1277
|
6.0.0.1275
|
6.0.0.1274
|
6.0.0.1273
|
6.0.0.1267
|
6.0.0.1266
|
6.0.0.1265
|
6.0.0.1264
|
6.0.0.1262
|
6.0.0.1261
|
6.0.0.1259
|
6.0.0.1255
|
6.0.0.1247
|
6.0.0.1246
|
6.0.0.1245
|
6.0.0.1244
|
6.0.0.1232
|
6.0.0.1227
|
6.0.0.1226
|
6.0.0.1224
|
6.0.0.1214
|
6.0.0.1212
|
6.0.0.1210
|
6.0.0.1204
|
6.0.0.1203
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Compress Data over the Network |
|
2 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | LIKE doesn't work for computed values (at least in a view) |
|
3 | SS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | LIKE doesn't work for computed values (at least in a view) |
|
4 | CS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | User savepoints are not released on commit |
|
5 | SS | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | User savepoints are not released on commit |
|
6 | CS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Prohibit an ability to issue DML or DDL statements on RDB$ tables |
|
7 | SS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Prohibit an ability to issue DML or DDL statements on RDB$ tables |
|
8 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>) |
|
9 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>) |
|
10 | CS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Gradual slowdown compilation (create, recreate or drop) of views |
|
11 | SS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Gradual slowdown compilation (create, recreate or drop) of views |
|
12 | CS | X | X | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB crashes on attempt to create table with number of fields greater than 5460 |
|
13 | SS | X | X | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | FB crashes on attempt to create table with number of fields greater than 5460 |
|
14 | CS | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Implement SQL standard FORMAT clause for CAST between string types and datetime types [CORE6507] |
|
15 | SS | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Implement SQL standard FORMAT clause for CAST between string types and datetime types [CORE6507] |
|
16 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Data pages of newly gbak restored databases should be marked as "swept" |
|
17 | CS | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired |
|
18 | CS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Lack of proper clean up after failure to initialize shared memory |
|
19 | SS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Lack of proper clean up after failure to initialize shared memory |
|
20 | CS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Non-correlated sub-query is evaluated multiple times if it is based on a VIEW rathe than on appropriate derived table. |
|
21 | SS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Non-correlated sub-query is evaluated multiple times if it is based on a VIEW rathe than on appropriate derived table. |
|
22 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | F | P | F | F | P | P | P | P | P | P | P | P | P | P | P | Improve performance of external (UDR) functions |
|
23 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | F | P | F | P | F | F | F | F | P | P | P | P | P | P | P | P | P | Improve performance of external (UDR) functions |
|
24 | CS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Cardinality estimation should use primary record versions only |
|
25 | SS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Cardinality estimation should use primary record versions only |
|
26 | CS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Strange output from SHOW DEPENDENCIES command on 6.0 |
|
27 | SS | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Strange output from SHOW DEPENDENCIES command on 6.0 |
|
28 | CS | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Test of NESTED PROCEDURES functionality |
|
29 | SS | P | P | P | P | P | P | P | P | F | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Test of NESTED PROCEDURES functionality |
|
30 | CS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Support for NOT SINGULAR when subquery refers to another table |
|
31 | SS | P | P | P | P | P | P | F | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Support for NOT SINGULAR when subquery refers to another table |
NN | Test name | mode | median_ms |
6.0.0.1299
|
6.0.0.1295
|
6.0.0.1293
|
6.0.0.1292
|
6.0.0.1290
|
6.0.0.1286
|
6.0.0.1283
|
6.0.0.1282
|
6.0.0.1280
|
6.0.0.1278
|
6.0.0.1277
|
6.0.0.1275
|
6.0.0.1274
|
6.0.0.1273
|
6.0.0.1267
|
6.0.0.1266
|
6.0.0.1265
|
6.0.0.1264
|
6.0.0.1262
|
6.0.0.1261
|
6.0.0.1259
|
6.0.0.1255
|
6.0.0.1247
|
6.0.0.1246
|
6.0.0.1245
|
6.0.0.1244
|
6.0.0.1232
|
6.0.0.1227
|
6.0.0.1226
|
6.0.0.1224
|
6.0.0.1214
|
6.0.0.1212
|
6.0.0.1210
|
6.0.0.1204
|
6.0.0.1203
|
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 23815 | 23766 | 23611 | 23891 | 23349 | 23253 | 23725 | 24081 | 23546 | 23966 | 23986 | 24133 | 24384 | 23234 | 23964 | 23507 | 24534 | 24293 | 23940 | 24263 | 24837 | 24179 | 23807 | 24615 | 23788 | 24776 | 23840 | 23815 | 23447 | 26924 | 23521 | 23602 | 23718 | 23446 | 23410 | 23622 | Compress Data over the Network |
|
2 | CS | 790 | 864 | 1183 | 772 | 815 | 800 | 779 | 781 | 784 | 799 | 832 | 817 | 830 | 781 | 787 | 780 | 782 | 776 | 814 | 779 | 834 | 776 | 832 | 789 | 823 | 782 | 814 | 790 | 781 | 857 | 837 | 822 | 786 | 769 | 773 | 805 | LIKE doesn't work for computed values (at least in a view) |
|
3 | SS | 536 | 543 | 933 | 516 | 518 | 515 | 536 | 516 | 522 | 713 | 555 | 530 | 517 | 563 | 568 | 541 | 534 | 537 | 532 | 549 | 546 | 556 | 564 | 531 | 730 | 680 | 526 | 535 | 518 | 522 | 527 | 533 | 540 | 520 | 565 | 565 | LIKE doesn't work for computed values (at least in a view) |
|
4 | CS | 792 | 826 | 792 | 799 | 770 | 812 | 773 | 779 | 805 | 782 | 830 | 783 | 815 | 766 | 782 | 828 | 823 | 824 | 788 | 825 | 792 | 808 | 801 | 786 | 825 | 785 | 780 | 773 | 804 | 787 | 786 | 812 | 774 | 775 | 779 | 827 | User savepoints are not released on commit |
|
5 | SS | 533 | 548 | 570 | 524 | 534 | 561 | 546 | 549 | 558 | 516 | 537 | 531 | 530 | 500 | 529 | 523 | 531 | 527 | 534 | 548 | 522 | 514 | 542 | 533 | 527 | 531 | 510 | 538 | 553 | 539 | 545 | 525 | 519 | 518 | 546 | 535 | User savepoints are not released on commit |
|
6 | CS | 11429 | 11013 | 11454 | 11380 | 11329 | 11552 | 11428 | 11454 | 11547 | 11429 | 11385 | 11295 | 11533 | 11094 | 11720 | 11356 | 11764 | 11370 | 11419 | 11715 | 11706 | 11510 | 11647 | 11721 | 11473 | 11454 | 11309 | 11336 | 11370 | 11315 | 11414 | 11507 | 11272 | 11251 | 11707 | 12364 | Prohibit an ability to issue DML or DDL statements on RDB$ tables |
|
7 | SS | 6338 | 6611 | 6573 | 6950 | 6534 | 6257 | 6209 | 6690 | 6338 | 6451 | 6419 | 7459 | 6109 | 6031 | 6209 | 6823 | 6956 | 6561 | 6652 | 6247 | 6287 | 6336 | 7755 | 6740 | 6575 | 6722 | 6235 | 6265 | 6220 | 6233 | 6578 | 6181 | 6165 | 6111 | 6237 | 6277 | Prohibit an ability to issue DML or DDL statements on RDB$ tables |
|
8 | CS | 3049 | 3077 | 3043 | 3050 | 3038 | 3050 | 3043 | 3033 | 3224 | 3057 | 3031 | 3044 | 3043 | 3063 | 3049 | 3055 | 3054 | 3048 | 4217 | 3063 | 3068 | 3044 | 3045 | 3039 | 3055 | 3067 | 3081 | 3044 | 3049 | 3045 | 3043 | 3047 | 3051 | 3033 | 3039 | 3054 | Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>) |
|
9 | SS | 2848 | 2864 | 2861 | 2845 | 2841 | 2850 | 2843 | 2858 | 2847 | 2854 | 2846 | 2850 | 2847 | 2828 | 2863 | 2837 | 2852 | 2867 | 2847 | 2867 | 2840 | 2840 | 2848 | 2876 | 3839 | 2840 | 2840 | 2844 | 2843 | 2848 | 3358 | 2848 | 2885 | 2875 | 2842 | 2853 | Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>) |
|
10 | CS | 572 | 591 | 576 | 618 | 559 | 566 | 564 | 560 | 593 | 568 | 563 | 566 | 593 | 563 | 566 | 581 | 565 | 606 | 635 | 570 | 572 | 575 | 597 | 562 | 596 | 583 | 604 | 562 | 569 | 568 | 569 | 573 | 580 | 585 | 571 | 607 | Gradual slowdown compilation (create, recreate or drop) of views |
|
11 | SS | 375 | 409 | 397 | 371 | 382 | 372 | 391 | 372 | 376 | 393 | 376 | 362 | 375 | 360 | 374 | 391 | 403 | 375 | 378 | 370 | 372 | 372 | 365 | 373 | 362 | 387 | 373 | 373 | 366 | 371 | 395 | 378 | 376 | 389 | 382 | 373 | Gradual slowdown compilation (create, recreate or drop) of views |
|
12 | CS | 48651 | 0 | 0 | 51279 | 48651 | 48411 | 48241 | 48672 | 50590 | 50376 | 50539 | 51402 | 49626 | 48157 | 48331 | 48536 | 48308 | 48054 | 47968 | 48768 | 48684 | 49236 | 48431 | 48145 | 48252 | 48762 | 48315 | 47932 | 48287 | 48216 | 48676 | 49032 | 48561 | 48698 | 48858 | 49027 | FB crashes on attempt to create table with number of fields greater than 5460 |
|
13 | SS | 48084 | 0 | 0 | 49961 | 49276 | 47259 | 47706 | 48742 | 49297 | 52008 | 49585 | 51187 | 49220 | 47141 | 48021 | 48411 | 47623 | 47628 | 47419 | 47872 | 47927 | 49083 | 48315 | 47152 | 47747 | 47961 | 47344 | 49587 | 47924 | 47550 | 48392 | 48084 | 48551 | 48071 | 48377 | 48703 | FB crashes on attempt to create table with number of fields greater than 5460 |
|
14 | CS | 135377 | 134937 | 135636 | 137429 | 138276 | 133864 | 134464 | 136731 | 135539 | 136575 | 137496 | 139265 | 134885 | 132001 | 138908 | 137202 | 138327 | 136124 | 134508 | 135769 | 135377 | 137159 | 134112 | 135382 | 135000 | 134980 | 135003 | 134608 | 135670 | 134069 | 134160 | 134048 | 134549 | 134291 | 134748 | 135480 | Implement SQL standard FORMAT clause for CAST between string types and datetime types [CORE6507] |
|
15 | SS | 136010 | 140819 | 134192 | 136778 | 137082 | 134262 | 135938 | 139454 | 135122 | 136221 | 137259 | 139709 | 134818 | 131640 | 138907 | 137091 | 139056 | 144599 | 135761 | 136268 | 136435 | 136837 | 136078 | 136010 | 135321 | 135535 | 136041 | 148765 | 135718 | 134578 | 135393 | 134405 | 133980 | 134668 | 133487 | 135987 | Implement SQL standard FORMAT clause for CAST between string types and datetime types [CORE6507] |
|
16 | CS | 1535 | 1579 | 1601 | 1543 | 1564 | 1518 | 1548 | 1522 | 1506 | 1528 | 1532 | 1548 | 1500 | 1484 | 1533 | 1493 | 1535 | 1563 | 1539 | 1534 | 2018 | 1515 | 1509 | 1547 | 1537 | 1543 | 1568 | 1522 | 1541 | 1534 | 1570 | 1566 | 1525 | 1568 | 1533 | 1525 | Data pages of newly gbak restored databases should be marked as "swept" |
|
17 | CS | 21645 | 21671 | 21650 | 21645 | 21679 | 21639 | 21632 | 21626 | 21632 | 21643 | 21638 | 21622 | 21639 | 22000 | 21633 | 21998 | 21650 | 21656 | 21645 | 21648 | 21665 | 21656 | 21642 | 21634 | 21672 | 21629 | 21664 | 21629 | 21650 | 21659 | 21645 | 21638 | 21649 | 21630 | 21643 | 21651 | When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired |
|
18 | CS | 3529 | 2636 | 3496 | 3528 | 3713 | 3509 | 3502 | 3519 | 3507 | 3521 | 3522 | 3520 | 3490 | 3469 | 3514 | 3542 | 3540 | 3529 | 3533 | 3538 | 3511 | 3542 | 3551 | 3536 | 3535 | 3527 | 3531 | 3733 | 3558 | 3543 | 3647 | 3521 | 3540 | 3517 | 3530 | 3560 | Lack of proper clean up after failure to initialize shared memory |
|
19 | SS | 1688 | 1774 | 1642 | 1693 | 1887 | 1659 | 1719 | 1662 | 1953 | 1889 | 1871 | 1649 | 1612 | 1625 | 1657 | 1839 | 1687 | 1722 | 1782 | 1655 | 1701 | 1933 | 1836 | 1646 | 1652 | 1688 | 1877 | 1765 | 1627 | 1669 | 1697 | 1655 | 1651 | 1709 | 1639 | 1649 | Lack of proper clean up after failure to initialize shared memory |
|
20 | CS | 694 | 726 | 675 | 666 | 674 | 660 | 693 | 721 | 670 | 666 | 676 | 671 | 664 | 687 | 741 | 730 | 742 | 726 | 726 | 733 | 731 | 764 | 743 | 741 | 725 | 727 | 757 | 676 | 700 | 676 | 668 | 679 | 702 | 694 | 679 | 677 | Non-correlated sub-query is evaluated multiple times if it is based on a VIEW rathe than on appropriate derived table. |
|
21 | SS | 458 | 707 | 440 | 443 | 433 | 453 | 432 | 441 | 464 | 446 | 433 | 428 | 434 | 421 | 484 | 458 | 498 | 463 | 461 | 509 | 460 | 662 | 501 | 497 | 508 | 465 | 661 | 434 | 445 | 474 | 437 | 430 | 477 | 485 | 433 | 446 | Non-correlated sub-query is evaluated multiple times if it is based on a VIEW rathe than on appropriate derived table. |
|
22 | CS | 7682 | 7554 | 7592 | 7476 | 7483 | 7419 | 7587 | 7568 | 7454 | 7682 | 7922 | 7969 | 7942 | 7437 | 8094 | 8178 | 8153 | 8149 | 8204 | 8260 | 8114 | 8241 | 8168 | 8197 | 8245 | 8213 | 8156 | 7497 | 7548 | 7487 | 7432 | 7449 | 7496 | 7468 | 7745 | 7444 | Improve performance of external (UDR) functions |
|
23 | SS | 7373 | 7384 | 7296 | 7323 | 7231 | 7240 | 7238 | 7363 | 7270 | 7295 | 7647 | 7367 | 7194 | 7188 | 7895 | 7883 | 7891 | 7828 | 8340 | 8028 | 7937 | 8264 | 7909 | 8386 | 7925 | 7938 | 8119 | 7536 | 7542 | 7295 | 7238 | 7176 | 7373 | 7269 | 7172 | 7211 | Improve performance of external (UDR) functions |
|
24 | CS | 1084 | 1166 | 1089 | 1060 | 1064 | 1084 | 1066 | 1081 | 1078 | 1071 | 1092 | 1061 | 1066 | 1094 | 1168 | 1152 | 1171 | 1135 | 1156 | 1156 | 1136 | 1149 | 1144 | 1151 | 1152 | 1144 | 1134 | 1063 | 1065 | 1074 | 1066 | 1044 | 1076 | 1056 | 1072 | 1071 | Cardinality estimation should use primary record versions only |
|
25 | SS | 917 | 1189 | 904 | 878 | 874 | 845 | 881 | 885 | 908 | 867 | 862 | 882 | 979 | 844 | 994 | 929 | 992 | 922 | 917 | 976 | 951 | 1118 | 957 | 954 | 938 | 952 | 964 | 914 | 901 | 915 | 944 | 857 | 943 | 939 | 852 | 886 | Cardinality estimation should use primary record versions only |
|
26 | CS | 621 | 634 | 636 | 572 | 582 | 581 | 582 | 581 | 585 | 582 | 587 | 610 | 585 | 593 | 642 | 680 | 673 | 661 | 675 | 669 | 643 | 638 | 660 | 639 | 648 | 691 | 631 | 656 | 608 | 613 | 587 | 629 | 585 | 611 | 609 | 621 | Strange output from SHOW DEPENDENCIES command on 6.0 |
|
27 | SS | 419 | 478 | 398 | 393 | 395 | 393 | 396 | 404 | 414 | 393 | 393 | 393 | 409 | 390 | 438 | 443 | 505 | 423 | 438 | 873 | 428 | 478 | 440 | 470 | 434 | 448 | 408 | 425 | 474 | 437 | 419 | 396 | 376 | 417 | 396 | 676 | Strange output from SHOW DEPENDENCIES command on 6.0 |
|
28 | CS | 1230 | 1225 | 1236 | 1216 | 1237 | 1210 | 1240 | 1196 | 1204 | 1780 | 1607 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Test of NESTED PROCEDURES functionality |
|
29 | SS | 757 | 775 | 753 | 758 | 739 | 756 | 743 | 762 | 728 | 1698 | 1215 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Test of NESTED PROCEDURES functionality |
|
30 | CS | 800 | 846 | 840 | 800 | 794 | 784 | 799 | 1245 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Support for NOT SINGULAR when subquery refers to another table |
|
31 | SS | 587 | 633 | 606 | 584 | 587 | 583 | 580 | 933 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Support for NOT SINGULAR when subquery refers to another table |