sqlite - Unsupported Sql

Not logged in

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

• Contents
• No-Diff
• Text

*** 36,61 ****
  
        START WITH <conditions> CONNECT BY [PRIOR]<conditions> (ORACLE)
  
! *: 2003.07.28 : Stored Procedures
! 
! *: 2003.07.28 : Rollup and Cube -> UnsupportedSqlRollupAndCube
! 
! *: 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 - See: http://www.postgresql.org/docs/8.1/static/ddl-schemas.html -> UnsupportedSqlSchemas
  
! *: 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_
  
! *: 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). -> UnsupportedSqlUpdateWithFrom
--- 36,62 ----
  
        START WITH <conditions> CONNECT BY [PRIOR]<conditions> (ORACLE)
  
! *: 2003.08.06 : 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._
  
  
! *: 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)
! 
! *: 2003.08.06 : CREATE TRIGGER [BEFORE | AFTER | INSTEAD OF] (Oracle)
  
! *: 2003.07.28 : Stored Procedures
! 
! *: 2003.07.28 : Rollup and Cube -> UnsupportedSqlRollupAndCube
! 
! *: ALTER VIEW, ALTER TRIGGER, ALTER TABLE
  
  *: UPDATE with a FROM clause (not sure if this is standard, Sybase and
  Microsoft have it). -> UnsupportedSqlUpdateWithFrom