Changeset: 855b87757088 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=855b87757088
Removed Files:
sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.stable.out.int128
Modified Files:
sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.sql
sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.stable.out
sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.test
Branch: mtest
Log Message:
Updated test using mclient
diffs (154 lines):
diff --git
a/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.sql
b/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.sql
---
a/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.sql
+++
b/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.sql
@@ -1,7 +1,9 @@
CREATE TABLE bar (name CHAR(8), ct INTEGER, ct2 INTEGER);
INSERT INTO bar VALUES ('A', 123, 456);
-CREATE TABLE foo AS SELECT SUM(ct + ct2) / 100.0 AS eur FROM bar GROUP BY name
WITH DATA;
-\d foo
+CREATE TABLE foo AS SELECT cast(SUM(ct + ct2) as bigint) / 100.0 AS eur FROM
bar GROUP BY name WITH DATA;
+
+select "name", "query", "type", "remark" from describe_table('sys', 'foo');
+select * from describe_columns('sys', 'foo');
DROP TABLE foo;
DROP TABLE bar;
diff --git
a/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.stable.out
b/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.stable.out
---
a/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.stable.out
+++
b/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.stable.out
@@ -60,10 +60,19 @@ stdout of test 'mserver-creates-but-not-
#CREATE TABLE bar (name CHAR(8), ct INTEGER, ct2 INTEGER);
#INSERT INTO bar VALUES ('A', 123, 456);
[ 1 ]
-#CREATE TABLE foo AS SELECT SUM(ct + ct2) / 100.0 AS eur FROM bar GROUP BY
name WITH DATA;
-CREATE TABLE "sys"."foo" (
- "eur" DECIMAL(18,3)
-);
+#CREATE TABLE foo AS SELECT cast(SUM(ct + ct2) as bigint) / 100.0 AS eur FROM
bar GROUP BY name WITH DATA;
+#select "name", "query", "type", "remark" from describe_table('sys', 'foo');
+% .%3, .%3, .%3, .%3 # table_name
+% name, query, type, remark # name
+% clob, clob, clob, clob # type
+% 3, 0, 5, 0 # length
+[ "foo", NULL, "TABLE", NULL ]
+#select * from describe_columns('sys', 'foo');
+% .%3, .%3, .%3, .%3, .%3, .%3, .%3, .%3 # table_name
+% name, type, digits, scale, nulls, cdefault, number, remark
# name
+% clob, clob, int, int, boolean, clob, int, clob #
type
+% 3, 7, 2, 1, 5, 0, 1, 0 # length
+[ "eur", "decimal", 23, 3, true, NULL, 0, NULL
]
#DROP TABLE foo;
#DROP TABLE bar;
diff --git
a/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.stable.out.int128
b/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.stable.out.int128
deleted file mode 100644
---
a/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.stable.out.int128
+++ /dev/null
@@ -1,73 +0,0 @@
-stdout of test
'mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863` in
directory 'sql/test/BugTracker-2015` itself:
-
-
-# 18:46:27 >
-# 18:46:27 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=34224" "--set"
"mapi_usock=/var/tmp/mtest-73834/.s.monetdb.34224" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/Users/jennie/scratch/monet-install/Jul2015/debug/var/MonetDB/mTests_sql_test_BugTracker-2015"
"--set" "mal_listing=0" "--set" "embedded_r=yes"
-# 18:46:27 >
-
-# MonetDB 5 server v11.21.12
-# This is an unreleased version
-# Serving database 'mTests_sql_test_BugTracker-2015', using 2 threads
-# Compiled for x86_64-apple-darwin14.5.0/64bit with 64bit OIDs dynamically
linked
-# Found 4.000 GiB available main-memory.
-# Copyright (c) 1993-July 2008 CWI.
-# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
-# Visit http://www.monetdb.org/ for further information
-# Listening for connection requests on
mapi:monetdb://dhcp-207.eduroam.cwi.nl:34224/
-# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-73834/.s.monetdb.34224
-# MonetDB/GIS module loaded
-# Start processing logs sql/sql_logs version 52200
-# Finished processing logs sql/sql_logs
-# MonetDB/SQL module loaded
-# MonetDB/R module loaded
-
-# SQL catalog created, loading sql scripts once
-# loading sql script: 09_like.sql
-# loading sql script: 10_math.sql
-# loading sql script: 11_times.sql
-# loading sql script: 12_url.sql
-# loading sql script: 13_date.sql
-# loading sql script: 14_inet.sql
-# loading sql script: 15_querylog.sql
-# loading sql script: 16_tracelog.sql
-# loading sql script: 17_temporal.sql
-# loading sql script: 20_vacuum.sql
-# loading sql script: 21_dependency_functions.sql
-# loading sql script: 22_clients.sql
-# loading sql script: 23_skyserver.sql
-# loading sql script: 24_zorder.sql
-# loading sql script: 25_debug.sql
-# loading sql script: 26_sysmon.sql
-# loading sql script: 27_rejects.sql
-# loading sql script: 39_analytics.sql
-# loading sql script: 40_geom.sql
-# loading sql script: 40_json.sql
-# loading sql script: 41_md5sum.sql
-# loading sql script: 45_uuid.sql
-# loading sql script: 46_gsl.sql
-# loading sql script: 51_sys_schema_extension.sql
-# loading sql script: 72_fits.sql
-# loading sql script: 75_storagemodel.sql
-# loading sql script: 80_statistics.sql
-# loading sql script: 80_udf.sql
-# loading sql script: 90_generator.sql
-# loading sql script: 99_system.sql
-
-# 18:46:28 >
-# 18:46:28 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-73834" "--port=34224"
-# 18:46:28 >
-
-#CREATE TABLE bar (name CHAR(8), ct INTEGER, ct2 INTEGER);
-#INSERT INTO bar VALUES ('A', 123, 456);
-[ 1 ]
-#CREATE TABLE foo AS SELECT SUM(ct + ct2) / 100.0 AS eur FROM bar GROUP BY
name WITH DATA;
-CREATE TABLE "sys"."foo" (
- "eur" DECIMAL(23,3)
-);
-#DROP TABLE foo;
-#DROP TABLE bar;
-
-# 18:46:29 >
-# 18:46:29 > "Done."
-# 18:46:29 >
-
diff --git
a/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.test
b/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.test
---
a/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.test
+++
b/sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.test
@@ -5,10 +5,27 @@ statement ok
INSERT INTO bar VALUES ('A', 123, 456)
statement ok
-CREATE TABLE foo AS SELECT SUM(ct + ct2) / 100.0 AS eur FROM bar GROUP BY name
WITH DATA
+CREATE TABLE foo AS SELECT cast(SUM(ct + ct2) as bigint) / 100.0 AS eur FROM
bar GROUP BY name WITH DATA
+
+query TTTT rowsort
+select "name", "query", "type", "remark" from describe_table('sys', 'foo')
+----
+foo
+NULL
+TABLE
+NULL
-statement ok
-\d foo
+query TTIITTIT rowsort
+select * from describe_columns('sys', 'foo')
+----
+eur
+decimal
+23
+3
+True
+NULL
+0
+NULL
statement ok
DROP TABLE foo
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
