added test for truncate
added test for updateLob with joins
added test for compileLock returning string