MySQL Release?

Hi, I noticed that the 6.11 branch is not available for download anymore. Did they rename it to 5.4? Thanks, -Alex

6.0.11 source

Anyone knows where I can download the 6.0.11 gziped source from?

Re: SOS mysql signal syntax error

> DECLARE divide_by_zero CONDITION FOR SQLSTATE '22012'; > IF divisor = 0 THEN > SIGNAL divide_by_zero; > END IF; > END > > Methinks someone forgot to include this feature in the release! > > > -Original Message- > From: Alex Katebi [mailto:alex.

SOS mysql signal syntax error

Hi Folks, I am getting syntax error with the mysql signal. I have a trigger that needs a signal for raising an error condition if a row with specific value is removed. CREATE TRIGGER my_trig BEFORE DELETE ON my_tbl FOR EACH ROW BEGIN DECLARE mysig CONDITION FOR SQLSTATE '45000';

What is wrong with this SYNTAX?

It is complaining about near STRCMP. CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global FOR EACH ROW BEGIN IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN set NEW.Variable_name=NULL; ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN set NEW.Variable_name=NULL ELSEIF STRCM

Re: Native Function

Hello Martin, This sounds great! I am not sure if plugins are supported for the embedded mysql applications. Meaning that my application is linked with the libmysqld not libmysql. Do you know the answer? Thanks, Alex On Mon, May 18, 2009 at 10:17 AM, Martin Gainty wrote: > yes if the lib

Native Function

Hi All, I am using the mysql embedded library (libmysqld) in my application. I am using triggers and calling a C/C++ function in my application. This is how I convey configuration changes to my application. I think my only choice is to make a Native Function in the mysql source code since UDF

Re: AMD64

On Tue, Apr 7, 2009 at 11:17 AM, Martijn Tonies wrote: > Alex, > > Please respond to the list instead of my personal address. sorry I thought i was. > > > > Nevertheless, if MYSQL_TYPE_LONG is the datatype for a table field, > it would always -have- to be the same size, cause different clients c

passing a bad pointer question

Hi, If I have a mysql client application that passes a bad MYSQL* connection pointer to the server. How does the server cope with that. Does the server crash? Or does the server drops the client connection? Or does the server ignore the function call and return error? If it returns error what i

AMD64

Hi, What is the size of MYSQL_TYPE_LONG in a 64bit machine? I am trying to save pointers. If this type is 4 bytes on a 32bit machine and 8 bytes on a 64bit machine will make it much easier. Thanks, -Alex

is this a bug?

In mysql embedded server 6.09 built from source for Linux 2.6.27.11 kernel. First create a connection (mysql_real_connect) then close the connection in a different thread. This causes a SIGSEGV crash in THD:store_globals ( ). My mysql embedded library is thread-safe. Thanks in advance, -Alex

Autoconf & --basedir

Anyone knows how to figure out the mysql basedir string using Autoconf and then pass it to Automake for an embedded application? Thanks in advance, -Alex

stored procedures & embedded server

For embedded server do I need to configure --with-embedded-privilege-control? It looks like stored procedure is looking for mysql.proc table. Thanks.

embedded client test scripts

Any information on how to run the test scripts for the embedded client. Thanks, -Alex

Tables are too wide

Hi, When selecting (example: select * from mysql.db ) some of the mysql database tables the result set does not fit in a standard xterm window. Is there any terminal display program in Linux that has a horizontal scroll bar that I can use? Or what can I do to split the table output to fit on my

UDF Question

Hello, I am planning to write a UDF (User Defined Function) that acts like a server side client. This UDF is called by a client first. After that the UDF spwans a thread then exits. Within this spawned thread it will get work from a network socket. After that it will start executing SQL statemen

mysql user and authentication ???

Hello, I just installed the 6.0.6 version of the mysqld on Linux using the binary RPM. The RPM installed all the programs then it started the mysqld server. I read lots of documents about mysql user and password. But I have no idea what the users are used for, and how users are created. The

starting mysqld on Linux fedora

Hello, Is there any documentation on how to start the mysqld server. I have installed version 6.0 server and client. But I don't know how to start the server correctly. Thanks, -Alex