Changeset: 70c2ff1e978e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=70c2ff1e978e
Added Files:
sql/test/delete-from-value-list/Tests/All
sql/test/delete-from-value-list/Tests/create-and-fill-table.sql
sql/test/delete-from-value-list/Tests/delete-from-sub-table.py
sql/test/delete-from-value-list/Tests/delete-from-value-list.py
sql/test/delete-from-value-list/Tests/delete-from-value-list.timeout
sql/test/delete-from-value-list/Tests/delete.sql
Modified Files:
.vscode/settings.json
.vscode/tasks.json
Branch: configurable_working_set
Log Message:
Add temporary tests.
diffs (183 lines):
diff --git a/.vscode/settings.json b/.vscode/settings.json
--- a/.vscode/settings.json
+++ b/.vscode/settings.json
@@ -79,5 +79,6 @@
"NT/rules.msc.orig": true,
"MacOSX/build": true,
"MacOSX/usr": true,
- }
+ },
+ "python.linting.pylintEnabled": false
}
diff --git a/.vscode/tasks.json b/.vscode/tasks.json
--- a/.vscode/tasks.json
+++ b/.vscode/tasks.json
@@ -52,7 +52,7 @@
{
"label": "run tests",
"type": "shell",
- "command": "export
PATH=/home/aris/Installations/default-env/bin:$PATH && Mtest.py -r",
+ "command": "export
PATH=/home/aris/Installations/default-env/bin:$PATH && cd
${workspaceFolder}/sql/test/delete-from-value-list/Tests && Mtest.py -r",
"group": {
"kind": "test",
"isDefault": true
diff --git a/sql/test/delete-from-value-list/Tests/All
b/sql/test/delete-from-value-list/Tests/All
new file mode 100644
--- /dev/null
+++ b/sql/test/delete-from-value-list/Tests/All
@@ -0,0 +1,1 @@
+delete-from-sub-table
diff --git a/sql/test/delete-from-value-list/Tests/create-and-fill-table.sql
b/sql/test/delete-from-value-list/Tests/create-and-fill-table.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/delete-from-value-list/Tests/create-and-fill-table.sql
@@ -0,0 +1,17 @@
+create table table1 (id int);
+
+create procedure fill_table1(maximum_size bigint)
+begin
+ declare val bigint;
+ set val = 0;
+
+ while val < maximum_size do
+ insert into table1 values (val);
+
+ set val = val + 1;
+ end while;
+end;
+
+call fill_table1(1000000);
+
+drop table table1 cascade;
diff --git a/sql/test/delete-from-value-list/Tests/delete-from-sub-table.py
b/sql/test/delete-from-value-list/Tests/delete-from-sub-table.py
new file mode 100644
--- /dev/null
+++ b/sql/test/delete-from-value-list/Tests/delete-from-sub-table.py
@@ -0,0 +1,44 @@
+import os, sys
+try:
+ from MonetDBtesting import process
+except ImportError:
+ import process
+
+def server_start(args):
+ sys.stderr.write('#mserver: "%s"\n' % ' '.join(args))
+ sys.stderr.flush()
+ srv = process.server(args = args, stdin = process.PIPE,
+ stdout = process.PIPE, stderr = process.PIPE)
+ return srv
+
+def client(lang, file):
+ sys.stderr.write('#client: "%s"\n' % file)
+ sys.stderr.flush()
+ clt = process.client(lang.lower(), stdin = open(file),
+ stdout = process.PIPE, stderr = process.PIPE)
+ return clt.communicate()
+
+def delete_where_in_sub_query_statement():
+ return "delete from table1 where id in (select subtable1.id from
subtable1);select count(*) from table1;"
+
+def main():
+ srv = server_start([])
+
+ out, err = client('SQL',
+ os.path.join(os.getenv('RELSRCDIR'),
+ 'delete.sql'))
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+ c = process.client('sql', stdin = process.PIPE, stdout = process.PIPE,
stderr = process.PIPE)
+
+ out, err = c.communicate(delete_where_in_sub_query_statement())
+
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+ out, err = srv.communicate()
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+main()
diff --git a/sql/test/delete-from-value-list/Tests/delete-from-value-list.py
b/sql/test/delete-from-value-list/Tests/delete-from-value-list.py
new file mode 100644
--- /dev/null
+++ b/sql/test/delete-from-value-list/Tests/delete-from-value-list.py
@@ -0,0 +1,46 @@
+import os, sys
+try:
+ from MonetDBtesting import process
+except ImportError:
+ import process
+
+def server_start(args):
+ sys.stderr.write('#mserver: "%s"\n' % ' '.join(args))
+ sys.stderr.flush()
+ srv = process.server(args = args, stdin = process.PIPE,
+ stdout = process.PIPE, stderr = process.PIPE)
+ return srv
+
+def client(lang, file):
+ sys.stderr.write('#client: "%s"\n' % file)
+ sys.stderr.flush()
+ clt = process.client(lang.lower(), stdin = open(file),
+ stdout = process.PIPE, stderr = process.PIPE)
+ return clt.communicate()
+
+def delete_where_in_mega_value_list_query_statement(size, period):
+ values = [str(x) for x in range(0, size-1) if x % period == 0]
+
+ return "delete from table1 where id in ({});select count(*) from
table1;".format(','.join(values))
+
+def main():
+ srv = server_start([])
+
+ out, err = client('SQL',
+ os.path.join(os.getenv('RELSRCDIR'),
+ 'create-and-fill-table.sql'))
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+ c = process.client('sql', stdin = process.PIPE, stdout = process.PIPE,
stderr = process.PIPE)
+
+ out, err =
c.communicate(delete_where_in_mega_value_list_query_statement(1000000, 5))
+
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+ out, err = srv.communicate()
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+main()
diff --git
a/sql/test/delete-from-value-list/Tests/delete-from-value-list.timeout
b/sql/test/delete-from-value-list/Tests/delete-from-value-list.timeout
new file mode 100644
--- /dev/null
+++ b/sql/test/delete-from-value-list/Tests/delete-from-value-list.timeout
@@ -0,0 +1,1 @@
+10
diff --git a/sql/test/delete-from-value-list/Tests/delete.sql
b/sql/test/delete-from-value-list/Tests/delete.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/delete-from-value-list/Tests/delete.sql
@@ -0,0 +1,21 @@
+create table table1 (id int);
+
+create procedure fill_table1(maximum_size bigint)
+begin
+ declare val bigint;
+ set val = 0;
+
+ while val < maximum_size do
+ insert into table1 values (val);
+
+ set val = val + 1;
+ end while;
+end;
+
+call fill_table1(1000000);
+
+create table subtable1 (id int);
+
+insert into subtable1 select id from table1 where id % 5 = 0;
+
+select count(*) from subtable1;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
