Changeset: ed69122d70d6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ed69122d70d6 Added Files: sql/test/mosaic/Tests/prefix.sql Modified Files: sql/test/mosaic/Tests/All sql/test/mosaic/Tests/prefix.stable.out Branch: mosaic Log Message:
Add sql prefix test. diffs (73 lines): diff --git a/sql/test/mosaic/Tests/All b/sql/test/mosaic/Tests/All --- a/sql/test/mosaic/Tests/All +++ b/sql/test/mosaic/Tests/All @@ -4,9 +4,7 @@ compressionRLE2 xqueries xqueries_rle xqueries_delta -#prefix TODO - +prefix mix - session_init session_exit diff --git a/sql/test/mosaic/Tests/prefix.sql b/sql/test/mosaic/Tests/prefix.sql new file mode 100644 --- /dev/null +++ b/sql/test/mosaic/Tests/prefix.sql @@ -0,0 +1,18 @@ +set optimizer='mosaic_pipe'; + +create table tmpPrefix( i integer); +insert into tmpPrefix values (1), (1), (1), (1), (1), (1), (2), (2); + +select * from tmpPrefix; + +alter table tmpPrefix alter column i set storage 'prefix'; + +select * from tmpPrefix; +select count(*) from tmpPrefix; + +alter table tmpPrefix alter column i set storage NULL; + +select * from tmpPrefix; +select sum(i) from tmpPrefix; + +drop table tmpPrefix; diff --git a/sql/test/mosaic/Tests/prefix.stable.out b/sql/test/mosaic/Tests/prefix.stable.out --- a/sql/test/mosaic/Tests/prefix.stable.out +++ b/sql/test/mosaic/Tests/prefix.stable.out @@ -17,11 +17,9 @@ stdout of test 'prefix` in directory 'sq # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-21664/.s.monetdb.35122 # MonetDB/SQL module loaded -Ready. - -# 12:53:32 > -# 12:53:32 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-21664" "--port=35122" -# 12:53:32 > +# 13:32:13 > +# 13:32:13 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-32286" "--port=32588" +# 13:32:13 > #set optimizer='mosaic_pipe'; #create table tmpPrefix( i integer); @@ -55,7 +53,7 @@ Ready. [ 2 ] [ 2 ] #select count(*) from tmpPrefix; -% sys.L4 # table_name +% .L3 # table_name % L3 # name % bigint # type % 1 # length @@ -75,7 +73,7 @@ Ready. [ 2 ] [ 2 ] #select sum(i) from tmpPrefix; -% sys.L4 # table_name +% sys.L3 # table_name % L3 # name % hugeint # type % 2 # length _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
