1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
SQL Engines - Specifics
-----------------------
This document lists specifics among SQL engines. We need to remember about them when implementing features of KDb and designing KDbSQL.
Legend: + == works, - == doesn't work, ? == not tested yet
== 1. Ordering by computed column ==
Examples: select rand() from T order by 1;
select 1 from T order by 1;
MySQL: +
SQLite: -
PostgreSQL: ?
== 2. Using more than just "*" in the column list ==
Example: select *, 1 from T;
MySQL: -
SQLite: +
PostgreSQL: ?
Notes: select T.*, 1 from T; works everywhere
|
