Changeset: e8d8cb2b81bb for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e8d8cb2b81bb
Added Files:
sql/test/prepare/Tests/prepare-view.SQL.py
sql/test/prepare/Tests/prepare-view.sql
sql/test/prepare/Tests/prepare-view.stable.out
Modified Files:
sql/test/SQLancer/Tests/sqlancer16.test
sql/test/prepare/Tests/All
Branch: Jul2021
Log Message:
Added tests for recent fixes
diffs (86 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer16.test
b/sql/test/SQLancer/Tests/sqlancer16.test
--- a/sql/test/SQLancer/Tests/sqlancer16.test
+++ b/sql/test/SQLancer/Tests/sqlancer16.test
@@ -132,3 +132,22 @@ 8
statement ok
ROLLBACK
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE t0(c0 INTERVAL DAY)
+
+statement ok rowcount 3
+INSERT INTO t0(c0) VALUES(INTERVAL '9' DAY), (INTERVAL '7' DAY), (INTERVAL '8'
DAY)
+
+query T rowsort
+select sub0.c2 from t0 cross join (values (timestamp '1970-01-01 01:00:00',
timestamp '1970-01-01 01:00:00')) as sub0(c1,c2)
+----
+1970-01-01 01:00:00
+1970-01-01 01:00:00
+1970-01-01 01:00:00
+
+statement ok
+ROLLBACK
+
diff --git a/sql/test/prepare/Tests/All b/sql/test/prepare/Tests/All
--- a/sql/test/prepare/Tests/All
+++ b/sql/test/prepare/Tests/All
@@ -28,3 +28,4 @@ subquery_prepare
decimal_needs_truncation.SF-2605686
prepare_commit_execute.SF-2606020
prepare_decimal_bug.SF-2831994
+prepare-view
diff --git a/sql/test/prepare/Tests/prepare-view.SQL.py
b/sql/test/prepare/Tests/prepare-view.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/prepare/Tests/prepare-view.SQL.py
@@ -0,0 +1,10 @@
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ # optional or default connection
+ tc.connect()
+ with open('prepare-view.sql') as f:
+ tc.execute(query=None, client='mclient', stdin=f)\
+ .assertSucceeded()\
+ .assertMatchStableOut(fout='prepare-view.stable.out')
+
diff --git a/sql/test/prepare/Tests/prepare-view.sql
b/sql/test/prepare/Tests/prepare-view.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/prepare/Tests/prepare-view.sql
@@ -0,0 +1,11 @@
+prepare CREATE TABLE IF NOT EXISTS mydata ( sensor VARCHAR(64) NOT NULL, dt
TIMESTAMP NOT NULL, val INTEGER NOT NULL, exponent INTEGER NOT NULL, CONSTRAINT
data_pk PRIMARY KEY(sensor, dt));
+exec **();
+
+prepare CREATE VIEW myview AS SELECT m.sensor, m.dt, m.val * power(10,
m.exponent) FROM mydata m;
+exec **();
+
+SELECT * FROM mydata;
+SELECT * FROM myview;
+
+DROP VIEW myview;
+DROP TABLE mydata;
diff --git a/sql/test/prepare/Tests/prepare-view.stable.out
b/sql/test/prepare/Tests/prepare-view.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/prepare/Tests/prepare-view.stable.out
@@ -0,0 +1,16 @@
+% .prepare, .prepare, .prepare, .prepare, .prepare,
.prepare # table_name
+% type, digits, scale, schema, table, column # name
+% varchar, int, int, str, str, str # type
+% 0, 1, 1, 0, 0, 0 # length
+% .prepare, .prepare, .prepare, .prepare, .prepare,
.prepare # table_name
+% type, digits, scale, schema, table, column # name
+% varchar, int, int, str, str, str # type
+% 0, 1, 1, 0, 0, 0 # length
+% sys.mydata, sys.mydata, sys.mydata, sys.mydata # table_name
+% sensor, dt, val, exponent # name
+% varchar, timestamp, int, int # type
+% 0, 26, 1, 1 # length
+% sys.myview, sys.myview, sys.myview # table_name
+% sensor, dt, v # name
+% varchar, timestamp, double # type
+% 0, 26, 24 # length
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
