This is an automated email from the ASF dual-hosted git repository.
amashenkov pushed a commit to branch ignite-21941
in repository https://gitbox.apache.org/repos/asf/ignite-3.git
commit bd2cb1b62f5b73fd39125e057f1b8080022d3ef5
Author: amashenkov <andrey.mashen...@gmail.com>
AuthorDate: Tue May 7 15:21:21 2024 +0300
wip
---
.../sql/identifiers/test_long_identifiers.test | 68 ++++++++++++++++++++++
1 file changed, 68 insertions(+)
diff --git
a/modules/sql-engine/src/integrationTest/sql/identifiers/test_long_identifiers.test
b/modules/sql-engine/src/integrationTest/sql/identifiers/test_long_identifiers.test
new file mode 100644
index 0000000000..7851690c99
--- /dev/null
+++
b/modules/sql-engine/src/integrationTest/sql/identifiers/test_long_identifiers.test
@@ -0,0 +1,68 @@
+# name: sql/identifiers/test_long_identifiers.test
+# description: SQL feature F391 (Long identifiers)
+# group: [identifiers]
+
+statement ok
+PRAGMA enable_verification
+
+statement ok
+CREATE TABLE tableNameLongIdentifier (keyColumnLongIdentifier INTEGER,
valueColumnLongIdentifier INTEGER, PRIMARY KEY (keyColumnLongIdentifier))
+
+statement ok
+ALTER TABLE tableNameLongIdentifier ADD COLUMN (newValueColumnLongIdentifier
INTEGER)
+
+statement ok
+ALTER TABLE tableNameLongIdentifier DROP COLUMN newValueColumnLongIdentifier
+
+query I
+SELECT col_ FROM (VALUES (1), (2)) t(col_)
+----
+1
+2
+
+query I
+SELECT 1 as col_
+----
+1
+
+query I
+SELECT 1 col_
+----
+1
+
+query I
+SELECT col_ FROM (SELECT 1 as col_)
+----
+1
+
+query I
+SELECT col_ FROM (SELECT 1 col_)
+----
+1
+
+query I
+SELECT col__ FROM (VALUES (1), (2)) t(col__)
+----
+1
+2
+
+statement ok
+CREATE INDEX t_some_idx_ on t_ (val)
+
+statement ok
+DROP INDEX t_some_idx_
+
+statement ok
+DROP TABLE t_
+
+statement ok
+CREATE ZONE zone_ WITH STORAGE_PROFILES='default', PARTITIONS=1, REPLICAS=3
+
+statement ok
+ALTER ZONE zone_ SET REPLICAS = 4
+
+statement ok
+ALTER ZONE zone_ RENAME TO another_zone_
+
+statement ok
+DROP ZONE another_zone_
