summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorVrishali Doke2012-06-12 06:41:21 (EDT)
committerStephan Born2012-06-15 10:41:51 (EDT)
commit97f95293217e1c0985a1eed641fa2b0a5d84e79f (patch)
tree59098d1b3a8c78c700533d28f2f17977fe35ad3b
parenta08d319e410bf55853bf8cf9ca22140ddc5aaf15 (diff)
downloadorg.eclipse.stardust.documentation-97f95293217e1c0985a1eed641fa2b0a5d84e79f.zip
org.eclipse.stardust.documentation-97f95293217e1c0985a1eed641fa2b0a5d84e79f.tar.gz
org.eclipse.stardust.documentation-97f95293217e1c0985a1eed641fa2b0a5d84e79f.tar.bz2
CRNT-17107 - Added transaction and non-transactional behavior of MySQL
git-svn-id: http://emeafrazerg/svn/ipp/product/trunk/stardust/documentation@57010 8100b5e0-4d52-466c-ae9c-bdeccbdeaf6b
-rw-r--r--org.eclipse.stardust.docs.dev/html/handbooks/others/troubleshooting.html11
1 files changed, 11 insertions, 0 deletions
diff --git a/org.eclipse.stardust.docs.dev/html/handbooks/others/troubleshooting.html b/org.eclipse.stardust.docs.dev/html/handbooks/others/troubleshooting.html
index bb8f6f6..0fdf2a4 100644
--- a/org.eclipse.stardust.docs.dev/html/handbooks/others/troubleshooting.html
+++ b/org.eclipse.stardust.docs.dev/html/handbooks/others/troubleshooting.html
@@ -97,6 +97,7 @@
<li><a href="#sybase">Sybase - failing invocation of parallel activities</a></li>
<li><a href="#deadlock">Sybase - deadlock situations</a></li>
<li><a href="#mysqlVersion">Some MySQL versions cause server crashes</a></li>
+ <li><a href="#tran">Mixing transactional and non-transactional behavior in MySQL</a></li>
</ul></li>
<li><a href="#dms">DMS</a>
<ul>
@@ -787,6 +788,16 @@ operation guide, for information on this property.</p>
http://bugs.mysql.com/bug.php?id=39320</a> for detailed information).</li>
</ul>
<p>All versions in between the ones mentioned above provide more stability.</p>
+
+<h4 id="tran">Mixing transactional and non-transactional behavior in MySQL</h4>
+<p>MySQL does not consider (some) errors as errors, if they happen on the second or subsequent row of a multi-row insert.
+Only if it happens on the first row, it is an error.
+To change this behavior so that every error is really an error, set:</p>
+<pre>SET SQL_MODE='STRICT_ALL_TABLES'</pre>
+
+
+
+
<h3 id="dms">DMS</h3>
<h4 id="typeMismatch">Mapping - Hidden Type Mismatch</h4>
<p>Mapping types, which are different, but which are both represented as <tt>Number</tt>