I use the newest 7.7 under Windows 2003 64-bit.
When i run the following statement with JDBC
SELECT COUNT(*) AS ANZAHL, BENUTZER_ADRESSE.BUNDESLAND AS GRUPPE
FROM DOC_META, BENUTZER_ADRESSE
...
GROUP BY BENUTZER_ADRESSE.BUNDESLAND ORDER BY GRUPPE
The result columns are"ANZAHL", "BUNDESLAND".
SELECT COUNT(*) AS ANZAHL, BENUTZER_ADRESSE.BUNDESLAND & '' AS GRUPPE
In the result list the expected "ANZAHL" and "GRUPPE" will be displayed.
Is their something suspicious with my statement or is their a bug in the jdbc driver?
Regards
Stefan