Fix SQLite3::SQLException in Quantity ordered scope

CAST(... AS BINARY) is MySQL-specific syntax; SQLite requires BLOB.
Use connection.adapter_name to select the correct cast type.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

app/models/quantity.rb

@@ -63,16 +63,10 @@ class Quantity < ApplicationRecord
   scope :ordered, ->(root: nil, include_root: true) {
     numbered = Arel::Table.new('numbered')
 
-    path_expr = if connection.adapter_name =~ /mysql/i
-      numbered.cast(numbered[:child_number], 'BINARY')
-    else
-      numbered[:child_number]
-    end
-
     self.model.with(numbered: numbered(:parent_id, :name)).with_recursive(arel_table.name => [
       numbered.project(
         numbered[Arel.star],
-        path_expr.as('path')
+        numbered.cast(numbered[:child_number], connection.adapter_name == 'Mysql2' ? 'BINARY' : 'BLOB').as('path')
       ).where(numbered[root && include_root ? :id : :parent_id].eq(root)),
       numbered.project(
         numbered[Arel.star],
@@ -86,25 +80,20 @@ class Quantity < ApplicationRecord
   # be merged with :ordered
   # https://gist.github.com/ProGM/c6df08da14708dcc28b5ca325df37ceb#extending-arel
   scope :numbered, ->(parent_column, order_column) {
-    row_num = Arel::Nodes::NamedFunction.new('ROW_NUMBER', [])
+    select(
-      .over(Arel::Nodes::Window.new.partition(parent_column).order(order_column))
+      arel_table[Arel.star],
-
-    child_number = if connection.adapter_name =~ /mysql/i
       Arel::Nodes::NamedFunction.new(
         'LPAD',
         [
-          row_num,
+          Arel::Nodes::NamedFunction.new('ROW_NUMBER', [])
+            .over(Arel::Nodes::Window.new.partition(parent_column).order(order_column)),
           Arel::SelectManager.new.project(
             Arel::Nodes::NamedFunction.new('LENGTH', [Arel.star.count])
           ).from(arel_table),
           Arel::Nodes.build_quoted('0')
-        ]
+        ],
+      ).as('child_number')
     )
-    else
-      Arel::Nodes::NamedFunction.new('format', [Arel::Nodes.build_quoted('%09d'), row_num])
-    end
-
-    select(arel_table[Arel.star], child_number.as('child_number'))
   }
 
   def to_s