Changeset: 2b1005c56152 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2b1005c56152 Added Files: sql/test/nested/Tests/inserts.test Modified Files: sql/test/nested/Tests/All Branch: nested Log Message:
Enables composite test file for nested and adds new inserts test file diffs (61 lines): diff --git a/sql/test/nested/Tests/All b/sql/test/nested/Tests/All --- a/sql/test/nested/Tests/All +++ b/sql/test/nested/Tests/All @@ -3,3 +3,5 @@ basic fileloader webclicks array +composite +inserts diff --git a/sql/test/nested/Tests/inserts.test b/sql/test/nested/Tests/inserts.test new file mode 100644 --- /dev/null +++ b/sql/test/nested/Tests/inserts.test @@ -0,0 +1,47 @@ +## columns types + +statement ok +create table bt_col (n int) + +# composite col type + +statement ok +create type ct as (n int, m text) + +statement ok +create table ct_col (c ct) + +statement ok +create type cat as (na int[], m text) + +statement ok +create table cat_col (ca cat) + +statement ok +create table bt_arr (n int[]) + +statement ok +create table ct_arr (c ct[]) + +## dml + +statement ok +insert into bt_col values (1), (2) + +statement ok +insert into ct_col values ((1, 'hello')), ((2, 'world')) + +statement error 42000! +insert into cat_col values (((1, 2), 'alice')), (((3, 4), 'bob')) + +### CRASH +###statement ok +###insert into cat_col values ((array[1, 2], 'alice')), ((array[3, 4], 'bob')) + +### CRASH +###statement ok +###insert into bt_arr values (array[1, 2]), (array[10, 20]) + +statement ok +insert into ct_arr values (array[(1, 'tic'), (2, 'tac')]), (array[(10, 'abc'), (20, 'xyz')]) + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
