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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
