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.
[ BUILD # : 200808170243 ] [ JDK VERSION : 1.6.0_07 ] In SQL Editor results window, after having executing a SQL Select statement with results, I can change the Page Size field to display a different number of results so the results are paginated. If I enter a value such as 10, or 50, or 200 and press enter the window refreshes correctly. However, if I enter a value such as 9999 and press enter the window refreshes, but the Page Size field is no longer editable. Click inside it again and try changing the number. I cannot. No visible error or exception occurs.
I did try this with various sample database tables, I was not able to reproduce this. If you are using the sample database please let me know which database you are using. Please provide steps to reproduce this.
I tried this with an Oracle database and a MySQL database, on a dozen different tables in each database, on separate days. It is not specific to one table or one type of database. If I enter a value in the Page Size field such as 10, or 50, or 200 and press enter the window refreshes correctly. However, if I enter a value such as 9999 and press enter the window refreshes and the Page Size field LOOKS like it can be edited, but is no longer editable. Click inside it again and try changing the number to 8888 or 5555 or 200. I cannot. No visible error or exception occurs. Product Version: NetBeans IDE Dev (Build 200808170243) Java: 1.6.0_02; Java HotSpot(TM) Client VM 1.6.0_02-b05 System: Windows XP version 5.1 running on x86; Cp1252; en_US (nb)
Adam provided more information on this issue so I don't consider it INCOMPLETE now. Or are we still waiting for more data?
I tried to reproduce with couple of databases and both Windows and Mac without any success. Everytime I am able to edit after I enter 9999. BTW, the maximum page size is 9999, if you want to edit after entering 9999 then you need to delete and then enter new numbers.
I have a further clarification to help replicate this problem. Once you view some data in the grid, double-click the # 20 in the page field size. The 20 should become highlighted. If you type 50, the 20 is overwritten with 50 as expected. Now type 9999 into the field and press enter. The grid refreshes and 9999 remains in the page field size. DOUBLE-CLICK the 9999 so it is highlighted. Now try to overwrite it by typing 50 or 555. The field should prevent you from typing over the number. If you press Backspace with the number highlighted it does disappear, but for some reason you cannot type over the numbers once highlighted ONLY AFTER you entered an invalid value and pressed enter.
http://hg.netbeans.org/main/rev/916eeb2f1afa
Integrated into 'main-golden', available in build *200808300201* on http://bits.netbeans.org/dev/nightly/ Changeset: http://hg.netbeans.org/main/rev/916eeb2f1afa User: ahimanikya@netbeans.org Log: #144510 [65cat] Page Size Field Validation in SQL Editor results window