Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread A brilliant idea for identifier lengths
Mon, Jun 30 2014 1:25 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Whilst taking the dog for a walk in the forest I came up with a brilliant idea

<tongue in cheek ON>
Let's ask Tim for a boolean flag - USEDESCRIPTIONS. It would default to false but if set to true then SQL statements would require you to type the full description for the identifier, in quotes, and it would lookup the actual id from thatand then construct the SQL that is run.

It would then be possible to have identifiers up to 2GB in length.

This would allow us to have table definitions in the catalog that exceeded the physical memory of the computer.

<tongue in cheek OFF>

Roy Lambert
Mon, Jun 30 2014 4:52 PMPermanent Link

Barry

>>Whilst taking the dog for a walk in the forest I came up with a brilliant idea

<tongue in cheek ON>
Let's ask Tim for a boolean flag - USEDESCRIPTIONS. It would default to false but if set to true then SQL statements would require you to type the full description for the identifier, in quotes, and it would lookup the actual id from thatand then construct the SQL that is run.

It would then be possible to have identifiers up to 2GB in length.

This would allow us to have table definitions in the catalog that exceeded the physical memory of the computer.

<tongue in cheek OFF>

<<

How your dog puts up with you is beyond me.
The only reason he hasn't run away by now is because he doesn't understand English. VBG

Barry
Tue, Jul 1 2014 3:09 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Barry


>How your dog puts up with you is beyond me.
>The only reason he hasn't run away by now is because he doesn't understand English. VBG

Easy - HE is a female and hence totally irrational!

Roy Lambert
Image