Date: Fri, 7 Mar 2003 12:02:44 +0000 From: Nick Jones <nick@freebsd.cx> To: freebsd-sparc@freebsd.org Subject: Strange MySQL Behaviour Message-ID: <20030307120244.GA31139@cordelia.tachief.com>
next in thread | raw e-mail | index | archive | help
I'm having a particularly strange issue with MySQL running on an Ultra5 with a recent build of -CURRENT (uname -a is: FreeBSD amber.tachief.com 5.0-CURRENT FreeBSD 5.0-CURRENT #1: Sun Mar 2 01:32:07 GMT 2003 nick@amber.tachief.com:/usr/obj/usr/src/sys/AMBER sparc64). I can INSERT data into a table fine, but when I perform a SELECT query on the same table no results are returned. However, if I try the same INSERT statement again with a duplicate primary key, it acknowledges the dupe and the INSERT fails. Again, a subsequent SELECT returns no data. I'm using MySQL 4.0.10 compiled and installed from ports with no special options or configuration directives. A snapshot of the same database running under the same version of MySQL but under -STABLE on x86 works fine. Any clues? -- /Nick To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-sparc" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030307120244.GA31139>