proxysql

Commit Graph

Author	SHA1	Message	Date
Rene Cannao	c8408d76b3	test: add 6 unit test files with 588 assertions (Round 5) New test files (test/tap/tests/unit/): Core: - pgsql_tokenizer_unit-t (65 tests): PgSQL SQL digest — dollar- quoted strings, ::type casts, ARRAY literals, boolean literal replacement, E/B/X/U& prefix strings, comment handling, grouping/IN-list collapsing, edge cases - admin_disk_upgrade_unit-t (60 tests): all 6 disk_upgrade_*() schema migration functions with in-memory SQLite — scheduler v1.2.0→current, mysql_users v1.3.0→current, rest_api_routes v2.0.15→current, mysql_servers v1.1.0→current (with weight cap and compression normalization bugs), pgsql_replication_hostgroups v3.0.1→current, mysql_query_rules v1.2.2→current - gtid_utils_unit-t (37 tests): addGtid interval merging (adjacent, non-consecutive, duplicate, bridge, reverse-order, within- existing), addGtidInterval (update, duplicate, non-overlapping), gtid_executed_to_string formatting - glovars_unit-t (78 tests): GloVars constructor defaults, ProxySQL_Checksum_Value (set/replace_zeros/version/epoch), generate_global_checksum determinism, command-line parsing (--initial/--reload/--no-version-check/-D/--bootstrap/-n/-f/-M) - query_processor_unit-t (+217 tests, 259 total): EXTENDED with PgSQL-specific tests — all-fields rule creation, client_addr wildcard, flagOUT attributes JSON, command counters, stats, rule text 35-column serialization, query_parser_command_type for 100+ PgSQL commands (DML/DDL/views/sequences/functions/ triggers/policies/LISTEN/NOTIFY/VACUUM/TEXT SEARCH/etc.), fast routing hashmap, firewall whitelist, query digests GenAI/MCP (PROXYSQLGENAI=1): - genai_mysql_catalog_unit-t (89 tests): MySQL_Catalog with in-memory SQLite — upsert/get/remove, schema isolation, list with pagination, FTS search, merge, multiple kinds, special character handling Production changes for testability: - include/proxysql_admin.h: add friend class TestDiskUpgrade - test/tap/tests/unit/Makefile: add DEBUG auto-detection from libproxysql.a symbols (fixes struct layout ODR violations when library is built with -DDEBUG) Running totals: 32 test files, 2553 assertions, all passing.	3 months ago

Author

SHA1

Message

Date

Rene Cannao

c8408d76b3

test: add 6 unit test files with 588 assertions (Round 5)

New test files (test/tap/tests/unit/):

  Core:
  - pgsql_tokenizer_unit-t (65 tests): PgSQL SQL digest — dollar-
    quoted strings, ::type casts, ARRAY literals, boolean literal
    replacement, E/B/X/U& prefix strings, comment handling,
    grouping/IN-list collapsing, edge cases
  - admin_disk_upgrade_unit-t (60 tests): all 6 disk_upgrade_*()
    schema migration functions with in-memory SQLite — scheduler
    v1.2.0→current, mysql_users v1.3.0→current, rest_api_routes
    v2.0.15→current, mysql_servers v1.1.0→current (with weight cap
    and compression normalization bugs), pgsql_replication_hostgroups
    v3.0.1→current, mysql_query_rules v1.2.2→current
  - gtid_utils_unit-t (37 tests): addGtid interval merging (adjacent,
    non-consecutive, duplicate, bridge, reverse-order, within-
    existing), addGtidInterval (update, duplicate, non-overlapping),
    gtid_executed_to_string formatting
  - glovars_unit-t (78 tests): GloVars constructor defaults,
    ProxySQL_Checksum_Value (set/replace_zeros/version/epoch),
    generate_global_checksum determinism, command-line parsing
    (--initial/--reload/--no-version-check/-D/--bootstrap/-n/-f/-M)
  - query_processor_unit-t (+217 tests, 259 total): EXTENDED with
    PgSQL-specific tests — all-fields rule creation, client_addr
    wildcard, flagOUT attributes JSON, command counters, stats,
    rule text 35-column serialization, query_parser_command_type
    for 100+ PgSQL commands (DML/DDL/views/sequences/functions/
    triggers/policies/LISTEN/NOTIFY/VACUUM/TEXT SEARCH/etc.),
    fast routing hashmap, firewall whitelist, query digests

  GenAI/MCP (PROXYSQLGENAI=1):
  - genai_mysql_catalog_unit-t (89 tests): MySQL_Catalog with
    in-memory SQLite — upsert/get/remove, schema isolation,
    list with pagination, FTS search, merge, multiple kinds,
    special character handling

Production changes for testability:
- include/proxysql_admin.h: add friend class TestDiskUpgrade
- test/tap/tests/unit/Makefile: add DEBUG auto-detection from
  libproxysql.a symbols (fixes struct layout ODR violations
  when library is built with -DDEBUG)

Running totals: 32 test files, 2553 assertions, all passing.

1 Commits (feature/pgsql-native-backend-protocol)