Regex search on label index (cypher)

Question

This is similar to the question posed here.

I have a query that works:

match (n:Campus {name:'Georgia Southern University'}) return n;

1 row 38 ms

However, I'm building a search feature where I'd like to be able to have a user type "georgia" and return a list of nodes from the Campus label index whose name is like "Georgia".

This query does not work in neo4j-community-2.0.0 (although it did in -M05):

match (n:Campus) where n.`name` =~ '(?i).*Georgia.*' return n;

0 row 29 ms

1. Is my expression incorrect? Quite possible, knowing my handicap with regexes.
2. Otherwise, is it possible to do a regular expression search on a label index?

Thanks!

Edit: More info, output from the neo4j-shell:

neo4j-sh (?)$ match (n:Campus {name:'Georgia Southern University'}) return n.name;
+-------------------------------+
| n.name                        |
+-------------------------------+
| "Georgia Southern University" |
| "Georgia Southern University" |
+-------------------------------+
2 rows
45 ms
neo4j-sh (?)$ match (n:Campus) where n.`name` =~ '(?i).*Georgia.*' return n;
+---+
| n |
+---+
+---+
0 row
10 ms

Answer 1

Tried your query in 2.0.0-RC1 and it works fine:

CREATE (n:Campus {name:'Georgia Southern University'}) RETURN n
CREATE (n:Campus {name:'lil georgia'}) RETURN n
CREATE (n:Campus {name:'CAP GEORGIA CAP'}) RETURN n
CREATE (n:Campus {name:'East Georgia Tech'}) RETURN n


MATCH (n:Campus) 
    WHERE n.`name` =~ '(?i).*georgia.*'
    RETURN n    

...

Returned 4 rows in 156 ms

Answer 2

Solved, thanks to @cod3monk3y. I was upgrading my database from the neo4j-community-2.0.0-M05 version to the new stable version. The clean database test above led me to believe it was my database. Apparently the upgrade process during startup failed in terms of labels.

If I use the "rm -l" command to remove a label, then use "set" to set the same label again, the search works.

neo4j-sh (0)$  match (n:Campus {name: 'Boise State University'}) return id(n), n.name;
+----------------------------------+
| id(n) | n.name                   |
+----------------------------------+
| 2772  | "Boise State University" |
+----------------------------------+
1 row
77 ms
neo4j-sh (0)$ match (n:Campus) where n.`name` =~ '(?i).*Boise.*' return n;
+---+
| n |
+---+
+---+
0 row
215 ms
neo4j-sh (0)$ cd 2772
neo4j-sh (Boise State University,2772)$ ls
:Campus (plus a lot of other properties)
neo4j-sh (Boise State University,2772)$ rm -l Campus
neo4j-sh (Boise State University,2772)$ set -l Campus
neo4j-sh (Boise State University,2772)$ match (n:Campus) where n.`name` =~ '(?i).*Boise.*' return n.`name`;
+--------------------------+
| n.`name`                 |
+--------------------------+
| "Boise State University" |
+--------------------------+
1 row
72 ms

I used the code below previously to set labels up in the first place (the _handle property is one I set to group nodes before labels came about):

match n where n._handle='Campus' set n:Campus return Id(n), n.name, labels(n) order by Id(n);

I'll just modify it to remove the old labels, then re-set them.