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

COUNT usage leads to error: Invalid generated Coq code #82

Open
matthiastz opened this issue Jan 2, 2020 · 1 comment
Open

COUNT usage leads to error: Invalid generated Coq code #82

matthiastz opened this issue Jan 2, 2020 · 1 comment

Comments

@matthiastz
Copy link

setup:

schema InvoiceSchema(InvoiceId: int, CustomerId: int, InvoiceDate: date,
			BillingAddress: varchar, BillingCity: varchar,
			BillingState: varchar, BillingCountry: varchar,
			BillingPostalCode: varchar, Total: numeric); 
table Invoice(InvoiceSchema);

query q1
`SELECT i.InvoiceId, i.CustomerId, count(i.CustomerId) FROM Invoice i`;

query q2
`SELECT i.InvoiceId, i.CustomerId, count(i.CustomerId) FROM Invoice i`;

verify q1 q2;

result:
Invalid generated Coq code. Please file an issue.

Rosette find an counterexample.

@matthiastz
Copy link
Author

original queries I wanted to test:

schema InvoiceSchema(InvoiceId: int, CustomerId: int, InvoiceDate: date,
			BillingAddress: varchar, BillingCity: varchar,
			BillingState: varchar, BillingCountry: varchar,
			BillingPostalCode: varchar, Total: numeric); 
table Invoice(InvoiceSchema);

query q1
`SELECT i.InvoiceId, i.CustomerId, count(i.CustomerId) FROM Invoice i
 GROUP BY i.CustomerId`;

query q2
`SELECT i.InvoiceId, i.CustomerId, count(i.CustomerId) FROM Invoice i`;

verify q1 q2;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant