Skip to Content
0
Feb 26, 2009 at 01:56 PM

MaxDB 7.7: JDBC select with alias doesn't work

67 Views

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