[PDI-11461] Hypersonic db has no type TEXT

<h1>DIRECT-MASTER</h1> verify if it is approved for direct master merge.

* Changed: 'TEXT' to hsqldb specific 'LONGVARCHAR'
* Added testcase