Further to this, I should point out everything works fine in mysql-front or
at the mysql console.
The problem shows up when using mysql++, a BadQuery exception is thrown.
query.reset();
query << "CREATE TEMPORARY TABLE " << sTemporary << " TYPE=HEAP
MAX_ROWS=10000 " << subselect;
try
{
query.parse();
query.execute();
}
----- Original Message -----
From: "Phil Bitis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 12:41 PM
Subject: Create Temporary Table problem
> As a way of getting around the lack of subselect (I'm aware this is coming
> soon) we're parsing sql queries, running subselects and storing their
> results in a temporary table and replacing the subselect in the sql with
the
> temporary table name.
>
> This has been working fine, but on upgrading to v4.0.13 the "CREATE
> TEMPORARY TABLE <some sql>" part is failing with this error:
>
> Access denied for user: '@localhost' to database 'uclan_database'
>
> Any ideas?
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
