You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by am...@apache.org on 2024/05/07 15:17:32 UTC
(ignite-3) branch ignite-21941 created (now 4d054e9edd)
This is an automated email from the ASF dual-hosted git repository.
amashenkov pushed a change to branch ignite-21941
in repository https://gitbox.apache.org/repos/asf/ignite-3.git
at 4d054e9edd Add feature tests
This branch includes the following new commits:
new bd2cb1b62f wip
new 4d054e9edd Add feature tests
The 2 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
(ignite-3) 02/02: Add feature tests
Posted by am...@apache.org.
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 4d054e9edd934bbd6b1181d10c9e96c7bd538959
Author: amashenkov <an...@gmail.com>
AuthorDate: Tue May 7 18:17:24 2024 +0300
Add feature tests
---
.../sql/identifiers/test_long_identifiers.test | 57 ++++++++++++++++------
1 file changed, 41 insertions(+), 16 deletions(-)
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
index 7851690c99..8a3c039af3 100644
--- a/modules/sql-engine/src/integrationTest/sql/identifiers/test_long_identifiers.test
+++ b/modules/sql-engine/src/integrationTest/sql/identifiers/test_long_identifiers.test
@@ -6,63 +6,88 @@ statement ok
PRAGMA enable_verification
statement ok
-CREATE TABLE tableNameLongIdentifier (keyColumnLongIdentifier INTEGER, valueColumnLongIdentifier INTEGER, PRIMARY KEY (keyColumnLongIdentifier))
+CREATE TABLE someTableNameLongIdentifier (keyColumnLongIdentifier INTEGER, valueColumnLongIdentifier INTEGER, PRIMARY KEY (keyColumnLongIdentifier));
statement ok
-ALTER TABLE tableNameLongIdentifier ADD COLUMN (newValueColumnLongIdentifier INTEGER)
+ALTER TABLE someTableNameLongIdentifier ADD COLUMN (newValueColumnLongIdentifier INTEGER);
statement ok
-ALTER TABLE tableNameLongIdentifier DROP COLUMN newValueColumnLongIdentifier
+ALTER TABLE someTableNameLongIdentifier DROP COLUMN newValueColumnLongIdentifier;
+
+statement ok
+INSERT INTO someTableNameLongIdentifier (keyColumnLongIdentifier, valueColumnLongIdentifier) VALUES (1, 1), (2, 1);
query I
-SELECT col_ FROM (VALUES (1), (2)) t(col_)
+SELECT columnAliasLongIdentifier FROM (VALUES (1), (2)) tableAliasLongIdentifier(columnAliasLongIdentifier);
----
1
2
query I
-SELECT 1 as col_
+SELECT 1 as columnAliasLongIdentifier
----
1
query I
-SELECT 1 col_
+SELECT 1 columnAliasLongIdentifier
----
1
query I
-SELECT col_ FROM (SELECT 1 as col_)
+SELECT columnAliasLongIdentifier FROM (SELECT 1 as columnAliasLongIdentifier);
----
1
query I
-SELECT col_ FROM (SELECT 1 col_)
+SELECT columnAliasLongIdentifier FROM (SELECT 1 columnAliasLongIdentifier);
----
1
+
query I
-SELECT col__ FROM (VALUES (1), (2)) t(col__)
+SELECT someTableNameLongIdentifier.keyColumnLongIdentifier FROM someTableNameLongIdentifier;
----
1
2
+query II
+SELECT keyColumnLongIdentifier, valueColumnLongIdentifier FROM someTableNameLongIdentifier ORDER BY keyColumnLongIdentifier DESC;
+----
+2 1
+1 1
+
+query II
+SELECT valueColumnLongIdentifier, SUM(keyColumnLongIdentifier) FROM someTableNameLongIdentifier GROUP BY valueColumnLongIdentifier;
+----
+1 3
+
+query II
+SELECT * FROM someTableNameLongIdentifier WHERE keyColumnLongIdentifier = 2;
+----
+2 1
+
+query I
+SELECT columnAliasLongIdentifier FROM (SELECT 1 columnAliasLongIdentifier) WHERE columnAliasLongIdentifier = 1;
+----
+1
+
statement ok
-CREATE INDEX t_some_idx_ on t_ (val)
+CREATE INDEX someIndexNameLongIdentifier on someTableNameLongIdentifier (valueColumnLongIdentifier);
statement ok
-DROP INDEX t_some_idx_
+DROP INDEX someIndexNameLongIdentifier;
statement ok
-DROP TABLE t_
+DROP TABLE someTableNameLongIdentifier;
statement ok
-CREATE ZONE zone_ WITH STORAGE_PROFILES='default', PARTITIONS=1, REPLICAS=3
+CREATE ZONE someZoneNameLongIdentifier WITH STORAGE_PROFILES='default', PARTITIONS=1, REPLICAS=3;
statement ok
-ALTER ZONE zone_ SET REPLICAS = 4
+ALTER ZONE someZoneNameLongIdentifier SET REPLICAS = 4;
statement ok
-ALTER ZONE zone_ RENAME TO another_zone_
+ALTER ZONE someZoneNameLongIdentifier RENAME TO anotherZoneNameLongIdentifier;
statement ok
-DROP ZONE another_zone_
+DROP ZONE anotherZoneNameLongIdentifier;
(ignite-3) 01/02: wip
Posted by am...@apache.org.
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 <an...@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_