Uploaded image for project: 'Crucible'
  1. Crucible
  2. CRUC-5507

Under Oracle, creating a review from a changeset fails with "ORA-00932: inconsistent datatypes: expected - got CLOB"

    XMLWordPrintable

Details

    Description

      We "select distinct review from Review review..." which fails under Oracle because distinct applies to all columns but Oracle won't compare CLOBs (and Review has two CLOB columns).

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CRUC-5505 Oracle error creating review

          • Highest - Our top priority issues
          • Closed

          Activity

            People

              mstudman Michael Studman (Inactive)
              mstudman Michael Studman (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 3h 13m
                  3h 13m