# Retrieve data using a full-table scan #ws9 - column id's serial type code is NULL

**URL:** <https://forum.codecrafters.io/t/retrieve-data-using-a-full-table-scan-ws9-column-ids-serial-type-code-is-null/16083>\
**Category:** Challenges\
**Tags:** challenge:sqlite\
**Created:** [May 2, 2026, 12:37am UTC](https://forum.codecrafters.io/t/retrieve-data-using-a-full-table-scan-ws9-column-ids-serial-type-code-is-null/16083 "2026-05-02T00:37:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![magnusram05](https://yyz1.discourse-cdn.com/flex003/user_avatar/forum.codecrafters.io/magnusram05/32/25321_2.png) [@magnusram05](https://forum.codecrafters.io/u/magnusram05)\
**Post date:** [May 2, 2026, 12:37am UTC](https://forum.codecrafters.io/t/retrieve-data-using-a-full-table-scan-ws9-column-ids-serial-type-code-is-null/16083/1 "2026-05-02T00:37:41Z")

</div>

column id’s serial type code is NULL, but the test is expecting a number to be printed in the output

[tester::#WS9] Expected [1052|Silver St. Cloud (New Earth) 252|Dolphin (New Earth) 2668|Pasquale Galante, Jr. (New Earth)] to be returned as values, got: [|Dolphin (New Earth) |Pasquale Galante, Jr. (New Earth) |Silver St. Cloud (New Earth)]  
[tester::#WS9] Test failed

---

<div class="post-metadata">

**Author:** ![andy1li](https://yyz1.discourse-cdn.com/flex003/user_avatar/forum.codecrafters.io/andy1li/32/10_2.png) [@andy1li](https://forum.codecrafters.io/u/andy1li)\
**Post date:** [May 2, 2026, 6:53am UTC](https://forum.codecrafters.io/t/retrieve-data-using-a-full-table-scan-ws9-column-ids-serial-type-code-is-null/16083/3 "2026-05-02T06:53:39Z")

</div>

Hey @magnusram05, the id here corresponds to the `rowid`, which is stored **before the payload**.

 ![image](https://canada1.discourse-cdn.com/flex003/uploads/codecrafters/original/3X/6/c/6cc3c935a61cee7f2b551bd185d4d21d3a31126d.png)

You can find more details in [this post](https://forum.codecrafters.io/t/sqllite-challenge-table-columns-with-a-serial-type-of-integer-are-not-being-returned/2384/3) and explore a sample DB [here](https://sqlite-internal.pages.dev/).

Let me know if you’d like more clarification!

---

<div class="post-metadata">

**Author:** ![magnusram05](https://yyz1.discourse-cdn.com/flex003/user_avatar/forum.codecrafters.io/magnusram05/32/25321_2.png) [@magnusram05](https://forum.codecrafters.io/u/magnusram05)\
**Post date:** [May 3, 2026, 12:17am UTC](https://forum.codecrafters.io/t/retrieve-data-using-a-full-table-scan-ws9-column-ids-serial-type-code-is-null/16083/4 "2026-05-03T00:17:07Z")

</div>

@andy1li thank you. I can hear you say ‘read the SPEC’ 🙂 thanks for the timely response.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex003/uploads/codecrafters/original/3X/7/0/700657133935c15703e22c7c8870394f6e6dc27d.svg) [@system](https://forum.codecrafters.io/u/system)\
**Post date:** [May 8, 2026, 12:17am UTC](https://forum.codecrafters.io/t/retrieve-data-using-a-full-table-scan-ws9-column-ids-serial-type-code-is-null/16083/5 "2026-05-08T00:17:47Z")

</div>

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.