Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Double Quotes in SQL Parser Gives Odd Results #18

Open
dclements opened this issue Jan 6, 2013 · 0 comments
Open

Double Quotes in SQL Parser Gives Odd Results #18

dclements opened this issue Jan 6, 2013 · 0 comments
Labels

Comments

@dclements
Copy link
Contributor

test [4] > create table test2 (id int32, value string, primary key (id))
table test2 defined
test [5] > insert into test2 values (1, 'foo')
inserted 1 row
test [6] > select * from test2 where value = "f"
    inserted    1   foo
test [7] > select * from test2 where value = 'f'

test [8] >

Similar results happen if the field is an int32.

On an integer primary key:

test [4] > create table test (id int32, val int32, primary key (id))
table test defined
test [5] > insert into test values (1, 1)
inserted 1 row
test [6] > select * from test where id > ""
java.lang.UnsupportedOperationException

With the following on the server:

com.readytalk.revori.server.SQLServer executeRequest
WARNING: null
java.lang.UnsupportedOperationException
    at com.readytalk.revori.imp.ColumnReferenceAdapter.makeScan(ColumnReferenceAdapter.java:34)
    at com.readytalk.revori.imp.Plan.improvePlan(Plan.java:60)
    at com.readytalk.revori.imp.Plan.choosePlan(Plan.java:104)
    at com.readytalk.revori.imp.TableIterator.<init>(TableIterator.java:98)
    at com.readytalk.revori.imp.TableAdapter.iterator(TableAdapter.java:27)
    at com.readytalk.revori.imp.TableAdapter.iterator(TableAdapter.java:1)
    at com.readytalk.revori.imp.MyQueryResult.reset(MyQueryResult.java:121)
    at com.readytalk.revori.imp.MyQueryResult.<init>(MyQueryResult.java:116)
    at com.readytalk.revori.imp.MyQueryResult.<init>(MyQueryResult.java:63)
    at com.readytalk.revori.imp.MyRevision.diff(MyRevision.java:215)
    at com.readytalk.revori.server.SQLServer.diff(SQLServer.java:1390)
    at com.readytalk.revori.server.SQLServer.access$10(SQLServer.java:1383)
    at com.readytalk.revori.server.SQLServer$ParserFactory$12.run(SQLServer.java:2156)
    at com.readytalk.revori.server.SQLServer.executeRequest(SQLServer.java:2619)
    at com.readytalk.revori.server.SQLServer.handleRequest(SQLServer.java:2686)
    at com.readytalk.revori.server.SQLServer.access$3(SQLServer.java:2671)
    at com.readytalk.revori.server.SQLServer$Client.run(SQLServer.java:487)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:680)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant