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

Queries in stored procedures with and EXISTS(SELECT * FROM VIEW) crashes and closes hte conneciton.

    Details

    • Sprint:
      10.0.30

      Description

      I am getting an error:

      (conn:7) Could not read packet: unexpected end of stream, read 0 bytes from 4

      I see a reference to a similar problem reported in https://jira.mariadb.org/browse/CONJ-348 for the connector.

      this recommends the solution of adding ?useServerPrepStmts=false to the connection string.

      Unfortunately I am making heavy use of stored procedures and stored procedures automatically have their prepared statemsnts buffered so the second time I use the procedure it crashes with the above error.

      this error comes from a statement similar to:

      SELECT *
      FROM MY_TABLE MT
      WHERE EXISTS ( SELECT *
      FROM MYVIEW MV
      WHERE MV.FIELD1 = MT.FIELD1 )
      AND MT.FIELD2 = V_VALUE;

      The view is quite complicated and essentially implements a security system I have been working on for some months so its a bit of blocker to rolling out a system.

      the text in /CONJ-348 suggests this server error is to be fixed in 10.1.21 so I have upgraded to that but the issue still remains.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sanja Oleksandr Byelkin
                Reporter:
                nicholasdenning Nicholas Denning
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: