When parsing we can detect easy things as same expression on both side of comparison expressions etc. This should be added to compiler warnings as some kind of info level to let clients handle this.
Would also be nice to have some kind of compiler options that could append a warning if a table scan is used to be able to detect faulty queries as early as possible.
Asterisk schemas used that yielded non ordinal column etc.
When parsing we can detect easy things as same expression on both side of comparison expressions etc. This should be added to compiler warnings as some kind of info level to let clients handle this.
Would also be nice to have some kind of compiler options that could append a warning if a table scan is used to be able to detect faulty queries as early as possible.
Asterisk schemas used that yielded non ordinal column etc.