Ask a Question related to PHP Development, Design and Development.
-
davefazio at annulet dot com #1
#26387 [NEW]: TABLE TEMPORARY DOES NOT WORK
From: davefazio at annulet dot com
Operating system: Windows 2003 Sever
PHP version: 5.0.0b2 (beta2)
PHP Bug Type: MySQL related
Bug description: TABLE TEMPORARY DOES NOT WORK
Description:
------------
Keep getting a FAIL when passing a CREATE TABLE TEMPORARY in PHP 5 (and
the current production release). I can run the exact same query with same
MySQL user from the command line without error.
Reproduce code:
---------------
and CREATE TABLE TEMPORARY statement should reproduce the problem.
Actual result:
--------------
mysql_query returns FALSE adn the table is not created
--
Edit bug report at [url]http://bugs.php.net/?id=26387&edit=1[/url]
--
Try a CVS snapshot (php4): [url]http://bugs.php.net/fix.php?id=26387&r=trysnapshot4[/url]
Try a CVS snapshot (php5): [url]http://bugs.php.net/fix.php?id=26387&r=trysnapshot5[/url]
Fixed in CVS: [url]http://bugs.php.net/fix.php?id=26387&r=fixedcvs[/url]
Fixed in release: [url]http://bugs.php.net/fix.php?id=26387&r=alreadyfixed[/url]
Need backtrace: [url]http://bugs.php.net/fix.php?id=26387&r=needtrace[/url]
Try newer version: [url]http://bugs.php.net/fix.php?id=26387&r=oldversion[/url]
Not developer issue: [url]http://bugs.php.net/fix.php?id=26387&r=support[/url]
Expected behavior: [url]http://bugs.php.net/fix.php?id=26387&r=notwrong[/url]
Not enough info: [url]http://bugs.php.net/fix.php?id=26387&r=notenoughinfo[/url]
Submitted twice: [url]http://bugs.php.net/fix.php?id=26387&r=submittedtwice[/url]
register_globals: [url]http://bugs.php.net/fix.php?id=26387&r=globals[/url]
PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=26387&r=php3[/url]
Daylight Savings: [url]http://bugs.php.net/fix.php?id=26387&r=dst[/url]
IIS Stability: [url]http://bugs.php.net/fix.php?id=26387&r=isapi[/url]
Install GNU Sed: [url]http://bugs.php.net/fix.php?id=26387&r=gnused[/url]
Floating point limitations: [url]http://bugs.php.net/fix.php?id=26387&r=float[/url]
davefazio at annulet dot com Guest
-
Trouble creating temporary memory table
I tried to create a temporary memory table using the following: CREATE TEMPORARY TABLE mytable_tmp LIKE mytable ENGINE=MEMORY; However, I... -
Temporary Table Creation Problem in CF7 not CF6.1
We have been preparing for our upgrade to CF7.0 from 6.1 on a test site with a test mssql database and come across an issue we cannot resolve. Maybe... -
Get result from temporary Oracle Table
Hi, Having problem with temporary table from Oracle. Runing my stored procedure (which stores an amount of row in a temporary table) from an Sql... -
Temporary Table Query
Hi, I am inserting data into a temporary table using the following method: select a into #b from c This method works fine, but...if i... -
Is there any equivalent of Sql Server's temporary table in Oracle
On Thu, 05 Dec 2002, gamaz@eathlink.net wrote: Let Oracle do the temporary set building. You code the join. -- Galen Boyer



Reply With Quote

