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.
[#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.
Reproducible. Should offer BIT as a data type for 5.x and newer.
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
v.