From: Brian Hicks <brian@brianthicks.com>
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 15.0 \(3693.40.0.1.81\))
Subject: barrel 0.7.0 puts a semicolon in ALTER TABLE for indexes in Sqlite
Message-Id: <2C62A937-A22B-49FA-B199-8379B5E75B47@brianthicks.com>
Date: Tue, 11 Jan 2022 17:23:40 -0600
To: ~spacekookie/public-inbox@lists.sr.ht

Hey there! I=E2=80=99m using Barrel 0.7.0 and have found a problem while =
adding a table.

Here=E2=80=99s the code I have:

    use barrel::backend::Sqlite;
    use barrel::{types, Migration};

    pub fn migration() -> String {
        let mut m =3D Migration::new();

        m.change_table("items", |t| {
            t.add_index("idx_next", types::index(&["next"]))
        });

        m.make::<Sqlite>()
    }

this outputs the following SQL:

    ALTER TABLE "items" ;CREATE  INDEX "idx_next" ON "items" ("next=E2=80=9D=
);

note the interior semicolon. Sqlite doesn=E2=80=99t accept this, of =
course.

Not a huge rush to fix from my perspective, but I thought you should =
know!