| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 31 Dec 2025 07:51:19 GMT
content-type: text/html; charset=utf-8
cache-control: max-age=0, private, must-revalidate
content-security-policy: default-src 'none'; base-uri 'self'; child-src github.githubassets.com github.com/assets-cdn/worker/ github.com/assets/ gist.github.com/assets-cdn/worker/; connect-src 'self' uploads.github.com www.githubstatus.com collector.github.com raw.githubusercontent.com api.github.com github-cloud.s3.amazonaws.com github-production-repository-file-5c1aeb.s3.amazonaws.com github-production-upload-manifest-file-7fdce7.s3.amazonaws.com github-production-user-asset-6210df.s3.amazonaws.com *.rel.tunnels.api.visualstudio.com wss://*.rel.tunnels.api.visualstudio.com github.githubassets.com objects-origin.githubusercontent.com copilot-proxy.githubusercontent.com proxy.individual.githubcopilot.com proxy.business.githubcopilot.com proxy.enterprise.githubcopilot.com *.actions.githubusercontent.com wss://*.actions.githubusercontent.com productionresultssa0.blob.core.windows.net/ productionresultssa1.blob.core.windows.net/ productionresultssa2.blob.core.windows.net/ productionresultssa3.blob.core.windows.net/ productionresultssa4.blob.core.windows.net/ productionresultssa5.blob.core.windows.net/ productionresultssa6.blob.core.windows.net/ productionresultssa7.blob.core.windows.net/ productionresultssa8.blob.core.windows.net/ productionresultssa9.blob.core.windows.net/ productionresultssa10.blob.core.windows.net/ productionresultssa11.blob.core.windows.net/ productionresultssa12.blob.core.windows.net/ productionresultssa13.blob.core.windows.net/ productionresultssa14.blob.core.windows.net/ productionresultssa15.blob.core.windows.net/ productionresultssa16.blob.core.windows.net/ productionresultssa17.blob.core.windows.net/ productionresultssa18.blob.core.windows.net/ productionresultssa19.blob.core.windows.net/ github-production-repository-image-32fea6.s3.amazonaws.com github-production-release-asset-2e65be.s3.amazonaws.com insights.github.com wss://alive.github.com wss://alive-staging.github.com api.githubcopilot.com api.individual.githubcopilot.com api.business.githubcopilot.com api.enterprise.githubcopilot.com; font-src github.githubassets.com; form-action 'self' github.com gist.github.com copilot-workspace.githubnext.com objects-origin.githubusercontent.com; frame-ancestors 'none'; frame-src viewscreen.githubusercontent.com notebooks.githubusercontent.com; img-src 'self' data: blob: github.githubassets.com media.githubusercontent.com camo.githubusercontent.com identicons.github.com avatars.githubusercontent.com private-avatars.githubusercontent.com github-cloud.s3.amazonaws.com objects.githubusercontent.com release-assets.githubusercontent.com secured-user-images.githubusercontent.com/ user-images.githubusercontent.com/ private-user-images.githubusercontent.com opengraph.githubassets.com marketplace-screenshots.githubusercontent.com/ copilotprodattachments.blob.core.windows.net/github-production-copilot-attachments/ github-production-user-asset-6210df.s3.amazonaws.com customer-stories-feed.github.com spotlights-feed.github.com objects-origin.githubusercontent.com *.githubusercontent.com; manifest-src 'self'; media-src github.com user-images.githubusercontent.com/ secured-user-images.githubusercontent.com/ private-user-images.githubusercontent.com github-production-user-asset-6210df.s3.amazonaws.com gist.github.com github.githubassets.com; script-src github.githubassets.com; style-src 'unsafe-inline' github.githubassets.com; upgrade-insecure-requests; worker-src github.githubassets.com github.com/assets-cdn/worker/ github.com/assets/ gist.github.com/assets-cdn/worker/
link: ; rel=preload; as=fetch; crossorigin=use-credentials
referrer-policy: no-referrer-when-downgrade
server-timing: issue_layout-fragment;desc="issue_layout fragment";dur=242.444701,issue_conversation_content-fragment;desc="issue_conversation_content fragment";dur=444.655376,nginx;desc="NGINX";dur=1.340661,glb;desc="GLB";dur=98.900765
strict-transport-security: max-age=31536000; includeSubdomains; preload
vary: X-PJAX, X-PJAX-Container, Turbo-Visit, Turbo-Frame, X-Requested-With, Accept,Accept-Encoding, Accept, X-Requested-With
x-content-type-options: nosniff
x-frame-options: deny
x-voltron-version: aab62e3
x-xss-protection: 0
server: github.com
content-encoding: gzip
accept-ranges: bytes
set-cookie: _gh_sess=5qfPSROCoP%2F9SYwAw2Zzr3V%2FgiZQhjJLQeOb0lgzwH4U4JVTNpxhTONAEbZ1SUoaC5PF%2F5XsPhhYxm%2BreW6O2xpFSgid4uMm9K%2BLDxbaKINNjdc%2BkE9EUIhN%2FUbYYtCPG%2Bqm4XdzGRhUrpCQr%2BGGKq%2BR74WbBiO5EU3wdoQySXD%2FdI7YrvwU3Yh4QSQc2%2F58zVvrtbZGF4%2FmHGimr2ekYPsrrJIG1dyAZ3ZcJXMFs9N7hauBxBkIC%2BbbeoV%2FlEslfIb1RT4TP6eJR%2ByWXSdOpw%3D%3D--%2F8UdER7o3nXZ%2BueT--kuBWqGOB00wFlru9ouvTNg%3D%3D; Path=/; HttpOnly; Secure; SameSite=Lax
set-cookie: _octo=GH1.1.1694386847.1767167479; Path=/; Domain=github.com; Expires=Thu, 31 Dec 2026 07:51:19 GMT; Secure; SameSite=Lax
set-cookie: logged_in=no; Path=/; Domain=github.com; Expires=Thu, 31 Dec 2026 07:51:19 GMT; HttpOnly; Secure; SameSite=Lax
x-github-request-id: D692:2E7100:181F44D:1B3FE38:6954D5F7
Parser can't parse NOT in simple when operand · Issue #2828 · h2database/h2database · GitHub
No one assignedNo labelsNo typeNo projectsNo milestoneNone yetNo branches or pull requests
Skip to content
Navigation Menu
{{ message }}
-
Notifications
You must be signed in to change notification settings - Fork 1.3k
Closed
Description
Consider the following test case:
CREATE TABLE T0(c0 BINARY);
CREATE VIEW V0(c0) AS SELECT T0.C0 FROM T0 WHERE (CASE NULL WHEN (NOT T0.C0) THEN 1 END);
SELECT * FROM V0;Unexpectedly, the SELECT results in a syntax error:
Caused by: org.h2.message.DbException: Syntax error in SQL statement "SELECT
""T0"".""C0""
FROM ""PUBLIC"".""T0""
WHERE CASE NULL WHEN NOT ""T0""[*].""C0"" THEN 1 END"; expected "ILIKE, REGEXP, BETWEEN, IN, LIKE" [42001-201]
at org.h2.message.DbException.getSyntaxError(DbException.java:238)
at org.h2.command.Parser.getSyntaxError(Parser.java:1260)
at org.h2.command.Parser.readConditionRightHandSide(Parser.java:3445)
at org.h2.command.Parser.readWhenOperand(Parser.java:5887)
at org.h2.command.Parser.readSimpleWhenClause(Parser.java:5870)
at org.h2.command.Parser.readCase(Parser.java:5854)
at org.h2.command.Parser.readTerm(Parser.java:5333)
at org.h2.command.Parser.readFactor(Parser.java:3652)
at org.h2.command.Parser.readSum(Parser.java:3639)
at org.h2.command.Parser.readConcat(Parser.java:3604)
at org.h2.command.Parser.readCondition(Parser.java:3390)
at org.h2.command.Parser.readExpressionWithGlobalConditions(Parser.java:3300)
at org.h2.command.Parser.parseSelect(Parser.java:3169)
at org.h2.command.Parser.parseQuerySub(Parser.java:3033)
at org.h2.command.Parser.parseSelectUnion(Parser.java:2871)
at org.h2.command.Parser.parseQuery(Parser.java:2841)
at org.h2.command.Parser.parsePrepared(Parser.java:1070)
at org.h2.command.Parser.parse(Parser.java:1045)
at org.h2.command.Parser.parse(Parser.java:1021)
at org.h2.command.Parser.prepare(Parser.java:929)
at org.h2.engine.SessionLocal.prepare(SessionLocal.java:583)
at org.h2.table.TableView.compileViewQuery(TableView.java:113)
at org.h2.table.TableView.initColumnsAndTables(TableView.java:165)
at org.h2.table.TableView.init(TableView.java:106)
at org.h2.table.TableView.<init>(TableView.java:68)
at org.h2.command.ddl.CreateView.update(CreateView.java:125)
at org.h2.command.CommandContainer.update(CommandContainer.java:173)
at org.h2.command.Command.executeUpdate(Command.java:250)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:236)
... 8 more
I found this based on commit f184cbf.
Metadata
Metadata
Assignees
Labels
No labels
Type
Projects
Milestone
Relationships
Development
Issue actions
You can’t perform that action at this time.