Hi Anil,
The reason is that there is no standard unsigned date SQL type that Phoenix
can map to, so Squirrel does not know how to interpret this type. An easy
fix should be to override the following method in PDataType for
UNSIGNED_DATE, UNSIGNED_TIME, and UNSIGNED_TIMESTAMP like this (returning
the corresponding regular type which SQuirrel will understand):
@Override
public int getResultSetSqlType() {
return DATE.getResultSetSqlType();
}
Would you mind giving this a try and if successful send us a patch? We
should be able to get it into our upcoming 3.1/4.1 release.
Thanks,
James
On Thu, May 1, 2014 at 4:58 PM, anil gupta <[email protected]> wrote:
> Hi All,
>
> I have Unsigned_Date Type columns in my phoenix tables. Squirell is unable
> to display the values. Instead of value it displays : "<UnknownType (19)>"
> What is the reason Squirell is unable to show that column? Can anyone tell
> me how to fix this problem(without changing the columns to Date)?
>
> --
> Thanks & Regards,
> Anil Gupta
>
