75 results found
-
bug in table edition with graphic table editor
the table designer has a BUG. A table column can have as a default value an internal server variable, in my case @@bindaddress. The correct way to add it (@@bindaddress), and it works. But when the table editor reverses a table definition, it misinterprets these defaults and saves it back wrong.
1 vote -
Allow variable identifiers to be user defined to accommodate multiple environments.
We are unable to define delimiters for variables. This causes query code from dbForge to fail when copied to a java based production environment.
Currently the dbForge variable delimiters are not compatible with many environments.
Provide means for users to define variable delimiters like DbVisualizer does.
2 votes -
"Modify via SQL" always Refresh automatically before opening Editor
When we work in Stored Procedures we already overwrote accidentially code as we were working in different windows and worked on an old version of the code
It is annoying to always need to refresh first to make sure that no old copy of the code is edited.
3 votes -
9.2.105 Bug -- Cannot connect (SSL) to AWS Aurora MySQL
Using identical configuration and credentials, v9.2.34 (and previous versions) connects to my AWS Aurora MySQL instance over SSL. However, the v9.2.105 update does NOT connect. It returns a dialog stating "SSL connection error (2026): The server hello message uses a protocol that was not recognized."
I tried many configurations, but none worked. Uninstalled and downgraded, worked on first try. Updated to latest and repeated test, same failure.
1 vote -
Separate DEFINER and SQL SECURITY in exclude backup options
It only makes sense to combine these two options when SQL SECURITY is set to DEFINER. In the other case (INVOKER) it will cause a problem if the DEFINER is specified when restoring the database to a different environment - user will not exist or will not have the right privileges. "Exclude DEFINER" and "Exclude SQL SECURITY" should be two separate options when backing up a database.
3 votes -
Erro no atalho
Erro no atalho , como copiar e colar... ctrl+q para filtrar... f5 para execultar
1 vote -
Compare data bases lists table as different, thought they are the identical
When comparing databases, we constantly get the tables with no differences. And final script doesn't have any alter statements.
Ex.: the table
CREATE TABLE SecurityContextXSiteGroup (
SecurityContextId INT NOT NULL,
SiteGroupId INT NOT NULL
)
ENGINE = INNODB,
CHARACTER SET utf8mb4,
COLLATE utf8mb40900ai_ci;ALTER TABLE SecurityContextXSiteGroup
ADD UNIQUE INDEX SecurityContextXSiteGroup_UN(SecurityContextId, SiteGroupId);ALTER TABLE SecurityContextXSiteGroup
ADD CONSTRAINT SecurityContextXSiteGourp_FK FOREIGN KEY (SecurityContextId)
REFERENCES SecurityContext(SecurityContextId) ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE SecurityContextXSiteGroup
ADD CONSTRAINT SecurityContextXSiteGourpFK1 FOREIGN KEY (SiteGroupId)
REFERENCES SiteGroup(SiteGroupId) ON DELETE CASCADE ON UPDATE CASCADE;The other table ("differs"):
CREATE TABLE SecurityContextXSiteGroup (
SecurityContextId INT NOT…1 vote -
Facilitate MariaDB 10.11
The current version of DB fORGE STUDIO supports up to MariaDB 10.6 which is limited in respect of JSON functionality. With respect to querying you cannot join a regular table on a JSON path or use methods like JSON_TABLE(). Such efforts result in an error.
1 vote -
There is a problem using "groups" word as name for table or part of a stored procedure
There is a problem using "groups" as a name for a table or using that word as part of a stored procedure.
I have a table named like this and when trying to make a backup I always get the same error message: Unexpected symbol 'groups'
If I try to compare 2 schemas it also fails.
In my case I use dbForge Studio for MySQL Professional Edition v9.1.21
3 votes -
Profiling for queries with CTEs
When running the query profiler on a query that contains CTEs, the results are not accurate and the Explain Plan section does not appear in the profiler tree.
To profile queries with CTEs I have to re-write them as subqueries which is a waste of time and makes it more difficult to read.
1 vote -
update grid alert
When choosing to edit a record from a select, an alert always appears that shows us the following:
"Unique key is missing"
This in previous versions only appeared when you did not indicate the primary key. Now it always appears even if it is a select * from anytable;
9 votes -
Selected cell of Data-Compare goes blank
Awesome product btw - (just) one annoying bug:
This relates to the top part of the data compare section; any selected cell to pick a related view turns white and doesn't show the number anymore - just the checkbox. Same for the source or target object name.
(Moving away to see the number again resets the list view; looking at the tag bubble of the list requires searching the columns since the position is always shifting based on the length of all numbers. Not so much fun on large data sets)
Thanks for your fantastic work,
Regards,
Martin.(customer since…
1 vote -
убрать дурацкое модальное окно "невозможно распарсить код" во время редактирования SQL
убрать дурацкое модальное окно "невозможно распарсить код" во время редактирования SQL
3 votes -
1 vote
-
Character set 'perlogicalinterfacedtoview' is not supported
Comparing two databases I encounter this error.
I have selected "Detect mysql charset" as I am advised by the error message.
However I keep receiving this error.
Is there a way to manually add some encodings?
I have updated the application to the latest update.
DB forge Studio for Mysql Pro.1 vote -
Add support for "Stored Aggregate Functions"
The ability to create stored aggregate functions was added in MariaDB 10.3.3. but dbForge do not read they.
https://mariadb.com/kb/en/stored-aggregate-functions/
I see the functions in the tree, but when I try to open they I get an error like "Unable to parse source text", and when I try to backup a database that contains Stored Aggregate Function it fails.
3 votes -
Export to MS Excel 2007
Currently, exporting to MS Excel 2007 more than 1048576 rows, dbForge doesn't slipt to a new Sheet the remaining rows.
1 vote -
You have a bug, this stored procedure has legal text, you can compile it, but it cannot be edited by the tool.
You can compile this stored procedure but you cannot edit with your tool, it says that the code is wrong, but it is not.
CREATE DEFINER = 'root'@'%'
PROCEDURE simulation.comparebill()
BEGIN
with mybill AS(
with billing AS(select c.day AS day,c.code AS code,cast(c.seconds as double) / 60.00 AS Mins,
case when r.code is null then 0.005 when c.jurisdiction = 'Inter' THEN
r.inter when c.jurisdiction = 'Intra' then r.intra else greatest(r.intra,r.inter) end AS rate,
ifnull(r.description,'Missing Destinations at $0.005') AS description
from (cdr c INNER join ratedeck r on(c.code = r.code))) select billing.day AS day,billing.description AS description,
round(sum(billing.Mins),2) AS Minutes,
round(sum(billing.Mins * billing.rate),2)…1 vote -
Code for CREATE TABLE with MariaDb "system versioning" is not generated correctly.
On a table with system versioning, from context menu I select:
Generate script as > CREATE > To new SQL window.
And the output does not include SYSTEM VERSIONING data at all.
When I run SHOW CREATE TABLE tablename - I get correct information.The same with "Edit table"
(In general it would be nice to set, if "Generate script" uses dbForge engine, or from database "SHOW CREATE TABLE", because output sometimes is drastically different)2 votes -
Show/Hide additional document views
With new DBForge update (2020), keyboard shortcut to show/hide additional document views is gone. Please add this feature back as it was extremely convenient to show/hide data results when writing long procedures.
5 votes
- Don't see your idea?