... which is what SQLite does internally if you provide a list of literal values inside the parentheses. In some cases, SQLite 3.24 has been observed to use such an ephemeral table as the outer table of a join; with detrimental effects on query performance and no CROSS JOIN syntax available to force a different query plan
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von James K. Lowden Gesendet: Mittwoch, 05. Dezember 2018 19:04 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] Re: [sqlite] sqlite3_bind_text() and WHERE x IN (?) On Fri, 30 Nov 2018 23:25:48 +0900 Simon Walter <si...@gikaku.com> wrote: > > SELECT id, data FROM val WHERE id IN ("1, 893, 121212"); ... > I have no idea yet if MySQL and/or PostgreSQL can handle this scenario > and how they do it. The important thing to understand about parameterized queries is that they are not a generalized macro system. Only data -- not metadata, not arbitrary strings -- can be parameterized. That's why your IN list can't be parameterized (except as individual elements) and why can't say SELECT id, data FROM ? or SELECT id, ? FROM val as would occasionally be convenient. Other than string-slinging, the only generalized standard solution for your parameterized IN list, where the number of elements is variable, is to first insert the list into a table, then use IN or EXISTS against it. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
