2
0
mirror of https://github.com/boostorg/mysql.git synced 2026-01-23 05:42:22 +00:00

292 Commits

Author SHA1 Message Date
Anarthal (Rubén Pérez)
c242bb0ffd Added CI tests for MySQL 9.x
close #303
2025-10-07 16:56:17 +02:00
Anarthal (Rubén Pérez)
6a82609638 caching_sha2_password can now be used without TLS
Fixed a problem that caused pfr_by_name<T> to fail compilation when T has no fields under older clang/libc++ versions.

close #313
close #483
2025-06-07 13:20:48 +02:00
Anarthal (Rubén Pérez)
90405e79e4 Handshake is now more resilient
Errors issued by the server for caching_sha2_password users after a fast
auth OK packet has been received (e.g. bad database errors) are now
reported correctly
Handshake now correctly detects protocol violation errors, like double
auth switches

close #469 
close #468
2025-05-07 13:11:52 +02:00
Anarthal (Rubén Pérez)
cbe9270253 Added handshake unit tests
close #442
2025-04-25 17:10:34 +02:00
Anarthal (Rubén Pérez)
303b9f0b59 Added benchmarks against the official drivers
Added one_small_row, one_big_row, many_rows, stmt_params benchmarks against libmysqlclient and libmariadb
Added a CI build to compile and run benchmarks
Added a Python script to run the benchmarks
Refactored the connection_pool benchmark to be use data independent from examples

close #458
2025-04-02 11:32:43 +02:00
Anarthal (Rubén Pérez)
e988c9ad9e Added docs on using asio::cancel_after with pool_params::thread_safe
close #402
2025-02-24 22:11:35 +01:00
Anarthal (Rubén Pérez)
33660e2710 Starting operations while engaged in multi-function ops is no longer UB
Attempting to start an operation involving server communication after a
multi-function operation has been started and before all its associated
packets have been read now fails with
client_errc::engaged_in_multi_function, instead of causing undefined
behavior.
Attempting to start a read_some_rows or read_resultset_head operation
with no in-progress multi-function operation now fails with
client_errc::not_engaged_in_multi_function.
Attempting to start an operation that requires an established session
before a successful connect now fails with client_errc::not_connected.
Added the three client_errc enum values mentioned above.
Renamed detail::connection_status (connection_pool) to node_status.
Added detail::connection_status (connection_state_data).
Removed redundant spotcheck tests.

close #448 
close #450
2025-02-22 19:15:03 +01:00
Anarthal (Rubén Pérez)
3868d8a0cf Added unit tests for the close connection algorithm
close #445
2025-02-19 16:13:23 +01:00
Anarthal (Rubén Pérez)
dd9690921a Reworked the static interface exposition page
close #419
2025-02-19 16:13:07 +01:00
Anarthal (Rubén Pérez)
41a674628f Added quit_connection unit tests and refactored
Quit now correctly marks TLS as terminated, even if it encounters an error
Removed ssl_state

close #444
2025-02-17 18:46:46 +01:00
Anarthal (Rubén Pérez)
b4365f3254 Reworked the dynamic interface exposition page
close #418
2025-02-14 14:03:20 +01:00
Anarthal (Rubén Pérez)
eb4c2af073 Added a section on interfacing sync and async code
Replaces an incorrect sync connection_pool snippet that contained a race
condition.

close #412
2025-02-14 14:03:03 +01:00
Anarthal (Rubén Pérez)
5a3a2f40c9 Reworked the text queries and SQL formatting exposition pages
close #417 
close #424
2025-02-13 21:40:01 +01:00
Anarthal (Rubén Pérez)
cd0ee4ad14 Replaced C++20 feature test macros by Boost.Config's for C++17 headers 2025-02-13 08:03:57 +01:00
Anarthal (Rubén Pérez)
6a24faa7da Reworked the prepared statement exposition page
close #416
2025-02-12 18:17:52 +01:00
Anarthal (Rubén Pérez)
793b678287 Updated file copyrights to 2025 2025-02-11 20:42:41 +01:00
Anarthal (Rubén Pérez)
f5ff37539a Fixed a race condition in per-operation cancellation in connection operations
Now connection/any_connection async operations are cancelled even when
the cancellation signal is emitted after an intermediate operation
completes, but before its intermediate handler gets called.
Restored a connection_id integration test that required this fix.

