replication bug

Hi,

when I use variables replication fails...

how-to-repeat:

On the Master:

mysql> drop table a;
Query OK, 0 rows affected (0.00 sec)

mysql> create table a (id int);
Query OK, 0 rows affected (0.00 sec)

mysql> set @a = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into a values (@a);
Query OK, 1 row affected (0.00 sec)

mysql> select * from a;
+------+
| id |
+------+
| 1 |
+------+
1 row in set (0.00 sec)


On the Slave:

mysql> select * from a;
+------+
| id |
+------+
| NULL |
+------+
1 row in set (0.00 sec)

Regards

Georg

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13300@lists.mysql.com
To unsubscribe, e-mail

Re: replication bug

On Monday 16 December 2002 19:53, Georg Richter wrote:

forgot the version: 4.1 latest bk

Georg

filter: how-to-repeat

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13301@lists.mysql.com
To unsubscribe, e-mail

Re: replication bug

On Mon, Dec 16, 2002 at 07:53:00PM +0100, Georg Richter wrote:
> Hi,
>
> when I use variables replication fails...

It is documented as not working.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
| http://jeremy.zawodny.com/

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13302@lists.mysql.com
To unsubscribe, e-mail

Re: replication bug

Georg Richter writes:
> Hi,
>
> when I use variables replication fails...
>
> how-to-repeat:
>
> On the Master:
>

[skip]

> Regards
>
> Georg
>

Hi!

This is a known issue, which we have very recently started to solve
in our 4.1 BK tree.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13303@lists.mysql.com
To unsubscribe, e-mail