Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Enormous Bug In 5.18, Fixed In 5.19?

forums forums SQLyog SQLyog: Bugs / Feature Requests Enormous Bug In 5.18, Fixed In 5.19?

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • #22454
      peterlaursen
      Participant

      One thread per question only please!

      Does this answer you question?

      http://webyog.com/faq/28_70_en.html

      EVERY database client does so, with identical rows!

      If not then explain your self more in detail.

    • #22455
      peterlaursen
      Participant

      Now ..

      It seems that I have a mail from a developer. There is an issue. I do not usnderstand details. It is fixed in the 5.2 beta 4 tree, I was told

    • #22456
      peterlaursen
      Participant

      What we can reproduce with this schema is that if more rows have the same value for the numerical field and you change that numerical field (not a text filed) SQLyog sends SQL like

      Code:
      update `tbl_requetes` set `Req_ID`='abc',`Req_Sql`='def', `Req_Param`='ghi' ,`Req_Description`='jkl' ,`Req_Type`='2' ,`Req_Libelle`='mno' where `Req_Type`='1';

      what results in all rows having `Req_Type`='1' to become updated even if the text fileds are not identical.

      The where-clause:

      Code:
      where `Req_Type`='1';

      would be OK if that field was a PK. But it is not and it is a bug.

    • #22457
      peterlaursen
      Participant

      … but you really SHOULD have a primary key in the table because without a PK the WHERE-condition must include all columns. With such WHERE MySQL cannot use indexes at all and with some data in the database an update can be very slow.

      BTW: do you have any particular reason to use TEXTs for all fields and not VARCHARS ?

Viewing 3 reply threads
  • You must be logged in to reply to this topic.