| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Yann PICHOT <ypichot(at)gmail(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Fwd: [JDBC] Diffrence between 8.0.3 and 8.1.3 |
| Date: | 2006-07-05 19:31:48 |
| Message-ID: | Pine.BSO.4.63.0607051425130.31538@leary2.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Naschenweng | 2006-07-05 20:50:28 | BUG #2515: Full Scan with constant column |
| Previous Message | Gilles | 2006-07-05 14:46:16 | BUG #2514: (jdbc driver) Multiple inlined statements with mixed updates and queries return wrong results |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Skaljac Bojan | 2006-07-05 23:09:52 | I have implement set/get stored procedure parameter by name |
| Previous Message | Yann PICHOT | 2006-07-05 06:57:00 | Fwd: Diffrence between 8.0.3 and 8.1.3 |