diff options
| author | unknown <jimw@mysql.com> | 2005-03-01 19:05:48 -0800 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-03-01 19:05:48 -0800 |
| commit | 1430a2a44319aa5ca1fa1b4e626fca7cec1243ad (patch) | |
| tree | d4401945cb12d0479d56b038315a2c864f68e2d9 /mysql-test/r/temp_table.result | |
| parent | abd8200f77a0b5c8463628fa921f998cbf7498f9 (diff) | |
| download | mariadb-git-1430a2a44319aa5ca1fa1b4e626fca7cec1243ad.tar.gz | |
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
Diffstat (limited to 'mysql-test/r/temp_table.result')
| -rw-r--r-- | mysql-test/r/temp_table.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/temp_table.result b/mysql-test/r/temp_table.result index 10c0a2e3652..f08fe6ddd0f 100644 --- a/mysql-test/r/temp_table.result +++ b/mysql-test/r/temp_table.result @@ -97,3 +97,12 @@ Variable_name Value Created_tmp_disk_tables 0 Created_tmp_tables 1 drop table t1; +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; +d c +bar 2 +foo 1 +drop table t1, t2; |