Changeset: fdffb7386868 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fdffb7386868
Modified Files:
sql/test/miscellaneous/Tests/select_groupby.sql
sql/test/miscellaneous/Tests/select_groupby.stable.out
Branch: Apr2019
Log Message:
Extended test case
diffs (202 lines):
diff --git a/sql/test/miscellaneous/Tests/select_groupby.sql
b/sql/test/miscellaneous/Tests/select_groupby.sql
--- a/sql/test/miscellaneous/Tests/select_groupby.sql
+++ b/sql/test/miscellaneous/Tests/select_groupby.sql
@@ -61,4 +61,51 @@ mytable."twentieth-third", mytable."twen
FROM myschema.mytable
WHERE ("first" = '227 / 0' AND "eleventh" = 'Lekker' AND (EXTRACT(YEAR FROM
mytable."eighth")*100 + EXTRACT(MONTH FROM mytable."eighth"))/100.0 =
'2014.030')
GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT 1001;
+
+PREPARE SELECT
+mytable."eighth" AS "first-projection",
+mytable."twentieth", mytable."twentieth-seventh",
+mytable."twentieth-third", mytable."twentieth-second"
+FROM myschema.mytable
+WHERE ("first" = '227 / 0' AND "eleventh" = 'Lekker' AND (EXTRACT(YEAR FROM
mytable."eighth")*100 + EXTRACT(MONTH FROM mytable."eighth"))/100.0 =
'2014.030')
+GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT 1001;
+exec ** ();
+
+PREPARE SELECT
+mytable."eighth" AS "first-projection",
+mytable."twentieth", mytable."twentieth-seventh",
+mytable."twentieth-third", mytable."twentieth-second"
+FROM myschema.mytable
+WHERE ("first" = ? AND "eleventh" = ? AND (EXTRACT(YEAR FROM mytable."eighth")
* cast(? as bigint) + EXTRACT(MONTH FROM mytable."eighth")) / cast(? as bigint)
= cast(? as bigint))
+GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT ?;
+exec ** ('a', 'b', 923, 51, 942, 544);
+
+TRUNCATE myschema.mytable;
+
+SELECT
+mytable."eighth" AS "first-projection",
+mytable."twentieth", mytable."twentieth-seventh",
+mytable."twentieth-third", mytable."twentieth-second"
+FROM myschema.mytable
+WHERE ("first" = '227 / 0' AND "eleventh" = 'Lekker' AND (EXTRACT(YEAR FROM
mytable."eighth")*100 + EXTRACT(MONTH FROM mytable."eighth"))/100.0 =
'2014.030')
+GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT 1001;
+
+PREPARE SELECT
+mytable."eighth" AS "first-projection",
+mytable."twentieth", mytable."twentieth-seventh",
+mytable."twentieth-third", mytable."twentieth-second"
+FROM myschema.mytable
+WHERE ("first" = '227 / 0' AND "eleventh" = 'Lekker' AND (EXTRACT(YEAR FROM
mytable."eighth")*100 + EXTRACT(MONTH FROM mytable."eighth"))/100.0 =
'2014.030')
+GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT 1001;
+exec ** ();
+
+PREPARE SELECT
+mytable."eighth" AS "first-projection",
+mytable."twentieth", mytable."twentieth-seventh",
+mytable."twentieth-third", mytable."twentieth-second"
+FROM myschema.mytable
+WHERE ("first" = ? AND "eleventh" = ? AND (EXTRACT(YEAR FROM mytable."eighth")
* cast(? as bigint) + EXTRACT(MONTH FROM mytable."eighth")) / cast(? as bigint)
= cast(? as bigint))
+GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT ?;
+exec ** ('a', 'b', 923, 51, 942, 544);
+
rollback;
diff --git a/sql/test/miscellaneous/Tests/select_groupby.stable.out
b/sql/test/miscellaneous/Tests/select_groupby.stable.out
--- a/sql/test/miscellaneous/Tests/select_groupby.stable.out
+++ b/sql/test/miscellaneous/Tests/select_groupby.stable.out
@@ -107,6 +107,143 @@ Ready.
% first-projection, twentieth, twentieth-seventh,
twentieth-third, twentieth-second # name
% date, char, char, double, double # type
% 10, 100, 100, 24, 24 # length
+#PREPARE SELECT
+#mytable."eighth" AS "first-projection",
+#mytable."twentieth", mytable."twentieth-seventh",
+#mytable."twentieth-third", mytable."twentieth-second"
+#FROM myschema.mytable
+#WHERE ("first" = '227 / 0' AND "eleventh" = 'Lekker' AND (EXTRACT(YEAR FROM
mytable."eighth")*100 + EXTRACT(MONTH FROM mytable."eighth"))/100.0 =
'2014.030')
+#GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT 1001;
+#PREPARE SELECT
+#mytable."eighth" AS "first-projection",
+#mytable."twentieth", mytable."twentieth-seventh",
+#mytable."twentieth-third", mytable."twentieth-second"
+#FROM myschema.mytable
+#WHERE ("first" = '227 / 0' AND "eleventh" = 'Lekker' AND (EXTRACT(YEAR FROM
mytable."eighth")*100 + EXTRACT(MONTH FROM mytable."eighth"))/100.0 =
'2014.030')
+#GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT 1001;
+% .prepare, .prepare, .prepare, .prepare, .prepare,
.prepare # table_name
+% type, digits, scale, schema, table, column # name
+% varchar, int, int, str, str, str # type
+% 6, 3, 1, 0, 7, 17 # length
+[ "date", 0, 0, "", "mytable", "first-projection"
]
+[ "char", 100, 0, "", "mytable", "twentieth" ]
+[ "char", 100, 0, "", "mytable", "twentieth-seventh"
]
+[ "double", 53, 0, "", "mytable", "twentieth-third"
]
+[ "double", 53, 0, "", "mytable", "twentieth-second"
]
+#exec 13 ();
+% myschema.mytable, myschema.mytable, myschema.mytable,
myschema.mytable, myschema.mytable # table_name
+% first-projection, twentieth, twentieth-seventh,
twentieth-third, twentieth-second # name
+% date, char, char, double, double # type
+% 10, 100, 100, 24, 24 # length
+#PREPARE SELECT
+#mytable."eighth" AS "first-projection",
+#mytable."twentieth", mytable."twentieth-seventh",
+#mytable."twentieth-third", mytable."twentieth-second"
+#FROM myschema.mytable
+#WHERE ("first" = ? AND "eleventh" = ? AND (EXTRACT(YEAR FROM
mytable."eighth") * cast(? as bigint) + EXTRACT(MONTH FROM mytable."eighth")) /
cast(? as bigint) = cast(? as bigint))
+#GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT ?;
+#PREPARE SELECT
+#mytable."eighth" AS "first-projection",
+#mytable."twentieth", mytable."twentieth-seventh",
+#mytable."twentieth-third", mytable."twentieth-second"
+#FROM myschema.mytable
+#WHERE ("first" = ? AND "eleventh" = ? AND (EXTRACT(YEAR FROM
mytable."eighth") * cast(? as bigint) + EXTRACT(MONTH FROM mytable."eighth")) /
cast(? as bigint) = cast(? as bigint))
+#GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT ?;
+% .prepare, .prepare, .prepare, .prepare, .prepare,
.prepare # table_name
+% type, digits, scale, schema, table, column # name
+% varchar, int, int, str, str, str # type
+% 6, 5, 1, 0, 7, 17 # length
+[ "date", 0, 0, "", "mytable", "first-projection"
]
+[ "char", 100, 0, "", "mytable", "twentieth" ]
+[ "char", 100, 0, "", "mytable", "twentieth-seventh"
]
+[ "double", 53, 0, "", "mytable", "twentieth-third"
]
+[ "double", 53, 0, "", "mytable", "twentieth-second"
]
+[ "char", 100, 0, NULL, NULL, NULL ]
+[ "char", 100, 0, NULL, NULL, NULL ]
+[ "bigint", 64, 0, NULL, NULL, NULL ]
+[ "bigint", 64, 0, NULL, NULL, NULL ]
+[ "bigint", 64, 0, NULL, NULL, NULL ]
+[ "bigint", 64, 0, NULL, NULL, NULL ]
+#exec 15 ('a', 'b', 923, 51, 942, 544);
+% myschema.mytable, myschema.mytable, myschema.mytable,
myschema.mytable, myschema.mytable # table_name
+% first-projection, twentieth, twentieth-seventh,
twentieth-third, twentieth-second # name
+% date, char, char, double, double # type
+% 10, 100, 100, 24, 24 # length
+#TRUNCATE myschema.mytable;
+[ 1 ]
+#SELECT
+#mytable."eighth" AS "first-projection",
+#mytable."twentieth", mytable."twentieth-seventh",
+#mytable."twentieth-third", mytable."twentieth-second"
+#FROM myschema.mytable
+#WHERE ("first" = '227 / 0' AND "eleventh" = 'Lekker' AND (EXTRACT(YEAR FROM
mytable."eighth")*100 + EXTRACT(MONTH FROM mytable."eighth"))/100.0 =
'2014.030')
+#GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT 1001;
+% myschema.mytable, myschema.mytable, myschema.mytable,
myschema.mytable, myschema.mytable # table_name
+% first-projection, twentieth, twentieth-seventh,
twentieth-third, twentieth-second # name
+% date, char, char, double, double # type
+% 10, 100, 100, 24, 24 # length
+#PREPARE SELECT
+#mytable."eighth" AS "first-projection",
+#mytable."twentieth", mytable."twentieth-seventh",
+#mytable."twentieth-third", mytable."twentieth-second"
+#FROM myschema.mytable
+#WHERE ("first" = '227 / 0' AND "eleventh" = 'Lekker' AND (EXTRACT(YEAR FROM
mytable."eighth")*100 + EXTRACT(MONTH FROM mytable."eighth"))/100.0 =
'2014.030')
+#GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT 1001;
+#PREPARE SELECT
+#mytable."eighth" AS "first-projection",
+#mytable."twentieth", mytable."twentieth-seventh",
+#mytable."twentieth-third", mytable."twentieth-second"
+#FROM myschema.mytable
+#WHERE ("first" = '227 / 0' AND "eleventh" = 'Lekker' AND (EXTRACT(YEAR FROM
mytable."eighth")*100 + EXTRACT(MONTH FROM mytable."eighth"))/100.0 =
'2014.030')
+#GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT 1001;
+% .prepare, .prepare, .prepare, .prepare, .prepare,
.prepare # table_name
+% type, digits, scale, schema, table, column # name
+% varchar, int, int, str, str, str # type
+% 6, 3, 1, 0, 7, 17 # length
+[ "date", 0, 0, "", "mytable", "first-projection"
]
+[ "char", 100, 0, "", "mytable", "twentieth" ]
+[ "char", 100, 0, "", "mytable", "twentieth-seventh"
]
+[ "double", 53, 0, "", "mytable", "twentieth-third"
]
+[ "double", 53, 0, "", "mytable", "twentieth-second"
]
+#exec 21 ();
+% myschema.mytable, myschema.mytable, myschema.mytable,
myschema.mytable, myschema.mytable # table_name
+% first-projection, twentieth, twentieth-seventh,
twentieth-third, twentieth-second # name
+% date, char, char, double, double # type
+% 10, 100, 100, 24, 24 # length
+#PREPARE SELECT
+#mytable."eighth" AS "first-projection",
+#mytable."twentieth", mytable."twentieth-seventh",
+#mytable."twentieth-third", mytable."twentieth-second"
+#FROM myschema.mytable
+#WHERE ("first" = ? AND "eleventh" = ? AND (EXTRACT(YEAR FROM
mytable."eighth") * cast(? as bigint) + EXTRACT(MONTH FROM mytable."eighth")) /
cast(? as bigint) = cast(? as bigint))
+#GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT ?;
+#PREPARE SELECT
+#mytable."eighth" AS "first-projection",
+#mytable."twentieth", mytable."twentieth-seventh",
+#mytable."twentieth-third", mytable."twentieth-second"
+#FROM myschema.mytable
+#WHERE ("first" = ? AND "eleventh" = ? AND (EXTRACT(YEAR FROM
mytable."eighth") * cast(? as bigint) + EXTRACT(MONTH FROM mytable."eighth")) /
cast(? as bigint) = cast(? as bigint))
+#GROUP BY "first-projection", "twentieth", "twentieth-seventh",
"twentieth-third", "twentieth-second" LIMIT ?;
+% .prepare, .prepare, .prepare, .prepare, .prepare,
.prepare # table_name
+% type, digits, scale, schema, table, column # name
+% varchar, int, int, str, str, str # type
+% 6, 5, 1, 0, 7, 17 # length
+[ "date", 0, 0, "", "mytable", "first-projection"
]
+[ "char", 100, 0, "", "mytable", "twentieth" ]
+[ "char", 100, 0, "", "mytable", "twentieth-seventh"
]
+[ "double", 53, 0, "", "mytable", "twentieth-third"
]
+[ "double", 53, 0, "", "mytable", "twentieth-second"
]
+[ "char", 100, 0, NULL, NULL, NULL ]
+[ "char", 100, 0, NULL, NULL, NULL ]
+[ "bigint", 64, 0, NULL, NULL, NULL ]
+[ "bigint", 64, 0, NULL, NULL, NULL ]
+[ "bigint", 64, 0, NULL, NULL, NULL ]
+[ "bigint", 64, 0, NULL, NULL, NULL ]
+#exec 23 ('a', 'b', 923, 51, 942, 544);
+% myschema.mytable, myschema.mytable, myschema.mytable,
myschema.mytable, myschema.mytable # table_name
+% first-projection, twentieth, twentieth-seventh,
twentieth-third, twentieth-second # name
+% date, char, char, double, double # type
+% 10, 100, 100, 24, 24 # length
#rollback;
# 13:54:02 >
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
