René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"SQL: Error when comparing two empty strings","articleBody":"### ArcadeDB Version:\r\n`ArcadeDB Server v23.10.1 (build 47e2c315678e3a503e5c9b4e615186bed925ac7d/1698807954815/main)`\r\n### OS and JDK Version:\r\n`Running on Linux 6.4.16-linuxkit - OpenJDK 64-Bit Server VM 11.0.21 (Temurin-11.0.21+9)`\r\n\r\nIn `23.10.1` (via docker hub container) the following error appears when comparing an empty string against an empty string.\r\nParticularly, this happens only if both sides in a comparison are the empty string.\r\nHowever, this error is strangely not happening with the current repo head.\r\n\r\nMaybe the case of two empty string needs to be handled here https://github.com/ArcadeData/arcadedb/blob/main/engine/src/main/java/com/arcadedb/serializer/BinaryComparator.java#L403 ?\r\n\r\n### Expected behavior\r\nCorrect string comparisons with empty strings.\r\n\r\n### Actual behavior\r\n\r\n\u003cdetails\u003e \u003csummary\u003e\u003ccode\u003eInternal error Index -1 out of bounds for length 0\u003c/code\u003e\u003c/summary\u003e\r\n\r\n```\r\nError on command execution (PostCommandHandler)\r\njava.lang.ArrayIndexOutOfBoundsException: Index -1 out of bounds for length 0\r\n       at com.arcadedb.serializer.BinaryComparator.equalsBytes(BinaryComparator.java:410)\r\n       at com.arcadedb.serializer.BinaryComparator.equalsString(BinaryComparator.java:399)\r\n       at com.arcadedb.serializer.BinaryComparator.equals(BinaryComparator.java:382)\r\n       at com.arcadedb.query.sql.executor.QueryOperatorEquals.equals(QueryOperatorEquals.java:39)\r\n       at com.arcadedb.query.sql.parser.EqualsCompareOperator.execute(EqualsCompareOperator.java:35)\r\n       at com.arcadedb.query.sql.parser.BinaryCondition.evaluate(BinaryCondition.java:49)\r\n       at com.arcadedb.query.sql.parser.NotBlock.evaluate(NotBlock.java:56)\r\n       at com.arcadedb.query.sql.parser.AndBlock.evaluate(AndBlock.java:70)\r\n       at com.arcadedb.query.sql.parser.OrBlock.evaluate(OrBlock.java:58)\r\n       at com.arcadedb.query.sql.parser.WhereClause.matchesFilters(WhereClause.java:56)\r\n       at com.arcadedb.query.sql.parser.Expression.execute(Expression.java:89)\r\n       at com.arcadedb.query.sql.parser.ProjectionItem.execute(ProjectionItem.java:137)\r\n       at com.arcadedb.query.sql.parser.Projection.calculateSingle(Projection.java:129)\r\n       at com.arcadedb.query.sql.executor.ProjectionCalculationStep.calculateProjections(ProjectionCalculationStep.java:66)\r\n       at com.arcadedb.query.sql.executor.ProjectionCalculationStep$1.next(ProjectionCalculationStep.java:51)\r\n       at com.arcadedb.query.sql.parser.LocalResultSet.next(LocalResultSet.java:72)\r\n       at com.arcadedb.server.http.handler.AbstractQueryHandler.serializeResultSet(AbstractQueryHandler.java:98)\r\n       at com.arcadedb.server.http.handler.PostCommandHandler.execute(PostCommandHandler.java:100)\r\n       at com.arcadedb.server.http.handler.DatabaseAbstractHandler.execute(DatabaseAbstractHandler.java:99)\r\n       at com.arcadedb.server.http.handler.AbstractServerHttpHandler.handleRequest(AbstractServerHttpHandler.java:126)\r\n       at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)\r\n       at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)\r\n       at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)\r\n       at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)\r\n       at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)\r\n       at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)\r\n       at java.base/java.lang.Thread.run(Thread.java:829)\r\n\r\n```\r\n\u003c/details\u003e\r\n\r\n### Steps to reproduce\r\n\r\nMinimal example:\r\n```\r\nSELECT ('' != '')\r\n```\r\n\r\nGeneral example:\r\n```\r\nCREATE DOCUMENT TYPE doc;\r\nCREATE PROPERTY doc.str;\r\nINSERT INTO doc SET str = '';\r\nSELECT str FROM doc WHERE str != ''\r\n```\r\n","author":{"url":"https://github.com/gramian","@type":"Person","name":"gramian"},"datePublished":"2023-11-02T19:13:00.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/1297/arcadedb/issues/1297"}