I ran the SQL
INSERT INTO xxxx SELECT * FROM yyy
There was no error everything looked good. Later when I ran the program I found that only 21 rows where inserted out of
the expected thousands.
I suspect that you have set the max rows on the connection. This is very very dangerous. Maybe your looking for the word
Jirko, can you please take a look at this? Sounds bad...
I'm going to investigate it soon....
Which database do you use? I guess the duplicate of the issue #157022.
This was Sybase.
Yes it looks like a duplicate of #157022.
It's a scary one... I got my self into a complete mess moving records around with SELECT INTO and DELETE. There was no
indication that only partial records were being effected.
If this isn't fixed you should at least highlight the issue.
I agree that the issue is serious and we should fix it. Which database/driver do you use? I was not able to reproduce it
on MySQL neither javadb. It seems that bug is related to MS SQL server only.
This is Sybase not MS SQL.
I use jtds-1.2.2.jar
The native Sybase jConnect driver has other problems with NB.
*** This issue has been marked as a duplicate of 157022 ***