diff options
| author | unknown <evgen@moonbone.local> | 2007-02-07 00:46:03 +0300 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2007-02-07 00:46:03 +0300 |
| commit | 976f0a391c9d20982d495cd01ab6e8f701d915fd (patch) | |
| tree | 56c0e739bcc59645b6b36a4c468a1034d31858df /tools | |
| parent | c35ceeca9e11062516bd93d10d89ac818a6e1f23 (diff) | |
| download | mariadb-git-976f0a391c9d20982d495cd01ab6e8f701d915fd.tar.gz | |
Bug#19978: INSERT .. ON DUPLICATE erroneously reports some records were
updated.
INSERT ... ON DUPLICATE KEY UPDATE reports that a record was updated when
the duplicate key occurs even if the record wasn't actually changed
because the update values are the same as those in the record.
Now the compare_record() function is used to check whether the record was
changed and the update of a record reported only if the record differs
from the original one.
sql/sql_update.cc:
Bug#19978: INSERT .. ON DUPLICATE erroneously reports some records were
updated.
The compare_record() function was changed to non-static one.
sql/sql_insert.cc:
Bug#19978: INSERT .. ON DUPLICATE erroneously reports some records were
updated.
Now the compare_record() function is used to check whether the record was
changed and the update of a record reported only if the record differs
from the original one.
sql/mysql_priv.h:
Bug#19978: INSERT .. ON DUPLICATE erroneously reports some records were
updated.
Added the prototype of the compare_record() function.
mysql-test/t/insert_select.test:
Added a test case for bug#19978: INSERT .. ON DUPLICATE erroneously reports
some records were updated.
mysql-test/r/insert_select.result:
Added a test case for bug#19978: INSERT .. ON DUPLICATE erroneously reports
some records were updated.
Diffstat (limited to 'tools')
0 files changed, 0 insertions, 0 deletions