Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5763

Reference Guide should note the new casing rules for the USERNAME arguments to the NATIVE procedures

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.9.1.0
    • Fix Version/s: 10.9.1.0
    • Component/s: Documentation
    • Labels:
      None
    • Urgency:
      Normal

      Description

      The work on DERBY-5762 changed the behavior of the USERNAME arguments to the NATIVE procedures. Now those arguments are case-sensitive only if you double-quote the username string. For example, the following calls affect the same user, EDWARD:

      call syscs_util.syscs_create_user( 'Edward', 'hisPassword' )
      call syscs_util.syscs_create_user( 'EdWard', 'hisPassword' )

      ...while the following call affects a different user, EdWard:

      call syscs_util.syscs_create_user( '"EdWard"', 'hisPassword' )

      The rule is this: without double quotes, the USERNAME argument is uppercased. To create camel-case or lowercase users, you need to double-quote the USERNAME.

        Attachments

        1. DERBY-5763.diff
          8 kB
          Kim Haase
        2. DERBY-5763.stat
          0.2 kB
          Kim Haase
        3. DERBY-5763.zip
          13 kB
          Kim Haase
        4. DERBY-5763-2.diff
          9 kB
          Kim Haase
        5. DERBY-5763-2.zip
          13 kB
          Kim Haase

          Issue Links

            Activity

              People

              • Assignee:
                chaase3 Kim Haase
                Reporter:
                rhillegas Rick Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: