Uploaded image for project: 'Couchbase Documentation'
  1. Couchbase Documentation
  2. DOC-9380

Query CREATE/DROP function supports IF [NOT] EXISTS syntax to match analytics

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • Neo
    • Neo
    • query
    • DOC-2022-S4
    • 1

    Description

      Added support for the IF NOT EXISTS clause to the CREATE FUNCTION STATEMENT and IF EXISTS to DROP FUNCTION to largely match https://docs.couchbase.com/server/current/analytics/9_udf.htm

      i.e.

      CREATE FUNCTION name ( args) IF NOT EXISTS body

      DROP FUNCTION name IF EXISTS

      It is a syntax error to specify OR REPLACE along with IF NOT EXISTS, i.e.

      CREATE OR REPLACE name (args) IF NOT EXISTS body 

      will result in an error.

      Attachments

        Issue Links

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

          Activity

            People

              simon.dew Simon Dew
              Donald.haggart Donald Haggart
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty