aboutsummaryrefslogtreecommitdiffstats
path: root/yt/yql/tests/sql/suites/pg
diff options
context:
space:
mode:
authorvvvv <vvvv@yandex-team.com>2024-12-28 17:20:43 +0300
committervvvv <vvvv@yandex-team.com>2024-12-28 18:00:52 +0300
commitc3689e981be0dc1c9f79ac90f7d36d456124f782 (patch)
treed5af3c1cce2a16bb19537c5dc6c5b3f15118adfc /yt/yql/tests/sql/suites/pg
parent1217ad4cbdfb5b1e52f8461a0681dd24bf1d6b70 (diff)
downloadydb-c3689e981be0dc1c9f79ac90f7d36d456124f782.tar.gz
Change "devtools/contrib/piglet/projects/ydblib/config.yaml"
commit_hash:3d2efe706faf091f9f2f2e93e511213405b80e78
Diffstat (limited to 'yt/yql/tests/sql/suites/pg')
-rw-r--r--yt/yql/tests/sql/suites/pg/all_data.txt2
-rw-r--r--yt/yql/tests/sql/suites/pg/input.txt4
-rw-r--r--yt/yql/tests/sql/suites/pg/input2.txt3
-rw-r--r--yt/yql/tests/sql/suites/pg/input3.txt3
-rw-r--r--yt/yql/tests/sql/suites/pg/input4.txt3
-rw-r--r--yt/yql/tests/sql/suites/pg/input5.txt5
-rw-r--r--yt/yql/tests/sql/suites/pg/inputC.txt1
-rw-r--r--yt/yql/tests/sql/suites/pg/inputZ.txt2
-rw-r--r--yt/yql/tests/sql/suites/pg/input_1.txt4
-rw-r--r--yt/yql/tests/sql/suites/pg/input_2.txt4
-rw-r--r--yt/yql/tests/sql/suites/pg/input_3.txt4
-rw-r--r--yt/yql/tests/sql/suites/pg/input_name.txt3
-rw-r--r--yt/yql/tests/sql/suites/pg/input_pg.txt4
-rw-r--r--yt/yql/tests/sql/suites/pg/input_pg_int_and_text.txt4
14 files changed, 46 insertions, 0 deletions
diff --git a/yt/yql/tests/sql/suites/pg/all_data.txt b/yt/yql/tests/sql/suites/pg/all_data.txt
new file mode 100644
index 0000000000..311847daa5
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/all_data.txt
@@ -0,0 +1,2 @@
+{}
+
diff --git a/yt/yql/tests/sql/suites/pg/input.txt b/yt/yql/tests/sql/suites/pg/input.txt
new file mode 100644
index 0000000000..65949ea745
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/input.txt
@@ -0,0 +1,4 @@
+{"key"="075";"subkey"="1";"value"="abc"};
+{"key"="800";"subkey"="2";"value"="ddd"};
+{"key"="020";"subkey"="3";"value"="q"};
+{"key"="150";"subkey"="4";"value"="qzz"};
diff --git a/yt/yql/tests/sql/suites/pg/input2.txt b/yt/yql/tests/sql/suites/pg/input2.txt
new file mode 100644
index 0000000000..0667916f57
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/input2.txt
@@ -0,0 +1,3 @@
+{"key2"="075";"subkey2"="1";"value2"="ABC"};
+{"key2"="800";"subkey2"="2";"value2"="DDD"};
+{"key2"="020";"subkey2"="3";"value2"="Q"};
diff --git a/yt/yql/tests/sql/suites/pg/input3.txt b/yt/yql/tests/sql/suites/pg/input3.txt
new file mode 100644
index 0000000000..f489ef07c6
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/input3.txt
@@ -0,0 +1,3 @@
+{"key"="1";"subkey"="3";"value"="aaa"};
+{"key"="2";"subkey"="5";"value"="aaa"};
+{"key"="3";"subkey"="1";"value"="bbb"};
diff --git a/yt/yql/tests/sql/suites/pg/input4.txt b/yt/yql/tests/sql/suites/pg/input4.txt
new file mode 100644
index 0000000000..9ca7e736b6
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/input4.txt
@@ -0,0 +1,3 @@
+{"b_val"="true";"i_val"="3";"d_val"="2000-01-01"};
+{"b_val"="false";"i_val"="5";"d_val"="1979-12-12"};
+{"b_val"="true";"i_val"="1";"d_val"="2010-12-01"};
diff --git a/yt/yql/tests/sql/suites/pg/input5.txt b/yt/yql/tests/sql/suites/pg/input5.txt
new file mode 100644
index 0000000000..3d8c1dee24
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/input5.txt
@@ -0,0 +1,5 @@
+{"key"="150";"subkey"="8";"value"="zzz"};
+{"key"="200";"subkey"="7";"value"="qqq"};
+{"key"="527";"subkey"="4";"value"="bbb"};
+{"key"="761";"subkey"="6";"value"="ccc"};
+{"key"="911";"subkey"="2";"value"="kkk"};
diff --git a/yt/yql/tests/sql/suites/pg/inputC.txt b/yt/yql/tests/sql/suites/pg/inputC.txt
new file mode 100644
index 0000000000..9b2963ca66
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/inputC.txt
@@ -0,0 +1 @@
+{"id"="1";"CodeGen_FullTime"="infinity"};
diff --git a/yt/yql/tests/sql/suites/pg/inputZ.txt b/yt/yql/tests/sql/suites/pg/inputZ.txt
new file mode 100644
index 0000000000..6379112ef3
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/inputZ.txt
@@ -0,0 +1,2 @@
+{"f"="+0.0"};
+{"f"="-0.0"};
diff --git a/yt/yql/tests/sql/suites/pg/input_1.txt b/yt/yql/tests/sql/suites/pg/input_1.txt
new file mode 100644
index 0000000000..9c4f4416e8
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/input_1.txt
@@ -0,0 +1,4 @@
+{"id"="000";"name"="vera"};
+{"id"="001";"name"="nadezhda"};
+{"id"="002";"name"="lubov"};
+{"id"="003";"name"="mashina"};
diff --git a/yt/yql/tests/sql/suites/pg/input_2.txt b/yt/yql/tests/sql/suites/pg/input_2.txt
new file mode 100644
index 0000000000..1fb956089f
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/input_2.txt
@@ -0,0 +1,4 @@
+{"id"="000";"no"="A001TX77"};
+{"id"="001";"no"="B002KK76"};
+{"id"="002";"no"="C003AE78"};
+{"id"="003";"no"="B777OP777"};
diff --git a/yt/yql/tests/sql/suites/pg/input_3.txt b/yt/yql/tests/sql/suites/pg/input_3.txt
new file mode 100644
index 0000000000..cea60db303
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/input_3.txt
@@ -0,0 +1,4 @@
+{"id"="000";"sname"="lodkovna"};
+{"id"="001";"sname"="korableva"};
+{"id"="002";"sname"="sudnovna"};
+{"id"="003";"sname"="vremeni"};
diff --git a/yt/yql/tests/sql/suites/pg/input_name.txt b/yt/yql/tests/sql/suites/pg/input_name.txt
new file mode 100644
index 0000000000..096cfb7e19
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/input_name.txt
@@ -0,0 +1,3 @@
+{"key"="foo";index=1};
+{"key"="bar";index=2};
+{"key"="baz";index=3};
diff --git a/yt/yql/tests/sql/suites/pg/input_pg.txt b/yt/yql/tests/sql/suites/pg/input_pg.txt
new file mode 100644
index 0000000000..25433188f6
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/input_pg.txt
@@ -0,0 +1,4 @@
+{"a"=1;"b"="aaa";"c"="\0\0\0\1\0\0\0\0\0\0\0\x15\0\0\0\2\0\0\0\1\0\0\0\2\0\1\0\0\0\2\0\2"};
+{"a"=1;"b"="ddd";"c"="\0\0\0\1\0\0\0\0\0\0\0\x15\0\0\0\2\0\0\0\1\0\0\0\2\0\1\0\0\0\2\0\3"};
+{"a"=2;"b"="bbb";"c"="\0\0\0\1\0\0\0\0\0\0\0\x15\0\0\0\2\0\0\0\1\0\0\0\2\0\1\0\0\0\2\0\2"};
+{"a"=2;"b"="ccc";"c"="\0\0\0\1\0\0\0\0\0\0\0\x15\0\0\0\2\0\0\0\1\0\0\0\2\0\1\0\0\0\2\0\3"};
diff --git a/yt/yql/tests/sql/suites/pg/input_pg_int_and_text.txt b/yt/yql/tests/sql/suites/pg/input_pg_int_and_text.txt
new file mode 100644
index 0000000000..79d59e9d3f
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg/input_pg_int_and_text.txt
@@ -0,0 +1,4 @@
+{"a"=1;"b"="aaa"};
+{"a"=1;"b"="bbb"};
+{"a"=2;"b"=#};
+{"a"=2;"b"="ccc"};