samedi 28 mars 2015

sqlite duplicate column header on select

I noticed that when you do a select like this :



select * from table1 join table2


If both tables happened to have a column with the same name, sqlite simply shows two columns with that name. For example if both tables have an id column, in the result you will get two identical column header. This behaviour causing problems when working with jdbc, as you cannot get the value of the column. Is there a generic way to overcome this. For example make sqlite give a prefix to these columns, or simply refuse to execute the query.


Aucun commentaire:

Enregistrer un commentaire