Bug #17834 ndb_partition_range.test fails
Submitted: 1 Mar 2006 19:05 Modified: 2 Mar 2006 16:18
Reporter: Ingo Strüwing Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Partitions Severity:S2 (Serious)
Version:5.1.8 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[1 Mar 2006 19:05] Ingo Strüwing
Description:
*** r/ndb_partition_range.result        2006-03-01 18:45:07.000000000 +0300
--- r/ndb_partition_range.reject        2006-03-01 21:59:14.000000000 +0300
***************
*** 248,255 ****
  INSERT INTO t1 VALUES(2, '---2---');
  select * from t1;
  f1    f2
- 1     ---1---
  2     ---2---
  UPDATE t1 SET f1 = f1 + 4 WHERE f1 = 2;
  select * from t1;
  f1    f2
--- 248,255 ----
  INSERT INTO t1 VALUES(2, '---2---');
  select * from t1;
  f1    f2
  2     ---2---
+ 1     ---1---
  UPDATE t1 SET f1 = f1 + 4 WHERE f1 = 2;
  select * from t1;
  f1    f2

How to repeat:
BUILD/compile-pentium-debug-max
cd mysql-test
./mysql-test-run --ps-protocol --mysqld=--binlog-format=row ndb_partition_range
[2 Mar 2006 16:18] Valeriy Kravchuk
Thank you for a problem report. Sorry, but I was not able to repeat the problem you described with 5.1.8-BK (ChangeSet@1.2205.1.2, 2006-03-02 08:44:11+01:00):

openxs@suse:~/dbs/5.1/mysql-test> ./mysql-test-run --ps-protocol --mysqld=--binlog-format=row ndb_partition_range

Stopping master cluster
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --b
asedir=.. --datadir=mysql-test/var/master-data --skip-innodb --skip-ndbcluster -
-skip-bdb
Installing Master Databases 1
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --b
asedir=.. --datadir=mysql-test/var/master-data1 --skip-innodb --skip-ndbcluster
--skip-bdb
Installing Slave Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --b
asedir=.. --datadir=mysql-test/var/slave-data --skip-innodb --skip-ndbcluster --
skip-bdb
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

TEST                            RESULT
-------------------------------------------------------
ndb_partition_range            [ pass ]
-------------------------------------------------------

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Stopping master cluster
All 1 tests were successful.
WARNING: Got errors/warnings while running tests. Please examine
/home/openxs/dbs/5.1/mysql-test/var/log/warnings for details.

I had used simpler configure:

./configure --prefix=/home/openxs/dbs/5.1 --with-extra-charsets=all \
--with-readline --with-innodb --with-ndbcluster \
--with-mysqld-ldflags=-all-static --enable-thread-safe-client \
--with-debug=full

But does it really matter?