On 11/08/2015 06:20 PM, Viktor Dukhovni wrote: > Just be aware that headers potentially contain embedded new-lines, > and can be up to 100k bytes (header_size_limit) long. Test your > SQL engine to make sure it supports queries with string literals > that long.
Thanks for the heads up, the mysql shell certainly seem to barf on it (and badly, it looks like it attempts to overrun the buffer), but I think it's just the shell and not the engine itself, I'll have to find another way to test the engine, possibly with a bit of perl and DBI. >> 2. Is it a supported use case? > > Yes. > >> 3. Assuming the answer to 1 is "yes", will it continue to work in the >> future or is it possible that the functionality could be changed or >> removed in a way which will break this use case? > > Provided the underlying table driver does not choke on general > input, you can attempt to use any table type in a context that > supports table lookups. Thanks, that's what I thought, but I felt it was good to make sure before I committed time to this strategy. Peter
