bog-walk

Results 44 comments of bog-walk

Hi @rtc11 , in the event that you are using a database that supports `CREATE SEQUENCE` operation (like PostgreSQL), you could set this up yourself if you're in a bind....

It will be possible to provide a custom sequence instance to `autoIncrement()` in the upcoming version 0.54.0.

Starting with version 0.52.0, column comments in MySQL, MariaDB, H2, and SQLite will be available using: ```kt object Users : Table("users") { val id = long("id") .autoIncrement() .withDefinition("COMMENT", stringLiteral("user id"))...

Hi @utybo I'm attempting to narrow down the goal of this issue and would appreciate any clarification regarding your comment about using a table object across both PostgreSQL and MySQL....

Thanks very much for the detailed response and the MySQL workaround @utybo . Regarding the feature flag for auto-escaping identifiers, I've requested some feedback in another issue ([issue #1658](https://github.com/JetBrains/Exposed/issues/1658)), but...

@valeriyo This is the expected behavior based on PostgreSQL's [case insensitive identifier syntax](https://www.postgresql.org/docs/7.1/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS) and following PostgreSQL's own logic of folding unquoted identifiers to lower case. Even if the generated SQL...

Since [version 0.44.0](https://github.com/JetBrains/Exposed/blob/main/CHANGELOG.md#0440), a column can be flagged as generated/updated by the database using `Column.databaseGenerated()`.

Both these approaches will become possible in upcoming version 0.53.0. A new extension function `comment()` has been added to the `Query` class in PR #2088 . And the `Query` class...

From my understanding, PostgreSQL will be the only database that returns a result set populated with inserted/updated values that are not auto-incrementing. It might be good to investigate later if...

@levilansing Thanks very much for bringing this use case to our attention. `exec()` arguments have been typically tried and tested using stand-alone/throw-away `columnType`s via manually-defined lists of pairs. The logic...