NO. Only if all of the following apply - you are parsing and/or displaying raw returned column names - your select contains more than one table (a table joined to itself counts as 2) - your tables have columns that share the same name
-----Ursprüngliche Nachricht----- Von: Tim Streater [mailto:t...@clothears.org.uk] Gesendet: Montag, 26. Jänner 2015 13:00 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Invalid column prefix returned in SELECT with joined subquery On 26 Jan 2015 at 07:33, Hick Gunter <h...@scigames.at> wrote: > It is never a good idea to rely on automatically assigned column > names. If you want reproducible, predictable, release independant > column names then please assign them with the AS clause. So you're saying that if I do: create table wiggy (a,b,c,d,e,f,g,h); and later do: select a, b, c, d, e, f from wiggy; then I should really be doing: select a as a, b as b, c as c, d as d, e as e, f as f from wiggy; That'll be a bit tedious changing the more than 300 select statements in my app. I notice that in the PHP doc for SQLite result sets, they carefully talk about the "column names returned in the result set" rathe than just "column names", although I suppose that is just to indicate that names may be provided with AS. -- Cheers -- Tim ___________________________________________ Gunter Hick Software Engineer Scientific Games International GmbH FN 157284 a, HG Wien Klitschgasse 2-4, A-1130 Vienna, Austria Tel: +43 1 80100 0 E-Mail: h...@scigames.at This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
