SQLite CVSTrac

*** 7,19 ****
  *: SQL92 Character sets, collations, coercibility.
  *: Inserting blob using X'AABBCCDD' syntax.
  *: Stored Procedures
! *: Rollup and Cube
  *: INSERT INTO with multiple rows (ie. INSERT INTO table VALUES (...), (...). etc)
! *: CREATE DATABASE, DROP DATABASE
  *: ALTER VIEW, ALTER TRIGGER, ALTER TABLE
! *: Schemas
! *: TRUNCATE (MySQL, Postgresql and Oracle have it... but I dont know if this is a standard 
! command)
  *: ORDER BY myfield ASC NULLS LAST (Oracle)
  *: CREATE TRIGGER [BEFORE | AFTER | INSTEAD OF] (Oracle)
  *: UPDATE with a FROM clause (not sure if this is standard, Sybase and Microsoft have it).
--- 7,21 ----
  *: SQL92 Character sets, collations, coercibility.
  *: Inserting blob using X'AABBCCDD' syntax.
  *: Stored Procedures
! *: Rollup and Cube - _Who can tell me what this means?_
  *: INSERT INTO with multiple rows (ie. INSERT INTO table VALUES (...), (...). etc)
! *: CREATE DATABASE, DROP DATABASE - _Does not seem meaningful for an
!    embedded database engine like SQLite.  To create a new database, just
!    do sqlite_open().  To drop a database, delete the file._
  *: ALTER VIEW, ALTER TRIGGER, ALTER TABLE
! *: Schemas - _Who can tell me what this means?_
! *: TRUNCATE (MySQL, Postgresql and Oracle have it... but I dont know if this is a standard command) - _SQLite does this automatically when you do a DELETE
! without a WHERE clause._
  *: ORDER BY myfield ASC NULLS LAST (Oracle)
  *: CREATE TRIGGER [BEFORE | AFTER | INSTEAD OF] (Oracle)
  *: UPDATE with a FROM clause (not sure if this is standard, Sybase and Microsoft have it).
***************
*** 29,33 ****
  *: MEDIAN and standard deviation... are they standard?  Useful for sqlite standalone (for shell script 
  users)
  *: enum column type (mysql does)
! *: join syntax (+) (-) like oracle has
  *: name columns in views (i.e. CREATE VIEW (foo, bar) AS SELECT qux, quo FROM baz;)
--- 31,36 ----
  *: MEDIAN and standard deviation... are they standard?  Useful for sqlite standalone (for shell script 
  users)
  *: enum column type (mysql does)
! *: join syntax (+) (-) like oracle has  - _SQLite used to have this but it
! was removed because it is not standard SQL._
  *: name columns in views (i.e. CREATE VIEW (foo, bar) AS SELECT qux, quo FROM baz;)

sqlite - Unsupported Sql