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

drop constraint problem

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › drop constraint problem

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • December 2, 2003 at 9:51 am #8259
      Shadow
      Member

      I wanted to drop a constraint from an InnoDB table, but SQLyog came back with 140: wrong create options. Apparently the temporary table could not be created. Any idea?

    • December 2, 2003 at 10:12 am #15277
      Ritesh
      Member

      SQLyog logs all the queries in the History window. Just check out the query that is returning error :huh:

    • December 2, 2003 at 9:46 pm #15278
      Shadow
      Member

      The create table command for the temporary table fails. It's getting more interesting as I manually executed the steps that SQLyog is supposed to do when dropping the table, and everything went smoothly. The drop constraint option, however, doesn't work even after repeated attempts. I will work on the issue tomorrow.

    • December 3, 2003 at 8:24 am #15279
      Shadow
      Member

      I believe, I found the problem: MySql (not SQLyog) tried to create the temporary table's file with illegal character (“?”) in its name.

    • December 4, 2003 at 2:34 am #15280
      Ritesh
      Member

      Great 😀

    • December 4, 2003 at 7:58 am #15281
      Shadow
      Member

      Well, not that great, we have an app that regularly creates temporary tables. What if it fails beacause of MySql creating temporary tables with illegal characters in their names?

    • December 4, 2003 at 9:22 am #15282
      Ritesh
      Member

      Hmmmm..

      Maybe you can put it in the MySQL Bug List :huh:

    • December 4, 2003 at 10:03 am #15283
      Shadow
      Member

      I have already sent them an e-mail. It seems, however, that certain sessions create temp tables this way. If a session fails to create a temp table once because of this bug, then it won't stop. “Fortunately,” it is MySql 4.1-alpha. I wish, MySql released a beta (at least…)!

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