[MDEV-17375] sql_mode=ORACLE: Incompatibility with CAST(number AS CHAR) - Jira

XML

Word

Printable

Oracle removes insignificant fractional digits when converting a number to char:

SQL> select cast(10/10 as char) from dual;

while MariaDB preserves zeros:

MariaDB [test]> select cast(10/10 as char);

+---------------------+

| cast(10/10 as char) |

+---------------------+

| 1.0000              |

+---------------------+

As a result, Oracle returns one row in all these queries:

select 'X' from dual where  1 like 10/10;

select 'X' from dual where 1 like 1.00;

select 'x' from dual where 1.000 like 1.00;

MariaDB returns empty set.

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.