Bug #10231 Problem creating fulltext index on a view
Submitted: 28 Apr 2005 8:56 Modified: 17 Dec 2010 13:21
Reporter: Gerard McGarry Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[28 Apr 2005 8:56] Gerard McGarry
I cannot find any way to create a fulltext index against a view in MySQL. I have a support table and an actions table which we log IT Support calls to internally, but I'd like to be able to perform a fulltext search against both tables.

How to repeat:
Can't repeat
[14 Dec 2009 3:16] Trent Lloyd
It is not possible to create an index on a VIEW.  Indexes can only be created on real tables.