You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
MySQL doesn't supports ==. Sometimes after not wring SQL requests for long, I'm using == instead of =. For example like this:
CREATE TABLE TestTable (
id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
);
testRequest:
SELECT * FROM TestTable WHERE id == ?;
Neither in the IDE, nor during the build, does the error show up, and I get the following crash:
org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT * FROM TESTTABLE WHERE ID[*] == ?"; SQL statement:
SELECT * FROM TestTable WHERE id == ? [42000-200]
Stacktrace
at org.h2.message.DbException.getJdbcSQLException(DbException.java:453)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.message.DbException.getSyntaxError(DbException.java:229)
at org.h2.command.Parser.getSyntaxError(Parser.java:1051)
at org.h2.command.Parser.getSpecialType2(Parser.java:5663)
at org.h2.command.Parser.read(Parser.java:5125)
at org.h2.command.Parser.readTerm(Parser.java:4303)
at org.h2.command.Parser.readFactor(Parser.java:3343)
at org.h2.command.Parser.readSum(Parser.java:3330)
at org.h2.command.Parser.readConcat(Parser.java:3305)
at org.h2.command.Parser.readCondition(Parser.java:3108)
at org.h2.command.Parser.readExpressionWithGlobalConditions(Parser.java:3046)
at org.h2.command.Parser.parseSelect(Parser.java:2962)
at org.h2.command.Parser.parseQuerySub(Parser.java:2817)
at org.h2.command.Parser.parseSelectUnion(Parser.java:2649)
at org.h2.command.Parser.parseQuery(Parser.java:2620)
at org.h2.command.Parser.parsePrepared(Parser.java:868)
at org.h2.command.Parser.parse(Parser.java:843)
at org.h2.command.Parser.parse(Parser.java:819)
at org.h2.command.Parser.prepareCommand(Parser.java:738)
at org.h2.engine.Session.prepareLocal(Session.java:657)
at org.h2.engine.Session.prepareCommand(Session.java:595)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352)
at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337)
at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
at com.squareup.sqldelight.sqlite.driver.JdbcDriver.executeQuery(JdbcDriver.kt:124)
at com.well.modules.db.server.serverDb.AvailabilitiesQueriesImpl$GetByOwnerIdQueryQuery.execute(DatabaseImpl.kt:1398)
at com.squareup.sqldelight.Query.executeAsList(Query.kt:134)
at com.well.modules.db.server.QueryExtensionsKt.getByOwnerId(queryExtensions.kt:75)
The text was updated successfully, but these errors were encountered:
SQLDelight Version
1.6.5
Application Operating System
JVM
Describe the Bug
MySQL doesn't supports
==
. Sometimes after not wring SQL requests for long, I'm using==
instead of=
. For example like this:Neither in the IDE, nor during the build, does the error show up, and I get the following crash:
Stacktrace
The text was updated successfully, but these errors were encountered: