mysql

mysql left join 连接空表时造成全表扫描 BNL


加一点数据

发现是 BNL 算法的问题

https://blog.csdn.net/qq_41931364/article/details/121877375

Tags: 

Drupal sql 注入研究


  function debug_sql(string $type) {
    $list = [];
    $sql = <<<sql
SELECT node.nid AS nid, node.title AS title, node.created AS node_created
FROM 
{node} node
WHERE (( (node.status = '1') AND (node.type IN  ('$type')) ))
ORDER BY node_created DESC
sql;
    $result = db_query($sql);

Drupal 7 views_data_export 数据导出 阿里云 RDS mysql5.7 导出失败解决


由于阿里云RDS使用 GTID 导致 views_data_export 导出数据时报错

Statement violates GTID consistency

经过查询发现下面的补丁,可以解决这个问题。

https://www.drupal.org/project/views_data_export/issues/2209853#comment-...