Hello all, I was wondering whether the SQLite parser will parse out redundant conditions out of an SQL statement or will it process them as if they are all unique?
I'm building dynamic SQL statements and sometimes I can't avoid (well, without re-working a lot of code) things like: SELECT * FROM TABLEA WHERE COLUMNA=1 AND COLUMNA=1 AND COLUMNA=1 AND ( COLUMNB=2 OR COLUMNC=3 ) Does it hurt performance having 3 COLUMNA statements like that in any way? Thanks in advance! Dennis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
