mariadb/mysql-test/suite/versioning/r
Aleksey Midenkov f1f9284181 MDEV-34046 Parameterized PS converts error to warning, causes
replication problems

DELETE HISTORY did not process parameterized PS properly as the
history expression was checked on prepare stage when the parameters
was not yet substituted. In that case check_units() succeeded as there
is no invalid type: Item_param has type_handler_null which is
inherited from string type and this is valid type for history
expression. The warning was thrown when the expression was evaluated
for comparison on delete execution (when the parameter was already
substituted).

The fix postpones check_units() until the first PS execution. We have
to postpone where conditions processing until the first execution and
update select_lex.where on every execution as it is reset to the state
after prepare.
2025-06-12 14:52:00 +03:00
..
alter.result Merge 10.4 into 10.5 2024-02-13 14:25:21 +02:00
autoinc.result MDEV-22562 Assertion `next_insert_id == 0' upon UPDATE on system-versioned table 2021-03-31 21:25:36 +03:00
binlog.result Merge 10.10 into 10.11 2023-03-29 16:53:37 +03:00
commit_id.result
create.result MDEV-29833 CREATE ... SELECT system_versioned_table causes invalid defaults 2022-10-26 15:30:38 +02:00
cte.result MDEV-4750 follow-up: Reduce disabling innodb_stats_persistent 2021-08-31 13:55:02 +03:00
data.result Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
debug.result Merge 10.8 into 10.9 2023-01-10 14:50:58 +02:00
delete.result MDEV-25644 UPDATE not working properly on transaction precise system versioned table 2023-07-20 18:22:31 +03:00
delete_history.result MDEV-34046 Parameterized PS converts error to warning, causes 2025-06-12 14:52:00 +03:00
derived.result MDEV-23779 Error upon querying the view, that selecting from versioned table with partitions 2020-10-20 10:49:54 +03:00
foreign.result Merge 10.4 into 10.5 2023-01-13 10:18:30 +02:00
insert.result Merge branch '10.6' into 10.11 2024-10-29 15:24:38 +01:00
insert2.result
misc.result Merge branch '10.10' into 10.11 2022-11-02 13:08:01 +01:00
not_embedded.result MDEV-5215 prerequisite: remove test and test_* database hacks in the test suite 2022-11-01 16:33:00 +01:00
online.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
optimized.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
partition,heap.rdiff Merge branch '10.6' into 10.11 2024-07-22 15:14:50 +02:00
partition.result MDEV-33370 Assertion `!is_set() || (m_status == DA_OK_BULK && 2025-06-03 11:27:45 +03:00
replace.result MDEV-35343 unexpected replace behaviour when long unique index on 2025-01-14 18:56:13 +03:00
rpl.result Merge branch '10.6' into 10.11 2024-10-29 15:24:38 +01:00
rpl_mix.result Merge 10.8 into 10.9 2022-09-21 10:07:09 +03:00
rpl_row.result Merge branch '10.6' into 10.11 2024-10-29 15:24:38 +01:00
rpl_stmt.result Merge 10.8 into 10.9 2022-09-21 10:07:09 +03:00
select,trx_id.rdiff Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
select.result Merge branch '10.5' into 10.6 2023-12-17 11:20:43 +01:00
select2,trx_id.rdiff Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
select2.result Merge 10.4 into 10.5 2020-05-31 10:28:59 +03:00
simple.result MDEV-28632 Change default of explicit_defaults_for_timestamp to ON 2022-08-10 15:03:22 +02:00
sysvars.result Merge branch '10.3' into 10.4 2021-07-31 22:59:58 +02:00
trx_id.result Merge 10.5 into 10.6 2022-09-20 16:53:20 +03:00
update,trx_id.rdiff MDEV-25644 UPDATE not working properly on transaction precise system versioned table 2023-07-20 18:22:31 +03:00
update-big.result MDEV-17554 Auto-create new partition for system versioned tables with history partitioned by INTERVAL/LIMIT 2022-05-06 15:11:02 +03:00
update.result MDEV-34679 ER_BAD_FIELD uses non-localizable substrings 2024-10-17 21:37:37 +02:00
view.result MDEV-23779 Error upon querying the view, that selecting from versioned table with partitions 2020-10-20 10:49:54 +03:00