[teiid-commits] teiid SVN: r3722 - branches/7.6.x/engine/src/test/java/org/teiid/query/processor.
Author: jolee
Date: 2011-12-07 11:55:59 -0500 (Wed, 07 Dec 2011)
New Revision: 3722
Modified:
branches/7.6.x/engine/src/test/java/org/teiid/query/processor/TestProcessor.java
Log:
https://issues.jboss.org/browse/TEIID-1862
Unit test to prevent regression of:
https://c.na7.visual.force.com/apex/Case_View?id=500A0000008T0Ck&sfdc...
Modified:
branches/7.6.x/engine/src/test/java/org/teiid/query/processor/TestProcessor.java
===================================================================
---
branches/7.6.x/engine/src/test/java/org/teiid/query/processor/TestProcessor.java 2011-12-07
15:46:45 UTC (rev 3721)
+++
branches/7.6.x/engine/src/test/java/org/teiid/query/processor/TestProcessor.java 2011-12-07
16:55:59 UTC (rev 3722)
@@ -7653,5 +7653,35 @@
Arrays.asList(3)});
}
+ @Test public void testMultipleAliasInUnionAll(){
+ String sql = "SELECT enterprise_id FROM ( " +
+ "SELECT * FROM ( " +
+ " SELECT id, id AS display_id, 103 AS enterprise_id FROM ("
+
+ " SELECT 'x' as id, e1 FROM pm1.g1) AS nexted103) as
table103Source " +
+ "UNION ALL " +
+ "SELECT 'x', 'x' AS display_id, 101 AS
enterprise_id FROM (" +
+ " SELECT 'x', e1 FROM pm1.g1) AS nested101 " +
+ "UNION ALL " +
+ "SELECT 'x', 'x' AS display_id, 100 AS
enterprise_id FROM (" +
+ " SELECT 'x', e1 FROM pm1.g1) AS nested100) as
tableFrom1stSelect " +
+ "WHERE enterprise_id = 100";
+
+
+ // Create expected results - would expect these to be:
+ List[] expected = new List[] {
+ Arrays.asList(100)
+ };
+
+ // Construct data manager with data
+ HardcodedDataManager dataManager = new HardcodedDataManager();
+ dataManager.addData("SELECT 100 FROM pm1.g1 AS g_0", new List[]
{Arrays.asList(100)});
+
+ Command command = helpParse(sql);
+ ProcessorPlan plan = helpGetPlan(command, RealMetadataFactory.example1Cached(),
TestOptimizer.getGenericFinder(false));
+ // Run query
+ helpProcess(plan, dataManager, expected);
+
+ }
+
private static final boolean DEBUG = false;
}