2943652 - Signal 11 in s_execclearvar() when Java client executes INSERT using PreparedStatement - SAP ASE

• A Java client executes an INSERT statement using PreparedStatement as:

PreparedStatement pstmt = conn.prepareStatement("insert my_table (data_id,batch_id,router_id,create_time) values (?,?,?,getdate()) 354!");
connecting to jdbc:sybase:Tds:localhost:5000/tempdb?DYNAMIC_PREPARE=FALSE

• And hits an exception:

com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near '354'.

at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4119)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3235)
at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)
at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2750)
at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2734)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:330)
at br_insert.main(br_insert.java:32)

• ASE errorlog reports an "infected with signal 11" error in the module s_execclearvar() together with a stack trace:

Current process (0x6f6d0f40) infected with signal 11 (SIGSEGV)
Address 0x0x00000000011dac27 (s_execclearvar+0x27), siginfo (code, address) = (1, 0x0x0000000000000004)

• The stack trace includes the functions:

s_execclearvar
sequencer
tdsrecv_language

  Note: A complete stack trace is available under Attachments.

• SAP Adaptive Server Enterprise (ASE) 15.7 SP137-SP139
• SAP Adaptive Server Enterprise (ASE) 16.0 SP02 pre-PL06
• SAP Adaptive Server Enterprise (ASE) 16.0 SP03 pre-PL02
• Java client

CR805654, CR#805654, 805654, CR809395, CR#809395 809395, SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace, registers, prepared, statement