Bug ID domain?

[Jason Pyeron]

On Fri, 25 Apr 2003, Bradley Baetz wrote:

>On Thu, Apr 24, 2003 at 07:12:52PM -0400, Sean McAfee wrote:
>
>> Even a text column isn't large enough for all cases, though.  The default
>> value for a multiselection would have to be serialized in some way;
>> to a string like "1,2,3,4", presumably.
>
>I thought mulitselects were out of the first version? I really need to
>look at the next draft of the proposal - I just haven't had time
>recently. Hopefully this weekend.
>
>Hmm. Maybe putting it into the data table will work. You'd have to use
>NULL (not 0, or anything else) so that FKs will work. (Besides, NULL is
>the 'correct' thing here)
>

Yes that is right but he has it set such that the pk is (null,val) that is 
why he said they could not be used and was looking for a hack.

What needs to be done is:

do a unique index on (null,val) and have an ID pk not null column.

[sorry it is too late to remember column names and correct syntax]

>> But the earlier consensus was
>> that the number of possible selection values should be unlimited, so the
>> serialization of a large multiselect default could exceed 64K characters.
>> Sure, probably no one *would* create such a huge default value, but the
>> design should allow for that possibility.  Besides which, I'd find it
>> much more elegant if data of all kinds are stored in the DB in their
>> most compact representation, with no munging required.
>
>But it does't matter here, because theres no querying involved. It
>matters for the real data since that affects the indexing/comparison
>operations.
>
>Anyway, I've changed my mind; NULLs in the data table should be fine.
>Thoughts?

Got a penny? [Java SQL DB Engine = Evil & NoSleep]

Jason Pyeron

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-                                                               -
- Jason Pyeron                   http://www.pyerotechnics.com   -
- Owner & Lead                  Pyerotechnics Development, Inc. -
- +1 410 808 6646 (c)           500 West University Parkway #1S -
- +1 410 467 2266 (f)           Baltimore, Maryland  21210-3253 -
-                                                               -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.