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 <percy@clicksecurity.com>
To: Communication channel for MonetDB users <users-list@monetdb.org>
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20130308/45b3504f/attachment-0001.html>
------------------------------
Message: 2
Date: Fri, 08 Mar 2013 17:24:00 +0100
From: Martin Kersten <Martin.Kersten@cwi.nl>
To: users-list@monetdb.org
Subject: Re: INSERT INTO ... SELECT * FROM ... OFFSET X seems to leave
destination table in an inconsistent state
Message-ID: <513A10A0.4080801@cwi.nl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
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
>
------------------------------
Message: 3
Date: Sat, 9 Mar 2013 14:38:29 +1300
From: Duncan Garmonsway <nacnudus@gmail.com>
To: users-list@monetdb.org
Subject: Installation on Ubuntu 12.10 Quantal
Message-ID:
<CAARqVQMoUp9oYwBkRQB6Gnig=3zD1i+oY710Xe8LZcDjV0_tsg@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Hello,
After installation I am getting the error:
$ monetdbd create ~/monetdb/
monetdbd: error while loading shared libraries: libstream.so.3: cannot open
shared object file: No such file or directory
But the library (and the symlink to it) are right here:
$ ls -l /usr/local/lib | grep libstream
-rwxr-xr-x 1 root root 943 Mar 9 14:23 libstream.la
lrwxrwxrwx 1 root root 18 Mar 9 14:23 libstream.so ->
libstream.so.3.1.5
lrwxrwxrwx 1 root root 18 Mar 9 14:23 libstream.so.3 ->
libstream.so.3.1.5
-rwxr-xr-x 1 root root 107879 Mar 9 14:23 libstream.so.3.1.5
And there were no errors reported during any of
./configure
sudo make
sudo make install
My installation script was:
sudo apt-get install libxml2-dev bison ant flex unixODBC-dev
# download and unpack source
wget http://dev.monetdb.org/downloads/sources/Latest/MonetDB-11.15.3.tar.xz
tar -xvf MonetDB-11.15.3.tar.xz
# install
cd MonetDB-11.15.3
./configure
sudo make
sudo make install
Help much appreciated,
Duncan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20130309/5f4ee6d8/attachment-0001.html>
------------------------------
Message: 4
Date: Fri, 8 Mar 2013 20:23:09 -0600
From: Brandon Jackson <usbrandon@gmail.com>
To: Communication channel for MonetDB users <users-list@monetdb.org>
Cc: "users-list@monetdb.org" <users-list@monetdb.org>
Subject: Re: Installation on Ubuntu 12.10 Quantal
Message-ID: <123B6933-A931-428D-9D3B-E1B527AEA002@gmail.com>
Content-Type: text/plain; charset="us-ascii"
Did you try a sudo ldconfig? That should make the system aware of new libraries.
Sent from my iPhone
On Mar 8, 2013, at 7:38 PM, Duncan Garmonsway <nacnudus@gmail.com> wrote:
> Hello,
>
> After installation I am getting the error:
>
> $ monetdbd create ~/monetdb/
> monetdbd: error while loading shared libraries: libstream.so.3: cannot open shared object file: No such file or directory
>
> But the library (and the symlink to it) are right here:
> $ ls -l /usr/local/lib | grep libstream
> -rwxr-xr-x 1 root root 943 Mar 9 14:23 libstream.la
> lrwxrwxrwx 1 root root 18 Mar 9 14:23 libstream.so -> libstream.so.3.1.5
> lrwxrwxrwx 1 root root 18 Mar 9 14:23 libstream.so.3 -> libstream.so.3.1.5
> -rwxr-xr-x 1 root root 107879 Mar 9 14:23 libstream.so.3.1.5
>
> And there were no errors reported during any of
> ./configure
> sudo make
> sudo make install
>
> My installation script was:
> sudo apt-get install libxml2-dev bison ant flex unixODBC-dev
> # download and unpack source
> wget http://dev.monetdb.org/downloads/sources/Latest/MonetDB-11.15.3.tar.xz
> tar -xvf MonetDB-11.15.3.tar.xz
> # install
> cd MonetDB-11.15.3
> ./configure
> sudo make
> sudo make install
>
> Help much appreciated,
>
> Duncan
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/users-list/attachments/20130308/295a7166/attachment-0001.html>
------------------------------
_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
End of users-list Digest, Vol 7, Issue 3
****************************************