B2T2 icon indicating copy to clipboard operation
B2T2 copied to clipboard

Wrong Department ID in emplyees example table?

Open michel-steuwer opened this issue 3 years ago • 1 comments

Hi,

the employees table at: https://github.com/brownplt/B2T2/blob/main/ExampleTables.md contains the value 32 as a Department ID which is not present in the departments table. This is not the case in the linked source: https://en.wikipedia.org/wiki/Join_(SQL) where the 32 is a 33.

I wanted to check if this is a deliberate choice (and if so, what the rationale is) or a mistake.

I stumbled across this when my prototype implementation reported this as a type error.

michel-steuwer avatar Jan 07 '22 16:01 michel-steuwer

The 32 is indeed a typo. Thanks for catching it!

We plan to fix the typo, release a new version of B2T2, and notify other contributors.

But first, would you please fix the typo locally and keep working on your prototype implementation? We're all very impressed that your prototype caught this typo as a type error --- it's a kind of error we hadn't imagined! And it makes us wonder whether you'll find other errors further down in the API or in the example programs & errors. Ideally we'd like to fix those all together before notifying people.

bennn avatar Jan 08 '22 02:01 bennn