add decimal and bit sqlgen and some test cases