netripper

-- Testcase to demonstrate an "Invalid bookmark." problem on SQL Compact 3.5 SP1
--
-- This can be solved by using nvarchar(4000) instead of ntext. However, that is not a feasible solution in my case. I'd rather not
-- use BLOBs either.
--
DROP TABLE Foo
GO
DROP TABLE Bar
GO
CREATE TABLE Foo (
      Id INT NOT NULL,
      MyText ntext NULL
)
GO
CREATE TABLE Bar (
      Id INT NOT NULL,
      MyText ntext NULL
)
GO
INSERT INTO Bar VALUES (1, 'MyText')
GO
SELECT Dora.MyText
  FROM (
            SELECT Id, MyText
              FROM Foo

             UNION ALL

            SELECT Id, MyText
              FROM Bar
         ) AS Dora
GO

-- Result:
-- (1 row(s) affected)
-- Major Error 0x80040E0E, Minor Error 0
-- > SELECT Dora.MyText
--   FROM (
--               SELECT Id, MyText
--                 FROM Foo
--
--                UNION ALL
--
--               SELECT Id, MyText
--                 FROM Bar
--           ) AS Dora
-- Invalid bookmark.