These queries don't run in the repository of the Cassandra SpringBoot App:
@Query("SELECT * FROM activities2 WHERE viewer_id='?0'")
Iterable<Activity> findByApp_Id(String appId);
@Query("SELECT * FROM activities2 WHERE viewer_id=''?0''")
Iterable<Activity> findByApp_Id(String appId);
@Query("SELECT * FROM activities2 WHERE viewer_id='''?0'''")
Iterable<Activity> findByApp_Id(String appId);
@Query("SELECT * FROM activities2 WHERE viewer_id=\'?0\'")
Iterable<Activity> findByApp_Id(String appId);
BUT,
this does:
@Query("SELECT * FROM activities2 WHERE viewer_id='v1'")
Iterable<Activity> findByApp_Id(String appId);
It seems that spring doesn't escape the query properly. How can I solve this ?