summaryrefslogtreecommitdiff
path: root/sql/sql_delete.cc
diff options
context:
space:
mode:
authorunknown <monty@tik.mysql.fi>2001-07-16 03:04:30 +0300
committerunknown <monty@tik.mysql.fi>2001-07-16 03:04:30 +0300
commit2a18a762e1d4c688ff169e92a8c3977bcbb00f03 (patch)
tree12ce618a9c1f4bb3a79632d66e11232e84ab2e12 /sql/sql_delete.cc
parentcb696ba1f3f7d64dbedd64487c7d02660251f98f (diff)
downloadmariadb-git-2a18a762e1d4c688ff169e92a8c3977bcbb00f03.tar.gz
Patch for netBSD
Added warning for tables where the auto_increment key is 0 Fixed DELETE ... LIMIT 0 Fixed UPDATE ..LIMIT 0 Docs/manual.texi: Changelog + Update to CHECK TABLE configure.in: Patch for netBSD mit-pthreads/gen/ctime.c: Patch for netBSD mit-pthreads/machdep/netbsd-1.1/__signal.h: Patch for netBSD mit-pthreads/stdio/strerror.c: Patch for netBSD myisam/mi_check.c: Added warning for tables where the auto_increment key is 0 myisam/myisamchk.c: Added warning for tables where the auto_increment key is 0 mysql-test/r/auto_increment.result: Added warning for tables where the auto_increment key is 0 mysql-test/r/limit.result: Test of DELETE ... LIMIT 0 mysql-test/t/auto_increment.test: Added warning for tables where the auto_increment key is 0 mysql-test/t/limit.test: Test of DELETE ... LIMIT 0 sql/Makefile.am: Don't add mysqld_LDADD to mysqlbinlog (portability patch) sql/ha_gemini.cc: Changed copyright (have got ok from NuSphere previously) sql/ha_gemini.h: Changed copyright (have got ok from NuSphere previously) sql/sql_delete.cc: Fixed DELETE ... LIMIT 0 sql/sql_update.cc: Fixed UPDATE ..LIMIT 0
Diffstat (limited to 'sql/sql_delete.cc')
-rw-r--r--sql/sql_delete.cc7
1 files changed, 4 insertions, 3 deletions
diff --git a/sql/sql_delete.cc b/sql/sql_delete.cc
index 587b205886e..8b4b1b527ca 100644
--- a/sql/sql_delete.cc
+++ b/sql/sql_delete.cc
@@ -170,12 +170,13 @@ int mysql_delete(THD *thd,TABLE_LIST *table_list,COND *conds,ha_rows limit,
select=make_select(table,0,0,conds,&error);
if (error)
DBUG_RETURN(-1);
- if (select && select->check_quick(test(thd->options & SQL_SAFE_UPDATES),
- limit))
+ if ((select && select->check_quick(test(thd->options & SQL_SAFE_UPDATES),
+ limit)) ||
+ !limit)
{
delete select;
send_ok(&thd->net,0L);
- DBUG_RETURN(0);
+ DBUG_RETURN(0); // Nothing to delete
}
/* If running in safe sql mode, don't allow updates without keys */