Revision 45692
| trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.mdb/src/test/resources/org/gvsig/fmap/dal/store/mdb/resultSetForSetProvider.sql | ||
|---|---|---|
| 10 | 10 |
|
| 11 | 11 |
-- Simple Group by |
| 12 | 12 |
SELECT |
| 13 |
MIN([ID]) AS [ID], MAX([Byte]) AS [Byte], NULL AS [Bool1], [Long],
|
|
| 13 |
MIN([test].[ID]) AS [ID], MAX([test].[Byte]) AS [Byte], NULL AS [Bool1], [Long],
|
|
| 14 | 14 |
NULL AS [Timestamp], NULL AS [Date], NULL AS [Time], NULL AS [Bool2], |
| 15 |
NULL AS [String], NULL AS [Bool3], SUM([Double]) AS [Double], |
|
| 15 |
NULL AS [String], NULL AS [Bool3], SUM([test].[Double]) AS [Double],
|
|
| 16 | 16 |
NULL AS [Bool4], NULL AS [Float], NULL AS [Bool5], NULL AS [Decimal], |
| 17 | 17 |
NULL AS [Geometry], NULL AS [Decimal19_0] |
| 18 | 18 |
FROM [test] |
| 19 |
GROUP BY [Long]; |
|
| 19 |
GROUP BY [test].[Long];
|
|
| 20 | 20 |
|
| 21 | 21 |
-- Subselect |
| 22 | 22 |
SELECT |
| ... | ... | |
| 38 | 38 |
|
| 39 | 39 |
-- Group and Subselect |
| 40 | 40 |
SELECT |
| 41 |
MIN([ID]) AS [ID], MAX([Byte]) AS [Byte], NULL AS [Bool1], [Long],
|
|
| 41 |
MIN([test].[ID]) AS [ID], MAX([test].[Byte]) AS [Byte], NULL AS [Bool1], [Long],
|
|
| 42 | 42 |
NULL AS [Timestamp], NULL AS [Date], NULL AS [Time], NULL AS [Bool2], |
| 43 |
NULL AS [String], NULL AS [Bool3], SUM([Double]) AS [Double], |
|
| 43 |
NULL AS [String], NULL AS [Bool3], SUM([test].[Double]) AS [Double],
|
|
| 44 | 44 |
NULL AS [Bool4], NULL AS [Float], NULL AS [Bool5], NULL AS [Decimal], |
| 45 | 45 |
NULL AS [Geometry], NULL AS [Decimal19_0] |
| 46 | 46 |
FROM [test] |
| ... | ... | |
| 49 | 49 |
FROM [countries] |
| 50 | 50 |
WHERE (([TEST].[STRING] = [countries].[CONTINENT]) AND |
| 51 | 51 |
([countries].[LASTCENSUS] < 0)) LIMIT 1)),TRUE,FALSE) |
| 52 |
GROUP BY [Long]; |
|
| 52 |
GROUP BY [test].[Long];
|
|
| 53 | 53 |
|
| 54 | 54 |
-- Simple |
| 55 | 55 |
SELECT |
Also available in: Unified diff