RustPython
diff --git a/‎.cspell.json‎
Lines changed: 1 addition & 0 deletions b/‎.cspell.json‎
Lines changed: 1 addition & 0 deletions
diff --git a/‎Lib/test/test_sqlite3/test_dbapi.py‎
Lines changed: 0 additions & 1 deletion b/‎Lib/test/test_sqlite3/test_dbapi.py‎
Lines changed: 0 additions & 1 deletion
diff --git a/‎crates/stdlib/src/_sqlite3.rs‎
Lines changed: 10 additions & 0 deletions b/‎crates/stdlib/src/_sqlite3.rs‎
Lines changed: 10 additions & 0 deletions
@@ -83,6 +83,7 @@
     "opargs",
     "pointee",
     "pyc",
+    "qmark",
     "reborrow",
     "reborrows",
     "reparenting",
 
@@ -875,7 +875,6 @@ def __getitem__(slf, x):
         with self.assertRaises(ZeroDivisionError):
             self.cu.execute("select name from test where name=?", L())
 
-    @unittest.expectedFailure  # TODO: RUSTPYTHON; mixed named and positional parameters not validated
     def test_execute_named_param_and_sequence(self):
         dataset = (
             ("select :a", (1,)),
 
@@ -3208,6 +3208,16 @@ mod _sqlite3 {
             }
 
             for i in 1..=num_needed {
+                let name = unsafe { sqlite3_bind_parameter_name(self.st, i) };
+                if !name.is_null() && unsafe { *name } != b'?' as libc::c_char {
+                    let name_str = ptr_to_str(name, vm)?;
+                    return Err(new_programming_error(
+                        vm,
+                        format!(
+                            "Binding {i} ('{name_str}') is a named parameter, but you supplied a sequence which requires nameless (qmark) placeholders."
+                        ),
+                    ));
+                }
                 let val = seq.get_item(i as isize - 1, vm)?;
                 self.bind_parameter(i, &val, vm)?;
             }