Re: Alter table add index not working

--===============3226814288737547142==
Content-Type: multipart/alternative; boundary="000000000000a45e7b05f7437d9c"

--000000000000a45e7b05f7437d9c
Content-Type: text/plain; charset="UTF-8"

But we are using compatibility mode as mysql.

On Sun, 19 Mar 2023 at 8:37 PM, Fred Toussi via Hsqldb-user <
[email protected]> wrote:

> This is not the correct syntax. Use this:
>
> "create index index_name on table_name(column_name)"
>
> See the Guide:
> http://hsqldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_other_object_creation
> On Sun, Mar 19, 2023, at 14:29, Sravya Kothuri wrote:
>
> Hi Team,
>
> I am actually using embedded HSQL database in my application and we
> recently migrated application from oracle to MariaDB and HSQL DB is
> throwing "type not found or user lacks provilige " while running "alter
> table table_name add index index_name (column_name)" and I saw from one of
> your article that this syntax is also correct I am using Public schema with
> SA user and version HSQL2.3.4 Also I tried same command with other versions
> as well and I am seeing same error.
>
>
> Thanks,
> Kothuri Sravya
>
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>

--000000000000a45e7b05f7437d9c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">But we are using compatibility mode as mysql.</div><div><=
br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sun,=
 19 Mar 2023 at 8:37 PM, Fred Toussi via Hsqldb-user &lt;<a href=3D"mailto:=
[email protected]">[email protected]</a>&gt=
; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .=
8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u><div><div style=3D"=
font-family:Arial">This is not the correct syntax. Use this:<br></div><div =
style=3D"font-family:Arial"><br></div><div style=3D"font-family:Arial">&quo=
t;create index index_name on table_name(column_name)&quot;<b></b></div><div=
 style=3D"font-family:Arial"><br></div><div style=3D"font-family:Arial" dir=
=3D"auto">See the Guide: <a href=3D"http://hsqldb.org/doc/2.0/guide/databas=
eobjects-chapt.html#dbc_other_object_creation" target=3D"_blank">http://hsq=
ldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_other_object_creation<=
/a></div></div><div><div>On Sun, Mar 19, 2023, at 14:29, Sravya Kothuri wro=
te:<br></div></div><div><blockquote type=3D"cite" id=3D"m_-4114109747830170=
389qt"></blockquote></div><div><blockquote type=3D"cite" id=3D"m_-411410974=
7830170389qt"><div><span style=3D"color:rgb(49,49,49);word-spacing:1px"><sp=
an style=3D"font-family:-apple-system,&quot;Helvetica Neue&quot;">Hi Team,<=
/span></span><br></div><div dir=3D"auto" style=3D"color:rgb(49,49,49);font-=
family:-apple-system,&quot;Helvetica Neue&quot;;word-spacing:1px"><br></div=
><div dir=3D"auto" style=3D"font-size:1rem;color:rgb(49,49,49);font-family:=
-apple-system,&quot;Helvetica Neue&quot;;word-spacing:1px">I am actually us=
ing embedded HSQL database in my application and we recently migrated appli=
cation from oracle to MariaDB and HSQL DB is throwing &quot;type not found =
or user lacks provilige &quot; while running &quot;alter table table_name a=
dd index index_name (column_name)&quot; and I saw from one of your article =
that this syntax is also correct I am using Public schema with SA user and =
version HSQL2.3.4 Also I tried same command with other versions as well and=
 I am seeing same error.<br></div><div dir=3D"auto" style=3D"font-size:1rem=
;color:rgb(49,49,49);font-family:-apple-system,&quot;Helvetica Neue&quot;;w=
ord-spacing:1px"><br></div><div dir=3D"auto" style=3D"color:rgb(49,49,49);f=
ont-family:-apple-system,&quot;Helvetica Neue&quot;;word-spacing:1px"><br><=
/div><div dir=3D"auto" style=3D"font-size:1rem;color:rgb(49,49,49);font-fam=
ily:-apple-system,&quot;Helvetica Neue&quot;;word-spacing:1px">Thanks,<br><=
/div><div dir=3D"auto" style=3D"font-size:1rem;color:rgb(49,49,49);font-fam=
ily:-apple-system,&quot;Helvetica Neue&quot;;word-spacing:1px">Kothuri Srav=
ya<br></div><div><br></div></blockquote></div><div><blockquote type=3D"cite=
" id=3D"m_-4114109747830170389qt"><div>____________________________________=
___________<br></div><div>Hsqldb-user mailing list<br></div><div><a href=3D=
"mailto:[email protected]" target=3D"_blank">Hsqldb-user@li=
sts.sourceforge.net</a><br></div><div><a href=3D"https://lists.sourceforge.=
net/lists/listinfo/hsqldb-user" target=3D"_blank">https://lists.sourceforge=
.net/lists/listinfo/hsqldb-user</a><br></div><div><br></div></blockquote><d=
iv style=3D"font-family:Arial"><br></div></div>____________________________=
___________________<br>
Hsqldb-user mailing list<br>
<a href=3D"mailto:[email protected]" target=3D"_blank">Hsql=
[email protected]</a><br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/hsqldb-user" rel=3D=
"noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/listinfo=
/hsqldb-user</a><br>
</blockquote></div></div>

--000000000000a45e7b05f7437d9c--


--===============3226814288737547142==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============3226814288737547142==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

--===============3226814288737547142==--