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

Unable to deploy if handler has N1QL query with ( for Union clause

    XMLWordPrintable

Details

    • Untriaged
    • Ubuntu 64-bit
    • Unknown

    Description

      • Create a handler code with N1QL query for UNION 

      (SELECT * FROM src_bucket WHERE NOT (NUMERIC_FIELD IS NOT NULL) ORDER BY NUMERIC_FIELD_LIST, STRING_FIELD_LIST, BOOL_FIELD_LIST DESC) UNION (SELECT * FROM src_bucket WHERE (NUMERIC_FIELD IS NULL OR ((STRING_FIELD IS NOT NULL) OR (STRING_FIELD <= STRING_VALUES)) AND (STRING_FIELD NOT BETWEEN LOWER_BOUND_VALUE and UPPER_BOUND_VALUE)) ORDER BY STRING_FIELD_LIST);

      * Deploy that code, compilation got failed

      POST http://10.142.170.102:8091/_p/event/setApplication/?name=Function_507219280_test_random_n1ql122017143119004084 body: {"appcode": "function OnUpdate(doc, meta) {\n    var query=(SELECT * FROM src_bucket WHERE NOT (NUMERIC_FIELD IS NOT NULL) ORDER BY NUMERIC_FIELD_LIST, STRING_FIELD_LIST, BOOL_FIELD_LIST DESC) UNION (SELECT * FROM src_bucket WHERE (NUMERIC_FIELD IS NULL OR ((STRING_FIELD IS NOT NULL) OR (STRING_FIELD <= STRING_VALUES)) AND (STRING_FIELD NOT BETWEEN LOWER_BOUND_VALUE and UPPER_BOUND_VALUE)) ORDER BY STRING_FIELD_LIST);\n\n    try{\n    query.execQuery();\n    var key = Date.now();\n    dst_bucket[key]={'passed_query' : query};\n    }\n    catch(e){\n    var key = Date.now();\n    dst_bucket[key]={'failed_query' : query};\n    }\n}", "settings": {"execution_timeout": 60, "skip_timer_threshold": 86400, "log_level": "TRACE", "description": "Sample Description", "processing_status": true, "worker_count": 1, "cleanup_timers": false, "rbacuser": "cbadminbucket", "dcp_stream_boundary": "from_now", "rbacpass": "password", "cpp_worker_thread_count": 1, "tick_duration": 5000, "timer_worker_pool_size": 3, "sock_batch_size": 1, "rbacrole": "admin", "timer_processing_tick_interval": 500, "checkpoint_interval": 10000, "deployment_status": true}, "depcfg": {"buckets": [{"alias": "dst_bucket", "bucket_name": "dst_bucket"}], "source_bucket": "src_bucket", "metadata_bucket": "metadata"}, "appname": "Function_507219280_test_random_n1ql122017143119004084"} headers: {'Content-type': 'application/json', 'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==\n'} error: 500 reason: unknown {"name":"ERR_HANDLER_COMPILATION","code":27,"description":"Handler compilation failed","attributes":null,"runtime_info":"{\"language\":\"JavaScript\",\"compile_success\":false,\"index\":409,\"line_number\":2,\"column_number\":379,\"description\":\"Unexpected token ;\"}\n"} auth: Administrator:password

      Attachments

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

        Activity

          People

            vinayaka.kamath Vinayaka Kamath (Inactive)
            vikas.chaudhary Vikas Chaudhary
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty