diff --git a/autotests/folding/highlight.cmake.fold b/autotests/folding/highlight.cmake.fold
--- a/autotests/folding/highlight.cmake.fold
+++ b/autotests/folding/highlight.cmake.fold
@@ -14,7 +14,7 @@
)
# BEGIN defining a macro
-MACRO(ECOS_ADD_EXECUTABLE _exe_NAME )
+MACRO(ECOS_ADD_EXECUTABLE _exe_NAME )
#special parameters are italic, see the STATIC in the next line
ADD_LIBRARY(${_exe_NAME} STATIC ${ARGN})
@@ -39,7 +39,7 @@
PROPERTIES
ADDITIONAL_MAKE_CLEAN_FILES "${ECOS_ADD_MAKE_CLEAN_FILES}"
)
-ENDMACRO(ECOS_ADD_EXECUTABLE)
+ENDMACRO(ECOS_ADD_EXECUTABLE)
# END of macro
#calling a self-defined function, variables are also Qt::blue here
diff --git a/autotests/folding/test.sql.fold b/autotests/folding/test.sql.fold
--- a/autotests/folding/test.sql.fold
+++ b/autotests/folding/test.sql.fold
@@ -4,3 +4,62 @@
SELECT * FROM stuff WHERE id = 'string';
select * from stuff where id < 0.42;
Select col1, col2 From stuff Where stuff.col1 IS NOT NuLL;
+
+CREATE TABLE Persons (
+ ID int NOT NULL AUTO_INCREMENT,
+ LastName varchar(255) NOT NULL,
+ FirstName varchar(255),
+ Age int,
+ PRIMARY KEY (ID)
+ CONSTRAINT CHK_Person CHECK (Age>=18 AND City='Sandnes')
+);
+
+SELECT column_name(s)
+FROM table1
+FULL OUTER JOIN table2 ON table1.column_name = table2.column_name;
+
+SELECT * FROM Customers
+WHERE City LIKE '[bsp]%';
+
+SELECT Count(*) AS DistinctCountries
+FROM (SELECT DISTINCT Country FROM Customers)
+GROUP BY Country
+HAVING COUNT(CustomerID) > 5
+ORDER BY COUNT(CustomerID) DESC;
+
+SELECT 'Customer' As Type, ContactName, City, Country
+FROM Customers
+UNION
+SELECT 'Supplier', ContactName, City, Country
+FROM Suppliers;
+
+SELECT COUNT(ProductID), AVG(Price)
+FROM Products;
+
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+SET default_tablespace = '';
+
+DROP TABLE IF EXISTS employees;
+
+ALTER TABLE ONLY employees
+ ADD CONSTRAINT fk_employees_employees FOREIGN KEY (reportsto) REFERENCES employees;
+
+CREATE VIEW [Current Product List] AS
+SELECT ProductID, ProductName
+FROM Products
+WHERE Discontinued = No;
+
+SELECT * FROM [Current Product List];
+
+SELECT * FROM [Category Sales For 1997]
+WHERE CategoryName = 'Beverages';
+
+begin
+end
+/
+ /
+/ u
diff --git a/autotests/folding/test.sql_oracle.fold b/autotests/folding/test.sql_oracle.fold
--- a/autotests/folding/test.sql_oracle.fold
+++ b/autotests/folding/test.sql_oracle.fold
@@ -10,6 +10,7 @@
nq'agdfgsdfgfhfghjfgh'f'f'sdfg'sdfg'dfg#a' dafdfadasfasdf;
v_nchar := n'NCHAR STRING';
+ if_n := 0;
Q'#gdfgsdfgsdfgsdfgsdfg#' afgasasdfasdfasfasdfasdfasdfasdfsdf
@@ -42,3 +43,12 @@
sdfdfsdf;
end if;
end;
+
+CREATE TABLE Persons (
+ ID int NOT NULL,
+ LastName varchar(255) NOT NULL,
+ FirstName varchar(255),
+ Age int,
+ City varchar(255),
+ CONSTRAINT CHK_Person CHECK (Age>=18 AND City='Sandnes')
+);
diff --git a/autotests/html/test.sql.html b/autotests/html/test.sql.html
--- a/autotests/html/test.sql.html
+++ b/autotests/html/test.sql.html
@@ -10,4 +10,63 @@
SELECT * FROM stuff WHERE id = 'string';
select * from stuff where id < 0.42;
Select col1, col2 From stuff Where stuff.col1 IS NOT NuLL;
+
+CREATE TABLE Persons (
+ ID int NOT NULL AUTO_INCREMENT,
+ LastName varchar(255) NOT NULL,
+ FirstName varchar(255),
+ Age int,
+ PRIMARY KEY (ID)
+ CONSTRAINT CHK_Person CHECK (Age>=18 AND City='Sandnes')
+);
+
+SELECT column_name(s)
+FROM table1
+FULL OUTER JOIN table2 ON table1.column_name = table2.column_name;
+
+SELECT * FROM Customers
+WHERE City LIKE '[bsp]%';
+
+SELECT Count(*) AS DistinctCountries
+FROM (SELECT DISTINCT Country FROM Customers)
+GROUP BY Country
+HAVING COUNT(CustomerID) > 5
+ORDER BY COUNT(CustomerID) DESC;
+
+SELECT 'Customer' As Type, ContactName, City, Country
+FROM Customers
+UNION
+SELECT 'Supplier', ContactName, City, Country
+FROM Suppliers;
+
+SELECT COUNT(ProductID), AVG(Price)
+FROM Products;
+
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+SET default_tablespace = '';
+
+DROP TABLE IF EXISTS employees;
+
+ALTER TABLE ONLY employees
+ ADD CONSTRAINT fk_employees_employees FOREIGN KEY (reportsto) REFERENCES employees;
+
+CREATE VIEW [Current Product List] AS
+SELECT ProductID, ProductName
+FROM Products
+WHERE Discontinued = No;
+
+SELECT * FROM [Current Product List];
+
+SELECT * FROM [Category Sales For 1997]
+WHERE CategoryName = 'Beverages';
+
+begin
+end
+/
+ /
+/ u