Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28651

quote(NULL) returns incorrect result in view ('NU' instead of 'NULL')

    XMLWordPrintable

Details

    Description

      Test:

      create view v1 as select quote(NULL);
      		 
      select * from v1;
      		 
      drop view v1;

      Actual result:

      NU

      Expected result:

      NULL

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31587 quote(NULL) returns incorrect result with cursor protocol

          • Major - Major loss of function.
          • Closed
          is part of

          Technical task - A technical task. MDEV-27691 make working view-protocol

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27945 Select from view with multi-byte charsets gives incorrect result

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28585 Wrong result for view defined as SELECT ROW(1,2,3) = (SELECT 1,2,NULL)

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28649 json_array(false) in the definition of view return 0 instead of "true"

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28652 SUBSTRING(str,pos,len) returns incorrect result in view (returns an empty string)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28659 View returns wrong value for big digits nuber

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28660 TRUNCATE(X,D) returns incorrect result in view

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28661 MIN(X) returns incorrect result in view

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28673 View returns different value for min(year) function

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28677 UDF returns wrong string value in view

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29524 "-0000000000000001" changes to "-1" in view definition, so type changes from bigint to int

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29525 CAST in view definition returns string instead of NULL on warning and gives incorrect round

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29526 ROUND(X,D) returns incorrect result in view when D>9

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29534 In view FROM_UNIXTIME adds .000000 in the result

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29647 ROW_NUMBER is not 0 for warnings in case without row in view

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33942 View cuts off the end of string with the utf8 character set in INSERT function

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29552 LEFT and RIGHT with big value for parameter 'len' >0 return empty value in view

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31587 quote(NULL) returns incorrect result with cursor protocol

          • Major - Major loss of function.
          • Closed

          Activity

            People

              bar Alexander Barkov
              lstartseva Lena Startseva
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1h 20m
                  1h 20m

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.