I'm having the strangest issue. I am using a Perl program to test out some other Perl programs and all the Perl connections with MySQL are "normal", as in I use the standard interface. But in the test program I'm just using this:
$out = `mysql --table -e"SELECT * FROM search.Status"`; print "$out\n"; as a quick and dirty way to check on the data tables while I'm working. This test program gives this output: +--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+ | Source | Search | Stage | Status | Resource | TotalItems | CurrentItem | CheckIn | PID | +--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+ | alpha | one | 3 | waiting | 1 | -1 | -1 | 2011-0126-160720 | 0 | | alpha | two | 1 | searching | 201 | -1 | -1 | 2011-0126-160115 | 12331 | +--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+ I have two items in the first row that are my concern, the first is in the column Status, the 2nd is in the column PID. These are updated. Also, this program is a loop and after it displayed this table, I locked the screen with "ctrl-q" (in a BASH shell using Konsole on OS X with MacPorts). (Also, this system is a VM, under parallels, on another Mac and I'm using ssh to connect to that system to run all these commands.) But when I go to the console where I've logged into MySQL and display this table, I get: mysql> SELECT * FROM search.Status; +--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+ | Source | Search | Stage | Status | Resource | TotalItems | CurrentItem | CheckIn | PID | +--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+ | alpha | one | 3 | searching | 1 | -1 | -1 | 2011-0126-160120 | 12336 | | alpha | two | 1 | searching | 201 | -1 | -1 | 2011-0126-160115 | 12331 | +--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+ 2 rows in set (0.00 sec) When I go to a command line and cut and paste the command from in the program, I get this: hal@tnet-search:threshNet]$ mysql --table -e"SELECT * FROM search.Status" +--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+ | Source | Search | Stage | Status | Resource | TotalItems | CurrentItem | CheckIn | PID | +--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+ | alpha | one | 3 | searching | 1 | -1 | -1 | 2011-0126-155546 | 12294 | | alpha | two | 1 | searching | 201 | -1 | -1 | 2011-0126-155545 | 12289 | +--------+--------+-------+-----------+----------+------------+-------------+------------------+-------+ So I'm checking this data table from THREE sources, from within MySQL, from the command line, and from within the Perl program. How can I get different values in two cells in the table? Is there some kind of buffering along the way that could effect the output to the Perl program? Thanks for any ideas on this! Hal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
