SQLite CVSTrac

*** 39,44 ****
--- 39,50 ----
  
  *: 2005.06.01 : Named parts of natural joins. For example: SELECT a.c1 FROM T1 a NATURAL JOIN T1 b. Because sqlite reduces the number of columns kept, the name is lost.
  
+ *: 2005.04.27 : DELETE from table ORDER BY column LIMIT x,y is not supported. I worked around it by using a second query and deleting, eg:
+ 
+       SELECT timestamp from table LIMIT
+       x,1; DELETE from table
+       where timestamp < .....
+ 
  *: 2004.11.17 : INSERTing one record with all VALUES to DEFAULT: INSERT INTO example ()
  VALUES ();
  
***************
*** 164,174 ****
  nothing else.  The only functionality required is to ensure a "RESERVED" lock
  is placed on the database
  if not already there.
- 
- *:DELETE from table ORDER BY column LIMIT x,y is not supported. I worked around
- it by using a second query and deleting, eg: SELECT timestamp from table LIMIT
- x,1; DELETE from table
- where timestamp < .....
  
  *:create table wg (
  cpf numeric not null,
--- 170,175 ----

sqlite - Unsupported Sql