Qbe does not work for number columns with trailing zero's

XMLWordPrintable

    • Type: Bug
    • Resolution: Not an Issue
    • Priority: P2
    • 7-pool
    • Affects Version/s: 7u11
    • Component/s: core-libs
    • None

         
        SHORT SUMMARY:
        This bug is being logged as requested by Oracle JDeveloper group.
        Inconsistent QBE behavior for number columns with trailing zero's.

        Take these examples.

        1. Amount = 100.00

           When user enters 100 (or) 100. [just the decimal point], record is queried
           in the table.

           It does not work when user enters 100.0 (or) 100.00

        2. Amount = 1062.50

           When user enters 1062.5, record is queried.

           It does not work for all other cases, 1062 (or) 1062. (or) 1062.50

        Issue:
        This is the pattern I see. When there are trailing zero's in the decimal
        place, QBE does not work when user enters the exact value.

        INDICATORS:
        COUNTER INDICATORS:
        TRIGGERS:
        KNOWN WORKAROUND:
        As a workaround, user has to enter all numbers until the non-zero value.
        PRESENT SINCE:
        HOW TO VERIFY:
        NOTES FOR SE:
        REGRESSION:
         

              Assignee:
              Dmeetry Degrave (Inactive)
              Reporter:
              Webbug Group
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: