Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-29145

Unicode characters are not handled on CBAS workbench.

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Won't Fix
    • 5.5.0
    • 6.0.0
    • analytics
    • Enterprise Edition 5.5.0 build 2423

    Description

      Query: select –9223372036854775806
      Here "-" is a unicode character.

      Result:

      [
        {
          "code": 1,
          "msg": "ParseException: TokenMgrError: Lexical error at line 1, column 8.  Encountered: \"\\u2013\" (8211), after : \"\"",
          "query_from_user": "select –9223372036854775806"
        }
      ]
      

      N1QL also does not support it:

      [
        {
          "code": 3000,
          "msg": "syntax error - at –",
          "query_from_user": "select –9223372036854775806"
        }
      ]
      

      Logged this ticket if we can do something about it in future or at minimum be aware of this.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          till Till Westmann added a comment - - edited

          Does this character work in a string? In that case it's not an issue at all.

          till Till Westmann added a comment - - edited Does this character work in a string? In that case it's not an issue at all.

          The query

          select "–9223372036854775806"
          

          works and returns

          [
            {
              "$1": "–9223372036854775806"
            }
          ]
          

          Is this is working, as expected as the lexical analysis doesn't (and shouldn't) recognize –9223372036854775806 as a token.

          till Till Westmann added a comment - The query select "–9223372036854775806" works and returns [ { "$1": "–9223372036854775806" } ] Is this is working, as expected as the lexical analysis doesn't (and shouldn't) recognize –9223372036854775806 as a token.

          People

            till Till Westmann
            ritesh.agarwal Ritesh Agarwal
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty