dynamobi/dynamobi — Issue #571: [FRG-301] Flatfile columns named "USER" will get it's data replaced
Author: dynamobi-build
Created: 2011-12-30 03:35:57+00:00
State: open
Labels: FRG, SQL Parser

[reporter="ogothberg", created="Wed, 18 Oct 2006 15:20:58 -0500 (GMT-05:00)"]
So I have a flatfile with a column named "USER" containing various usernames, that I use as a foreign data source.

If I create a view on top of that foreign table, and sample that, the "USER" column now contains 'sa' for all rows, instead of the data in the flatfile. If I rename the column, the problem goes away and I get the correct data.