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

ALTER TABLE DROP FOREIGN KEY - unexpected end of stream error

    Details

      Description

      On 10.3.8 when you issue the following command:

      ALTER TABLE `p1b` COMMENT 'drop fk test', DROP FOREIGN KEY p1b_ibfk_1 
      

      it generates the following error:

      (conn=41) unexpected end of stream, read 0 bytes from 4 (socket was closed by server)
      

      Note that this has worked without issue in all prior 10.1 and 10.2 versions we have used. Also, note that the following does NOT generate an error and does work correctly:

      ALTER TABLE `p1b` DROP FOREIGN KEY p1b_ibfk_1 
      

      Also the following works correctly:

      ALTER TABLE `p1b` COMMENT 'add fk test', ADD  FOREIGN KEY (`p1`) REFERENCES `p1` (`p1_ID`) ON DELETE RESTRICT ON UPDATE CASCADE 
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                rdyas Robert Dyas
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: