Changeset: 4fc6e7325339 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/4fc6e7325339
Branch: default
Log Message:
merge Aug2024
diffs (81 lines):
diff --git a/buildtools/conf/monetdbd.conf.in b/buildtools/conf/monetdbd.conf.in
--- a/buildtools/conf/monetdbd.conf.in
+++ b/buildtools/conf/monetdbd.conf.in
@@ -1,3 +1,6 @@
# this file is for systemd
# monetdbd needs a directory in /run that is owned by monetdb:monetdb
d @CMAKE_INSTALL_FULL_RUNSTATEDIR@/monetdb 0775 monetdb monetdb -
+# do not touch our socket files
+x /tmp/.s.monetdb.*
+x /tmp/.s.merovingian.*
diff --git a/sql/test/BugTracker-2024/Tests/7605_full_3_level_name_support.test
b/sql/test/BugTracker-2024/Tests/7605_full_3_level_name_support.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2024/Tests/7605_full_3_level_name_support.test
@@ -0,0 +1,37 @@
+statement ok
+create schema test
+
+statement ok
+create table test.mytable (name clob, id clob)
+
+statement ok
+insert into test.mytable values('my', '1')
+
+statement ok
+insert into test.mytable values('my', '2')
+
+-- 42000!SELECT: cannot use non GROUP BY column 'mytable.name' in query
results without an aggregate function
+skipif knownfail
+query TI nosort
+select test.mytable.name, count(*)
+from test.mytable
+group by test.mytable.name
+order by test.mytable.name
+----
+my
+2
+
+query TI nosort
+select x.name, count(*)
+from test.mytable as x
+group by x.name
+order by x.name
+----
+my
+2
+
+statement ok
+drop table test.mytable
+
+statement ok
+drop schema test
diff --git a/sql/test/BugTracker-2024/Tests/7607-alter-add-serial.test
b/sql/test/BugTracker-2024/Tests/7607-alter-add-serial.test
--- a/sql/test/BugTracker-2024/Tests/7607-alter-add-serial.test
+++ b/sql/test/BugTracker-2024/Tests/7607-alter-add-serial.test
@@ -18,3 +18,15 @@ alter table t add column d serial;
statement ok
create table tb(a int, b int auto_increment)
+
+statement ok
+drop table tb
+
+statement ok
+drop table t
+
+statement ok
+set schema sys
+
+statement ok
+drop schema s7607
diff --git a/sql/test/BugTracker-2024/Tests/All
b/sql/test/BugTracker-2024/Tests/All
--- a/sql/test/BugTracker-2024/Tests/All
+++ b/sql/test/BugTracker-2024/Tests/All
@@ -99,4 +99,5 @@ KNOWNFAIL?7598-foreign_key_match_options
KNOWNFAIL?7598-foreign_key_match_options_dump
7602-copy-into-multiple-files
7603-copy-into-3files-crash
-7607-alter-add-serial.test
+7605_full_3_level_name_support
+7607-alter-add-serial
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
