Exceptions not caught in UDF written in C++ in MySQL 5.5

2011-08-30 Thread H. Steuer
Hello guys, after upgrading from MySQL 5.1 to 5.5 we encounter a problem that C++ exceptions thrown in an UDF are not catched at all. Even there is a "catch (... )" at the end or our try block which avoids exceptions to be thrown outside of the UDF, the server crashes with: terminate called

bug in mysql with COUNT() in subqueries

2006-11-15 Thread H. Steuer
guys, strange things happen when using COUNT() in subqueries. even the use of HAVING in a SELECT statement turns up a weired result, as it should work on the result set and should be filtered while rows are returned to the client. (you can find the selects and stuff in a more readable way on http

mysql 4.1.x and openbsd: client library problem

2005-01-15 Thread H. Steuer
hello guys, after compiling and installing mysql 4.1.9 from sources, the database server seems to work fine, but everything from client/ seems to somehow "hardcode" the client library path into the binary. when e.g. trying to start "mysqladmin" it goes: # mysqladmin

Re: replication and other col names

2004-11-19 Thread H. Steuer
as experiences with this kind of configuration. kind regards, heri"H. Steuer" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___

replication and other col names

2004-11-19 Thread H. Steuer
hi gents, is there a way to do replication where all database fields on the slave have the same type, but other names? i didnt investigate a binary log yet to check how queries are stored there, but maybe one of you has experiences with this kind of configuration. kind regards, heri

Re: Exportation

2003-12-08 Thread H. Steuer
use mysqldump to dump all your databases. man mysqldump should help further. regards, /H On Mon, 08 Dec 2003 22:49:30 +0100 Pierre-Etienne Mélet <[EMAIL PROTECTED]> wrote: > Hi, > > I have a question concerning the portability of the files of the > database. Is there a way to export the c

cross database queries

2003-12-08 Thread H. Steuer
hello guys, im just wondering if there are any limitations in cross database queries like: SELECT one.* FROM db1.one, db2.two; are there any differences in joining tables from within various databases to joinin tables from within the same database? the background of my question is that various u

Re: C API problems with InnoDB

2002-12-03 Thread H. Steuer
Hi Stefan, > Does the second shell actually perform those changes? In this case, I assume > it's got something to do with the isolation level / consistent read in > InnoDB tables. "shell1" sees all its changes immediately, "shell2" (the > application) has just a snapshot of the data at the time it

Re: C API problems with InnoDB

2002-12-03 Thread H. Steuer
Hello Mark, thanks for your answer. In fact the mysql shell where I update the row is using AUTOCOMMIT=1. Even after I issue a COMMIT manually the changes are not seen by the application. What I dont understand is that the program doing a SELECT has to issue an COMMIT to have all data available. M

C API problems with InnoDB

2002-12-02 Thread H. Steuer
Hello MySQL users, I have a weired issue using the MySQL C API and InnoDB tables. An application polls a database every 30 seconds. When the application starts everything seems to be fine. During the running of the application i change some rows, but the application itself doesnt see the changes a