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 69243

Summary:	[MySQL] Missing BIT data type support
Product:	db	Reporter:	Martin Schovanek <mschovanek>
Component:	Code	Assignee:	Andrei Badea <abadea>
Status:	VERIFIED FIXED
Severity:	blocker
Priority:	P3
Version:	5.x
Hardware:	All
OS:	All
Issue Type:	DEFECT	Exception Reporter:

Description Martin Schovanek 2005-11-24 10:07:13 UTC

[#200511221900, jdk1.5.0, MySQL 5.0]

This data type was added in MySQL 5.0.3 for MyISAM, and extended in 5.0.5 to
MEMORY, InnoDB, and BDB. Before 5.0.3, BIT  was a synonym for TINYINT.

Current Nb MySQL support does not mention BIT type at all.

Comment 1 Andrei Badea 2005-12-01 13:19:25 UTC

Reproducible. Should offer BIT as a data type for 5.x and newer.

Comment 2 Andrei Badea 2005-12-04 16:19:54 UTC

Fixed. Offering BIT in the Create Table and Add Table Column dialogs for all
MySQL versions. We need to address the database specification by name *and
version* if we want to offer the BIT type for versions > 5. Too risky for 5.0.

Also note that for BIT column nodes we display the datatype property as BIT for
4.x and OTHER for 5.0. That's because we display types from java.sql.Types
instead of database-specific types. Filed issue 69846.

Checking in libsrc/org/netbeans/lib/ddl/impl/Specification.java;
/cvs/db/libsrc/org/netbeans/lib/ddl/impl/Specification.java,v  <-- 
Specification.java
new revision: 1.21; previous revision: 1.20
done
Checking in libsrc/org/netbeans/lib/ddl/resources/dbspec.plist;
/cvs/db/libsrc/org/netbeans/lib/ddl/resources/dbspec.plist,v  <--  dbspec.plist
new revision: 1.52; previous revision: 1.51
done

Comment 3 Lukasz Grela 2006-01-17 09:26:35 UTC

v.