[GitHub] [airflow] alexott commented on pull request #25579: Fix migration code for the dag_owner_attributes table

[GitBox <gi...@apache.org>]

alexott commented on PR #25579:
URL: https://github.com/apache/airflow/pull/25579#issuecomment-1207378121

   my default locale on Linux is `en_US.UTF-8`, but right now I'm looking into output of `show create table`, and see table declared as `DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci`, and `dag_id` as `CHARACTER SET utf8 COLLATE utf8_bin`:
   
   ```
   CREATE TABLE `dag` (
     `dag_id` varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
     `is_paused` tinyint(1) DEFAULT NULL,
     `is_subdag` tinyint(1) DEFAULT NULL,
     `is_active` tinyint(1) DEFAULT NULL,
     `last_parsed_time` timestamp NULL DEFAULT NULL,
     `last_pickled` timestamp(6) NULL DEFAULT NULL,
     `last_expired` timestamp(6) NULL DEFAULT NULL,
     `scheduler_lock` tinyint(1) DEFAULT NULL,
     `pickle_id` int(11) DEFAULT NULL,
     `fileloc` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
     `owners` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
     `description` text COLLATE utf8mb4_unicode_ci,
     `default_view` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
     `schedule_interval` text COLLATE utf8mb4_unicode_ci,
     `root_dag_id` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
     `next_dagrun` timestamp(6) NULL DEFAULT NULL,
     `next_dagrun_create_after` timestamp(6) NULL DEFAULT NULL,
     `max_active_tasks` int(11) NOT NULL,
     `has_task_concurrency_limits` tinyint(1) NOT NULL,
     `max_active_runs` int(11) DEFAULT NULL,
     `next_dagrun_data_interval_start` timestamp(6) NULL DEFAULT NULL,
     `next_dagrun_data_interval_end` timestamp(6) NULL DEFAULT NULL,
     `has_import_errors` tinyint(1) DEFAULT '0',
     `timetable_description` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
     PRIMARY KEY (`dag_id`),
     KEY `idx_root_dag_id` (`root_dag_id`),
     KEY `idx_next_dagrun_create_after` (`next_dagrun_create_after`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
   ```
   
   I believe that I've recreated a MySQL setup few months ago, but maybe I'm wrong and I initialized it last year around November.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org