MySQL Bugs: #29515: Create Falcon tablespace/datafile with backslashes does not work

Bug #29515	Create Falcon tablespace/datafile with backslashes does not work
Submitted:	3 Jul 2007 13:34	Modified:	31 Oct 2007 11:44
Reporter:	Robin Schumacher	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Falcon storage engine	Severity:	S3 (Non-critical)
Version:	6.0	OS:	Windows
Assigned to:	Sergey Vojtovich	CPU Architecture:	Any

Description:
If you use backslashes for a datafile name on Windows, the tablespace creation appears to work but no tablespace is actually created. 

How to repeat:
mysql> use gimf;
Database changed
mysql> create tablespace gimfdata1
    -> add datafile 'c:\dev\gimf1.fts'
    -> engine=falcon;
Query OK, 0 rows affected (0.00 sec)

No file is created

Thank you for the bug report. It actually creates a file devgimf1.fts on data directory see below:

c:\dev\6.0>bin\mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 6.0.1-alpha-nt Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database gimf;
Query OK, 1 row affected (0.00 sec)

mysql> use gimf
Database changed
mysql> create tablespace gimfdata1
    ->  add datafile 'c:\dev\gimf1.fts'
    -> engine=falcon;
Query OK, 0 rows affected (0.12 sec)

mysql> exit
Bye

c:\dev\6.0>dir data\*.fts
 O volume na unidade C não tem nome.
 O Número de Série do Volume é 6418-7E81

 Pasta de c:\dev\6.0\data

03/07/2007  11:39                 0 devgimf1.fts
03/07/2007  11:39                 0 falcon_master.fts
03/07/2007  11:39                 0 falcon_temporary.fts
03/07/2007  11:39                 0 falcon_user.fts
               4 arquivo(s)              0 bytes
               0 pasta(s)   49.964.924.928 bytes disponíveis

This is not a bug. DATAFILE name must be encoded as any other string.
E.g.:
SELECT 'c:\dev\gimf1.fts';
---> c:devgimf1.fts
SELECT 'c:\\dev\\gimf1.fts';
---> c:\dev\gimf1.fts