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 150273 - Inconsistent view for BIT type
Summary: Inconsistent view for BIT type
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Shansi 11
URL:
Keywords:
Depends on:
Blocks: 152437
  Show dependency tree
 
Reported: 2008-10-15 18:57 UTC by Roman Mostyka
Modified: 2009-02-19 20:37 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Mostyka 2008-10-15 18:57:27 UTC 
1. Connect to MySQL DB and expand it's node.
2. Rightclick "Tables" node and choose "Create Table".
3. Add table with 1 columns with BIT type and some values with "Insert Record" dialog.
4. Rightclick added table and choose "View Data".

Result: Data is shown as checkbox.

5. Click some cell.

Result: Checkbox becomes string "true" or "false".
Comment 1 _ ahimanikya 2008-10-17 21:26:47 UTC 
Agree, what you think will be better, string "true", "false" or checkbox?
Comment 2 Roman Mostyka 2008-10-21 08:08:57 UTC 
Actually I'm not sure that all these values are appropriated.
Please correct me if I'm wrong, but I read here that BIT value isn't the same as BOOL in MySQL:
http://dev.mysql.com/doc/refman/5.0/en/bit-field-values.html
Comment 3 David Vancouvering 2008-10-29 00:55:00 UTC 
It should be 1 or 0 - that's what a BIT is, it's not a boolean, which is what a checkbox or "true"/"false" implies.
Comment 4 Roman Mostyka 2008-11-19 14:20:33 UTC 
ahimanikya, can You take a look at this issue? This issue is P3, but it looks like presented functionality doesn't work
well and therefore this issue is going to be included into NetBeans 6.5 Patch 1.
Please fix it till 27 November (this is code freeze date for Patch 1) or update this issue with justification why the
fix isn't possible till this date.
Thanks.
Comment 5 pgebauer 2008-11-24 09:29:18 UTC 
The issue didn't pass the nomination process by nomination cut-off date. It has been marked as 65fixes2-candidate.
Comment 6 Roman Mostyka 2008-12-04 16:56:56 UTC 
I went through the list of issues and found that this issue isn't fixed yet, but we found out that BIT type for MySQL it
isn't boolean, so we just have wrong appearance for this type and therefore it is P1.
Sivashankari, please look at it.
Comment 7 _ ahimanikya 2008-12-04 23:12:28 UTC 
Its better we express BIT as BOOLEAN, setting value to "0" or "1" can confuse user with numeric columns.

But I agree we need to be consistent. The Bug is valid, it should turn to "true" or "false" after editing, it remain a
checkbox.
Comment 8 Shansi 11 2008-12-05 02:00:22 UTC 
Needs Verification
http://hg.netbeans.org/main/rev/80320faf63ad
Comment 9 Roman Mostyka 2008-12-07 01:16:02 UTC 
Verified with build 081205.
Comment 10 pgebauer 2008-12-18 14:48:35 UTC 
The fix has been ported into the release65_fixes repository.

http://hg.netbeans.org/release65_fixes/rev/05b6eacf0997