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

impossible where with < operation, but =-5 return one row, same problem occur with UPDATE/SELECT/DELETE

Details

    Description

      hi guys, i got a bug (i think i'm right)
      when executing this:
      well it's a big table, i will put a link to download
      it was 10.0.1 version, but it don't exists anymore in jira

      query retuning rows:
      SELECT * FROM nf_erro_20130620 WHERE emitente_tipo='j' AND emitente_id=1 AND emitente_propriedade=0 AND nf_serie="3nfe" AND nf=-5

      query without rows:
      SELECT * FROM nf_erro_20130620 WHERE emitente_tipo='j' AND emitente_id=1 AND emitente_propriedade=0 AND nf_serie="3nfe" AND nf<0

      link to table (tar -zcf nf_erro_20130620.tgz nf_erro*)
      i removed the link
      169.093.860 bytes - the internet link is slow (130KB/s)

      or a mysqldump: (mysqldump 19_org nf_erro_20130620 --force > nf_erro_20130620.sql)
      i removed the link
      112.587.870 bytes - the internet link is slow (130KB/s)-

      Note by elenst: use the attachment instead, see the comment: https://mariadb.atlassian.net/browse/MDEV-4687?focusedCommentId=32844&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-32844

      EXPLAIN EXTENDED
      		 
      SELECT * FROM nf_erro_20130620 WHERE emitente_tipo='j' AND emitente_id=1 AND emitente_propriedade=0 AND nf_serie="3nfe" AND nf<0

      return a where 0 ?!

      show warnings
      		 
      select `19_org`.`nf_erro_20130620`.`emitente_tipo` AS `emitente_tipo`,`19_org`.`nf_erro_20130620`.`emitente_id` AS `emitente_id`,`19_org`.`nf_erro_20130620`.`emitente_propriedade` AS `emitente_propriedade`,`19_org`.`nf_erro_20130620`.`nf_serie` AS `nf_serie`,`19_org`.`nf_erro_20130620`.`nf` AS `nf`,`19_org`.`nf_erro_20130620`.`id_item` AS `id_item`,`19_org`.`nf_erro_20130620`.`status` AS `status`,`19_org`.`nf_erro_20130620`.`unidade_id` AS `unidade_id`,`19_org`.`nf_erro_20130620`.`lote_tipo` AS `lote_tipo`,`19_org`.`nf_erro_20130620`.`lote_spa` AS `lote_spa`,`19_org`.`nf_erro_20130620`.`oe_tipo` AS `oe_tipo`,`19_org`.`nf_erro_20130620`.`oe` AS `oe`,`19_org`.`nf_erro_20130620`.`oe_seq` AS `oe_seq`,`19_org`.`nf_erro_20130620`.`item_id` AS `item_id`,`19_org`.`nf_erro_20130620`.`item_id_red` AS `item_id_red`,`19_org`.`nf_erro_20130620`.`item_codigo` AS `item_codigo`,`19_org`.`nf_erro_20130620`.`item_desc` AS `item_desc`,`19_org`.`nf_erro_20130620`.`servico` AS `servico`,`19_org`.`nf_erro_20130620`.`documento_auxiliar` AS `documento_auxiliar`,`19_org`.`nf_erro_20130620`.`cfop_id` AS `cfop_id`,`19_org`.`nf_erro_20130620`.`cfop_id_red` AS `cfop_id_red`,`19_org`.`nf_erro_20130620`.`cfop_numero` AS `cfop_numero`,`19_org`.`nf_erro_20130620`.`class_fiscal` AS `class_fiscal`,`19_org`.`nf_erro_20130620`.`sit_trib` AS `sit_trib`,`19_org`.`nf_erro_20130620`.`sit_trib_ipi` AS `sit_trib_ipi`,`19_org`.`nf_erro_20130620`.`sit_trib_pis` AS `sit_trib_pis`,`19_org`.`nf_erro_20130620`.`sit_trib_cofins` AS `sit_trib_cofins`,`19_org`.`nf_erro_20130620`.`sit_trib_iss` AS `sit_trib_iss`,`19_org`.`nf_erro_20130620`.`sit_trib_sn` AS `sit_trib_sn`,`19_org`.`nf_erro_20130620`.`icms_incluir_bc` AS `icms_incluir_bc`,`19_org`.`nf_erro_20130620`.`icms_subst_incluir_bc` AS `icms_subst_incluir_bc`,`19_org`.`nf_erro_20130620`.`ipi_incluir_bc` AS `ipi_incluir_bc`,`19_org`.`nf_erro_20130620`.`pis_inclur_bc` AS `pis_inclur_bc`,`19_org`.`nf_erro_20130620`.`cofins_incluir_bc` AS `cofins_incluir_bc`,`19_org`.`nf_erro_20130620`.`ii_incluir_bc` AS `ii_incluir_bc`,`19_org`.`nf_erro_20130620`.`sn_incluir_bc` AS `sn_incluir_bc`,`19_org`.`nf_erro_20130620`.`un_fat` AS `un_fat`,`19_org`.`nf_erro_20130620`.`quant` AS `quant`,`19_org`.`nf_erro_20130620`.`pecas` AS `pecas`,`19_org`.`nf_erro_20130620`.`pbruto` AS `pbruto`,`19_org`.`nf_erro_20130620`.`pliq` AS `pliq`,`19_org`.`nf_erro_20130620`.`vliq` AS `vliq`,`19_org`.`nf_erro_20130620`.`vbruto` AS `vbruto`,`19_org`.`nf_erro_20130620`.`valor_pauta` AS `valor_pauta`,`19_org`.`nf_erro_20130620`.`valor_pauta_grandeza` AS `valor_pauta_grandeza`,`19_org`.`nf_erro_20130620`.`valor_pauta_grandeza_quant` AS `valor_pauta_grandeza_quant`,`19_org`.`nf_erro_20130620`.`valor_produto_un` AS `valor_produto_un`,`19_org`.`nf_erro_20130620`.`valor_produto_grandeza` AS `valor_produto_grandeza`,`19_org`.`nf_erro_20130620`.`valor_produto_grandeza_quant` AS `valor_produto_grandeza_quant`,`19_org`.`nf_erro_20130620`.`valor_produto_tabela_un` AS `valor_produto_tabela_un`,`19_org`.`nf_erro_20130620`.`valor_produto_total` AS `valor_produto_total`,`19_org`.`nf_erro_20130620`.`valor_frete` AS `valor_frete`,`19_org`.`nf_erro_20130620`.`valor_seguro` AS `valor_seguro`,`19_org`.`nf_erro_20130620`.`valor_outras` AS `valor_outras`,`19_org`.`nf_erro_20130620`.`valor_estimado_impostos` AS `valor_estimado_impostos`,`19_org`.`nf_erro_20130620`.`valor_estimado_impostos_por` AS `valor_estimado_impostos_por`,`19_org`.`nf_erro_20130620`.`desconto` AS `desconto`,`19_org`.`nf_erro_20130620`.`icms_de_aliq` AS `icms_de_aliq`,`19_org`.`nf_erro_20130620`.`icms_de_red` AS `icms_de_red`,`19_org`.`nf_erro_20130620`.`icms_fe_aliq` AS `icms_fe_aliq`,`19_org`.`nf_erro_20130620`.`icms_fe_red` AS `icms_fe_red`,`19_org`.`nf_erro_20130620`.`icms_basecalculo` AS `icms_basecalculo`,`19_org`.`nf_erro_20130620`.`icms_valor` AS `icms_valor`,`19_org`.`nf_erro_20130620`.`icms_subst_ind_convenio` AS `icms_subst_ind_convenio`,`19_org`.`nf_erro_20130620`.`icms_subst_basecalculo` AS `icms_subst_basecalculo`,`19_org`.`nf_erro_20130620`.`icms_subst_valor` AS `icms_subst_valor`,`19_org`.`nf_erro_20130620`.`ipi_aliq` AS `ipi_aliq`,`19_org`.`nf_erro_20130620`.`ipi_red` AS `ipi_red`,`19_org`.`nf_erro_20130620`.`ipi_basecalculo` AS `ipi_basecalculo`,`19_org`.`nf_erro_20130620`.`ipi_valor` AS `ipi_valor`,`19_org`.`nf_erro_20130620`.`iss_aliq` AS `iss_aliq`,`19_org`.`nf_erro_20130620`.`iss_red` AS `iss_red`,`19_org`.`nf_erro_20130620`.`iss_basecalculo` AS `iss_basecalculo`,`19_org`.`nf_erro_20130620`.`iss_valor` AS `iss_valor`,`19_org`.`nf_erro_20130620`.`pis_aliq` AS `pis_aliq`,`19_org`.`nf_erro_20130620`.`pis_red` AS `pis_red`,`19_org`.`nf_erro_20130620`.`pis_basecalculo` AS `pis_basecalculo`,`19_org`.`nf_erro_20130620`.`pis_valor` AS `pis_valor`,`19_org`.`nf_erro_20130620`.`cofins_aliq` AS `cofins_aliq`,`19_org`.`nf_erro_20130620`.`cofins_red` AS `cofins_red`,`19_org`.`nf_erro_20130620`.`cofins_basecalculo` AS `cofins_basecalculo`,`19_org`.`nf_erro_20130620`.`cofins_valor` AS `cofins_valor`,`19_org`.`nf_erro_20130620`.`funrural_aliq` AS `funrural_aliq`,`19_org`.`nf_erro_20130620`.`funrural_red` AS `funrural_red`,`19_org`.`nf_erro_20130620`.`funrural_basecalculo` AS `funrural_basecalculo`,`19_org`.`nf_erro_20130620`.`funrural_valor` AS `funrural_valor`,`19_org`.`nf_erro_20130620`.`sn_aliq` AS `sn_aliq`,`19_org`.`nf_erro_20130620`.`sn_red` AS `sn_red`,`19_org`.`nf_erro_20130620`.`sn_basecalculo` AS `sn_basecalculo`,`19_org`.`nf_erro_20130620`.`sn_valor` AS `sn_valor`,`19_org`.`nf_erro_20130620`.`cide_aliq` AS `cide_aliq`,`19_org`.`nf_erro_20130620`.`cide_red` AS `cide_red`,`19_org`.`nf_erro_20130620`.`cide_basecalculo` AS `cide_basecalculo`,`19_org`.`nf_erro_20130620`.`cide_valor` AS `cide_valor`,`19_org`.`nf_erro_20130620`.`csll_aliq` AS `csll_aliq`,`19_org`.`nf_erro_20130620`.`csll_red` AS `csll_red`,`19_org`.`nf_erro_20130620`.`csll_basecalculo` AS `csll_basecalculo`,`19_org`.`nf_erro_20130620`.`csll_valor` AS `csll_valor`,`19_org`.`nf_erro_20130620`.`sit_trib_csll` AS `sit_trib_csll`,`19_org`.`nf_erro_20130620`.`inss_aliq` AS `inss_aliq`,`19_org`.`nf_erro_20130620`.`inss_red` AS `inss_red`,`19_org`.`nf_erro_20130620`.`inss_basecalculo` AS `inss_basecalculo`,`19_org`.`nf_erro_20130620`.`inss_valor` AS `inss_valor`,`19_org`.`nf_erro_20130620`.`sit_trib_inss` AS `sit_trib_inss`,`19_org`.`nf_erro_20130620`.`ir_aliq` AS `ir_aliq`,`19_org`.`nf_erro_20130620`.`ir_red` AS `ir_red`,`19_org`.`nf_erro_20130620`.`ir_basecalculo` AS `ir_basecalculo`,`19_org`.`nf_erro_20130620`.`ir_valor` AS `ir_valor`,`19_org`.`nf_erro_20130620`.`sit_trib_ir` AS `sit_trib_ir`,`19_org`.`nf_erro_20130620`.`ii_aliq` AS `ii_aliq`,`19_org`.`nf_erro_20130620`.`ii_red` AS `ii_red`,`19_org`.`nf_erro_20130620`.`ii_basecalculo` AS `ii_basecalculo`,`19_org`.`nf_erro_20130620`.`ii_valor` AS `ii_valor`,`19_org`.`nf_erro_20130620`.`sit_trib_ii` AS `sit_trib_ii`,`19_org`.`nf_erro_20130620`.`numero_pedido_compra` AS `numero_pedido_compra`,`19_org`.`nf_erro_20130620`.`numero_item_pedido` AS `numero_item_pedido`,`19_org`.`nf_erro_20130620`.`obs_item` AS `obs_item`,`19_org`.`nf_erro_20130620`.`quant_devolvida` AS `quant_devolvida`,`19_org`.`nf_erro_20130620`.`pecas_devolvida` AS `pecas_devolvida`,`19_org`.`nf_erro_20130620`.`pbruto_devolvida` AS `pbruto_devolvida`,`19_org`.`nf_erro_20130620`.`pliq_devolvida` AS `pliq_devolvida`,`19_org`.`nf_erro_20130620`.`vliq_devolvida` AS `vliq_devolvida`,`19_org`.`nf_erro_20130620`.`vbruto_devolvida` AS `vbruto_devolvida`,`19_org`.`nf_erro_20130620`.`ii_anterior_un` AS `ii_anterior_un`,`19_org`.`nf_erro_20130620`.`ipi_anterior_un` AS `ipi_anterior_un`,`19_org`.`nf_erro_20130620`.`pis_anterior_un` AS `pis_anterior_un`,`19_org`.`nf_erro_20130620`.`cofins_anterior_un` AS `cofins_anterior_un` from `19_org`.`nf_erro_20130620` where 0

      Attachments

        1. mdev-4687.dump
          1.15 MB
          Elena Stepanova

        Activity

          Ascending order - Click to sort in descending order
          View 35 older comments
          psergei Sergei Petrunia added a comment -

          Pushed into 5.5 tree

          psergei Sergei Petrunia added a comment - Pushed into 5.5 tree
          rspadim roberto spadim added a comment -

          nice sergei! i tested with 10.0.3 and this worked fine too
          i don't use <5.5 maybe someone could test...

          thanks again =]

          rspadim roberto spadim added a comment - nice sergei! i tested with 10.0.3 and this worked fine too i don't use <5.5 maybe someone could test... thanks again =]
          rspadim roberto spadim added a comment -

          PLEASE PUT THIS IN 10.0.4 VERSION =]

          rspadim roberto spadim added a comment - PLEASE PUT THIS IN 10.0.4 VERSION =]
          serg Sergei Golubchik added a comment -

          I'm afraid it's too late to do a new 5.5->10.0 merge now. Remember, 10.0.4 is an alpha release, it's main feature is 5.6 merge. The goal of 10.0.4 release is to get the new features out so that users could try them out.

          In about a month we expect to have 10.0.5 release that will include this bug fix.

          serg Sergei Golubchik added a comment - I'm afraid it's too late to do a new 5.5->10.0 merge now. Remember, 10.0.4 is an alpha release, it's main feature is 5.6 merge. The goal of 10.0.4 release is to get the new features out so that users could try them out. In about a month we expect to have 10.0.5 release that will include this bug fix.
          rspadim roberto spadim added a comment -

          ok no problem, i used the same patch for 10.0.3 without changes, and it worked, if possible put this as soon as possible, recompiling sometimes is a problem, the binary is easier to install =] thanks !

          rspadim roberto spadim added a comment - ok no problem, i used the same patch for 10.0.3 without changes, and it worked, if possible put this as soon as possible, recompiling sometimes is a problem, the binary is easier to install =] thanks !

          People

            psergei Sergei Petrunia
            rspadim roberto spadim
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.