[SMW-devel] Semantic Drilldown and ALTER

[Daniel F. <dan...@te...>]

It appears that Semantic Drilldown's BrowseDataPage::createTempTable is 
using a SQL ALTER command.

This would be a case of lazy coding. It adds a extra query for something 
which should be done inside of the create statement, and it also 
requires that the unprivileged mysql user has the ability to alter the 
structure of the tables, which would be considered an administrative 
thing. The ALTER command does not have a TEMPORARY like DROP does, and 
honestly does not need one since all of the definitions for a temporary 
table should be specified inside of it's creation.

-- 
~Daniel Friesen(Dantman, Nadir-Seen-Fire) of:
-The Nadir-Point Group (http://nadir-point.com)
--It's Wiki-Tools subgroup (http://wiki-tools.com)
--The ElectronicMe project (http://electronic-me.org)
--Games-G.P.S. (http://ggps.org)
-And Wikia ACG on Wikia.com (http://wikia.com/wiki/Wikia_ACG)
--Animepedia (http://anime.wikia.com)
--Narutopedia (http://naruto.wikia.com)