Thanks, that worked. Didn't realise I was still such a noob... Cheers, Duncan On 10 March 2013 00:00, wrote:

Send users-list mailing list submissions to users-list@monetdb.org

To subscribe or unsubscribe via the World Wide Web, visit http://mail.monetdb.org/mailman/listinfo/users-list or, via email, send a message with subject or body 'help' to users-list-request@monetdb.org

You can reach the person managing the list at users-list-owner@monetdb.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of users-list digest..."

Today's Topics:

1. INSERT INTO ... SELECT * FROM ... OFFSET X seems to leave destination table in an inconsistent state (Percy Wegmann) 2. Re: INSERT INTO ... SELECT * FROM ... OFFSET X seems to leave destination table in an inconsistent state (Martin Kersten) 3. Installation on Ubuntu 12.10 Quantal (Duncan Garmonsway) 4. Re: Installation on Ubuntu 12.10 Quantal (Brandon Jackson)

----------------------------------------------------------------------

Message: 1 Date: Fri, 8 Mar 2013 10:22:53 -0600 From: Percy Wegmann To: Communication channel for MonetDB users Subject: INSERT INTO ... SELECT * FROM ... OFFSET X seems to leave destination table in an inconsistent state Message-ID: < CADpZG+Scab3V8u_isKziJobUgCYO4BEmkCWMB8iOD-pjggTWQQ@mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1"

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