{"issue":{"milestone":null,"title":"[LDB-40] TEST -  view on external SQL Server table containing TIMESTAMP column","created_at":"2011-12-30T02:26:35Z","user":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","gravatar_id":"cb215b3d786be20761071a562a56af64","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"updated_at":"2011-12-30T02:26:35Z","state":"open","labels":[{"name":"LDB","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/LDB","color":"e2b9bd"},{"name":"Test","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/Test","color":"0ce5bc"}],"id":2685482,"closed_at":null,"html_url":"https://github.com/dynamobi/dynamobi/issues/281","pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"body":"<b><i>[reporter=\"jvs\", created=\"Wed, 1 Mar 2006 23:00:40 -0500 (GMT-05:00)\"]</i></b>\nBoris said I should assign this one to you.  I closed LER-461 without adding a test case, so I'm requesting one here to make sure we don't regress.<br/>\n<br/>\nTo exercise the code that had the bug, the external table needs to be specifically defined (not via IMPORT FOREIGN SCHEMA) without explicit datatypes, e.g.<br/>\n<br/>\ncreate foreign table s.t<br/>\nserver mssql_server<br/>\noptions(schema_name 'dbo', table_name 'Orders');<br/>\n<br/>\ncreate view s.v as select * from s.t;<br/>\n<br/>\nselect * from s.v;<br/>\n","number":281,"url":"https://api.github.com/repos/dynamobi/dynamobi/issues/281","comments":0,"assignee":null},"action":"opened"}