Tool - Find invalide Objects

[Ben2003]

== English ==

Version: Beta 2020 (9.0.269)
Hi,

When searching for invalid objects, objects are also displayed in which there is no error.

Example:

CREATE DEFINER = `service charge settlement` @`% `PROCEDURE` proc_searchPLZOrt` (IN searchPLZ VARCHAR (255), IN searchOrt VARCHAR (255))
BEGIN
   SET searchPLZ = CONCAT (searchPLZ, "%");
   SET searchOrt = CONCAT (searchOrt, "%");
   SELECT
     qpo.PLZ,
   CONVERT (qpo.Ort USING utf8) location
     FROM qry_PLZ_location qpo
   WHERE ZIP LIKE searchPLZ
   AND location LIKE search
END

In this object, among other things, in the line ...
SET searchPLZ = CONCAT (searchPLZ, "%");
... the characters "%" complained: The '%' does not exist in the 'proc_searchPLZOrt'.

However, the stored procedure runs without errors.

Does the search also find incorrect views that can no longer be opened correctly?

== German ==
Version: Beta 2020 (9.0.269)
Hallo,

Bei der Suche nach ungültigen Objekten werden auch Objekte angezeigt, in denen kein Fehler vorliegt.

Beispiel:

CREATE DEFINER=`nebenkostenabrechnung`@`%` PROCEDURE `proc_searchPLZOrt`(IN searchPLZ VARCHAR(255), IN searchOrt VARCHAR(255))
BEGIN
SET searchPLZ = CONCAT(searchPLZ, "%");
SET searchOrt = CONCAT(searchOrt, "%");
SELECT
qpo.PLZ,
CONVERT(qpo.Ort USING utf8) Ort
FROM qry_PLZ_Ort qpo
WHERE PLZ LIKE searchPLZ
AND Ort LIKE searchOrt;
END

In diesem Objekt wird unter anderem in der Zeile ...
SET searchPLZ = CONCAT(searchPLZ, "%");
... die Zeichen "%" angemeckert: The '%' does not exist in the 'proc_searchPLZOrt'.

Die Stored Procedure läuft allerdings fehlerfrei durch.

Werden bei der Suche auch fehlerhafte Views gefunden, die nicht mehr fehlerfrei geöffnet werden können?

[alexa]

We will investigate this issue and will answer you as soon as possible.

[alexa]

We were able to reproduce this issue and will fix it in one of the next product builds. We will notify you once it's available for downloading.