Changeset: cf53b2ff6d18 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cf53b2ff6d18 Added Files: sql/test/rename/Tests/rename04.sql sql/test/rename/Tests/rename04.stable.err Modified Files: sql/test/rename/Tests/All Branch: rename-sql Log Message:
New test. diffs (88 lines): diff --git a/sql/test/rename/Tests/All b/sql/test/rename/Tests/All --- a/sql/test/rename/Tests/All +++ b/sql/test/rename/Tests/All @@ -1,3 +1,4 @@ rename01 rename02 rename03 +rename04 diff --git a/sql/test/rename/Tests/rename04.sql b/sql/test/rename/Tests/rename04.sql new file mode 100644 --- /dev/null +++ b/sql/test/rename/Tests/rename04.sql @@ -0,0 +1,35 @@ +create table "trychangeme" (something int); +insert into "trychangeme" values (1); + +start transaction; + +insert into "trychangeme" values (2); +select "something" from "trychangeme"; +alter table "trychangeme" rename to "anothername"; +select "something" from "anothername"; +select "name" from sys.tables where "name" in ('trychangeme', 'anothername'); +insert into "anothername" values (3); +select "something" from "anothername"; + +savepoint sp1; + +insert into "anothername" values (4); +select "something" from "anothername"; +alter table "anothername" alter column "something" rename to "somethingelse"; +select "somethingelse" from "anothername"; +select "name" from sys.columns where "table_id" in (select "id" from sys.tables where "name" = 'anothername'); + +rollback to savepoint sp1; + +insert into "anothername" values (5); +select "something" from "anothername"; +select "name" from sys.columns where "table_id" in (select "id" from sys.tables where "name" = 'anothername'); + +rollback; + +select "name" from sys.tables where "name" in ('trychangeme', 'anothername'); +insert into "trychangeme" values (6); +select "something" from "trychangeme"; + +drop table "trychangeme"; +select "name" from sys.tables where "name" in ('trychangeme', 'anothername'); diff --git a/sql/test/rename/Tests/rename04.stable.err b/sql/test/rename/Tests/rename04.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/rename/Tests/rename04.stable.err @@ -0,0 +1,35 @@ +stderr of test 'rename04` in directory 'sql/test/rename` itself: + + +# 10:21:04 > +# 10:21:04 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39810" "--set" "mapi_usock=/var/tmp/mtest-30073/.s.monetdb.39810" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/ferreira/repositories/MonetDB-rename-sql/BUILD/var/MonetDB/mTests_sql_test_rename" "--set" "embedded_c=true" +# 10:21:04 > + +# builtin opt gdk_dbpath = /home/ferreira/repositories/MonetDB-rename-sql/BUILD/var/monetdb5/dbfarm/demo +# builtin opt gdk_debug = 0 +# builtin opt gdk_vmtrim = no +# builtin opt monet_prompt = > +# builtin opt monet_daemon = no +# builtin opt mapi_port = 50000 +# builtin opt mapi_open = false +# builtin opt mapi_autosense = false +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 39810 +# cmdline opt mapi_usock = /var/tmp/mtest-30073/.s.monetdb.39810 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /home/ferreira/repositories/MonetDB-rename-sql/BUILD/var/MonetDB/mTests_sql_test_rename +# cmdline opt embedded_c = true +# cmdline opt gdk_debug = 553648138 + +# 10:21:05 > +# 10:21:05 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-30073" "--port=39810" +# 10:21:05 > + + +# 10:21:06 > +# 10:21:06 > "Done." +# 10:21:06 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list