[gtksourceview/gtksourceview-4-6] file.sql: Add some more statements to look at
- From: Christian Hergert <chergert src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [gtksourceview/gtksourceview-4-6] file.sql: Add some more statements to look at
- Date: Thu, 25 Jun 2020 18:16:57 +0000 (UTC)
commit f0856223a6a31c308020a9e356d8378cd941958c
Author: Tomisław Kityński <t kitynski e-owl tech>
Date: Thu Jun 25 14:13:10 2020 +0200
file.sql: Add some more statements to look at
tests/syntax-highlighting/file.sql | 14 ++++++++++++++
1 file changed, 14 insertions(+)
---
diff --git a/tests/syntax-highlighting/file.sql b/tests/syntax-highlighting/file.sql
index a9c639f4..78366dc3 100644
--- a/tests/syntax-highlighting/file.sql
+++ b/tests/syntax-highlighting/file.sql
@@ -1,5 +1,13 @@
-- this is a comment
+CREATE TABLE table_name (
+ column1 integer NOT NULL PRIMARY KEY,
+ column2 varchar(20),
+ column3 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ column4 smallint CHECK (column4 >= 0),
+ CONSTRAINT ct1 CHECK (column4 IS NULL OR column2 IS NOT NULL)
+);
+
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
@@ -9,3 +17,9 @@ BEGIN;
WHERE account_id = '123';
-- more comment
COMMIT;
+
+CREATE TABLE other_table (
+ col1 int4 NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
+ col2 integer REFERENCES table_name
+);
+
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]