aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMaxim Yurchuk <maxim-yurchuk@ydb.tech>2024-11-12 15:19:57 +0000
committerGitHub <noreply@github.com>2024-11-12 18:19:57 +0300
commitc9d166e21c1a358ccc7433862412e5836adc77e0 (patch)
treeefed4578184561ae6a2e8ffdb136d3f1bf9fdc1f
parent8fb382cb51673480c66b4a9977d204b5ef37ef64 (diff)
downloadydb-c9d166e21c1a358ccc7433862412e5836adc77e0.tar.gz
Recanonize test_postgres.py (#11533)
-rw-r--r--.github/config/muted_ya.txt1
-rw-r--r--ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_2.plan15
-rw-r--r--ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_3.plan15
-rw-r--r--ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_7.plan15
-rw-r--r--ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_8.plan41
5 files changed, 8 insertions, 79 deletions
diff --git a/.github/config/muted_ya.txt b/.github/config/muted_ya.txt
index caf1ab0c13..7d569588d9 100644
--- a/.github/config/muted_ya.txt
+++ b/.github/config/muted_ya.txt
@@ -156,7 +156,6 @@ ydb/tests/functional/restarts test_restarts.py.TestRestartSingleBlock42.test_res
ydb/tests/functional/serializable test.py.test_local
ydb/tests/functional/serverless test_serverless.py.test_database_with_disk_quotas[enable_alter_database_create_hive_first--false]
ydb/tests/functional/serverless test_serverless.py.test_database_with_disk_quotas[enable_alter_database_create_hive_first--true]
-ydb/tests/functional/suite_tests test_postgres.py.TestPGSQL.test_sql_suite[plan-jointest/join2.test]
ydb/tests/functional/tenants test_dynamic_tenants.py.test_create_and_drop_tenants[enable_alter_database_create_hive_first--false]
ydb/tests/functional/tenants test_dynamic_tenants.py.test_create_and_drop_tenants[enable_alter_database_create_hive_first--true]
ydb/tests/functional/tenants test_dynamic_tenants.py.test_create_and_drop_the_same_tenant2[enable_alter_database_create_hive_first--false]
diff --git a/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_2.plan b/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_2.plan
index 66cfc02ea1..b332512c7a 100644
--- a/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_2.plan
+++ b/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_2.plan
@@ -29,24 +29,11 @@
"PlanNodeType": "Connection",
"Plans": [
{
- "Node Type": "TopSort-TopSort",
+ "Node Type": "TopSort",
"Operators": [
{
"Inputs": [
{
- "InternalOperatorId": 1
- },
- {
- "ExternalPlanNodeId": 5
- }
- ],
- "Limit": "1001",
- "Name": "TopSort",
- "TopSortBy": "argument.s2.name"
- },
- {
- "Inputs": [
- {
"ExternalPlanNodeId": 5
}
],
diff --git a/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_3.plan b/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_3.plan
index 66cfc02ea1..b332512c7a 100644
--- a/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_3.plan
+++ b/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_3.plan
@@ -29,24 +29,11 @@
"PlanNodeType": "Connection",
"Plans": [
{
- "Node Type": "TopSort-TopSort",
+ "Node Type": "TopSort",
"Operators": [
{
"Inputs": [
{
- "InternalOperatorId": 1
- },
- {
- "ExternalPlanNodeId": 5
- }
- ],
- "Limit": "1001",
- "Name": "TopSort",
- "TopSortBy": "argument.s2.name"
- },
- {
- "Inputs": [
- {
"ExternalPlanNodeId": 5
}
],
diff --git a/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_7.plan b/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_7.plan
index 53b0e42ddd..5487a78ee2 100644
--- a/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_7.plan
+++ b/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_7.plan
@@ -29,24 +29,11 @@
"PlanNodeType": "Connection",
"Plans": [
{
- "Node Type": "TopSort-TopSort",
+ "Node Type": "TopSort",
"Operators": [
{
"Inputs": [
{
- "InternalOperatorId": 1
- },
- {
- "ExternalPlanNodeId": 5
- }
- ],
- "Limit": "1001",
- "Name": "TopSort",
- "TopSortBy": ""
- },
- {
- "Inputs": [
- {
"ExternalPlanNodeId": 5
}
],
diff --git a/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_8.plan b/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_8.plan
index 653bfe5ddd..d064b26895 100644
--- a/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_8.plan
+++ b/ydb/tests/functional/suite_tests/canondata/test_postgres.TestPGSQL.test_sql_suite_plan-jointest_join2.test_/query_8.plan
@@ -29,52 +29,21 @@
"PlanNodeType": "Connection",
"Plans": [
{
- "Node Type": "TopSort-Filter-TopSort-Filter",
+ "Node Type": "TopSort-Filter",
"Operators": [
{
"Inputs": [
{
- "InternalOperatorId": 2
+ "InternalOperatorId": 1
},
{
- "InternalOperatorId": 3
+ "InternalOperatorId": 1
},
{
- "InternalOperatorId": 3
+ "InternalOperatorId": 1
},
{
- "InternalOperatorId": 3
- },
- {
- "InternalOperatorId": 3
- }
- ],
- "Limit": "1001",
- "Name": "TopSort",
- "TopSortBy": ""
- },
- {
- "Inputs": [
- {
- "ExternalPlanNodeId": 5
- }
- ],
- "Name": "Filter",
- "Predicate": "Exist(item.y.y2)"
- },
- {
- "Inputs": [
- {
- "InternalOperatorId": 3
- },
- {
- "InternalOperatorId": 3
- },
- {
- "InternalOperatorId": 3
- },
- {
- "InternalOperatorId": 3
+ "InternalOperatorId": 1
}
],
"Limit": "1001",