load data infile @File

Hi,

it seems variable can't be used anywhere,
even if it could be expected::

set @File=concat('/somepath/',@loaddate);
set @File=concat(@File,'.txt');

load data infile @File
INTO TABLE t
FIELDS TERMINATED BY ' '
OPTIONALLY ENCLOSED BY '"'
(r,l,C1,C2,C3)
;


ERROR 1064: You have an error in your SQL syntax.  Check the manual
that corresponds to your MySQL server version for the right syntax to
use near '@File
INTO TABLE t
FIELDS TERMINATED BY ' '
OPTIONALLY ENCL


select version();
+------------+
| version()  |
+------------+
| 4.0.21-log |
+------------+



-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]