LocalSQL

  Copyright (C) 2002 Dave Berton
  Copyright (C) 2001 Trolltech AS

  Contact:
	 Dave Berton (dberton @ gmail.com)
	 Jasmin Blanchette (jasmin@trolltech.com)

  This library is free software; you can redistribute it and/or
  modify it under the terms of the GNU Lesser General Public
  License as published by the Free Software Foundation; either
  version 2.1 of the License, or (at your option) any later version.

  This library is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  Lesser General Public License for more details.

  You should have received a copy of the GNU Lesser General Public
  License along with this library; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA


This file outlines the level of SQL supported by LocalSQL.

Data Types
----------

CHAR, VARCHAR
INT, INTEGER
DECIMAL, FLOAT, DOUBLE, NUMERIC
DATE

SQL Statements
--------------

The following SQL-schema statements are supported:
	<table definition>
	<drop table statement>

The following SQL-data statements are supported:
	<select statement>
	<insert statement>
	<update statement>
	<delete statement>

The following set functions are supported:
	AVG
	MAX
	MIN
	SUM
	COUNT

The following string value functions are supported:
	UPPER
	LOWER
	LENGTH, CHARACTER_LENGTH
	SUBSTRING

The following datetime value functions are supported:
	CURRENT_DATE

The following predicates are supported:
	<comparison>
	<between>
	<like>
	<null>
	<in>

NULL values are supported.

SELECT statements are supported, with the following form:
	<table expression>
		<from clause>
		[ <where clause> ]
		[ <group by clause> ]
		[ <having clause> ]

Multiple table SELECTs are supported.

Note on constraints
-------------------

Unique column constraints are supported, for example:

	create table t
	(id int unique);

NOT NULL, and PRIMARY KEY are also supported:

	create table t
	(id int primary key,
	 name not null);

The above example creates a unique index on 'id' and a NOT NULL
constraint on both 'id' and 'name'.

However, FOREIGN KEY and CHECK contraints are not fully supported.
For example:

	create table t
	(id int foreign key);

The above issues a warning, but creates the table and a non-unique
index on the 'id' field anyway.

	create table t
	(id int check ...);

The above issues a warning that CHECK constraints are not supported,
but creates the table anyway.


Note on strings
---------------

All string data is saved as utf8, therefore the length of any string
columns should be adjusted if multi-byte characters are being used.


Stuff not supported
-------------------

Sub-selects are not supported.
DISTINCT is not supported.
DATETIME and INTERVAL data types are not supported
Referential integrity constraints are not supported.
UNIONs are not supported.
JOINs are not supported.
INTERSECTs are not supported.
Cast specifications are not supported.
Numeric value functions are not supported.
SQL-transaction statements are not supported.
SQL-connection statements are not supported.
SQL-session statements are not supported.
SQL-dynamic statements are not supported.
SQL-procedure statements are not supported.
Language clauses are not supported.
Cursors are not supported.
User priviledges (GRANT, REVOKE, etc) are not supported.
Assertions are not supported.
Anything to do with translations is not supported.
Anything to do with intervals is not supported.
Anything to do with character sets is not supported.
Anything to do with collating is not supported.
Anything to do with dynamic SQL (PREPARE, EXECUTE, etc.) is not supported.
Anything to do with diagnostic management is not supported.
Anything to do with information schemas is not supported.
DEFAULT clauses for CREATE TABLE and INSERT statements are not supported.
ALTER TABLE is not supported.
ADD|DROP TABLE CONSTRAINT is not supported.
VIEWs are not supported.
DOMAINs are not supported.
Temporary tables are not supported.