metacat TEXT nodes limited to 4K characters
The current 4K character limit on metacat TEXT nodes is going to be limiting in
some cases. Need mechanism to split text nodes into multiple sibling TEXT
nodes, each no more than 4K. Can't use a LONG or LOB because they can't be put
in the WHERE clause of a SELECT. Using mutiple sibling TEXT nodes will cause
problems searching across the boundaries, but it is the best approach AFAIK.
#1 Updated by Matt Jones about 20 years ago
Fixed bug where TEXT nodes couldn't be longer than 4000 characters, which is the
maximum length of a VARCHAR2 field in Oracle. Now, if text exceeds the field
length, I break the text up into a series of TEXT nodes each of the max field
length, and the remainder in the last TEXT node. The only problem with this is
that our current search algorithms only will find phrases within a single TEXT
nodes, so if the search term spans the node boundary, the search algorithm will
not return a hit. I expect this is extremely rare, basically inconsequential.
But I will still log it as a bug.