Closed kilianmh closed 6 months ago
You have put the closing paren in the wrong place. It needs to be after :preserve-rows.
(is (equal (sql (:create-extended-table (:temporary distributors)
:as
(:select '*
:from 'businesses
:where (:= 'type "distribution"))
((:on-commit :preserve-rows))))
"CREATE TEMP TABLE distributors ON COMMIT PRESERVE ROWS AS ((SELECT * FROM businesses WHERE (type = E'distribution')))"))
Now it should be correct
Are the tests now passing on your side?
They are passing for me.
Now the compilation of the test suite works again. Still many tests do not succeed.