Index: ../src-rep/src/lib/aqua-database/com/aquafold/aquacore/open/rdbms/core/schema/extract/ExtractIndex.java IDEA additional info: Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP <+>UTF-8 =================================================================== --- ../src-rep/src/lib/aqua-database/com/aquafold/aquacore/open/rdbms/core/schema/extract/ExtractIndex.java (revision 58897) +++ ../src-rep/src/lib/aqua-database/com/aquafold/aquacore/open/rdbms/core/schema/extract/ExtractIndex.java (revision 58898) @@ -1359,7 +1359,8 @@ sql.append("SELECT us.name, index_name, table_name, column_name, ixcol.sequence, "); sql.append(openQuote).append("order").append(closeQuote).append(", "); sql.append("CASE ").append(openQuote).append("unique").append(closeQuote).append(" WHEN 1 THEN 'Y' ELSE 'N' END").append(", "); - sql.append("siqi.index_type, dbs.dbspace_name, siqi.delimited_by, siqi.limit, "); + sql.append("siqi.index_type, dbs.dbspace_name, siqi.delimited_by, "); + sql.append("siqi.").append(openQuote).append("limit").append(closeQuote).append(", "); sql.append(sybIQ_15_2_EqualOrGreater ? "stc.text_config_name, us1.name, " : "null as text_config_name, null as name, "); sql.append(sybIQ_15_1_EqualOrGreater ? "sr.remarks " : "null as remarks "); sql.append("FROM sysidxcol ixcol "); @@ -1383,7 +1384,9 @@ sql.append(openQuote).append("unique").append(closeQuote).append(", "); sql.append("ind.index_type, "); sql.append(sybIQ_15_0_EqualOrGreater ? "dbs.dbspace_name as dbspace_name, " : "null as dbspace_name, "); - sql.append("null as delimited_by, null as limit, null as text_config_name, null as name, null as remarks "); + sql.append("null as delimited_by, "); + sql.append("null as ").append(openQuote).append("limit").append(closeQuote).append(", "); + sql.append("null as text_config_name, null as name, null as remarks "); sql.append("FROM sysixcol ixcol, sysindex ind, syscolumn col, systable tab, sysusers us").append(sybIQ_15_0_EqualOrGreater ? ", sys.sysdbspace dbs " : " "); sql.append("WHERE "); sql.append(sybIQ_15_0_EqualOrGreater ? "ind.file_id *= dbs.dbspace_id AND " : ""); @@ -4351,7 +4354,8 @@ sql.append("SELECT us.name, index_name, table_name, column_name, ixcol.sequence, "); sql.append(openQuote).append("order").append(closeQuote).append(", "); sql.append("CASE ").append(openQuote).append("unique").append(closeQuote).append(" WHEN 1 THEN 'Y' ELSE 'N' END").append(", "); - sql.append("siqi.index_type, dbs.dbspace_name, siqi.delimited_by, siqi.limit, "); + sql.append("siqi.index_type, dbs.dbspace_name, siqi.delimited_by, "); + sql.append("siqi.").append(openQuote).append("limit").append(closeQuote).append(", "); sql.append(sybIQ_15_2_EqualOrGreater ? "stc.text_config_name, us1.name " : "null as text_config_name, null as name "); sql.append("FROM sysidxcol ixcol "); sql.append("INNER JOIN sys.sysidx ind on ixcol.index_id = ind.index_id and ixcol.table_id = ind.table_id and ind.[unique] != 2 "); @@ -4373,7 +4377,9 @@ sql.append(openQuote).append("unique").append(closeQuote).append(", "); sql.append("ind.index_type, "); sql.append(sybIQ_15_0_EqualOrGreater ? "dbs.dbspace_name as dbspace_name, " : "null as dbspace_name, "); - sql.append("null as delimited_by, null as limit, null as text_config_name, null as name "); + sql.append("null as delimited_by, "); + sql.append("null as ").append(openQuote).append("limit").append(closeQuote).append(", "); + sql.append("null as text_config_name, null as name "); sql.append("FROM sysixcol ixcol, sysindex ind, syscolumn col, systable tab, sysusers us").append(sybIQ_15_0_EqualOrGreater ? ", sys.sysdbspace dbs " : " "); sql.append("WHERE "); sql.append(sybIQ_15_0_EqualOrGreater ? "ind.file_id *= dbs.dbspace_id AND " : ""); \ No newline at end of file