From 2b58344a8b36c4aebdfdc60b55c95b432fc8842d Mon Sep 17 00:00:00 2001
From: Vincent Rischmann
Date: Fri, 31 Dec 2021 01:56:10 +0100
Subject: add a test using untyped bind markers

---
 sqlite.zig | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

diff --git a/sqlite.zig b/sqlite.zig
index 6851aee..0eca84c 100644
--- a/sqlite.zig
+++ b/sqlite.zig
@@ -3137,6 +3137,25 @@ test "sqlite: oneDynamic" {
     }
 }
 
+test "sqlite: one with all named parameters" {
+    var db = try getTestDb();
+    defer db.deinit();
+    try addTestData(&db);
+
+    var diags = Diagnostics{};
+
+    // Mix bind marker prefix for good measure
+
+    const id = try db.one(
+        usize,
+        "SELECT id FROM user WHERE age = $age AND weight < :weight and id < @id",
+        .{ .diags = &diags },
+        .{ .id = 400, .age = 33, .weight = 200 },
+    );
+    try testing.expect(id != null);
+    try testing.expectEqual(@as(usize, 20), id.?);
+}
+
 test "sqlite: empty slice" {
     var arena = std.heap.ArenaAllocator.init(testing.allocator);
     defer arena.deinit();
-- 
cgit v1.2.3