Careful with reserved words

If you have a variable say "class" or "package" when calling them via a script you will get weird results. I'd advise to avoid this list of names for columns.

Javascript Reserved Words

abstractargumentsawaitbooleanbreakbytecasecatch
charclassconstcontinuedebuggerdefaultdeletedo
doubleelseenumevalexportextendsfalsefinal
finallyfloatforfunctiongotoifimplementsimport
ininstanceofintinterfaceletlongnativenew
nullpackageprivateprotectedpublicreturnshortstatic
superswitchsynchronizedthisthrowthrowstransienttrue
trytypeofvarvoidvolatilewhilewithyield

Try it out. make a catalog item. make a variable, call it "class", try to use that variable in a refernce qualifer and observe weird things.

The docs also say, "you cannot use reserved words".

Other's have had issues using these terms for column names. If you can, avoid that so you don't have the same problem here as Detlef.

MysQL Reserved Words

Database view reserved words seems to be different and dependent on MysQL's list