close #199
2025-02-11 19:15:50 +01:00
Anarthal (Rubén Pérez)
829dbf775c Connections now check for in-progress async operations and fail without UB
connection and any_connection now check whether there is an in-progress
async operation, and fail with client_errc::operation_in_progress if
there is one. This situation no longer triggers undefined behavior.
Refactored the internal sans-io algorithms

close #405
2025-02-05 20:15:54 +01:00
Anarthal (Rubén Pérez)
91cd262c68 Simplified locking in sha256 tests by using GET_LOCK 2025-02-05 17:35:23 +01:00
Anarthal (Rubén Pérez)
bef74828a9 Added any_connection::connection_id
close #408
2025-02-05 15:14:06 +01:00
Anarthal (Rubén Pérez)
1c67537290 connection_pool now resizes correctly in the presence of pending connections
Changed the algorithm that calculates how many connections to create to
correctly take into account the number of pending requests.
This makes the pool resize as expected and avoids potential deadlocks.

close #395
2025-01-06 17:14:32 +01:00
Anarthal (Rubén Pérez)
c343cde1fb Improved discussion and examples
Added a tutorial on UPDATEs, transactions and multi-queries
Added a tutorial on connection_pool
Added a tutorial on error handling
Added examples on INSERTs and DELETEs
Rewrote the discussion page on character sets
Added a discussion page on the templated connection class
Removed superseded examples on timeouts and multi-queries
Updated the coverage build to gcc-14 (gcc-13 was using a non-LTS release
that caused problems)

Contributes to #365 and #366
2024-11-29 17:47:44 +01:00
Anarthal (Rubén Pérez)
f6c119210d Boost 1.87: new discussion and examples (part 1)
Added tutorials 2, 3 and 4
Changed most of the discussion to use any_connection
Added examples on disabling TLS, multi-function operations, multi-queries and transactions
All examples now use any_connection
Automate parts of example qbk generation

Partially addresses #365 and #366
2024-11-05 00:12:27 +01:00
Anarthal (Rubén Pérez)
8b2727f840 with_diagnostics now passes through unknown signatures
This makes asio::as_tuple and asio::redirect_error usable as partial
completion tokens with any_connection and connection_pool.
Fixed a Jamfile issue that caused warnings in dependencies to fail CI builds.
Removed leftover comment in the pipeline example.
2024-11-02 20:10:22 +01:00
Anarthal (Rubén Pérez)
eba723f5a7 connection_pool destructor now cancels async operations
Improved connection_pool docs on thread-safety.

close #370
2024-10-14 13:35:32 +02:00
Anarthal (Rubén Pérez)
6842c2d83d sequence now returns an owning type
Renamed format_sequence_view to format_sequence
format_sequence members are now part of the public API
Moved sequence to a separate header
Added sequence_range_t

close #359
2024-10-11 22:17:17 +02:00
Anarthal (Rubén Pérez)
268aa33a84 Connections now support immediate executors
Immediate completions in connection and any_connection are now correctly
    dispatched to the token's immediate executor using asio::async_immediate
    instead of plain asio::post.
Added a section on executors in the reference docs of async functions in
    connection and any_connection
Disabled TSAN connection_pool_cancel_get_connection for libc++ builds

close #301
2024-10-03 20:19:51 +02:00
Anarthal (Rubén Pérez)
7ef6ff8773 Removed pool executor params
Added pool_params::connection_executor

close #350
2024-10-03 06:28:43 +02:00
Anarthal (Rubén Pérez)
a4a40d8b90 async_get_connection now waits if the pool is not running
close #356
2024-09-30 21:38:30 +02:00
Anarthal (Rubén Pérez)
e39c978514 Removed the global io_context in tests
Now tests are independent of each other
Refactor common utilities for separate compilation
2024-09-28 19:36:43 +02:00
Anarthal (Rubén Pérez)
e72b4906af Removed connection_pool::async_get_connection timeout overloads
Please use asio::cancel_after, instead.
Replaced client_errc::timeout, client_errc::cancelled by
    client_errc::no_connection_available, client_errc::pool_cancelled
async_get_connection no longer uses the last connect error code as failure error code,
    but embeds this info in the output diagnostics

