mariadb/mysql-test/suite
Monty ed7534c42c MDEV-20023 Implement Oracle TRUNC() function
It returns the DATETIME data type (which is the closest to Oracle's DATE).

The following Oracle formats are supported:
Truncate to day: DD, DDD,J
Truncate to month: MM,MON,MONTH,RM
Truncate to Year: SYEAR,SYYYY,Y,YEAR,YY,YYY,YYYY

TRUNC(date) is same as TRUNC(date, "DD")

This patch incorporates a fix for:

MDEV-37414 SIGSEGV in Binary_string::c_ptr | Item_func_trunc::get_date

Fixing the problem that the code did not take into
account that args[1] can return SQL NULL.
2025-08-25 11:19:24 +04:00
..
archive
atomic Fix the test: changing charset should be dome when we can not skip the test. 2025-05-09 07:36:15 +02:00
binlog Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
binlog_encryption Merge branch '10.11' into 11.4 2025-07-28 19:40:10 +02:00
client Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
compat MDEV-20023 Implement Oracle TRUNC() function 2025-08-25 11:19:24 +04:00
csv mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
encryption fix tests for --view 2025-08-03 14:59:18 +02:00
engines Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
events MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
federated Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
funcs_1 Merge branch '10.11' into 11.4 2025-07-28 19:40:10 +02:00
funcs_2
galera MDEV-36554: Assertion `is_wsrep() == wsrep_on(mysql_thd)' failed in void trx_t::commit_in_memory(const mtr_t*) 2025-08-04 14:58:18 +02:00
galera_3nodes Merge branch '11.8' into 12.0 2025-07-31 20:55:47 +02:00
galera_3nodes_sr
galera_sr Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
gcol Merge branch '10.11' into 11.4 2025-07-28 19:40:10 +02:00
handler mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
heap
innodb Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
innodb_fts Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
innodb_gis mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
innodb_i_s
innodb_zip Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
jp Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
json Merge branch '11.8' into 12.0 2025-05-22 09:22:55 +02:00
large_tests
maria MDEV-24 Segmented key cache for Aria 2025-06-25 17:59:45 +03:00
mariabackup Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
merge mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
mtr/t
mtr2
multi_source Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
optimizer_unfixed_bugs
parts Merge branch '11.8' into 12.0 2025-07-31 20:55:47 +02:00
perfschema Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
perfschema_stress remove features that were deprecated in 10.5 2025-04-29 16:53:02 +02:00
period Merge branch '11.8' into 12.0 2025-07-31 20:55:47 +02:00
plugins Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
roles Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
rpl Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
s3 Merge branch '11.8' into 12.0 2025-06-18 07:50:39 +02:00
sql_sequence Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
storage_engine mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
stress
sys_vars MDEV-36077: Galera feature: Retry applying writesets at slaves 2025-08-04 14:58:10 +02:00
sysschema Merge branch '11.8' into 12.0 2025-07-31 20:55:47 +02:00
unit
vcol Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
versioning Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00
wsrep Merge branch '12.0' into 12.1 2025-08-03 15:01:09 +02:00