From 1430a2a44319aa5ca1fa1b4e626fca7cec1243ad Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 1 Mar 2005 19:05:48 -0800 Subject: Make sure that the filename for temporary tables is built with fn_format() so that extra slashes are handled in tmpdir. (Bug #8497) sql/ha_heap.cc: use constants instead of magic integers on fn_format() calls sql/sql_select.cc: Construct filename for temporary tables using fn_format() to get consistent filenames. mysql-test/t/temp_table.test: Add new regression test mysql-test/r/temp_table.result: Add new test results --- mysql-test/t/temp_table.test | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'mysql-test/t/temp_table.test') diff --git a/mysql-test/t/temp_table.test b/mysql-test/t/temp_table.test index 74276c7668c..3e60917783a 100644 --- a/mysql-test/t/temp_table.test +++ b/mysql-test/t/temp_table.test @@ -89,3 +89,12 @@ flush status; select * from t1 group by d; show status like "created_tmp%tables"; drop table t1; + +# Bug #8497: tmpdir with extra slashes would cause failures +# +create table t1 (a int, b int, index(a), index(b)); +create table t2 (c int auto_increment, d varchar(255), primary key (c)); +insert into t1 values (3,1),(3,2); +insert into t2 values (NULL, 'foo'), (NULL, 'bar'); +select d, c from t1 left join t2 on b = c where a = 3 order by d; +drop table t1, t2; -- cgit v1.2.1