[rt-devel] Oracle LIKE in CLOB support for RT - Done!

[Jesse Vincent]

On Thu, Mar 20, 2003 at 02:00:39PM +1000, Brook Schofield wrote:
> The support of RT on Oracle has just had a significant boost - after I read 
> the documentation.
> 
> If the minimum requirement for RT becomes Oracle 9iR2 (9.2) the there is no 
> need to specifically support CLOBs for LIKE queries. Since Oracle 8.x is 
> being EOL'd at the end of this year - I would see little reason for people 
> to deploy a new system (RT3.0) on a database(8.1.7) that will become 
> unsupported.

Yes. I don't even want to think about porting to Oracle 8, because of
the broken oracle-specific left join syntax.

> 
> I believe "large" refers to greater than 4k - so many operations will work 
> out of the box. This could mean some work in the subclassing of 
> DBIx::SearchBuilder::Record or modifications to RT::Record.pm to support 
> LOB types. The above Oracle document details the 4,000 character limits as 
> well.
 
So. I almost had to do this for postgres tonight, but didn't want to
deal with the churn (and found a simpler solution).

There's only one place of consequence where we actually do the parameter
binding in DBIx::SearchBuilder::Handle's SimpleQuery method.

And the only two places where we pass in data that needs to have its
attributes tagged is Record->Create and Record->__Set. Both of these
methods have access to the ClassAccessible hash of table metadata,
including the column types (as defined in mysql).   Perl has
"attributes" (perldoc attributes). It should be possible to tag things
that need special bind_param handling in __Set/Create and cope with that
in SimpleQuery. (perhaps by callign a function in the Handle subclass.

Does that make sense?

> -Brook

Thanks!
	Jesse

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.