| Re: [stellation-res] Comments table, why insert empty comment? |
On Tue, 2002-10-01 at 19:58, Dave Shields wrote: > On Tue, Oct 01, 2002 at 05:30:58PM +0100, Ringo De Smet wrote: > > Hello, > > > > I still have problems creating the repository with the Oracle backend. > > The creation of the Comments table works, but why is an empty comment > > inserted in the Comments table? Here is the snippet of > > I picked "" over NULL as we don't use NULL in any other table. I don't think this really answers the question. Why are we seeding the comments table with a row with an empty string? On the other hand: I think it's reasonable to expect the system to work properly when users choose not to supply comments. So we need to do something to make the system work correctly when an empty comment is supplied. So far, it looks like Oracle is the only database that we're looking at that has a problem with this, but we still need a workaround to make it work there. Dare I suggest that when the user supplies an empty comment, we automatically substitute "no comment"? -Mark -- Mark Craig Chu-Carroll, IBM T.J. Watson Research Center *** The Stellation project: Advanced SCM for Collaboration *** http://www.eclipse.org/stellation *** Work Email: mcc@xxxxxxxxxxxxxx ------- Personal Email: markcc@xxxxxxxxxxx
Attachment:
signature.asc
Description: This is a digitally signed message part