Bug? Execute Query Doesnt Respect Current Database

This topic is empty.

Viewing 8 reply threads

Author

Posts
- April 21, 2005 at 2:07 am #8927
  
  hjo
  Member
  
  I've found behaviour with the Execute Query (Execute Batch File) dialog that doesn't match earlier versions (I think I was previously using 4.0.3). I have a bunch of scripts that don't specify a database – the reason being is that the scripts must be applied against a few different databases that have similar schemas. As such, I would normally select the database I want to use from the drop down (on the top toolbar), then execute the script.
  
  In the past this would work just fine. Now I continually get errors like this:
  
  Line no.:1
  
  Error Code: 1046 – No database selected
  
  Query:
  
  alter table listing_groups add modifiedTimeStamp timestamp
  
  I believe this behaviour is a bug as the Execute Query dialog appears to recognise what the Current Database is (it writes it in bold), but it doesn't actually do anything about it anymore when running the script.
  
  Any chance of getting this fixed soon?
- April 21, 2005 at 3:35 am #17476
  
  peterlaursen
  Participant
  
  I agree there is a problem. I have experienced that too recently. Not every time but from time tt tome.
  
  However it should work to click on the DB in the Object Browser (or choose from the drown down as you do – I think it does exactly the same).
  
  In my case it has always been possible to solve the problem to close sqlyog at start it again. But of course that's not perfect …
- April 21, 2005 at 4:59 am #17477
  
  Ritesh
  Member
  
  Bug confirmed.
  
  Will be fixed in v4.06.
- April 21, 2005 at 11:53 am #17478
  
  just4fun
  Member
  
  Ritesh mb you make update utilitie?
  
  This is a small bug, but write use `database`; in all my *.sql files… brrr… pleeeaze
  
  p.s. i'm use unlegal sn 🙄
- April 21, 2005 at 7:55 pm #17479
  
  jjmendezg
  Member
  
  *** FEATURE REQUEST ***
  
  In the same ExecuteBatchFile 's error dialog, could you please add a button for viewing the SQLYOG.ERR file ?
  
  Thanks
- April 28, 2005 at 2:43 am #17480
  
  Ritesh
  Member
  
  Quote:
  
  i'm use unlegal sn
  
  😮 😮
- April 30, 2005 at 3:06 am #17481
  
  Ritesh
  Member
  
  Quote:
  
  *** FEATURE REQUEST ***
  
  In the same ExecuteBatchFile 's error dialog, could you please add a button for viewing the SQLYOG.ERR file ?
  
  Thanks
  
  Will be added in v4.1.
- April 30, 2005 at 10:24 am #17482
  
  zzapper
  Member
  
  Cool
- May 2, 2005 at 12:55 pm #17483
  
  Ritesh
  Member
  
  v4.06 BETA has been released. Check http://www.webyog.com/forums/index.php?act…&st=0#entry5252 for more details.
Author

Posts