Ticket #3654 (new bug)

Opened 13 months ago

Last modified 13 months ago

The CQL format does not support wildcard in value (for LIKE operator).

Reported by: scaddenp Owned by: tschaub
Priority: critical Milestone: 2.13 Release
Component: Format.CQL Version: 2.11
Keywords: CQL Parsing Cc:
State:

Description

An expression like: TRANS_NAME LIKE 'OTS%' fails because % is not a valid character.

It should be noted that this format reader supports only a limited syntax compared to what server CQL expressions are supported. (eg TRANS_NAME NOT LIKE 'OTS%' or TRANS_NAME !NOT LIKE 'OTS%' are valid on the server but not to CQL.js which requires NOT TRANS_NAME LIKE 'OTS%'

Attachments

cql.patch Download (477 bytes) - added by scaddenp 13 months ago.
Patch to allow % as a valid character in VALUE
CQL.html Download (11.5 KB) - added by scaddenp 13 months ago.
Updated test

Change History

Changed 13 months ago by scaddenp

Patch to allow % as a valid character in VALUE

Changed 13 months ago by scaddenp

Updated test

Changed 13 months ago by scaddenp

First attached test had an error. Replaced with a new one.

Note: See TracTickets for help on using tickets.