| | @@ -325,13 +325,13 @@ |
| 325 | 325 | SELECT F.name, R.rev |
| 326 | 326 | FROM revision R, file F |
| 327 | 327 | WHERE R.rid IN (SELECT rid |
| 328 | 328 | FROM revision -- All revisions |
| 329 | 329 | EXCEPT -- subtract |
| 330 | | - SELECT CR.rid |
| 331 | | - FROM csrevision CR, changeset C -- revisions used |
| 332 | | - WHERE C.cid = CR.cid -- by any revision |
| 330 | + SELECT CI.iid |
| 331 | + FROM csitem CI, changeset C -- revisions used |
| 332 | + WHERE C.cid = CI.cid -- by any revision |
| 333 | 333 | AND C.type = 0) -- changeset |
| 334 | 334 | AND R.fid = F.fid -- get file of unused revision |
| 335 | 335 | } |
| 336 | 336 | # Find all revisions which are used by more than one |
| 337 | 337 | # changeset. |
| | @@ -345,15 +345,15 @@ |
| 345 | 345 | -- select those with more than one user, and get their |
| 346 | 346 | -- associated file (name) for display. |
| 347 | 347 | |
| 348 | 348 | SELECT F.name, R.rev |
| 349 | 349 | FROM revision R, file F, |
| 350 | | - (SELECT CR.rid AS rid, count(CR.cid) AS count |
| 351 | | - FROM csrevision CR, changeset C |
| 350 | + (SELECT CI.iid AS rid, count(CI.cid) AS count |
| 351 | + FROM csitem CI, changeset C |
| 352 | 352 | WHERE C.type = 0 |
| 353 | | - AND C.cid = CR.cid |
| 354 | | - GROUP BY CR.rid) AS U |
| 353 | + AND C.cid = CI.cid |
| 354 | + GROUP BY CI.iid) AS U |
| 355 | 355 | WHERE U.count > 1 |
| 356 | 356 | AND R.rid = U.rid |
| 357 | 357 | AND R.fid = F.fid |
| 358 | 358 | } |
| 359 | 359 | # All revisions have to refer to the same meta information as |
| | @@ -360,14 +360,14 @@ |
| 360 | 360 | # their changeset. |
| 361 | 361 | CheckRevCS \ |
| 362 | 362 | {All revisions have to agree with their changeset about the used meta information} \ |
| 363 | 363 | {disagrees with its changeset @ about the meta information} { |
| 364 | 364 | SELECT CT.name, C.cid, F.name, R.rev |
| 365 | | - FROM changeset C, cstype CT, revision R, file F, csrevision CR |
| 365 | + FROM changeset C, cstype CT, revision R, file F, csitem CI |
| 366 | 366 | WHERE C.type = 0 -- revision changesets only |
| 367 | | - AND C.cid = CR.cid -- changeset --> its revisions |
| 368 | | - AND R.rid = CR.rid -- look at them |
| 367 | + AND C.cid = CI.cid -- changeset --> its revisions |
| 368 | + AND R.rid = CI.iid -- look at them |
| 369 | 369 | AND R.mid != C.src -- Only those which disagree with changeset about the meta |
| 370 | 370 | AND R.fid = F.fid -- get file of the revision |
| 371 | 371 | AND CT.tid = C.type -- get changeset type, for labeling |
| 372 | 372 | } |
| 373 | 373 | # All revisions have to agree on the LOD their changeset |
| | @@ -383,14 +383,14 @@ |
| 383 | 383 | {All revisions in a changeset have to belong to the same LOD} \ |
| 384 | 384 | {: Its revisions disagree about the LOD they belong to} { |
| 385 | 385 | SELECT T.name, C.cid |
| 386 | 386 | FROM changeset C, cstype T |
| 387 | 387 | WHERE C.cid IN (SELECT U.cid |
| 388 | | - FROM (SELECT DISTINCT CR.cid AS cid, R.lod AS lod |
| 389 | | - FROM csrevision CR, changeset C, revision R |
| 390 | | - WHERE CR.rid = R.rid |
| 391 | | - AND C.cid = CR.cid |
| 388 | + FROM (SELECT DISTINCT CI.cid AS cid, R.lod AS lod |
| 389 | + FROM csitem CI, changeset C, revision R |
| 390 | + WHERE CI.iid = R.rid |
| 391 | + AND C.cid = CI.cid |
| 392 | 392 | AND C.type = 0) AS U |
| 393 | 393 | GROUP BY U.cid HAVING COUNT(U.lod) > 1) |
| 394 | 394 | AND T.tid = C.type |
| 395 | 395 | } |
| 396 | 396 | # All revisions have to agree on the project their changeset |
| | @@ -406,14 +406,14 @@ |
| 406 | 406 | {All revisions in a changeset have to belong to the same project} \ |
| 407 | 407 | {: Its revisions disagree about the project they belong to} { |
| 408 | 408 | SELECT T.name, C.cid |
| 409 | 409 | FROM changeset C, cstype T |
| 410 | 410 | WHERE C.cid IN (SELECT U.cid |
| 411 | | - FROM (SELECT DISTINCT CR.cid AS cid, F.pid AS pid |
| 412 | | - FROM csrevision CR, changeset C, revision R, file F |
| 413 | | - WHERE CR.rid = R.rid |
| 414 | | - AND C.cid = CR.cid |
| 411 | + FROM (SELECT DISTINCT CI.cid AS cid, F.pid AS pid |
| 412 | + FROM csitem CI, changeset C, revision R, file F |
| 413 | + WHERE CI.iid = R.rid |
| 414 | + AND C.cid = CI.cid |
| 415 | 415 | AND C.type = 0 |
| 416 | 416 | AND F.fid = R.fid) AS U |
| 417 | 417 | GROUP BY U.cid HAVING COUNT(U.pid) > 1) |
| 418 | 418 | AND T.tid = C.type |
| 419 | 419 | } |
| | @@ -432,19 +432,19 @@ |
| 432 | 432 | {: Its revisions share files} { |
| 433 | 433 | SELECT T.name, C.cid |
| 434 | 434 | FROM changeset C, cstype T |
| 435 | 435 | WHERE C.cid IN (SELECT VV.cid |
| 436 | 436 | FROM (SELECT U.cid as cid, COUNT (U.fid) AS fcount |
| 437 | | - FROM (SELECT DISTINCT CR.cid AS cid, R.fid AS fid |
| 438 | | - FROM csrevision CR, changeset C, revision R |
| 439 | | - WHERE CR.rid = R.rid |
| 440 | | - AND C.cid = CR.cid |
| 437 | + FROM (SELECT DISTINCT CI.cid AS cid, R.fid AS fid |
| 438 | + FROM csitem CI, changeset C, revision R |
| 439 | + WHERE CI.iid = R.rid |
| 440 | + AND C.cid = CI.cid |
| 441 | 441 | AND C.type = 0 |
| 442 | 442 | ) AS U |
| 443 | 443 | GROUP BY U.cid) AS UU, |
| 444 | | - (SELECT V.cid AS cid, COUNT (V.rid) AS rcount |
| 445 | | - FROM csrevision V, changeset X |
| 444 | + (SELECT V.cid AS cid, COUNT (V.iid) AS rcount |
| 445 | + FROM csitem V, changeset X |
| 446 | 446 | WHERE X.cid = V.cid |
| 447 | 447 | AND X.type = 0 |
| 448 | 448 | GROUP BY V.cid) AS VV |
| 449 | 449 | WHERE VV.cid = UU.cid |
| 450 | 450 | AND UU.fcount < VV.rcount) |
| | @@ -475,13 +475,13 @@ |
| 475 | 475 | SELECT P.name, S.name |
| 476 | 476 | FROM project P, tag T, symbol S |
| 477 | 477 | WHERE T.tid IN (SELECT tid -- All tags |
| 478 | 478 | FROM tag |
| 479 | 479 | EXCEPT -- subtract |
| 480 | | - SELECT CR.rid -- tags used |
| 481 | | - FROM csrevision CR, changeset C |
| 482 | | - WHERE C.cid = CR.cid -- by any tag |
| 480 | + SELECT CI.iid -- tags used |
| 481 | + FROM csitem CI, changeset C |
| 482 | + WHERE C.cid = CI.cid -- by any tag |
| 483 | 483 | AND C.type = 1) -- changeset |
| 484 | 484 | AND S.sid = T.sid -- get symbol of tag |
| 485 | 485 | AND P.pid = S.pid -- get project of symbol |
| 486 | 486 | } |
| 487 | 487 | # Find all tags which are used by more than one changeset. |
| | @@ -495,17 +495,17 @@ |
| 495 | 495 | -- user, and get their associated file (name) for |
| 496 | 496 | -- display. |
| 497 | 497 | |
| 498 | 498 | SELECT P.name, S.name |
| 499 | 499 | FROM tag T, project P, symbol S, |
| 500 | | - (SELECT CR.rid AS rid, count(CR.cid) AS count |
| 501 | | - FROM csrevision CR, changeset C |
| 500 | + (SELECT CI.iid AS iid, count(CI.cid) AS count |
| 501 | + FROM csitem CI, changeset C |
| 502 | 502 | WHERE C.type = 1 |
| 503 | | - AND C.cid = CR.cid |
| 504 | | - GROUP BY CR.rid) AS U |
| 503 | + AND C.cid = CI.cid |
| 504 | + GROUP BY CI.iid) AS U |
| 505 | 505 | WHERE U.count > 1 |
| 506 | | - AND T.tid = U.rid |
| 506 | + AND T.tid = U.iid |
| 507 | 507 | AND S.sid = T.sid -- get symbol of tag |
| 508 | 508 | AND P.pid = S.pid -- get project of symbol |
| 509 | 509 | } |
| 510 | 510 | if 0 { |
| 511 | 511 | # This check is disabled for the moment. Apparently tags |
| | @@ -529,14 +529,14 @@ |
| 529 | 529 | {All tags in a changeset have to belong to the same LOD} \ |
| 530 | 530 | {: Its tags disagree about the LOD they belong to} { |
| 531 | 531 | SELECT T.name, C.cid |
| 532 | 532 | FROM changeset C, cstype T |
| 533 | 533 | WHERE C.cid IN (SELECT U.cid |
| 534 | | - FROM (SELECT DISTINCT CR.cid AS cid, T.lod AS lod |
| 535 | | - FROM csrevision CR, changeset C, tag T |
| 536 | | - WHERE CR.rid = T.tid |
| 537 | | - AND C.cid = CR.cid |
| 534 | + FROM (SELECT DISTINCT CI.cid AS cid, T.lod AS lod |
| 535 | + FROM csitem CI, changeset C, tag T |
| 536 | + WHERE CI.iid = T.tid |
| 537 | + AND C.cid = CI.cid |
| 538 | 538 | AND C.type = 1) AS U |
| 539 | 539 | GROUP BY U.cid HAVING COUNT(U.lod) > 1) |
| 540 | 540 | AND T.tid = C.type |
| 541 | 541 | } |
| 542 | 542 | } |
| | @@ -553,14 +553,14 @@ |
| 553 | 553 | {All tags in a changeset have to belong to the same project} \ |
| 554 | 554 | {: Its tags disagree about the project they belong to} { |
| 555 | 555 | SELECT T.name, C.cid |
| 556 | 556 | FROM changeset C, cstype T |
| 557 | 557 | WHERE C.cid IN (SELECT U.cid |
| 558 | | - FROM (SELECT DISTINCT CR.cid AS cid, F.pid AS pid |
| 559 | | - FROM csrevision CR, changeset C, tag T, file F |
| 560 | | - WHERE CR.rid = T.tid |
| 561 | | - AND C.cid = CR.cid |
| 558 | + FROM (SELECT DISTINCT CI.cid AS cid, F.pid AS pid |
| 559 | + FROM csitem CI, changeset C, tag T, file F |
| 560 | + WHERE CI.iid = T.tid |
| 561 | + AND C.cid = CI.cid |
| 562 | 562 | AND C.type = 1 |
| 563 | 563 | AND F.fid = T.fid) AS U |
| 564 | 564 | GROUP BY U.cid HAVING COUNT(U.pid) > 1) |
| 565 | 565 | AND T.tid = C.type |
| 566 | 566 | } |
| | @@ -578,19 +578,19 @@ |
| 578 | 578 | {: Its tags share files} { |
| 579 | 579 | SELECT T.name, C.cid |
| 580 | 580 | FROM changeset C, cstype T |
| 581 | 581 | WHERE C.cid IN (SELECT VV.cid |
| 582 | 582 | FROM (SELECT U.cid as cid, COUNT (U.fid) AS fcount |
| 583 | | - FROM (SELECT DISTINCT CR.cid AS cid, T.fid AS fid |
| 584 | | - FROM csrevision CR, changeset C, tag T |
| 585 | | - WHERE CR.rid = T.tid |
| 586 | | - AND C.cid = CR.cid |
| 583 | + FROM (SELECT DISTINCT CI.cid AS cid, T.fid AS fid |
| 584 | + FROM csitem CI, changeset C, tag T |
| 585 | + WHERE CI.iid = T.tid |
| 586 | + AND C.cid = CI.cid |
| 587 | 587 | AND C.type = 1 |
| 588 | 588 | ) AS U |
| 589 | 589 | GROUP BY U.cid) AS UU, |
| 590 | | - (SELECT V.cid AS cid, COUNT (V.rid) AS rcount |
| 591 | | - FROM csrevision V, changeset X |
| 590 | + (SELECT V.cid AS cid, COUNT (V.iid) AS rcount |
| 591 | + FROM csitem V, changeset X |
| 592 | 592 | WHERE X.cid = V.cid |
| 593 | 593 | AND X.type = 1 |
| 594 | 594 | GROUP BY V.cid) AS VV |
| 595 | 595 | WHERE VV.cid = UU.cid |
| 596 | 596 | AND UU.fcount < VV.rcount) |
| | @@ -622,13 +622,13 @@ |
| 622 | 622 | SELECT P.name, S.name |
| 623 | 623 | FROM project P, branch B, symbol S |
| 624 | 624 | WHERE B.bid IN (SELECT bid -- All branches |
| 625 | 625 | FROM branch |
| 626 | 626 | EXCEPT -- subtract |
| 627 | | - SELECT CR.rid -- branches used |
| 628 | | - FROM csrevision CR, changeset C |
| 629 | | - WHERE C.cid = CR.cid -- by any branch |
| 627 | + SELECT CI.iid -- branches used |
| 628 | + FROM csitem CI, changeset C |
| 629 | + WHERE C.cid = CI.cid -- by any branch |
| 630 | 630 | AND C.type = 2) -- changeset |
| 631 | 631 | AND S.sid = B.sid -- get symbol of branch |
| 632 | 632 | AND P.pid = S.pid -- get project of symbol |
| 633 | 633 | } |
| 634 | 634 | # Find all branches which are used by more than one changeset. |
| | @@ -642,17 +642,17 @@ |
| 642 | 642 | -- than one user, and get their associated file (name) |
| 643 | 643 | -- for display. |
| 644 | 644 | |
| 645 | 645 | SELECT P.name, S.name |
| 646 | 646 | FROM branch B, project P, symbol S, |
| 647 | | - (SELECT CR.rid AS rid, count(CR.cid) AS count |
| 648 | | - FROM csrevision CR, changeset C |
| 647 | + (SELECT CI.iid AS iid, count(CI.cid) AS count |
| 648 | + FROM csitem CI, changeset C |
| 649 | 649 | WHERE C.type = 2 |
| 650 | | - AND C.cid = CR.cid |
| 651 | | - GROUP BY CR.rid ) AS U |
| 650 | + AND C.cid = CI.cid |
| 651 | + GROUP BY CI.iid ) AS U |
| 652 | 652 | WHERE U.count > 1 |
| 653 | | - AND B.bid = U.rid |
| 653 | + AND B.bid = U.iid |
| 654 | 654 | AND S.sid = B.sid -- get symbol of branch |
| 655 | 655 | AND P.pid = S.pid -- get project of symbol |
| 656 | 656 | } |
| 657 | 657 | # All branches have to agree on the LOD their changeset |
| 658 | 658 | # belongs to. In other words, all branches in a changeset have |
| | @@ -667,14 +667,14 @@ |
| 667 | 667 | {All branches in a changeset have to belong to the same LOD} \ |
| 668 | 668 | {: Its branches disagree about the LOD they belong to} { |
| 669 | 669 | SELECT T.name, C.cid |
| 670 | 670 | FROM changeset C, cstype T |
| 671 | 671 | WHERE C.cid IN (SELECT U.cid |
| 672 | | - FROM (SELECT DISTINCT CR.cid AS cid, B.lod AS lod |
| 673 | | - FROM csrevision CR, changeset C, branch B |
| 674 | | - WHERE CR.rid = B.bid |
| 675 | | - AND C.cid = CR.cid |
| 672 | + FROM (SELECT DISTINCT CI.cid AS cid, B.lod AS lod |
| 673 | + FROM csitem CI, changeset C, branch B |
| 674 | + WHERE CI.iid = B.bid |
| 675 | + AND C.cid = CI.cid |
| 676 | 676 | AND C.type = 2) AS U |
| 677 | 677 | GROUP BY U.cid HAVING COUNT(U.lod) > 1) |
| 678 | 678 | AND T.tid = C.type |
| 679 | 679 | } |
| 680 | 680 | # All branches have to agree on the project their changeset |
| | @@ -690,14 +690,14 @@ |
| 690 | 690 | {All branches in a changeset have to belong to the same project} \ |
| 691 | 691 | {: Its branches disagree about the project they belong to} { |
| 692 | 692 | SELECT T.name, C.cid |
| 693 | 693 | FROM changeset C, cstype T |
| 694 | 694 | WHERE C.cid IN (SELECT U.cid |
| 695 | | - FROM (SELECT DISTINCT CR.cid AS cid, F.pid AS pid |
| 696 | | - FROM csrevision CR, changeset C, branch B, file F |
| 697 | | - WHERE CR.rid = B.bid |
| 698 | | - AND C.cid = CR.cid |
| 695 | + FROM (SELECT DISTINCT CI.cid AS cid, F.pid AS pid |
| 696 | + FROM csitem CI, changeset C, branch B, file F |
| 697 | + WHERE CI.iid = B.bid |
| 698 | + AND C.cid = CI.cid |
| 699 | 699 | AND C.type = 2 |
| 700 | 700 | AND F.fid = B.fid) AS U |
| 701 | 701 | GROUP BY U.cid HAVING COUNT(U.pid) > 1) |
| 702 | 702 | AND T.tid = C.type |
| 703 | 703 | } |
| | @@ -716,19 +716,19 @@ |
| 716 | 716 | {: Its branches share files} { |
| 717 | 717 | SELECT T.name, C.cid |
| 718 | 718 | FROM changeset C, cstype T |
| 719 | 719 | WHERE C.cid IN (SELECT VV.cid |
| 720 | 720 | FROM (SELECT U.cid as cid, COUNT (U.fid) AS fcount |
| 721 | | - FROM (SELECT DISTINCT CR.cid AS cid, B.fid AS fid |
| 722 | | - FROM csrevision CR, changeset C, branch B |
| 723 | | - WHERE CR.rid = B.bid |
| 724 | | - AND C.cid = CR.cid |
| 721 | + FROM (SELECT DISTINCT CI.cid AS cid, B.fid AS fid |
| 722 | + FROM csitem CI, changeset C, branch B |
| 723 | + WHERE CI.iid = B.bid |
| 724 | + AND C.cid = CI.cid |
| 725 | 725 | AND C.type = 2 |
| 726 | 726 | ) AS U |
| 727 | 727 | GROUP BY U.cid) AS UU, |
| 728 | | - (SELECT V.cid AS cid, COUNT (V.rid) AS rcount |
| 729 | | - FROM csrevision V, changeset X |
| 728 | + (SELECT V.cid AS cid, COUNT (V.iid) AS rcount |
| 729 | + FROM csitem V, changeset X |
| 730 | 730 | WHERE X.cid = V.cid |
| 731 | 731 | AND X.type = 2 |
| 732 | 732 | GROUP BY V.cid) AS VV |
| 733 | 733 | WHERE VV.cid = UU.cid |
| 734 | 734 | AND UU.fcount < VV.rcount) |
| | @@ -757,15 +757,15 @@ |
| 757 | 757 | # changeset's tag associated with them. |
| 758 | 758 | CheckRevCS \ |
| 759 | 759 | {All revisions used by tag symbol changesets have to have the changeset's tag attached to them} \ |
| 760 | 760 | {does not have the tag of its symbol changeset @ attached to it} { |
| 761 | 761 | SELECT CT.name, C.cid, F.name, R.rev |
| 762 | | - FROM changeset C, cstype CT, revision R, file F, csrevision CR, tag T |
| 762 | + FROM changeset C, cstype CT, revision R, file F, csitem CI, tag T |
| 763 | 763 | WHERE C.type = 1 -- symbol changesets only |
| 764 | 764 | AND C.src = T.sid -- tag only, linked by symbol id |
| 765 | | - AND C.cid = CR.cid -- changeset --> its revisions |
| 766 | | - AND R.rid = CR.rid -- look at the revisions |
| 765 | + AND C.cid = CI.cid -- changeset --> its revisions |
| 766 | + AND R.rid = CI.iid -- look at the revisions |
| 767 | 767 | -- and look for the tag among the attached ones. |
| 768 | 768 | AND T.sid NOT IN (SELECT TB.sid |
| 769 | 769 | FROM tag TB |
| 770 | 770 | WHERE TB.rev = R.rid) |
| 771 | 771 | AND R.fid = F.fid -- get file of revision |
| | @@ -776,15 +776,15 @@ |
| 776 | 776 | |
| 777 | 777 | CheckRevCS \ |
| 778 | 778 | {All revisions used by branch symbol changesets have to have the changeset's branch attached to them} \ |
| 779 | 779 | {does not have the branch of its symbol changeset @ attached to it} { |
| 780 | 780 | SELECT CT.name, C.cid, F.name, R.rev, C.cid |
| 781 | | - FROM changeset C, cstype CT, revision R, file F, csrevision CR, branch B |
| 781 | + FROM changeset C, cstype CT, revision R, file F, csitem CI, branch B |
| 782 | 782 | WHERE C.type = 1 -- symbol changesets only |
| 783 | 783 | AND C.src = B.sid -- branches only |
| 784 | | - AND C.cid = CR.cid -- changeset --> its revisions |
| 785 | | - AND R.rid = CR.rid -- look at the revisions |
| 784 | + AND C.cid = CI.cid -- changeset --> its revisions |
| 785 | + AND R.rid = CI.iid -- look at the revisions |
| 786 | 786 | -- and look for the branch among the attached ones. |
| 787 | 787 | AND B.sid NOT IN (SELECT BB.sid |
| 788 | 788 | FROM branch BB |
| 789 | 789 | WHERE BB.root = R.rid) |
| 790 | 790 | AND R.fid = F.fid -- get file of revision |
| 791 | 791 | |