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 86276 - SQLEditor: statement not executed if there is whitespace at end
Summary: SQLEditor: statement not executed if there is whitespace at end
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 5.x
Hardware: All All
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-10-02 01:22 UTC by _ jimdavidson
Modified: 2007-07-31 14:45 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 _ jimdavidson 2006-10-02 01:22:28 UTC 
In Runtime, drill down to Databases -> sample -> Customer -> View Data

SQLEditor appears, with command 'select * from "APP"."CUSTOMER"'
Right-click -> Run Statement.  Works fine.

Add a space or carriage return at the end: 'select * from "APP"."CUSTOMER" '

Right-click -> Run Statement.  Nothing happens.

Problem seems to occur whenever the statement ends with whitespace.
Comment 1 Andrei Badea 2007-01-04 16:51:00 UTC 
Reproduced.
Comment 2 Andrei Badea 2007-07-31 14:45:45 UTC 
Fixed, please verify.

Checking in src/org/netbeans/modules/db/sql/execute/SQLExecuteHelper.java;
/cvs/db/core/src/org/netbeans/modules/db/sql/execute/SQLExecuteHelper.java,v  <--  SQLExecuteHelper.java
new revision: 1.13; previous revision: 1.12
done
Checking in src/org/netbeans/modules/db/sql/execute/StatementInfo.java;
/cvs/db/core/src/org/netbeans/modules/db/sql/execute/StatementInfo.java,v  <--  StatementInfo.java
new revision: 1.3; previous revision: 1.2
done
Checking in test/unit/src/org/netbeans/modules/db/sql/execute/SQLExecuteHelperTest.java;
/cvs/db/core/test/unit/src/org/netbeans/modules/db/sql/execute/SQLExecuteHelperTest.java,v  <--  SQLExecuteHelperTest.java
new revision: 1.5; previous revision: 1.4
done