diff options
Diffstat (limited to 'kexi/doc/dev/sql_engine_specifics.txt')
| -rw-r--r-- | kexi/doc/dev/sql_engine_specifics.txt | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/kexi/doc/dev/sql_engine_specifics.txt b/kexi/doc/dev/sql_engine_specifics.txt new file mode 100644 index 00000000..3db65fdf --- /dev/null +++ b/kexi/doc/dev/sql_engine_specifics.txt @@ -0,0 +1,22 @@ +SQL Engines - Specifics +----------------------- + +This document lists specifics among SQL engines. We need to remember about them when implementing features of KexiDB and designing KEXISQL. + +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 + |