Beta 6: Build fails on using references on information_schema in own projects

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
MarkBrock
Posts: 33
Joined: Fri 12 Dec 2008 12:31

Beta 6: Build fails on using references on information_schema in own projects

Post by MarkBrock » Thu 14 Mar 2013 08:55

Hi Support Team,

testing Beta 6 version will cause a problem on a project which works in version 5.
I have a function in my project, which references a table of the information_schema of MySQL. A simple select on the table 'information_schema.`COLUMNS`'. When try to build it, it stops build or sync with an error message '3 The name 'information_schema.`COLUMNS`' does not exist in the current context D:\...\f_wbc_SetFlag.sql 18 7' and also the usage of the columns of that table will produce this error (in the same select statement). In version 5 it works without any problem.
MySQL tables should be all available in each context.

Cheers

alexa

Re: Beta 6: Build fails on using references on information_schema in own projects

Post by alexa » Thu 14 Mar 2013 10:46

We were able to reproduce this issue and will fix it in one of the next product builds.

MarkBrock
Posts: 33
Joined: Fri 12 Dec 2008 12:31

Re: Beta 6: Build fails on using references on information_schema in own projects

Post by MarkBrock » Thu 04 Apr 2013 10:01

Hi Support Team,

the problem described was really solved in a newer BEAT version, but today I switched to the RELEASE version of version 6 and the problem is there again. I can't build/sync a project until I have switched of the "verify references" option in the projects DB connection properties.

Another problem (performance) when building a project is, if I switch on the "verify references" option in the projects DB connection properties the verifying will take about 3 minutes instead of 10-20 sec in version 5.

Both problems are not useful and I think about switching back to version 5.

MarkBrock
Posts: 33
Joined: Fri 12 Dec 2008 12:31

Re: Beta 6: Build fails on using references on information_schema in own projects

Post by MarkBrock » Thu 04 Apr 2013 12:35

in additional to the last reply...

when syncing the project it takes much more time on verifying the data after build, just before it shows the result, and while it is "comparing data..." the program is stuck.

alexa

Re: Beta 6: Build fails on using references on information_schema in own projects

Post by alexa » Mon 08 Apr 2013 14:15

We are currently investigating this issue and will answer you as soon as possible.

Post Reply