This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 257457 - SQL warnings are not displayed in output window
Summary: SQL warnings are not displayed in output window
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 8.2
Hardware: PC Windows XP
: P3 normal (vote)
Assignee: matthias42
URL:
Keywords:
: 127597 (view as bug list)
Depends on:
Blocks:
 
Reported: 2016-01-07 11:57 UTC by NukemBy
Modified: 2016-01-19 02:27 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments
Patch (7.15 KB, application/x-zip-compressed)
2016-01-07 11:57 UTC, NukemBy
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NukemBy 2016-01-07 11:57:54 UTC
Created attachment 158044 [details]
Patch

When calling SQL stored procedures having some diagnostic messages generated inside - they are NOT displayed in NetBeans' output window.

With execution of the following SQL code (PostgerSQL) ...

        CREATE OR REPLACE FUNCTION dummy()
            RETURNS timestamp LANGUAGE plpgsql AS $$
        DECLARE
        BEGIN
            raise notice 'dummy as (%)', now();
            return now();
        END $$;

        select dummy();

... I expect following to be displayed in output:

        NOTICE: dummy as (2016-01-07 14:37:44.845092+03)
        Executed successfully in 0 s.
        Line XX, column YY

I've created a patch to fix this, it also includes changes to fix issue https://netbeans.org/bugzilla/show_bug.cgi?id=257363 (otherwise $$-quotes will not be recognized)
Comment 1 matthias42 2016-01-15 22:22:24 UTC
*** Bug 127597 has been marked as a duplicate of this bug. ***
Comment 2 matthias42 2016-01-17 17:03:44 UTC
Once again thank you for for taking the time to give an example and work through the code for a possible solution. I implemented a bit different, but followed the basic idea.

The change was pushed as:

http://hg.netbeans.org/core-main/rev/e59601d1f5c5

In the next few days a nightly build will be produced that contains the fix. By then a message will be posted here. Please check that nightly and if you find this fixed, please change status of this issue to VERIFIED. If not please specify what did not work.
Comment 3 Quality Engineering 2016-01-19 02:27:09 UTC
Integrated into 'main-silver', will be available in build *201601190002* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)

Changeset: http://hg.netbeans.org/main-silver/rev/e59601d1f5c5
User: Matthias Blaesing <matthias42@netbeans.org>
Log: #257457: Log warnings resulting from SQL execution into SQL output window