Raimund Jacob wrote: > using dbvisualizer (3.0 beta 2 / jdbc 7.4.3 Build > 001-000-078-671) i did: > > select dummy from dual > -> ok > > select dummy, dummy from dual > -> ok > > explain select dummy from dual > -> ok > > explain select dummy, dummy from dual > -> [-6001] (at 16) Duplicate column name:DUMMY > > i ran into this problem when i wanted to get a join explained where > different tables had the same name for a column. > > i dont know if this problem exists for other jdbc drivers...
It has nothing to do with JDBC, it is a kernel-effect. For some reason sometimes the select in an explain was (bug fix is in the next kernel version) more restrictive than a select outside. To use the same output-column-name twice is no good habit, but allowed. You should always avoid it by renaming at least one of the columns select dummy, dummy mydummy from dual Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
