[peterlaursen]

Now see attached.

Note that in table 'mp3_filer' I have colums named identically to the VIEWS – except for the lettercase.

Is that what destroys the autocomplete functionality here?

Additional

1)

Also if I write:

“SELECT kunstner from mp3_filer” – there is no tooltip with subsets of 'kunstner' such as 'kunst' and 'kunstn'!

but as soon as I write:

“select Bitr” autocomplete tooltip displays 'Bitrate'

2) After adding the VIEW 'testview' defined like

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `testview` AS (select _latin1'test' AS `test`)

'testview is not available with autocomplete at all. Not after 'rebuild tags' either.

This 'ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER' was added by MySQL – I did not write that.

Also 'select_latin1' was added by MySQL. BTW: don't we miss a SPACE character here?

A complete (structure-only) export of the database attached. You have the data to fill in if you need!

[peterlaursen]

Nope! it does not. No change!

[peterlaursen]

@Ritesh

do you mean to say that beta9 fixes the issue that I reported?

[peterlaursen]

additional.

I tried deleting TAGS folder. Connected to MySQL 5.0.21. After 'rebuild tags' from 'powertools' VIEWS are found by TAB and CTRL+SPACE. But not TOOLTIP.

[peterlaursen]

I did this.

1) started 5.1.9 on port 3307 and copied 'musik' database on 5.0.21 to 'nymysik' database on 5.1.9. The 'automatic' 'rebuilt tag started after copy.

2) After that views were not available from autocomplete. Neither TAB, CTRL+SPACE or TOOLTIP

3) rebuilt TAGS manually

4) Now TAB and CTRL+SPACE both find the views, but still no TOOLTIP.

Same on MySQL 5.1.9 as on 5.0.21.

[peterlaursen]

This is a preety old database. I think it was originally created with the first MySQL 5.x I had installed and VIEWs were created with YOG 4.07 or 4.1 of the time I think.

Now they ARE in the TAG-file as autocomplete TAB and CTL+SPACE finds it. But no tooltip!

On request I just rebuilt TAGs (for 27th time 🙂 ). Same thing.

MySQL is 5.0.21. I try copying to 5.1.9. Wait for it.

It is not the 'DEFINER' thing again that cheats the query done by 'TOOLTIP' functionality ??

[peterlaursen]

As of now NULL and (NULL) are synonyms with the grid, as DEFAULT and (DEFAULT) is.

To me just NULL and DEFAULT would have been OK … but no need to change it now.

[peterlaursen]

I have too!

And that is why we use 'CAPTCHAS' in the FAQ.

But I do not know if this Forums Software has this option.

[peterlaursen]

I think this was copied from 5.0.21.

BTW you should get rid of 5,1,6. Pretty old version 5.1.9 is out!

The 'DEFINER' thing was added recently as a security enhancement.

[peterlaursen]

more info please!

My car wont start!

Os version? server version ?? al that stuff.

It does not crash here!

[peterlaursen]

see attached. No tooltip here. Pressing TAB find 'albumtitel'.

However in table mp3_filer I have a column 'Albumtitel', but same thing if I create a 'petertest' VIEW.

VIEW definition:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `albumtitel` AS select count(0) AS `##`,`mp3_filer`.`Albumtitel` AS `Albumtitel`,`mp3_filer`.`Genre` AS `Genre`,`mp3_filer`.`Kunstner` AS `Kunstner` from `mp3_filer` where ((`mp3_filer`.`Kunstner` is not null) and (`mp3_filer`.`Albumtitel` is not null)) group by `mp3_filer`.`Albumtitel`,`mp3_filer`.`Kunstner`,`mp3_filer`.`Genre` order by `mp3_filer`.`Albumtitel`,`mp3_filer`.`Kunstner`,`mp3_filer`.`Genre`

[peterlaursen]

@ I did not understand that ..

What do you mean ?

[peterlaursen]

MySQL docs now say:

http://dev.mysql.com/doc/refman/5.0/en/upg…g-from-4-1.html

Incompatible change: Before MySQL 4.1.13/5.0.8, conversion of DATETIME values to numeric form by adding zero produced a result in YYYYMMDDHHMMSS format. The result of DATETIME+0 is now in YYYYMMDDHHMMSS.000000 format.

So I think SJA must do TRUNCATE(datetime + 0) to fit all versions 😮

[peterlaursen]

@Ritesh

The issue that I reported does also occur with a fresh installation.

The 'rebuild tags' from program start-up does not find procedure 'yyyyyyyyyy' – the 'rebuild tags' from 'powertools' menu does.

[peterlaursen]

I fear it may repeat itself next you build a SP.

Could you try that?

[Author]

Posts