Changeset: 0e7980bf352a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0e7980bf352a
Added Files:
sql/test/strimps/Tests/strimps_not_like.SQL.py
Modified Files:
sql/test/strimps/Tests/All
sql/test/strimps/Tests/persisted_strimp.SQL.py
sql/test/strimps/Tests/strimps_stable_counts.SQL.py
Branch: strimps_update
Log Message:
Add test for NOT LIKE
diffs (100 lines):
diff --git a/sql/test/strimps/Tests/All b/sql/test/strimps/Tests/All
--- a/sql/test/strimps/Tests/All
+++ b/sql/test/strimps/Tests/All
@@ -1,2 +1,3 @@
strimps_stable_counts
persisted_strimp
+strimps_not_like
diff --git a/sql/test/strimps/Tests/persisted_strimp.SQL.py
b/sql/test/strimps/Tests/persisted_strimp.SQL.py
--- a/sql/test/strimps/Tests/persisted_strimp.SQL.py
+++ b/sql/test/strimps/Tests/persisted_strimp.SQL.py
@@ -41,7 +41,7 @@ with tempfile.TemporaryDirectory() as fa
mdb.execute("ALTER TABLE orders SET READ ONLY;")
mdb.execute("CREATE IMPRINTS INDEX o_comment_strimp ON
orders(o_comment);")
- mdb.execute("SELECT COUNT(*) FROM orders WHERE o_comment LIKE
'%%slyly%%';").assertSucceeded().assertDataResultMatch([(12896,)])
+
mdb.execute(COUNT_QUERY).assertSucceeded().assertDataResultMatch([(12896,)])
s.communicate()
with process.server(mapiport='0', dbname='db1',
@@ -50,6 +50,6 @@ with tempfile.TemporaryDirectory() as fa
stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as s:
with SQLTestCase() as mdb:
mdb.connect(database='db1', port=s.dbport, username='monetdb',
password='monetdb')
- mdb.execute("SELECT COUNT(*) FROM orders WHERE o_comment LIKE
'%%slyly%%';").assertSucceeded().assertDataResultMatch([(12896,)])
- mdb.execute("SELECT COUNT(*) FROM orders WHERE o_comment LIKE
'%%slyly%%';").assertSucceeded().assertDataResultMatch([(12896,)])
+
mdb.execute(COUNT_QUERY).assertSucceeded().assertDataResultMatch([(12896,)])
+
mdb.execute(COUNT_QUERY).assertSucceeded().assertDataResultMatch([(12896,)])
s.communicate()
diff --git a/sql/test/strimps/Tests/strimps_not_like.SQL.py
b/sql/test/strimps/Tests/strimps_not_like.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/strimps/Tests/strimps_not_like.SQL.py
@@ -0,0 +1,48 @@
+import os
+import tempfile
+
+try:
+ from MonetDBtesting import process
+except ImportError:
+ import process
+from MonetDBtesting.sqltest import SQLTestCase
+
+COUNT_NOT_LIKE_QUERY = "SELECT COUNT(*) FROM orders WHERE o_comment NOT LIKE
'%%slyly%%';"
+
+with tempfile.TemporaryDirectory() as farm_dir:
+ fdir = os.path.join(farm_dir, 'db1')
+ os.mkdir(fdir)
+ with process.server(mapiport='0', dbname='db1',
+ dbfarm=fdir,
+ stdin=process.PIPE,
+ stdout=process.PIPE,
+ stderr=process.PIPE) as s:
+ with SQLTestCase() as mdb:
+ mdb.connect(database='db1', port=s.dbport, username='monetdb',
password='monetdb')
+ mdb.execute("""CREATE TABLE orders (
+ o_orderkey BIGINT NOT NULL,
+ o_custkey INTEGER NOT NULL,
+ o_orderstatus CHAR(1) NOT NULL,
+ o_totalprice DECIMAL(15,2) NOT NULL,
+ o_orderdate DATE NOT NULL,
+ o_orderpriority CHAR(15) NOT NULL,
+ o_clerk CHAR(15) NOT NULL,
+ o_shippriority INTEGER NOT NULL,
+ o_comment VARCHAR(79) NOT
NULL);""").assertSucceeded()
+ mdb.execute("""COPY 15000 RECORDS INTO orders from
r'{}/sql/benchmarks/tpch/SF-0.01/orders.tbl' USING DELIMITERS
'|','\n','"';""".format(os.getenv('TSTSRCBASE'))).assertSucceeded()
+ mdb.execute("""COPY 15000 RECORDS INTO orders from
r'{}/sql/benchmarks/tpch/SF-0.01/orders.tbl' USING DELIMITERS
'|','\n','"';""".format(os.getenv('TSTSRCBASE'))).assertSucceeded()
+ mdb.execute("""COPY 15000 RECORDS INTO orders from
r'{}/sql/benchmarks/tpch/SF-0.01/orders.tbl' USING DELIMITERS
'|','\n','"';""".format(os.getenv('TSTSRCBASE'))).assertSucceeded()
+ mdb.execute("""COPY 15000 RECORDS INTO orders from
r'{}/sql/benchmarks/tpch/SF-0.01/orders.tbl' USING DELIMITERS
'|','\n','"';""".format(os.getenv('TSTSRCBASE'))).assertSucceeded()
+
mdb.execute(COUNT_NOT_LIKE_QUERY).assertSucceeded().assertDataResultMatch([(47104,)])
+ # Create strimp
+ mdb.execute("ALTER TABLE orders SET READ ONLY;")
+ mdb.execute("CREATE IMPRINTS INDEX o_comment_strimp ON
orders(o_comment);")
+ s.communicate()
+
+ with process.server(mapiport='0', dbname='db1',
+ dbfarm=fdir,
+ stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as s:
+ with SQLTestCase() as mdb:
+ mdb.connect(database='db1', port=s.dbport, username='monetdb',
password='monetdb')
+
mdb.execute(COUNT_NOT_LIKE_QUERY).assertSucceeded().assertDataResultMatch([(47104,)])
+ s.communicate()
diff --git a/sql/test/strimps/Tests/strimps_stable_counts.SQL.py
b/sql/test/strimps/Tests/strimps_stable_counts.SQL.py
--- a/sql/test/strimps/Tests/strimps_stable_counts.SQL.py
+++ b/sql/test/strimps/Tests/strimps_stable_counts.SQL.py
@@ -36,7 +36,7 @@ with tempfile.TemporaryDirectory() as fa
mdb.execute("""COPY 15000 RECORDS INTO orders from
r'{}/sql/benchmarks/tpch/SF-0.01/orders.tbl' USING DELIMITERS
'|','\n','"';""".format(os.getenv('TSTSRCBASE'))).assertSucceeded()
mdb.execute("""COPY 15000 RECORDS INTO orders from
r'{}/sql/benchmarks/tpch/SF-0.01/orders.tbl' USING DELIMITERS
'|','\n','"';""".format(os.getenv('TSTSRCBASE'))).assertSucceeded()
mdb.execute("""COPY 15000 RECORDS INTO orders from
r'{}/sql/benchmarks/tpch/SF-0.01/orders.tbl' USING DELIMITERS
'|','\n','"';""".format(os.getenv('TSTSRCBASE'))).assertSucceeded()
- mdb.execute("SELECT COUNT(*) FROM orders WHERE o_comment LIKE
'%%slyly%%';").assertSucceeded().assertDataResultMatch([(12896,)])
+
mdb.execute(COUNT_QUERY).assertSucceeded().assertDataResultMatch([(12896,)])
s.communicate()
with process.server(mapiport='0', dbname='db1',
@@ -47,5 +47,5 @@ with tempfile.TemporaryDirectory() as fa
# Create strimp
mdb.execute("ALTER TABLE orders SET READ ONLY;")
mdb.execute("CREATE IMPRINTS INDEX o_comment_strimp ON
orders(o_comment);")
- mdb.execute("SELECT COUNT(*) FROM orders WHERE o_comment LIKE
'%%slyly%%';").assertSucceeded().assertDataResultMatch([(12896,)])
+
mdb.execute(COUNT_QUERY).assertSucceeded().assertDataResultMatch([(12896,)])
s.communicate()
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
