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

Summary:	query doesn't show all result set
Product:	db	Reporter:	unclepaulie <unclepaulie>
Component:	Show Data	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED DUPLICATE
Severity:	blocker
Priority:	P3
Version:	6.x
Hardware:	PC
OS:	Windows Vista
Issue Type:	DEFECT	Exception Reporter:

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 ***