/usr/local/GreatSQL-8.0.32-25/bin/mysqld --defaults-file=/etc/mysql/9004.cnf   --user=mysql &
[1] 15707
[root@yingji-db04.produce.yz ~]# 2024-03-19T07:14:58.433496Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2024-03-19T07:14:58.433503Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2024-03-19T07:14:58.433631Z 0 [System] [MY-010116] [Server] /usr/local/GreatSQL-8.0.32-25/bin/mysqld (mysqld 8.0.32-25) starting as process 15707
2024-03-19T07:14:58.445817Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-19T07:14:59.597040Z 1 [ERROR] [MY-013171] [InnoDB] Cannot boot server version 80032 on data directory built by version 80036. Downgrade is not supported
mysqld: Can't open file: 'mysql.ibd' (errno: 0 - )
2024-03-19T07:15:00.274727Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-03-19T07:15:00.275416Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-19T07:15:00.275457Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-19T07:15:00.276532Z 0 [System] [MY-010910] [Server] /usr/local/GreatSQL-8.0.32-25/bin/mysqld: Shutdown complete (mysqld 8.0.32-25)  GreatSQL, Release 25, Revision 79f57097e3f.

mysql> ALTER TABLE BIZ_Enterprise                 SECONDARY_LOAD;
ERROR 3877 (HY000): The data type is not yet supported

mysql>  desc BIZ_Enterprise;
+--------------------+---------------+------+-----+-------------------+-----------------------------------------------+
| Field              | Type          | Null | Key | Default           | Extra                                         |
+--------------------+---------------+------+-----+-------------------+-----------------------------------------------+
| RecordID           | int           | NO   | PRI | NULL              | auto_increment                                |
| Guid               | varchar(36)   | NO   |     | NULL              |                                               |
| EnterpriseID       | bigint        | NO   | UNI | NULL              |                                               |
| EnterpriseName     | varchar(256)  | YES  |     | NULL              |                                               |
| EnterpriseFullName | varchar(256)  | YES  |     | NULL              |                                               |
| PID                | bigint        | YES  | MUL | 0                 |                                               |
| Level              | int           | YES  |     | 1                 |                                               |
| AreaID             | bigint        | YES  |     | NULL              |                                               |
| BeginDate          | date          | YES  |     | NULL              |                                               |
| Remarks            | varchar(1024) | YES  |     | NULL              |                                               |
| IsUse              | bit(1)        | NO   |     | b'1'              |                                               |
| OwnerID            | bigint        | NO   |     | NULL              |                                               |
| CreatedDate        | datetime      | NO   |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED                             |
| ModifiedDate       | timestamp     | NO   |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
+--------------------+---------------+------+-----+-------------------+-----------------------------------------------+
14 rows in set (0.01 sec)

SELECT a.CustomerID
	, SUM(CASE 
		WHEN a.DataDate >= '2023-12-01' THEN b.Amount - b.AmountTotal
		ELSE 0
	END) AS XCDiscount
	, SUM(CASE 
		WHEN a.DataDate < '2023-12-01'
			AND a.DataDate >= qcdate.DataDate
		THEN AmountTotal
		ELSE 0
	END) AS XSFS_QC
	, SUM(CASE 
		WHEN a.DataDate >= '2023-12-01' THEN t3.yfAmount
		ELSE 0
	END) AS yfAmount
	, SUM(CASE 
		WHEN a.DataDate >= '2023-12-01' THEN Amount
		ELSE 0
	END) AS Amount
	, SUM(CASE 
		WHEN a.DataDate < '2023-12-01'
			AND a.DataDate >= qcdate.DataDate
		THEN t3.yfAmount
		ELSE 0
	END) AS Qmyf
	, cus.CustomerName AS SummaryType1Name, cus.CustomerID AS SummaryType1, '客户' AS SummaryType1FieldName
FROM test_Qlw_Business.SA_Sales a
	INNER JOIN test_Qlw_Business.SA_SalesDetail_czx b ON a.NumericalOrder = b.NumericalOrder
	LEFT JOIN (
		SELECT c.EnterpriseID, MAX(IFNULL(a.DataDate, '1990-01-01')) AS DataDate
		FROM qlw_test_com.BIZ_Enterprise_czx c
			LEFT JOIN test_Qlw_Business.FD_SettleReceipt a
			ON a.EnterpriseID = c.EnterpriseID
				AND SettleReceipType = 201610220104402204
				AND a.datadate <= '2023-12-01'
		WHERE c.enterpriseid = 1132506
		GROUP BY c.enterpriseid
	) qcdate
	ON a.enterpriseid = qcdate.enterpriseid
	LEFT JOIN (
		SELECT t1.EnterpriseID AS EnterpriseID, t1.DataDate AS DataDate, t3.ParentValue, Avg(t2.AmountTotal) AS yfAmount
		FROM test_qlw_business.ls_carriage t1
			INNER JOIN test_qlw_business.ls_carriagedetail t2 ON t1.NumericalOrder = t2.NumericalOrder
			INNER JOIN test_qlw_business.biz_related t3
			ON RelatedType = 201610210104402122
				AND ParentType = 1805081858270000130
				AND ChildType = 1612230944450000101
				AND t2.NumericalOrderDetail = t3.ChildValue
		WHERE t2.AmountTotal IS NOT NULL
			AND t1.EnterpriseID = 1132506
			AND t1.DataDate <= '2023-12-31'
		GROUP BY EnterpriseID, DataDate, ParentValue
	) t3
	ON t3.ParentValue = a.NumericalOrder
		AND t3.EnterpriseID = a.EnterpriseID
	LEFT JOIN qlw_test_com.biz_customer_czx cus ON a.CustomerID = cus.CustomerID
WHERE a.DataDate <= '2023-12-31'
	AND a.EnterpriseID = 1132506
GROUP BY a.CustomerID, SummaryType1


ERROR 3877 (HY000): Binder Error: column "CustomerName" must appear in the GROUP BY clause or must be part of an aggregate function.
Either add it to the GROUP BY list, or use "ANY_VALUE(CustomerName)" if the exact value of "CustomerName" is not important.



mysql> show variables like '%sql_mode%'
    -> ;
+-----------------+----------------------------------------------------------------------------------------------------+
| Variable_name   | Value                                                                                              |
+-----------------+----------------------------------------------------------------------------------------------------+
| shrink_sql_mode |                                                                                                    |
| sql_mode        | STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
+-----------------+----------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)