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

Forum Replies Created

Viewing 15 posts - 2,611 through 2,625 (of 7,398 total)
  • Author
    Posts
  • in reply to: #27495
    peterlaursen
    Participant

    Actually 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).

    in reply to: #27475
    peterlaursen
    Participant

    We 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.

    in reply to: #27493
    peterlaursen
    Participant

    Ther 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

    in reply to: #27474
    peterlaursen
    Participant

    Ok .. I will ask the team to post a link when office opens tomorrow morning Indian Time.

    in reply to: #27472
    peterlaursen
    Participant

    We 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?

    in reply to: #27464
    peterlaursen
    Participant

    The 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.

    in reply to: #27488
    peterlaursen
    Participant

    I 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!

    in reply to: #27485
    peterlaursen
    Participant

    Also 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! 😆

    in reply to: #27479
    peterlaursen
    Participant

    not currently!

    We have such requests already: http://code.google.com/p/sqlyog/issues/detail?id=275

    in reply to: #27470
    peterlaursen
    Participant

    We were able to reproduce this on a Linux/Wine system.

    in reply to: #27469
    peterlaursen
    Participant

    1) 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)

    in reply to: #27462
    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).

    in reply to: #27375
    peterlaursen
    Participant

    I 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.

    in reply to: Postgresql Support Expected? #20735
    peterlaursen
    Participant

    Problem 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.

    in reply to: #27468
    peterlaursen
    Participant

    1)

    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)

Viewing 15 posts - 2,611 through 2,625 (of 7,398 total)