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

Update WHERE condition null

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • N/A
    • Server
    • None
    • Amazon RDS MariaDB 10.2.12

    Description

      Is this behavior correct?
      I'm trying to make an update with the condition v.fk_status != 17 and in the database the value v.fk_status is null

      [SQL] UPDATE vendas v SET v.data_cancelamento = '2018-05-31 10:27:27', v.fk_status = 17 WHERE v.id_venda = 531476 AND v.fk_status != 17

      Affected rows: 0
      Time: 0.012s

      Attachments

        Activity

          People

            Unassigned Unassigned
            elvisdosreis Elvis P dos Reis
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.