Derby
  1. Derby
  2. DERBY-2731

String literal constants currently take the collation of the compilation schema but the wiki page http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478 expects USER schema collation.

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Won't Fix
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: 10.3.1.4
    • Component/s: SQL
    • Labels:
      None

      Description

      I checked in code some time back which sets the collation type of string literal to be same as the compilation schema. The advantage of this is that metadata queries will work without changes since those queries do character string literal comparisons.

      But the wiki page at http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478 in Section Collation Determination, Rule 1) says that character string literal should always take the collation of user schema. This decision was based on the discussion in the Collation feature discussion thread at http://www.nabble.com/Collation-feature-discussion-tf3418026.html#a9675967. SQL spec defines the behavior here to be implementation defined (it says that in a convoluted way which can be found in the Collation feature discussion). But considering the impact it will have on the metadata queries (they will have to be changed so that we CAST character string literals so that they will take the collation of system schema and hence the comparison will not fail), should we reconsider our decision made on the wiki page.

        Issue Links

          Activity

          Mamta A. Satoor created issue -
          Mamta A. Satoor made changes -
          Field Original Value New Value
          Link This issue is part of DERBY-2599 [ DERBY-2599 ]
          Mike Matrigali made changes -
          Link This issue is related to DERBY-1478 [ DERBY-1478 ]
          Mamta A. Satoor made changes -
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Mamta A. Satoor made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Myrna van Lunteren made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Myrna van Lunteren made changes -
          Resolution Won't Fix [ 2 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          Myrna van Lunteren made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Gavin made changes -
          Workflow jira [ 12405178 ] Default workflow, editable Closed status [ 12797420 ]

            People

            • Assignee:
              Mamta A. Satoor
              Reporter:
              Mamta A. Satoor
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development