[IGNITE-23361] Calcite. Lost precision of dynamic parameters

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.14
• Fix Version/s: 2.17
• Labels: calcite ignite-3 ise
• Release Note: SQL Calcite: Fixed lost precisions of dynamic query parameters
• Ignite Flags: Release Notes Required
• Assignee: Vladimir Steshin
• Reporter: Vladimir Steshin
• Created: 03/Oct/24 18:41
• Updated: 24/Oct/24 12:27
• Resolved: 24/Oct/24 12:27

Description

Reproducer:

@Test
    public void test() {
       //Exprected 'ab'
        assertQuery("SELECT CAST(? AS VARCHAR(2))").withParams("abcd").returns("ab").check();
    }

@Test
    public void test0(){
        // A conversion error is expected.
        assertQuery("SELECT CAST(? AS DECIMAL(2))").withParams(new BigDecimal("123")).check();
    }

Adoption of #IGNITE-19353

Issue Links

• links to: GitHub Pull Request #11581