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 173782 - query doesn't show all result set
Summary: query doesn't show all result set
Status: RESOLVED DUPLICATE of bug 156444
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: PC Windows Vista
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-05 15:54 UTC by unclepaulie
Modified: 2009-10-06 11:38 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 unclepaulie 2009-10-05 15:54:37 UTC
I inserted the following query to the editor:

select topics.topicId, count(*) FROM posts
INNER JOIN topics ON topics.topicID = posts.topicId
GROUP BY topics.topicId;

This query shows how many posts there are for each topic in the database.
There are 10k topics so it should show that number of topics plus the 
correspondent number of posts. Unfortunately it's only showing the 
first 20 topics.

It works with Mysql Query Browser as well as Mysql CLI client but not 
with the embedded Netbeans query editor. 

-- Uncle Paulie
Comment 1 Jiri Rechtacek 2009-10-06 11:38:34 UTC
You can set a page size of the result set, however it doesn't work correctly, it's tracked as issue 156444.

*** This issue has been marked as a duplicate of 156444 ***