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

[CX] "explain text" and SET statement incompatibility

    XMLWordPrintable

Details

    • Untriaged
    • Unknown
    • CX Sprint 149, CX Sprint 150, CX Sprint 178

    Description

      While

      set `import-private-functions` `true`;
      array_count(tpcds_datagen("customer_address", 0.1))
      

      works and returns

      [
        5000
      ]
      

      neither

      explain text set `import-private-functions` `true`;
      array_count(tpcds_datagen("customer_address", 0.1))
      

      (returning

      [
        {
          "code": 24000,
          "msg": "Syntax error: In line 1 >>explain  set `import-private-functions` `true`;<< Encountered \"set\" at column 10. ",
          "query_from_user": "explain text set `import-private-functions` `true`;\narray_count(tpcds_datagen(\"customer_address\", 0.1))"
        }
      ]

      ) nor

      set `import-private-functions` `true`;
      explain text array_count(tpcds_datagen("customer_address", 0.1))
      

      (returning

      [
        {
          "code": 24001,
          "msg": "Compilation error: function Default.tpcds_datagen@2 is not defined (in line 1, at column 22)",
          "query_from_user": "set `import-private-functions` `true`;\nexplain text array_count(tpcds_datagen(\"customer_address\", 0.1))"
        }
      ]

      ) can be used to get a textual plan for the request

      Attachments

        For Gerrit Dashboard: MB-34086
        # Subject Branch Project Status CR V

        Activity

          People

            umang.agrawal Umang
            till Till Westmann
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty