mariadb/mysql-test/suite/compat/oracle/r
Monty b5c93848d8 MDEV-37319 Oracle Compatibility - MONTHS_BETWEEN functions
If one compiles with EXTENDED_MONTHS_BETWEEN MariaDB would take hours,
minutes, seconds and fractional seconds into account when comparing
dates when computing the fractional months.

For example
MONTHS_BETWEEN("1995-02-15 12:00:00", "1995-01-17 12:00:01") would
return "one day less" than if time part would not have been given.
2025-10-03 18:34:23 +03:00
..
anonymous_derived.result MDEV-34679 ER_BAD_FIELD uses non-localizable substrings 2024-10-17 21:37:37 +02:00
binlog_ptr_mysqlbinlog.result MDEV-34504 PURGE BINARY LOGS not working anymore 2024-07-10 18:50:08 +03:00
binlog_stm_ps.result
binlog_stm_sp.result
binlog_stm_sp_package.result
column_compression.result Merge branch '10.5' into 10.6 2024-07-18 16:25:33 +02:00
custom_aggregate_functions.result
empty_string_literal.result Merge 10.5 into 10.6 2024-03-27 15:00:56 +02:00
events.result fix tests for embedded 2022-05-18 01:22:29 +02:00
exception.result
func_add_months.result MDEV-20025: ADD_MONTHS() Oracle function 2021-05-19 22:54:12 +02:00
func_case.result
func_concat.result MDEV-31910 ASAN memcpy-param-overlap upon CONCAT in ORACLE mode 2024-11-06 11:39:50 +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
func_misc.result MDEV-34679 ER_BAD_FIELD uses non-localizable substrings 2024-10-17 21:37:37 +02:00
func_months_between.result MDEV-37319 Oracle Compatibility - MONTHS_BETWEEN functions 2025-10-03 18:34:23 +03: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
func_to_char.result MDEV-36216 TO_CHAR FM format not recognized in SQL_MODE=Oracle 2025-04-16 12:55:49 +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
func_trunc.result MDEV-20023 Implement Oracle TRUNC() function 2025-10-03 18:34:23 +03:00
func_trunc_ucs2.result MDEV-20023 Implement Oracle TRUNC() function 2025-10-03 18:34:23 +03:00
gis-debug.result
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
keywords.result
minus.result MDEV-20021 sql_mode="oracle" does not support MINUS set operator 2021-05-19 22:54:12 +02: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
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 MDEV-31616 Problems with a stored function EMPTY() on upgrade to 10.6. 2024-01-24 09:59:55 +04:00
plugin.result
ps.result MDEV-34679 ER_BAD_FIELD uses non-localizable substrings 2024-10-17 21:37:37 +02: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
sequence.result
sp-anchor-row-type-table.result MDEV-29062 Wrong result set metadata for a mix of INT+ENUM 2022-07-08 15:29:23 +04:00
sp-anonymous.result
sp-code.result
sp-cursor-decl.result
sp-cursor-rowtype.result MDEV-34679 ER_BAD_FIELD uses non-localizable substrings 2024-10-17 21:37:37 +02:00
sp-cursor.result MDEV-36047 Package body variables are not allowed as FETCH targets 2025-02-09 13:56:19 +04:00
sp-expr.result
sp-goto-debug.result
sp-goto.result
sp-inout.result MDEV-33616 Tests failing on macOS 2024-04-24 08:44:24 -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-36047 Package body variables are not allowed as FETCH targets 2025-02-09 13:56:19 +04:00
sp-package-concurrent-dml-db.result
sp-package-concurrent-dml-package.result
sp-package-concurrent-dml-trigger.result
sp-package-concurrent-dml-view.result
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 Removed "<select expression> INTO <destination>" deprication. 2023-02-03 11:57:50 +03:00
sp-package-mdl.result
sp-package-mysqldump.result Merge branch '11.2' into 11.4 2024-08-04 17:27:48 +02:00
sp-package-security.result
sp-package.result MDEV-33428 Error messages ER_PACKAGE_ROUTINE_* are not good enough 2024-02-08 16:01:20 +04:00
sp-param.result Merge 10.6 into 10.7 2022-09-21 09:33:07 +03:00
sp-row.result Removed "<select expression> INTO <destination>" deprication. 2023-02-03 11:57:50 +03:00
sp-security.result MDEV-28548: ER_TABLEACCESS_DENIED_ERROR is missing information about DB 2022-09-30 08:48:57 +02:00
sp-sys_refcursor-alias.result MDEV-20034 Add support for the pre-defined weak SYS_REFCURSOR 2025-10-03 18:34:23 +03:00
sp-sys_refcursor-func_hybrid.result MDEV-20034 Add support for the pre-defined weak SYS_REFCURSOR 2025-10-03 18:34:23 +03:00
sp-sys_refcursor.result MDEV-20034 Add support for the pre-defined weak SYS_REFCURSOR 2025-10-03 18:34:23 +03:00
sp.result Merge 10.9 into 10.10 2022-09-21 10:59:56 +03:00
statement-expr.result
table_value_constr.result Merge branch '10.11' into 11.2 2024-10-29 16:42:46 +01:00
trigger.result
truncate.result
type_blob.result
type_clob.result
type_date.result Merge remote-tracking branch 'origin/10.4' into 10.5 2022-09-14 16:24:51 +04:00
type_number.result
type_raw.result
type_varchar.result
type_varchar2.result
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 Removed "<select expression> INTO <destination>" deprication. 2023-02-03 11:57:50 +03:00
variables.result
vcol.result
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
win.result