[FRG-220] Java calc allows '.' as single-character match in SIMILAR TO

[dynamobi-build]

[reporter="jvs", created="Tue, 10 Oct 2006 10:47:23 -0500 (GMT-05:00)"] Should treat this as a normal character since SQL standard uses '_' for this purpose instead. Fennel calc is already strict here.

[dynamobi-build]

[author="jvs", created="Thu, 8 Nov 2007 18:53:00 -0500 (GMT-05:00)"] Special character classes such as [:DIGIT:] don't seem to be working correctly:

0: jdbc:luciddb:> values '1' similar to '[:DIGIT:]';
+---------+
| EXPR$0 |
+---------+
| false |
+---------+
1 row selected (1.046 seconds)
0: jdbc:luciddb:> values '1' similar to '[:digit:]';
+---------+
| EXPR$0 |
+---------+
| false |
+---------+
1 row selected (0.148 seconds)
0: jdbc:luciddb:> values 'a' similar to '[:ALPHA:]';
+---------+
| EXPR$0 |
+---------+
| false |
+---------+
1 row selected (0.145 seconds)
0: jdbc:luciddb:> values 'a' similar to '[:alpha:]';
+---------+
| EXPR$0 |
+---------+
| true |
+---------+
1 row selected (0.13 seconds)
0: jdbc:luciddb:> values 'a' similar to '[:upper:]';
+---------+
| EXPR$0 |
+---------+
| false |
+---------+
1 row selected (0.148 seconds)
0: jdbc:luciddb:> values 'a' similar to '[:lower:]';
+---------+
| EXPR$0 |
+---------+
| false |
+---------+

[dynamobi-build]

[author="jvs", created="Thu, 29 Nov 2007 02:23:11 -0500 (GMT-05:00)"] I was confused; correct syntax needs two brackets.

0: jdbc:luciddb:> values '12' similar to '[[:DIGIT:]]+';
+---------+
| EXPR$0 |
+---------+
| true |
+---------+