dynamobi/dynamobi — Issue #281: [LDB-40] TEST -  view on external SQL Server table containing TIMESTAMP column
Author: dynamobi-build
Created: 2011-12-30 02:26:35+00:00
State: open
Labels: LDB, Test

[reporter="jvs", created="Wed, 1 Mar 2006 23:00:40 -0500 (GMT-05:00)"]
Boris 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.

To 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.

create foreign table s.t

server mssql_server

options(schema_name 'dbo', table_name 'Orders');

create view s.v as select * from s.t;

select * from s.v;