dear list,
i have a 7.3 DB running on my mandrake 9.1 notebook.
"select columnname, mode, nullable from columns where tablename='X'"
results in Y, OPT, NO on some columns. So mode is still optional, but nullabe is no.
What is the difference between the columntype MAN and the nullable-column in the columns-systemtable? Using the jdbc-features to analyze the data structure the nullable-field of the metadata object is only false if mode = MAN. This is a bit confusing.
Sorry to bother the list with this but the systemtable documentation does not even mention the nullable column in the columns table.
One idea came into my mind: does MAN mean, that the *client* has to provide a value to fulfill the nullable=no rule, whilst columns which have a default value may remain on OPT, because the server itsself takes care of the nullable=no rule by inserting the default value?
Exactly.
Daniel Dittmar
-- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
