History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: SQLQ-20
Type: Bug Bug
Status: Open Open
Priority: Blocker Blocker
Assignee: Stefan Stiller
Reporter: Josh Auerbach
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
SQL Query Plugin

plugin does not seem to return proper results for INTEGER primary keys

Created: 04 Dec 06 18:11   Updated: 04 Dec 06 18:11
Component/s: Result Table
Affects Version/s: None
Fix Version/s: None

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown
Environment: windows xp, IntelliJ 5.1.2


 Description  « Hide
the column domain_id is the primary key, int(10) unsigned autoincrement
here is a query run in the MySQL query browser

select distinct(domain_id) from domain order by domain_id limit 10
1
2
3
4
5
6
7
8
9
10

which is the correct result, in the plugin I run the same query and get
4294967297
4294967298
4294967299
4294967300
4294967301
4294967302
4294967303
4294967304
4294967305
4294967306



 All   Comments   Work Log   Change History      Sort Order:
There are no comments yet on this issue.