Index: Doc/Extra/Provider/version.html
==================================================================
--- Doc/Extra/Provider/version.html
+++ Doc/Extra/Provider/version.html
@@ -47,10 +47,11 @@
     <ul>
       <li>Updated to <a href="http://www.sqlite.org/releaselog/3_8_7_1.html">SQLite 3.8.7.1</a>.</li>
       <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li>
       <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to <a href="http://system.data.sqlite.org/index.html/info/e122d26e70">[e122d26e70]</a>.</li>
       <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for <a href="http://system.data.sqlite.org/index.html/info/daeaf3150a">[daeaf3150a]</a>.</li>
+      <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for <a href="http://system.data.sqlite.org/index.html/info/0a32885109">[0a32885109]</a>.</li>
       <li>In the SQLiteDataReader.VerifyType method, remove duplicate &quot;if&quot; statement for the DbType.SByte value and move the remaining &quot;if&quot; to the Int64 affinity. Fix for <a href="http://system.data.sqlite.org/index.html/info/c5cc2fb334">[c5cc2fb334]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
       <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for <a href="http://system.data.sqlite.org/index.html/info/3e783eecbe">[3e783eecbe]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
     </ul>
     <p><b>1.0.94.0 - September 9, 2014</b></p>
     <ul>

Index: System.Data.SQLite.Linq/SQL Generation/SqlGenerator.cs
==================================================================
--- System.Data.SQLite.Linq/SQL Generation/SqlGenerator.cs
+++ System.Data.SQLite.Linq/SQL Generation/SqlGenerator.cs
@@ -2468,18 +2468,35 @@
 
     ISqlFragment VisitSetOpExpression(DbExpression left, DbExpression right, string separator)
     {
 
       SqlSelectStatement leftSelectStatement = VisitExpressionEnsureSqlStatement(left);
+      bool leftOrderByLimitOrOffset = leftSelectStatement.HaveOrderByLimitOrOffset();
       SqlSelectStatement rightSelectStatement = VisitExpressionEnsureSqlStatement(right);
+      bool rightOrderByLimitOrOffset = rightSelectStatement.HaveOrderByLimitOrOffset();
 
       SqlBuilder setStatement = new SqlBuilder();
+
+      if (leftOrderByLimitOrOffset)
+          setStatement.Append("SELECT * FROM (");
+
       setStatement.Append(leftSelectStatement);
+
+      if (leftOrderByLimitOrOffset)
+          setStatement.Append(") ");
+
       setStatement.AppendLine();
       setStatement.Append(separator); // e.g. UNION ALL
       setStatement.AppendLine();
+
+      if (rightOrderByLimitOrOffset)
+          setStatement.Append("SELECT * FROM (");
+
       setStatement.Append(rightSelectStatement);
+
+      if (rightOrderByLimitOrOffset)
+          setStatement.Append(") ");
 
       return setStatement;
     }
 
 

Index: System.Data.SQLite.Linq/SQL Generation/SqlSelectStatement.cs
==================================================================
--- System.Data.SQLite.Linq/SQL Generation/SqlSelectStatement.cs
+++ System.Data.SQLite.Linq/SQL Generation/SqlSelectStatement.cs
@@ -193,10 +193,31 @@
     internal bool IsTopMost
     {
       get { return this.isTopMost; }
       set { this.isTopMost = value; }
     }
+
+    /// <summary>
+    /// Checks if the statement has an ORDER BY, LIMIT, or OFFSET clause.
+    /// </summary>
+    /// <returns>
+    /// Non-zero if there is an ORDER BY, LIMIT, or OFFSET clause;
+    /// otherwise, zero.
+    /// </returns>
+    public bool HaveOrderByLimitOrOffset()
+    {
+        if ((this.orderBy != null) && !this.orderBy.IsEmpty)
+            return true;
+
+        if (this.top != null)
+            return true;
+
+        if (this.skip != null)
+            return true;
+
+        return false;
+    }
 
     #region ISqlFragment Members
 
     /// <summary>
     /// Write out a SQL select statement as a string.

ADDED   Tests/tkt-0a32885109.eagle
Index: Tests/tkt-0a32885109.eagle
==================================================================
--- /dev/null
+++ Tests/tkt-0a32885109.eagle
@@ -0,0 +1,64 @@
+###############################################################################
+#
+# tkt-0a32885109.eagle --
+#
+# Written by Joe Mistachkin.
+# Released to the public domain, use at your own risk!
+#
+###############################################################################
+
+package require Eagle
+package require Eagle.Library
+package require Eagle.Test
+
+runTestPrologue
+
+###############################################################################
+
+package require System.Data.SQLite.Test
+runSQLiteTestPrologue
+runSQLiteTestFilesPrologue
+
+###############################################################################
+
+runTest {test tkt-0a32885109-1.1 {LINQ compound-operator handling} -body {
+  #
+  # NOTE: Re-copy the reference database file used for this unit test to the
+  #       build directory in case it has been changed by a previous test run.
+  #
+  file copy -force $northwindEfDbFile \
+      [file join [getBuildDirectory] [file tail $northwindEfDbFile]]
+
+  set result [list]
+  set output ""
+
+  set code [catch {
+    testClrExec $testLinqExeFile [list -eventflags Wait -directory \
+        [file dirname $testLinqExeFile] -nocarriagereturns -stdout output \
+        -success 0] -unionall
+  } error]
+
+  tlog "---- BEGIN STDOUT OUTPUT\n"
+  tlog $output
+  tlog "\n---- END STDOUT OUTPUT\n"
+
+  lappend result $code
+
+  if {$code == 0} then {
+    lappend result [string trim $output]
+  } else {
+    lappend result [string trim $error]
+  }
+
+  set result
+} -cleanup {
+  unset -nocomplain code output error result
+} -constraints {eagle monoToDo SQLite file_System.Data.SQLite.dll testExec\
+file_System.Data.SQLite.Linq.dll file_testlinq.exe file_northwindEF.db} \
+-result {0 {WHITC ANATR BERGS WHITC ANATR WHITC ANATR BERGS}}}
+
+###############################################################################
+
+runSQLiteTestFilesEpilogue
+runSQLiteTestEpilogue
+runTestEpilogue