close #349
2024-09-26 08:30:52 +02:00
Anarthal (Rubén Pérez)
a84b774bef Per-operation cancellation for connection_pool
close #197
2024-09-21 21:10:31 +02:00
Anarthal (Rubén Pérez)
0f843cd963 Refactored connection_pool unit tests
Removed IoTraits
Removed mock_timer_service
Simplified connection_pool_impl unit tests
2024-09-16 17:32:41 +02:00
Anarthal (Rubén Pérez)
1f79e5ce3f connection_pool thread-safety is now more robust
Thread-safety is now achieved using pool_params::thread_safe.
Removed pool_executor_params::thread_safe
Unsafe pools now use the standard Asio semantics
Safe pools are now safe even if the handlers' associated executors point
    to a context different from the pool's context

close #268
2024-09-14 13:06:54 +02:00
Anarthal (Rubén Pérez)
95a9aa1068 Added with_diagnostics completion token
Made with_diagnostics(deferred) the default token for any_connection and
connection_pool.
throw_on_error is now marked as legacy.

close #329 
close #296
2024-08-13 10:48:49 +02:00
Anarthal (Rubén Pérez)
36dc47693e Async ops now support cancel_after and similar tokens
All initiations have now an associated executor.

close #330
2024-08-08 18:46:34 +02:00
Anarthal (Rubén Pérez)
a20fc3e5ea Added with_params
close #218
2024-08-01 12:59:56 +02:00
Anarthal (Rubén Pérez)
f76e17c37b Using an unconnected any_connection no longer crashes
Refactored `variant_stream` and added tests

close #230 
close #321
2024-07-29 13:37:01 +02:00
Anarthal (Rubén Pérez)
a8c992dd95 as_netresult completion token for tests
Restructured handshake integration tests
Removed er_connection infrastructure
Reworked network_result
Greatly simplified integration tests
2024-07-23 18:27:30 +02:00
Anarthal (Rubén Pérez)
cf74314c4e Improved tracker_executor
Added the ability to detect the executor call stack and whether we're
running from an initiating function or not.
Integration tests now consistently check these two.
2024-07-15 12:26:47 +02:00
Anarthal (Rubén Pérez)
c3337d20d4 Added a CI build with UNIX sockets disabled
close #196
2024-07-14 21:51:33 +02:00
Anarthal (Rubén Pérez)
a918c6b6b5 Improved server feature detection for integration tests
Introduced BOOST_MYSQL_DISABLED_SERVER_FEATURES env var
Removed BOOST_MYSQL_NO_UNIX_SOCKET_TESTS env var
JSON tests in database_types are now actually run

close #29
2024-07-11 17:36:42 +02:00
Anarthal (Rubén Pérez)
eb4cea7fcb Disabled Naggle's algorithm in any_connection
Fixes a performance issue with pipelines only containing close statement
stages.

close #277
2024-07-02 18:35:03 +02:00
Anarthal (Rubén Pérez)
0944b2af77 Added a max limit to any_connection buffer size
any_connection max buffer size is now 64MB
Renamed any_connection_params::initial_read_buffer_size to initial_buffer_size
Renamed pool_params::initial_read_buffer_size to initial_buffer_size

close #278
2024-06-30 15:49:27 +02:00
Anarthal (Rubén Pérez)
d1f1219e4b Removed the pipeline static interface
close #288
2024-06-26 16:47:27 +02:00
Anarthal (Rubén Pérez)
1ad51fc579 Character set clean-up
character_set::name is now a const char*, since NULL characters are not
   allowed by MySQL
character_set::next_char doesn't need to be noexcept
Removed noexcepts from next_char functions
Internal refactor
2024-06-24 17:10:12 +02:00
Anarthal (Rubén Pérez)
77361353a5 Added formattable_ref
format_context_base::append_value now uses formattable_ref instead of being a template

close #284
2024-06-23 18:35:26 +02:00
Anarthal (Rubén Pérez)
80a86189e9 Support for ranges in client-side SQL formatting
close #280
2024-06-22 11:48:45 +02:00
Anarthal (Rubén Pérez)
759820b470 async_connect now always requires connect_params to be kept alive
This trims down complexity and build times.
asio::ssl::context is now forward-declared in any_connection.
2024-06-20 12:04:13 +02:00
Anarthal (Rubén Pérez)
08abb5d073 Client-side SQL formatting now supports specifiers
Added the 'i' and 'r' specifiers
Removed the identifier class

close #217
2024-06-17 21:53:07 +02:00