Closed (fixed)
Project:
Drupal core
Version:
6.x-dev
Component:
comment.module
Priority:
Critical
Category:
Task
Assigned:
Reporter:
Created:
6 Nov 2007 at 18:13 UTC
Updated:
21 Nov 2007 at 16:04 UTC
http://dev.mysql.com/doc/refman/4.1/en/insert-select.html
Prior to MySQL 4.0.14, the target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. This limitation is lifted in 4.0.14.
We require MySQL 4.1.
| Comment | File | Size | Author |
|---|---|---|---|
| db_temp_table_joins_lock_table_in_the_grave.patch | 962 bytes | chx |
Comments
Comment #1
catch#189832 was duplicate, yay!
Comment #2
FiReaNGeL commentedMake perfect sense to me; I wasn't even aware of that limitation in pre 4.1 MySQL.
Comment #3
catchdisabled comment module.
Posted a node - no record made in node_comment_statistics
applied the patch
enabled comment module
node_comment_statistics was updated, and the values were all fine.
Bye bye then.
Comment #4
chx commentedTo continue the quote from MySQL manual
I just tested that INSERT...SELECT works into the same table with just INSERT and SELECT grants. So while the manual says there is a temporary table being made that's behind the scenes, somewhat similar to the well known fact that some ordinary SELECTs result in a temporary table (and when those get on disk, your performance plumets).
Comment #5
gábor hojtsyWho tested this on PostgreSQL?
Comment #6
chx commentedMe.
Comment #7
gábor hojtsyOK, committed, thanks.
Comment #8
(not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.