Bug #33153 Update with primary key effect all rows
| Submitted: | 11 Dec 2007 20:12 | Modified: | 4 May 2009 7:37 |
|---|---|---|---|
| Reporter: | Fuat Akgn | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S2 (Serious) |
| Version: | 5.0.45 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | primary key, UPDATE, whole table | ||
[12 Dec 2007 12:34]
Tonci Grgin
Fuat, this is in no way enough information for me to start working on this report. Please attach/check following: - What is your MyODBC version. - Please attach *full* test case. - Please check general query log from MySQL server at the time error occurs. To start server with logging, please see manual. What is the actual update command issued? - Please check http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q190727&GSSNB=1. You can use it like this: Dim rs Set rs = CreateObject("ADODB.Recordset") With rs .ActiveConnection = cnxDatabase .CursorLocation = adUseClient .LockType = adLockOptimistic .CursorType = adOpenForwardOnly .Properties("Update Criteria").Value = 0 .Open(strSQL) .Update "Name", "nesto_drugo" End With - Please attach DM trace log (Start/Control Panel/Administrative Tools/Data Sources (ODBC)/ Tracing tab). - Is your table error free? Did you check it recently?
[13 Jan 2008 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[30 Apr 2009 19:04]
Fuat Akgn
The same problem is here http://bugs.mysql.com/bug.php?id=35881
[4 May 2009 7:37]
Tonci Grgin
Thanks Fuat. Marking this report as duplicate of Bug#35881.
[10 Mar 2011 13:05]
Tapas Barman
Hi, i have sqL server running well, and i want to develop a web program using PHP and MySQL as database. i use SQL server 2005 dan MySQL 5.0, i want to my SQL Server automatic migrate the data to MySQL Server. So i make a proc to delete old data in MySQL Server and Insert new data to it. but when i want delete/query at about 10 million data from sql server to mysql server using ODBC 5.1 Driver, My SQL Server give error " OLE DB provider "MSDASQL" for linked server "CON_MYSQL" returned message "[MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]MySQL client ran out of memory"." Please Help me to solve my problem. thx.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.060 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: Hi, I am working on my local MySQL server whose version is 5.0.45 I sometimes have problem with updating a table over an primary key with asp rs.open"select davetiye from uye where id=1",bag,1,3 rs(0) = rs(0) - 1 rs.update rs.close Everytime this sql command executed "davetiye"(integer) column must be decremented by 1 over recordset object which is used in ASP. This problem is not first time but it doesn't always occure. I am giving my table named "uye" DROP TABLE IF EXISTS `bocuk`.`uye`; CREATE TABLE `bocuk`.`uye` ( `id` int(10) unsigned NOT NULL auto_increment, `ad` varchar(45) default NULL, `email` varchar(100) default NULL, `davetiye` int(10) unsigned default '20', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin5; How to repeat: This problem is not first time but it doesn't always occure as I said. But I really don't know when or how this became... Suggested fix: When i use rs.open"select * from uye where id=1",bag,1,3 rs("davetiye") = rs("davetiye") - 1 rs.update rs.close there will be no problem and only the correct row will be efected.