1384 Commits (3.0.2)

Author	SHA1	Message	Date
René Cannaò	2c26a42897	Merge pull request #4819 from sysown/v3.0-ff_conns_eof_caps_match ... Enforce `CLIENT_DEPRECATE_EOF` capability match for `fast-forward` sessions	1 year ago
René Cannaò	988d4049ac	Merge pull request #4941 from sysown/v3.0-4935 ... Fix losing database info on first logging for 'caching_sha2_password' - Closes #4935	1 year ago
René Cannaò	edc84ea14b	Merge pull request #4922 from sysown/v3.0-4861_fixes1 ... Further enhancement in prepared statement logging #4861	1 year ago
René Cannaò	d622fcfd4d	Merge pull request #4932 from sysown/v3.0-4918 ... Fix query digests for comments for certain query sizes - Closes #4918.	1 year ago
Javier Jaramago Fernández	93b3e2a5a0	Add test verifying handshake info is preserved across auth methods	1 year ago
Javier Jaramago Fernández	ea8211618e	Extract auth testing utils from 'test_auth_methods-t.cpp'	1 year ago
René Cannaò	8c9375d018	Merge pull request #4938 from sysown/v3.0-sliced_groups ... add sliced groups	1 year ago
Miro Stauder	6b6ffc3a9e	remove obsolete stuff	1 year ago
Miro Stauder	d0a5c39236	change -sliceX naming to -gX	1 year ago
René Cannaò	9f4b139e6c	Merge pull request #4929 from sysown/v3.0_track_transaction_param_state_4907 ... Track Variable State Across Transactions and Savepoints - v3.0	1 year ago
Miro Stauder	e7d4ddb59d	add sliced groups	1 year ago
Rahim Kanji	4d5ca5adbe	Improved TAP test logging	1 year ago
Rahim Kanji	f87fc30261	Added TAP test	1 year ago
Javier Jaramago Fernández	1d7840673a	Several updates for 'test_mysql_query_digests_stages-t.cpp' ... - New regression payloads for fix in 5c3a0637. - Added config option for 'null' replacement in 'mz' payloads. - When specifying 'regular' as command line option, it's now possible to also specify the path to the file holding the payloads to be tested.	1 year ago
Javier Jaramago Fernández	b2568d7af5	Fix waits before unshunning for 'test_unshun_algorithm-t.cpp' - Closes #4930	1 year ago
René Cannaò	4e05596ddd	Updating test_ps_logging-t after enabling mysql-eventslog_stmt_parameters ... Now that variable `mysql-eventslog_stmt_parameters` is present and disabled by default, `mysql-eventslog_stmt_parameters` needs to be enabled to run test `test_ps_logging-t`	1 year ago
Rahim Kanji	dd589508f4	Added regression test	1 year ago
Javier Jaramago Fernández	1c416275ee	Add regression tests for certain query digests comments	1 year ago
René Cannaò	77247a1bd8	Merge pull request #4895 from sysown/v3.0-4861-mysql-logging_prepared_statement_parameters ... [MYSQL] logging of prepared statement parameters #4861	1 year ago
René Cannaò	231622f8ed	Adding sleep in test_ps_logging	1 year ago
René Cannaò	1b801f2f09	Adding defaults in tables in test_ps_logging-t	1 year ago
René Cannaò	0bf5839e20	Extending test_ps_logging-t ... Extending test_ps_logging-t with more data types	1 year ago
René Cannaò	ae68ebace9	Merge pull request #4911 from sysown/v3.0_reg_4867_tap_test ... Replaced last_insert_rowid() with MAX(...)	1 year ago
Javier Jaramago Fernández	a098f99046	Fix flags on conn creation for 'test_binlog_fast_forward-t'	1 year ago
Javier Jaramago Fernández	811874bad1	Merge branch 'v3.0' of github.com:sysown/proxysql into v3.0-ff_conns_eof_caps_match	1 year ago
René Cannaò	35e4ed58a9	Extending test_ps_logging-t to test more data types	1 year ago
René Cannaò	6df3d6b84b	Merge pull request #4899 from sysown/v3.0_refactor_connection_info_param ... Refactor PostgreSQL Connection-Level Parameters Handling	1 year ago
René Cannaò	a39580ffe1	Several fixes on prepared statements parameters logging ... In write_query_format_1() : * write the number of parameters (previously erroneously skipped) * write null_bitmap only if there are parameters * write the parameters values (this was previously erroneously skipped) In test_ps_logging-t.cpp : * verify that query logging is configured to file In eventlog_reader_to_json.cpp : * added verbose logging * added enum `log_event_type` for properly identifying event type * parse all events in the input file	1 year ago
Rahim Kanji	51c93d987e	Replaced last_insert_rowid() with MAX(...) because last_insert_rowid() is specific to a database connection, and random modifications are performed by monitoring thread	1 year ago
René Cannaò	2cfebaddec	Adding tap test for logging prepared statements parameters ... Still not completed. We still need an automatic way to verify the generated files.	1 year ago
Rahim Kanji	4c918490a4	Added TAP test ... Note: - Using libpq to test ProxySQL's handling of undocumented parameters isn't possible, as libpq enforces a strict subset of PostgreSQL connection parameters as per the official documentation, rejecting any undocumented parameters. However, actual PostgreSQL servers accept additional parameters (e.g., extra_float_digits) and apply them at the connection/session level. To test this behavior, a raw socket is used to connect to a ProxySQL server and send custom built messages to communicate with ProxySQL. It currently works with plain text password authentication, without ssl support. - Failure due to an invalid parameter returned by the PostgreSQL server, differs from ProxySQL's behavior. PostgreSQL returns an error during the connection handshake phase, whereas in ProxySQL, the connection succeeds, but the error is encountered when executing a query. This is behaviour is intentional, as newer PostgreSQL versions may introduce new parameters that ProxySQL is not yet aware of.	1 year ago
René Cannaò	e17477e297	Merge pull request #4871 from sysown/v3.0-4803_20250313 ... Port to 3.0 of in-memory query logging	1 year ago
René Cannaò	16a1a4d1f5	Remove hardcoded values in mysql_query_logging_memory-t	1 year ago
René Cannaò	1d00d45a96	Fixed the return values of get_matching_lines()	1 year ago
René Cannaò	d3f06c537f	Merge branch 'v3.0' into v3.0-ff_conns_eof_caps_match	1 year ago
René Cannaò	a876b1f055	Merge pull request #4881 from sysown/v3.0-ci_fixes_172 ... Fix issues with several TAP tests - Closes #4830	1 year ago
René Cannaò	6ab22f4870	Merge pull request #4875 from sysown/v3.0_improve_copy_stdin ... Moved dynamic fast-forward logic (used for COPY ... FROM STDIN) to execute after session variables are set on the backend connection	1 year ago
René Cannaò	ad193258b2	Merge pull request #4872 from sysown/v3.0_issue_4867 ... Fixed mirror_hostgroup and mirror_flagOUT swapping issue in MySQL and PostgreSQL query rules - v3.0	1 year ago
Javier Jaramago Fernández	1aaa16a7c1	Complete redesign of 'mysql-protocol_compression_level-t.cpp' ... - Deterministic test table: Invalid limits and tables with variable rows ('information_schema') were used to create the original table size, this is now replaced with a deterministic table. - Compression overhead measurement: Previous test design generated a very large resultset (> 20Gb), performing a single measurement per resultset. This resulted in very inaccurate measurements, with radical variations between different systems. A resultset of the previous size can interfere in multiple ways with measurements, like network saturation, bufferbloat, and queuing delays at application level, all things that are out of the scope of the test measurement. This have been reworked into multiple smaller packets (40Mb) big enough so that the increased latency of compression can be measured and averaged. - Fixed test checks: Previous test checks were meaningless, performing only a non-zero comparison between performance differences. This gave no insights about ProxySQL vs MySQL differences or allowed for simple coherence checks (non-compress time < compress time). All these checks have new confidence ranges based on experimental values. - Improved general logging based on other TAP tests conventions and refactored most of the functions.	1 year ago
Javier Jaramago Fernández	13d46de27b	Adjust TAP test time threshold based on OpenSSL version - Closes #4830	1 year ago
Javier Jaramago Fernández	70b6686e87	Fix target hostgroup for 'test_utf8mb4_as_ci-4841-t.cpp' ... Test requires a MySQL 8 instance, this is now parametrized via TAP_MYSQL8_BACKEND_HG env variable as in other TAP tests.	1 year ago
Javier Jaramago Fernández	73288cb76f	Remove duplicate utils from 'test_query_rules_fast_routing_algorithm-t'	1 year ago
Javier Jaramago Fernández	69c2839f0d	Fix 'set_testing-240-t' issues with recent MariaDB versions	1 year ago
Javier Jaramago Fernández	da61dca29c	Increase tolerances in 'test_backend_conn_ping-t' ... Number of connections being maintained by the test now assumes (number_of_intervals - 1). This spare interval decreases the number of connections actively maintained and should make the test more resilient in to small network stalls.	1 year ago
Javier Jaramago Fernández	e37f933fbe	Fix 'plan' test count for 'set_character_set-t'	1 year ago
René Cannaò	644e518c76	Removed test of character_set_database	1 year ago
Rahim Kanji	45eadce110	Fixed TAP test	1 year ago
Rahim Kanji	c5e348628d	Fixed permission issue	1 year ago
Rahim Kanji	0bf4fd0bcb	Fixed TAP test pgsql-copy_from_stdin_session_parameter-t	1 year ago
Rahim Kanji	1cb3f0e92a	Added TAP test	1 year ago