This is confirmed working on a small test set with MySQL 4.1.22
transitioning from SPARC to X64. Thanks everyone!
-Aaron
Here's the test set we used:
CREATE TABLE `test_innodb` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`bigint` bigint(11) DEFAULT NULL,
`float` float DEFAULT NULL,
Hi,
I guess the id_file_set is an INT?
The problem si most likely due to the fact you are comparing integer to
string, which forces MySQL to use type conversion. For more information
check http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html
When type conversion occurs MySQL will not be
Hi Mauricio,
On Wed, Feb 18, 2009 at 12:58 AM, Mauricio Tellez
wrote:
> Hi, sorry if this is an offtopic. I have a web site with LAMP, one module
> use a "LOAD DATA LOCAL INFILE" statement, all was running fine, but today I
> ran this module and I get an "The used command is not allowed with this
Hi David,
On Wed, Feb 18, 2009 at 4:25 AM, Daevid Vincent wrote:
> I'm really confused. First, I don't understand why quoting my IN()
> values here caused them to run significantly slower than the non-quoted
> versions... on just this simple contrived example it can be as much as
> 2.2 seconds vs
