sqlite - Unsupported Sql

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 142,151 ****
  *: 2003.08.06 : Schemas - See: http://www.postgresql.org/docs/8.1/static/ddl-schemas.html ->
  UnsupportedSqlSchemas
  
! *: 2003.08.06 : 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. You can use also VACUUM command_
  
  *: 2003.08.06 : ORDER BY myfield ASC NULLS LAST (Oracle)
  
--- 142,152 ----
  *: 2003.08.06 : Schemas - See: http://www.postgresql.org/docs/8.1/static/ddl-schemas.html ->
  UnsupportedSqlSchemas
  
! *: 2003.08.06 : TRUNCATE (MySQL, Postgresql and Oracle have it... but I don't know if this is
  a standard command) -
  _SQLite does this automatically when you do a DELETE
! without a WHERE clause. You can use also VACUUM command. The sqlite
! DELETE without a WHERE clause is significantly slower though due to the logging of transactions while TRUNCATE doesn't support rollback._
  
  *: 2003.08.06 : ORDER BY myfield ASC NULLS LAST (Oracle)