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.
| Summary: | Disable "insert records" if there are uncommited updates in table | ||
|---|---|---|---|
| Product: | db | Reporter: | bolsover <bolsover> |
| Component: | SQL Editor | Assignee: | Jaroslav Havlin <jhavlin> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | musilt2 |
| Priority: | P3 | ||
| Version: | 7.4 | ||
| Hardware: | PC | ||
| OS: | Windows 8 x64 | ||
| Issue Type: | DEFECT | Exception Reporter: | |
|
Description
bolsover
2013-06-17 09:14:32 UTC
http://hg.netbeans.org/core-main/rev/35092ef90942 Fixed. > 4 Fail - 4.1 says 2 buttons enabled - when actually all 5 buttons are enabled > Insert, Delete, Commit, Cancel, Truncate I'm not sure whether this should be read as "_only_ two buttons are enabled", or "two buttons are _newly_ enabled" ... > If Insert is selected without prior commit of edit, then the edit is lost but > the insert succeeds. I don't think this is a major issue - but it is a fail > against the test specification. ... but I agree, it's safer if the actions that could damage current changes are disabled. > 5 Fail - Only matches char fields when 2 characters are entered into matching > rows text field. e.g. If a data column contains the text 'Charlotte', it is > only matched when 'Ch' is entered and not when 'C' entered. It works fine for me. Maybe you have letter 'c' in other values as well. The filter accepts all values that contain 'c', not only the ones that start with 'c'. Thank you very much for reporting. I cannot reproduce as well.
> 5 Fail
Thanks for a fast fix!
With the could not reproduce comments, I went back and checked my results and was immediately able to reproduce..
Note: I actually created the table and entered row data manually - so apologies if I have made any typo errors in the code that follows - but hopefully the intent is clear.
Using MySQL
1 Create new testable
delimiter $$
CREATE TABLE 'testtable1' (
'id' int(11) NOT NULL,
'name' char(255) DEFAULT NULL,
'email' char(255) DEFAULT NULL,
PRIMARY KEY ('id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8$$
2 Insert data
INSERT INTO sakila.testtable1 (id, 'name', email) VALUES (1, 'David Bolsover', 'david@mailserver.com' );
INSERT INTO sakila.testtable1 (id, 'name', email) VALUES (2, 'Charlotte Bolsover', 'charlotte@mailserver.com' );
INSERT INTO sakila.testtable1 (id, 'name', email) VALUES (3, 'Janette Bolsover', 'janette@mailserver.com' );
3 Test matching rows feature using values 'd', 'j', 'c', 'ch'.
Rows 1 and 3 are matched as expected - but row 2 is only matched when entering 'ch'
Thank you very much, David, for steps to reproduce. I think that it works correctly. If you use filter value 'c', all rows are matched and visible, because they all contain 'c' in column email, in the ".com" suffix. If you display query "select name from testtable1;", only the column with value "Charlotte" will be displayed if you use the same filter. Can you please check it? Thank you. You are quite correct - my fault - I've been using a case sensitive database lately and completely ignored the matching lowercase 'c' doh! Please consider closed. > Please consider closed.
OK. Thank you very much for your help!
Integrated into 'main-golden', will be available in build *201306181109* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/35092ef90942 User: Jaroslav Havlin <jhavlin@netbeans.org> Log: #231344: TS 70 DB Sanity test fails |