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

SUBSTRING(str,pos,len) returns incorrect result in view (returns an empty string)

Details

    Description

      Test:

      create view v1 as select substring('hello', 1, 4294967295);
      select * from v1;
      drop view v1;
      

      Actual result:
      empty string

      Expected result:

      hello
      

      Attachments

        Issue Links

          Activity

            bar Alexander Barkov added a comment - Sanja, please review: https://github.com/MariaDB/server/commit/76ebc6a10b34427930d8baf32c30d34024d46c60

            OK to push

            sanja Oleksandr Byelkin added a comment - OK to push

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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