Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.2.0
-
None
-
None
-
2018-10, 2018-11
Description
The following works fine in 1.1 but errors in develop:
CREATE TABLE `pv_facts` (
|
`page_view_id` varchar(35) NOT NULL,
|
`visit_date_key` date NOT NULL,
|
`visit_time_key` varchar(6) DEFAULT "000000",
|
`visitor_key` int unsigned NOT NULL,
|
`user_key` int unsigned NOT NULL,
|
`referring_url_key` int unsigned NOT NULL,
|
`url_key` int unsigned NOT NULL,
|
`publication_key` int unsigned NOT NULL,
|
`eref_key` int unsigned NOT NULL,
|
`iref_key` int unsigned NOT NULL,
|
`content_key` int unsigned NOT NULL,
|
`device_key` int unsigned NOT NULL,
|
`visit_time` decimal(18,5) NOT NULL,
|
`visit_id` varchar(100) NOT NULL,
|
`ip_address` bigint NOT NULL,
|
`visit_type` varchar(20) NOT NULL,
|
`page_type` varchar(20) NOT NULL,
|
`page_id` varchar(255) DEFAULT NULL,
|
`first_byte` int unsigned DEFAULT NULL,
|
`dom_interactive` int unsigned DEFAULT NULL,
|
`dns_lookup` int unsigned DEFAULT NULL,
|
`dom_done` int unsigned DEFAULT NULL,
|
`small_screen` int unsigned DEFAULT "0",
|
`view_width` int unsigned DEFAULT "0",
|
`view_height` int unsigned DEFAULT "0"
|
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
|