I'm having a problem with schema-qualified tables used in eager graphs under MSSQL:
http://pastie.org/815193 The last line in that example produces the following SQL: SELECT [s].[a].[id], [s].[a].[b_id], [s].[a].[c_id], [s].[a].[b_id], [c].[id] AS [c_id_0] FROM (SELECT * FROM [s].[a] INNER JOIN [s].[b] ON ([s].[b].[b_id] = [s].[a].[b_id])) AS [s__a] LEFT OUTER JOIN [s].[c] AS [c] ON ([c].[id] = [s].[a].[c_id]) Note the table alias [s__a]. This statement produces multiple errors from the DBMS when executed: The column 'b_id' was specified multiple times for 's__a'. The multi-part identifier "s.a.c_id" could not be bound. The multi-part identifier "s.a.id" could not be bound. ... so on for s.a.b_id, s.a.c_id, s.a.b_id -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
