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

Select With Aes_Decrypt Hangs Intermittently

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Select With Aes_Decrypt Hangs Intermittently

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • January 7, 2010 at 12:19 am #11821
      normk
      Member

      When I try to do a “SELECT AES_DECRYPT(mycol,'KEY') FROM mycol WHERE id=num; “, I noticed that SQLYog hangs intermittently, more than 50% of the time. You cannot stop the query with the X icon on the toolbar. You need to kill the process. We got this condition on several PCs running Windows 7 with SqlYog Enterprise 8.14 for several different tables where the encrypted data is stored in a column of type longtext or mediumtext.

    • January 7, 2010 at 8:01 am #30305
      nithin
      Member

      Hello,

      We haven't reproduced yet

      Inbtw please tell,

      Have you tried this case other OS than Win7?

      What type of connection used (Direct/ssh/http)?

      MySQL version?

      Also can you try with latest stable version 8.2?

      Thank you

      Nithin

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.