Dylan Su

Dylan Su has asked 0 questions and find answers to 18 problems.

Stats

About

Software quality architecture work:

Complete continuous integrity(CI) / continuous delivery(CD) process construction
Static scanning techniques
Automation testing framework construction
Online flow replay techniques
Auto-generating testing framework, facilitated with AI

Database correctness related work:

Use Random Query Generator(RQG) to break different databases, like MySQL 5.5-5.7, MariaDB 10.1.10, Oceanbase(Alibaba) and etc (100+ bugs filed to MySQL)
Other random testing on SQL
Part of database optimizer development
Tools: linux, python, java, c++, MySQL, MariaDB, RQG

Dylan Su questions

Dylan Su answers

Sorting in group_concat
MySQL select all the entries older than 10 days
fetch and find frquency count of generalized zipcode
SQLZOO SELECT from nobel #14
Mysql group_concat of repeated keys and count of repetition of multiple columns in 1 query ( Query Optimization )
List all MySQL tables and exclude specific one
Fetching last insert id shows wrong number
mySQL select from a list from another select
How to check whether a date is the 2nd or 4th Sunday of the month in MySQL?
How to disable only_full_group_by in MySQL or Sequelize