Bug Sqlite Engine with "Select" column names

 

We have found an issue that randomly happens with some of our SQL queries in our application. 

 

There are some queries that attach the name of the alias of the table to the column name even when there aren't two columns with the same name in the result. As you can see in the example we are giving you (debugger snapshot and query snapshot). Long story short: We don't want that these "SAP_YEAR_MONTH" and we want just "YEAR_MONTH" as the query states. Funnily, it doesn't happen in other similar queries that we have, with the same columns and aliases.

 

We have tried to force  columnNameStyle  to "SHORT" in the SQLConnection we are using, but it still happens. We are using the latest versions of HARMAN AIR SDK and it's happening in all of them. Can you give us a solution? 

 

Thank you very much.