mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-04-14 03:05:37 +02:00
Code Issues Projects Releases Packages Wiki Activity Actions1
mariadb/mysql-test/suite/compat/oracle/r
History
Nikita Malyavin e33064e0fc MDEV-27769 Assertion failed in Field::ptr_in_record upon UPDATE in ORACLE mode 
table->move_fields has some limitations:
1. It cannot be used in cascade
2. It should always have a restoring pair

In this case, an error has occurred before the field ptr was restored, returning
from the function in that state. Even in case of an error, the table can be
reused afterwards and table->field[i]->ptr is not reset in between.

The solution is to restore the field pointers immanently whenever they've been
deviated.

Also add an assertion that ensures that table fields are restored after the use
in close_thread_tables.
2025-01-26 16:15:46 +01:00
..
binlog_ptr_mysqlbinlog.result MDEV-23108: Point in time recovery of binary log fails when sql_mode=ORACLE 2020-07-22 11:34:50 +05:30
binlog_stm_ps.result MDEV-16095 Oracle-style placeholder inside GROUP BY..WITH ROLLUP breaks replication 2018-05-06 16:10:49 +04:00
binlog_stm_sp.result MDEV-16020 SP variables inside GROUP BY..WITH ROLLUP break replication 2018-04-27 22:11:18 +04:00
binlog_stm_sp_package.result MDEV-11952 Oracle-style packages: stage#5 2018-02-27 15:26:51 +04:00
column_compression.result MDEV-34318 mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server 2024-07-17 21:25:40 +02:00
custom_aggregate_functions.result MDEV-18813 PROCEDURE and anonymous blocks silently ignore FETCH GROUP NEXT ROW 2019-03-07 18:48:15 +04:00
empty_string_literal.result MDEV-33460 select '123' 'x'; unexpected result 2024-03-27 15:51:26 +11:00
events.result fix tests for embedded 2022-05-18 01:22:29 +02:00
exception.result Merge 10.2 into 10.3 2020-05-25 19:41:58 +03:00
func_case.result MDEV-10342 Providing compatibility for basic SQL built-in functions 2017-04-05 15:02:48 +04:00
func_concat.result MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE 2023-11-08 15:01:20 +04:00
func_decode.result MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE 2023-11-08 15:01:20 +04:00
func_length.result MDEV-12783 : sql_mode=ORACLE: Functions LENGTH() and LENGTHB() 2017-05-18 11:43:24 +02:00
func_misc.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
func_pad.result MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE 2023-11-08 15:01:20 +04:00
func_qualified.result MDEV-29095 REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode 2024-01-24 10:59:17 +04:00
func_regexp_replace.result MDEV-29095 REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode 2024-01-24 10:59:17 +04:00
func_replace.result MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE 2023-11-08 15:01:20 +04:00
func_substr.result MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE 2023-11-08 15:01:20 +04:00
func_time.result MDEV-16152 Expressions with INTERVAL return bad results in some cases 2018-05-14 11:36:22 +04:00
func_trim.result MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE 2023-11-08 15:01:20 +04:00
gis-debug.result MDEV-20009 Add CAST(expr AS pluggable_type) 2019-07-10 11:55:16 +04:00
gis.result MDEV-33803 Error 4162 "Operator does not exists" is incorrectly-worded 2024-04-03 10:03:02 +11:00
information_schema_parameters.result MDEV-18092 Query with the table I_S.PARAMETERS stop working after a package is created 2019-04-18 08:34:08 +04:00
keywords.result MDEV-17363 - Compressed columns cannot be restored from dump 2019-06-18 07:48:08 +04:00
misc.result An additional patch for MDEV-27690 Crash on CHARACTER SET csname COLLATE DEFAULT in column definition 2022-04-14 12:22:28 +04:00
mysqldump_restore.result MDEV-17363 - Compressed columns cannot be restored from dump 2019-06-18 07:48:08 +04:00
mysqldump_restore_func_qualified.result MDEV-29968 Functions in default values in tables with some character sets break SHOW CREATE (and mysqldump) 2025-01-17 15:39:55 +04:00
parser.result Merge 10.4 into 10.5 2020-09-04 18:44:44 +03:00
plugin.result MDEV-18767 Port "MDEV-16294: INSTALL PLUGIN IF NOT EXISTS / UNINSTALL PLUGIN IF EXISTS" to sql_yacc_ora.yy 2019-02-28 07:17:47 +04:00
ps.result MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE 2023-11-08 15:01:20 +04:00
rpl_mariadb_date.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
rpl_sp_package.result MDEV-30662 SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION 2023-07-14 13:26:26 +04:00
rpl_sp_package_variables.result MDEV-11952 Oracle-style packages: stage#5 2018-02-27 15:26:51 +04:00
sequence.result MDEV-12533 sql_mode=ORACLE: Add support for database qualified sequence names in NEXTVAL and CURRVAL 2017-04-20 08:30:23 +04:00
sp-anchor-row-type-table.result MDEV-15960 Wrong data type on CREATE..SELECT char_or_enum_or_text_spvar 2018-04-22 15:52:46 +04:00
sp-anonymous.result MDEV-10655 Anonymous blocks 2017-04-05 15:02:55 +04:00
sp-code.result MDEV-19639 + MDEV-19640 fix + preparatory changes for WL#4179 2019-06-04 06:21:22 +04:00
sp-cursor-decl.result Merge 10.2 into 10.3 2020-04-15 09:56:03 +03:00
sp-cursor-rowtype.result MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE 2023-11-08 15:01:20 +04:00
sp-cursor.result Merge 10.2 into 10.3 2020-04-15 09:56:03 +03:00
sp-expr.result Adding more tests for IN/EXIST subqueries for better coverage 2018-04-20 23:15:27 +04:00
sp-goto-debug.result MDEV-20667 Server crash on pop_cursor 2019-12-12 16:25:16 +04:00
sp-goto.result MDEV-20667 Server crash on pop_cursor 2019-12-12 16:25:16 +04:00
sp-memory-leak.result MDEV-26186 280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode 2023-07-18 12:19:16 +04:00
sp-package-code.result MDEV-11952 Oracle-style packages: stage#5 2018-02-27 15:26:51 +04:00
sp-package-concurrent-dml-db.result MDEV-11952 Oracle-style packages: stage#5 2018-02-27 15:26:51 +04:00
sp-package-concurrent-dml-package.result MDEV-11952 Oracle-style packages: stage#5 2018-02-27 15:26:51 +04:00
sp-package-concurrent-dml-trigger.result MDEV-11952 Oracle-style packages: stage#5 2018-02-27 15:26:51 +04:00
sp-package-concurrent-dml-view.result MDEV-11952 Oracle-style packages: stage#5 2018-02-27 15:26:51 +04:00
sp-package-i_s.result MDEV-30662 SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION 2023-07-14 13:26:26 +04:00
sp-package-innodb.result MDEV-11953: support of brackets in UNION/EXCEPT/INTERSECT operations 2018-07-04 19:13:55 +02:00
sp-package-mdl.result Added new MDL_BACKUP locks for all backup stages 2018-12-09 22:12:27 +02:00
sp-package-mysqldump.result also protect the /*!999999 sandbox comment 2024-07-17 21:25:40 +02:00
sp-package-security.result MDEV-20076: SHOW GRANTS does not quote role names properly 2020-02-05 17:22:26 +01:00
sp-package.result MDEV-30662 SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION 2023-07-14 13:26:26 +04:00
sp-param.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
sp-row.result Merge remote-tracking branch 'origin/10.4' into 10.5 2022-09-14 16:24:51 +04:00
sp-security.result MDEV-28548: ER_TABLEACCESS_DENIED_ERROR is missing information about DB 2022-09-30 08:48:57 +02:00
sp.result Merge remote-tracking branch 'origin/10.4' into 10.5 2022-09-14 16:24:51 +04:00
statement-expr.result MDEV-20634 Report disallowed subquery errors as such (instead of parse error) 2019-09-20 10:36:20 +04:00
table_value_constr.result Merge 10.4 into 10.5 2022-04-21 15:33:50 +03:00
trigger.result MDEV-15620 Crash when using "SET @@NEW.a=expr" inside a trigger 2018-03-27 07:59:57 +04:00
truncate.result MDEV-10588 sql_mode=ORACLE: TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ] 2017-04-05 15:02:54 +04:00
type_blob.result MDEV-20263 sql_mode=ORACLE: BLOB(65535) should not translate to LONGBLOB 2019-08-06 18:02:03 +04:00
type_clob.result MDEV-10343 Providing compatibility for basic SQL data types 2017-04-05 15:02:38 +04:00
type_date.result Merge remote-tracking branch 'origin/10.4' into 10.5 2022-09-14 16:24:51 +04:00
type_number.result MDEV-10343 Providing compatibility for basic SQL data types 2017-04-05 15:02:38 +04:00
type_raw.result MDEV-10343 Providing compatibility for basic SQL data types 2017-04-05 15:02:38 +04:00
type_varchar.result MDEV-11275 sql_mode=ORACLE: CAST(..AS VARCHAR(N)) 2017-04-05 15:02:54 +04:00
type_varchar2.result MDEV-11275 sql_mode=ORACLE: CAST(..AS VARCHAR(N)) 2017-04-05 15:02:54 +04:00
update.result MDEV-27769 Assertion failed in Field::ptr_in_record upon UPDATE in ORACLE mode 2025-01-26 16:15:46 +01:00
update_innodb.result MDEV-19535 sql_mode=ORACLE: 'SELECT INTO @var FOR UPDATE' does not lock the table 2019-05-21 14:22:49 +04:00
variables.result A fix for MDEV-10411 Providing compatibility for basic PL/SQL constructs (Part 6: Assignment operator) 2017-04-05 15:02:52 +04:00
vcol.result MDEV-13500 sql_mode=ORACLE: can't create a virtual column with function MOD 2017-08-14 11:12:17 +04:00
vcol_innodb.result MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE 2023-11-08 15:01:20 +04:00
versioning.result MDEV-17959 Assertion `opt_bootstrap || mysql_parse_status || thd->lex->select_stack_top == 0' failed in parse_sql upon DELETE HISTORY under ORACLE mode 2018-12-27 10:32:33 +04:00
win.result Adding "SET sql_mode=ORACLE" forgotten in fdcc95143d 2018-05-18 06:51:21 +04:00