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 170934 - Schema name is not prepended in SQL query
Summary: Schema name is not prepended in SQL query
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: PC Windows Vista
: P2 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
: 171577 (view as bug list)
Depends on:
Blocks:
 
Reported: 2009-08-26 14:05 UTC by denbo
Modified: 2009-09-18 22:15 UTC (History)
1 user (show)

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 denbo 2009-08-26 14:05:03 UTC 
Right-clicking a database table and selecting "View Data" causes an SQL error. In my case, this is a DB2 database.
Most likely, the reason is the missing schema name in the SQL query. Where the SQL "select * from ACQUISITIONTEAMS" is
generated, it should read "select * from CORPDB.ACQUISITIONTEAMS". When I change the query in this way and run it, I get
the desired result.

Build 200908210201
Comment 1 err 2009-09-07 15:45:27 UTC 
*** Issue 171577 has been marked as a duplicate of this issue. ***
Comment 2 Jiri Rechtacek 2009-09-15 15:14:15 UTC 
It's reproducible in more platforms, I increased the priority to don't forget fix for NB6.8.
Comment 3 Jiri Rechtacek 2009-09-16 16:21:06 UTC 
Reproducible e.g. with MS SQL
Comment 4 Jiri Rechtacek 2009-09-17 10:18:28 UTC 
core-main/rev/0bf69b5bc27f
Comment 5 Quality Engineering 2009-09-18 22:15:16 UTC 
Integrated into 'main-golden', will be available in build *200909181401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/0bf69b5bc27f
User: Jiri Rechtacek <jrechtacek@netbeans.org>
Log: #170934: Schema name is not prepended in SQL query