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

every time when I execute one sql statement mariadb got crashed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.6.3
    • Fix Version/s: None
    • Labels:
    • Environment:

      Description

      I have a table with data of attachment 1.zip. I can select all rows without any problem.
      But every time I execute the follow sql mariadb got crashed(I have try to drop and recreate the table and create the table in other database but without any effect):
      SELECT id, createDate,createTime, TYPE, typeName, state, orderInfo, stateInfo, state4Tab ,fromPlanId,money,prize, betConfirmTime
      ,autoShowPrintedTime
      FROM order_orders1 WHERE userId=66668951

      AND (
      (state4Tab = 40 AND TYPE NOT IN (10,70,80))
      OR
      (TYPE IN (10,70,80) AND autoShowPrintedTime <= '2021-07-24 15:32:42' )
      )

      ORDER BY ID DESC

        Attachments

        1. 1.sql
          4.84 MB
        2. 1.zip
          470 kB
        3. my.cnf
          17 kB
        4. mysqld.log
          328 kB

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            chen666888 chen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration