SP Debug using tempory table created in SQL Editor

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
EduardoFornaro
Posts: 1
Joined: Tue 04 May 2021 19:27

SP Debug using tempory table created in SQL Editor

Post by EduardoFornaro » Tue 04 May 2021 19:36

Hi,

I installed the trial version for testing. I opened a new SQL Editor and created a temporary table. Now I need to debug a Stored Procedure that will use this temporary table. The problem is that the SP debugging window cannot see the temporary table created in the other window (SQL Editor). It looks like they are isolated connections. How can I share the temporay table with my SP?

Grateful,

Edward

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

Re: SP Debug using tempory table created in SQL Editor

Post by dzhanhira » Fri 14 May 2021 06:32

Unfortunally, it's not possible. In order for the temporary table to participate in debugging, it must be created inside the procedure.

Post Reply