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

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.6.3
    • None

    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

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

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.