test: Simplify test file naming for easier expansion

[BohuTANG]

Summary

now:
05_0019_ddl_create_view.test

after:
05_ddl_create_view.test

It's easy to add new test file.

[BohuTANG]

#!/bin/bash

# The directory where your test files are located
root_dir="/path/"

# Use find to recursively search for .test files
find "$root_dir" -type f -name '*.test' | while read -r file; do
    # Extract new filename by using sed to remove the _00xx_ pattern
    new_name=$(echo "$file" | sed -E 's/(_[0-9]{4})(_)/\2/g')

    # Move (rename) the file to the new name
    if [ "$file" != "$new_name" ]; then
        mv "$file" "$new_name"
        echo "Renamed: $file -> $new_name"
    fi
done