Warning, /libraries/kdb/docs/sql_engine_specifics.txt is written in an unsupported language. File is not indexed.
0001 SQL Engines - Specifics 0002 ----------------------- 0003 0004 This document lists specifics among SQL engines. We need to remember about them when implementing features of KDb and designing KDbSQL. 0005 0006 Legend: + == works, - == doesn't work, ? == not tested yet 0007 0008 == 1. Ordering by computed column == 0009 Examples: select rand() from T order by 1; 0010 select 1 from T order by 1; 0011 MySQL: + 0012 SQLite: - 0013 PostgreSQL: ? 0014 0015 == 2. Using more than just "*" in the column list == 0016 Example: select *, 1 from T; 0017 MySQL: - 0018 SQLite: + 0019 PostgreSQL: ? 0020 0021 Notes: select T.*, 1 from T; works everywhere 0022