Nick Pasich writes:
>
> After upgrading from 3.23.32 to 3.23.35 I stopped getting statistics
> when using mysqlimport. (Records: Deleted: Skipped: Warnings:)
>
> I took a quick look at 3.23.32 mysqlimport.c and it is the same code as
> 3.23.35.
>
>
> The command
> -----------
> mysqlimport --ignore --verbose --fields-terminated-by=',' --fields-enclosed-by='"'
>traffic $BFILE
>
>
> >From 3.23.32 (is OK)
> ------------
> Connecting to localhost
> Selecting database traffic
> Loading data from SERVER file:
>/usr/local/MYSQL/DB/traffic/LOADDIR/blockedHistory.asc into blockedHistory
> traffic.blockedHistory: Records: 269 Deleted: 0 Skipped: 0 Warnings: 0
> ^^^^^^^^^^^^ ^^^^^^^^^^ ^^^^^^^^^^ ^^^^^^^^^^^
> Disconnecting from localhost
>
>
> >From 3.23.35 (No Statistics)
> ------------
> Connecting to localhost
> Selecting database traffic
> Loading data from SERVER file:
>/usr/local/MYSQL/DB/traffic/LOADDIR/blockedHistory.asc into blockedHistory
> traffic.blockedHistory:
> ^^^^^^^^^^^^ ^^^^^^^^^^ ^^^^^^^^^^ ^^^^^^^^^^^
> Disconnecting from localhost
>
>
> -----( Nick Pasich )-----
>
>
Hi!
Here is a patch for the above bug:
*** tmp/net_pkg.cc Mon Mar 19 20:16:49 2001
--- sql/net_pkg.cc Mon Mar 19 20:17:11 2001
***************
*** 148,154 ****
buff[0]=0; // No fields
pos=net_store_length(buff+1,(ulonglong) affected_rows);
pos=net_store_length(pos, (ulonglong) id);
! if (net->return_status)
{
int2store(pos,*net->return_status);
pos+=2;
--- 148,154 ----
buff[0]=0; // No fields
pos=net_store_length(buff+1,(ulonglong) affected_rows);
pos=net_store_length(pos, (ulonglong) id);
! if (net->return_status && opt_using_transactions)
{
int2store(pos,*net->return_status);
pos+=2;
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php