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

Add Oracle, SQL Server, MySQL Compatibility functions.

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 6.5.0
    • 6.5.0
    • query
    • Security Level: Public
    • None

    Description

      https://forums.couchbase.com/t/simulate-sql-coalesce-and-isnull-using-n1ql/16725

      This is to make people and product migration easier.

      Consider requirement of these functions on JSON types, include arrays and objects where applicable.

      Add Coalesce, NVL, NVL2, etc functions to N1QL.

      Analyze Oracle and SQL Server for missing (common!) functions in N1QL and propose the list to review.

      -- 

      -COS---+(-
      radian_expr
      -)--+-----------------------

         | COSH--- |   
         | SIN---- |   
         | SINH--- |   
         | TAN---- |   
         | TANH--- |   
         | 'DEGREES' |   
         'ASIN+(-
      numeric_expr
      -)+-'   
          | ASINH |    
          | ACOS- |    
          | ACOSH |    
          | ATAN- |    
          | 'ATANH' |    
          +ATAN2(-
      y, x
      -)------------+    
          'RADIANS(-
      degree_expr
      -)---'

      Attachments

        Issue Links

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

          Activity

            People

              chang.liu Chang Liu (Inactive)
              keshav Keshav Murthy
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty