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

Inconsistent Sql Reult Sets

forums › forums › SQLyog › Using SQLyog › Inconsistent Sql Reult Sets

Tagged: 

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • March 21, 2015 at 7:27 pm #35255
      peterlaursen
      Participant

      Why do you think this is an issue with SQLyog? it is the MySQL server that executesthequery and returns the result set. Please try n another client (‘mysql’ command line, phpMyAdmin or whatever you have acces to) and check here. 

       

      I think it would bemore appropriate tor eport this to bugs.mysql.com, if you think it is a bug in the server: And you should always mention the server version in such reports BTW. 

       

       

      You are of course welcome to ask users of our Forums (and us). But we would need a full test case with table structure and data to verify. And in principle we support or own programs and not the MySQl server. 

    • March 21, 2015 at 8:08 pm #35256
      shew
      Member

      Hi Peter,

       

      Fair enough. Thanks. You are right. I had just become so used to working within the SQLyog interface that I forgot what was really going on.

       

      I have decided it must be an issue with the indexes and am going to pursue that angle.

    • March 24, 2015 at 11:50 am #35257
      peterlaursen
      Participant

      If indexes or not makes a difference on what result set is returned, it is a bug with the server.

       

      Indexes should only matter for performance of the query and the amont of memory the server uses when executing the query – not the result.  If it is reproducible on a current server version, I think you should post a bug (with a test case suffiient to reproduce) to bugs.mysql.com

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.