Bug #5875 crash-me uses 'matcjhes' instead of 'matches'

Submitted:	4 Oct 2004 10:17	Modified:	7 Jan 2005 18:42
Reporter:	[ name withheld ]	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Websites: MySQL.com	Severity:	S3 (Non-critical)
Version:	perhaps all	OS:	Any (all)
Assigned to:	Jim Winstead	CPU Architecture:	Any

Description:
i just compared mysql and informix (which i liked a lot and supports MATCHES) and found that the keyword is typed wrong:

func_where_matches:

DB > select a from crash_me where b matcjhes 'a*'

How to repeat:
compare any db and look at 'Functions in WHERE' - Function MATCHES

Suggested fix:
delete the 'j' to get 'matches'

4.0-bk > grepfind -in matcjh
./sql-bench/limits/mysql.cfg:1723:   ###<select a from crash_me where b matcjhes 'a*'
./sql-bench/limits/mysql.cfg:1724:   ###> execute failed:You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'matcjhes 'a*'' at line 1
./sql-bench/crash-me.sh:1042: ["MATCHES","matches","b matcjhes 'a*'",1,0],

The patch fixes typo in crash-me, the tests will need to be re-run for the website to be updated.

No documentation changes required.

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.