[Bug 352321] Re: mysql queries "lose" results

[Martin Wimmer]

ok, thank you for your quick reply. I now created an import script and
tested it.

With it I could also reproduce this bug on intrepid.

To see how the results of the query should normally look like, try to insert a dummy entry into the temp table:
INSERT INTO `plib_objects_plib_objects_dbo_temp` (`oid`, `expires`) VALUES
(-1, '2030-01-01 00:00:00');

After creating it the bug disappears. If you delete it, the bug appears
again.


** Attachment added: "SQL Script to create the problematic database"
   http://launchpadlibrarian.net/24575162/bug.sql

-- 
mysql queries "lose" results
https://bugs.launchpad.net/bugs/352321
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.