dropwizard-jdbi creating query with concat generate NullPointerException

[grugna]

this query works fine:
"SELECT cd.display_name AS name
FROM city_dct as cd
WHERE cd.display_name LIKE :partialName"

this query does not:
"SELECT cd.display_name AS name, concat('-',cd.city_cd) AS dbIDMultiKey
FROM city_dct as cd
WHERE cd.display_name LIKE :partialName"

The metadata generated has null values for tableName and the other attributes when the select concat is created

.

[jhaber]

Thanks for opening this issue, I think I see the problem and it should be an easy fix. So I can verify the fix, may I ask which version of Rosetta you're using and which database/driver?

[grugna]

com.hubspot.rosetta RosettaJdbi 3.11.2

I am using MySQL (ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci)
Thank you, let me know if you need anything else.

[jhaber]

I was a bit surprised you said MySQL since we use MySQL at HubSpot and haven't run into this issue. I tried reproducing the exception but didn't have any luck (I kept getting back an empty string for the table name, and I tried with useOldAliasMetadataBehavior enabled and disabled). 164f2bf should fix the exception (I'll cut a release shortly), but I'm still curious as to the exact conditions under which the NPE manifests. Are you using mysql-connector-java as the driver? If so, which version? What is the MySQL server version?

[jhaber]

164f2bf is included in version 3.11.7 which should show up in Maven Central shortly. Can you confirm that it fixes the NPE you were seeing?

[grugna]

Thank you! I will try it later today and I will send you all my version used

[grugna]

version 3.11.7 solved the issue, thank you again.
I am using MySQL 5.7.18, jackson, mysql-connector-java 6.0.6. If you need any other information feel free to ask

[jhaber]

Ah, we're still on mysql-connector-java 5.1.x so that's probably why we haven't run into it. Thanks again for reporting the issue