help1402

It's UWAweek 42 (2nd semester, week 12)

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

Please consider offering answers and suggestions to help other students! And if you fix a problem by following a suggestion here, it would be great if other interested students could see a short "Great, fixed it!" followup message.

How do I ask a good question?

Displaying selected article

Showing 1 of 612 articles.
Currently 122 other people reading this forum.

UWA week 37 (2nd semester, week 7) ↓

Lab 04 - Question 05 (all 8)

2:02pm Wed 11th Sep, Adam W.

Yes it does appear to be an issue with the parenthesis, I tried adding them into the correct solution on the test interface and it does appear to break it, I'll investigate if this is an SQLite issue, or to do with the testing code implemented on the question itself. So for now don't use parenthesis for this one. Adam. "Yufang Wei" <24*1*1*3@s*u*e*t*u*a*e*u*a*> wrote:

> It seems like sqlite doesn't allow parenthesis for select statement when performing UNION/EXCEPT/INTERSECT operators? > > Without parenthesis, after UNION we get IRN and IWS, next it will perform EXCEPT and the result will be IWS, lastly it will do INTERSECT so the final results it returns is IWS.

help1402 articles all ANNOUNCEMENTS recent articles login to post a new article help1402 topics from today and yesterday from the past week from the past two weeks ALL topics, most recent first	login chapter0 unitinfo research projects csforum csse-feedback csbreakdown cssubmit csmarks 2nd semester help fora Algebra Advanced Algorithms Cloud Computing High Performance Computing Intelligent Agents Professional Computing Relational Database Management Systems Systems Programming