Changeset: 6adb908b3bc7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/6adb908b3bc7
Modified Files:
sql/test/nested/Tests/webclicks.test.in
Branch: nested
Log Message:
add crashing case
diffs (29 lines):
diff --git a/sql/test/nested/Tests/webclicks.test.in
b/sql/test/nested/Tests/webclicks.test.in
--- a/sql/test/nested/Tests/webclicks.test.in
+++ b/sql/test/nested/Tests/webclicks.test.in
@@ -179,6 +179,25 @@ FROM events
----
60
+query TTTTTTTTTT
+SELECT
+ timestamp,
+ sessionid,
+ userid,
+ user_agent,
+ event,
+ ecommerce.name as ecom_name,
+ CASE WHEN l.element.key = 'pageType' THEN l.element.value END AS pagetype,
+ CASE WHEN u.element.key = 'customerType' THEN u.element.value END AS
customertype,
+ CASE WHEN u.element.key = 'customerid' THEN u.element.value END AS
customerid,
+ CASE WHEN eal.element.key = 'brand' THEN eal.element.value END AS
ecom_attributes_brand
+FROM events
+ left join unnest(location.list) as l on true
+ left join unnest(ecommerce.objects.list) as eol on true
+ left join unnest(eol.element.attributes.list) as eal on true
+ cross join unnest("user".list) as u
+----
+
#WITH base AS (
# SELECT
# timestamp,
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
