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

DELETE (single table) to support table aliases

Details

    Description

      from: https://github.com/PrestaShop/PrestaShop/issues/33157

      Support syntax:

      DELETE FROM product xy WHERE id_product=123123;

      Attachments

        Issue Links

          Activity

            if that happen to work with the existing PR — great, otherwise let's have a separate MDEV for this extension

            serg Sergei Golubchik added a comment - if that happen to work with the existing PR — great, otherwise let's have a separate MDEV for this extension
            danblack Daniel Black added a comment -

            bar already does:

            MariaDB [test]> create table tab1 ( id int);
            Query OK, 0 rows affected (0.001 sec)
             
            MariaDB [test]> delete from tab1 a where a.id =3;
            Query OK, 0 rows affected (0.001 sec)
            
            

            danblack Daniel Black added a comment - bar already does: MariaDB [test]> create table tab1 ( id int ); Query OK, 0 rows affected (0.001 sec)   MariaDB [test]> delete from tab1 a where a.id =3; Query OK, 0 rows affected (0.001 sec)
            danblack Daniel Black added a comment - - edited

            I didn't have a 11.6 branch to base it on so its still as 11.5:

            bb-11.5-MDEV-33988-delete-table-alias-pkgtest,

            • aarch64,amd64, -debian-10-deb-autobake-install - java security test error - no applicable
            • aarch64,amd64-fedora-39-rpm-autobake - cpack errors around mariadbackup man pages - not applicable
            • aarch64-macos - test errors that where on the 11.5/11.6 branch already
            • aarch64-ubuntu-2004-debug - main.status2 error on debug sync point in select statement - not applicable.
            • amd64-debian-10 - main.query_cache_merge - number of hit errors on SELECT. - not applicable
            • amd64-debian-11-msan - rpl.rpl_change_master_demote (rpl.rpl_change_master_demote MDEV-34274, MDEV-3336), atomic.alter_table (timeout) - not applicable
            • amd64-debian-12-asan-ubsan - ssl_auto_verify and feedback plugin - not using delete.
            • amd64-fedora-40-rpm-autobake - infra timeout in build phase
            • amd64-freebsd-14 - unit.my_apc - not using delete
            • amd64-opensuse-15-rpm-autobake-install - MDBF-696
            • amd64-opensuse-15-rpm-autobake-major-upgrade - MDBF-697
            • amd64-rhel8-dockerlibrary - non-deterministic failures - doesn't use DELETE aliases - to be investigated
            • amd64-rhel8-wordpress - infra problem - now corrected
            • amd64-rockylinux-8-rpm-autobake - MDBF-698
            • amd64-ubuntu-2004-eco-php - identical failure on other branch
            • amd64-ubuntu-2004-fulltest feedback plugin and mysql-interactive test failures (now fixed on 11.5)
            • amd64-ubuntu-2204-clang14-asan - feedback plugin fixed on 11.5
            • amd64-ubuntu-2204-valgrind - spider mtr faults still on 11.5
            • amd64-windows-packages - main.status (flush status related) - still on 11.5
            • aix - compile error on libfmt MDEV-34206 - waiting on merge up
            • ppc64le-centos-stream9 / rhel9- MDEV-33603 - select ORDER by error
            • ppc64le-debian-12-deb-autobake-major-upgrade - MDBF-699 - scripting around versions
            • ppc64le-debian-sid-deb-autobake-major-upgrade - packaging scripting - fixed in 11.5 latest
            • ppc64le-ubuntu-2004 MDEV-31900

            bb.net.

            • kvm-bintar-centos74-amd64 - query plan change on EXPLAIN SELECT - not applicable
            • kvm-debug-ppc64le - infra fault

            Packages: https://ci.mariadb.org/46917

            Container: quay.io/mariadb-foundation/mariadb-devel:11.5-MDEV-33988-delete-table-alias-pkgtest

            10.5 version - different query plan in main.delete_use_source but otherwise same result.
            bb-10.5-MDEV-33988-delete-table-alias-pkgtest, bb.net.

            Less faults than 11.5, nothing potentially related to the commit.

            packages: https://ci.mariadb.org/46918

            Container: quay.io/mariadb-foundation/mariadb-devel:10.5-MDEV-33988-delete-table-alias-pkgtest

            danblack Daniel Black added a comment - - edited I didn't have a 11.6 branch to base it on so its still as 11.5: bb-11.5-MDEV-33988-delete-table-alias-pkgtest , aarch64,amd64, -debian-10-deb-autobake-install - java security test error - no applicable aarch64,amd64-fedora-39-rpm-autobake - cpack errors around mariadbackup man pages - not applicable aarch64-macos - test errors that where on the 11.5/11.6 branch already aarch64-ubuntu-2004-debug - main.status2 error on debug sync point in select statement - not applicable. amd64-debian-10 - main.query_cache_merge - number of hit errors on SELECT. - not applicable amd64-debian-11-msan - rpl.rpl_change_master_demote (rpl.rpl_change_master_demote MDEV-34274 , MDEV-3336), atomic.alter_table (timeout) - not applicable amd64-debian-12-asan-ubsan - ssl_auto_verify and feedback plugin - not using delete. amd64-fedora-40-rpm-autobake - infra timeout in build phase amd64-freebsd-14 - unit.my_apc - not using delete amd64-opensuse-15-rpm-autobake-install - MDBF-696 amd64-opensuse-15-rpm-autobake-major-upgrade - MDBF-697 amd64-rhel8-dockerlibrary - non-deterministic failures - doesn't use DELETE aliases - to be investigated amd64-rhel8-wordpress - infra problem - now corrected amd64-rockylinux-8-rpm-autobake - MDBF-698 amd64-ubuntu-2004-eco-php - identical failure on other branch amd64-ubuntu-2004-fulltest feedback plugin and mysql-interactive test failures (now fixed on 11.5) amd64-ubuntu-2204-clang14-asan - feedback plugin fixed on 11.5 amd64-ubuntu-2204-valgrind - spider mtr faults still on 11.5 amd64-windows-packages - main.status (flush status related) - still on 11.5 aix - compile error on libfmt MDEV-34206 - waiting on merge up ppc64le-centos-stream9 / rhel9- MDEV-33603 - select ORDER by error ppc64le-debian-12-deb-autobake-major-upgrade - MDBF-699 - scripting around versions ppc64le-debian-sid-deb-autobake-major-upgrade - packaging scripting - fixed in 11.5 latest ppc64le-ubuntu-2004 MDEV-31900 bb.net . kvm-bintar-centos74-amd64 - query plan change on EXPLAIN SELECT - not applicable kvm-debug-ppc64le - infra fault Packages: https://ci.mariadb.org/46917 Container: quay.io/mariadb-foundation/mariadb-devel:11.5- MDEV-33988 -delete-table-alias-pkgtest 10.5 version - different query plan in main.delete_use_source but otherwise same result. bb-10.5-MDEV-33988-delete-table-alias-pkgtest , bb.net . Less faults than 11.5, nothing potentially related to the commit. packages: https://ci.mariadb.org/46918 Container: quay.io/mariadb-foundation/mariadb-devel:10.5- MDEV-33988 -delete-table-alias-pkgtest

            Testing done.
            Before pushing, it is necessary to get a solution for the bug MDEV-34598

            lstartseva Lena Startseva added a comment - Testing done. Before pushing, it is necessary to get a solution for the bug MDEV-34598

            Ok to push.

            lstartseva Lena Startseva added a comment - Ok to push.

            People

              danblack Daniel Black
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.