Daniel John Debrunner wrote: > [EMAIL PROTECTED] wrote > > > >> INSERT INTO WORKS1 >> SELECT * >> FROM WORKS; >>-12 rows inserted/updated/deleted >>+12 --s executed > > > The patch seems to have problems, several of the correct execution > status lines in the test output have been replaced with lines that make > no sense. Ie. in this case '--s executed'. > > This is the danger of getting ij parsing SQL text, it may not have the > same understanding as the underlying SQL engine, which may not be Derby.
I meant to add I think it may be possible to tell from the JDBC api if a statement execution returns: - ResultSet - update count - other execution (e.g. DDL) For the first two, ij does do the correct behaviour now. For the latter, ij prints out the 0 rows inserted/upodated/deleted, but maybe it should print out a simple 'statement executed'. Though I could never figure out exactly how to tell from JDBC which type of statement it is. Dan.
