MySQL select statement using JDBC
Brought to you by:
jhereth,
peterbecker
For a attribute scale using two attributes
hp < 10
hp < 20
The SQL generated and submitted to MySQL via JDBC seems
to include a SELECT (*) which MySQL doesn't like.
Submitted query for part of the lattice
select () FROM aom WHERE ( NOT (hp < 10) AND NOT (hp
<20) );
ERROR 1064: You have an error in your SQL syntax near
') FROM aom WHERE ( NOT (hp < 10) AND NOT (hp <20)
)' at line 1
But without the (*) part and just * MySQL runs the
query fine.
mysql> select * FROM aom WHERE ( NOT (hp < 10) AND
NOT (hp <20) );
+---------... data follows ...