Re: [BUGS] [JDBC] Error in DatabaseMetaData.getColumns() with Views

2004-07-07 Thread Dario V. Fassi
  "coalesce", "case then", etc. The overflow or "data truncation" exception , for views, it's a going back , but almost put the problem in programmer's hands. Regards, Dario. Kris Jurka wrote: On Sat, 3 Jul 2004, Dario V. Fassi wrote: In th

Re: [BUGS] [JDBC] Error in DatabaseMetaData.getColumns() with Views

2004-07-07 Thread Dario V. Fassi
laboration for that. Regards all, Dario Fassi. Dario V. Fassi wrote: Kris Jurka wrote: On Fri, 2 Jul 2004, Dario Fassi wrote: Hi, I wish to report a erroneous information returned by DatabaseMetaData.getColumns() method. This happens with ResultSet&#

Re: [BUGS] [JDBC] Error in DatabaseMetaData.getColumns() with Views

2004-07-07 Thread Dario V. Fassi
Stephan Szabo wrote: On Sun, 4 Jul 2004, Kris Jurka wrote: On Sat, 3 Jul 2004, Dario V. Fassi wrote: In the sample adjunct, you can see that error arise at the time when the view's sql text is parsed and saved in database catalog. Then generic NUMERIC ty

Re: [BUGS] [JDBC] Error in DatabaseMetaData.getColumns() with Views

2004-07-07 Thread Dario V. Fassi
s the case the returning data type must be a floating point data type like a double, but never 2 decimals for a row and 3, 4 or whatever for others rows. Stephan Szabo wrote: On Sun, 4 Jul 2004, Dario V. Fassi wrote: Stephan Szabo wrote: On Sun, 4 Jul 2004, Kris Jurka