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 108904 - SQL statement is changed after opening Query Editor
Summary: SQL statement is changed after opening Query Editor
Status: CLOSED DUPLICATE of bug 103287
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: PC All
: P2 blocker (vote)
Assignee: _ jimdavidson
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-07-04 18:58 UTC by _ alexpetrov
Modified: 2007-07-17 11:01 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description _ alexpetrov 2007-07-04 18:58:55 UTC
Product Version: NetBeans IDE 6.0M10 (build 200706260050) 
Java: 1.6.0_01; Java HotSpot(TM) Client VM 1.6.0_01-b06 
System: Windows XP version 5.1 running on x86; Cp1251; ru_RU (nb)

1. Connect to DB Derby Travel.
2. Create new VWP project.
3. DnD DB table "PERSON" on Designer View.
4. In the window "Navigator" expand tree node "SessionBean1" and select tree subnode "personRowSet".

Result:
- the name of this RowSet-subnode contains SQL satement "SELECT * FROM TRAVEL.PERSON"
- its property "command" in the window "Properties" also contains SQL statement "SELECT * FROM TRAVEL.PERSON"
- SessionBean1.java contains the line
  "personRowSet.setCommand("SELECT * FROM TRAVEL.PERSON");"

5. Use popup menu item "Edit SQL Statement" for selected "personRowSet" (Query Editor window will be opened)

Result:
- Query Editor contains quite another SQL statement:
SELECT ALL "TRAVEL"."PERSON"."PERSONID", 
                    "TRAVEL"."PERSON"."NAME", 
                    "TRAVEL"."PERSON"."JOBTITLE", 
                    "TRAVEL"."PERSON"."FREQUENTFLYER", 
                    "TRAVEL"."PERSON"."LASTUPDATED" 
FROM TRAVEL.PERSON  

- previous SQL statement "SELECT * ..." will be changed to this new SQL satement "SELECT ALL ..."
  in the RowSet-subnode name, in the property "command", in the "SessionBean1.java".

But definitely "SELECT * " isn't quite equal to "SELECT ALL " ("*" != "ALL" in SQL-92)
Comment 1 _ alexpetrov 2007-07-05 15:48:09 UTC
More correctly: I have in mind that SQL statement "SELECT * ..." shouldn't be changed to "SELECT ALL <db_column_list>
..." without user approval.
Comment 2 _ jimdavidson 2007-07-17 01:01:22 UTC

*** This issue has been marked as a duplicate of 103287 ***
Comment 3 _ alexpetrov 2007-07-17 11:01:12 UTC
Closed as duplicate of
http://www.netbeans.org/issues/show_bug.cgi?id=103287