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

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

[4 Oct 2004 10:17] [ name withheld ]

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 Oct 2004 12:47] Hartmut Holzgraefe

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],

[3 Jan 2005 22:20] Jim Winstead

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

[7 Jan 2005 18:42] Paul DuBois

No documentation changes required.