- Not Implemented:
- Remove
- Merge
- Everything that isn't create, insert, or select
- Implemented:
- Table create
- Record insert
- Table select
- Partly implemented:
- N/A
- Bugs
- At times, when running the basic test, no records will be inserted to the initial table, making any selects show empty tables. This most likely has to due with the fact that I am not properly checking and closing fstream objects utilized in my utilities.cpp file.
- To get passed this bug, simply keep re-running the program until there are no crashes and all the tables are displaying correctly.
- I will admit I am a bit too lazy to fix the issue considering I already passed CS 008 with an A++ (100% plus extra credit for wearing a costume to class on Halloween), but atleast I know what it is!
- This project is the culmination of, quite literally, 100s of hours of work. Every single folder represents a single individual project that had to be meticulously programmed, unit tested, and at times documented, in order to become the almagamation that is this impressively unimpressive final project.
- While I may have been the first to pass 100% on all unit tests for the final project, having spent nearly 50 hours alone on it, I am certainly not the best nor most efficient of my peers.
- There is just WAY too much for me to document. Should have documented each project when I was working on them.
----------running basic_test.cpp--------- [==========] Running 1 test from 1 test suite. [----------] Global test environment set-up. [----------] 1 test from SQL_BASIC [ RUN ] SQL_BASIC.SQLBasic >make table employee fields last, first, dep, salary, year basic_test: table created. >make table employee fields last, first, dep, salary, year >insert into employee values Blow, Joe, CS, 100000, 2018 >insert into employee values Blow, JoAnn, Physics, 200000, 2016 >insert into employee values Johnson, Jack, HR, 150000, 2014 >insert into employee values Johnson, "Jimmy", Chemistry,140000, 2018 >make table student fields fname, lname, major, age >insert into student values Flo, Yao, Art, 20 >insert into student values Bo, Yang, CS, 28 >insert into student values "Sammuel L.", Jackson, CS, 40 >insert into student values "Billy", Jackson, Math, 27 >insert into student values "Mary Ann", Davis, Math, 30 >select * from employee There is no condition Table name: _select_table_4, records: 4 record last first dep salary year 0 Blow Joe CS 100000 2018 1 Blow JoAnn Physics 200000 2016 2 Johnson Jack HR 150000 2014 3 Johnson Jimmy Chemistry 140000 2018 basic_test: records selected: 0 1 2 3 >select last, first, age from employee There is no condition Table name: _select_table_6, records: 4 record last first age 0 Blow Joe Blow 1 Blow JoAnn Blow 2 Johnson Jack Johnson 3 Johnson Jimmy Johnson basic_test: records selected: 0 1 2 3 >select last from employee There is no condition Table name: _select_table_8, records: 4 record last 0 Blow 1 Blow 2 Johnson 3 Johnson basic_test: records selected: 0 1 2 3 >select * from employee where last = Johnson ShuntingYard() : output_queue = Queue: Head-><-[last]-> <-[Johnson]-> <-[=]-> ||| Table name: _select_table_9, records: 2 record last first dep salary year 0 Johnson Jack HR 150000 2014 1 Johnson Jimmy Chemistry 140000 2018 basic_test: records selected: 2 3 >select * from employee where last=Blow and major="JoAnn" ShuntingYard() : output_queue = Queue: Head-><-[last]-> <-[Blow]-> <-[=]-> <-[major]-> <-[JoAnn]-> <-[=]-> <-[and]-> ||| Table name: _select_table_10, records: 0 record last first dep salary year basic_test: records selected: >select * from student There is no condition Table name: _select_table_12, records: 5 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 3 Billy Jackson Math 27 4 Mary Ann Davis Math 30 basic_test: records selected: 0 1 2 3 4 >select * from student where (major=CS or major=Art) ShuntingYard() : output_queue = Queue: Head-><-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> ||| Table name: _select_table_13, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 >select * from student where lname>J ShuntingYard() : output_queue = Queue: Head-><-[lname]-> <-[J]-> <-[>]-> ||| Table name: _select_table_14, records: 4 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 3 Billy Jackson Math 27 basic_test: records selected: 0 1 2 3 >select * from student where lname>J and (major=CS or major=Art) ShuntingYard() : output_queue = Queue: Head-><-[lname]-> <-[J]-> <-[>]-> <-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> ||| Table name: _select_table_15, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 ----- END TEST -------- [ OK ] SQL_BASIC.SQLBasic (718 ms) [----------] 1 test from SQL_BASIC (719 ms total) [----------] Global test environment tear-down [==========] 1 test from 1 test suite ran. (724 ms total) [ PASSED ] 1 test. ----------running testB.cpp--------- [==========] Running 3 tests from 3 test suites. [----------] Global test environment set-up. [----------] 1 test from TEST_SQL_PARENTH [ RUN ] TEST_SQL_PARENTH.TestSql ========== test_sql_parenthesis() ======================================= >select * from student where major = CS or major = Art or fname = Flo and lname = Yao ShuntingYard() : output_queue = Queue: Head-><-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> <-[or]-> ||| Table name: _select_table_0, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 >select * from student where (fname=Flo) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> ||| Table name: _select_table_1, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where fname = Flo or (major > Art and lname < Z) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[major]-> <-[Art]-> <-[>]-> <-[lname]-> <-[Z]-> <-[<]-> <-[and]-> <-[or]-> ||| Table name: _select_table_2, records: 5 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 3 Billy Jackson Math 27 4 Mary Ann Davis Math 30 basic_test: records selected: 0 1 2 3 4 >select * from student where (fname = Flo) or (lname < Z) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Z]-> <-[<]-> <-[or]-> ||| Table name: _select_table_3, records: 5 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 3 Billy Jackson Math 27 4 Mary Ann Davis Math 30 basic_test: records selected: 0 1 2 3 4 >select * from student where (fname = Flo and lname = Yao or major = CS) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> ||| Table name: _select_table_4, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 >select * from student where (fname = Flo and (lname = Yao or major = CS)) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> <-[and]-> ||| Table name: _select_table_5, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo and (lname <= Yao and (major = Art or age > 20))) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[<=]-> <-[major]-> <-[Art]-> <-[=]-> <-[age]-> <-[20]-> <-[>]-> <-[or]-> <-[and]-> <-[and]-> ||| Table name: _select_table_6, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where fname = Flo and lname = Yao ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> ||| Table name: _select_table_7, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where fname = Flo or (lname = Yao or major = CS) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> <-[or]-> ||| Table name: _select_table_8, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 >select * from student where (fname = Flo or lname = Yao) and major = CS ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[or]-> <-[major]-> <-[CS]-> <-[=]-> <-[and]-> ||| Table name: _select_table_9, records: 0 record fname lname major age basic_test: records selected: >select * from student where (fname = Flo or lname = Yao) and (major = CS or major = Art) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[or]-> <-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> ||| Table name: _select_table_10, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo or (lname = Yao and (major = CS or major = Art))) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> <-[or]-> ||| Table name: _select_table_11, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where fname = Flo or (lname = Yao and (major = CS or major = Art)) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> <-[or]-> ||| Table name: _select_table_12, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo and (lname = Yao or major = CS or major = Art)) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> ||| Table name: _select_table_13, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo and lname = Yao or major = CS or major = Art) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> ||| Table name: _select_table_14, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 >select * from student where (fname = Flo and lname = Yao) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> ||| Table name: _select_table_15, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo and (lname = Yao or major = CS)) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> <-[and]-> ||| Table name: _select_table_16, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo and (lname = Yao or lname = Jackson) or major = CS and age <= 30) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[lname]-> <-[Jackson]-> <-[=]-> <-[or]-> <-[and]-> <-[major]-> <-[CS]-> <-[=]-> <-[age]-> <-[30]-> <-[<=]-> <-[and]-> <-[or]-> ||| Table name: _select_table_17, records: 2 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 basic_test: records selected: 0 1 >select * from student where ((fname = Flo and lname = Yao) or lname = Jackson) or major = CS and age <= 30 ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> <-[lname]-> <-[Jackson]-> <-[=]-> <-[or]-> <-[major]-> <-[CS]-> <-[=]-> <-[age]-> <-[30]-> <-[<=]-> <-[and]-> <-[or]-> ||| Table name: _select_table_18, records: 4 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 3 Billy Jackson Math 27 basic_test: records selected: 0 1 2 3 >select * from student where (fname = Flo or (lname = Yao and (major = CS or major = Art)) or lname = Jackson) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> <-[or]-> <-[lname]-> <-[Jackson]-> <-[=]-> <-[or]-> ||| Table name: _select_table_19, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Sammuel L. Jackson CS 40 2 Billy Jackson Math 27 basic_test: records selected: 0 2 3 ----- END TEST -------- [ OK ] TEST_SQL_PARENTH.TestSql (1040 ms) [----------] 1 test from TEST_SQL_PARENTH (1040 ms total) [----------] 1 test from TEST_SQL_INVALID [ RUN ] TEST_SQL_INVALID.TestSql [ OK ] TEST_SQL_INVALID.TestSql (0 ms) [----------] 1 test from TEST_SQL_INVALID (1 ms total) [----------] 1 test from TEST_BATCH_FILE [ RUN ] TEST_BATCH_FILE.TestBatchFile [ OK ] TEST_BATCH_FILE.TestBatchFile (0 ms) [----------] 1 test from TEST_BATCH_FILE (1 ms total) [----------] Global test environment tear-down [==========] 3 tests from 3 test suites ran. (1047 ms total) [ PASSED ] 3 tests. C:\Users\Dylan\Desktop\Visual Studio Workspace\CS 008\99_99_final_project\out\build\x64-Debug\bin\testB.exe (process 14320) exited with code -1073741819 (0xc0000005). Press any key to close this window . . .
----------running basic_test.cpp--------- [==========] Running 1 test from 1 test suite. [----------] Global test environment set-up. [----------] 1 test from SQL_BASIC [ RUN ] SQL_BASIC.SQLBasic >make table employee fields last, first, dep, salary, year basic_test: table created. >make table employee fields last, first, dep, salary, year >insert into employee values Blow, Joe, CS, 100000, 2018 >insert into employee values Blow, JoAnn, Physics, 200000, 2016 >insert into employee values Johnson, Jack, HR, 150000, 2014 >insert into employee values Johnson, "Jimmy", Chemistry,140000, 2018 >make table student fields fname, lname, major, age >insert into student values Flo, Yao, Art, 20 >insert into student values Bo, Yang, CS, 28 >insert into student values "Sammuel L.", Jackson, CS, 40 >insert into student values "Billy", Jackson, Math, 27 >insert into student values "Mary Ann", Davis, Math, 30 >select * from employee There is no condition Table name: _select_table_4, records: 4 record last first dep salary year 0 Blow Joe CS 100000 2018 1 Blow JoAnn Physics 200000 2016 2 Johnson Jack HR 150000 2014 3 Johnson Jimmy Chemistry 140000 2018 basic_test: records selected: 0 1 2 3 >select last, first, age from employee There is no condition Table name: _select_table_6, records: 4 record last first age 0 Blow Joe Blow 1 Blow JoAnn Blow 2 Johnson Jack Johnson 3 Johnson Jimmy Johnson basic_test: records selected: 0 1 2 3 >select last from employee There is no condition Table name: _select_table_8, records: 4 record last 0 Blow 1 Blow 2 Johnson 3 Johnson basic_test: records selected: 0 1 2 3 >select * from employee where last = Johnson ShuntingYard() : output_queue = Queue: Head-><-[last]-> <-[Johnson]-> <-[=]-> ||| Table name: _select_table_9, records: 2 record last first dep salary year 0 Johnson Jack HR 150000 2014 1 Johnson Jimmy Chemistry 140000 2018 basic_test: records selected: 2 3 >select * from employee where last=Blow and major="JoAnn" ShuntingYard() : output_queue = Queue: Head-><-[last]-> <-[Blow]-> <-[=]-> <-[major]-> <-[JoAnn]-> <-[=]-> <-[and]-> ||| Table name: _select_table_10, records: 0 record last first dep salary year basic_test: records selected: >select * from student There is no condition Table name: _select_table_12, records: 5 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 3 Billy Jackson Math 27 4 Mary Ann Davis Math 30 basic_test: records selected: 0 1 2 3 4 >select * from student where (major=CS or major=Art) ShuntingYard() : output_queue = Queue: Head-><-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> ||| Table name: _select_table_13, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 >select * from student where lname>J ShuntingYard() : output_queue = Queue: Head-><-[lname]-> <-[J]-> <-[>]-> ||| Table name: _select_table_14, records: 4 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 3 Billy Jackson Math 27 basic_test: records selected: 0 1 2 3 >select * from student where lname>J and (major=CS or major=Art) ShuntingYard() : output_queue = Queue: Head-><-[lname]-> <-[J]-> <-[>]-> <-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> ||| Table name: _select_table_15, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 ----- END TEST -------- [ OK ] SQL_BASIC.SQLBasic (718 ms) [----------] 1 test from SQL_BASIC (719 ms total) [----------] Global test environment tear-down [==========] 1 test from 1 test suite ran. (724 ms total) [ PASSED ] 1 test.
----------running testB.cpp--------- [==========] Running 3 tests from 3 test suites. [----------] Global test environment set-up. [----------] 1 test from TEST_SQL_PARENTH [ RUN ] TEST_SQL_PARENTH.TestSql ========== test_sql_parenthesis() ======================================= >select * from student where major = CS or major = Art or fname = Flo and lname = Yao ShuntingYard() : output_queue = Queue: Head-><-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> <-[or]-> ||| Table name: _select_table_0, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 >select * from student where (fname=Flo) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> ||| Table name: _select_table_1, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where fname = Flo or (major > Art and lname < Z) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[major]-> <-[Art]-> <-[>]-> <-[lname]-> <-[Z]-> <-[<]-> <-[and]-> <-[or]-> ||| Table name: _select_table_2, records: 5 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 3 Billy Jackson Math 27 4 Mary Ann Davis Math 30 basic_test: records selected: 0 1 2 3 4 >select * from student where (fname = Flo) or (lname < Z) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Z]-> <-[<]-> <-[or]-> ||| Table name: _select_table_3, records: 5 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 3 Billy Jackson Math 27 4 Mary Ann Davis Math 30 basic_test: records selected: 0 1 2 3 4 >select * from student where (fname = Flo and lname = Yao or major = CS) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> ||| Table name: _select_table_4, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 >select * from student where (fname = Flo and (lname = Yao or major = CS)) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> <-[and]-> ||| Table name: _select_table_5, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo and (lname <= Yao and (major = Art or age > 20))) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[<=]-> <-[major]-> <-[Art]-> <-[=]-> <-[age]-> <-[20]-> <-[>]-> <-[or]-> <-[and]-> <-[and]-> ||| Table name: _select_table_6, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where fname = Flo and lname = Yao ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> ||| Table name: _select_table_7, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where fname = Flo or (lname = Yao or major = CS) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> <-[or]-> ||| Table name: _select_table_8, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 >select * from student where (fname = Flo or lname = Yao) and major = CS ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[or]-> <-[major]-> <-[CS]-> <-[=]-> <-[and]-> ||| Table name: _select_table_9, records: 0 record fname lname major age basic_test: records selected: >select * from student where (fname = Flo or lname = Yao) and (major = CS or major = Art) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[or]-> <-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> ||| Table name: _select_table_10, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo or (lname = Yao and (major = CS or major = Art))) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> <-[or]-> ||| Table name: _select_table_11, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where fname = Flo or (lname = Yao and (major = CS or major = Art)) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> <-[or]-> ||| Table name: _select_table_12, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo and (lname = Yao or major = CS or major = Art)) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> ||| Table name: _select_table_13, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo and lname = Yao or major = CS or major = Art) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> ||| Table name: _select_table_14, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 basic_test: records selected: 0 1 2 >select * from student where (fname = Flo and lname = Yao) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> ||| Table name: _select_table_15, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo and (lname = Yao or major = CS)) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[or]-> <-[and]-> ||| Table name: _select_table_16, records: 1 record fname lname major age 0 Flo Yao Art 20 basic_test: records selected: 0 >select * from student where (fname = Flo and (lname = Yao or lname = Jackson) or major = CS and age <= 30) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[lname]-> <-[Jackson]-> <-[=]-> <-[or]-> <-[and]-> <-[major]-> <-[CS]-> <-[=]-> <-[age]-> <-[30]-> <-[<=]-> <-[and]-> <-[or]-> ||| Table name: _select_table_17, records: 2 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 basic_test: records selected: 0 1 >select * from student where ((fname = Flo and lname = Yao) or lname = Jackson) or major = CS and age <= 30 ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[and]-> <-[lname]-> <-[Jackson]-> <-[=]-> <-[or]-> <-[major]-> <-[CS]-> <-[=]-> <-[age]-> <-[30]-> <-[<=]-> <-[and]-> <-[or]-> ||| Table name: _select_table_18, records: 4 record fname lname major age 0 Flo Yao Art 20 1 Bo Yang CS 28 2 Sammuel L. Jackson CS 40 3 Billy Jackson Math 27 basic_test: records selected: 0 1 2 3 >select * from student where (fname = Flo or (lname = Yao and (major = CS or major = Art)) or lname = Jackson) ShuntingYard() : output_queue = Queue: Head-><-[fname]-> <-[Flo]-> <-[=]-> <-[lname]-> <-[Yao]-> <-[=]-> <-[major]-> <-[CS]-> <-[=]-> <-[major]-> <-[Art]-> <-[=]-> <-[or]-> <-[and]-> <-[or]-> <-[lname]-> <-[Jackson]-> <-[=]-> <-[or]-> ||| Table name: _select_table_19, records: 3 record fname lname major age 0 Flo Yao Art 20 1 Sammuel L. Jackson CS 40 2 Billy Jackson Math 27 basic_test: records selected: 0 2 3 ----- END TEST -------- [ OK ] TEST_SQL_PARENTH.TestSql (1040 ms) [----------] 1 test from TEST_SQL_PARENTH (1040 ms total) [----------] 1 test from TEST_SQL_INVALID [ RUN ] TEST_SQL_INVALID.TestSql [ OK ] TEST_SQL_INVALID.TestSql (0 ms) [----------] 1 test from TEST_SQL_INVALID (1 ms total) [----------] 1 test from TEST_BATCH_FILE [ RUN ] TEST_BATCH_FILE.TestBatchFile [ OK ] TEST_BATCH_FILE.TestBatchFile (0 ms) [----------] 1 test from TEST_BATCH_FILE (1 ms total) [----------] Global test environment tear-down [==========] 3 tests from 3 test suites ran. (1047 ms total) [ PASSED ] 3 tests. C:\Users\Dylan\Desktop\Visual Studio Workspace\CS 008\99_99_final_project\out\build\x64-Debug\bin\testB.exe (process 14320) exited with code -1073741819 (0xc0000005). Press any key to close this window . . .