Incorrect column numbers allowed
From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 23 Apr 2004 13:16:42 -0800
Message-ID: <408979aa_at_news.victoria.tc.ca>
CREATE INDEX DRAW_RESULTS_I2 ON DRAW_RESULTS ( -1 ); [Quoted] The above appears to work.
902000400 Received on Fri Apr 23 2004 - 23:16:42 CEST
Date: 23 Apr 2004 13:16:42 -0800
Message-ID: <408979aa_at_news.victoria.tc.ca>
CREATE INDEX DRAW_RESULTS_I2 ON DRAW_RESULTS ( -1 ); [Quoted] The above appears to work.
I wonder which column does -1 refer to?
In fact the number can be anything, including 0, or numbers higher than the number of columns in the table.
very odd
Oracle
RELEASE
902000400 Received on Fri Apr 23 2004 - 23:16:42 CEST