In 2.10, Queries can't use the ID and POSITION columns in some conditions

Description

The cause was:

  • The statusPosition and statusPK were set on two columns,

  • The preflight wasn't activated when changing the systemColumnsMode, so there was no time to reset the values

The resolution was simple:

  • Force the preflight when systemColumnsMode changes

  • Ensure only the first two columns have statusPK and statusPosition.

Environment

None

Observations

  • I have a table with ID but no POSITION.

  • When I create a query, Play SQL requires the "Generate" mode, and displays the ID twice,

  • Even if I use "ID, POSITION, *", Play SQL displays either ID or POSITION twice.

Assignee

Adrien Ragot (Play SQL / Requirement Yogi)

Reporter

Adrien Ragot (Old account)

Labels

None

Participants

None

Components

Fix versions

Affects versions

Priority

Configure