search

darrachequesne / spring-data-jpa-datatables

Spring Data JPA extension to work with the great jQuery plugin DataTables (https://datatables.net/)
Apache License 2.0
447 stars 173 forks source link

Searching with "+" throws SQLException #54

Closed maheshrpm closed 7 years ago

maheshrpm commented 7 years ago

Searching with column value only plus "+" throws SQLException. Query formed as "in ()".

darrachequesne commented 7 years ago

Could you please provide a failing test case? Which version are you using? Which dbms?

maheshrpm commented 7 years ago

Column level searching with only "+" character from UI. Version: 4.0. DBMS: Postgresql: 9.2.5

DataTablesInput(draw=2, start=0, length=10, search=Search(value=, regex=false), order=[ Order(column=0, dir=asc) ], columns=[ Column(data=username, name=, searchable=true, orderable=true, search=Search(value=+, regex=false)), Column(data=name, name=, searchable=true, orderable=true, search=Search(value=, regex=false)), Column(data=, name=, searchable=true, orderable=false, search=Search(value=, regex=false)) ])