Zabach, Elke wrote:
hello!
>>explain select dummy, dummy from dual
>>-> [-6001] (at 16) Duplicate column name:DUMMY
> 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.
good to have found it, though :-)
> 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
yeah, well: the above thing is just a test-case. in my real-world
application i select columns with the same names but from different
tables. something like
select a.foo, b.foo from a, b where....
since i access the result set by column position i dont care about the
column name, so renaming is not necessary for me.
thanks for having a look at it
Raimund
--
Raimund Jacob
\|/ ____ \|/
Pinuts Media+Science GmbH "@'/ ,. \`@"
Potsdamer Str. 96 /_| \__/ |_\
D-10785 Berlin \__U_/
http://www.pinuts.de/ voice: +49 30 590090313 fax: +49 30 590090390
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
