Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1406

Cannot create pv_facts table in develop

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2.0
    • 1.1.5
    • 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;
      

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            LinuxJedi Andrew Hutchings (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.