| Ticket Hash: | 7c0e06b162d5cc3ab95feae09ba81e61e86942f7 | |||
| Title: | NATURAL JOIN on virtual table results in "parse error in rank function" | |||
| Status: | Closed | Type: | Code_Defect | |
| Severity: | Critical | Priority: | Low | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-12-30 14:32:38 | |||
| Version Found In: | 3.30 | |||
| User Comments: | ||||
mrigger added on 2019-12-30 10:42:17:
(text/x-fossil-wiki)
The following test case results in an unexpected error "parse error in rank function:":
<pre>
CREATE VIRTUAL TABLE vt0 USING fts5(c0, c1);
CREATE VIRTUAL TABLE vt1 USING fts5(c0);
INSERT INTO vt1(c0) VALUES ('');
SELECT * FROM vt1 NATURAL JOIN vt0 WHERE vt0.c1 MATCH 'a'; -- parse error in rank function:
</pre>
| ||||