On Tue, 24 Jul 2007, Mathias Gug wrote: > On Tue, Jul 24, 2007 at 07:41:48PM -0000, Patrik Wallström wrote: > > I don't really understand what you mean. I used the MySQL from Dapper, > > works fine in x86 and fails on amd64. > Can you provide a specific test case ?
Here is the diff that fixed our problem: SELECT DOMAINS.* FROM DOMAINS -WHERE DATE_ADD(REGDATE, INTERVAL 5 DAY) < NOW() -AND '".$welcome_desc."' NOT IN ( -SELECT VALUE FROM DOMAIN_LOG -WHERE DOMAIN_LOG.DOMAIN_ID=DOMAINS.DOMAIN_ID AND -LOGDATE > DOMAINS.REGDATE -) +LEFT JOIN DOMAIN_LOG + ON (DOMAIN_LOG.DOMAIN_ID=DOMAINS.DOMAIN_ID AND + DOMAIN_LOG.VALUE='".$welcome_desc." AND + LOGDATE > DOMAINS.REGDATE') +WHERE +DATE_ADD(REGDATE, INTERVAL 5 DAY) < NOW() AND +DOMAIN_LOG.VALUE IS NULL AND STATE = ".DOMAIN_ACTIVE." It would take a lot of effort to strip out the tables and generate test data for you, but let me know if you really need it. I may not be able to reach my people right now since everybody is on vacation in Sweden. But you might be able figure out the relevant schema by looking at the above SQL statements. -- patrik_wallstrom->foodfight->[EMAIL PROTECTED]>+46-733173956 -- subselect bug in amd64 compiled version https://bugs.launchpad.net/bugs/84209 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs