Re: Alter table add index not working

--===============6248441007766608046==
Content-Type: multipart/alternative; boundary="0000000000007c56e305f74384db"

--0000000000007c56e305f74384db
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
>

--0000000000007c56e305f74384db
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">See=
 the Guide: <a href=3D"http://hsqldb.org/doc/2.0/guide/databaseobjects-chap=
t.html#dbc_other_object_creation" target=3D"_blank">http://hsqldb.org/doc/2=
.0/guide/databaseobjects-chapt.html#dbc_other_object_creation</a></div></di=
v><div><div>On Sun, Mar 19, 2023, at 14:29, Sravya Kothuri wrote:<br></div>=
</div><div><blockquote type=3D"cite" id=3D"m_-4114109747830170389qt"></bloc=
kquote></div><div><blockquote type=3D"cite" id=3D"m_-4114109747830170389qt"=
><div><span style=3D"color:rgb(49,49,49);word-spacing:1px"><span style=3D"f=
ont-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 using embedded =
HSQL database in my application and we recently migrated application from o=
racle to MariaDB and HSQL DB is throwing &quot;type not found or user lacks=
 provilige &quot; while running &quot;alter table table_name add index inde=
x_name (column_name)&quot; and I saw from one of your article that this syn=
tax 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;;word-spacing:1=
px"><br></div><div dir=3D"auto" style=3D"color:rgb(49,49,49);font-family:-a=
pple-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-sy=
stem,&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-family:-apple-sy=
stem,&quot;Helvetica Neue&quot;;word-spacing:1px">Kothuri Sravya<br></div><=
div><br></div></blockquote></div><div><blockquote type=3D"cite" id=3D"m_-41=
14109747830170389qt"><div>_______________________________________________<b=
r></div><div>Hsqldb-user mailing list<br></div><div><a href=3D"mailto:Hsqld=
[email protected]" target=3D"_blank">[email protected]=
ge.net</a><br></div><div><a href=3D"https://lists.sourceforge.net/lists/lis=
tinfo/hsqldb-user" target=3D"_blank">https://lists.sourceforge.net/lists/li=
stinfo/hsqldb-user</a><br></div><div><br></div></blockquote><div style=3D"f=
ont-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>

--0000000000007c56e305f74384db--


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


--===============6248441007766608046==
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

--===============6248441007766608046==--