Page 1 of 1

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

Posted: Thu 14 Mar 2013 08:55
by MarkBrock
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

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

Posted: Thu 14 Mar 2013 10:46
by alexa
We were able to reproduce this issue and will fix it in one of the next product builds.

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

Posted: Thu 04 Apr 2013 10:01
by MarkBrock
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.

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

Posted: Thu 04 Apr 2013 12:35
by MarkBrock
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.

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

Posted: Mon 08 Apr 2013 14:15
by alexa
We are currently investigating this issue and will answer you as soon as possible.