Below is the list of changes that have just been committed into a local
6.0-falcon repository of hakan. When hakan does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html
ChangeSet@stripped, 2007-04-25 15:44:47+02:00, hakank@stripped +3 -0
Removed commented test cases. Added failing test case falcon_bug_28026.test.
mysql-test/r/falcon_bug_28026.result@stripped, 2007-04-25 15:44:45+02:00, hakank@stripped +42 -0
New BitKeeper file ``mysql-test/r/falcon_bug_28026.result''
mysql-test/r/falcon_bug_28026.result@stripped, 2007-04-25 15:44:45+02:00, hakank@stripped +0 -0
mysql-test/t/disabled.def@stripped, 2007-04-25 15:44:45+02:00, hakank@stripped +1 -7
Removed commented test cases. Added failing test case falcon_bug_28026.test.
mysql-test/t/falcon_bug_28026.test@stripped, 2007-04-25 15:44:45+02:00, hakank@stripped +75 -0
New BitKeeper file ``mysql-test/t/falcon_bug_28026.test''
mysql-test/t/falcon_bug_28026.test@stripped, 2007-04-25 15:44:45+02:00, hakank@stripped +0 -0
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: hakank
# Host: lu0011.wdf.sap.corp
# Root: /home/hakan/work/mysql/mysql-5.1-falcon
--- New file ---
+++ mysql-test/r/falcon_bug_28026.result 07/04/25 15:44:45
*** Bug #28026 ***
SET @@storage_engine = 'Falcon';
DROP TABLE IF EXISTS t1;
SET @@autocommit = 0;
CREATE TABLE t1 (a int)
PARTITION BY LIST (a) (
PARTITION p8 VALUES in (8),
PARTITION p9 VALUES in (9)
);
INSERT INTO t1 VALUES (8);
INSERT INTO t1 VALUES (9);
COMMIT;
# Establish connection conn1
SET storage_engine = 'Falcon';
SET @@autocommit = 0;
# Switch to connection default
SELECT * FROM t1 WHERE a = 8 FOR UPDATE;
a
8
# Switch to connection conn1
SELECT * FROM t1 WHERE a = 9 FOR UPDATE;
a
9
# Switch to connection default
SELECT * FROM t1 WHERE a = 9 FOR UPDATE;
# Switch to connection conn1
SELECT * FROM t1 WHERE a = 8 FOR UPDATE;
a
UPDATE t1 SET a = 7 WHERE a = 8;
# Switch to connection default
a
9
COMMIT;
# Switch to connection conn1
ERROR HY000: Table has no partition for value 7
COMMIT;
# Switch to connection default
SELECT count(*) FROM t1;
count(*)
2
COMMIT;
DROP TABLE t1;
--- New file ---
+++ mysql-test/t/falcon_bug_28026.test 07/04/25 15:44:45
#
# Bug #28026: Falcon: crash if partitions and select for update
#
--echo *** Bug #28026 ***
# ----------------------------------------------------- #
# --- Initialisation --- #
# ----------------------------------------------------- #
let $engine = 'Falcon';
eval SET @@storage_engine = $engine;
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
SET @@autocommit = 0;
CREATE TABLE t1 (a int)
PARTITION BY LIST (a) (
PARTITION p8 VALUES in (8),
PARTITION p9 VALUES in (9)
);
INSERT INTO t1 VALUES (8);
INSERT INTO t1 VALUES (9);
COMMIT;
--echo # Establish connection conn1
connect (conn1,localhost,root,,);
eval SET storage_engine = $engine;
SET @@autocommit = 0;
# ----------------------------------------------------- #
# --- Test --- #
# ----------------------------------------------------- #
--echo # Switch to connection default
connection default;
SELECT * FROM t1 WHERE a = 8 FOR UPDATE;
--echo # Switch to connection conn1
connection conn1;
SELECT * FROM t1 WHERE a = 9 FOR UPDATE;
--echo # Switch to connection default
connection default;
--send SELECT * FROM t1 WHERE a = 9 FOR UPDATE
--echo # Switch to connection conn1
connection conn1;
--real_sleep 1
SELECT * FROM t1 WHERE a = 8 FOR UPDATE;
--send UPDATE t1 SET a = 7 WHERE a = 8
--echo # Switch to connection default
connection default;
--reap
COMMIT;
--echo # Switch to connection conn1
connection conn1;
--error 1514
--reap
COMMIT;
# ----------------------------------------------------- #
# --- Check --- #
# ----------------------------------------------------- #
--echo # Switch to connection default
connection default;
SELECT count(*) FROM t1;
COMMIT;
# ----------------------------------------------------- #
# --- Final cleanup --- #
# ----------------------------------------------------- #
disconnect conn1;
DROP TABLE t1;
--- 1.312/mysql-test/t/disabled.def 2007-04-25 01:56:36 +02:00
+++ 1.313/mysql-test/t/disabled.def 2007-04-25 15:44:45 +02:00
@@ -41,20 +41,15 @@
handler_falcon : 2007-01-23 hakank Currently fails
falcon-deadlock : Bug JStar#0000222: missing automatic deadlock resolution
-#falcon_temporary_alter: Bug#22089 2006-10-28 hakank (Currently fails on PB)
falcon_bug_22144 : Bug#22144 2006-08-24 hakank Get pushbuild green
falcon_bug_22151 : Bug#22151 2006-08-24 hakank (Get pushbuild green)
falcon_bug_22154 : Bug#22154 2006-11-04 hakank Too long run time for PB
-#falcon_bug_22155 : Bug#22155 2006-08-24 hakank (Get pushbuild green)
falcon_bug_22156 : Bug#22156 2006-11-04 hakank Case sensitivity problem
-#falcon_bug_22160 : Bug#22160 2006-08-24 hakank (Get pushbuild green)
falcon_bug_22165 : Bug#22165 2006-08-24 hakank (Get pushbuild green)
falcon_bug_22166 : Bug#22166 2006-08-24 hakank (Get pushbuild green)
falcon_bug_22168 : Bug#22168 2006-08-24 hakank (Get pushbuild green)
falcon_bug_22169 : Bug#22169 2006-08-24 hakank Too long run time for PB
-#falcon_bug_22170 : Bug#22170 2006-08-24 hakank (Get pushbuild green)
falcon_bug_22173 : Bug#22173 2006-08-24 hakank (Get pushbuild green)
-#falcon_bug_22175 : Bug#22175 2006-11-04 hakank Currently fails
falcon_bug_22182 : Bug#22182 2006-08-24 hakank (Get pushbuild green)
falcon_bug_22187 : Bug#22187 2006-08-24 hakank (Get pushbuild green)
falcon_bug_22189 : Bug#22189 2006-08-24 hakank (Get pushbuild green)
@@ -62,7 +57,6 @@
falcon_bug_22564 : Bug#22564 2006-10-07 hakank (Get pushbuild green)
falcon_bug_22845 : Bug#22845 2006-10-07 hakank Currently hangs
falcon_bug_22847 : Bug#22847 2006-10-03 hakank Currently hangs
-#falcon_bug_23689 : Bug#23689 2006-10-27 hakank Currently failing
falcon_bug_23692 : Bug#23692 2006-10-27 hakank Currently failing
falcon_bug_24024 : Bug#24024 2006-12-05 ML (Get pushbuild green)
falcon_bug_24921 : Bug#24921 2006-12-10 hakank Currently failing
@@ -70,11 +64,11 @@
falcon_bug_26433 : Bug#26433 2007-02-16 hakank Currently failing
falcon_bug_26607 : Bug#26607 2007-02-23 hakank Currently failing
falcon_bug_26827 : Bug#26827 2007-03-04 hakank Currently failing
-#falcon_bug_26828 : Bug#26828 2007-03-04 hakank Currently failing
falcon_bug_27350 : Bug#27350 2007-03-23 hakank Currently failing
falcon_bug_27426 : Bug#27426 2007-03-27 hakank Currently failing
falcon_bug_27697 : Bug#27697 2007-04-07 hakank Currently failing
falcon_bug_27997 : Bug#27997 2007-04-21 hakank Currently failing
+falcon_bug_28026 : Bug#28026 2007-04-25 hakank Currently failing
falcon_page_size_1 : Bug#23220 2007-02-19 hakank Currently failing
falcon_page_size_2 : Bug#23220 2007-02-19 hakank Currently failing
read_many_rows_falcon : Bug#23783 2006-10-30 ML Get pushbuild green
| Thread |
|---|
| • bk commit into 6.0-falcon tree (hakank:1.2651) | Hakan Kuecuekyilmaz | 25 Apr |
