Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantActually we do this already!
Try
1) type “create table tttt (id int);”
2) execute it
3) now type “select * trom tttt.”
4) Autocomplete pops up 'id'
The working is like this:
* When a connection is established we load the disk database for that connection into memory.
* Whatever CREATE/ALTER/DROP statements are sent to MySQL has effect (as INSERTs, UPDATEs and DELETEs) in the working SQLite copy kept in memory.
* When connection is closed the working copy in memory is 'committed' to disk. And it is here the problem is! Because those data in the in-memory copy of the database *should not be* commited for temporary objects. To manage that, I think we basically need a column more in the table that tells for every row if the object is temporary or not, and all code will need to be adjusted to handle that extra column. That is the reason why it is not *plain simple* to implement. Of course also the parser code will need to handle TEMPORARY keyword (but I believe this is a rather simple regular expression only so probably not a big issue).
peterlaursen
ParticipantWe have started the release cycle for 7.12 RC. Please check with this one once it is announced. I expect around one hour from now.
peterlaursen
ParticipantTher are two discussions here
1)
MySQL itself does not expose temporary tables
Try yourself this
Code:create database tttest;
use tttest;
create temporary table tt (id int); — 0 row(s) affected (no error – what means successful)
show tables; — 0 row(s) returned — no error what means statement successful, but table tt not exposed by SHOW TABLES
create temporary table tt (id int); — error: table allready exists
drop table tt; — 0 row(s) affected (no error – what means successful)Basically SHOW TABLES implicit means SHOW *GLOBAL* TABLES. Temporary tables are not global – they are session/connection specific and MySQL does not support SHOW LOCAL/SESSION TABLES or other statements providing this info. Same applies to SHOW FULL TABLES, SHOW TABLE STATUS and SELECT … FROM Information_Schema. There is no way to have the server information about (temporary) tables for the session/connection!
If you search http://bugs.mysql.com you will find similar requests (I posted at least one myself). Basically this is a request that should be adressed to MySQL and not to Webyog! We cannot 'guess' if the server does not provide the information! So TABLES in general in MySQL are quite different than TEMPORARY TABLES
2)
But you can say that we could record CREATE, ALTER and DROP statements for temporary tables locally (in memory). Let us discuss if this is possible!
FYI: the basic concept/logic is that
— a CREATE with MySQL causes an INSERT to SQLite
— an ALTER with MySQL causes an UPDATE to SQLte
— A DROP with MySQL causes a DELETE to SQLite
peterlaursen
ParticipantOk .. I will ask the team to post a link when office opens tomorrow morning Indian Time.
peterlaursen
ParticipantWe believe we have fixed this now. It would be nice if you could verify on your system. I can provide a link to an internal build. Please tell: are you COMMUNITY or ENTERPRISE user?
peterlaursen
ParticipantThe tar.gz will run as user who started it. The rpm build depends on OS. Don't you have some tool that can tell you (I am not sure about command but I would use KSysGuard GUI)?
Also if you add monyog user to 'mysql' group (what you will need to use the MONyog 'proceslist' feature fully), write access for group should be enough.
peterlaursen
ParticipantI know that one of the guys (Supratik) compiled with Winelib (and possibly WxWidgets too) (and on both Linus and Mac actually using the standard compilers on those systems (gcc on Linux, which one on Mac I do not know). It compiled but there were issues.
Problem is basically that a *good enough* library msut exist to replace the WIN32 API. I think Supratik is busy with something else for up to a couple of months but it is intended that he should solve this!
Maybe he can give you a hint after MG day!
peterlaursen
ParticipantAlso this was already requested!
http://code.google.com/p/sqlyog/issues/detail?id=308
Please search issue tracker and Forums before posting!
We are trying very hard to 'catch up' wiht those small and medium request – mostly posted by non-paying COMMUNITY users.
Actually we did a lot since 7.0 release as regards this
But we have to dedicate resources to more complex requests requested by (paying) ENTERPRISE users .. (but of course I cannot tell to what category you belong!) . Best way to get focus on a feature request is topurchase and next report to our tickets with purchase details information! 😆
peterlaursen
Participantnot currently!
We have such requests already: http://code.google.com/p/sqlyog/issues/detail?id=275
peterlaursen
ParticipantWe were able to reproduce this on a Linux/Wine system.
peterlaursen
Participant1) Please tell: Were you running the two versions on same OS and Wine version?
2) Please also tell Wine version. Was that one updated in between?
There were only very small changes in our code since 6.5 where the tree-view control was introduced in copy dialogue
– I think only what changelogs for 7.01 say “When SQLyog tried to reconnect while exporting a crash could occur. This bug was introduced in 7.0 with the speed optimization of the export dialogue.” So there was an optimization in 7.0 and a small fix in 7.01.
However in Schema Sync we had some issues with the tree-view in Wine described in changelogs for 7.1 like this “In Wine Schema Sync could generate an erroneous sync script (specific functions on Wine functioned slightly different than the original Win32 API).” Basically some function in Wine tree view control API did not return what it should. So this could explain this behaviour.
To debug we need to reproduce and we need you tell us Wine version. (and we have doublechecked now that there is no such issue in Windows)
peterlaursen
Participant“I have the permissions setup so the mysql user can read them”. Well .. that will not help MONyog to read them! MONyog does not run as user 'mysql'.
What is permission for the files? Please try for a start to give global read permission (444 or larger in octal notation).
peterlaursen
ParticipantI think most users will not specify a database in connections manager and will want to navigate in the object tree. Also I think it is 'overkill' to provide a 'preference' for that.
peterlaursen
ParticipantProblem is that to populate the GUI interface, we will need to query the server about 'metadata'. We mainly use SHOW statements for that. SHOW is a non-standard extension to SQL, only supported by MySQL.
Currently there is no actvity supporting other RDMS.
peterlaursen
Participant1)
Please see release notes for 7.1 “* Added an option in Preferences to ‘Automatically refresh DATA tab on focus’. This was the program behavior before 7.0. In 7.0 to 7.02 it was not. Now it is optional.”. I think that it will solve to check this option. Could you try with 7.11? .. and also simply pressing 'refresh' after import should do I think!
2)
To avoid the CSV you can import to Access and use the Migration Tool (ENTERPRISE feature)
-
AuthorPosts