Bug #688 Should a moveToInsertRow() assign default database values to fields?

Submitted:	19 Jun 2003 16:45	Modified:	20 Jun 2003 7:26
Reporter:	David Marquis	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / J	Severity:	S4 (Feature request)
Version:	all ?	OS:	Any (all)
Assigned to:	Mark Matthews	CPU Architecture:	Any

Description:
I don't know if it's in the JDBC-spec but,I loose nothing to ask anyways. When a call to moveToInsertRow() is made, should the driver assign default values to every fields on the insert row ?

How to repeat:
CREATE TABLE temp
(
id int not null primary key,
isValid ENUM('T','F') DEFAULT 'T'
);

ResultSet set (...)
set.moveToInsertRow()
set.getBoolean("isValid") always returns false.

Suggested fix:
I know DatabaseMetaData.getColumns returns default values (COLUMN_DEF), so maybe it is not a big deal to gather default values around this code ?

This is now fixed in the development tree for both 3.0.x and 3.1.x. You can check out a nightly snapshot after 00:00 GMT 21-June-03 from http://mmmysql.sourceforge.net/snapshots/ to test it, or wait for Connector/J 3.0.9 to be released, which should be sometime in the next few days.

Thanks for your bug report!

   -Mark

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.