[PDI-11461] Hypersonic db has no type TEXT

* Changed: 'TEXT' to hsqldb specific 'LONGVARCHAR'
* Added testcase