H2-(相当)长的INSERT失败，错误42000 [英] H2 - (Quite) long INSERT failing with error 42000

问题描述

H2内存-插入-错误42000

H2 in-memory - INSERT - Error 42000

试用版本1.4.196、1.4.197、1.4.199.

Tried versions 1.4.196, 1.4.197, 1.4.199.

我还尝试在H2服务器(本地)上执行INSERT:也失败了

I also tried to execute INSERT on H2 server (local) : also failed

给出错误的行:(对不起，但出于安全原因，我无法生产更多):

The line giving the error: (sorry but for security reasons I cannot produce more) :

    INSERT INTO tb_ae (server,  record_id,  ...) 
    SELECT ... 
    FROM   vw_ofch_prepal_delta,   vw_ab_bie  
    WHERE  bie_tp IN ('S[*]') AND is_most_recent = 1;

该语句的长度为4.004个字符.

The statement is 4.004 characters long.

H2将错误指示为[*](这不是语句的一部分).

The error is pointed by H2 as [*] (this is not part of the statement).

推荐答案

H2不在字符串文字中设置错误标记[*].这意味着您很可能在更早的位置放错了'字符.它可以是未封闭的字符串文字，也可以是某些字符串文字中的未转义的'字符(如果字符串文字包含'字符，则应使用两个诸如''之类的字符书写)或一个杂散的'字符.

H2 does not set the error mark [*] inside character string literals. It means that most likely you have a misplaced ' character somewhere earlier. It can be an unclosed string literal, unescaped ' character in some string literal (if a string literal contains the ' character it should be written with two such characters as ''), or a stray ' character.

这篇关于H2-(相当)长的INSERT失败，错误42000的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！