Re: Fwd: Diffrence between 8.0.3 and 8.1.3

2006/7/5, Kris Jurka <books(at)ejurka(dot)com>:
>
>
>
> On Wed, 5 Jul 2006, Yann PICHOT wrote:
>
> > When i use this SQL request : SELECT col1, cast(' ' as varchar(3)) as
> mycol
> > FROM mytable, getColumnDisplaySize return -5.
> > When i use this SQL request : SELECT col1, cast(' ' as varchar(3)) as
> mycol,
> > getColumnDisplaySize return 3 !!!!
> >
>
> OK, I misunderstood your test case and was only looking at the second
> version which works. As you noted earlier the server is responding with a
> different typmod value, so this is not a JDBC problem, but a server
> regression and I've forwarded this on to the -bugs list. To summarize for
> them:
>
> In 8.0 "SELECT ' '::varchar(3) FROM tab" retained the typmod value
> specified in the query, but in 8.1 it is lost and -1 is used instead.
>
> Kris Jurka
>

Thanks, i'll follow the problem in the bug list.

--
Yann