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

LP:1003825 - SP does not accept variables in LIMIT clause

        Details

        • Type: Bug
        • Status: Closed
        • Resolution: Not a Bug
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          Description

          Seems this is already fixed bug in MySQL http://bugs.mysql.com/bug.php?id=11918 still exists in 5.3.5-MariaDB-ga-mariadb113

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Re: SP does not accept variables in LIMIT clause
                Hi,

                The feature was implemented in 5.5 code line and is present both in MySQL 5.5 and MariaDB 5.5, but not in MySQL 5.1.
                MariaDB 5.3 is based on MySQL 5.1, so it does not have the functionality either.

                Show
                elenst Elena Stepanova added a comment - Re: SP does not accept variables in LIMIT clause Hi, The feature was implemented in 5.5 code line and is present both in MySQL 5.5 and MariaDB 5.5, but not in MySQL 5.1. MariaDB 5.3 is based on MySQL 5.1, so it does not have the functionality either.
                Hide
                Permalink
                ntman NT Man added a comment -

                Re: SP does not accept variables in LIMIT clause
                It's problem for me install MariaDB 5.5 because not exists RPM package neither for CentOS 5.x/6.x, nor for Fedora 17.
                On http://mariadb.org/ exists only MariaDB 5.3 RPM package for CentOS 5.x :'(

                Show
                ntman NT Man added a comment - Re: SP does not accept variables in LIMIT clause It's problem for me install MariaDB 5.5 because not exists RPM package neither for CentOS 5.x/6.x, nor for Fedora 17. On http://mariadb.org/ exists only MariaDB 5.3 RPM package for CentOS 5.x :'(
                Hide
                Permalink
                wlad Vladislav Vaintroub added a comment -

                Re: SP does not accept variables in LIMIT clause
                No RPMs for 5.5 is a separate problem which is being fixed

                Show
                wlad Vladislav Vaintroub added a comment - Re: SP does not accept variables in LIMIT clause No RPMs for 5.5 is a separate problem which is being fixed
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 1003825

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 1003825

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    ntman NT Man
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: