Return-Path: X-Original-To: apmail-empire-db-commits-archive@www.apache.org Delivered-To: apmail-empire-db-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3B7E1181A5 for ; Fri, 11 Sep 2015 13:53:49 +0000 (UTC) Received: (qmail 50724 invoked by uid 500); 11 Sep 2015 13:53:46 -0000 Delivered-To: apmail-empire-db-commits-archive@empire-db.apache.org Received: (qmail 50708 invoked by uid 500); 11 Sep 2015 13:53:46 -0000 Mailing-List: contact commits-help@empire-db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: empire-db-dev@empire-db.apache.org Delivered-To: mailing list commits@empire-db.apache.org Received: (qmail 50592 invoked by uid 500); 11 Sep 2015 13:53:45 -0000 Delivered-To: apmail-incubator-empire-db-commits@incubator.apache.org Received: (qmail 50588 invoked by uid 99); 11 Sep 2015 13:53:45 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Sep 2015 13:53:45 +0000 Date: Fri, 11 Sep 2015 13:53:45 +0000 (UTC) From: =?utf-8?Q?Rainer_D=C3=B6bele_=28JIRA=29?= To: empire-db-commits@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (EMPIREDB-226) Empire generates incorrect SQL when DBCommand's where list is empty MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/EMPIREDB-226?page=3Dcom.atlassi= an.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D14= 740838#comment-14740838 ]=20 Rainer D=C3=B6bele commented on EMPIREDB-226: ---------------------------------------- I have just added some more similar checks. > Empire generates incorrect SQL when DBCommand's where list is empty > ------------------------------------------------------------------- > > Key: EMPIREDB-226 > URL: https://issues.apache.org/jira/browse/EMPIREDB-226 > Project: Empire-DB > Issue Type: Bug > Reporter: Ivan Nemeth > Assignee: Rainer D=C3=B6bele > Priority: Minor > > if you add an empty constraint list to DBCommand through addWhereConstrai= nts, the resulting sql will end with an empty WHERE. > Example: > DBCommand cmd =3D db.createCommand(); > cmd.select(TABLE.getColumns()); > cmd.addWhereConstraints(new ArrayList()); > The generated sql will be something like this: > "SELECT t0.name FROM table t0 WHERE" -- This message was sent by Atlassian JIRA (v6.3.4#6332)