MS SQL issues

Thank you. Created:
https://youtrack.jetbrains.com/issue/DBE-969
https://youtrack.jetbrains.com/issue/DBE-970

The last issue requires a bit of play around, will do it later. If you can provide a sample script to demonstrate the problem, please do.

Regards,
Alexander.

I wrote a stored procedure in Azure SQL Database. Throughout the stored procedure I added many lines like:
RAISERROR('Reached point X.', 10, 7) WITH NOWAIT;

I thought this might help me with debugging. But yeah, on the “Output” tab, DataGrip doesn't seem to display these informational “error” messages until the stored procedure execution completes. So, it doesn't help. (Because I am debugging a stored procedure that never completes!)

I read through DBE-969, where it says “we shall add [have now added, I assume] async getWarnings() polling for a running statement.” What does this mean? I've searched, but I cannot figure it out. Is there some way for me to fetch these informational “error” messages that have been raised, during the execution of the stored procedure? (Or, ideally, have DataGrip display them in real time?)

Many thanks!

DataGrip 2024.3.3
Build #DB-243.23654.19, built on December 17, 2024
Runtime version: 21.0.5+8-b631.30 amd64 (JCEF 122.1.9)
Windows 11.0

The stored procedure is defined like below. I'm not sure if I should expect it to show the messages that are within the TRANSACTION, before that transaction is COMMITted? But when I start executing the procedure, it doesn't even show the first message ('Started execution!'), which is before the transaction begins.

CREATE PROCEDURE table_x_sync (
    @p1_drop_and_recreate BIT
    ,@p2_incremental_refresh BIT
) AS BEGIN

RAISERROR('Started execution!', 10, 1) WITH NOWAIT;

    BEGIN TRANSACTION;

RAISERROR('Started transaction!', 10, 2) WITH NOWAIT;

        IF @p1_drop_and_recreate = 1 AND @p2_incremental_refresh = 1 BEGIN
            RAISERROR('Both @p1_drop_and_recreate and @p2_incremental_refresh cannot be 1 simultaneously.', 16, 199);
            RETURN;
        END;

RAISERROR('Reached point 3!', 10, 3) WITH NOWAIT;

        IF @p1_drop_and_recreate = 1 BEGIN

            DROP TABLE IF EXISTS table_x;

            CREATE TABLE table_x (
                id INTEGER
                ,[...more columns...]
                ,_adf_synced_at_pacific_brnz DATETIME2(0)
                ,_adf_synced_at_pacific DATETIME2(0)
            );

        END

RAISERROR('Reached point 4!', 10, 4) WITH NOWAIT;

        IF @p1_drop_and_recreate = 0 AND @p2_incremental_refresh = 0 BEGIN TRUNCATE TABLE table_x END

RAISERROR('Reached point 5!', 10, 5) WITH NOWAIT;

        DECLARE @now DATETIME2(0) = CAST((SYSDATETIMEOFFSET() AT TIME ZONE 'Pacific Standard Time') AS DATETIME2(0));

        SELECT ...
        INTO stg_table
        FROM ...

RAISERROR('Reached point 6!', 10, 6) WITH NOWAIT;

        IF @p2_incremental_refresh = 1 BEGIN

RAISERROR('Reached point 7 !', 10, 7) WITH NOWAIT;

            DELETE ...
            FROM table_x
            WHERE...;
        END

RAISERROR('Reached point 8!', 10, 8) WITH NOWAIT;

        INSERT INTO table_x...

RAISERROR('Inserted rows into table_x!', 10, 9) WITH NOWAIT;

    COMMIT TRANSACTION;

RAISERROR('Committed transaction!', 10, 10) WITH NOWAIT;

END;