[peterlaursen]

I do not remember details but FLOAT type implementation has changed with different MySQL versions. I think what was earlier (4,2) may be now (6,2), but not sure. We will check this of course! We will prefer to solve it and not display warnings!

I do not consider this an emergency however!

BTW: I do not understand why you do not use DECIMAL for money! That is actually what it is intended for primarily! DECIMAL(19,4) is commonly used (4 digits after decimal sign is normally what is required to compesate for rounding errors) for MONEY.

DECIMAL is a high precision numerical type, FLOAT is inaccurate (optimized for performance (and for use with very small (molecular) and very big (astronomic) numbers where exact numbers are 'out of range')).

But also DECIMALs have changed between versions! But I think that only refers to storage format (string/binary storage)

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

… says

“types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION).”

[peterlaursen]

hmmm …

we will look into this tomorrow morning.

it will speed up the process if you attach (and zip!) a small dump from 3.23 with such data where this is reproducable!

did you try to export/import or data sync?

[peterlaursen]

yes …

if you grant privileges from EDIT/ADD USERS they will be GLOBAL privileges.

To grant privileges for specific databases, tables etc use the menu 'manage permissions'

So from EDIT/ADD USERS do not check anything, next go to 'manage permissions'.

[peterlaursen]

better image here!

[peterlaursen]

Please see attached image! So simple really if I understand correct!

It is the LINES that will have to be terminated with comma.

As there is only a single value in every line the settings for FIELDS don't take any effect!

[peterlaursen]

Please refer to the release notes of 6.07!

6.07 should solve it. Please try!

[peterlaursen]

If I understand you right this is not reproducable for me with 6.06 and 6.07 final.

Please try 6.07 and tell if it is still an issue for you!

If it still is I probably do not understand and may need a more detailed description (screenshot?)

[peterlaursen]

Just like your post about Stored Procedures this is a MySQL issue.

1) MySQL returns the create statement like that

2) the setting if preferences can only have effect on statements generated by SQLyog – not whne a complete CREATE statement is returned by the MySQL server.

You may say and think that we should do some parsing and formatting on the client side.

We try to avoid it. We think MySQL AB should solve those issues!

[peterlaursen]

we cannot help that! MySQL itself does not save your formatting properly. When we copy we get what MySQL has stored!

There are several complaints about this in MySQL bugs page and Forums! And it is even worse with VIEWs!

Try execute SHOW CREATE PROCEDURE yourself and copy/paste into an editor.

[peterlaursen]

Now I think I understand.

You simply want to save this SQL snippet as a literal string?

Please try to enclose the string in `backquotes`!

Alternativley disable 'smart keywords and functions' in preferences.

I think SQLyog her attempts to evaluate as a function, refer to

http://webyog.com/faq/8_116_en.html

Please reply back if that was the issue!

[peterlaursen]

We have fixed an(other ?) issue reported by another customer where the program enters an infinite loop when executing SET CHARSET after a reconnect.

This bug was introduced in 6.06 when we re-enabled reconnect in Structure Sync (that was accidentially removed in 6.0).

You may try if it makes any difference for your issues:

http://www.webyog.com/downloads/betas/not_…QLyog607Ent.exe

[peterlaursen]

First: please attach the DUMP file!

Next: you write you can 'alter' a table and this popup occurs. Do you mean ALTER TABLE (structure) or edit data? And it ONLY occurs when particular this particular operation?

[peterlaursen]

ok .. SJA is crashing or the system 'knocks it down' for some reason.

I think we should first check with Ubuntu! What Ubuntu version do we have here?

[peterlaursen]

I am afraid I do not understand this

“When I copy/paste the sentence “TO_DAYS(NOW()) – TO_DAYS(database.table.entdate) > 365″ in the filter column”

Where is that 'filter column'? in SQLyog?

I also do not understand

1) where you use PHP and where you use SQLyog

2) what works in SQLyog 4 (or 5) and not in 6?

A few screenshots may tell more than words!

[peterlaursen]

Inspiration from here:

http://www.google.com/search?client=opera&…-8&oe=utf-8

Is the program 'ksysguard' installed? Is is the standard KDE system monitoring tool, but nowadays GNOME supports several KDE applications and vice versa! (note that UPPERCASES may be used for some letters!)

[Author]

Posts