[BUG] dbForge Studio 2020 MySQL Enterprise - IDE doesn't allow corrected references in Stored Procedures

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Requnix
Posts: 113
Joined: Thu 12 Dec 2019 19:41

[BUG] dbForge Studio 2020 MySQL Enterprise - IDE doesn't allow corrected references in Stored Procedures

Post by Requnix » Wed 07 Oct 2020 21:36

Version: 9.0.391
Platform: Windows 10

I'm pretty sure this is a bug in the IDE since the code works fine in my execution window.

Code: Select all

SELECT COUNT(DISTINCT(ilm.FROM)) FROM import_linkedin_messages ilm WHERE DIRECTION = 'OUTGOING';
Of course the column name of FROM is not proper naming convention - in this example it's from an imported file. But the code should still work. Once again; this code works fine in the execution window (and executes fine).

The errors are:
Unexpected symbol 'ilm' and Unexpeted symbol ')'.

Renaming the Columns solves the problem:

Code: Select all

SELECT COUNT(DISTINCT(ilm.ic_FROM)) FROM import_linkedin_messages ilm WHERE ic_DIRECTION = 'OUTGOING';
Here's the table details:

Code: Select all

SET NAMES 'utf8mb4';

--
-- Set default database
--
USE empowercrm_main;

--
-- Create table `import_linkedin_messages`
--
CREATE TABLE import_linkedin_messages (
    ID int NOT NULL AUTO_INCREMENT,
    `FROM` varchar(100) DEFAULT NULL,
    `TO` text DEFAULT NULL,
    DATE datetime DEFAULT NULL,
    SUBJECT varchar(150) DEFAULT NULL,
    CONTENT text DEFAULT NULL,
    DIRECTION varchar(50) DEFAULT NULL,
    FOLDER varchar(50) DEFAULT NULL,
    PRIMARY KEY (ID)
)
ENGINE = INNODB,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_unicode_ci;

alexa

Re: [BUG] dbForge Studio 2020 MySQL Enterprise - IDE doesn't allow corrected references in Stored Procedures

Post by alexa » Thu 08 Oct 2020 08:11

We will fix this issue in one of the next product builds.

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: [BUG] dbForge Studio 2020 MySQL Enterprise - IDE doesn't allow corrected references in Stored Procedures

Post by dzhanhira » Wed 03 Feb 2021 15:03

We have a new release with a lot of fixes for you.

The new release can be downloaded here: https://www.devart.com/dbforge/mysql/st ... nload.html
Please, let us know if the problem persists.

Vladimirgzv
Posts: 1
Joined: Sat 19 Dec 2020 07:30

Where is Administration forums.devart.com?

Post by Vladimirgzv » Thu 01 Apr 2021 02:51

Where is admin?
It is important.
Thanks.

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: [BUG] dbForge Studio 2020 MySQL Enterprise - IDE doesn't allow corrected references in Stored Procedures

Post by dzhanhira » Fri 02 Apr 2021 06:34

Feel free to ask here or if it's something personal you can contact our support.

Post Reply