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 227479 - SQL EXEC support is broken
Summary: SQL EXEC support is broken
Status: VERIFIED FIXED
Alias: None
Product: cnd
Classification: Unclassified
Component: Code Model (show other bugs)
Version: 7.3
Hardware: All All
: P1 normal (vote)
Assignee: Vladimir Voskresensky
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-03-14 13:50 UTC by Vladimir Voskresensky
Modified: 2013-03-19 09:22 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Vladimir Voskresensky 2013-03-14 13:50:39 UTC 
regression in ProC support.
A lot of unexpected tokens in the following sample:
EXEC SQL DECLARE friends_cursor CURSOR FOR SELECT NAME, SURNAME FROM FRIENDS;

void sql_error() {
    EXEC SQL DECLARE friends_cursor CURSOR FOR SELECT NAME, SURNAME FROM FRIENDS;

    EXEC SQL WHENEVER SQLERROR DO sql_error("database error--");
    
    EXEC SQL CONNECT :username IDENTIFIED BY :password USING :database;

    printf("\nConnected to database as user: %s\n\n", username);
}
Comment 1 Vladimir Voskresensky 2013-03-14 16:10:08 UTC 
http://hg.netbeans.org/cnd-main/rev/dcda0fae96e0
Comment 2 Quality Engineering 2013-03-15 01:46:50 UTC 
Integrated into 'main-golden', will be available in build *201303142300* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/dcda0fae96e0
User: Vladimir Voskresensky <vv159170@netbeans.org>
Log: fixed #227479 - SQL EXEC support is broken
- greedy rule must be after pro_c related one
Comment 3 Vladimir Voskresensky 2013-03-15 19:59:37 UTC 
Patch 1 stopper
Comment 4 soldatov 2013-03-15 21:54:57 UTC 
Verified in trunk 201303142300
Comment 5 Vladimir Voskresensky 2013-03-16 16:38:24 UTC 
transplanted
http://hg.netbeans.org/releases/rev/104acfc1b3ce
+ spec version
http://hg.netbeans.org/releases/rev/b9c40629467d
Comment 6 Quality Engineering 2013-03-18 01:12:00 UTC 
Integrated into 'releases', will be available in build *201303172200* or newer. Wait for official and publicly available build.
Changeset: http://hg.netbeans.org/releases/rev/104acfc1b3ce
User: Vladimir Voskresensky <vv159170@netbeans.org>
Log: fixed #227479 - SQL EXEC support is broken
- greedy rule must be after pro_c related one
(transplanted from dcda0fae96e032935033c6e4e535ea52d372c726)
Comment 7 soldatov 2013-03-19 09:22:26 UTC 
Verified in build 201303172200 and latest Oracle Solaris Studio build