// vtest build: present_sqlite3?
module main

import db.sqlite

struct Client18333 {
	id   int @[primary; sql: serial]
	name ?string
}

fn test_orm_option_field_issue_18333() {
	mut db := sqlite.connect(':memory:') or { panic(err) }
	defer {
		db.close() or {}
	}

	sql db {
		create table Client18333
	}!

	client := Client18333{
		name: 'alice'
	}

	sql db {
		insert client into Client18333
	}!

	rows := sql db {
		select from Client18333 where name == 'alice'
	}!

	assert rows.len == 1
	assert rows[0].name or { '' } == 'alice'
}