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

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.3, 5.5.31, 5.1.67, 5.2.14, 5.3.12
        • Fix Version/s: 10.0.5, 5.5.33, 5.3.13
        • Component/s: Storage Engine - Aria
        • Labels:
        • Environment:
          linux

          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

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                34 older comments
                Hide
                Permalink
                psergey Sergei Petrunia added a comment -

                Pushed into 5.5 tree

                Show
                psergey Sergei Petrunia added a comment - Pushed into 5.5 tree
                Hide
                Permalink
                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 =]

                Show
                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 =]
                Hide
                Permalink
                rspadim roberto spadim added a comment -

                PLEASE PUT THIS IN 10.0.4 VERSION =]

                Show
                rspadim roberto spadim added a comment - PLEASE PUT THIS IN 10.0.4 VERSION =]
                Hide
                Permalink
                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.

                Show
                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.
                Hide
                Permalink
                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 !

                Show
                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

                  • Assignee:
                    psergey Sergei Petrunia
                    Reporter:
                    rspadim roberto spadim
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    5 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - 1 week
                      1w
                      Remaining:
                      Remaining Estimate - 1 week
                      1w
                      Logged:
                      Time Spent - Not Specified
                      Not Specified