Index: readme.htm
==================================================================
--- readme.htm
+++ readme.htm
@@ -214,10 +214,11 @@
 <ul>
     <li>Updated to <a href="http://www.sqlite.org/releaselog/3_8_7.html">SQLite 3.8.7</a>.</li>
     <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li>
     <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to [e122d26e70].</li>
     <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for [daeaf3150a].</li>
+    <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for [0a32885109].</li>
     <li>In the SQLiteDataReader.VerifyType method, remove duplicate &quot;if&quot; statement for the DbType.SByte value and move the remaining &quot;if&quot; to the Int64 affinity. Fix for [c5cc2fb334].&nbsp;<b>** Potentially Incompatible Change **</b></li>
     <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for [3e783eecbe].&nbsp;<b>** Potentially Incompatible Change **</b></li>
 </ul>
 <p>
     <b>1.0.94.0 - September 9, 2014</b>

Index: testlinq/Program.cs
==================================================================
--- testlinq/Program.cs
+++ testlinq/Program.cs
@@ -74,10 +74,14 @@
                               pageSize = int.Parse(arg.Trim());
                       }
 
                       return SkipTest(pageSize);
                   }
+              case "unionall":
+                  {
+                      return UnionAllTest();
+                  }
               case "endswith":
                   {
                       string value = null;
 
                       if (args.Length > 1)
@@ -215,10 +219,81 @@
                   Console.Write(customers.CustomerID);
 
                   once = true;
               }
           }
+
+          return 0;
+      }
+
+      //
+      // NOTE: Used to test the fix for ticket [0a32885109].
+      //
+      private static int UnionAllTest()
+      {
+          using (northwindEFEntities db = new northwindEFEntities())
+          {
+              bool once = false;
+
+              var customers1 = db.Customers.Where(
+                  f => f.Orders.Any()).OrderByDescending(
+                    f => f.CompanyName).Skip(1).Take(1);
+
+              var customers2 = db.Customers.Where(
+                  f => f.Orders.Any()).OrderBy(
+                    f => f.CompanyName).Skip(1).Take(1);
+
+              var customers3 = db.Customers.Where(
+                  f => f.CustomerID.StartsWith("B")).OrderBy(
+                    f => f.CompanyName).Skip(1).Take(1);
+
+              foreach (var customer in customers1)
+              {
+                  if (once)
+                      Console.Write(' ');
+
+                  Console.Write(customer.CustomerID);
+                  once = true;
+              }
+
+              foreach (var customer in customers2)
+              {
+                  if (once)
+                      Console.Write(' ');
+
+                  Console.Write(customer.CustomerID);
+                  once = true;
+              }
+
+              foreach (var customer in customers3)
+              {
+                  if (once)
+                      Console.Write(' ');
+
+                  Console.Write(customer.CustomerID);
+                  once = true;
+              }
+
+              foreach (var customer in customers1.Concat(customers2))
+              {
+                  if (once)
+                      Console.Write(' ');
+
+                  Console.Write(customer.CustomerID);
+                  once = true;
+              }
+
+              foreach (var customer in
+                    customers1.Concat(customers2).Concat(customers3))
+              {
+                  if (once)
+                      Console.Write(' ');
+
+                  Console.Write(customer.CustomerID);
+                  once = true;
+              }
+          }
 
           return 0;
       }
 
       //

Index: www/news.wiki
==================================================================
--- www/news.wiki
+++ www/news.wiki
@@ -8,10 +8,11 @@
 <ul>
     <li>Updated to [http://www.sqlite.org/releaselog/3_8_7_1.html|SQLite 3.8.7.1].</li>
     <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li>
     <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to [e122d26e70].</li>
     <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for [daeaf3150a].</li>
+    <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for [0a32885109].</li>
     <li>In the SQLiteDataReader.VerifyType method, remove duplicate &quot;if&quot; statement for the DbType.SByte value and move the remaining &quot;if&quot; to the Int64 affinity.  Fix for [c5cc2fb334].&nbsp;<b>** Potentially Incompatible Change **</b></li>
     <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for [3e783eecbe].&nbsp;<b>** Potentially Incompatible Change **</b></li>
 </ul>
 <p>
     <b>1.0.94.0 - September 9, 2014</b>