Bug #1039 tmpdir and datadir not available via @@ system variable syntax

Submitted: 13 Aug 2003 5:54 Modified: 22 May 2006 1:27
Reporter: Tim Bunce Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:
Assigned to: Jim Winstead CPU Architecture:Any

[13 Aug 2003 5:54] Tim Bunce
Description:
My specific need is for

  create TEMPORARY table ... DATA DIRECTORY=@@datadir

to work so I can create temporary table that are not stored in tmpdir
(which may be a swap space filesystem and too small to use in some cases).

Apart from making @@datadir available it may require changes to the parser.

How to repeat:
mysql> select @@datadir;
ERROR 1193: Unknown system variable 'datadir'

Suggested fix:
Make all system variables available via the @@ syntax for consistency.
[10 Nov 2003 8:07] Boyd Gerber
This has been turned into a feature request
[7 May 2006 23:45] Roland Bouman
Is anyone considering to implement this? 

I sure hope so.
[8 May 2006 0:19] Roland Bouman
Actually, what I mean is the implementation of 

select @@datadir;

Not the ability to reference that value in a CREATE TABLE statement. 

It seems mighty odd that:

mysql> show variables like 'datadir';
+---------------+---------------------------------+
| Variable_name | Value                           |
+---------------+---------------------------------+
| datadir       | D:\MySQL\MySQL Server 5.1\Data\ |
+---------------+---------------------------------+
1 row in set (0.00 sec)

, but:

mysql> select @@datadir;
ERROR 1193 (HY000): Unknown system variable 'datadir'
mysql>
[8 May 2006 23:36] Jim Winstead
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6131
[20 May 2006 1:50] Jim Winstead
Fixed in 5.0.22. Merge to 5.1 is still pending.
[20 May 2006 6:07] Jim Winstead
Fixed in 5.0.22 and 5.1.11.
[22 May 2006 1:27] Paul DuBois
Noted in 5.0.22, 5.1.11 changelogs.

The <literal>basedir</literal> and <literal>tmpdir</literal>
system variables could not be access via
<literal>@@<replaceable>var_name</replaceable></literal>
syntax. (Bug #1039)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.