[MDEV-24701] T-SQL support for string function REPLICATE alias for REPEAT in sql_mode MSSQL Created: 2021-01-26  Updated: 2021-01-26

Status: Open
Project: MariaDB Server
Component/s: Parser
Fix Version/s: None

Type: Task Priority: Trivial
Reporter: VAROQUI Stephane Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Compatibility


 Description   

https://docs.microsoft.com/en-us/sql/t-sql/functions/replace-transact-sql?view=sql-server-ver15

MariaDB [test]> set sql_mode ='MSSQL';
Query OK, 0 rows affected (0.001 sec)
MariaDB [test]> select REPLICATE('svar',3);
ERROR 1305 (42000): FUNCTION test.REPLICATE does not exist
MariaDB [test]> select REPEAT('svar',3);
-----------------

REPEAT('aaa',3)

-----------------

svarsvarsvar

-----------------
1 row in set (0.001 sec)
Generated at Thu Feb 08 09:32:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.