I've stumbled over a bug when working with INSERT ....SELECT... It only seems to work when selecting all columns from the target table. Otherwise it throws an Index out of range. The reason is the indexing in an columnMap array which gets constructed in
Parser::compileInsertStatement
her we find
cm to be initilized as
cm = t.getNewColumnMap()
which seems to grab al columns from the target table.
I've replaced this with a simple
cm = new int[len];
Here len seems to be the number of of columns that have been identied as the cross section between source and target table.
Hope that helps S.,
-- ********************************** Dr. Sebastian Kloska Head of Bioinformatics Scienion AG Volmerstr. 7a 12489 Berlin phone: +49-(30)-6392-1708 fax: +49-(30)-6392-1701 http://www.scienion.de **********************************
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
