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

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

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: replication and other col names

2004-11-19 Thread H. Steuer
Hi Gleb, is that a no? Not having it in the docs doesnt mean that it is not possible :) regards, heri - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 19, 2004 4:35 PM Subject: Re: replication and other col names Hello. There

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

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

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.

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

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