INSERT INTO ... SELECT * FROM ... OFFSET X seems to leave destination table in an inconsistent state
Dear Monet Team, Today I ran into an issue with copying data between tables. I've tried it on 11.13.7 and 11.13.9 with the same results. What I find is that when including an OFFSET clause in my source query, the destination table ends up in a weird state. I've logged a bug for it - http://bugs.monetdb.org/show_bug.cgi?id=3249 I'm using the workaround of ordering my data and using a LIMIT instead of an OFFSET, which seems to work. Just wanted to let you know. Thanks, Percy
Dear Percy Thanks for the valuable feedback. We'll take into our QA process. regards, Martin Kersten On 3/8/13 5:22 PM, Percy Wegmann wrote:
Dear Monet Team,
Today I ran into an issue with copying data between tables. I've tried it on 11.13.7 and 11.13.9 with the same results. What I find is that when including an OFFSET clause in my source query, the destination table ends up in a weird state.
I've logged a bug for it - http://bugs.monetdb.org/show_bug.cgi?id=3249
I'm using the workaround of ordering my data and using a LIMIT instead of an OFFSET, which seems to work. Just wanted to let you know.
Thanks, Percy
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Martin Kersten -
Percy Wegmann